Bug 54723 - [PATCH] Support for percentage in VALUE() function
Summary: [PATCH] Support for percentage in VALUE() function
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: 3.10-dev
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
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
View All Add an attachment (proposed patch, testcase, etc.)

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.