Enhanced formula input

To comment on the following update, log in, then open the
issue:
http://www.openoffice.org/issues/show_bug.cgi?id=20496





------- Additional comments from muthusubaopenoffice.org Thu Oct 19 22:23:10 -0700 2006 -------
discoleo,
  have you tried the patch attached in this issue? it will
be easier to know
what is 'left out' from the patch.
muthusuba

This is what the patch does:
<this is very similar to excel> (you can interchange
'+' and '-' for the below
examples)

+1       => +1
+1+2     => =+1+2
+exe     => =+exe
+<arrow> => starts the formula input mode (i.e.
become +A1 etc..)
++a      => =++a
-4^2     => =-4^2
+A1+A2   => =+A1+A2
'+abcd   => string +abcd
+abcd    => if it generates an error then it is shown as
an error (similar to
what excel does) - probably the user made a typo! (consider
this, =inf("system") 
generates an error then why shouldn't
+inf("system") generate an error?)

(import is not considered in the patch so importing a .csv
file with +4+2 will
give +4+2 in the cell - this is because exporting would have
been =+4+2 (in case
the user typed +4+2 it would have converted it to =+4+2))

And yes, as far as i can see from the above comments, we are
considering adding
an option to disable this feature (mmeeks, nn, er would be
able to comment
better here).

[Waiting for comments from user experience team - in the
mean while i will work
on adding an option to disable this - more the features
better it is! ]

------------------------------------------------------------
---------
Please do not reply to this automatically generated
notification from
Issue Tracker. Please log onto the website and enter your
comments.
http://qa.openoffice.org/issue_handling/
project_issues.html#notification

------------------------------------------------------------
---------
To unsubscribe, e-mail: issues-unsubscribesc.openoffice.org
For additional commands, e-mail: issues-helpsc.openoffice.org