<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - REGEX formula is not interpreted and is displayed as org.libreoffice.regex"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137535">137535</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>REGEX formula is not interpreted and is displayed as org.libreoffice.regex
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.6.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>michel.lopez@zaclys.net
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>