I'm converting from Apache and had occasion to copy-paste a range of cells from AOO into Calc. When I did it overwriting cells containing data there was no overwrite warning. I checked the options and Warning was selected. Then I experimented with data copied from other cells within the Calc sheet and that gave the proper warning. Apparently the source of the data matters. I believe that the Paste overwrite action should be the same regardless of the Copy source because it is an indication that existing data will be lost.
What do you mean by 'I'm converting from Apache' ? Just save the file as ods and open it with LibreOffice. Why do you need to copy from AOO to LibreOffice ?
By converting I mean I personally am changing over from the AOO software to the LOO. As a consequence I have discovered several things I wish to upgrade so the process is not as simple as opening the same file with LOO. Regardless of my motivation for doing a copy-paste, I believe this is still a flaw in the implementation. Under all circumstances if a paste action will cause the destruction of any data present in any cell then the user must be warned. The Calc General Option reads "Show overwrite warning when pasting data". There are no qualifications or exceptions listed. It is unambiguous.
Hello Dale, Does it work when you copy/paste the data from AOO to another software? You are assuming the problem is in LibreOffice while it might be in AOO's side. OTOH, take into account LibreOffice and AOO took different pathes 10 years ago and at this point in time they are quite different internally even if they still look alike.
I pasted from Notepad, Editpad Lite, and LOO text document and they all failed to warn of overwrite. It is particularly telling that a paste from another LibreOffice app even fails. It indicates that the problem is not, as I first assumed, a result of copying data from an outside app. My bad. I should have investigated in more depth.
see https://ask.libreoffice.org/en/question/257955/paste-from-aoo-copy-does-not-give-overwrite-warning/ and comments there, setting to new, not intensively tested, but looks like: calc cares about overpaste only on it's own source, only same version! calc cares about content - value vs. formulae - only on it's own source, only same version! everyting else is pasted as string or numeric value ... only exception i could find quickly, from Ex$el 2010 to calc you can at least copy simple formulas, not in the other direction ... much space for improvements ... @xisco: imho OP meant he's 'migrating' and is converting files ...
Dear Dale Eltoft, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
I installed the latest version 7.3.5 To recreate the problem I 1) opened a new spreadsheet and 2) populated several cells with random numbers. 3) I selected a cell with a number in it and clicked "Copy" 4) Selected another cell with a number in it and clicked "Paste" **This resulted in a warning message indicating I was about to paste over existing content which I believe is the correct result. After cancelling that paste I 6) opened Windows Notepad 7) I typed in a random number and selected it. 8) clicked "Copy" 9) Shifted focus to the spreadsheet and selected the same cell a in #4 above 10) then clicked "Paste" **This resulted in the data from Notepad being entered into the cell with no warning which seems to me to be a problem. In my past experience the source of the data doesn't matter as long as it is not from another LibreOffice app.
(In reply to QA Administrators from comment #6) > Dear Dale Eltoft, > > To make sure we're focusing on the bugs that affect our users today, > LibreOffice QA is asking bug reporters and confirmers to retest open, > confirmed bugs which have not been touched for over a year. > > There have been thousands of bug fixes and commits since anyone checked on > this bug report. During that time, it's possible that the bug has been > fixed, or the details of the problem have changed. We'd really appreciate > your help in getting confirmation that the bug is still present. > > If you have time, please do the following: > > Test to see if the bug is still present with the latest version of > LibreOffice from https://www.libreoffice.org/download/ > > If the bug is present, please leave a comment that includes the information > from Help - About LibreOffice. > > If the bug is NOT present, please set the bug's Status field to > RESOLVED-WORKSFORME and leave a comment that includes the information from > Help - About LibreOffice. > > Please DO NOT > > Update the version field > Reply via email (please reply directly on the bug tracker) > Set the bug's Status field to RESOLVED - FIXED (this status has a particular > meaning that is not > appropriate in this case) > > > If you want to do more to help you can test to see if your issue is a > REGRESSION. To do so: > 1. Download and install oldest version of LibreOffice (usually 3.3 unless > your bug pertains to a feature added after 3.3) from > https://downloadarchive.documentfoundation.org/libreoffice/old/ > > 2. Test your bug > 3. Leave a comment with your results. > 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; > 4b. If the bug was not present in 3.3 - add 'regression' to keyword > > > Feel free to come ask questions or to say hello in our QA chat: > https://web.libera.chat/?settings=#libreoffice-qa > > Thank you for helping us make LibreOffice even better for everyone! > > Warm Regards, > QA Team > > MassPing-UntouchedBug Bug confirmed as remaining in 7.3.5
I began with a Calc spreadsheet having text data in some cells and numbers in others. I opened the Microsoft Notepad app and typed in a string of text on one line and a number on another. I selected the text from Notepad, copied it to the clipboard and pasted it into a Calc cell already containing text. There was no warning. I did the same with the number into a cell with a number and again no warning. I repeated these steps using a Writer document as the source of the clipboard data. There was no warning. Next I selected a Calc cell containing text. Then going to the Input line where the text was also displayed, I selected one word from the sentence and copied it to the clipboard using the keyboard shortcut. Then I clicked the red X to clear the Input Line update. Next I selected another cell containing text and pasted into it. Again no warning. It seems that the warning "You are pasting data into cells that already contain data." only shows up if the data being pasted is copied to the clipboard from one or more whole cells selected from an active Calc spreadsheet. To be clear from my experiments I believe that data pasted into one or more cells already containing data from any source other than whole cells copied from a currently active open Calc sheet does not provide an overlay warning. Version: 7.4.2.3 (x64) / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Reproducible with: Version: 6.4.7.2 (x86) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; Locale: es-AR (es_MX); UI-Language: en-US Calc: threaded Version: 7.6.0.2 (x86) / LibreOffice Community Build ID: 41d6f628ba3f046f16b5fa9fa8db8d4c2ab3b582 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: es-MX (es_MX); UI: en-US Calc: threaded
Reproducible with: Version: 7.4.3.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 1; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US Calc: threaded