Hi,
I am using aspose cells for xsl to PDF.
Issue 1:- In the print preview of office, only 6 sheets are visible, but Aspose rendering all of the sheets.
Issue 2:- Even when I set visible as false for the sheets that are not selected, it renders all.
Issue 3: the select logic itself is giving incorrect answers for this input.
Sample Code:-
public static void main(String args[]) throws Exception {
loadLicense();
Workbook workbook = new Workbook(“C:\Users\avashish\Downloads\ECDCTS-5740\test.xls”);
com.aspose.cells.PdfSaveOptions options = new com.aspose.cells.PdfSaveOptions();
Worksheet worksheet = null;
System.out.println("total number of pages "+workbook.getWorksheets().getCount());
for (int i = 0; i < workbook.getWorksheets().getCount(); i++)
{
if (workbook.getWorksheets().get(i).isSelected()) {
System.out.println("Selected page number "+ i);
workbook.getWorksheets().get(i).setVisible(true);
System.out.println("visibility chage done for page number " + i);
}
workbook.getWorksheets().get(i).setVisible(true);
System.out.println("Not Selected this page "+i);
}
workbook.save(“C:\Users\avashish\Downloads\ECDCTS-5740\excel_.pdf”, options);
Attaching the input here.
Aspose.zip (2.1 MB)