Description: Copy/Pasting via Drag and Drop from a Base query resultset systematically pastes the resultset into cell A1 of a Calc sheet, irrespective of the target cell pointed to by the mouse. If there is data already in cell A1 (and any other cell that falls within the pasted array), then that data gets overwritten. This is a rather annoying regression in 24.2.x. Steps to Reproduce: 1. Open a Calc sheet containing data in cells A1 to D32 2. Load a database and open (run) a GUI database query from the registered database. 3. In the resultset (which is displayed in a grid control), select with the mouse the left hand top corner to select the whole array of data. 4. Drag the selection to a cell on the Calc sheet that is not within the existing data array. The green pointer indicates where the data should be dropped. 5. The data gets pasted to cell A1 and any other cells covered by the array of pasted data, overwriting the existing data. Actual Results: See above - existing data gets overwritten despite the drop pointer being located outside of the existing data in the Calc sheet. Expected Results: The data should only be pasted in the selected target cell and cells corresponding to the copied data array. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.4.2 (AARCH64) / LibreOffice Community Build ID: b9485aad85c48b4444220279f5499908c52f00f5 CPU threads: 8; OS: macOS 14.5; UI render: Skia/Metal; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
The pasting works correctly using Cmd-V shortcut.
Works for me with Version: 24.2.5.1 (X86_64) / LibreOffice Community Build ID: 2ccb78ad6bdfe3f3356a7a7f294ec388775c5816 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded But seems not always reliable.
For example, this works correctly in Version: 7.1.8.1 / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded ==>> regression Could be a macOS specific bug.
I found that the first time, always got to column A, repeating the action works fine. Creating a new sheet and again goes to column A. Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: bff48f885e3aad560776a42e451a735ed6c72c57 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Last working on my installed versions Version: 7.2.7.2 (x64) / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
Sorry, last working Version: 7.3.7.2 (x64) / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
(In reply to Alex Thurgood from comment #3) > > ==>> regression I can reproduce with 7.0 beta on Linux. In my test the trigger of the bug is drop selection immediately after the last row of the data in the spreadsheet.