ROUND function

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
jacopeeman
Posts: 4
Joined: Fri Nov 03, 2006 10:46 am

ROUND function

Post 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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Post by larsa »

Hello


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


Lars Arvidsson
jacopeeman
Posts: 4
Joined: Fri Nov 03, 2006 10:46 am

Post 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
jacopeeman
Posts: 4
Joined: Fri Nov 03, 2006 10:46 am

Post by jacopeeman »

Test D7 project can be found here:
http://www.informaticamp.nl/textxls.rar
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Post 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
jacopeeman
Posts: 4
Joined: Fri Nov 03, 2006 10:46 am

Post by jacopeeman »

The latest version on your website still seems to be 3.00.02.
Post Reply