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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: 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.