Bug 166780 - calc ; données ; AutoFiltre ; Elément à rechercher
Summary: calc ; données ; AutoFiltre ; Elément à rechercher
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.7.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-05-29 07:33 UTC by ROCHET JJ
Modified: 2025-12-27 03:24 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
bug166780 submitted (306.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-05-29 14:02 UTC, ROCHET JJ
Details
feuille dans CALC (306.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-05-29 14:05 UTC, ROCHET JJ
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ROCHET JJ 2025-05-29 07:33:59 UTC
Description:
dans une colonne de chiffres différents et/ou vide, ne retrouve pas "1465" en cellule D2215 directement. Le filtre ne peut le retrouver qu'en tapant "465"

Actual Results:
problème rencontré pour la première fois par utilisateur régulier et mettant à jour avec la dernière version la plus fiable : A ce jour, LibreOffice 24.8

Expected Results:
correction bug ; amélioration version ultérieure


Reproducible: Always


User Profile Reset: No

Additional Info:
néant
Comment 1 Julien Nabet 2025-05-29 12:00:57 UTC
Pourriez-vous joindre le fichier dans le bugtracker en utilisant le lien https://bugs.documentfoundation.org/attachment.cgi?bugid=166780&action=enter

Attention, le fichier sera alors public, s'il contient des informations sensibles et/ou privés, il faudra d'abord le "sanitiser" (cf ce lien :
https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission)
Comment 2 ROCHET JJ 2025-05-29 14:02:43 UTC
Created attachment 201031 [details]
bug166780 submitted

Bug : 
retrouver 1465 en colonne D avec l'autofiltre 

si on tape 1465, une autre proposition est faite
Pour le retrouver il faut taper dans l'autofiltre : 465
Comment 3 ROCHET JJ 2025-05-29 14:05:32 UTC
Created attachment 201032 [details]
feuille dans CALC
Comment 4 Julien Nabet 2025-05-29 19:38:02 UTC
Merci pour le retour. Apparemment, c'est le format de cellule qui fait que la recherche ne fonctionne pas.
Si on change le format et qu'on met le format nombre par défaut, cela fonctionne.
Par contre, je pense que le filtre ne devrait pas tenir compte du format.
Je vais demander confirmation.


On pc Debian x86-64 with master sources updated today, I could reproduce this.

Xisco: D2215 containing "1465" doesn't appear when typing "1465" in the autofilter and it appears if typing just "465".
I noticed that if I format D2215 as simple Number, the autofilter will work.
Now, is it expected autoformat takes into account the format of the cell?
Comment 5 QA Administrators 2025-11-26 03:41:53 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2025-12-27 03:24:16 UTC
Dear ROCHET JJ,

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