To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=115832
Issue #|115832
Summary|errors in max and min
Component|Spreadsheet
Version|1.0.0
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|realbigdave
------- Additional comments from realbigd...@openoffice.org Tue Nov 30 01:21:34
+0000 2010 -------
I entered =MAX(C1;C10) expecting that I would get the maximum value from C1 to
C10 inclusive. I then copied this down the page. What I got was a maximum
value for the first couple of lines, then a random number selected from the
column of numbers from the last 10 rows in each line.
I got the same result from =MIN(D1;D10) when I copied it down the page. The
results were random and only the first couple were the appropriate minimums.
Here is the first page of the calcs. The formulas do not show here but what I
was trying to do was put the maximum value of C1;C10 in H10 and the minimum
value of D1;D10 in I10. If you place the formulas there and copy them down you
will see what I got.
01/04/99 122.15 123.4 122.14 122.87 2926 1313
01/05/99 122.89 123.05 122.13 122.41 2112 2091
01/06/99 122.41 122.48 120.01 120.63 5107 3816
01/07/99 120.83 121.94 120.73 121.7 3894 4191
01/08/99 121.72 121.78 120.05 120.5 4032 4469
01/11/99 120.23 120.55 119.39 119.44 6195 7627
01/12/99 119.51 120.25 119.16 120.07 3265 8241
01/13/99 120.22 122.46 120.14 121.09 5765 7212 fHighest
fLowest
01/14/99 121.18 121.77 120.8 121.63 1304 6902
01/15/99 121.59 121.91 120.19 120.43 1065 6466 123.4 120.19
01/19/99 120.18 120.86 120.18 120.64 1889 6184 123.05 120.18
01/20/99 120.63 120.71 119.96 120.07 1596 6494 122.48 119.96
01/21/99 120.18 120.64 120.03 120.51 1115 6356 121.94 120.03
01/22/99 120.49 120.75 120.2 120.37 1246 6823 121.78 120.05
01/25/99 120.34 120.4 120.04 120.05 975 7176 120.55 119.39
01/26/99 120.32 120.35 120.1 120.1 1853 6850 120.35 119.16
01/27/99 120.11 120.11 118.56 118.8 14839 18690 122.46 118.56
01/28/99 118.86 119.15 118.37 118.67 7198 22412 121.77 118.37
01/29/99 118.59 118.72 117.91 118.12 2584 23650 121.91 117.91
02/01/99 118.29 118.37 117.34 117.57 5328 27109 120.86 117.34
02/02/99 117.45 117.92 117.39 117.92 2629 27050 120.71 117.39
02/03/99 117.92 118.01 117.61 117.62 4844 26981 120.64 117.61
02/04/99 117.58 117.86 116.97 117.76 6027 27998 120.75 116.97
02/05/99 117.75 118.04 116.95 117.06 2585 28482 120.4 116.95
02/08/99 117.09 117.67 116.62 117.65 10464 29894 120.35 116.62
02/09/99 117.49 117.95 117.22 117.29 2001 30301 120.11 117.22
02/10/99 117.56 117.99 117.17 117.84 4079 27459 119.15 117.17
02/11/99 117.51 117.69 116.66 116.7 2949 28798 118.72 116.66
02/12/99 116.75 117.24 116.52 117.17 4004 27749 118.37 116.52
02/16/99 117.25 117.27 116.01 116.38 6754 30110 117.92 116.01
02/17/99 116.41 116.92 116.4 116.72 5049 30473 118.01 116.4
02/18/99 116.89 117.05 116.24 116.37 1765 31306 117.86 116.24
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
