[ 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)