You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/11/07 11:07:09 UTC
[Bug 55754] New: XSSFCell.setCellValue(double) and number formatting
https://issues.apache.org/bugzilla/show_bug.cgi?id=55754
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
Hy,
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){
...
_cell.setV(String.valueOf(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?
Thanks.
DoD
--
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
[Bug 55754] XSSFCell.setCellValue(double) and number formatting
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55754
dod <do...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |INVALID
--
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