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.
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.
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.
I think this was an old bug using OpenCL, solved long time ago, please as @Aron say test with a new version.
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 ***