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 discoleoopenoffice.org Thu Oct 19 09:21:14 -0700 2006 -------
I had a new brainstorming session and would like to expand
on some issues/
Specifications:

What__________| How
is____________| should it be
entered_______| interpreted
==============|=============
SIMPLE NUMBER:
* Number (e.g. 4)      => as plain number
* negative number (-3) => as negative plain number
* '+' + 'Number'       => as STRING !!!
  -- this is currently interpreted as a number, too, but in
categorical data you
may have often categories of, e.g. '+4' which is different
from '4' (think of
grades in histology and so on);

NOTE: when we have only one number [regardless of the
+/-/(or nothing) in front
of that number], the formula does *NOT bring* any
*additional benefit*, so I do
NOT believe that a formula is needed in these situations!!!)

NUMBER FOLLOWED BY OPERATOR:
* 'plain number'+'any operator' => string
* '+' + 'plain number' + 'any operator' => formula
* '-' + 'plain number' + 'any operator' => string
(formula?)
* ('+' or '-') + '-' + 'plain number' + 'any op' =>
formula; strip first +/-
  -- advanced: IF "'any operator'..." does
evaluate to *ERROR*, consider string
instead of formula

STRING:
* any string => string
* ('+' OR '-') + STRING
  -- IF string evaluates to valid function => formula
  -- IF NOT => just a string

------------------------------------------------------------
---------
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