Bug 134893 - 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)
Summary: LibreOffice Calc > Column containing calculated values disappears when copyin...
Status: RESOLVED DUPLICATE of bug 132451
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-17 05:36 UTC by el_gallo_azul
Modified: 2020-11-01 09:04 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
The weird spreadsheet in question (39.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-08-01 04:33 UTC, el_gallo_azul
Details

Note You need to log in before you can comment on or make changes to this bug.
Description el_gallo_azul 2020-07-17 05:36:16 UTC
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.
Comment 1 el_gallo_azul 2020-08-01 04:33:33 UTC
Created attachment 163835 [details]
The weird spreadsheet in question

I can't understand why the "Principal Paid" column doesn't show the calculated values any more.
Comment 2 Aron Budea 2020-08-21 11:55:59 UTC
I don't know why the wrong values are saved in the file, but recalculating the sheet using Ctrl-Shift-F9 shows correct results for me. If that doesn't work for you, I'd suggest upgrading to a more recent version, 7.0.0 or 6.4.6, first.
Comment 3 m_a_riosv 2020-10-07 16:53:56 UTC
I think this was an old bug using OpenCL, solved long time ago, please as @Aron say test with a new version.
Comment 4 b. 2020-11-01 09:04:20 UTC
hello @el_gallo_azul@yahoo.com, 

most likely you had been trapped by tdf#132451 (and / or it's predecessors), 

that bug is recently claimed fixed for ver. 7.1, 7.0.0.1, and 6.4.6, 

fail was that above 100 rows with identical formulas (and some other dependencies) parallelizing by openCL and / or 'threaded calculation' stepped in and had been buggy, you'd just hit that threshold, (have to say i like the informative description you gave for the error, pinpointing the weak point), 

either try those ver. (i don't use reg. other bugs), or switch off openCL and! threading, the performance loss is neglectable afais, 

wrong saved values need a refresh by ctrl-shift-F9 or recalc on load or similar, 

if the error reappears with mentioned ver. / settings pls. add info here! 

setting duplicate, feel free to change / reopen if i'm wrong,

*** This bug has been marked as a duplicate of bug 132451 ***