Difference between revisions of "AutoInput"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Issues: Added issue 77374 about URL recognition in Calc)
(Issues with discoverability)
 
(35 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
== Introduction ==
 
== Introduction ==
  
This page will discuss the user interface for the ''AutoInput'' feature in Calc and Writer (also known as auto-completion.)
+
This page will discuss the user interface for the ''AutoInput'' feature in Calc (also known as ''auto-completion''.)
  
 
Status: Work in progress.
 
Status: Work in progress.
Line 7: Line 7:
 
== How it works ==
 
== How it works ==
  
=== In Calc ===
+
=== When? ===
 
+
==== When? ====
+
  
 
In cell input mode or in edition mode when the cursor is at the end of the field.
 
In cell input mode or in edition mode when the cursor is at the end of the field.
  
==== What? ====
+
=== What? ===
  
 
The content of a cell above the edited cell, if not a formula.
 
The content of a cell above the edited cell, if not a formula.
Line 19: Line 17:
 
The name of named ranges (see {{Bug|73997}}) in formula edition or input mode.
 
The name of named ranges (see {{Bug|73997}}) in formula edition or input mode.
  
=== In Writer ===
+
== Issues ==
  
=== In other parts of OpenOffice.org ===
+
=== Remark ===
  
* In the Help system: in the search field, an auto-completion mechanism is used which is similar to AutoInput in Calc.
+
We list a lot of issues (see the [http://qa.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&issueidtype=include&issue_id=1342+3765+5743+7566+8453+17505+18748+23146+29042+34417+34418+40908+43108+47848+51483+51236+51483+52054+52784+55331+55652+56469+60144+69984+71138+73036+75413+76878+77373+77374+77763+80191+81213+82106+88908+89016+93483+96332 full list]). Many of these issues are closed as INVALID or WORKSFORME, but it is rather a consequence of unexperienced reporters setting the issue type as DEFECT instead of ENHANCEMENT. These issues and the associated discussions still are valuable for this evaluation.
  
== Issues ==
+
=== Issues with discoverability ===
  
We list a lot of issues (see the [http://qa.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&issueidtype=include&issue_id=3765+5743+7566+8453+17505+18748+34418+40908+47848+51483+51236+51483+52784+55331+60144+73036+75413+76878+77374+80191+82106+93483 full list]). Many of these issues are closed as INVALID or WORKSFORME, but it is rather a consequence of unexperienced reporters setting the issue type as DEFECT instead of ENHANCEMENT. These issues and the associated discussions still are valuable for this evaluation.
+
==== Discoverability of the menu entry ====
  
=== Issues with discoverability ===
+
* There is an '''unadapted intermediary step''' to find the AutoInput option in the menu: the option is located in {{Spec/menuitem|Tools > Cell content > AutoInput}}. This may seem illogical since the feature does not deal with cell content, but with the method used to input that content. For examples of users that do not find this menu entry, see {{Bug|40908}}, {{Bug|17505}} and {{Bug|93483}}.
 +
* The '''name of the feature''' is poorly chosen. It has consequences on discoverability because 'AutoInput' does not match the name most users spontaneously give to that feature when talking about it (which is 'auto-completion'.) As a consequence, users looking for the feature may ''not recognize that this is the feature they are looking for'' (see last comment in {{Bug|34417}}). The reason why 'AutoInput' has been preferred to auto-completion seems to be that it does not complete a word, but suggests previous input in a full cell. This is a questionable choice.
 +
 
 +
==== Lack of Feedback after input ====
  
* The feature is '''hard to find in the menu''' because of unadapted intermediary steps:
 
** '''In Calc''', the option is located in {{Spec/menuitem|Tools > Cell content > AutoInput}}. This is illogical since the feature does not deal with cell content, but about the method used to input that content. For examples of users that do not find this menu entry, see {{Bug|40908}}, {{Bug|17505}} and {{Bug|93483}}.
 
** '''In Writer''', the option is configured ''via'' a tab in the {{Spec/menuitem|Tools > AutoCorrect…}} dialog. But semantically, 'AutoInput' does not ''correct'' what the user has typed, it just helps her/him to enter it. So it is likely that many users wanting to configure AutoInput do not find where to make the changes (to do: look for issues).
 
* The '''name of the feature''' is poorly chosen, and it has consequences on discoverability, because it does not match the name spontaneously given by most users when talking about the feature, which is 'auto-completion'. As a consequence, users looking for the feature may ''not recognize that this is the feature they are looking for''. The reason why 'AutoInput' has been preferred to auto-completion in Calc seems to be that it does not complete a word, but suggests a previous input. This is a questionable choice for Calc, but there is no such argument for Writer.
 
 
* The '''lack of feedback''' explicating what happened after completion, may in many cases (such as {{Bug|47848}} or {{Bug|51483}}) prevent the user to understand the feature, or even that there is a feature. We then miss an occasion to learn the user a new feature.
 
* The '''lack of feedback''' explicating what happened after completion, may in many cases (such as {{Bug|47848}} or {{Bug|51483}}) prevent the user to understand the feature, or even that there is a feature. We then miss an occasion to learn the user a new feature.
* AutoInput in Calc uses the Sort Lists defined in {{Spec/menuitem|Tools > Options… > OpenOffice.org Calc > Sort Lists}} as sources for AutoInput, changing the capitalization accordingly (see {{Bug|3765}}). But it does not use it as a source for completion suggestions, so the user cannot know that this change of capitalization is done by AutoInput (and may think it is done by AutoCorrect such as in {{Bug|55331}}). The user then cannot know that it can be disabled with {{Spec/menuitem|Tools > Cell Content > AutoInput}}.
+
* AutoInput '''uses Sort Lists''' defined in {{Spec/menuitem|Tools > Options… > OpenOffice.org Calc > Sort Lists}} as sources for AutoInput, changing the capitalization accordingly (see {{Bug|3765}}). But it does not use it as a source for completion suggestions, so the user cannot know that this change of capitalization is done by AutoInput (and may think it is done by AutoCorrect such as in {{Bug|55331}}). The user then cannot know that it can be disabled with {{Spec/menuitem|Tools > Cell Content > AutoInput}}.
  
 
=== Issues with navigation ===
 
=== Issues with navigation ===
  
* In Calc: AutoInput prevents the use of the Tab key to change cell. See {{Bug|18748}} and {{Bug|7566}}.
+
* AutoInput prevents the use of the Tab key to change cell. See {{Bug|18748}} and {{Bug|7566}}. See also {{Bug|81213}}, which is a request for enhancement.
  
=== Issues with capitalization ===
+
=== Issues making difficult to enter content ===
  
* In Calc: when the word is written ''in extenso'', AutoInput has no other effect than changing capitalization. Many users then complains that it is not possible to enter some word with two different capitalizations in the same column, see {{Bug|73036}}, {{Bug|5743}}, {{Bug|47848}}, {{Bug|51483}}, {{Bug|51236}} and {{Bug|52784}}. See also {{Bug|60144}}, which is still open because it explicitly questions the fact that auto-completion should not occur when the word is typed ''in extenso''. [Note: actually, rules concerning capitalization are very unpredictable and depend upon the capitalization of both the first cell containing the text and the text typed, with different kind of capitalization (first letter, all caps, no caps at all…). It needs more work to tell exactly how it works.]
+
==== Difficulty to discard suggested completion ====
* AutoInput in Calc uses the Sort Lists defined in {{Spec/menuitem|Tools > Options… > OpenOffice.org Calc > Sort Lists}} as sources for AutoInput, changing the capitalization accordingly (see {{Bug|3765}}).
+
  
=== Issues with interpretation of content ===
+
* It may be hard to discard suggested completion.
  
* In Calc, AutoInput conflicts with recognition of URLs. See {{Bug|77374}}.
+
==== Issues with capitalization ====
 +
 
 +
* When the cell content is written ''in extenso'', AutoInput has no other effect than changing capitalization. Many users then complains that it is not possible to enter some word with two different capitalizations in the same column, see {{Bug|73036}}, {{Bug|5743}}, {{Bug|47848}}, {{Bug|51483}}, {{Bug|51236}}, {{Bug|52784}}, {{Bug|96332}} and {{Bug|77763}}. See also {{Bug|60144}}, which is still open because it explicitly questions the fact that auto-completion should not occur when the word is typed ''in extenso'', but {{Bug|1342}} is a request for enhancement of that behavior that has been accepted. See also {{Bug|23146}}.
 +
* Rules concerning capitalization are very unpredictable and depend upon the capitalization of both the first cell containing the text and the text typed, with different kind of capitalization (first letter, all caps, no caps at all…). [It needs more work to tell exactly how it works.]
 +
* AutoInput uses the Sort Lists defined in {{Spec/menuitem|Tools > Options… > OpenOffice.org Calc > Sort Lists}} as sources for AutoInput, changing the capitalization accordingly (see {{Bug|3765}}, {{Bug|88908}}, {{Bug|69984}} and {{Bug|71138}}). Also, {{Bug|29042}} is a request for enhancement of this behavior that still as status 'NEW'.
 +
 
 +
==== Issues with interpretation of content ====
 +
 
 +
* AutoInput conflicts with recognition of URLs. See {{Bug|77373}} and {{Bug|77374}}.
 +
* AutoInput can conflict with number input if some text in another cell could have been interpreted as a number but it has been escaped with a leading '. See {{Bug|55652}}.
  
 
=== Inconsistency between Calc and Writer ===
 
=== Inconsistency between Calc and Writer ===
  
* '''Interaction design differs''' in Writer and Calc for AutoInput. See {{Bug|8453}} for user complaining about it, and [http://n2.nabble.com/Auto-completion%3A-finding-peculiarities-in-Calc-%28compared-to-Writer%29-tp2303486p2303486.html this message by Graham Perrin] for further details about the differences.
+
See the page [[Auto-completion]].
* '''Options and their interface differs''': in Writer, AutoInput is a tab in {{Spec/menuitem|Tools > AutoCorrect…}} but in Calc it is an entry in {{Spec/menuitem|Tools > Cell Content}}. For examples of users expecting the feature to have the same configuration interface in the two modules, see {{Bug|75413}}, {{Bug|80191}}, {{Bug|82106}} and {{Bug|34418}}.
+
  
 
=== Inconsistency with auto-complete features from other products ===
 
=== Inconsistency with auto-complete features from other products ===
  
 
* It does not use a menu. See {{Bug|76878}}.
 
* It does not use a menu. See {{Bug|76878}}.
 +
* In Excel, it seems that AutoInput suggestions for completion do not rely on the ''content'' of the cells in the same column, but on their ''value''. At least, it takes into account references. See the request for enhancement in {{Bug|43108}}.
 +
 +
=== Other issues ===
 +
 +
* Only 2000 cells or 200 strings are analyzed for suggestions of completion. See {{Bug|89016}}.
 +
 +
== See Also ==
 +
 +
* [[Auto-completion]]
 +
* [[Word Completion]]
 +
* [[Mac_OS_X_Porting_-_Keyboard_Shortcuts|Mac OS X porting — keyboard shortcuts]]
  
 
[[Category:User Experience]]
 
[[Category:User Experience]]

Latest revision as of 14:32, 14 February 2009

Introduction

This page will discuss the user interface for the AutoInput feature in Calc (also known as auto-completion.)

Status: Work in progress.

How it works

When?

In cell input mode or in edition mode when the cursor is at the end of the field.

What?

The content of a cell above the edited cell, if not a formula.

The name of named ranges (see Issue 73997 ) in formula edition or input mode.

Issues

Remark

We list a lot of issues (see the full list). Many of these issues are closed as INVALID or WORKSFORME, but it is rather a consequence of unexperienced reporters setting the issue type as DEFECT instead of ENHANCEMENT. These issues and the associated discussions still are valuable for this evaluation.

Issues with discoverability

Discoverability of the menu entry

  • There is an unadapted intermediary step to find the AutoInput option in the menu: the option is located in Tools > Cell content > AutoInput. This may seem illogical since the feature does not deal with cell content, but with the method used to input that content. For examples of users that do not find this menu entry, see Issue 40908 , Issue 17505 and Issue 93483 .
  • The name of the feature is poorly chosen. It has consequences on discoverability because 'AutoInput' does not match the name most users spontaneously give to that feature when talking about it (which is 'auto-completion'.) As a consequence, users looking for the feature may not recognize that this is the feature they are looking for (see last comment in Issue 34417 ). The reason why 'AutoInput' has been preferred to auto-completion seems to be that it does not complete a word, but suggests previous input in a full cell. This is a questionable choice.

Lack of Feedback after input

  • The lack of feedback explicating what happened after completion, may in many cases (such as Issue 47848 or Issue 51483 ) prevent the user to understand the feature, or even that there is a feature. We then miss an occasion to learn the user a new feature.
  • AutoInput uses Sort Lists defined in Tools > Options… > OpenOffice.org Calc > Sort Lists as sources for AutoInput, changing the capitalization accordingly (see Issue 3765 ). But it does not use it as a source for completion suggestions, so the user cannot know that this change of capitalization is done by AutoInput (and may think it is done by AutoCorrect such as in Issue 55331 ). The user then cannot know that it can be disabled with Tools > Cell Content > AutoInput.

Issues with navigation

Issues making difficult to enter content

Difficulty to discard suggested completion

  • It may be hard to discard suggested completion.

Issues with capitalization

  • When the cell content is written in extenso, AutoInput has no other effect than changing capitalization. Many users then complains that it is not possible to enter some word with two different capitalizations in the same column, see Issue 73036 , Issue 5743 , Issue 47848 , Issue 51483 , Issue 51236 , Issue 52784 , Issue 96332 and Issue 77763 . See also Issue 60144 , which is still open because it explicitly questions the fact that auto-completion should not occur when the word is typed in extenso, but Issue 1342 is a request for enhancement of that behavior that has been accepted. See also Issue 23146 .
  • Rules concerning capitalization are very unpredictable and depend upon the capitalization of both the first cell containing the text and the text typed, with different kind of capitalization (first letter, all caps, no caps at all…). [It needs more work to tell exactly how it works.]
  • AutoInput uses the Sort Lists defined in Tools > Options… > OpenOffice.org Calc > Sort Lists as sources for AutoInput, changing the capitalization accordingly (see Issue 3765 , Issue 88908 , Issue 69984 and Issue 71138 ). Also, Issue 29042 is a request for enhancement of this behavior that still as status 'NEW'.

Issues with interpretation of content

  • AutoInput conflicts with recognition of URLs. See Issue 77373 and Issue 77374 .
  • AutoInput can conflict with number input if some text in another cell could have been interpreted as a number but it has been escaped with a leading '. See Issue 55652 .

Inconsistency between Calc and Writer

See the page Auto-completion.

Inconsistency with auto-complete features from other products

  • It does not use a menu. See Issue 76878 .
  • In Excel, it seems that AutoInput suggestions for completion do not rely on the content of the cells in the same column, but on their value. At least, it takes into account references. See the request for enhancement in Issue 43108 .

Other issues

  • Only 2000 cells or 200 strings are analyzed for suggestions of completion. See Issue 89016 .

See Also

Personal tools