Difference between revisions of "Calc/Drafts/Show Formula Syntax"

From Apache OpenOffice Wiki
< Calc‎ | Drafts
Jump to: navigation, search
 
(16 intermediate revisions by 4 users not shown)
Line 1: Line 1:
==About adding a new feature that "Show Formula Syntax in tip help" in Calc.==
+
== Design for a new feature in Calc: "Show Formula Syntax in tip help" ==
===This function can be described as follows:===
+
===Function description===
According to the request of the to-do list in Calc OOo community, the feature is to show formula syntax in tip help in Calc. This feature would make the user get immediate feedback when a cell formula is being edited, in addition to the function selection above the cell, show some input hints (like the syntax of the function that is edited) in a tip help window below the cell)<br>
+
According to the request of the to-do list in Calc OOo community, the feature is to show formula syntax in tip help in Calc. This feature would make the user get immediate feedback when a cell formula is being edited, in addition to the function selection above the cell, show some input hints (like the syntax of the function that is edited) in a tip help window below the cell<br>
[http://wiki.services.openoffice.org/wiki/Image:Specification.odt the Specification of this new feature]
+
[http://wiki.services.openoffice.org/wiki/Image:Show_Formula_Syntax_Specification.odt the Specification of this new feature]
 +
 
 +
===Rationale===
 +
This feature has been discussed extensively in a [http://ux.openoffice.org/servlets/ReadMsg?list=discuss&msgNo=1270 thread on the UX discuss mailing list]. Several specific variations of and additions to the original specification have been discussed, including:
 +
* In tip help, highlighting the currently expected function argument using surrounding space characters (also referred to as "suggestion 2").
 +
* In tip help, highlighting the currently expected function argument using a special character, e.g. a downwards arrow ("suggestion 8").
 +
* In tip help, explicitly stating the currently expected function argument using natural language ("suggestion 3").
 +
 
 +
The above three points tried to work around the fact that formatting currently isn't supported in tip help.
 +
 
 +
* In edited cell, using suggest-as-you-type autocompletion to inform about function syntax and aid formula editing ("suggestion 4").
 +
* Using tip help syntax info combined with a programming-environment-like suggest-and-pick interface (comparable to [http://help.eclipse.org/help33/topic/org.eclipse.jdt.doc.user/tips/jdt_tips.html#editing_section Eclipse's Content Assist]).
 +
 
 +
In the discussion of these rather specific suggestions, the need was recognized to step back and analyze the formula manipulation process as a whole. What lies behind this requirement? What functions do people use? What are they trying to achieve? This "big picture" analysis will include a re-evaluation of the current procedures and components.
 +
 
 +
Because this analysis will take time, Maoyg is going to implement "suggestion 8" in the meanwhile.
 +
 
 +
See also [http://www.openoffice.org/issues/show_bug.cgi?id=86856 the original suggestion on OOo's bug tracker] and
 +
[http://wiki.services.openoffice.org/wiki/Image:symbols.odt the Specification of the symbol]
 +
 
 +
[[Category:Calc|Draft/Show Formula Syntax]]
 +
[[Category:To-Do]]
 +
[[Category:Draft]]
 +
[[Category:Outdated]]

Latest revision as of 12:37, 17 May 2012

Design for a new feature in Calc: "Show Formula Syntax in tip help"

Function description

According to the request of the to-do list in Calc OOo community, the feature is to show formula syntax in tip help in Calc. This feature would make the user get immediate feedback when a cell formula is being edited, in addition to the function selection above the cell, show some input hints (like the syntax of the function that is edited) in a tip help window below the cell
the Specification of this new feature

Rationale

This feature has been discussed extensively in a thread on the UX discuss mailing list. Several specific variations of and additions to the original specification have been discussed, including:

  • In tip help, highlighting the currently expected function argument using surrounding space characters (also referred to as "suggestion 2").
  • In tip help, highlighting the currently expected function argument using a special character, e.g. a downwards arrow ("suggestion 8").
  • In tip help, explicitly stating the currently expected function argument using natural language ("suggestion 3").

The above three points tried to work around the fact that formatting currently isn't supported in tip help.

  • In edited cell, using suggest-as-you-type autocompletion to inform about function syntax and aid formula editing ("suggestion 4").
  • Using tip help syntax info combined with a programming-environment-like suggest-and-pick interface (comparable to Eclipse's Content Assist).

In the discussion of these rather specific suggestions, the need was recognized to step back and analyze the formula manipulation process as a whole. What lies behind this requirement? What functions do people use? What are they trying to achieve? This "big picture" analysis will include a re-evaluation of the current procedures and components.

Because this analysis will take time, Maoyg is going to implement "suggestion 8" in the meanwhile.

See also the original suggestion on OOo's bug tracker and the Specification of the symbol

Personal tools