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

Reply via email to