[Bug 62651] setting setDisplayGridlines(false) on the first sheet causes all sheets to hide their gridlines

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=62651

--- Comment #1 from diarmuid <diarmuidke...@gmail.com> ---
Here's a Gist to reproduce the issue - resulting files attached 

package go.figure;

import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;

public class PoiBug62651 {

        public static void caseWithExpectedBehaviour(){
                try (SXSSFWorkbook wb = new SXSSFWorkbook(1)) {
                        wb.setCompressTempFiles(true);
                        wb.createSheet("1st").setDisplayGridlines(true);
                        wb.createSheet("2nd").setDisplayGridlines(false);
                        wb.createSheet("3rd").setDisplayGridlines(true);
                        wb.createSheet("4th").setDisplayGridlines(false);
                        wb.createSheet("5th").setDisplayGridlines(true);
                        try (FileOutputStream out = new
FileOutputStream("PoiBug62651-" + "correct-behaviour-selected-sheets-hidden" +
".xlsx")) {
                                wb.write(out);
                        } finally {
                                wb.dispose();
                        }
                } catch (IOException e) {
                        e.printStackTrace();
                }
        }

        public static void caseWithUnexpectedBehaviour(){
                try (SXSSFWorkbook wb = new SXSSFWorkbook(1)) {
                        wb.setCompressTempFiles(true);
                        wb.createSheet("1st").setDisplayGridlines(false);
                        wb.createSheet("2nd").setDisplayGridlines(false);
                        wb.createSheet("3rd").setDisplayGridlines(true);
                        wb.createSheet("4th").setDisplayGridlines(false);
                        wb.createSheet("5th").setDisplayGridlines(true);
                        try (FileOutputStream out = new
FileOutputStream("PoiBug62651-" + "all-5-sheets-incorrectly-hide-grids" +
".xlsx")) {
                                wb.write(out);
                        } finally {
                                wb.dispose();
                        }
                } catch (IOException e) {
                        e.printStackTrace();
                }
        }

        public static void main(String[] args) {
                caseWithExpectedBehaviour();
                caseWithUnexpectedBehaviour();
        }

}


jdk version information :-

/usr/lib/jvm/java-8-openjdk-amd64/bin/java -version 
openjdk version "1.8.0_181"
OpenJDK Runtime Environment (build 1.8.0_181-8u181-b13-0ubuntu0.16.04.1-b13)
OpenJDK 64-Bit Server VM (build 25.181-b13, mixed mode)

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org