https://issues.apache.org/bugzilla/show_bug.cgi?id=46537
Yegor Kozlov <yegor@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution| |WONTFIX
--- Comment #3 from Yegor Kozlov <yegor@dinom.ru> 2009-01-15 05:52:27 PST ---
The sheet contains a shared formula with a user-defined VBA function.
In short, shared formula is a template. Excel stores it in the first cell of a
group of cells, other cells just substitute column and row references as
appropriate.
In your example the shared formula is used as follows:
concatstring(D2:M2) //the template formula is in C2
concatstring(D3:M3) //C3 does not contain a formula, instead it takes the
shared formula from above and sets rownum=3
concatstring(D4:M4) //the same but for rownum=4
....
To process shared formulas POI needs to parse them, update cell area arguments
and convert the parsed expression back to String. POI can do that for formulas
with built-in Excel functions but not for custom VBA functions.
Regards,
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
|