poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55754] New: XSSFCell.setCellValue(double) and number formatting
Date Thu, 07 Nov 2013 10:07:09 GMT

            Bug ID: 55754
           Summary: XSSFCell.setCellValue(double) and number formatting
           Product: POI
           Version: 3.10-dev
          Hardware: PC
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: dodane49@hotmail.com


I am trying to complete XLS or XLSM files.
The number (double) aren't well-formed in XLSM, because decimal separator is a
dot instead of comma for my system. Formulas which are using these number cells
can't run.
With XLS, i don't have any problem.
The cell format defined with Excel is a numeric with 4 decimals.

In source code of POI (i use 3.10 beta 2):
XSSFCell.setCellValue(double value){

For example, with value=1.0015 => String.valueOf(value) = "1.0015"

In any case, my source code:

double value = Double.parseDouble("1.0015");
cell.setCellValue(value); //xls => OK (cell completed with : 1,0015 ) , xlsm =>
KO (cell completed with : 1.0015)

Is there a bug?
Why with XLS Files, i don't have problem?


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

View raw message