[libreoffice-users] Re: Calc: Autofilter sorting fails to expand selection when a column has empty cells at the bottom

2017-11-06 Thread jmgallag
I expect it to work like a table in Excel. I believe others would expect the same as well. It is not logical that sorting the middle column sorts across less rows than on either side. -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to:

[libreoffice-users] Calc: Autofilter sorting fails to expand selection when a column has empty cells at the bottom

2017-11-05 Thread jmgallag
LibreOffice 5.4.2.2 Create a new spreadsheet. Three columns of data. Column A: col1, a, b, c, d Column B: col2, 1, 2, 3<--- leave cell B5 empty Column C: col3, z, y, x, w Select the 15 cells, select Data -> Autofilter. We have a 3 x 4 table with headings. Sort column A descending. Data in