[
https://issues.apache.org/jira/browse/ODFTOOLKIT-337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13452729#comment-13452729
]
Ian Cunningham commented on ODFTOOLKIT-337:
-------------------------------------------
Hi Guys,
I looked into the content.xml file and can see extra characters at the start of
the two rows with the problem.
The characters are none printable. I got rid of the problem by opening the
spreadsheet and in the edit of the cell place the cursor at the apparent start
of the text. Ctrl Shift Left - so select the text you can't see.
Then press delete.
The gray marks then disappeared. Save the file and all should be good.
Cheers,
Ian C
> Simple API generated .ods files have cells with extra character with gray
> background in the beginning of the text. Files are attached
> --------------------------------------------------------------------------------------------------------------------------------------
>
> Key: ODFTOOLKIT-337
> URL: https://issues.apache.org/jira/browse/ODFTOOLKIT-337
> Project: ODF Toolkit
> Issue Type: Bug
> Components: simple api
> Affects Versions: 0.7
> Environment: Windows 64 bit, Eclipse Helious, jdk6_30
> Reporter: Sherzod Muratov
> Attachments: Global_export_20120907175756.ods,
> Project_synthesis_20120907123758.ods, shot.jpg
>
>
> We use Simple API to generate extensive reports in spreadsheet for open
> source project www.sigmah.org. There is problem on generated files. Now, we
> are very dependent on this library. What would be your suggestion to solve it
> or would it be fix versions ahead? Please help.
> Details:
> 1. file: (http://www.sigmah.org/issues/file_download.php?file_id=61&type=bug)
> 2. Office application : Libre Calc from LibreOffice 3.5.4.2
> 3. version we use
> <dependency>
> <groupId>org.apache.odftoolkit</groupId>
> <artifactId>odfdom-java</artifactId>
> <version>0.8.8-incubating</version>
> </dependency>
> <dependency>
> <groupId>org.apache.odftoolkit</groupId>
> <artifactId>simple-odf</artifactId>
> <version>0.7-incubating</version>
> </dependency>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
