Hello,
We have encountered a bug when attempting to set the view type to Page Layout view for XLSB files. The following code works as expected for XLS, XLSX and XLSM files, but produces no effect in the case of XLSB files:
public void saveInPageLayoutView(final String inFile, final String outFile) throws Exception {
final Workbook workbook = new Workbook(inFile);
for (Object sheetObject : workbook.getWorksheets()) {
final Worksheet sheet = (Worksheet) sheetObject;
sheet.setViewType(ViewType.PAGE_LAYOUT_VIEW);
}
workbook.save(outFile);
}
I have attached the input files we used for testing and the output files resulted in each case.
We would appreciate any help or workaround in order to have the processed XLSB file open in Page Layout View, like the other Excel types do.
Thank you,
Oana.