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

On 18/05/15 16:50, hw wrote:
......
> 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.  .....

That's possibly because you don't really need one. Or at least, it's 
easy enough to create the necessary xml by hand. Easiest way is to 
create a document like the one you want, and examine its structure, then 
make your code write something similar. Some quick work with perl's 
zip-file modules, and you're done. I've a number of programs that do 
just this.

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

I sympathize. IMO the GUI is badly designed (iow broken), and the case 
sensitivity might better appear somewhere in the File|Properties 
dialogue. I'll not hold my breath though.


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