koala
koala copied to clipboard
Sum across worksheets?
Hi,
I am handling yet another Excel spreadsheet and I naively thought I could use koala to do some calculations with it. However, koala complains (rightly I believe) with this error:
Pb with ref Sheet Start:Sheet End!N126 Invalid address format SHEET START
This is because the funny Excel workbook uses the feature of "summing across sheets", like this:
=SUM(Sheet1:Sheet3!A1)
Is there any way to support this feature, or something else I could try to make koala work on this spreadsheet?
Thank you.
Andrea.
Is there any update on this issue? Any update would be really helpful. Thanks!