Disable case-sensivity for formulas to be compatible with MS Excel and G Spreadsheet

Progress® Kendo UI® for jQuery Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Completed

Last Updated: 26 Feb 2020 14:25 by ADMIN

Mike

Created on: 13 Mar 2018 14:01

Category: Spreadsheet

Type: Feature Request

Disable case-sensivity for formulas to be compatible with MS Excel and G Spreadsheet

type =IF( "a"="A" ; 1 ; 0 ) and =IF( EXACT("a";"A") ; 1 ; 0 )
into Kendo Spreadsheet and Google Spreadsheet and MS Excel.
There is a special EXACT function (which is also available in Kendo) to enforce case-sensitivity. By default it should be off.