Re: [libreoffice-users] how to make formulas permanently case sensitive?

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 <hw@gartencenter-vaehning.de>
 To: users@global.libreoffice.org 
 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: users+unsubscribe@global.libreoffice.org
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: users+unsubscribe@global.libreoffice.org
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