Backslash in spreadsheet formula.

1 Answer 129 Views
Spreadsheet
Vincent
Top achievements
Rank 1
Iron
Vincent asked on 16 Oct 2021, 07:06 PM
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

Sort by
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/.

Tags
Spreadsheet
Asked by
Vincent
Top achievements
Rank 1
Iron
Answers by
Nencho
Telerik team
Share this question
or