[Libreoffice-ux-advise] [Bug 134724] 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

--- Comment #7 from Eike Rathke <erack at redhat.com> ---
First off, the "Formulas" vs "Values" label is a terrible naming, but it's
probably due to the terrible naming that Excel introduced and its users are
used to. What it actually does and the difference is that Formulas searches the
*cell content*, be it literal strings, numbers or formula expressions; and
Values searches the unformatted *display value*, literal strings, numbers or
results of formula expressions.

Now if the default in Find&Replace was Values (display value) instead of
Formulas (content), a Replace operation would destroy any formula expression
where the result matched the Find, i.e. Find the result display value but
Replace the formula expression that calculated it => the formula is lost and
replaced by the literal replacement value. You certainly don't want that to be
the default. Specifically, even worse, you don't want to be the default that a
Find would match either the content or the result.

The Find&Replace dialog remembers the Values/Formulas setting though and
equally may trap the user in the next operation once Values was used.

The Find toolbar only searches in cell content (Formulas).

Confusingly the Formatted Display option searches displayed strings of
*literal* cell content and thus *ignores* formulas and their results (which is
logical, but..)

Personally I'd always expect a quick find (i.e. toolbar) to search content
instead of display values, but YMMV. Though I'd also expect that if I check
Formatted Display then formula results were searched as well, not the formula
as cell content. For both the toolbar and Find&Replace dialog.

-- 
You are receiving this mail because:
You are on the CC list for the bug.