Bug 49026 - [PATCH] Excel TEXT function evaluation implementation
Summary: [PATCH] Excel TEXT function evaluation implementation
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: POI Overall (show other bugs)
Version: 3.6-FINAL
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-30 20:09 UTC by Steve Wolke
Modified: 2010-04-24 13:18 UTC (History)
0 users


Attachments
proposed patch for TEXT function (5.26 KB, patch)
2010-03-30 20:09 UTC, Steve Wolke 		Details | Diff
Test Case for the TEXT function patch [tar.bz2 FILE] (1.52 KB, application/octet-stream)
2010-03-30 20:10 UTC, Steve Wolke 		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 Steve Wolke 2010-03-30 20:09:08 UTC 
Patch to add TEXT function support.  The support is not 100% compatible with the Excel function because the decimal formatting relies on the DecimalFormat class and the date formatting relies on SimpleDateFormat.  And the formatting strings have a little variance to their Excel counterparts.
Comment 1 Steve Wolke 2010-03-30 20:09:59 UTC 
Created attachment 25217 [details]
proposed patch for TEXT function
Comment 2 Steve Wolke 2010-03-30 20:10:51 UTC 
Created attachment 25218 [details]
Test Case for the TEXT function patch [tar.bz2 FILE]
Comment 3 Yegor Kozlov 2010-04-24 13:18:13 UTC 
applied in r937652

Regards,
Yegor