Issue 58931 - Should autocomplete function respect cell format type?
Summary: Should autocomplete function respect cell format type?
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2005-12-06 07:43 UTC by tuharsky
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description tuharsky 2005-12-06 07:43:39 UTC
User is editing his spreadsheet, in which he enters some cells, which contain
numbers at beginning, but also another symbols inside, for example "-". You can
imagine telephone numbers or so (555-55-5555).

He sets the format of these cells to be "text".

Then he formats other cells as "number" and writes some numbers into them. If
they match initial sequence of previously entered cells, the strings are
autocompleted even using strings from text cells.

There is a question: should autocomplete function insert strings to "number"
cells even in the case, that these strings originate in "text" cells? It may
annoy and/or lead to unexpected results in target cell..

Target cell type is unaffected (stays "number") which is correct IMO, because
user has chosen it and program should respect that.
Comment 1 lars 2005-12-06 17:59:39 UTC
confirming described behaviour on Windows XP Pro SP2 with OOo 2.0.1 RC2
Comment 2 frank 2006-02-17 15:11:36 UTC
one for the requirements team