<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 - FILEOPEN XLSX TEXT formula gives different result than in Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131536">131536</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX TEXT formula gives different result than in Excel
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.3.0.4 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Keywords</th>
<td>filter:xlsx
</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>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=158936" name="attach_158936" title="Example file from Excel">attachment 158936</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=158936&action=edit" title="Example file from Excel">[details]</a></span>
Example file from Excel
Attached document contains a TEXT formula that was made in Excel.
If it is called using the empty string as third parameter, embedded in an IF
formula, it gives back a Err:502 result, unlike Excel.
However if the same formula is called using “0” as third parameter, the error
is not present.
The problem does not appear until the result from TEXT is used in an IF
formula, so the example file contains a breakdown of the complex IF formula as
well.
Steps to reproduce:
1. Open attached document.
Actual results:
The formula in D10 gives TRUE in Excel, but Err:502 in Calc.
The same formula with a small change in the TEXT formula is in E10, gives 1 in
Calc.
Expected results:
The formula in D10 gives 1 in Calc.
LibreOffice details:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: b07d429f8610c4df93dffa72552f4f759ec0b74f
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL
Also in:
Verzió: 6.0.0.3
Build az.: 64a0f66915f38c6217de274f0aa8e15618924765
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: GL;
Területi beállítások: hu-HU (hu_HU); Calc: CL
Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale: hu-HU (hu_HU)
Version: 4.3.0.4
Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0
In 4.0 - 4.2 even worse, since the Err:502 appears as result of the simpler
formulas, not only IF.</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>