EasyXLS http://forum.easyxls.com/ 

Lots of formulas on large spreadsheets http://forum.easyxls.com/viewtopic.php?f=5&t=722 
Page 1 of 1 
Author:  usefulidiot [ Mon Aug 25, 2008 6:56 am ] 
Post subject:  Lots of formulas on large spreadsheets 
I just started testing the demo version of EasyXLS. My goal is to read formula results from a very large (about 10 MB) XLS spreadsheet, then modify the formula input values and recalculate and read the result again. However, I managed to stop the OutOfMemoryExceptions, but still, working with currentSheet.easy_computeFormulas(xls, false) takes a disturbingly long time to process (510 min or more). Is there any possibilty to calculate results only of single cells? I need one cell only in my test, but its formula needs to walk over 8000 lines of data in another sheet... 
Author:  daniela [ Wed Sep 10, 2008 2:31 am ] 
Post subject:  
See this post: http://forum.easyxls.com/viewtopic.php?t=130 
Page 1 of 1  All times are UTC  4 hours 
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ 