Description: The error pop-up describes that there is too many cells trying to be pasted Steps to Reproduce: 1.copy a whole column, not being entirely filled, 2.paste into a new column below existing filled numbers 3.watch the pop-up Actual Results: pop-up error box Expected Results: copying of a complete column into a new column below existing cells, should be smart enough that empty cells pasted into empty cells should still be empty cells. Reproducible: Always User Profile Reset: No Additional Info: this is an old problem.
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.)
Created attachment 189391 [details] image file
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.
So for me not a bug, it's how it works.
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.
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).
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.
(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 >...
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.
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.
(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…).
Dear CSV, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
The responses given by the last poster shows an attitude that is not commensurable to product usefulness. I have given all the info to replicate the problem, and which has been ignored. I appreciate all the volunteer work, but this cannot be an excuse for accepting subpar work. If this is "not a bug", maybe you can bounce the issue over to the product development team, who may take their work seriously.
After you have marked the total column use the short cut Ctrl+Shift+ArrowUp. That reduces the selection to the last non-empty cell. Now you can copy&paste without problems.