<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 - Formula (sum()) in cell is not calculation correct after adding a column and adjusting the range of the sum formula"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114143">114143</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Formula (sum()) in cell is not calculation correct after adding a column and adjusting the range of the sum formula
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.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>libreofficebugzilla@crazyideas.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
After adding a column into a a document and adjusting the range of a =sum()
formula so that it contains the new cell the value of the new cell can be
changed without getting a new result in the =sum() cell
I already tried "Safe Mode" no success.
I also tried it on a different machine with version 5.3.7.2.
I'm using the german version so please be gentle if there are some menu
captions are translated wrong ;-)
You need to follow the "Steps to reproduce" exactly. If you for example use
your keyboard in step 6 to alter the range of the sum formula directly the bug
will NOT appear.
Steps to Reproduce:
1. open scalc.exe
2. add formula =SUM(A1:C1) into cell D1 (Value of Cell D1 is now 0)
3. right click on column header of column D
4. click add new column on the left
5. select the cell with the SUM formula (should be E1 now) and press F2
6. use your mouse to extend the selection so that it covers A1 to D1 inclusiv
7. press enter
8. enter a number(42) in any of the cells which are covered by the SUM formula
9. see that the cell with the SUM formula doesn't get the new correct value.
(still displaying 0)
Actual Results:
The SUM formula is not calculating properly
Expected Results:
The calculation should be work as normal. After entering the value of a cell
which is covered by the SUM formula the SUM formula should be updated with the
new value.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
I tried it with OpenGL enabled and disabled it doesn't affect the bug.
Helo -> ABout LibreOffice
Version: 5.4.2.2 (x64)
Build-ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU-Threads: 8; Betriebssystem:Windows 6.1; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc: CL
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) Gecko/20100101
Firefox/52.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>