Aspose.Cells -> Save workbook with slicers -> file corrupted

Aspose.Cells Product Family
,
1

I have a simple Excel that has 1 slicer. The slicer is connected to an Excel table (listObject).
If I open the workbook and save it, opening the same file in Excel gives an error “We found a problem with Excel…” (pic attached).

I am using Aspose.Cells 21.4 .NET (same behavior in Java).

slicer_error1.png (4.5 KB)

slicer_error2.png (12.2 KB)

SimpleSlicer.zip (536.1 KB)

There is the sample code.

static void DoSlicer()
{
	var dataDir = @"c:\temp\";

	using (var fstream = new FileStream(dataDir + "SimpleSlicer.xlsx", FileMode.Open))
	{
		// Instantiate a Workbook object that represents the existing Excel file
		var workbook = new Workbook(fstream);

		workbook.Save(dataDir + "1.xlsx");
	}
}
2

@eyalmolad,
We have observed the issue and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNET-48009 - File is corrupted after saving the workbook having Slicers

3

@eyalmolad,

Please try our latest version/fix: Aspose.Cells for .NET v21.4.6 (attached)

Aspose.Cells21.4.6 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.4.6 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.4.6 For .NetStandard20.Zip (5.5 MB)

Your issue should be fixed in it.
Let us know your feedback.

4

Great. I can confirm this works :slightly_smiling_face:
Would this be also included in the upcoming JAVA version?
Tnx

5

@eyalmolad,

Good to know that your issue is resolved by the new fix.

Yes, the fix will be included in the upcoming release (Aspose.Cells for Java v21.5). Hopefully the new release will be published before the end of next week or so.

6

The issues you have found earlier (filed as CELLSNET-48009) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao