Bug 147541 - Calc does correctly sort when using multiple sorting parameters.
Summary: Calc does correctly sort when using multiple sorting parameters.
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-19 20:04 UTC by vernice.potter.64
Modified: 2022-09-19 03:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description vernice.potter.64 2022-02-19 20:04:50 UTC
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.
Comment 1 Jean-Baptiste Faure 2022-02-19 20:37:22 UTC
Please attach a test file and explain step by step how you perform the sort.

Status has been set to NEEDINFO, please set it back to UNCONFIRMED once requested information has been provided.

Best regards. JBF
Comment 2 QA Administrators 2022-08-19 03:43:33 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2022-09-19 03:33:46 UTC
Dear vernice.potter.64,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp