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
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 184.108.40.206 - and works fine. So maybe
the issue is specific to the later version of LO (220.127.116.11).
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.
2015-07-09 20:40 GMT+02:00 Mike Scott <firstname.lastname@example.org
On 09/07/15 14:08, Cley Faye wrote:
Do you have a sample file with this error?
Using an older version (18.104.22.168) I can't seem to reproduce this
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
Harlow Essex England
Mike Scott (unet2 <at> [deletethis] scottsonline.org.uk)
Harlow Essex England
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy