[
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"
{{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"
}}
I halso 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"
{{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"}}
I halso posted a qalsoon [ 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"
> {{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"
> }}
> I halso 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)
