Issue 11511 - Define a function using a Sheet
Summary: Define a function using a Sheet
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Other OS
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-02-15 14:46 UTC by mortoray
Modified: 2013-02-07 22:33 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 mortoray 2003-02-15 14:46:00 UTC
It would be incredibly useful if it was possible to define a function using a Sheet. That is, the first row of cells in the sheet are the parameters of the function -- these parameters are then used within that sheet to calculate a return value (one cell is marked as the return value).  This may not be clear, so here is an example to illustrate:

I have a sheet called Function which defines my function, this is how it is used.

In SheetA I enter a formula: =Function( valA; valB; valC )

To calculate the return value of this function the first row of the Function sheet is populated like this:
A1=valA; B1=valB; C1=valD

Then a Recalc is issued to the Function sheet, where the result is stored in A2 (I'm not sure how to mark the return cell right now).  Then this value in A2 is used as the return value of the function.

This would allow the creation of very powerful functions without needing a Macro.  I was working on this (written in StarBasic) but ran into two limitations: 
1) Presently a macro function cannot modify the contents of a sheet (making the above impossible for a StarBasic function)
2) Issue 11510 deleted all my scripts before I did a backup copy. :(
Comment 1 frank 2003-02-17 08:04:03 UTC
Hi Bettina,

1 4 u

Comment 2 ace_dent 2008-05-16 02:37:58 UTC Issue Tracker - Feedback Request.

The Issue you raised has the status 'New' pending further action, but has not
been updated within the last 4 years. Please consider re-testing with one of the
latest versions of OOo, as the problem(s) may have already been addressed.
Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 3 bettina.haberer 2010-05-21 14:48:25 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".