[Libreoffice-bugs] [Bug 118735] New: False #Value! error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118735

            Bug ID: 118735
           Summary: False #Value! error
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: alistair.fitchie at gmail.com

I used to have Lo 4.4.7 until yesterday.
It worked great, but I was advised to upgrade to 5.1.
I instantly found that it demanded I save the file even though I had not
amended anything.

It also gave #VALUE! errors for all the xmlfliter(webservice cells.
But the formula wizard shows correct values for all cells.

I threw that version in the bin and did another upgrade to 6.0.5.2 as it
advertised somewhere it had fixed a shedload of bugs.
Well not this one.

The sheet is about 7MB, and it needs a "latest.xls" in the same directory.

https://www.dropbox.com/s/puhkre5lqsdlbpf/FakeMembers.ods?dl=1

https://www.dropbox.com/s/tfejjho86z8laqw/latest.xls?dl=1

All names & addresses are fakes.

It used to be that you could open the spreadsheet, and it would not need to
update its link, as it would remember from the previous session.
No longer.

I been using this spreadsheet for a couple of years now, with no problem up
until the upgrade.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180712/8fdf16ae/attachment.html>