Issue 62694

Summary: Across sheet parameter to custom function
Product: Calc Reporter: iannz <hillview>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.0.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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