Problem with formula
Posted: Wed Feb 04, 2009 8:00 pm
Hi i put this in my code (it is a easy formula to test the error)
XLS.Sheets[sheets].Asformula[59,Line] := 'IF(1=0;1;0)';
Xls.Sheets[sheets].Cell[59,Line].FontSize := 8;
XLS.Sheets[sheets].cell[59,Line].NumberFormat := '0.00';
In the version 2 this code work fine and i return the value 1 but in version 4.00.15 i received in error when i open my excel file.
I have a french version of Office 2003, i translate the message "file error : lost data" and when i watch the column 59 i see "=#N/A" for the formula I should see "=IF (1=0; 1; 0)"
What is the trouble ?
I see another message with a similar trouble if it is the same trouble when you post the next update ?
Thanks
XLS.Sheets[sheets].Asformula[59,Line] := 'IF(1=0;1;0)';
Xls.Sheets[sheets].Cell[59,Line].FontSize := 8;
XLS.Sheets[sheets].cell[59,Line].NumberFormat := '0.00';
In the version 2 this code work fine and i return the value 1 but in version 4.00.15 i received in error when i open my excel file.
I have a french version of Office 2003, i translate the message "file error : lost data" and when i watch the column 59 i see "=#N/A" for the formula I should see "=IF (1=0; 1; 0)"
What is the trouble ?
I see another message with a similar trouble if it is the same trouble when you post the next update ?
Thanks