[Libreoffice-bugs] [Bug 134893] New: LibreOffice Calc > Column containing calculated values disappears when copying and posting the 108th row (100 rows of data) to the 109th row (101 rows of data)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134893
           Summary: LibreOffice Calc > Column containing calculated values
                    disappears when copying and posting the 108th row (100
                    rows of data) to the 109th row (101 rows of data)
           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: el_gallo_azul at yahoo.com

Description:
I want to add a new line to a sheet. I normally copy the final row and paste it
to the new row that I append. Today, when I do that, an entire column of
calculated numbers is annulled (ie. the numbers change from the calculated
values to "-" as the value in each row).

They do not return if I Ctrl-Z (undo), but stay as "-" on each row in that
column.

I have no option but to NOT save, and to close and reopen the sheet. I can't
find any way to correctly update the sheet.

Steps to Reproduce:
1.Save sheet with manually-entered values and calculation from those values
entered on 100 rows of data (108 rows in sheet)
2.Copy and paste calculations of final row to the subsequent row.
3.This same bug occurs when only the calculation from the final row in the
column that is affected by this bug is copied and pasted to the following row
(rather than copying and pasting the entire row).

Actual Results:
"-"

Expected Results:
Calculated number


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial10
CPU Threads: 32; OS Version: Linux 4.4; UI Render: default; 
Locale: en-AU (en_AU.UTF-8); Calc: CL

I haven't tried resetting my user profile, nor checking that OpenGL is enabled,
because this sheet has operated perfectly every week for two years until today.

-- 
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/20200717/5cad6bde/attachment.htm>