poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Murphy, Mark" <murphym...@metalexmfg.com>
Subject RE: POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files, viewed in MS Office 365 ProPlus
Date Thu, 08 Mar 2018 18:36:42 GMT
How did you sort the rows?

-----Original Message-----
From: Dagnon, William [mailto:William.Dagnon@wpsic.com] 
Sent: Thursday, March 08, 2018 8:53 AM
To: POI Users List <user@poi.apache.org>
Subject: RE: POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files,
viewed in MS Office 365 ProPlus

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 last 2 columns only have content for rows with this style
(w borders), but after sorting most of those columns just lose their borders: 7 rows keep
borders, 4 lose the last 2 columns' borders, 14 lose all borders after the sort.  Total 163
content rows.

The border dialog within Excel shows this isn't just a visual artifact: missing borders are
no longer set on those content rows.

The rows which keep their borders after the sort doesn't correlate with the original position
of rows with borders.

I don't know if this is an Excel-ism or how much POI affects it.

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 retention by others is strictly prohibited. If you are not
an intended recipient, please contact the sender and delete this e-mail, any attachments,
and all copies.
B�KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKCB��[��X��ܚX�KK[XZ[
�\�\�][��X��ܚX�P�K�\X�K�ܙ�B��܈Y][ۘ[��[X[��K[XZ[
�\�\�Z[�K�\X�K�ܙ�B

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Mime
View raw message