Issue 6386 - how about a formula creator for Calc ?
Summary: how about a formula creator for Calc ?
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P5 (lowest) Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2002-07-10 10:03 UTC by lars
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description lars 2002-07-10 10:03:34 UTC
A special window aacessible from the functions menu where one can enter a 
formula and this formula is then saved in a category "custom formulas"; this 
custom formula category then contains a button "modify formula" (or upon 
displaying the formula it can be edited inline directly !).
Also any formula that is entered into the toolbar data field becomes a custom 
forumla by doing (replacing by) the following which is the principle of custom 

Instead of B2, A1 etc. one writes  Input1, Input2  and one can use all already 
existing formulas and all operators.
The use of the custom formula is then that calc requires input cells when 
coming towards applying the function just like any function with arguments 
requires input cells.

eg.:   SQRT(Input1^2+Input2^2)=POLARRADIUS  //custom formula name  (SQRT=square 
root (exists as formula in english version?))

This lists in the category custom functions and is used like any other function 
in toolbar data field:  =POLARRADIUS(A1;B2)
or when using the functions menu "wizard" there are displayed two fields for 
the input data where one then can "enter" the source cells as usual.
There it is recommended to be able to comment ones InputX when creating 
formulas and commenting the formula itself.  eg.  POLARRADIUS gives the radius 
of a cartesian coordinate pair in polar coordinates
Comment 1 daniel.rentz 2002-07-10 10:57:26 UTC
@Falko: Sounds really good to me... Will cause huge effort.
@Lars: Just a hint: Until such a functionality may exist, you can use
Basic macros. Of course there it is not easy (but possible) to use the
built-in sheet functions.
Comment 2 lars 2002-07-10 15:02:31 UTC
on unknown fct, look through all custom functions

if name matches replace entered text by function text,

go through function text, replace InputX by entered CellX ,

submit this changed text to "function handler" instead of originally 
entered text.

That's problem-reduction.

Some work it is to "make" a new category, put a text field for direct 
editing (like windows filenames) on it etc..
Comment 3 lars 2002-07-10 22:52:05 UTC
i feel slightly bad for being so jackass,

perhaps m. dekkers signature fits: it's easy to suggest solutions if 
one knows nothing about the problem ...
Comment 4 lars 2002-08-20 18:09:43 UTC
how is decision and opinion about this "going along" ?
Comment 5 falko.tesch 2003-10-13 13:43:20 UTC
We will not have this in 2.0 (too much effort)
Since such function is _very_ specific (and AFAIK whether Quatrro Pro
Excel don't haveit either) I will put this on later.

Comment 6 frank.loehmann 2007-01-31 17:32:37 UTC
Set correct state.
Comment 7 Rob Weir 2013-07-30 02:20:07 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.