poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 48703] sum spanning multiple worksheets
Date Tue, 18 Dec 2012 19:58:36 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=48703

--- Comment #19 from Radoslav <rado.georgiev@ontario.ca> ---
After debugging this issues - the fix for the old binary format is not that
hard. The InternalWorkbook already contains these external references and they
are already created during leading. So the fix becomes the following:

1. Handle the parsing of the formula format (now it think it is a named range)
2. Correctly use the external indices (now it just uses the first sheet index)
3. Iterate over in the evaluation routine (now it only does over a single
sheet).
4. Fix for creating new formulae that span multiple sheets.

Unfortunately, this does not work with the ooxml as there are no such external
indices (points 2/4 and 3 as a result of the missing indices).

So far I have a produced almost working fix for the binary files but not for
the ooxml files. However, I am asking if anyone has any insights how to solve
this for the ooxml files format.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message