Bug 161602 - Sort of data: dynamic table with daily column doesn't sort days correctly
Summary: Sort of data: dynamic table with daily column doesn't sort days correctly
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-16 16:38 UTC by renoub51@gmail.com
Modified: 2024-06-16 21:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
file with daily sorting for sum of impressions (23.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-06-16 16:38 UTC, renoub51@gmail.com 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.