Ask Your Question

Trying to use advanced data filter in calc

asked 2021-02-22 03:35:04 +0100

alex4orly gravatar image

Using KDE Neon Plasma 5.21 Libreoffice version of is calc I have a large spreadsheet, close to 900,000 records and need to extract a subset of the data.

I followed the steps, looks simple, but all that I get after I click ok is the column heading names, without any Data (I expect about 220 records).

Any suggestions?

Thanks Alex

edit retag flag offensive close merge delete


needs more detailed explanation or a sample of your file, not the 900k records, just some dozen and the filter definition ...

newbie-02 gravatar imagenewbie-02 ( 2021-02-22 21:07:58 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-02-23 07:32:40 +0100

alex4orly gravatar image

Thanks for the feedback,

I found out in the meantime that in order to get a result, I had to check some "Options" in Libreoffice->Calc Wild cards

Thanks again All OK

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-02-22 03:35:04 +0100

Seen: 20 times

Last updated: Feb 23