bab-concat.zip (8.5 KB)
We have a situation where we have a spreadsheet that has two worksheets. One of the worksheets has a formula like
=CONCATENATE("K{""one""", "{""two~~""")
If you run workbook.CalculateFormula() and then read the value of the cell with the CONCATENATE call, the tildes are turned into commas. Is there an escape character that we’re missing? We expect to read a tilde.
Using version: Aspose.Cells .NET 23.4
@bblinn
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-53304
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
This is to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v23.6) that we plan to release in the first half of June 2023. You will be notified when the next version is released.
The issues you have found earlier (filed as CELLSNET-53304) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi