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

2017-11-05 Thread Michael D. Setzer II
On 6 Nov 2017 at 4:24, Brian Barker wrote: Date sent: Mon, 06 Nov 2017 04:24:47 + To: users@global.libreoffice.org From: Brian Barker Subject:Re: [libreoffice-users] Calc: Autofilter sorting fails to expand selection

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

2017-11-05 Thread Brian Barker
At 19:42 05/11/2017 -0700, Jim Gallagher wrote: 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

[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