[Libreoffice-bugs] [Bug 125588] New: EDITING: Wrong formula computed values and crash with formulas pasted on whole columns

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: matteo at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190530/7f867859/attachment-0001.html>