Save to XLSB breaks formulas like =SUM(Table[Col])

Aspose.Cells Product Family
1

Save to XLSB breaks formulas like =SUM(Table[Col]).


var workbook = new Workbook(GetFullPath(“sample.xlsx”));
workbook.Save(GetFullPath(“result.xlsx”));
workbook.Save(GetFullPath(“result.xlsb”), SaveFormat.Xlsb);

In result.xlsx the formula looks ok while in result.xlsb Excel shows an error.
2

Hi Dmitry,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue and found resulting xlsb shows error in the formula value but resulting xlsx shows formula value correctly. We also tried the Workbook.CalculateFormula() method before saving but it did not fix the issue.

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

  • CELLSNET-44128 - Save to XLSB breaks formulas like =SUM(Table[Col])

3

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-44128 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4

Hi,

Thanks for your using Aspose.Cells.

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

5

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

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