Error on CalculateSheet

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
Sandra
Posts: 2
Joined: Thu Nov 30, 2006 11:33 am
Location: Scotland

Error on CalculateSheet

Post by Sandra »

After upgrading to version 3.0 and applying the 3.00.06 update, I am still getting errors where the previous version had none.

Currently, having set up the formula etc, on the first CalculateSheet I get

'Calculate error on cell' which has the following formula

((-A1*A2)+A3+(A4*A5)+(A6*0*(1-A7))+(Erate*(A8+A9)))/A10

where Erate is named cell with another formula. It's quite a complex spreadsheet, but was working ok with version 2.0. If you need an example of the spreadsheet, let me know.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Post by larsa »

Hello

The problem was the unary minus in "-A1". An update will be posted within a day.


Lars Arvidsson
Post Reply