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.