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

So you should start with the un-sorted spreadsheet, make a copy, then sort and save, then compare the two. You could also make an unsorted version manually with Excel, save a copy, sort it, and then compare all four to see how things got out of whack. On Thu, Mar 8, 2018 at 1:39 PM, Dagnon,

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

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

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

How did you sort the rows? -Original Message- From: Dagnon, William [mailto:william.dag...@wpsic.com] Sent: Thursday, March 08, 2018 8:53 AM To: POI Users List Subject: RE: POI 3.17 Problems with border and fill styles in generating XSSF/xlsx files, viewed in MS

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