Calc is not copying data correctly with AutoFilter

asked 2020-10-15 07:32:53 +0200

Frants gravatar image

updated 2020-10-15 13:37:59 +0200

The data in my Calc spreadsheet applies AutoFilter. If you copy data immediately after opening the table, then all data in the range is copied (this is wrong). If you delete or change the filter and then copy the selection, then only the selection is copied (as it should be). Why does the application work incorrectly with the filter after opening?

Version: (x64) Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); ИП: ru-RU Calc: threaded

edit retag flag offensive close merge delete


No problem seen in LibreOffice (x86); OS: Windows 6.1.

Try with another file to see if the same thing happens.

LeroyG gravatar imageLeroyG ( 2020-10-15 11:19:50 +0200 )edit

@Frants, Edit your question and add a Enter before the three hyphens. This will fix the font size. Thanks.

LeroyG gravatar imageLeroyG ( 2020-10-15 11:20:27 +0200 )edit

Forgot to clarify something! The original table in XLSX format. If the table is saved as an ODS, it works fine...

Frants gravatar imageFrants ( 2020-10-15 13:38:06 +0200 )edit

So, save in .ods format.

LeroyG gravatar imageLeroyG ( 2020-10-15 13:59:25 +0200 )edit

Yes, but that doesn't fix the error ...

Frants gravatar imageFrants ( 2020-10-15 14:20:51 +0200 )edit

hi, thanks for spotting this exotic bug, repro with ver. 7.1 from today, see ... comments don't accept attachments? :-(
would you like to file a bug report about it in - lo bug-tracker - , could help to improve calc ...

newbie-02 gravatar imagenewbie-02 ( 2020-10-15 18:28:18 +0200 )edit

Excuse me, I'm not a very experienced user. Which file to send, and how?

Frants gravatar imageFrants ( 2020-10-16 07:14:11 +0200 )edit

I roughly figure out what and how, created and sent a table file and a report.

Frants gravatar imageFrants ( 2020-10-16 08:32:58 +0200 )edit

just go to the linked site, register and login, and submit a new bug ...

newbie-02 gravatar imagenewbie-02 ( 2020-10-16 13:19:20 +0200 )edit

Thanks! Yes, I did that.

Frants gravatar imageFrants ( 2020-10-16 13:33:26 +0200 )edit