Re: [libreoffice-l10n] Bad source strings?

Hi Michael,

On Friday, 2014-05-23 16:51:05 +0100, Michael Bauer wrote:

> 23/05/2014 15:52, sgrìobh Eike Rathke:
> > Regarding enables/disables: what I meant with disabled is actually that
> > changing the option is disabled. The "Treat empty string as zero"
> > option's value follows the "Conversion from text to number" option in
> > both cases. You can see if you play with the options;
> >
> > * set "Conversion from text to number" to "Generate #VALUE! error"
> >   => "Treat empty string as zero" is set to "False"
> >      * the option can't be changed / is disabled
> > * set "Conversion from text to number" to "Treat as zero"
> >   => "Treat empty string as zero" is set to "True"
> >      * the option can't be changed / is disabled
> >
> > This is what was meant with "follows that value". Does that clarify?
> Yes, I think so. There are two settings which have an effect on how
> empty strings are handled and if you've set one of them, it prevents
> you from setting the other. I haven't seen this in action (and I
> can't find it, must be a new addon getting integrated)

No, it's in the detailed formula calculation settings.

* open a new Calc spreadsheet
* go to Tools -> Options -> Calc -> Formula
* set "Detailed calculation settings" to Custom
* click Details

> which
> probably doesn't help but I get the feeling that this would be
> easier if we say it the other way round:
>
> If you have set "Treat empty string as zero" to either true or
> false, you cannot choose (here) if conversion of an empty string to
> a number will generate an error or if it will treat empty strings as
> zero. Otherwise this option determines how empty strings are
> treated.
>
> Does that fit?

Not really, you got the options mixed up ;-)
Following your wording it should be something like

If you have set "Conversion from text to number" to either "Generate
#VALUE! error" or "Treat as zero", you cannot choose (here) if
conversion of an empty string to a number will generate an error or if
it will treat empty strings as zero. Otherwise this option determines
how empty strings are treated.

Are we good with that?

  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key ID: 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Support the FSFE, care about Free Software! https://fsfe.org/support/?erack

-- 
To unsubscribe e-mail to: l10n+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/l10n/
All messages sent to this list will be publicly archived and cannot be deleted