Download it now!
Bug 97969 - Hidden rows sometimes not ignored during column sort
Summary: Hidden rows sometimes not ignored during column sort
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-UX Sorting
  Show dependency treegraph
Reported: 2016-02-18 10:03 UTC by devel
Modified: 2019-09-11 20:19 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

File to reproduce in LibreOffice by sort descending on Column1 (36.44 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-02-18 10:03 UTC, devel

Note You need to log in before you can comment on or make changes to this bug.
Description devel 2016-02-18 10:03:15 UTC
Created attachment 122755 [details]
File to reproduce in LibreOffice by sort descending on Column1

Opening an Excel file with a table, with filter/sort headings, and several hidden rows. When sorting by a column of this table, the hidden rows are not ignored during the sort, which means hidden entries are actually moved out of the hidden rows and into visible rows, and visible entries are moved out of visible rows into hidden rows.

In Excel it ignored hidden rows so you can hide values you don't care about and still sort, and the sort only applies across the visible rows. In LibreOffice this is impossible to do, during sorting you begin to see entries disappear and other entries you'd previously hidden appear again.

Attached Excel file reproduced the problem in LibreOffice 5.2.2 on Mac OS X El Capitan (Public Beta 2, 10.11.4). The file is pre-sorted in Excel as sort descending on Column1. Opening in LibreOffice it shows fine, but if you re-apply the sort descending on Column1 you can immediately see the problem - row 8 now shows a previously hidden row.
Comment 1 Buovjaga 2016-02-20 15:41:05 UTC

Win 7 Pro 64-bit, Version: (x64)
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
Locale: fi-FI (fi_FI)

Build ID: ef02de2698d90fd874bddf3146165cbe85487bc5
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-19_23:40:50
Locale: fi-FI (fi_FI)
Comment 2 QA Administrators 2017-03-06 14:51:52 UTC Comment hidden (obsolete)
Comment 3 Thomas Lendo 2017-03-06 20:05:36 UTC
Reproduces with LibO
Build ID: 1:5.3.0~rc3-0ubuntu1~trusty1.1
CPU Threads: 2; OS Version: Linux 3.13; UI Render: default; VCL: gtk2; Layout Engine: new; 
Locale: de-AT (de_DE.UTF-8); Calc: group
Comment 4 QA Administrators 2018-05-31 02:52:25 UTC Comment hidden (obsolete)
Comment 5 Timur 2018-05-31 16:09:05 UTC
From OO to 6.2+. Special case, we need to know which.
Comment 6 QA Administrators 2018-06-01 02:17:08 UTC Comment hidden (obsolete)
Comment 7 Thomas Lendo 2019-09-11 20:19:55 UTC
Reproduced with Version:
Build ID: f76dbe5dc581845996a8bd5f5109c5e2ff5a27b0
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-09-09_05:13:31