Apache OpenOffice (AOO) Bugzilla – Issue 11511
Define a function using a Sheet
Last modified: 2013-02-07 22:33:36 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. :(
Hi Bettina, 1 4 u Frank
OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".