https://bz.apache.org/bugzilla/show_bug.cgi?id=58452
Bug ID: 58452
Summary: Copy cell formulas containing unregistered Ptgs
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: enhancement
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Carried over from poi-user mailing list
Original post:
http://mail-archives.apache.org/mod_mbox/poi-user/201509.mbox/%3CCAM%2BTppJHZRk4QfZ%3DJ8WF0zw5%2B%2BrHi-XOnXAXTNezHsgXtr2gPQ%40mail.gmail.com%3E
Nick's response:
http://mail-archives.apache.org/mod_mbox/poi-user/201509.mbox/%3Calpine.DEB.2.02.1509221216360.18373%40urchin.earth.li%3E
If a formula contains one or more unregistered UDF's, a FormulaParseException
is normally thrown.
I need a way to allow the formula to be parsed, using placeholder Ptgs for the
unregistered functions. With this array of Ptgs, I can manipulate registered
Ptgs as needed, then recreate the cell formula and write it to the cell.
Formulas containing unregistered functions will not be eligible for computation
in the calculation chain.
Solution will be targeted for XSSFWorkbooks, but it's possible a fix may also
be available for HSSFWorkbooks if the source cell that the formula is being
copied from was created by Excel (that is, Excel has validated the formula and
the Ptg is saved in the BIFF file).
>From Nick via poi-user mailing list
> [Add formula parsing option] to skip / unchange unknown function names? (It
> might actually be easier to do the copy in the Ptg space, rather than
> Formula text space, as with the ptgs you could check for non-absolute
> references and update just them. That'd mean you'd need a ways to flag to
> skip these functions / leave them unchanged or something)
I'll hack away at this to see what I can come up with.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
