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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
