Reply to topic  [ 4 posts ] 
Formula calculation problem in XLS files (works in XLSX) 
Author Message

Joined: Fri Mar 15, 2013 11:45 am
Posts: 2
Reply with quote
Post Formula calculation problem in XLS files (works in XLSX)
Hi,

I'm using your library with visual basic dot-net and I'm setting one cell value to the following:

Code:
totalsRow.easy_getCell(3).setValue("=SUM(INDIRECT(ADDRESS(3,4)&"":""&ADDRESS(14,4)))")

This formula basically sums a few cells with decimal numbers in them.

When I save the file as XLSX the formula is correct and the value is calculated. However, when I save the file as XLS then the value of this field at opening is #VALUE! with the error "A value used in the formula is of the wrong data type." When I position my cursor in this field and press ENTER the formula properly calculates and everything is OK.

Since I'm working on some Excel export for customers where quite a few of columns will be calculated this way I can't expect them to go around the sheet pressing enter before it's usable for them in Office 2003 or earlier.

Is this a bug and is there a workaround for the issue?


Fri Mar 15, 2013 12:02 pm
Profile
Online

Joined: Wed Nov 07, 2007 4:42 am
Posts: 67
Reply with quote
Post Re: Formula calculation problem in XLS files (works in XLSX)
Hi! We could not reproduce your error using the latest version. What is the version of EasyXLS you are using?
Also, you are not using ExcelTable.easy_getCell() method correctly. It requires a second parameter.


Mon Mar 18, 2013 9:39 am
Profile WWW

Joined: Fri Mar 15, 2013 11:45 am
Posts: 2
Reply with quote
Post Re: Formula calculation problem in XLS files (works in XLSX)
oana wrote:
Hi! We could not reproduce your error using the latest version. What is the version of EasyXLS you are using?
Also, you are not using ExcelTable.easy_getCell() method correctly. It requires a second parameter.


totalsRow is of ExcelRow type and it's easy_getCell() function requires only one parameter - the index of the cell in a row. Still, no matter how I access the cell to set the value I have the same problem.

I have downloaded EasyXLS on Thursday (march 18th).


Mon Mar 18, 2013 10:19 am
Profile
Online

Joined: Wed Nov 07, 2007 4:42 am
Posts: 67
Reply with quote
Post Re: Formula calculation problem in XLS files (works in XLSX)
There is a problem if the formula is placed in a row that is not included in the range. This issue will be fixed in our next version which will be released by the end of April. If you need this fix earlier please contact us at support@easyxls.com and you will receive a patch.


Tue Mar 19, 2013 8:29 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 4 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.