Apache OpenOffice (AOO) Bugzilla – Issue 32533
Sorting table data: allow row attributes to follow data
Last modified: 2013-02-07 22:33:18 UTC
When sorting a table which has rows colors based on the data in the table, the row background color (or other attributes) MUST follow the data, or the information they convey will be WRONG. Since there are valid reasons for coloring rows based on both data (all rows with negative amounts) and position (alternate row shading for ease of reading), I think and enhancement would be appropriate: a checkbox in the sorting dialog to allow row attributes to follow the data. In the sample table attached, blue background indicates negative amounts. Once the table is sorted, the blue color now highlights the wrong row. Using the paragraph background is a poor workaround, although it does follow the text, it doesn't fill the table cells.
Ok, why can't I file an attachment? Here's a url: http://pcsb620.tju.edu/~jes/Table_sort_problem_32533.sxw
MRU->BH: A request, that table background colors should be taken in mind, when table content is sorted and recieves a new position in the table. Colors should stick to the referring content.
Created attachment 40000 [details] sample table showing desired behavior
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".