We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Chart's series legends showed- when worksheet copied

Hello.


I have founded, that if i will hide series in chart’s legend, that when i will copy worksheet to another workbook, legend appear agains.

@Test
public void copyWorksheetTest() throws Exception {
Workbook source = new Workbook(“D://chart.xlsx”);
Workbook target = new Workbook();

for (int iCount = 0; iCount < source.getWorksheets().getCount(); iCount++) {
//Формируем имя листа, если такой лист уже есть, то переименовываем
String newSheetName = source.getWorksheets().get(iCount).getName();
target.getWorksheets().add(newSheetName);
}

for (int iCount = 0; iCount < source.getWorksheets().getCount(); iCount++) {
Worksheet sourceWs = source.getWorksheets().get(iCount);
Worksheet targetWs = target.getWorksheets().get(sourceWs.getName());
try {
targetWs.copy(sourceWs);
targetWs.getPageSetup().setPrintArea(sourceWs.getPageSetup().getPrintArea());
} catch (Exception e) {
Assert.assertNull(e);
}
}

target.save(“D://out.xlsx”);
}

Best regards. Alexey

Hi Alexey,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing your code with your source Excel file using the latest version: Aspose.Cells
for Java v8.2.1.3
. Hidden series inside the legend appears again after copying worksheet.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-41038.

I have attached the output Excel file generated by the following code for a reference.

Java


Workbook source = new Workbook(“chart.xlsx”);

Workbook target = new Workbook();


for (int iCount = 0; iCount < source.getWorksheets().getCount(); iCount++) {

//Формируем имя листа, если такой лист уже есть, то переименовываем

String newSheetName = source.getWorksheets().get(iCount).getName();

target.getWorksheets().add(newSheetName);

}


for (int iCount = 0; iCount < source.getWorksheets().getCount(); iCount++) {

Worksheet sourceWs = source.getWorksheets().get(iCount);

Worksheet targetWs = target.getWorksheets().get(sourceWs.getName());

try {

targetWs.copy(sourceWs);

targetWs.getPageSetup().setPrintArea(sourceWs.getPageSetup().getPrintArea());

} catch (Exception e) {

// Assert.assertNull(e);

}

}


target.save(“output1.xlsx”);

Hellow guys. There is exists some updates about this issue?

Hi Alexey,

Thanks for your posting and using Aspose.Cells.

We are afraid, there is no update for you. Please spare us some more time a week or two. Hopefully, your issue will be resolved in this time span. Once, there is some fix or other update for you, we will let you know asap.

Hi Alexey,

Thanks for using Aspose.Cells.

We have fixed
this issue now. We will provide you a fix in couple of days after
incorporating other enhancements and fixes and conducting some extensive
testing. Once, it is available for you, we will let you know asap by
posting in this thread.

The issues you have found earlier (filed as CELLSJAVA-41038) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.