Excel Formula wrapped with Curly braces {}

Aspose.Cells Product Family
1

Hi Team,

If we open the attached excel using Aspose.cells and save a copy, the formula is getting encapsulated with curly braces ({}). You can refer sheet 2, cells A1 to A10 .
In the attached zip file, there is a working copy of the c# project along with the sample Excel.

Aspose Version - 21.7 - Aspose Cells for .Net
Aspose{}.jpg (158.7 KB)
AsposeDemo.zip (6.4 MB)

Is there a fix for this to not append{} to the formulas?

Thanks

2

@Mveerabaghu,

Thanks for the template file and screenshot.

I opened your template XLSB file into MS Excel 2016 manually and found those curly braces are already there for the formulas, see the screenshot attached.
sc_shot1.png (67.6 KB)

3

Hi ,

the version which we are using does not have the braces initially and it automatically gets appended only when loaded with Aspose. Could you try this with latest versions of Excel?

I am using in ofc 365 subscription and verified in Excel online and Desktop. The file attached do not show the braces in this version.

4

@Mveerabaghu,

Thanks for providing further details.

Please notice, I am able to reproduce the issue as you mentioned by re-saving your template XLSB file via Aspose.Cells APIs. I found Excel Formula is wrapped with curly braces “{}” when opening/viewing the output file into Excel 365, it does not show curly braces when viewing the input file into it though. e.g.
Sample code:

string srcFileName = "e:\\test2\\FormulaIssue.xlsb";
string destFileName = "e:\\test2\\out1.xlsb";

using (Workbook workbook = new Workbook(srcFileName))
{
        workbook.Save(destFileName);
}

Please note, when viewing his input file into MS Excel 2007 and 2016), those curly braces are also shown for the formulas. Anyways, we have to investigate and will try to figure it out. I have logged a ticket with an id “CELLSNET-52133” for your issue. We will look into it soon.

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

5

@Mveerabaghu,

Please notice, your issue is due to the fact currently importing and exporting of dynamic array formulas for XLSB file format have not been supported yet. We need more time to implement this feature. Once we have new information available, we will update you.

6

Hi,
We have tried this by using the latest Aspose.Cells and the issue persists for .xlsb files. This issue is being reported to us by several clients and it has become a showstopper as the files are getting corrupted and manual correction is not an option. Could you let us know the time frame by when we can expect the fix so that we can resolve the issue from our side.

7

@Mveerabaghu,

We will try to finish this task (support to read/write dynamic array formula for XLSB file format) in this month or early next month. If you can avail paid support service, we may try to give your issue higher priority and try to get it supported earlier.

8

@Mveerabaghu,

This is to inform you that your issue (logged earlier as “CELLSNET-52133”) has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v22.11) which is scheduled in the first half of November, 2022. You will also be notified when the next version is released.

9

thanks for the update Amjad. will be waiting on the notification.

10

@Mveerabaghu,

You are welcome.

11

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