https://bugs.documentfoundation.org/show_bug.cgi?id=149007
Bug ID: 149007
Summary: Search for scientific format fails
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: openfo...@davidpbrown.co.uk
Description:
Certain results of a calculation will land a scientific format without having
changed the cell format. Searching then for that result, fails.
Steps to Reproduce:
1. Make a cell some formula that lands a scientific result. eg
=8.765432/10000000000 ==> 8.765432E-10
2. Copy that result and search for it in the usual ctrl-F box 8.765432E-10
Actual Results:
Search key not found.. but it's right there.
Expected Results:
Search and find the concept of that number either as the long form or the
scientific but especially at least the scientific calc just created for itself.
Search should find what is present.
Reproducible: Always
User Profile Reset: No
Additional Info:
Simple bug likely with simple solution.. the format of the number should not
confuse the spreadsheet or the users.
--
You are receiving this mail because:
You are the assignee for the bug.
