Problem with formula

[Mig_2000]

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

[larsa]

Hello

This is fixed in the latest update.

[Mig_2000]

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 version for correct this trouble It's a major BUG......


Thanks

[larsa]

Hello

The update is not released yet. Because of upgraded computers, we have not installed all delphi versions yet, so we can't rebuild all packages. But if someone urgently needs this upgrade, please send me an e-mail, and I can send back the source code. You can then rebuild the package yourself. This is of course only for registered users.

My e-mail: larsa {at} axolot {dot} com