https://bugs.documentfoundation.org/show_bug.cgi?id=94523
Bug ID: 94523
Summary: Search or Find string in CALC text field returns
illogical result if string not found
Product: LibreOffice
Version: 4.4.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 119032
--> https://bugs.documentfoundation.org/attachment.cgi?id=119032&action=edit
Tiny Calc Shhet
When a source cell with a text string is utilised in a Find or Search function
on the contents of a text data cell then a valid hit returns a true value
(normally the start position of the source text) which can be subjected to
further processing
When the source text is not contained in the target string then an #VALUE!
result is returned. Clearly this is a terminal failure as no further processing
can be performed to provide any state that can subsequently be processed.
A small spreadsheet has been appended with a full description of the effect and
the one step needed to create the anomaly.
Simply type a value into either of the two cells in the first row.
A valid "hit" produces a processable return whereas a "miss" provides an
illogical or invalid result.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
