Public bug reported:
Binary package hint: openoffice.org
column "I" has approximately 600 unique numbers
(-0.309,-0.308,-0.307,....,-0.001,0.000,0.001,....,0.274).
Each row in column "J" has a formula similar to the following forumula for cell
J249:
=COUNTIF(H$3:H$15084,I249)
Column H has 15084 rows of data that are numbers between -0.309 and
0.274. These numbers represent "results" so I'm trying to tally the
number of times each "result" occurs in column H.
The countif() function seems to stop working when the "count" gets above
37 then starts working again further down column J when the count gets
below 22 again.
Hey, Wouldn't it just be easier if I attach the file? Look at column
J249 through J408.
ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
Package: openoffice.org-core 1:3.1.1-1ubuntu1~jaunty1 [modified:
var/lib/openoffice/basis3.1/program/services.rdb]
ProcEnviron:
PATH=(custom, user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-17-generic i686
UnreportableReason: This is not a genuine Ubuntu package
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: apport-bug i386
--
Spreadsheet COUNTIF() function stops working for large counts in large range
https://bugs.launchpad.net/bugs/512957
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
