<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 - Google Sheets export to XLSX gives lowercase formula "ifs()""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130509">130509</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Google Sheets export to XLSX gives lowercase formula "ifs()"
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.7.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</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>thor.rustad@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=157731" name="attach_157731" title="Image shows error in formula exported from Google Docs to XLSX format">attachment 157731</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=157731&action=edit" title="Image shows error in formula exported from Google Docs to XLSX format">[details]</a></span>
Image shows error in formula exported from Google Docs to XLSX format
I made a rather simple formula in Google Sheets and sent the sheet as email
attachment, then I opened the resulting .XLSX document in Libreoffice Calc. In
Calc, the formula "IFS" is lowercase "ifs", which causes the formula to fail.
Other formulae in the same cell are uppercase.
The spreadsheet is simple. In the first cell (A1) and the second one (B1) I add
either text or number (like A and 32)
In the third column (C1), I add the following:
=ifs(isblank(A1);"A1 is blank";istext(B1);"A1 is not blank and B1 contains
text";isnumber(B1);"A1 is not blank and B1 is a number")</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>