Issue with .xlsb excel format (getting "found unreadable content" and gettting aspose exception)

Aspose.Cells Product Family
21

Hi,


Thanks for providing us template files and details.

After an initial test, I observed the issue as you mentioned by opening and re-saving your template XLSB file, the PivotTable connections removed for the slicer shape when re-saving the XLSB file format as you pointed out.
e.g
Sample code:

string filePath = @“e:\test2\Financial_Statement_Input_Report_Withdata_original.xlsb”;


Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + “.out1.xlsb”);

I have logged an issue with an id “CELLSNET-43248” for your issue. We will look into your issue to figure it out soon.

Once we have any update on it, we will let you know here.

Thank you.
22

Hi,


any update on this issue? if possible can you please provide the ETA?


Thanks
23

Hi Chandra,


Thank you for writing back.

I am afraid, we haven’t yet received any updates regarding the last ticket logged for the problem of “PivotTable connections removed for the slicer when re-saving an XLSB file format”. We have recorded a note for the concerned development team member to share an estimated release schedule for the fix. As soon as we receive any updates in this regard, we will post here for your kind reference.
24

Hi,

Thanks for using Aspose.Cells.

It is to update you that

  • CELLSNET-43248 - PivotTable connections removed for the slicer when re-saving an XLSB file format

should be fixed in about December 31, 2014.

25

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue.

  • CELLSNET-43248 - PivotTable connections removed for the slicer when re-saving an XLSB file format

Please download and try the latest fix: Aspose.Cells for .NET v8.3.1.2 and let us know your feedback.

26

Hi Team,


This issue is raised for JAVA. But unfortunately this was routed to .net by the team

CELLSNET-43248 . Please provide the related JAVA fix.


Thanks
27

Hi Chandra,


We are sorry for the inconvenience caused.

Please try the equivalent revision of Aspose.Cells for Java 8.3.1.2 on your side, and feed us back with your results.

28

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

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

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
(2)
30

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

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

Hi Team,


we tried to importCSV command to import csv file to excel (XLSB+SLICERS) we are seeing same issue again with aspose cells 8.3.1.2 version

Please suggest.

try {
Workbook workbook = null;
try {
workbook = new Workbook(“E:\Current_Plan_Extract.xlsb”);
} catch (Exception e1) {
}
try {
workbook.save(“E:\Current_Plan_Extract.xlsb”);
} catch (Exception e1) {
}
TxtLoadOptions loadOptions = new TxtLoadOptions();
loadOptions.setSeparatorString("|");
workbook.getWorksheets().get(“Sheet1”).getCells()
.importCSV(
“E:\1dbeaf370ad151ea122c01fcf6926178_Sheet1.csv”, loadOptions,
0, 0);
workbook.save(“E:\sample.xlsb”, SaveFormat.XLSB);

} catch (Exception e) {
e.printStackTrace();
}
}
32

Hi Chandra,


Please follow your original thread on the same subject. We will continue the communication there regarding the recently shared scenario.