https://bugs.documentfoundation.org/show_bug.cgi?id=106432
Bug ID: 106432
Summary: CALC SEARCH function with brackets in the search text
fails when the file is saved as an XLS file and
reopened.
Product: LibreOffice
Version: 5.3.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jn...@outlook.com
Description:
The following CALC function gives a "VALUE ERROR" if the CALC file is saved as
a XLS file, and then re-opened.
=SEARCH("aa[0-9]";A1&"aa0")
It works correctly if the file is saved as an XLSX or as an ODS file.
Steps to Reproduce:
1.create a new CALC
2.enter some value in cell A1
3.enter in cell B1 the following function : =SEARCH("aa[0-9]";A1&"aa0")
4.save the CALC as an XLS file
5.close the CALC and open de XLS file
Actual Results:
Cell B1 shows #VALUE!
Expected Results:
Cell B1 shows the position of the first occurrence of the string "aax" where x
is a digit 0 to 9.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:51.0) Gecko/20100101
Firefox/51.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
