Calc Wrong number of selected rows using AutoFilter (Bug)

asked 2020-11-16 01:26:33 +0100

sete gravatar image

Hi! Let's say there's a table with 10 lines. Let's set an autofilter where you can see only lines 2, 4, and 6. Then, if you select lines 4 and 6 the status bar shows this:

Selected: 3 rows

That is wrong. There are only 2 rows selected. I guess the application counts from 4 to 6 which would be 3 rows. Then if you apply a different background color to the selected rows and then deactivate the filter, only those 2 rows will have the new color, which is right. So there were only 2 rows selected.

I asked a similar question last week and saw that my question was finally a bug. I reported and receive confirmation that it was a bug but it was already reported a long time ago. I guess this is another bug but I haven't found any information about it. I'm using LibreOffice

edit retag flag offensive close merge delete


Does anyone else see this problem?

sete gravatar imagesete ( 2020-11-16 12:20:13 +0100 )edit

Can confirm you describe what it shows and that in fact only 2 rows are selected (didn't test with colorization but using copy&paste to another sheet). Hence: Yes - the number of selected rows in status bar is wrong.

Opaque gravatar imageOpaque ( 2020-11-16 12:46:35 +0100 )edit

Look like this reported bug tdf#138264

m.a.riosv gravatar imagem.a.riosv ( 2020-11-16 19:47:30 +0100 )edit

Yes, I failed again. I reported it and it was already there. No matter how much time I spend looking for it, I never locate anything about the bug I've found. I'll have to improve my skill in looking for bugs reported.

sete gravatar imagesete ( 2020-11-17 11:12:04 +0100 )edit

Just for reference purposes: #tdf84517 is the related bug report addressing this issue for the first time.

Opaque gravatar imageOpaque ( 2020-11-17 11:26:15 +0100 )edit