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

            Bug ID: 94166
           Summary: lookup fails with documents created with a former
                    version of calc
           Product: LibreOffice
           Version: 5.0.1.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 118642
  --> https://bugs.documentfoundation.org/attachment.cgi?id=118642&action=edit
ODS with sample lookup that fails

Here is a document created with a version < 4.0 of OpenOffice.
Some lookups show the results #N/D when a normal value is expected. I notice
this behaviour when data and lookups are in a different tab.

I couldn't predict which cells give an incorrect answer, neither find a
workaround to make it work fine, but it seems that this is dependant to the
looked up value.

I noticed this with LibreOffice Calc 4.3.1, 5.0.0.5 and 5.0.1.2. When I rewrite
the same file from scratch with Calc 5.0.1.2, I obtain the expected behaviour.

This may be related to Bug 74558.

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

Reply via email to