Bug 83104 - EDITING: Calc text auto completion does not avoid suggestions starting with numbers
Summary: EDITING: Calc text auto completion does not avoid suggestions starting with n...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
 
Reported: 2014-08-26 15:22 UTC by Zeki Bildirici
Modified: 2016-10-19 23:31 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc and Excel auto completion comparison (81.28 KB, image/jpeg)
2014-08-26 15:23 UTC, Zeki Bildirici
Details

Note You need to log in before you can comment on or make changes to this bug.
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.