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

Am 15.05.2015 um 10:03 schrieb Brian Barker:
> Another contributor suggested that the original enquirer's problem may
> have been caused by (unwisely) saving spreadsheets in Microsoft Excel
> format, and it appears that this may well have been so. My experiments
> suggest that spreadsheets saved with the option set differently are
> displayed correctly in the Excel Viewer (and therefore presumably in
> Excel itself) but do not render correctly when reopened - suggesting
> that it is LibreOffice's input filter that is at fault. Solution: save
> in .ods format.

The spreadsheets are created with a perl module (Excel::Writer::XLSX) 
because there doesn't seem to be an equivalent module to create ODS 
files.  Saving them as ODS is not an option because it's annoying having 
to switch between different formats and to create various copies of the 
files all the time.

Even saving them as CSV to import them is a step that needs to be 
removed from the workflow.

> But the bottom line is still the same: because the situation is so
> complicated and fluid, the reliable way to deal with the problem is to
> build case sensitivity into formulae, testing similarity using the
> EXACT() function instead of the "=" operator.

I don't understand why or how this is complicated.  When I make a 
general/global setting amongst others, I simply expect this setting to 
be in effect regardless which document I open.

If this setting cannot be made general/global, then it needs to be clear 
that it is per document --- not considering that some ppl might 
nonetheless wish that a global/general setting for this exists.  And if 
a setting which is per document overrides a general/global setting, I 
should optionally receive a warning.

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