Bug 142472 - Weird autocomplete for range names starting with "Ma"
Summary: Weird autocomplete for range names starting with "Ma"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: implementationError
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
 
Reported: 2021-05-25 05:25 UTC by Dan Dascalescu
Modified: 2026-03-05 03:13 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Screencast (49.12 KB, image/gif)
2021-05-25 05:25 UTC, Dan Dascalescu
Details
cell name MAPS (227.66 KB, image/png)
2021-06-03 22:04 UTC, paulo g.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dan Dascalescu 2021-05-25 05:25:42 UTC
Created attachment 172309 [details]
Screencast

I want to create a range name called "MAPS". When I start typing that, Calc autocompletes to "Manage names..." even if I type in all capitals. The result will be "MaPS".
Comment 1 Roman Kuznetsov 2021-05-30 18:57:29 UTC
confirm for EN UI, but not for RU UI

Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 08e99279226206db8ce83cdebc4cf2994739e90b
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded


Caolan, can you please look at it. Thank you
Comment 2 Caolán McNamara 2021-05-31 13:56:24 UTC
Why me specifically ? Is there a commit of mine responsible for the current state ?
Comment 3 Roman Kuznetsov 2021-05-31 14:17:10 UTC
(In reply to Caolán McNamara from comment #2)
> Why me specifically ? Is there a commit of mine responsible for the current
> state ?

No, I thought you can look at it as UI guru. If I shouldn't do it, then sorry for the noise
Comment 4 paulo g. 2021-06-03 22:04:42 UTC
Created attachment 172601 [details]
cell name MAPS

The bug do not exist
Comment 5 Buovjaga 2021-06-04 06:40:49 UTC
(In reply to paulo g. from comment #4)
> Created attachment 172601 [details]
> cell name MAPS
> 
> The bug do not exist

Wrong, the bug still exists

Arch Linux 64-bit
Version: 7.2.0.0.alpha1+ / LibreOffice Community
Build ID: c6595e781cf20ab2825e9a2bd8592688f26448e3
CPU threads: 8; OS: Linux 5.12; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 3 June 2021
Comment 6 Buovjaga 2021-08-10 18:19:44 UTC
I used bibisect-43all to find out when Manage names was added: https://git.libreoffice.org/core/commit/74d3dd420bd80f88dd7e1078dd500aba8841aa44
Comment 7 QA Administrators 2023-08-11 03:05:41 UTC Comment hidden (obsolete)
Comment 8 Andreas Heinisch 2024-03-04 09:13:49 UTC
This is due to autocomplete in used in the input field. We could disable autocomplete in the range window, but I'm unsure of how it affects other use cases.
Comment 9 QA Administrators 2026-03-05 03:13:11 UTC
Dear Dan Dascalescu,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug