POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files, viewed in MS Office 365 ProPlus

2018-03-02 Thread Dagnon, William
Hello, long time fan, but long time since I last used POI. I've downloaded POI 3.17 and I'm generating XLSX files from Groovy within Eclipse IDE backed by Java 8, and started at: https://poi.apache.org/spreadsheet/quick-guide.html#FillsAndFrills Though looked at the API when there were problems a

Re: POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files, viewed in MS Office 365 ProPlus

2018-03-02 Thread Mark Murphy
Can you do what you want in Excel? Here is what it looks like when I add borders in Excel. The borders are re there though. If I look in Print Preview, it looks like this: So maybe what you are seeing is just the way Excel renders the borders you have created. On Fri, Mar 2, 2018 at 10:22 A

RE: POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files, viewed in MS Office 365 ProPlus

2018-03-02 Thread Dagnon, William
1. after more experimenting: Nope, Excel skips displaying any Medium-thickness borders on Column “A”, but will at least display the others. Which is idiotic and negates any WYSIWYG of Excel. 2. background fill: yes, that works fine through Excel. Except I am generating files and cannot go t

Re: POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files, viewed in MS Office 365 ProPlus

2018-03-02 Thread Mark Murphy
Ah yes, Fills. This is a bit tricky, but there are really three color levels in a cell. These are the Color (Font color), Foreground color (Fill color), Background color (Fill color). The Fill provides what we normally call the cell background, but the color terminology, Foreground Color / Backgrou