IFS formulas are wrapped with curly braces after saving with ASPOSE, why?

Hi There,

Recently, We came across situation where ASPOSE is modifying the IFS, INDEX formula and probably many other to have them wrapped with curly braces.
SourceIFS.png (26.8 KB)
TargetIFS.png (26.9 KB)

We have tried with latest ASPOSE Cells library and the issue still exist,

Cheers, Bhavin

@james.simpson,
Please share your sample file and runnable console application with us for our testing. We will reproduce the problem and provide our feedback after analysis.

Hi @ahsaniqbalsidiqui ,

Please find attached sample application with sample file etc
IFSFormulaWrapped.zip (5.6 MB)

Cheers, Bhavin

@james.simpson,
Could you please share version of your MS Excel. We will analyze it and provide our feedback accordingly.

Issue can be observed in the following version of excel

  • Office 365 version 16.0.12624.20424
  • Excel 2016 Version 1611 (Build 7571.2075)

@james.simpsonm
I have checked your Source.xlsx file in Excel Microsoft Office 365 ProPlus. Your source formula in the entire column contains this bracket that is why it is there in the target workbook as well. Please check it in MS excel and share the feedback.

Capture.PNG (23.4 KB)

@ahsaniqbalsidiqui Please find attached gif

SourceIFSCurlyBraces.gif (999.2 KB)

@james.simpson,
I have checked with Office 2016 too but still there are curly braces in source file. Could you please try in some other system and let us know your feedback.

@ahsaniqbalsidiqui

Can you please elaborate on what other system should I try on?

In my opinion, You(ASPOSE) should be able to tell the difference between the “Pre” and “Post” file and figure out what changed (in detail, open xml/vml) in the file after excel file has gone thru the sample application that I gave you.

@james.simpson,
We have managed to reproduce the issue and have logged it as “CELLSNET-47309” in our database. We have investigated a bit and found that cell “L2” refers to spreadsheetml metadata and the API does not support parsing metadata now. If we manually add relation into the generated file, curly braces are removed. So we will check the relations between cell and sheetml metadata which will take some time and issue may not be fixed soon. Once, we will have some news for you, we will update you in this topic.

@james.simpson,

We evaluated your issue further.
These are so called “dynamic array” in the upgraded formula language of Excel. I am afraid, currently Aspose.Cells does not support this kind of representation for those formulas. For the same formula, if you could create it in some older Excel versions(pre-dynamic array Excel), you will also see the curly braces too and MS Office declares that those formulas will continue to calculate the same way they always have. So, we think it will not cause trouble for users with those formulas.

Thank you very much @Amjad_Sahi,

We have been using ASPOSE for very long, since company inception literally. I understand that Microsoft has started releasing newer excel release more often than before year 2018.

Major part of our software platform relies on excel manipulation. We have occasionally been challenged by our clients to support newer excel functions, but we are partially blocked because ASPOSE’s limited or no support for newer functions.

I also understand that ASPOSE would have other priorities that would take precedent over catching up with newer microsoft excel functions.

With the priorities in mind, Do you have some sort of road map for ASPOSE.Cells OR strategy around catching up to newer excel version?

We ask this question because ASPOSE is important to us,

Cheers, Bhavin

@james.simpson,

Thanks for sharing your concerns.

We will evaluate and check if we could devise some way around to cope with it.

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

@james.simpson,
Currently we plan to support this feature in the third or fourth quarter of this year.

@ahsaniqbalsidiqui

Thank you for your reply,

Going forward, Do I assume that ASPOSE would continue innovation and constantly strive to catch up as and when possible with newer excel functions??

Cheers, Bhavin

@james.simpson,
You are right, we will continue to enhance and improve the APIs with latest features.

@solvexia,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

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