NeedQuoteInFormula faulty cases

Aspose.Cells Product Family
1

Hi team,

The NeedQuoteInFormula function added in version 23.11 works fine in almost all our test cases except for two :

  1. When a worksheet name ends with a ‘.’ (e.g. Test.), it doesn’t need to be wrapped with single quotes, but function returns true.
  2. When a worksheet name end with a ‘^’ (e.g. Test^), it needs to be wrapped in single quotes, but function returns false.

Thank you

2

@yashar.heydari,

After an initial testing, we noticed the issue as you mentioned. However, we need to evaluate whether these are actually faulty outcomes with NeedQuoteInFormula or if they are expected ones:

Console.WriteLine(CellsHelper.NeedQuoteInFormula("Test^"));//True
Console.WriteLine(CellsHelper.NeedQuoteInFormula("Test^"));//False

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-54932

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.

3

@yashar.heydari,

We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells v24.1) that we plan to release in this week or in the next week. You will be notified when new version is published.

1 Like
4

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