https://bz.apache.org/bugzilla/show_bug.cgi?id=69636
Bug ID: 69636
Summary: Document how to register user-defined or external
functions
Product: POI
Version: 5.4.0-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
I appreciate all the hard work you guys have put into this library.
One pain point I ran into is referencing external VBA functions that are
already present in the xlsm file. If I invoke:
cell.setCellFormula("RoundHalfEven(123.34, 12)");
I get this warning:
12:00:55.218 [main] WARN o.a.poi.ss.formula.FormulaParser.function() -
FormulaParser.function: Name 'RoundHalfEven' is completely unknown in the
current workbook.
I spent an hour trying to find a way to register the external function but
found nothing. I saw XSSFWorkbook.getUDFFinder() but:
1. It is package-private.
2. Its documentation is broken. It literally reads:
* To set / evaluate custom functions you need to register them as follows:
*
*
*
* </p>
Can you please add documentation, both to the website and to the Javadoc,
pointing users to the sample code over at
https://svn.apache.org/repos/asf/poi/trunk/poi-examples/src/main/java/org/apache/poi/examples/ss/formula/?
I only discovered it because
https://bz.apache.org/bugzilla/show_bug.cgi?id=54625#c2 showed up as a possible
duplicate when filing this bug report :) Let's make sure that future users have
an easier time.
--
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]
