Bug 49026

Summary: [PATCH] Excel TEXT function evaluation implementation
Product: POI Reporter: Steve Wolke <smwolke>
Component: POI OverallAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.6-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Attachments: proposed patch for TEXT function
Test Case for the TEXT function patch [tar.bz2 FILE]

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