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: [email protected] 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
