Problem description: Steps to reproduce: 1. take 2 tables with prices for fruits for june and july 2. filter only oranges of different varieties in both tables 3. assume that we have 50 oranges of different varieties in both tables(i mean the lists match each other) 4. we need to replace prices for july with the prices for june 5. it seems that this is only a matter of selecting the column in the filtered table with the prices for june and pasting it into the filtered table for july Current behavior: LibreOffice says this is impossible Microsoft Excel would paste it as if the july table had no filter Expected behavior: I see 2 tables, no matter they have hidden rows or columns, I should have an apportunity to work with them like with a normal tables. Comments: The solution for this situation is ether to copy 50 times each price separately(this is about 150 keypresses) or to write a complexed formula(this is a lot of keypresses too), but it looks intuitively like a copy/paste operation. Please implement this feature, I know you care about users, not about marketing like Microsoft, so please take care of me)) Operating System: Windows XP Version: 4.1.2.3 release
HI Plavozont, thanks for describing the issue. To be sure that we test in the same way as you, can you pls provide a test file? Regards, Cor
Created attachment 89073 [details] Copy/Pasting inside the filter Copy Range A4:A22 and paste it into B4
(In reply to comment #2) > Copy Range A4:A22 and paste it into B4 Thanks - I confirm the behaviour. I see that it's like that since OOo times. Work around: copy B4:B22 before pasting. therefore: could you agree that we set his as enhancement? Cheers,
Yes, set this as an enhancement
(In reply to comment #4) > Yes, set this as an enhancement Well, you could have done it yourself. I'm setting it now and changing Summary accordingly.
Copying selection or multiple cells can be made to another sheet or to the current sheet if you paste selected cells where some cells are not hidden by filter. Behavior was changed in old Bug 38822, but it's not explained in documentation. If this option can be added then we would need a warning that for example only visible cells will be copied. When I tested for Bug 84389 I also saw different behavior for MSO. Anyway, this remains like and enhancement but it may stay open for a long time.
*** Bug 84389 has been marked as a duplicate of this bug. ***
*** Bug 49205 has been marked as a duplicate of this bug. ***
Workaround explanation (in English, Spanish and Esperanto): When working with filtered ranges in LibreOffice Calc, direct pasting into a filtered column may fail because Calc expects a contiguous (unfiltered) target range. However, this can be worked around by explicitly selecting the visible target cells before pasting: Steps: Apply the filter to both source and target tables. Copy the visible cells from the source column (e.g., June prices). In the target table (e.g., July prices), manually select the visible cells where the data should be pasted (only the filtered rows). Paste the data. Result: LibreOffice will correctly paste the values into the selected visible cells, matching the filtered rows. Explanation: The issue occurs because LibreOffice does not automatically map filtered (non-contiguous) ranges during paste operations. By pre-selecting the destination cells, you explicitly define the target range, allowing Calc to bypass this limitation. Explicación del workaround (en español): Al trabajar con rangos filtrados en LibreOffice Calc, pegar directamente en una columna filtrada puede fallar porque Calc espera un rango de destino continuo (sin filtrar). Sin embargo, esto puede evitarse seleccionando explícitamente las celdas visibles de destino antes de pegar: Pasos: Aplica el filtro tanto en la tabla origen como en la tabla destino. Copia las celdas visibles de la columna origen (por ejemplo, los precios de junio). En la tabla destino (por ejemplo, los precios de julio), selecciona manualmente las celdas visibles donde quieres pegar los datos (solo las filas filtradas). Pega los datos. Resultado: LibreOffice pegará correctamente los valores en las celdas visibles seleccionadas, respetando las filas filtradas. Explicación: El problema ocurre porque LibreOffice no mapea automáticamente rangos filtrados (no contiguos) durante el pegado. Al preseleccionar las celdas de destino, se define explícitamente el rango, lo que permite a Calc evitar esta limitación. Klarigo de la solvo (workaround) en Esperanto: Dum laboro kun filtritaj intervaloj en LibreOffice Calc, rekta algluo en filtrita kolumno povas malsukcesi, ĉar Calc atendas kontinuan (nefiltritan) celintervalon. Tamen, tio povas esti evitata per eksplicita elekto de la videblaj celĉeloj antaŭ algluo: Paŝoj: Apliku la filtrilon al ambaŭ tabeloj (fonta kaj cela). Kopiu la videblajn ĉelojn el la fonta kolumno (ekzemple, la prezoj de junio). En la cela tabelo (ekzemple, la prezoj de julio), mane elektu la videblajn ĉelojn kie la datumoj devas esti algluitaj (nur la filtritaj vicoj). Algluu la datumojn. Rezulto: LibreOffice ĝuste algluos la valorojn en la elektitajn videblajn ĉelojn, kongruigante ilin kun la filtritaj vicoj. Klarigo: La problemo okazas ĉar LibreOffice ne aŭtomate mapigas filtritajn (nekontinuajn) intervalojn dum algluo. Per antaŭa elekto de la celĉeloj, oni eksplicite difinas la celintervalon, kio permesas al Calc eviti ĉi tiun limigon.
There seem to be two different cases involved here: 1) When rows are hidden by filter: - Pasting into a filtered range may fail with "Cannot insert into multiple selection". - However, if only visible cells are explicitly selected before pasting, the operation works correctly and only affects visible rows. 2) When rows are hidden manually: - Pasting still affects hidden rows, which is inconsistent with the filtered case. This suggests that Calc already supports correct behavior (visible-only paste), but only when the target range is explicitly defined as visible cells. It would be useful to clarify whether the patch addresses: - only the "multiple selection" error, or - also the inconsistency between filtered and manually hidden rows.
In WPS Office, if you try to merge cells with different values in it, it shows a dialog with different ways of combining them. Maybe a dialog with explanation what is going to happen will save users from total frustration. It shoud say something like: "When copying a range from a filtered table (or a range with hidden rows/columns) to a filtered table (or a range with hidden rows/columns), the range will be copied "as you see it" (i.e., without taking invisible cells) and placed into the range "as you see it" (that is, affecting only those cells that are visible to you right now), click here to continue" Click here to do it the "Excel way" [Cancel]
(In reply to Plavozont from comment #11) And by the way, this feature will allow to replace formulas with it's values right over the filter (you filter, select, copy, paste values). I always have to clear the filter first and then copy/paste values to get rid of formulas, it is not comfortable at all :)
(In reply to gmolleda from comment #10) > There seem to be two different cases involved here: > > 1) When rows are hidden by filter: > - Pasting into a filtered range may fail with "Cannot insert into > multiple selection". > - However, if only visible cells are explicitly selected before pasting, > the operation works correctly and only affects visible rows. > > 2) When rows are hidden manually: > - Pasting still affects hidden rows, which is inconsistent with the > filtered case. > > This suggests that Calc already supports correct behavior (visible-only > paste), but only when the target range is explicitly defined as visible > cells. > > It would be useful to clarify whether the patch addresses: > - only the "multiple selection" error, or > - also the inconsistency between filtered and manually hidden rows. Inconsistency also matters, because when you paste something and there are hidden rows/cols and you didn't know about it, you may not notice that part of what you pasted is invisible, so there should be a kind of warning to inform about that too (a dialog with options). About "multiple selection" error - pasting only visible data into only visible cells should work both when range is selected and if it's not - the dialog that offers the method of pasting should appear.
It is the same case when Hidden Columns is in effect. Neither selecting the different target destinations (using CTRL key) nor using the menu entry Select Only Visible Columns it is possible to paste into a range with hidden columns. Version: 26.2.4.2 (X86_64) Build ID: 620(Build:2) CPU threads: 16; OS: Linux 6.18; UI render: default; VCL: kf6 (cairo+xcb) Locale: es-MX (en_US.UTF-8); UI: en-US 26.2.4-3 Calc: threaded
The same issue also exists with manually hidden rows, not only hidden columns. In addition, it would be useful if pasting into a multiple selection of visible cells (e.g. after using Select Only Visible Rows/Columns) were supported. At the moment, even after selecting only the visible cells, pasting into that multiple selection is not possible. It would be great if both manually hidden rows and columns were handled consistently and if pasting into multiple visible selections were supported as well.