<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 - Spreadsheet is displaying cells with complex formulas and data dependencies with zero or some arbitrary value. These columns are feeds for x-y plots, and they begin to display bizarre results"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111912">111912</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Spreadsheet is displaying cells with complex formulas and data dependencies with zero or some arbitrary value. These columns are feeds for x-y plots, and they begin to display bizarre results
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>mlytle0@sbcglobal.net
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have a complex spreadsheet with 4 sheets. The first panel is for data input
and data accumulation and some calculations. Some of that data is copied to
the other sheets and further calculations are done, and those columns are
preset up and change from displaying '#value!' to displaying something real and
useful when the the cells these are linked to get real data, and that's normal
behavior. Now when entering data and saving the spreadsheet, many of these
cells that are in the state of displaying '#value!' suddenly decide their value
is '0' or some arbitrary random number. Those columns are the feed for some
x-y plots,and produce bizarre results.
Steps to Reproduce:
1.Add data to spreadsheet
2.Save spreadsheet and close it.
3.Reload spreadsheet, and there they are. You can manually 'clean' these cells
by dragging down from the last correctly displayed value to the bottom of the
sheet and it will nicely and correctly display '#value!' again. but after a
save and close and reload, you're back in the problem again.
Actual Results:
Results are bizarre and incorrect plots. But it's not the plot engine that's
at fault.
Expected Results:
Graph output that makes sense.
Reproducible: Always
User Profile Reset: No
Additional Info:
This is happening on two different hardware platforms, on brand new
installations and two different releases of Linux Mint.
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:55.0) Gecko/20100101
Firefox/55.0</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>