spreadsheetlab / XLParser

A C# parser for Microsoft Excel formulas with a 99.9% compatibility rate
Other
407 stars 91 forks source link

Parse error in latest version 1.7.2, but worked in 1.5.1 with '#' #189

Open kiruba-github opened 2 months ago

kiruba-github commented 2 months ago

The below expression format worked well and parsed as expected in version 1.5.1 But now I have tried to update the latest version 1.7.2 and it failed to parse the expression if contains '#' in whole app. With out '#' it converts, but it supports special char in some other expressions. Please clarify/suggest to resolve this to update the Package.

[Txn Details Insurers XXX/XXX # - 00000] IF(ISNULLORWHITESPACE([XXXX XX XX - 000]) ,"" , [XXXXXXX XXX XXX # - 0000])