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