Bug 144308 - Changing the DoAutoComplete attribute of the GlobalSheetSettings interface does not affect automatic completion of text in a cell is used.
Summary: Changing the DoAutoComplete attribute of the GlobalSheetSettings interface do...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: All All
: medium normal
Assignee: Mike Kaganski
URL:
Whiteboard: target:7.4.0
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-05 09:55 UTC by Vladimir Sokolinskiy
Modified: 2023-10-31 05:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Vladimir Sokolinskiy 2021-09-05 09:55:30 UTC
Steps to reproduce.
1. Create new Calc document. Check item Menu / Tools / Autoinput
2. Type in cell A1 "abcd". Type in cell A2 "a". Autocomplete works (text "bcd" is shown).
3. Run Macro

Sub Test
  CreateUnoService("com.sun.star.sheet.GlobalSheetSettings").DoAutoComplete=False
End Sub

4. Now item Menu / Tools / Autoinput is unchecked. But autocomplete still works...

Interactive switching of the Autoinput menu item works correctly.
Comment 1 Mike Kaganski 2021-11-29 10:12:08 UTC Comment hidden (obsolete)
Comment 2 Mike Kaganski 2021-11-29 10:15:19 UTC Comment hidden (obsolete)
Comment 3 Roman Kuznetsov 2021-11-29 18:06:21 UTC
https://gerrit.libreoffice.org/c/core/+/126002
Comment 4 Commit Notification 2021-11-29 20:32:13 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

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

tdf#144308: don't cache DoAutoComplete/AutoInput in ScInputHandler

It will be available in 7.4.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 5 Commit Notification 2021-11-30 17:50:31 UTC
Xisco Fauli committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/0cda0b47b171671b2d4d081c02e039dfda89839b

tdf#144308: sc_uicalc: Add unittest

It will be available in 7.4.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 6 Vladimir Sokolinskiy 2021-11-30 18:31:43 UTC
Colleagues, thank you very much!