<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 - error 522 on copying of rows in dev-6.3.0.0.alpha0-2019-03-22 editing"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124270">124270</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>error 522 on copying of rows in dev-6.3.0.0.alpha0-2019-03-22 editing
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.0.alpha0+ Master
</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>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
when inserting rows in a long file with 'stacked columns' (long columns summed
up bottom-to-top with cells from two other columns) and filling the inserted
rows with copies from 'working' rows above or below the gap i get error 522
sometimes somewhere - see attached screenshot in next comment.
ctrl-shift-F9 or inserting other copies corrected the fault up to now, but i
think that shouldn't be neccessary, the sheet should be able to insert and
calculate the formula in the same way as it does for the other lines.
Steps to Reproduce:
not so easy, i took one row from my 'big sheet', copied it in rows 1 to 100 on
another, inserted lines 6 to 10, copied line 15 to 4 - 12, got the error in
lines 1 and two, cutted all stuff around, can provide screenshot, see attached.
on save-load the error disappears as well as on strg-shift-F9, thus i cannot
provide the file with error.
Actual Results:
a cell with a clear simple formula without any circular references or similar
is calculated to Err:522,
Expected Results:
the cell should be calculated to a proper value instead, strg-shift-F9 or other
actions shouldn't be neccessary while autocalculate is on
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
Version: 6.3.0.0.alpha0+ (x64)
Build ID: 5a907fe76bc628629fddb5501727642468d38dae
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win;
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-22_00:18:04
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded
hardware / os: not tested with 'all', only win7(x64) on lenovo notebook,
it looks like that the error likes to come up when you copy the formula in the
gap with some overlap, e.g. insert 5 rows and copy the source row to nine rows
two above and two below the gap, thus replacing rows with an identical copy</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>