Bug 154251 - Sorting error in spreadsheet
Summary: Sorting error in spreadsheet
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.1.2 release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-03-18 09:36 UTC by michel.flx
Modified: 2023-10-16 03:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
erreur de tri dans tableur, feuille de calcul mal triée (227.12 KB, image/png)
2023-03-18 09:36 UTC, michel.flx
Details

Note You need to log in before you can comment on or make changes to this bug.
Description michel.flx 2023-03-18 09:36:43 UTC
Created attachment 186042 [details]
erreur de tri dans tableur, feuille de calcul mal triée

Bonjour,

Je constate que le tableur ne fonctionne pas correctement car, lorsque je veux effectuer un tri croissant ou autre dans une feuille de calcul, en l'occurence un relevé bancaire, il y a une erreur dans le tri qui mélange les dates des opérations, voir la capture d'écran jointe.
Comment 1 V Stuart Foote 2023-03-18 16:28:41 UTC
That looks correct. Dates are just sorted descending in date order, format is MM/DD/YYYY. 

Can not confirm, if I duplicate and select column then apply the 'Sort Ascending' or the 'Sort Descending' button action from the standard toolbar the entire column of dates sorts to accordingly.

If the MM/DD/YYYY is not the date format you expect, be sure to set the column type to 'Date' and to check the Format code.

=-Google gloss-=
Cela semble correct. Les dates sont simplement triées par ordre décroissant de date, le format est MM/JJ/AAAA.

Impossible de confirmer, si je duplique et sélectionne la colonne, appliquez l'action du bouton "Trier par ordre croissant" ou "Trier par ordre décroissant" de la barre d'outils standard, la colonne entière de dates est triée en conséquence.

Si le MM/DD/YYYY n'est pas le format de date que vous attendez, assurez-vous de définir le type de colonne sur 'Date' et de vérifier le code de format.

Veuillez retester

=-testing-=

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a179f6c91692076e7e17babf4890638caa398384
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Comment 2 QA Administrators 2023-09-15 03:06:13 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2023-10-16 03:15:30 UTC
Dear michel.flx,

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