[Libreoffice-bugs] [Bug 135718] New: LOOKUP function stopped working

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 135718
           Summary: LOOKUP function stopped working
           Product: LibreOffice
           Version: 6.3.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lkp1957 at hotmail.com

Description:
Had a list of LOOKUP functions referencing a table to report values as they
updated. Worked great for months until yesterday when it suddenly started
reporting wrong values mostly the same one. Checked the formulas and all good.

Steps to Reproduce:
1.Set up a two column table of text in one and values in the other
2.Set up second list of text with LOOKUP functions to report the corresponding
values
3. Update the values in the first table

Actual Results:
Mostly a single number randomly returned with a few others. All incorrect

Expected Results:
The correct values every update


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

-- 
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/20200813/87ffd400/attachment.htm>