Apache OpenOffice (AOO) Bugzilla – Issue 6386

how about a formula creator for Calc ?

Last modified: 2013-08-07 15:12:27 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

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

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

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

how is decision and opinion about this "going along" ?

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.

Set correct state.

Reset assignee on issues not touched by assignee in more than 2000 days.