Axolot Data

I received an error message with this formula IF((Q10=0),0,(Q10*E10)-L10)

The error is Unknown Name Q10


If i use IF(sum(Q10=0),0,(Q10*E10)-L10) or IF((0+Q10=0),0,(Q10*E10)-L10) i don't received this error.

P.S The formula work fine in version 2.

I have a version 4.00.17

Thanks

Where it is the latest update ? On which version do you correct this trouble ? I have the version 4.00.15 and i don't find the version 4.00.16 and when i install the new executable on you ftp i install the version 4.00.15. A lot of person in the forum have the same trouble. When you post a new versi...

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 vers...

Hi, I have an error when i tried to set a column width in my excel file with xlsreadwrite version 4.00.15 I put this code XLS.Sheet[0].Columns[0].Width := 12; and i have an access violation in the unit Columns4.pas on the Fwidth := Value; in this procedure procedure TXLSColumn.SetWidth(Value: intege...