Bug 105569 - sort criteria for text columns
Summary: sort criteria for text columns
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.4.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-27 14:17 UTC by Bruce Funk
Modified: 2017-08-30 19:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
screenshot of “sorted” spreadsheet (482.91 KB, application/pdf)
2017-01-27 14:17 UTC, Bruce Funk
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Bruce Funk 2017-01-27 14:17:13 UTC
Created attachment 130720 [details]
screenshot of “sorted” spreadsheet

Damn!
this is the most user unfriendly bug report system i’e encountered in 40 years (and I’m an IT professionsal that designs systems)
obviously designed with no actual user input!

So, the problem i’m actually trying to report:
The sort criteria for text fields is inconsistent
on one page in a spreadsheet a text field comprisd of numeric zeroes is sorted first
on another page in the same worksheet, text with leading zeroes is sorted second.and 
in one sheet, text, in ccluding null values, is sorted mixed, with text with leading zeroes intermixed with null text and text with no leading zero characters.]

trying to attach a screen shot
Holy Crap!
I can’t upload a screen shot ????
I have to give you a link to publicly access my computer or my dropbox?

This is the most out of touch bug report system I’ve seen !!!
I would have thought you would have beenon the leading edge of customer UI / experience
Booooo!!
Comment 1 V Stuart Foote 2017-01-27 15:31:19 UTC
Best if you can "add an attachment" of a sample Calc .ODS document (yes, depending on how you reach the BZ submission you may or maynot have the option while creating the report, but trivial to add to an established issue).

What values have you set on each of the columns in your screen clip?

Sorting will be dependent on the cell value type set for the column on the sheet.

Please provide a sample document (or just some sheets with values redacted) with column types set and the sort issues you claim.

Sorry, but as is we can't do a thing with this report.
Comment 2 QA Administrators 2017-07-27 12:06:35 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2017-08-30 19:31:59 UTC
Dear Bug Submitter,

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-20170830