[
https://issues.apache.org/jira/browse/ODFTOOLKIT-471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Enrico Scantamburlo updated ODFTOOLKIT-471:
-------------------------------------------
Description:
I need to create a ods document using the Apache ODF Toolking and to format the
content of its cells.
I was able to set a format for dates and simple numbers, but for some reason
when I try to format with scientific notation it does not work. It fails to
parse the string or it wraps the E00 into "E00"
{code:java}
Row numRow = rows.get(1);
numRow.getCellByIndex(0).setDoubleValue(9.12345678);
numRow.getCellByIndex(0).setFormatString("0.000"); // works
//numRow.getCellByIndex(0).setFormatString("0.00E+00"); // crashes
//numRow.getCellByIndex(0).setFormatString("0.00E00"); // does not work, it
becomes 0.00"E00"
{code}
I also posted a question [ here |
[https://stackoverflow.com/questions/48709473/formatting-cells-with-apache-odf-toolkit-simple-api-and-java]
]
was:
I need to create a ods document using the Apache ODF Toolking and to format the
content of its cells.
I was able to set a format for dates and simple numbers, but for some reason
when I try to format with scientific notation it does not work. It fails to
parse the string or it wraps the E00 into "E00"
{code:java}
Row numRow = rows.get(1);
numRow.getCellByIndex(0).setDoubleValue(9.12345678);
numRow.getCellByIndex(0).setFormatString("0.000"); // works
//numRow.getCellByIndex(0).setFormatString("0.00E+00"); // crashes
numRow.getCellByIndex(0).setFormatString("0.00E00"); // does not work, it
becomes 0.00"E00"
{code}
I also posted a question [ here |
[https://stackoverflow.com/questions/48709473/formatting-cells-with-apache-odf-toolkit-simple-api-and-java]
]
> API crashes/fails to set the format string of a cell in scientific notation
> ---------------------------------------------------------------------------
>
> Key: ODFTOOLKIT-471
> URL: https://issues.apache.org/jira/browse/ODFTOOLKIT-471
> Project: ODF Toolkit
> Issue Type: Bug
> Components: simple api
> Affects Versions: 0.6.2-incubating
> Reporter: Enrico Scantamburlo
> Priority: Major
>
> I need to create a ods document using the Apache ODF Toolking and to format
> the content of its cells.
> I was able to set a format for dates and simple numbers, but for some reason
> when I try to format with scientific notation it does not work. It fails to
> parse the string or it wraps the E00 into "E00"
> {code:java}
> Row numRow = rows.get(1);
> numRow.getCellByIndex(0).setDoubleValue(9.12345678);
> numRow.getCellByIndex(0).setFormatString("0.000"); // works
> //numRow.getCellByIndex(0).setFormatString("0.00E+00"); // crashes
> //numRow.getCellByIndex(0).setFormatString("0.00E00"); // does not work, it
> becomes 0.00"E00"
> {code}
> I also posted a question [ here |
> [https://stackoverflow.com/questions/48709473/formatting-cells-with-apache-odf-toolkit-simple-api-and-java]
> ]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
