Product: Spreadsheet
Type: changed
Title: SUMIF geometry of 3rd parameter adapts to 1st parameter
Posted by: [EMAIL PROTECTED]
Affected: sc
Effective from: cws odff
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
For interoperability with other spreadsheet applications the handling
of the 3rd parameter to the SUMIF() function changed. Previously, Calc
expected the geometry of that cell range to match that of the 1st
parameter. Now the 3rd parameter's range geometry does not have to
match the 1st parameter's; the upper left cell address is taken and
the geometry of the 1st parameter is used to turn that into a cell
range. For example, =SUMIF(A1:C3;1;X1) will result in the range X1:Z3
to be summed. If a range is passed, the geometry of the range is
ignored. If the resulting range would extend over the lower/right
sheet boundaries, those cells are silently ignored. For example, with
a lower right boundary of IV65536 the formula =SUMIF(A1:C3;1;IU65535)
would result in only 4 cells IU65535:IV65536 to be summed.
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
