Issue 102849 - resetting subtotals resorts data in Calc but leaves formatting on wrong rows
Summary: resetting subtotals resorts data in Calc but leaves formatting on wrong rows
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.0-dev
Hardware: PC (x86_64) Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-06-17 03:35 UTC by pcowley
Modified: 2013-11-25 11:07 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
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