NeedQuoteInFormula (v24.5.0) fails test case

Hi team,

The NeedQuoteInFormula passes all but one of our tests where a worksheet name is preceded by a period (‘.’). This test case was passing when we were on v23.11.0, but fails on upgrading to v24.5.0.

“.Test1” worksheet name needs to be wrapped in single quotes, but the function returns false.

Thanks!

@sparsh.trivedy
By testing with two versions, v24.5 and v23.11, we can reproduce the issue. Discovered that testing with v24.5 returned incorrect value when calling the NeedQuoteInFormula method. Please refer to the attachment. result.png (5.9 KB)

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

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.

@sparsh.trivedy,

We are pleased to inform you that the issue (logged as “CELLSNET-55800”) has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.6) scheduled for release in the second week of June 2024. You will be notified when the next version is released.

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