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 [EMAIL PROTECTED] Thu May 22 02:03:27 +0000
2008 -------
Re: Issue 20496
I a column of 'Expenses'I have cells that, normally, receives only
constants,
such as '264.58'.
Sometimes, however, I have to add an item, ie, change the constant to a formula:
'264.58+86.3'. Easy: I hit f2 (to enter the edit mode) and, since the cursor is
at the end of '264.58', enter '+86.3'. Problem: that's not a formula without a
leading =. To enter that = sign, I have to hit Home to put the cursor at the
formula beginning, and hit =. (If entering the initial = sign is a problem to
begin with --Issue 20496; eg, ggabriel Thu Jul 29 00:11:54 +0000 2004; Issue
46416--, it becomes worse in this case, when it has to be added in front of an
existing number.)
I read all the discussion around Issue 20496, and the suggestions to
put a
leading + or - to identify a formula, but the requirement to put ANYthing in
front of the first datum ('264.58') will add at least two keystrokes --too much,
when repeated often-- and the risk to alter that datum by hitting the wrong key.
It would be a lot easier (not only to me, but to anyone trying to enter
a
formula beginning with a number) if Calc recognized the obvious: that
'264.58+86.3' is a formula. Or, that any string beginning with a numeral is a
formula, eg: '20+D5'; '6*A44-F12+64.9'; '.5*sum(E8:F22)'. If the user wants this
to be text, let her precede it with an apostrophe; because real text seldom
begin with a numeral, this requirement will be much lighter than requiring a
leading = in a formula.
The leading = sign (or +, or -) would remain useful in such formulae as
'=sum(B4:C10)' or '=C3^2.
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
