Cloning Style problem

[Miguel Gomez <mi...@docpath.com>]

Hi everybody,

I want to clone cell styles between workbooks, but I have two problems:

- In Excel 2003, it works, but there are problems with the colors, they
are similar but not the same.

- In Excel 2007, it doesn't work as when I open the workbook the bug
50956 still appears. When I open a generated xlsx Excel shows a message
about corrupted styles.xml,
  but I am using POI 3.8 beta 3, which should have the bug already
corrected according to the change log: "50956 - Correct XSSF cell style
cloning between workbooks(poi-developers)".

Thanks and regards.
(sorry about my English)

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Cloning Style problem

[Nick Burch <ni...@alfresco.com>]

On Tue, 7 Jun 2011, Miguel Gomez wrote:
> - In Excel 2003, it works, but there are problems with the colors, they 
> are similar but not the same.

If you follow these steps, how far do you get before it breaks?
* Set colour in poi
* Clone style to new workbook
* Check colour on style in new workbook
* Save, and re-load in POI
* Check colour on style in new workbook
* Open in excel

> - In Excel 2007, it doesn't work as when I open the workbook the bug 
> 50956 still appears. When I open a generated xlsx Excel shows a message 
> about corrupted styles.xml, but I am using POI 3.8 beta 3, which should 
> have the bug already corrected according to the change log: "50956 - 
> Correct XSSF cell style cloning between workbooks(poi-developers)".

Can you try looking at the xml, and see if there's anything obviously 
wrong with it? Can POI read it properly? Do simple styles work and complex 
ones fail, or all?

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org