Bug 161602

Summary: Sort of data: dynamic table with daily column doesn't sort days correctly
Product: LibreOffice Reporter: renoub51 <renoub51>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: minor CC: miguelangelrv
Priority: medium    
Version: 24.2.4.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: file with daily sorting for sum of impressions

Description renoub51@gmail.com 2024-06-16 16:38:14 UTC 
Created attachment 194763 [details]
file with daily sorting for sum of impressions

DATA: Dynamic table : sort data

Generating a dynamic table from a calc table can't be sorted daily (monday to sunday) in french.
It generated a graphic sorted lundi, mardi, mercredi, jeudi, vendredi, dimanche et samedi.
That means monday, tuesday, wednesday, thursday, friday, sunday and saturday.

This disaccording to personnalize sorting which propose days sorted in right order.

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: CL threaded
Comment 1 m_a_riosv 2024-06-16 21:01:36 UTC 
Those days are the name of the day, not a true date formatted as weekday.
So they're sorted like any other text, no like dates.

Move the Jour-nb to the first column, and I think it works as you expect.
Comment 2 renoub51@gmail.com 2024-06-16 21:11:31 UTC 
Your explainations are ok.
It works with jour-nb in the first column : labels are written in day order.
You may close the ticket.
Thanks a lot.