Bug 167395 - Using the Lock feature in an AutoFilter with dates causes a crash
Summary: Using the Lock feature in an AutoFilter with dates causes a crash
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 beta1+
Hardware: x86-64 (AMD64) All
: highest critical
Assignee: Sahil Gautam (Collabora)
URL:
Whiteboard: target:26.8.0 target:26.2.3
Keywords: haveBacktrace, implementationError
: 169594 (view as bug list)
Depends on:
Blocks: AutoFilter Crash
  Show dependency treegraph
 
Reported: 2025-07-05 18:32 UTC by Andreas Säger
Modified: 2026-04-09 13:45 UTC (History)
8 users (show)

See Also:
Crash report or crash signature: ["SvTabListBox::GetEntryText(SvTreeListEntry%20const%20*,unsigned%20short)"]


Attachments
Screen recording (1.50 MB, image/gif)
2025-07-05 18:32 UTC, Andreas Säger
Details
My test document (58.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-07-05 18:34 UTC, Andreas Säger
Details
GDB trace of crash (22.34 KB, text/plain)
2025-11-23 16:53 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas Säger 2025-07-05 18:32:36 UTC
Created attachment 201671 [details]
Screen recording

See screen recording where I just pick arbitrary year entries from a date column, click the new "Lock" option, then OK and the application crashes.
Comment 1 Andreas Säger 2025-07-05 18:34:52 UTC
Created attachment 201672 [details]
My test document

Test document with a database range "Import1" and auto-filter set.
Comment 2 m_a_riosv 2025-07-06 00:45:59 UTC
Reproducible

Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 36a55369a6ac72ae985cf31405b7f52686665d84
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (es_ES); UI: en-US
Calc: CL threaded

Versions with Lock option crash, it has begun with 24.2
Comment 3 Buovjaga 2025-11-23 16:50:49 UTC
Implemented in bug 133836
Comment 4 Buovjaga 2025-11-23 16:50:59 UTC
*** Bug 169594 has been marked as a duplicate of this bug. ***
Comment 5 Buovjaga 2025-11-23 16:53:31 UTC
Created attachment 204229 [details]
GDB trace of crash
Comment 6 Sahil Gautam (Collabora) 2025-12-02 11:42:01 UTC
@Andreas thanks for reporting the issue, i can reproduce it. back when i implemented it, i was a half baked programmer, not that things have changed drastically since then ;). i will push a fix shortly :).
Comment 7 Sahil Gautam (Collabora) 2025-12-02 12:32:09 UTC
I remember now, (after looking at the code), in the code, there's this condition which checks if the entry is a date or not, and i had no idea on how to handle dates, so i only added the lock related code for entries which are not dates :).
Comment 8 Commit Notification 2025-12-11 12:21:26 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/3f4c2bd3e3e712316e0d46b4f803b3bdc4f6ee5c

Related tdf#167395: Break out of the loop after the entry has been found

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 9 Commit Notification 2025-12-11 12:21:29 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/b3fc9d9280076973bcc47c3fbb03fc179ec17e26

Related tdf#167395: Use descriptive variable name for returned value

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 10 Commit Notification 2025-12-11 12:21:31 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/3a51cd8cb3cc40615c86d1a158c0135b4f27a3ef

Related tdf#167395: Formatting change

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 11 Commit Notification 2025-12-11 12:22:34 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/4ea90e89422bd5dc5a31a986e8f6007c89df77da

Related tdf#167395: Remove unnecessary variable `mbChecked`

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 12 Commit Notification 2025-12-11 12:22:37 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/a034a2bce6d4cf5bb6de850c4d4367f91a8a9300

Related tdf#167395: Add comments, make variable names readable

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 13 Sahil Gautam (Collabora) 2025-12-11 12:26:08 UTC
this would take a little while, maybe a week or two. i pushed some code improvements, added a lot of comments. if someone wants to work on it in the meantime, please do so. these commits should make the code a little more readable.
Comment 14 Commit Notification 2026-03-16 13:58:33 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/26c15c6f6b531f6932628f05ce26c77746fe8c3f

Related: tdf#167395 avoid crash by skipping the code when mbHasDates

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 15 Commit Notification 2026-03-16 13:59:36 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/f591aae9103464a803cf2af7224c644937c94fff

Related: tdf#167395 add MarkCheckedMembers to mark checked entries

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 16 Commit Notification 2026-03-16 13:59:39 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/3c47aa01cc0700f235bb5fee1f88d1dac52dcb2c

Related: tdf#167395 pass lowercase search text to loadSearchedMembers

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 17 Commit Notification 2026-03-16 13:59:42 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/7d63f9fc615cba1cdc2c28b7c66901ab102b790f

Related: tdf#167395 refactor shared code into UpdateVisibleMembers

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 18 Commit Notification 2026-03-16 14:00:45 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/cf3bc0d74f14f83b9b3cb77f18352304ab2a546e

Related: tdf#167395 don't disable the date entries unnecessarily

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 19 Commit Notification 2026-03-16 14:00:47 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/d81d50be930f9b91e1ee20ad664c5387eb19583c

fix: tdf#167395 make lock work with hierarchies of dates

It will be available in 26.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 20 Xisco Faulí 2026-03-26 15:07:10 UTC
@Sahil, is this issue fixed now ?
Comment 21 Sahil Gautam (Collabora) 2026-03-27 05:39:58 UTC
(In reply to Xisco Faulí from comment #20)
> @Sahil, is this issue fixed now ?

yes, it doesn't crash with dates anymore, and locking works as expected.
Comment 22 Buovjaga 2026-03-27 08:52:14 UTC
(In reply to Sahil Gautam (Collabora) from comment #21)
> (In reply to Xisco Faulí from comment #20)
> > @Sahil, is this issue fixed now ?
> 
> yes, it doesn't crash with dates anymore, and locking works as expected.

Then please close as fixed :)
Comment 23 Commit Notification 2026-04-08 10:58:36 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/5cc4b06da962a02ebd41fcb84c9a682b79b03b70

Related tdf#167395: Break out of the loop after the entry has been found

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 24 Commit Notification 2026-04-08 10:58:39 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/feea317ac9c1f16ce49dad22b7f9cc3ebdb7ffe9

Related tdf#167395: Use descriptive variable name for returned value

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 25 Commit Notification 2026-04-08 10:59:42 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/31700187ad619aadb0fa3027283233cf4c5c6b6e

Related tdf#167395: Formatting change

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 26 Commit Notification 2026-04-08 10:59:44 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/e9a4617580493163a865af2ae472906373456f56

Related tdf#167395: Remove unnecessary variable `mbChecked`

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 27 Commit Notification 2026-04-08 10:59:47 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/ef7033392c8d363cf758a29ef434aa1aa6ee9874

Related tdf#167395: Add comments, make variable names readable

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 28 Commit Notification 2026-04-08 11:00:50 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/7711639e0c5a2d690981cb3d41139473fb996a48

Related: tdf#167395 avoid crash by skipping the code when mbHasDates

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 29 Commit Notification 2026-04-08 11:00:53 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/5693eb822e351342d17d51db0e29d8a9d1dc6050

Related: tdf#167395 add MarkCheckedMembers to mark checked entries

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 30 Commit Notification 2026-04-08 11:01:56 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/a1162bb2dd2ca55ce428d2a07af41aa9b92982ea

Related: tdf#167395 pass lowercase search text to loadSearchedMembers

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 31 Commit Notification 2026-04-08 11:01:58 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/a7a27b09cc5416c51883b3e026e08253a696014e

Related: tdf#167395 refactor shared code into UpdateVisibleMembers

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 32 Commit Notification 2026-04-08 11:03:01 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/385def53e76d7cf1472ebceced1e595692e17ec9

Related: tdf#167395 don't disable the date entries unnecessarily

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 33 Commit Notification 2026-04-09 13:45:38 UTC
Sahil Gautam committed a patch related to this issue.
It has been pushed to "libreoffice-26-2":

https://git.libreoffice.org/core/commit/db993eaf302015f11c5c9a7c8c4c43be01b7ba8a

fix: tdf#167395 make lock work with hierarchies of dates

It will be available in 26.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.