Bug 54723 - [PATCH] Support for percentage in VALUE() function
[PATCH] Support for percentage in VALUE() function
Status: RESOLVED FIXED
Product: POI
Classification: Unclassified
Component: POI Overall
3.10-dev
PC All
: P2 normal (vote)
: ---
Assigned To: POI Developers List
:
Depends on:
Blocks:
  Show dependency tree
 
Reported: 2013-03-19 09:43 UTC by opensource
Modified: 2013-08-16 17:23 UTC (History)
0 users



Attachments
patched files (1.06 KB, application/gzip)
2013-03-19 09:43 UTC, opensource
Details

Note You need to log in before you can comment on or make changes to this bug.
Description opensource 2013-03-19 09:43:03 UTC
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
Comment 1 Cédric Walter 2013-08-16 17:23:52 UTC
Subversion: Committed revision 1514799.