Issue 114913 - Freezing rows directly below a filter row and then sorting results in an unfrozen row replacing the filter row
Summary: Freezing rows directly below a filter row and then sorting results in an unfr...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2.1
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-10-04 22:19 UTC by gwilson2151
Modified: 2013-10-04 11:43 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Example of defect with issue 114913. (80.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-10-04 22:21 UTC, gwilson2151
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description gwilson2151 2010-10-04 22:19:32 UTC
I have a spreadsheet that has two frozen header rows, one with column
descriptions and a filter row below it, with the rest of the data below it.  If
I select a cell and then sort by that column the first row of the data set will
be put in place of the filter row.  I'm going to try to attach a spreadsheet
that displays this behaviour.  If I'm successful the steps to reproduce this
will be as such:

1. Select a cell in a column.
2. Press the Z->A or A->Z sort button.
3. Observe the first row (Alex Ovechkin) is now replacing the filter row and is
in the second of the rows that was frozen.

Note: this spreadsheet was originally an Excel spreadsheet but has been
converted to .ods and it still happens so I'm assuming it is a flaw in Calc.  I
can provide the original .xls if necessary.
Comment 1 gwilson2151 2010-10-04 22:21:27 UTC
Created attachment 71936 [details]
Example of defect with issue 114913.
Comment 2 Edwin Sharp 2013-10-04 11:43:59 UTC
As given in description.

AOO401m5(Build:9714)  -  Rev. 1523756
2013-09-16 20:50:21 (Mo, 16 Sep 2013)
Win 7