I've tried some other array formulas and there doesn't seem to be a problem with them.
>From a quick look on openoffice.org (OOo), I think this bug is related to OOo issue 8946, http://www.openoffice.org/issues/show_bug.cgi?id=8946 which had some changes to the frequency function at the end of last year and in February 2008 to allow for the values in the classes range not being in ascending order. The following comment was made by er on 6th Feb 2008: "The results of FREQUENCY() were somewhat arbitrary because when shuffling the sort array prior to invoking QuickSort the index order didn't follow. Fixed in sc/source/core/tool/interpr3.cxx 1.20.30.8" Strangely though, the "FREQUENCY_test.ods" file attached to OOo issue 8946 appears to work (with results in the correct order) in the OOo 2.4-ubuntu build but the OOo 2.4-sun build gives incorrect results when the values in the classes are not in ascending order. -- [Upstream] [hardy] Speadsheet has problems in hardy https://bugs.launchpad.net/bugs/209474 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs