Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

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 - and works fine. So maybe the issue is specific to the later version of LO (

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

2015-07-09 20:40 GMT+02:00 Mike Scott <

    On 09/07/15 14:08, Cley Faye wrote:

        Do you have a sample file with this error?

        Using an older version ( 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]
    Harlow Essex England

Mike Scott (unet2 <at> [deletethis]
Harlow Essex England

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.