[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 Eike Rathke changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 --- Comment #8 from Eike Rathke --- (In reply to Timur from comment #5) > This is closest to WontFix. Actually no. I'd rather have this case of copy-pasting entire columns onto entire columns covered and exempted. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 --- Comment #7 from Eike Rathke --- (In reply to zzz from comment #6) > The mere fact that just figuring out the cause of > this case took one year is a good evidence. Nonsense. I was made aware of this just today by being Cc'ed with comment 3. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 --- Comment #6 from zzz --- 42 should be fine, it's the solution to the whole universe:-) Well, I am very surprised that such magic number is embedded, especially in a spreadsheet software. Arbitrary limitations like that will eventually bring all kinds of perils. The mere fact that just figuring out the cause of this case took one year is a good evidence. Anyway, thanks for proposing a workaround. The problem with such a single-row target area is that it is counter-intuitive. I usually do the copy-column when I want to replicate the column width. For a single row target: (a)If the source is a finite range of rows, then the target column width does NOT change. (b)If the source is an infinite range of rows, then the target column width DOES change to the source width. So user must remember this whole inconsistency. It is also inconsistent with the interface of how to insert new columns, and how to insert-paste. This is how you have to teach users now: - If you want to insert-replicate columns, first consider whether you want to make over 23 columns. If no, then select the source columns, command-copy, then select the target region by selecting some arbitrarily finite rows, such as B1:EZ1, and then command paste. Oh, when you paste, don't forget to set the PasteSpecial|Selection|Formats|On, otherwise you will fail and have to do it again. Now, if you want to make over 23 columns, then you have to do another preparation. First insert the extra columns you want to add, then do the same procedure as above, ie. select the source columns, command-copy, then select the target region by selecting some arbitrarily finite rows, such as B1:EZ1, and then command paste. Oh, when you paste, don't forget to set the PasteSpecial|Selection|Formats|On, otherwise you will fail and have to do it again. Oh, wait, first check the release note because the limitation may have changed to 42. The URL of the release note is... Who wants to make such manual, help tooltip, or do such tutoring? Quite unproductive. Conclusion: The usefulness and ease-of-learn of spreadsheets stem from their fundamental mental model: "Any amount of empty cells can be treated as really empty". So keep that. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 --- Comment #5 from Timur --- This is closest to WontFix. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 --- Comment #4 from Eike Rathke --- What magic number would you like instead? 42? I chose the discordian 23 because it breaks up something.. The point in this behaviour is to prevent a "paste something into the entire selected range". Which happens if only one cell (or a range of data) was copied, pasting that onto entire selected columns will repeat the data over the selection to fill it up. Which usually leads to out of memory. Having copied an entire column first including all empty cells is a somewhat special case though (there can be no repetition). Which that checking code does not know about. Fwiw, pasting such copied entire columns works if the target range is not selected as entire columns but only as first cell starting positions like in any other normal paste operation, e.g. B1:EZ1 (hit Shift+Ctrl+T to focus the Name Box and enter B1:EZ1 and hit Enter, after which the range is selected). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 Timur changed: What|Removed |Added Keywords|bibisectRequest |bibisected, bisected See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=60 ||056, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=60 ||021 CC||er...@redhat.com --- Comment #3 from Timur --- Nice report. Bibisect 5.2 Linux: commit 0faad65737329a9b8365f4164653620880b5bfea Date: Tue Dec 19 06:51:16 2017 +0100 source sha:7dda28234cc516e864aff9a6c97b7c539a063c4e previous sha:d013a5a38c6460a22434c6ba637c63d2118f12dc Single commit: author Eike Rathke 2016-07-29 18:18:01 +0200 committer Caolán McNamara 2016-08-02 15:15:02 + commit 7dda28234cc516e864aff9a6c97b7c539a063c4e (patch) treebcbafa58d49fb9069f8b7a7d02f89f47640a37f8 parent d013a5a38c6460a22434c6ba637c63d2118f12dc (diff) limit SelectionFillDOOM to 24117248 cells, tdf#60021 tdf#60056 related CC: Eike. Please see this and comment on "magic number" of 23. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 Buovjaga changed: What|Removed |Added Keywords||bibisectRequest, regression OS|Windows (All) |All Version|6.4.4.2 release |6.3.0.4 release Status|UNCONFIRMED |NEW Whiteboard| QA:needsComment| Ever confirmed|0 |1 CC||ilmari.lauhakangas@libreoff ||ice.org --- Comment #2 from Buovjaga --- Repro already with oldest of linux-64-6.3 bibisect repository, but not yet with latest of 50max repo. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 BogdanB changed: What|Removed |Added Blocks||102593 CC||buzea.bog...@libreoffice.or ||g Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=102593 [Bug 102593] [META] Paste bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134675] [EDITING] Whole column cannot be pasted to a column range over 23 selected by shift-click
https://bugs.documentfoundation.org/show_bug.cgi?id=134675 --- Comment #1 from zzz --- Correction: > zzz 2020-07-09 05:30:11 UTC >* When you drag-selecting the paste range, the paste works correctly > for a broader range. Now I cannot reproduce this success case. Now, drag-selecting the paste range B:Y and ctrl+V into that will also fail to paste anything as well, reproducitibility 100% (5/5 times in 2 files). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
