<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 - Dragging formulae across columns result in persistent wrong data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=143816">143816</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Dragging formulae across columns result in persistent wrong data
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</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>robert@prino.org
</td>
</tr></table>
<p>
<div>
<pre>Description:
When dragging a cell to other cells (empty or not makes no difference) to copy
a formula, it seems that not just the formula is dragged, but also the value of
the cell that is dragged, and no amount of recalculating will change this
value. Only overtyping the actual formula, or one character of it will correct
this situation!
NOT THAT THIS IS A VERY SEVERE BUG!
Steps to Reproduce:
1. Open the attached spreadsheet, and select the Naco-CoTy-Naty sheet
2. Note the values in these cells and their formulae:
- G2: 48 / =MAX(G2:G301)
- H2: 19 / =MAX(H2:H301)
- I2: 24 / =MAX(I2:I301)
- J2: 93 / =MAX(J2:J301)
2. Select cell cell G2, and drag it across to cells H2, I2, and J2
3. Note the new values / formulae in these four cells:
- G2: 48 / =MAX(G2:G301)
- H2: 48 / =MAX(H2:H301)
- I2: 48 / =MAX(I2:I301)
- J2: 93 / =MAX(J2:J301)
4: Press F9 until you're blue in the face, and nothing will change the values
of cells H2 & I2
5: Edit cells H2 & I2, by just deleting the closing parentheses of the
formulae, and hey, now the values are recalculated correctly!
Similar thin happens fro draggingR2 across S2/T2/U2, here only S2 is screwed
up!
Actual Results:
See above
Expected Results:
Se above
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.1.5.2 (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded
Note: I have not tried to reduce the sheet to something minimal, it happens in
this one!</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>