https://bugs.documentfoundation.org/show_bug.cgi?id=147541
Bug ID: 147541
Summary: Calc does correctly sort when using multiple sorting
parameters.
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When I use multiple sort parameters in Calc the ending spreadsheet has data
placed erroneously in different cells than they are supposed to be in (not all
of them though). I have also noticed that some entire rows of data also come
up missing. The ending data output is not correct or reliable.
Steps to Reproduce:
1.Spread sheet with multiple columns and rows of data. Output data at end of
rows via formulas. Include dates, accounts, prices, quantities, etc.
2.Select rows and columns to sort.
3.Sort by at least 3 column parameters.
Actual Results:
Incorrect data inserted to wrong rows/cells distorting the output data.
Expected Results:
Sorting of data by rows with data integrity of each row maintained during the
sort.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Rows should have maintained correct data in their correct cells while be
sorted. I use the sheets to keep track of options being trades. Each row is
one option. Each column is a piece of info for each row/option. All the rows
get sorted according to: 1) account, 2) ticker symbol, and 3) the date the
option was started. Other column data is price, share price, strike price,
number of contracts, amount of premium, expiration date, and total premium.
Output data consists of total profit or loss, percentage of profit/loss made,
and annualized percentage.
--
You are receiving this mail because:
You are the assignee for the bug.
