Issue 114913

Summary:

Freezing rows directly below a filter row and then sorting results in an unfrozen row replacing the filter row

Product:

Calc

Reporter:

gwilson2151 <gwilsonjr>

Component:

editing

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Normal

Priority:

CC:

elish, issues

Version:

OOo 3.2.1

Target Milestone:

---

Hardware:

OS:

Windows 7

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Example of defect with issue 114913.	none

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