[Libreoffice-bugs] [Bug 134724] New: UI - Find in Calc fails when a formula refers to a cell in another sheet's pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134724
           Summary: UI - Find in Calc fails when a formula refers to a
                    cell in another sheet's pivot table
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: librebugs at osxtra.dev

Description:
Calc's Find function defaults to formulas.  All Pivot Table results are Values. 

If a cell contains a formuala referencing another cell in a Pivot Table,
searching returns "Search key not found".  One must use Find and Replace, then
change the "Search in" drop-down to "Values".

If sheet "Pivot" contains a pivot table, Pivot.A4 contains the value "My Pivot
Value", and Sheet1.A4 contains "=Pivot!A4" and displays "My Pivot Value", using
Cmd-F / Edit->Find from Sheet1 and searching for "My Pivot Value" fails with
"Search key not found".

Using Alt-Cmd-F / Edit->Find and Replace, changing "Formulas" to "Values" and
clicking "Find Next" will successfully select Sheet1.A4

Steps to Reproduce:
1. Create a pivot table ("Pivot") from data in some sheet.
2. Have a formula in another tab ("Sheet1") that refers to a cell in that
table.
3. Use "Find" to search for a value that can be seen in "Sheet1"

Actual Results:
The "Find" bar at the bottom of Calc displays "Search key not found"

Expected Results:
The cell containing the value that can be seen on the screen should be
selected.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 6.4.5.2
Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 16; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200711/1aa94328/attachment-0001.htm>