koala icon indicating copy to clipboard operation
koala copied to clipboard

Sum across worksheets?

Open infinity77 opened this issue 8 years ago • 1 comments

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.

infinity77 avatar Nov 23 '17 07:11 infinity77

Is there any update on this issue? Any update would be really helpful. Thanks!

akash9182 avatar Feb 12 '21 00:02 akash9182