[Libreoffice-bugs] [Bug 124270] New: error 522 on copying of rows in dev-6.3.0.0.alpha0-2019-03-22 editing

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124270

            Bug ID: 124270
           Summary: error 522 on copying of rows in
                    dev-6.3.0.0.alpha0-2019-03-22 editing
           Product: LibreOffice
           Version: 6.3.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

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 at 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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190322/2a96734b/attachment.html>