Bug 106928 - Parameters specified to accept sequences may accept cuboids. Non-scalar evaluation allowed would add useful power.
Summary: Parameters specified to accept sequences may accept cuboids. Non-scalar evalu...
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-04-03 16:41 UTC by Wolfgang Jäger
Modified: 2017-04-26 12:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Wolfgang Jäger 2017-04-03 16:41:19 UTC
There are only a few functions in Calc accepting cuboids on one or more parameter places. None of them is specified to do so explicitly in OpenFormula v1.2 , but there is a general specification about the conversion of cuboids to some kind of series accepted by a function. This conversion may be done by the body of the respective function itself or, in advance of passing something to the function, by the general part of the evaluator. 

(At least) if done the second way it should be feasible without too much complications to enrich the procedure by preposing a non-scalar evaluation where applicable in a similar way as it is done for 2D-arrays under forced or intrinsic array-evaluation as described in OpenFormula, paragraph 3.3. 

I would suggest to implement an extended (3D) variant of array-evaluation for expressions built (partly) from cuboids.
Comment 1 Buovjaga 2017-04-17 14:28:33 UTC
Can you give some practical examples?
Comment 2 Wolfgang Jäger 2017-04-26 12:31:05 UTC
I thought of emulating (partly) the functionality of SUMIF, AVERAGEIF and similar functions AS IF they accepted cuboids. 
I meanwhile analised the implications to a bit more depth and now want to withdraw the request. 
Sorry for any unnecessary effort on your behalf.
Comment 3 Buovjaga 2017-04-26 12:36:51 UTC
It's ok, I will close.