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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
