Bug 104078 - Sorting of cells in find all results
Summary: Sorting of cells in find all results
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.2.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Find-Search
  Show dependency treegraph
 
Reported: 2016-11-21 09:57 UTC by Mark van Rossum
Modified: 2020-03-01 09:11 UTC (History)
2 users (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 Mark van Rossum 2016-11-21 09:57:17 UTC
Hi

'Find all' in Calc returns a list of results.

If you sort this list on cells, it sorts this list alphabetically instead of numerically.
E.g. the return list is
$A$1
$A$11
$A$2

Instead, it would be more logical to return:
$A$1
$A$2
$A$11
Comment 1 m_a_riosv 2016-11-26 14:20:54 UTC
Reproducible.
Version: 5.3.0.0.alpha0+ (x64)
Build ID: 170105956f843047d4c79657584f0c01aa7814c7
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; 
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2016-08-19_17:41:46
Locale: es-ES (es_ES); Calc: group
Comment 2 QA Administrators 2017-11-27 09:59:03 UTC Comment hidden (obsolete)
Comment 3 Thomas Lendo 2020-03-01 09:11:03 UTC
Not reproducible with
Version: 6.3.5.2 (x64)
Build-ID: dd0751754f11728f69b42ee2af66670068624673
CPU-Threads: 4; BS: Windows 10.0; UI-Render: GL; VCL: win

Closing as Worksforme.