poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 46537] Cannot get cell formula.
Date Thu, 15 Jan 2009 13:52:30 GMT
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


Mime
View raw message