https://issues.apache.org/bugzilla/show_bug.cgi?id=46938
Karl Eilebrecht <karl.eilebre...@freenet.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Version|3.2-FINAL |3.5-FINAL Resolution|WONTFIX | --- Comment #9 from Karl Eilebrecht <karl.eilebre...@freenet.de> 2009-11-01 02:51:05 UTC --- Hi, I ran into the same problem and must agree with the previous speakers, this "bug" is an unsupported behaviour of Excel 2007, not an error of POI. However, the situation is extremely disappointing for me, since I'll have to support Excel 2007 for editing templates - and colors are very important for some customers. After a weekend of tracing the serialization of records and trial+error I tried the following hack: using POI 3.5-FINAL Workbook.class, line 812 public ExtendedFormatRecord createCellXF() { int insertPos = records.getXfpos() + 1; if (insertPos < records.size()) { while (records.get(insertPos) instanceof UnknownRecord) { insertPos++; if (insertPos == records.size()) { break; } } } records.add(insertPos, xf); records.setXfpos( insertPos ); numxfs++; return xf; } Obviously this is rather a hack than a solution. It seems(!) to help. And if so, this workaround could be useful for many people using POI. I'd be pleased if some of the gurus could check if this "happy reordering" is in conflict with any known rule of the excel format and thus may be discouraged. Especially testing with different excel versions (I only have 2007) would be important. Thanks! Regards. Karl -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org