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

["Svante Schubert (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ODFTOOLKIT-471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16360566#comment-16360566 ] 

Svante Schubert commented on ODFTOOLKIT-471:
--------------------------------------------

IBM has created the Simple API, but abandoned support, so if you desire a fix you might need it to do it yourself. That's the thing about open source, it is free, but the service is not necessarily included. You know the slogan: Improve the parts, that are itching you. :)

 

1) You get the latest sources. See http://incubator.apache.org/odftoolkit/source.html

 

2) There will be the need for a regression test, so best starting taking a look at the existing ones. If you search for 'setFormatString' in 

<YOUR_ODFTOOLKIT_DIR>/simple/src/test

You find a lot of occurrences in this class:

<YOUR_ODFTOOLKIT_DIR>/simple/src/test/java/org/odftoolkit/simple/table/TableCellTest.java 

If you add your crash & "don't work" scenarios, you should be able to reproduce the problem.

 

If there are any further questions, do not hesitate to ask.

Good Luck,

Svante

 

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