[Libreoffice-bugs] [Bug 137535] New: REGEX formula is not interpreted and is displayed as org.libreoffice.regex

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137535

            Bug ID: 137535
           Summary: REGEX formula is not interpreted and is displayed as
                    org.libreoffice.regex
           Product: LibreOffice
           Version: 6.1.6.3 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: michel.lopez at zaclys.net

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201016/84cdc754/attachment.htm>