https://bugs.documentfoundation.org/show_bug.cgi?id=97434
Bug ID: 97434
Summary: LibreOffice Calc Find and Find/Replace won't find
trailing zeros in numbers or currency
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: and...@themagicofyou.co.uk
Created attachment 122275
--> https://bugs.documentfoundation.org/attachment.cgi?id=122275&action=edit
Shows Find etc does not find currency value with trailing zeros
I format cells to be currency or numbers with 2 decimal places [maybe other
formats also, I didn't check all.] Then I enter a value of 4.70. Neither Find
nor Find/Replace will locate the entry, because neither recognises the trailing
zero. Both correctly find 4.7. Particularly in dealing with money, it is normal
to enter all digits including training zeros even thought these are
scientifically meaningless. So this can be - and in my income tax spreadsheet
yesterday was! - very misleading.
This is v 5.0.4.2, I assume earlier also.
I never posted a bug before, apologies if I didn't do it right.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
