[ODFTOOLKIT-471] API crashes/fails to set the format string of a cell in scientific notation

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.6.2-incubating
• Component/s: simple api
• Assignee: Unassigned
• Reporter: Enrico Scantamburlo
• Created: 09/Feb/18 16:13
• Updated: 12/Feb/18 13:16

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 also posted a question [ here | https://stackoverflow.com/questions/48709473/formatting-cells-with-apache-odf-toolkit-simple-api-and-java ]