[Libreoffice-bugs] [Bug 142145] UI - Sort suppresses the first output data row when there are multiple heading lines and the sort is done on a column with concatenated headings

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142145

Raymond Smith <raymond.macdonald.smith at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|1                           |0
             Status|NEEDINFO                    |UNCONFIRMED

--- Comment #7 from Raymond Smith <raymond.macdonald.smith at gmail.com> ---
I used the following procedure with the input file (attached file 1) :
Verify the print-range settings:
- Print range: $A1:$K107
- Rows to repeat: $1:$2
- Columns to repeat: none

Select all (click on top left-hand cell)

Select Data->Sort

Select Options, and then select:
- case sensitive
- range contains column headings
- Direction: Top to bottom (sort rows)

Select Sort Criteria, and then specify:
- Sort Key 1: PREVIOUS 7-DAY AVERAGE ▲ (column I)
  => Descending
- Sort Key 2: COUNTRY (column F) 
=> Ascending
The output file, incorrectly sorted, is attached (file 2)

When following the above procedure with Sort Key column J , the result is
correct (file 3)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210617/81deba05/attachment-0001.htm>