Issue 62694 - Across sheet parameter to custom function
Summary: Across sheet parameter to custom function
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-03-01 22:00 UTC by iannz
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description iannz 2006-03-01 22:00:02 UTC
I would like to be able to create custom spreadsheet functions that accept a 
range parameter that works across sheets.

E.g. In a cell on a spreadsheet:

Function declaration:

Currently returns: Err:504 Error in parameter list.

Note that =SUM(Sheet1.B41:Sheet6.C88) works as I'd expect summing all
the values on all 6 sheets between B41 and C88.

Note also that =FNMYCUSTOMFUNCTION(Sheet1.B41:C88) also works as
expected - passing a two dimensional array to the variable rng.

This enhancement would mean that custom functions could work in the same way as
the built-in functions. Separating the range into several single-sheet range
parameters is not a particularly satisfactory solution as spreadsheets using
such custom functions would be harder to maintain. E.g. Add a new sheet and
every instance of the function would have to be changed.
Comment 1 frank 2006-04-07 11:32:17 UTC
one for requirements