Issue 6386

Summary:	how about a formula creator for Calc ?
Product:	Calc	Reporter:	lars <lars_o_hansen>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	REOPENED ---	QA Contact:
Severity:	Trivial
Priority:	P5 (lowest)	CC:	issues
Version:	OOo 1.0.0
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---

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

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.