Ubuntu
openoffice.org package

  1. Bug #209474
  2. Comment #9

Comment 9 for bug 209474

Revision history for this message
Michael Devenish (mdevenish) wrote : Re: [Upstream] [hardy] Speadsheet has problems in hardy

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.