In earlier versions of LibO-Calc the hidden cells (e.g. via filter) were not copied, so that you could continue working with the visible cells. In version 184.108.40.206 the hidden cells are also copied. How can one copy only the visible cells in version 220.127.116.11?
My question is not really answered in the original bug (36466), but in the meantime I found that it works again with the mentioned Extensison, in version 2.
i cannot reproduce with:
Version: 18.104.22.168 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: de-DE (de_DE); Calc:
with applied autofilter:
- only visible rows are copied.
without autofilter and manually hidden rows:
- visible and hidden rows are copied
for me this works like expected.
Please attach a sample document, as this makes it easier for us to verify the bug.
(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.)
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
It seems to be due to the receiving table what is important after copying. Once the content has been pasted into a table that *unfiltered* records and displays everything, the copy is also pasted unfiltered into the source table (on a second sheet). In the same worksheet, pasting works correctly the first time.
Created attachment 148285 [details]
copying table with autofilter
Created attachment 148286 [details]
Could you please add a detailed description how the bug can be reproduced
with attached documents?
I have set the bug's status to 'NEEDINFO'.
Please change it back to 'UNCONFIRMED' once the requested info is provided.
Download the two files. Open the file copying_table.ods, e.g. select all records with the autofilter where the field 'valid to' is empty. Then select the cells E176 to A1 and copy them with <strg><c>. Then open the file receiving_table.ods, and press with selected cell A1 <strg><v> to paste the copied cells. Then you will see ALL entries in column E, including the filtered records with a value in column 'valid to'.
Created attachment 148288 [details]
- open "copying_table.ods"
- select "Empty" from column E
- select A1:E176
- open "receiving_table.ods"
- select A1
- result: A1:E99 is filled with copied data
as shown in attached "receiving_table_after_copy.ods"
Funny, now it's possible here too ... no idea why it did not work before and ALL records were displayed after inserting ... Strange, but thanks for trying it out!