poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 61638] New: Incorrect result from DataFormatter.formatCellValue for format 60#########
Date Fri, 20 Oct 2017 08:15:20 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=61638

            Bug ID: 61638
           Summary: Incorrect result from DataFormatter.formatCellValue
                    for format 60#########
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: wcchor89@gmail.com
  Target Milestone: ---

Created attachment 35444
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35444&action=edit
Screenshot of data within the excel file

Greetings, first of all I shall say thank you to show my appreciation for this
great product, it really helped a lot on projects I've involved throughout my
career.

However recently I've found an issue with the result returned from function
DataFormatter.formatCellValue(Cell cell).

I have this excel sheet filled with "166609647" in one of the cell, and I
applied format "60#########" on it. "60166609647" appears on my Excel program
afterwards, as screenshot attached.

Using below code I'm trying to get what's appeared on the screen:

Cell cell = getTheCell();
DataFormatter df = new DataFormatter();
String displayValue = df.formatCellValue(cell);

What I captured in displayValue is only "166609647", the leading "60" is
nowhere to be found.

If I change the format to "60000000000", the code above works fine, I can get
"60166609647".

I'm already using latest library 3.17 and this issue still occurs.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message