Hi every body,
I am getting a problem when i work with Microsoft.Inter op.Excel.dll
I tried to export and modify excel file with my conditional formatting for each cell of rows.
the function is :
Microsoft.Offic e.Interop.Excel .Range cellitem;
cellitem..Forma tConditions.Add (XlFormatCondit ionType.xlExpre ssion, XlFormatConditi onOperator.xlEq ual, "<my formular>", "");
i was working good...

Hi everyone,
I had a problem when I tried to modify Excel Sheet with Microsoft.Offic e.Interop.Excel l.dll. Everything seem ok until I changed the regions of computer to another(Germany ) which was different with English state.
when executing this line
cellitem.Format Conditions[1].Modify(XlFormatCondit ionType.xlExpre ssion, XlFormatConditi onOperator.xlEq ual, "=AND($X$" + position + ">2,MOD($X$ " + position...