https://bugs.freedesktop.org/show_bug.cgi?id=76159

          Priority: medium
            Bug ID: 76159
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: FILEOPEN: IF() and INDIRECT() in formulae causes #REF!
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: amaste...@gmail.com
          Hardware: All
            Status: UNCONFIRMED
           Version: 4.1.4.2 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 95776
  --> https://bugs.freedesktop.org/attachment.cgi?id=95776&action=edit
Test spreadsheet

See attached file.
You can see #REF! error in G3 cell when file is opened.
But changing B3 cell makes G3 to become 6 (As it must be).
But save/load returns to old situation: #REF! error.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to