Clearing chart title on specifc xls causes xls to become corrupt

Aspose.Cells Product Family
,
1

Hi,

After setting the chart title on some xls files and saving them out we have noticed it can corrupt the file and cause Excel to error error when trying to open the modified file.

Repro code:

var format = FileFormatUtil.DetectFileFormat("BrokenChartDoc.xls");

	var asposeLoadOptions = new LoadOptions(format.LoadFormat)
	{
		LoadFilter = new LoadFilter(LoadDataFilterOptions.All)
	};

	using (var workbook = new Workbook("BrokenChartDoc.xls", asposeLoadOptions))
	{
		var chart = workbook.Worksheets[1].Charts[0];
		chart.Title.IsAutoText = false;
		chart.Title.Text = string.Empty;

		workbook.Save(@"BrokenChartDoc_TitleCleared.xls");
	}

Sample file (client document):
BrokenChartDoc.zip (564.6 KB)

Thanks!

2

@bvk,
We have logged the issue as “CELLSNET-47761” in our database for investigations. Once we will have some news for you, we will update you in this topic.

3

@bvk,

We have fixed the issue of corrupted file. But we find another issue that the max value of value axis is not the same as MS Excel. We have logged a separate ticket with an id “CELLSNET-47763” in our database for investigations. Once we figure it out as well, we will update you with a fix.

4

@Amjad_Sahi,

Thanks for the update! It’s good to hear the first issue has been fixed and the second issue is being looked into.

5

@bvk,

You are welcome.

6

@bvk,

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

Your issues are fixed in it.

Let us know your feedback.
Aspose.Cells20.11.10 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells20.11.10 For .Net4.0.Zip (5.5 MB)
Aspose.Cells20.11.10 For .NetStandard20.Zip (5.4 MB)

7

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