I've had this problem for months but it is such a big issue I assumed it had to be me or my hardware. Today it manifested itself in a different way and I don't see how it could be anything I'm doing. When copying or cutting then pasting a cell or cells the previously selected data is used instead of the currently selected data. In other words it pastes the previous entry on the clipboard instead of the current one. This does not happen all the time but it does happen most of the time. Sometimes it doesn't recognize the data that's being pasted and will ask what format it should be pasted as. I can reproduce this on different Calc spreadsheets but no other programs are affected and pasting works normally for Thunderbird, kwrite and other programs. Another manifestation is that occasionally when selecting and overwriting a data range in the formula bar the beginning of the range is replaced with the ending range and the ending range becomes a very large unrelated number. This happens randomly but on average about 1 out of 20 times. Today the third and most serious manifestation occurred. I copy and pasted a range of cells containing formulas and they appeared fine. Then I noticed that the data in the first cell had a value that couldn't be right. The formula contained a range of values divided by an integer (creating an average of the values). When you highlighted the cell the correct range and formula appeared but the value was wrong. It appears that when it pasted the cell range the beginning range updated correctly but the ending range didn't change so that the pasted range now contained the incorrect number of cells. This is a big deal since there is no way to know then the formula value is wrong. The formula in the bar is correct but the underlying data references the wrong range. Here's the specific version I'm using: Version: 5.3.7.2.0+ Build ID: 5.3.7.2-3.mga6 CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: gtk3; Layout Engine: new; Locale: en-US (en_US.UTF-8); Calc: group This may be related to bug 99763.
Created attachment 143406 [details] Sheet displaying bug Sheet is self-explanatory. As you can see when using shortcut keys everything works as expected. The problem arises when the copy/cut source is selected with the mouse and copied/cut using the right click mouse menu. It appears that every other copy/cut action selects the previously selected data.
Created attachment 143412 [details] Screenshot of correct formula These 2 screenshots show the 2nd manifestation of this issue. I can't send you the spreadsheet, but here's a screenshot. The formulas in the column with the highlighted cell were modified by highlighting the row number of the first cell in the formula bar and replacing it with a different row number. The divisor was also modified the same way to reflect the new range.
Created attachment 143413 [details] Screenshot of screwed up formula This screenshot shows the next cell in the column. The data was modified exactly the same as in the first screenshot, but look at the how the formula was saved. The end of range became the beginning of the range and the end of the range became the beginning of the range plus the first character of the divisor. The 2nd and 3rd characters of the divisor are now the 1st 2 characters and a seemingly random 20 is added to the end of the divisor.
(In reply to Jeff Laramie from comment #3) > Created attachment 143413 [details] > Screenshot of screwed up formula > > This screenshot shows the next cell in the column. The data was modified > exactly the same as in the first screenshot, but look at the how the formula > was saved. The end of range became the beginning of the range and the end of > the range became the beginning of the range plus the first character of the > divisor. The 2nd and 3rd characters of the divisor are now the 1st 2 > characters and a seemingly random 20 is added to the end of the divisor. After looking at this more I think the 20 that was added to the divisor was not random but was the characters in the divisor that were highlighted and supposed to be replaced.
I've tried to update this to critical but the system won't let me. I know it's very unlikely a problem of this magnitude could make it into a major release and I'm still hoping this is something specific to my system, but as I look into this, that seems less and less likely. This is looking more like a memory allocation issue and an extremely serious one at that. This issue results in corrupted data and sometimes it is undetectable by the end user. I know you get hundreds of bug reports and most are bogus, but please don't blow this off.
I suggest reset your user profile and upgrade LO to 5.4.7.2 or 6.0.5.2 retest the behavior because i cannot reproduce the problem Version: 6.2.0.0.alpha0+ Build ID: 187af5be47db42e2f4ab94319f932b847f897ce2 CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: gtk3; Locale: nl-BE (en_US.UTF-8); Calc: group threaded
To be clear, when you say reset my user profile you're saying I should delete the files in ~.config/libreoffice?
(In reply to Jeff Laramie from comment #7) > To be clear, when you say reset my user profile you're saying I should > delete the files in ~.config/libreoffice? Hello, see https://wiki.documentfoundation.org/UserProfile
Using safe mode had no effect on this bug and I've ruled out a corrupted profile as the cause. I was unable to reproduce this on a different Mageia 6 laptop that had not been updated recently. I wiped the old installation and reinstalled Mageia 6 on the laptop. Now that the updated version 5.3.7.2-3.mga6 is installed I can reproduce it on both machines. I've filed a bug report with Mageia for this: https://bugs.mageia.org/show_bug.cgi?id=23304 Please keep this bug report open until we are able to determine the root cause.
Version 5.4.7.2 from your site does not contain the bug.
(In reply to Jeff Laramie from comment #10) > Version 5.4.7.2 from your site does not contain the bug. Do you mean the problem is no longer reproduced with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
(In reply to Xisco Faulí from comment #11) > (In reply to Jeff Laramie from comment #10) > > Version 5.4.7.2 from your site does not contain the bug. > > Do you mean the problem is no longer reproduced with the latest version of > LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have not tried the newest version, but 5.4.7.2 was the newest version at the time I tested, and it did not contain the bug. I have only been able to replicate this bug using a Mageia packaged version running the KDE desktop. Other desktops and versions work fine. It does not appear to be related to your code and this bug report can be closed.
Closing