Bug 83104

Summary: EDITING: Calc text auto completion does not avoid suggestions starting with numbers
Product: LibreOffice Reporter: Zeki Bildirici <kobzeci>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: erack, kohei, markus.mohrhard, raal
Priority: medium    
Version: 4.3.0.4 release   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=38643
Whiteboard: BSA
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103341    
Attachments: Calc and Excel auto completion comparison

Description Zeki Bildirici 2014-08-26 15:22:54 UTC 
Problem description: 

Hi,

Currently Calc auto completion does not avoid numbers. When you entered a cell beginning with number and followed by text, calc will try to autocomlete the cells which starts the number entered previously.

For example if you type ''1. Month'' or ''7000 bullets'' to A1, Calc will autocomplete every cell which starts with 1 or 7

This is really annoying because if you have a table with rows/coloums text+number combination every number entry will suggest you the label again. Also it is forcing users to make mistake, every number you'll need to click backspace and make sure it is "the number" and slows the user.

I am attaching a screenshot for Calc vs Ms Excel autocompletion comparison.



Steps to reproduce:
1. Type a number+ text(or sign) combination to a cell
2. Type the number and see the autocompletion suggestion

Current behavior:

Numbers are not avoided

Expected behavior:
Autocompletion suggestions which are starting with numbers are disabled.             
Operating System: All
Version: 4.3.0.4 release
Comment 1 Zeki Bildirici 2014-08-26 15:23:52 UTC 
Created attachment 105291 [details]
Calc and Excel auto completion comparison
Comment 2 Zeki Bildirici 2014-08-26 15:24:53 UTC 
Comment on attachment 105291 [details]
Calc and Excel auto completion comparison

Calc starts to make suggestion with when you type "1", but Excel starts when you type "1. M"
Comment 3 raal 2015-04-27 12:26:05 UTC 
Valid enhancement, setting to new.