Bug 157430

Summary:	How can I enable search in UI to match the displayed format of formatted currencies, including trailing zeroes, instead of only matching based on the stored format?
Product:	LibreOffice	Reporter:	Lennard Lehnen <vernehmlassung>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.6.1.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Lennard Lehnen 2023-09-25 11:17:31 UTC

Description:
When having a row in libreoffice calc with formatted currencies, for example german formatting 123,33 € at A1 and I am searching for 123,33, I get the position at A1.

If on the other hand, the value is 123,30 € at A1 and I am searching for 123,30, I get a not found error, because LOC omits all zeroes at the end.

Now I could of course search for "123,3", yet this will result in "123,31" "123,36" "123,39" etc. if available aswell.

In other words, you need to enable search in the way it's displayed "123,30" and not just how it's stored "123,3".

Steps to Reproduce:
See above

Actual Results:
See above

Expected Results:
See above


Reproducible: Always


User Profile Reset: No

Additional Info:
See above

Comment 1 m_a_riosv 2023-09-25 17:46:39 UTC

Please attach a sample file, so someone can test on it.

Comment 2 Lennard Lehnen 2023-09-25 18:19:44 UTC

Enter 123,33 in A1.
Enter 123,30 in A2.
Format all as Currency.
Search for 123,33.
Search for 123,30.
Search for 123,3.

Comment 3 ady 2023-09-25 20:02:47 UTC

IIUC, the simple answer to this support question is:

[CTRL]+[H] > set the check box named "Formatted display" as (checked) ON, and perform the search.

This site is for bug reports and enhancement requests. Please next time ask support questions in adequate sites, such as the user mailing list, or at https://ask.libreoffice.org .

I am closing this as invalid now. If, for some reason, there is really a bug to report regarding this feature, please set the report back to unconfirmed and explain it in detail, with relevant steps, actual results and expected results.

Comment 4 Lennard Lehnen 2023-09-25 20:41:34 UTC

It works, but how should I have known that?