1. Name a cell 'foo1' 2. Name another cell 'my_favorite' 3. Start typing a formula: =my_f Range name autocompletion will suggest 'foo1' and choosing it results in 'my_foo1' Instead, I expect 'my_favorite' to be suggested.
Scott: I think there's something I'm missing. When I follow your steps, autocompletion suggest "=MAX(", because of the formula "MAX", but nothing with "foo1". When I start to type "my" on a cell in Calc, it suggest "my_favourite" as the cell on step 2.
(In reply to comment #1) > When I start to type "my" on a cell in Calc, it suggest "my_favourite" as > the cell on step 2. Yes, but the issue is that when you've typed 'my_f' the suggestion is 'foo1'; imagine the set of names is: foo1 my_cat ... my_favourite my_food ... Now when you type 'my_f' you want to be able to choose between my_favourite and my_food but what you get is 'foo1' (In my actual spreadsheet I have 150+ names (not all with the same prefix, though).)
I'm able to confirm this on 3.6.6.2 release, updating version as version reflects oldest version that we see the issue - this is likely even older, maybe all the way back to beginning of LibreOffice days but I don't have the means to test that assumption right now. Marking as: New Minor - doens't prevent high quality work, but can slow it down a little Low - default seems appropriate, relatively easy to workaround this issue. ProposedEasyHack
Sorry forgot to say: Bodhi Linux x64 LibreOffice Version Tested: 4.0.3.3 release & 3.6.6.2 release
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval. Thank you and apologies for the noise
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.