Page 1 of 1

Problem with formula

Posted: Wed Feb 04, 2009 8:00 pm
by 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

Re: Problem with formula

Posted: Tue Feb 10, 2009 4:05 pm
by larsa
Hello

This is fixed in the latest update.

Re: Problem with formula

Posted: Thu Feb 12, 2009 6:21 pm
by 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

Re: Problem with formula

Posted: Fri Feb 13, 2009 8:18 am
by 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