<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 - Chart produces incorrect graph w/ some negative points when using large positive values in source cells"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=110993">110993</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Chart produces incorrect graph w/ some negative points when using large positive values in source cells
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.1.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>h.k.ghost@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=135050" name="attach_135050" title="LibreOffice Calc Chart Plotting Bug">attachment 135050</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=135050&action=edit" title="LibreOffice Calc Chart Plotting Bug">[details]</a></span>
LibreOffice Calc Chart Plotting Bug
DESCRIPTION
When creating a chart with very large numbers in cells, the line graph produced
is not entirely correct. While the values in the sheet cells are positive and
appear correct, some of them get plotted to the Y-axis incorrectly.
While trying different scaling values for the Y-axis, I saw that some Y-axis
entries were showing up as negative values instead of positive.
STEPS TO REPRODUCE
Create a data set meant to produce a graph to show how quickly common terms in
time complexity grow as the values of N grow.
1. Create a column for values of n, numbered: 1, 10, 20, 30, ... 100
2. Create additional columns with formulas to calculate 2^n and n!, as in:
O(2^n) and O(n!)
2.a. To calculate 2^n, use: =POWER(2, <cell>)
2.b. (OPTIONAL) Add a few smaller columns (e.g. n^2, n log n, etc) for
comparison
3. Select all the data and create a scatter chart to plot all of them
4. Adjust the maximum values for X axis to 100 and Y axis to 1.4E+020
4.a. Double click the table, then the X or Y axis, then the Scale tab.
4.b. Uncheck the "Automatic" checkbox for "Maximum" and set 100
EXPECTED RESULT
The asymptote for 2^n should be one single and continuous, though significantly
steeper relative to n^2, curve towards positive Y. The asymptote for n! should
be the steepest. All values for 2^n, n!, etc. must be plotted on the positive
Y-axis.
ACTUAL RESULT
There're some portions of the curves that drop below into the negative Y-axis,
which is incorrect.
Notice that the cells containing the values used by the chart are all positive,
but the chart does show the graph going through the negative Y-axis.</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>