Created attachment 68571 [details]
I make a calc document
In the cel A1 I enter 2
In the cel A2 I enter =A1+2
For cel the formula will be Ai = A[i-1] + 2 ( by dragind the formula from the right down corner of the A2 cel )
the calc doc will be like this:
1 2 - 2
2 4 - formula =A1 + 2
3 6 = formula =A2 + 2
4 8 = formula =A3+2
5 10 = formula =A4 +2
6 12 = formula =A5 + 2
7 14 = formula =A6 + 2
If I search ( ctrl+f ) for 6 i get the result A7 ( A6 + 2 ) not 6 , if I search for 10 ( in the A5 cel ) I get "search key not found"
It find the cel number but not the data that is inside the cel ( the calculated data ).
This is not a bug. What you have to do is:
Ctrl + F
Then click on the magnifying glass/pencil icon in the find toolbar. This will bring up the find & replace dialog.
Click on "More Options"
Then you can change the search in option from Formulas to "Values" (or Notes). If you change to "Values" it will correctly find the value 6 and ignore the formula.
Marking as INVALID as it's not a bug.