<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 - FILESAVE: Calc may retain illegitimate space characters between function names and parentheses, violating standard requirements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124614">124614</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE: Calc may retain illegitimate space characters between function names and parentheses, violating standard requirements
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.2.2 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>victor@terber.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
Saving a calc document in native LibreOffice format with a formula using a
blank between function name and initial parentheses may lead to a file which
may not be successfully opened by Excel.
This is very similar to the problem 104186 I reported earlier (and which was
fixed afterwards). LO seems to violate paragraph 5.14 (titled "Whitespace") of
the document "OASIS Open Document Format for Office Applications (OpenDocument)
Version 1.2" which clearly states:
"whitespace shall not separate a function name from its initial opening
parentheses."
If I manually remove the invalid blank from the LO save, Excel can open the
saved LO file successfully.
Steps to Reproduce:
1. Create a blank document with LO calc sheet with LO 6.2.2.2, using German
localisation
2. Use in the document the parameterized function JAHR (German for YEAR), and
use a cell reference as parameter for JAHR. In the formula, add a space
character between the function name and the initial brace.
3. Save the document in default LO format (.ods)
4. Open the document with a German version of Microsoft Excel 2016.
5. Excel reports an error for the cell with the JAHR function
6. Repeat steps 1 to 5, but do not add an additional blank. Result: Excel opens
the file successfully.
Actual Results:
Error message in Excel when opening the LO file
Expected Results:
No error message by Excel when opening the LO file
Reproducible: Always
User Profile Reset: No
Additional Info:
The application must not save any whitespace between a function name and the
initial opening parentheses. In my understanding this violates ISO/IEC
26300-1:2015.
See also <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - LOGINV function"
href="show_bug.cgi?id=103186">bug 103186</a> where the same issue was resolved for saves in ECMA-376
(Excel) format, which has the same constraints concerning illegal space
characters between function name and initial brace.</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>