I have a formula in spreadsheet. =IF(B1="\", "a", "b") , It is ok in excel. but in spreadsheet, the formula is wrong.
1 Answer, 1 is accepted
0
Nencho
Telerik team
answered on 20 Oct 2021, 10:56 AM
Hello, Vincent,
The Kendo UI Spreadsheet is a js web-based component. That said, the backslash is interpreted as an escape symbol. Hence the inability to achieve the corresponding behavior in excel.
That said, in order to apply the needed formula, you should use double backslash:
=IF(B1="\\", "a", "b")
Hope this would help.!
Regards,
Nencho
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.