[
https://issues.apache.org/jira/browse/COCOON-1958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jörg Heinicke updated COCOON-1958:
----------------------------------
Status: Continued (was: On Hold)
> Some Errors by serializing with the HSSFGenerator generated Excel-Sheet with
> style-informations (no Problems without)
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: COCOON-1958
> URL: https://issues.apache.org/jira/browse/COCOON-1958
> Project: Cocoon
> Issue Type: Bug
> Components: Blocks: POI
> Affects Versions: 2.1.9
> Reporter: Rolf Metternich
> Attachments: patch.txt
>
>
> For building an Excel-Sheet, I have to generate an Excel-Sheet by
> HSSFGenerator, manulpulate the values by a transformer and serialize as an
> Excel-Sheet.
> The first test are: generating an Excel-Sheet and serialize direct. Then, in
> the optimal case, the Excel-Sheet looks like the original. But there raised
> some error for which I made a workaround.
> First there was a NPE for fore- and background-colors by generation.
> I made a try-catch and set 'new HSSFColor.BLACK().getHexString()' for the
> foreground-color and 'new HSSFColor.WHITE().getHexString()' for the
> background when an error occures.
> This error occures only in cells, where the fore- and background-settings in
> Excel are automatic and none.
> patternColor (error on serializing) I set to 'attribute("PatternColor", new
> HSSFColor.WHITE().getHexString())';
> Bold (error on serializing) I set the attribute from
> 'Short.toString(font.getBoldweight())' to
> ((font.getBoldweight()>=font.BOLDWEIGHT_BOLD ) ? "1":"0").
> With this workaround, the generation-serialization of the Excel-Sheet work,
> but no images are imported, like a logo-jpg.
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
