[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 --- Comment #11 from ady --- (In reply to CSV from comment #9) > Pasting "cells" is really pasting the CONTENT of cells, not an empty > skeleton. FWIW, that is not accurate. Generally speaking, you paste not only content but also formatting (whether permanent or conditional, or both). But, you could use "paste special" in order to paste content only, or format only, or using other special options in order to obtain different results. (In reply to m.a.riosv from comment #10) > BTW, not pasting empty cells means that if in the destination range are not > empty cells, they remain with their content, when they shouldn't. I think this is not the case presented here. We are not talking about "skipping empty cells" when copying or when pasting. We are talking about "not-pasting" the "end" of the entire column(s)/row(s) under specific conditions, when the source – column(s)/row(s) – was copied "entirely" and the destination area/range would be smaller, so as to allow a simpler selection of the source and destination ranges (from the users' perspective). The area/range to be paste-on would be replaced, according to the kind of paste action (e.g. all, values only, formatting only…). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 --- Comment #10 from m.a.riosv --- BTW, not pasting empty cells means that if in the destination range are not empty cells, they remain with their content, when they shouldn't. Or maybe you want in destination cells the same format as in origin. To avoid assumptions, it's the better way to avoid mistakes. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 --- Comment #9 from CSV --- Sorry if my terse language upsets you, sometimes it is needed to get the required attention. Pasting "cells" is really pasting the CONTENT of cells, not an empty skeleton. Selecting a column is easier than scrolling down to say, line 123892, where the remaining 924784 empty cells have no value, other than to create irritation, and slow down the work. With over one million cells in a row a manual error checking is a non-starter. If you have to read a manual to use software there is a missed opportunity of intuitive usability. The attitude I usually get from developers is: "not a bug, suck it up" which is an attitude I find unacceptable. I have used Calc since early 2000's and found it useful, for a lot of things. The famous alternative with more than 10 times the executable size has excelled in crunching large datasets, where this one, 10 years ago, froze the PC for a very long time. Oo/Lo Calc is my goto spreadsheet program, to my coworkers chagrin, even-though the famous alternative suite you can now find for $30 - $50 for a perpetual license. That one misses out by rolling out tone-deaf improvements that makes blood pressure go up. I appreciate the work you guys do for this program. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 m.a.riosv changed: What|Removed |Added Keywords|needsUXEval | Blocks|102593 | Version|Inherited From OOo |unspecified --- Comment #8 from m.a.riosv --- (In reply to CSV from comment #5) > Not a bug? > > If this was the design intent, then there is something seriously wrong with > the attitude of the designer. > > It should be obvious from my input that this behavior is unacceptable. Absolutely unacceptable, it's your attitude here. Maybe you can patch the supposed improvement, and give a lesson to the developers. > > The "other" famous program does not produce this output. That affirmation it's false for Microsoft® Excel® for Microsoft 365 MSO (version 2308 compilation 16.0.16731.20052) 64 bits >... 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] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 Stéphane Guillou (stragu) changed: What|Removed |Added Keywords||needsUXEval Blocks||102593 CC||stephane.guillou@libreoffic ||e.org Version|unspecified |Inherited From OOo --- Comment #7 from Stéphane Guillou (stragu) --- Same behaviour in OOo 3.3, so inherited. (In reply to ady from comment #6) > The potential enhancement would be to avoid trying to paste the "lower" > range of cells of the source column onto the destination column (but I would > add some condition, such as the "lower" cells being empty of content for > example, in order to allow such kind of "partial-paste"). That sounds sensible to me: discarding the bottom cells silently _only if they are empty_. If they are not empty, show the same error message as currently. (In reply to CSV from comment #5) > If this was the design intent, then there is something seriously wrong with > the attitude of the designer. > > It should be obvious from my input that this behavior is unacceptable. > > The "other" famous program does not produce this output. > > Get a clue. As a side note: please keep in mind that a lot of the work on LibreOffice is done by volunteers kindly spending their time on making this software better. I don't think this is an appropriate "tone" when interacting with other contributors on this bug tracker. https://www.documentfoundation.org/code-of-conduct/ Indeed, I agree with m.a.riosv and ady that this report is better categorised as an enhancement request. Copying in the Design/UX team for their opinion on ady's suggestion. 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] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 ady changed: What|Removed |Added Version|7.2.4.1 release |unspecified Severity|normal |enhancement OS|Linux (All) |All --- Comment #6 from ady --- The potential enhancement would be to avoid trying to paste the "lower" range of cells of the source column onto the destination column (but I would add some condition, such as the "lower" cells being empty of content for example, in order to allow such kind of "partial-paste"). It is true that ATM the action described in comment 0 cannot be successfully achieved. I am not sure we could call this "by design", but it is indeed how it is working ATM: Calc is trying to fit the entire source column (i.e. _all_ rows, independently of content and format) onto a range that is less than one entire column (i.e. not enough rows to paste the source). The workaround is evident, but this is not about that; it is about how (easy) users select different areas before performing an action (i.e. copy in this case). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 --- Comment #5 from CSV --- Not a bug? If this was the design intent, then there is something seriously wrong with the attitude of the designer. It should be obvious from my input that this behavior is unacceptable. The "other" famous program does not produce this output. Get a clue. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 --- Comment #4 from m.a.riosv --- So for me not a bug, it's how it works. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #3 from m.a.riosv --- I think the issue is, that if you copy the whole column, it doesn't have space to paste if the range to paste into, it is not the entire column. Because all cells of the copied column (empty or not) are in the clipboard. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 --- Comment #2 from CSV --- Created attachment 189391 --> https://bugs.documentfoundation.org/attachment.cgi?id=189391&action=edit image file -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157120] pasting column with empty cells gives error
https://bugs.documentfoundation.org/show_bug.cgi?id=157120 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #1 from Xisco Faulí --- Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) -- You are receiving this mail because: You are the assignee for the bug.
