https://bz.apache.org/bugzilla/show_bug.cgi?id=63601
Bug ID: 63601
Summary: Formulas remove needed single quote for advanced math.
Product: POI
Version: unspecified
Hardware: Macintosh
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: ferrink...@ferrinkatz.com
Target Milestone: ---
When i use cell.setCellFormula("PERCENTILE.EXC(\'AllData\'!J1:J3946,.25)"), The
library strips of the single quotes in the formula returning a formula like
"=PERCENTILE.EXC(AllData!J1:J3946,.25)".
This works fine for more basic formulas like SUM and AVERAGE But that
particular formula does not work without those single quotes in excel 16.27 for
mac.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
