Bug 170170 - Nonexistent value found in value
Summary: Nonexistent value found in value
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-12-30 09:48 UTC by Dan Dascalescu
Modified: 2025-12-30 12:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Repro sheet (33.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-12-30 09:48 UTC, Dan Dascalescu 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dan Dascalescu 2025-12-30 09:48:45 UTC 
Created attachment 204861 [details]
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.
Comment 1 Werner Tietz 2025-12-30 12:58:22 UTC 
the real Question is:
Why dont you use (in A1):

```
=D1/SUM(D$1:D$7) * $C$7
```

The result in A2 is: -$3,82049892178 , as you can see there are the
four digits »2178« 

check Option [x]match whole Cells