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 <[email protected]
<mailto:[email protected]>>:
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: [email protected]
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
