Re: Fun with XSSF Fill Colors

2015-03-18 Thread Andreas Reichel
Dominik, thank you a lot, much appreciated. I will give it a try. For my own curiosity just a question please: My implicit work-around via fillID worked, so I wonder why there are two different ways for achieving the same even with inconsistent results. What I mean is: should the value of "applyFi

Re: Fun with XSSF Fill Colors

2015-03-18 Thread Dominik Stadler
Hi, I did a fix lately under bug 56295 - https://bz.apache.org/bugzilla/show_bug.cgi?id=56295, POI previously did use a default of "false" for the "applyfill" attribute, whereas Excel and LibreOffice seem to use "true" as default. As a result of this, POI did not read in background/foreground fill

Fun with XSSF Fill Colors

2015-03-03 Thread Andreas Reichel
Dear All. I built a java table component, which actually represents MS Excel files (as per HSSF or XSSF flavor). Unfortunately I spent hours for fiddeling around with simple cell background colors, as a simple XSSFCell xssfCell = (XSSFCell) cell; XSSFCellStyle xssfCellStyle = xssfCell.getCellStyl

Fun with XSSF Fill Colors

2015-02-21 Thread Andreas Reichel
Dear All. I built a java table component, which actually represents MS Excel files (as per HSSF or XSSF flavor). Unfortunately I spent hours for fiddeling around with simple cell background colors, as a simple XSSFCell xssfCell = (XSSFCell) cell; XSSFCellStyle xssfCellStyle = xssfCell.getCellStyl