LO latest version & Windows 11 latest version
For many years (almost as far back as the first release of StarOffice) I have been able to copy data from from spreadsheets (any of the open office versions or Excel) that are contained in the same row but in non adjacent columns using Ctrl+Cursor cell select. The copied data was then pasted into another area of the spreadsheet, (using Ctrl+V or Ctrl+Shift+V) or a different sheet of that spreadsheet, or even in another spreadsheet. The data was pasted into adjacent columns. This worked even if it was copied from different formats such as Excel to an Open Office spreadsheet or vice versa.
Sometime in the past months this changed. Now the copied data is pasted spaced across columns with the same separation as the column spacing that was in the source spreadsheet. This does not occur in Google Spreadsheets nor in Android Open Office.
If copied in LO Calc and pasted into Excel spreadsheet the pasted data is spaced across non adjacent columns as it was in the Calc spreadsheet. However if the non adjacent is original was created in Excel and then copy pasted it is pasted in adjacent Excel columns (most of the time).
I thought this was a problem with LibreOffice, but after reading about Microsoft’s recent enhancement of their Clipboard, I suspected it is more of a Windows problem since the spacing also showed up in pasting into Notepad. However since it doesn’t occur in other Spreadsheet Programs Iit looks line an LO problem.
I think this is a Calc bug. Has anyone else noticed this happening? If so, then it definitely a bug.