You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2018/08/24 10:15:06 UTC
[Bug 62651] setting setDisplayGridlines(false) on the first sheet
causes all sheets to hide their gridlines
https://bz.apache.org/bugzilla/show_bug.cgi?id=62651
--- Comment #1 from diarmuid <di...@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org