https://bugs.documentfoundation.org/show_bug.cgi?id=125588
Bug ID: 125588
Summary: EDITING: Wrong formula computed values and crash with
formulas pasted on whole columns
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mat...@mitalia.net
Description:
Pasting trivial formulas referencing different rows into a whole column results
in either incorrect results, or outright crashes.
We managed to reproduce this easily:
- on 5.1.6.2, Ubuntu 16.04/x86-64 (libreoffice package)
- on 6.1.6-1, Arch Linux/x86-64 (libreoffice-still package)
- on 6.1.6.3, Windows 7/x86-64 (official package, "still" distribution)
This is 100% reproducible on 3 machines out of 5 we tested; on the two machines
where we couldn't reproduce it there wasn't any particular pattern in version
difference - one was an Ubuntu 18.04 machine running LO 6.0.7, the other was
another Arch machine, presumably recently updated.
Steps to Reproduce:
- create a new spreadsheet;
- write the number 4 for 10 rows in column A;
- in cell B2 insert the formula =A2-A1; it will produce 0, as expected;
- select cell B2, copy;
- click on the B column header, selecting it;
- paste (Ctrl-V, didn't try pressing Enter)
Actual Results:
You'll get 4 in all the cells on the right of the range you initially filled,
zero in the other cells.
Expected Results:
it should be 0 everywhere except for the first cell of column B outside the
range that was initially filled with 4, where it should be -4.
Reproducible: Always
User Profile Reset: No
Additional Info:
To instead get a crash, do the same as above, but use = A2-A3 as formula.
You'll get a fatal error saying something like
multi_type_vector::position#1528: block position not found! (logical
pos=1048576, block size=2, logical size=1048576).
Screencast of the bug repro: https://www.youtube.com/watch?v=gjsylUJO8gw
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
