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 re-calculate 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 (5-10 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...