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

            Bug ID: 170170
           Summary: Nonexistent value found in value
           Product: LibreOffice
           Version: 25.2.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 204861
  --> https://bugs.documentfoundation.org/attachment.cgi?id=204861&action=edit
Repro sheet

1. Open the attached spreadsheet
2. Search for 2178 (in Values, as per default)

Notice that the second result is cell A2, with value -$3.82, and formula
=INDIRECT("D" & ROW())/SUM(D1:D7) * C7

In the original sheet, 2187 is also found in a cell with the value -$1.43, and
formula =INDIRECT("K" & ROW()) / SUM(K14131:K14139) *J14139.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to