<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - FILEOPEN XLSX TEXT formula gives different result than in Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131536">bug 131536</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>NEEDINFO
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - FILEOPEN XLSX TEXT formula gives different result than in Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131536#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - FILEOPEN XLSX TEXT formula gives different result than in Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131536">bug 131536</a>
from <span class="vcard"><a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> <span class="fn">Eike Rathke</span></a>
</span></b>
<pre>An empty format string makes no sense as it would return an empty string for
any input value. If that is actually desired the proper format string would be
";;;" (i.e. all empty sub formats).
However, if Excel allows such in TEXT() we could as well. ODFF puts no
constraints on TextFormatCode. BUT, what does Excel actually do there?
Apparently it does not return an empty string? Does it return a formatted
string according to the 'General' format? Something else? Can someone please
check?
For example, output for these is ...?
=TEXT(0;"")
=TEXT(12.3456;"")
=TEXT(1E23;"")
=TEXT("lala";"")</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>