https://bugs.documentfoundation.org/show_bug.cgi?id=134724
--- Comment #11 from Carl Pearson <libreb...@osxtra.dev> --- This bug appears to have been fixed, but it looks like a new one was spawned. Please advise if what appears to be the related bug should be opened as a separate item. CMD-F does now appear to match either values -or- formula results, instead of just values, which seems to be more intuitive. However, the Edit/Find and Replace dialog box has an issue, one which I don't recall presented previously. As a test to see if searching from a tab (not the Find and Replace dialog box) worked as desired, I again had a sheet with formulas pointing to cells in another tab, along with a hand-entered value in another cell of the sheet that was the same value as the referenced ones. In Sheet1: Cell H10 had the entered value "20.06" Cells E17 and E18 were formulas - "=Pivot.E17" and "=Pivot.E18" respectively - and the values of those referenced cells were also "20.06" In Edit/Find and Replace: "Find" contained "20.06" When "Search In" was set to "Formulas", only H10 was found. When "Search In" was set to "Values", all three cells were found. It now looks like when "Search In" is "Values", behavior is the same as CMD-F, with either hand-entered values or the result of a formula is matching. However, when "Search In" is "Formulas", the resulting behavior seems backwards. Only cells containing actual hand-entered values are being found, and cells that actually contain formulas are being ignored, even if their resolved value is the same as that which is being searched. For what it's worth, having the referenced data be part of a pivot table did not seem to matter. If other cells in sheet "Pivot" not actually in the pivot table contained the same hand-entered values, they were not found either when "Search In" was set to "Formulas". -- You are receiving this mail because: You are the assignee for the bug.
