Description: The formula is not executed properly and displays org.libreoffice.regex instead of executing REGEX formula. Steps to Reproduce: 1.Enter in K4 the formula =SIERREUR(DROITE(REGEX($D$4;",[:space:]?+[^,]*";;LIGNE(K4)-3);NBCAR(REGEX($D$4;",[:space:]?+[^,]*";;LIGNE(K4)-3))-2);"") equivalent to =IFERROR(RIGHT(REGEX($D$4;",[:space:]?+[^,]*";;LINE(K4)-3);NBCAR(REGEX($D$4;",[:space:]?+[^,]*";;LINE(K4)-3))-2);"") on a PC equipped with LO 6.6.2 under Ubuntu 18.04 2. The result is correct. 3. Save the file and send it to the claimer which PC is under Windows 1 Pro 64 bits and run LO 6.1.6.3.M15(x64) (release adopted by some official France minister department. The claimer has no admin rights on this PC. 4. The formula is not executed properly and K4 shows : =SIERREUR(DROITE(org.libreoffice.regex($D$4;",[:space:]?+[^,]";;LIGNE(K4)-3);NBCAR(org.libreoffice.regex($D$4;",[:space:]?+[^,]";;LIGNE(K4)-3))-2);"") Actual Results: Cacl displays org.libreoffice.regex in the middle of the formula Expected Results: Execution of REGEX Reproducible: Always User Profile Reset: No Additional Info: Latter on
I report this bug on behalf of someone else. When the claimer executes the files at home, under Windows 10 and LO6.4.6, REGEX is properly interpreted and provides the proper result.
Created attachment 166432 [details] Test file that induces the mis-interpretation of REGEX
(In reply to michel.lopez from comment #0) > The formula is not executed properly and displays org.libreoffice.regex > instead of executing REGEX formula. > > on a PC equipped with LO 6.6.2 under Ubuntu 18.04 > 2. The result is correct. > 3. Save the file and send it to the claimer which PC is under Windows 1 Pro > 64 bits and run LO 6.1.6.3.M15(x64) As mentioned on relevant help page [1]: > This function is available since LibreOffice 6.2. See also relevant release notes [2]. [1] https://help.libreoffice.org/latest/en-US/text/scalc/01/func_regex.html [2] https://wiki.documentfoundation.org/ReleaseNotes/6.2#New_spreadsheet_functions