<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 - Word spreadsheet formulas become all #REFS (but the results still show)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138222">138222</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Word spreadsheet formulas become all #REFS (but the results still show)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.7.2 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>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>kevinogorman4@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=167304" name="attach_167304" title="Problem in the formula for cell B11">attachment 167304</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167304&action=edit" title="Problem in the formula for cell B11">[details]</a></span>
Problem in the formula for cell B11
A colleague sent me a spreadsheet generated by QuickBooks Online, and it all
looked great until I started to use it. The formulas were full of #REF!
errors, even though the results looked normal. Until I went to do anything
with the cells, at which time the numbers also turned into #REFs.
I've trimmed it down to a single sum, removing all identifying info, so that
you can see it. If it goes as expected, you'll be able to open it and all will
look normal until you look at the formula under cell B11.
I've tried creating similar things in LibreOffice without seeing the error, so
I expect it's something in Excel that you don't interpret correctly. Or maybe
a bug in QuickBooks, I just can't tell with the tools I have.</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>