[jira] Updated: (COCOON-1958) Some Errors by serializing with the HSSFGenerator generated Excel-Sheet with style-informations (no Problems without)

["Antonio Gallardo (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/COCOON-1958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Antonio Gallardo updated COCOON-1958:
-------------------------------------

    Status: On Hold  (was: Open)

Would you provide a patch? or the lines numbers you are refering for? Many thanks in advance.

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