https://bugs.freedesktop.org/show_bug.cgi?id=61634
Priority: medium
Bug ID: 61634
Assignee: [email protected]
Summary: Calc: Strange data subtotals auto range selection
issue
Severity: minor
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
There is some unusual relation between Data Sort and Data Subtotals that can
cause minor issues under certain circumstances. Here is an illustration:
* Create a new spreadsheet.
* Start in A1 and enter several names going down.
* Now start in B1 and enter several matching numbers going down.
* Data-> Sort and check that it automatically selects all your data.
* Also note in Options that "Range contains column labels" is unselected.
* Perform the sort for column A.
* Now insert a row before row 1 for a header row.
* Add appropriate headers, like "Name" in A1 and "Dollars" in B1.
* Data-> Subtotals
* Note that the first row is not included in the automatically selected range.
At this point is is impossible to perform the data subtotals correctly and you
have to cancel the whole operation.
The workaround is to select the range manually, BEFORE activating Data->
Subtotals. I have verified this is a regression from OpenOffice 3.2.1 which
did not have this problem.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
