Excel -> select all rows -> sort -> select 2nd column, ascending
CONFIDENTIALITY NOTICE: This e-mail, including any attachments, may contain
confidential, privileged and/or proprietary information which is solely for the
use of the intended recipient(s). Any review, use, disclosure, or
As a follow-on: I created a cell style with a bottom and right border plus a
background, then applied it to selective rows. It looks good when I generate
the file.
If I sort the rows, the background color remains for the content rows - but the
border style randomly disappears. In fact the
Perfect, thank you for the explanation and details - it worked!
There is still the oddity about:
> row.setRowStyle(codeFill)
Only affecting cells AFTER the last one I created in the row. I've been using
a limited work-around.
Lastly: are row and cell styles ever
s like this:
[cid:ii_jea7dai41_161e7b9a118b7e5a]
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 AM, Dagnon, William
<william.dag...@wpsic.com<mailto:william.dag...@wpsic.com>> wrote:
Hello, long time fan, but long time since I la
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
