Page 1 of 1

ROUND function

Posted: Fri Nov 03, 2006 10:49 am
by jacopeeman
XLSReadWriteII 3.0 finds 3 arguments for the function round in formula:
Round(B1;0)+Round(D1;0)

Error in formula Round(B1;0)+Round(D1;0)
Wrong number of arguments for function ROUND.

Posted: Mon Nov 06, 2006 6:54 am
by larsa
Hello


I can't repeat this. Do you have the latest update installed?


Lars Arvidsson

Posted: Mon Nov 06, 2006 3:13 pm
by jacopeeman
Hello Lars,

My version is 3.00.02, so should be allright:

Code:
xls.Sheet[0].AsFormula[5,0] := 'Round(B1;0)+Round(D1;0)';

Gives:

Error in ormula Round(B1;0)+Round(D1;0)
Wrong number of arguments for function Round

Posted: Mon Nov 06, 2006 3:23 pm
by jacopeeman
Test D7 project can be found here:
http://www.informaticamp.nl/textxls.rar

Posted: Tue Nov 07, 2006 12:08 am
by larsa
Hello

The latest version is 3.00.04, but because of a system crash on our web host, our site was not restored to the latest state (no fresh backups). This resulted in that the version history not is up to date, and I forgot to change it...

Please download the latest update.


Lars Arvidsson

Posted: Tue Nov 07, 2006 7:38 am
by jacopeeman
The latest version on your website still seems to be 3.00.02.