To make a formula that is case sensitive, you should be able to use the string functions (I think) to convert to a known case before performing the comparison, e.g. if(UPPER(A1) = "X";...) /Gary From: hw <[email protected]> To: [email protected] Sent: Tuesday, 12 May 2015, 11:55 Subject: Re: [libreoffice-users] how to make formulas permanently case sensitive?
Am 12.05.2015 um 12:45 schrieb hw: > > Hi, > > I need, of course, formulars to be case sensitive. This can be set in > the options for calc. The option is not saved permanently and every > time I open a spreadsheet, I need to set the option again. > > How can I save this option permanently so I don't need to set it over > and over again? > To clarify: I need the string comparisons of IF() to be case sensitive: 'if(a1 = "x"; ...) is, of course, different from 'if(a1 = "X"; ...)'. Why would anyone make them not case sensitive unless explicitly specified, and how do I specify case sensitiveness per formula? -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
