Bug 63601 - Formulas remove needed single quote for advanced math.
Summary: Formulas remove needed single quote for advanced math.
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: unspecified
Hardware: Macintosh All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2019-07-24 00:22 UTC by ferrinkatz
Modified: 2019-07-24 00:26 UTC (History)
1 user (show)


Note You need to log in before you can comment on or make changes to this bug.
Description ferrinkatz 2019-07-24 00:22:08 UTC
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.
Comment 1 ferrinkatz 2019-07-24 00:26:25 UTC
The specific behavior is that it gives a #NAME? error until you click on the formula bar and press enter.