Issue 102849

Summary:	resetting subtotals resorts data in Calc but leaves formatting on wrong rows
Product:	Calc	Reporter:	pcowley <pecowley>
Component:	formatting	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	elish, issues
Version:	4.1.0-dev
Target Milestone:	---
Hardware:	PC (x86_64)
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description pcowley 2009-06-17 03:35:53 UTC

I have a spreadsheet of names and addresses etc., ( ie. a Membership list) and I
find that if I add subtotals then later reset them it sorts the table by the
first column (the default action). However, I have some rows highlighted with a
background colour (ie expired or non-current members are marked with a coloured
background) and instead of the highlight staying with the correct records (the
spreadsheet was sorted by "year paid to" before resetting the subtotals) when
the subtotals are reset the highlights stay in the same place but all the data
is sorted differently.

The work around is to "delete" the sub totals.  But the behaviour is
disconcerting and if you don't notice, can make your data misleading.

I am using version OOO300m15 (Build: 9379)

Comment 1 Edwin Sharp 2013-11-25 11:07:23 UTC

Table does not return to its original state when Subtotals are removed.

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian