[Libreoffice-bugs] [Bug 138222] New: Word spreadsheet formulas become all #REFS (but the results still show)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138222
           Summary: Word spreadsheet formulas become all #REFS (but the
                    results still show)
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kevinogorman4 at gmail.com

Created attachment 167304
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167304&action=edit
Problem in the formula for cell B11

A colleague sent me a spreadsheet generated by QuickBooks Online, and it all
looked great until I started to use it.  The formulas were full of #REF!
errors, even though the results looked normal.  Until I went to do anything
with the cells, at which time the numbers also turned into #REFs.

I've trimmed it down to a single sum, removing all identifying info, so that
you can see it.  If it goes as expected, you'll be able to open it and all will
look normal until you look at the formula under cell B11.

I've tried creating similar things in LibreOffice without seeing the error, so
I expect it's something in Excel that you don't interpret correctly.  Or maybe
a bug in QuickBooks, I just can't tell with the tools I have.

-- 
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/20201115/dc5e179e/attachment.htm>