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

On 14/05/15 10:55, Brian Barker wrote:
> At 20:32 12/05/2015 +0200, Honly Wonly wrote:
>> Am 12.05.2015 um 19:53 schrieb Brian Barker:
>>> At 12:45 12/05/2015 +0200, Honly Wonly wrote:
>>>> I need, of course, formulas 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.
>>>
>>> I'm surprised by that. If you mean the options at Tools | Options...
>>> | LibreOffice Calc | Calculate | Case sensitive, doesn't this apply
>>> per user and thus stick not only between documents but between
>>> LibreOffice sessions?
>>
>> No, this option is not remembered.
>
> I've done some research, and the setting is stored in
> registrymodifications.xcu in the profile. So yes: it *will* be saved per
> user, not per document or per system, and will stick across LibreOffice
> sessions. (But perhaps not, as I suggested, if you have a corrupt 
profile.)


Can I interject a comment and an experiment here?

Firstly, a global per-user setting for case sensitivity would be a 
recipe for disaster, and for spreadsheets not being properly portable.

But it isn't like that.

Now, checking under Tools|Options....Calculated showed my system 
(4.4.3.2/Mint 17) had the 'case sensitive' option' set. (TBH, I'd never 
noticed this before, but then I hardly ever use spreadsheets.)

I made a simple spreadsheet: two cells contained 'AAA' (A1) and 'aaa' 
(A2), and two cells with =IF(A1="AAA", 1, 0) and =IF(A2="AAA", 1, 0) and 
displaying 1 and 0 as expected. Save this as doc1. Set the Tools case 
sensitivity to no. The results cells now show 1 and 1 of course; save as 
doc2, and exit LO.

Now, if I reload doc1 and doc2 simultaneously, showing in 2 windows, 
both spreadsheets show the same results as before. Furthermore, checking 
the (expected-to-be-global) Tools option for case sensitivity shows 
different values when the dialogue is opened from each window.

Again, checking the contents.xml for each file shows an extra entry
<table:calculation-settings table:case-sensitive="false"/>
for the 'case insensitive' file. (Presumably the default is 'true'.)

So as one would hope, the setting is saved per-file.

My suspicion is that any value in registrymodifications.xcu is simply a 
default for new documents.


(I've communicated privately with Brian before posting the above, and I 
believe he has some extra germane comment to add.)


--
Mike Scott
Harlow, Essex, England

--
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