Re: [libreoffice-users] spreadsheet not calculating correctly

On 10/07/15 08:18, Cley Faye wrote:
> This is looking like an issue that will not be found easily. Simply
> opening your file, the result is correct: D5 initially show 33520.
>
> Out of curiosity, I tried opening it in gnumeric, same result. Only
> google drive *preview* show the 0 in D5. Interestingly enough, when
> opening the sheet fully in google drive, D5 shows up as "£33520" for no
> apparent reason.
>
> At this point, if you found a way to reproduce it, it might be worth
> opening a bug, but only after checking that your LO profile is not at
> fault. You could try renaming it to check that.

Thanks for checking.

I've just done what I should have done in the first place - try a 
different machine. That one had LO 4.2.8.2 - and works fine. So maybe 
the issue is specific to the later version of LO (4.4.4.3).

Removing my LO profile had no effect.

The spreadsheet was originally a financial one, but I removed all the 
'currency' formatting when I stripped out all the irrelevant cells. Odd 
that google seems to put it back.

I have to say, I don't like unrepeatable errors of unknown cause. In 
this case the fault was obvious; but what if it hadn't been clear?

As it is unrepeatable, I guess I'll archive the problem file and let the 
issue drop; and pay extra careful attention to results in future.
>

Thanks again.

> --
> Cley Faye
> http://cleyfaye.net
>
> 2015-07-09 20:40 GMT+02:00 Mike Scott <v.lo@scottsonline.org.uk
> <mailto:v.lo@scottsonline.org.uk>>:
>
>     On 09/07/15 14:08, Cley Faye wrote:
>
>         Do you have a sample file with this error?
>
>
>     http://scottsonline.no-ip.info/xxx.ods
>
>
>         Using an older version (4.4.1.2) I can't seem to reproduce this
>         behavior.
>
>     I'm not surprised. I can't recreate it in a new file either. And
>     pretty well any change to this one make it "go away". Nor do I have
>     the foggiest idea what I did to create this problem n the first place.
>
>     (The file will only be around temporarily, BTW.)
>
>
>     --
>     Mike Scott (unet2 <at> [deletethis] scottsonline.org.uk
>     <http://scottsonline.org.uk>)
>     Harlow Essex England


--
Mike Scott (unet2 <at> [deletethis] scottsonline.org.uk)
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