Please note, that I updated the specification at
http://specs.openoffice.org/calc/ease-of-use/Enhanced_Formula_Input.odt
Although the question which user input is converted into a formula
is quite controversial, I tried to include the most important comments
into the specification.
In a
, 9 Aug 2007 20:50:51 +0200
Subject: Re: [sc-dev] i20496 : Enhanced formula input
Hi Leonard,
On Thursday, 2007-08-09 20:51:26 +0300, Leonard Mada wrote:
Excel converts +number+number to =number+number and ++number
to =+number, but converts +name to =+name
Note that Excel does not convert
Hi Eike,
the examples in the spec basically follow the Excel behavior.
You made some good points and it seems, that the Excel behavior
is not always wanted. Unfortunately Frank is on vacation until
end of August, but the specification definitely needs to be
reworked.
From an implementation
Hi all,
there is one thing I definitely want to avoid - at all cost: namely
converting non-formula input into a formula.
Lets say the user enters: +some_string
IF 'some_string' is NOT a valid formula, then:
A.) IF this would be converted to a formula, Calc would evaluate it
and display
Hi all,
sorry for another post.
Eike Rathke wrote:
...
2. And w.r.t to the ++ - =++ its for the similarity with excel (and also +
- =+).
Excel converts +number+number to =number+number and ++number
to =+number, but converts +name to =+name
Note that Excel does not convert single
Hi Leonard,
On Thursday, 2007-08-09 20:51:26 +0300, Leonard Mada wrote:
Excel converts +number+number to =number+number and ++number
to =+number, but converts +name to =+name
Note that Excel does not convert single numbers like +1 or -1 but does
convert ++1 to =+1, --1 to =--1, +-1 to =+-1
Hi Frank,
The spec
http://specs.openoffice.org/calc/ease-of-use/Enhanced_Formula_Input.odt
for issue http://qa.openoffice.org/issues/show_bug.cgi?id=20496 states:
++ Number Formula: =++Number
Why should a leading ++ trigger conversion to formula?
-- Number Formula: =--Number
Again, why
