Re: [libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

Hi,

Paul schrieb:
> Well, I *think* the issue is with using the functions on a range that
> is across worksheets. I don't think you can do that,

But the specification allows a cuboid reference. Therefore it is a bug, 
or at least a missing feature. For AOO the issue is 
https://issues.apache.org/ooo/show_bug.cgi?id=110421

 but then again, I
> don't think you can do this in MSO either, but you seem to think that
> MSO can do this, so my assumption appears to be wrong, and as such
> might be wrong for LO too.

Excel 2010 does not allow this kind of reference for its xxxIF 
functions. For other functions like SUM such cuboid reference works.

Kind regards
Regina

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted