| Summary: | [PATCH] Support for percentage in VALUE() function | ||
|---|---|---|---|
| Product: | POI | Reporter: | opensource |
| Component: | POI Overall | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | P2 | ||
| Version: | 3.10-dev | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | All | ||
| Attachments: | patched files | ||
Subversion: Committed revision 1514799. |
Created attachment 30078 [details] patched files Getting value of a Text containing a percentage is not supported in Apache POI. What this patch is adding support for VALUE("30%") or VALUE("30 %") as excel support this * modified org.apache.poi.ss.formula.functions.Value * modified unit tests org.apache.poi.ss.formula.functions.TestValue