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...
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Example of defect with issue 114913. (80.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-10-04 22:21 UTC, gwilson2151 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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