gnumeric r16691 - in branches/gnumeric-1-8: . plugins/fn-lookup

[mortenw svn gnome org]

Author: mortenw
Date: Tue Jul  1 15:40:33 2008
New Revision: 16691
URL: http://svn.gnome.org/viewvc/gnumeric?rev=16691&view=rev

Log:
2008-07-01  Morten Welinder  <terra gnome org>

	* functions.c (find_bound_walk): When reversing direction, handle
	singleton right.  Fixes #540996.



Modified:
   branches/gnumeric-1-8/NEWS
   branches/gnumeric-1-8/plugins/fn-lookup/ChangeLog
   branches/gnumeric-1-8/plugins/fn-lookup/functions.c

Modified: branches/gnumeric-1-8/NEWS
==============================================================================
--- branches/gnumeric-1-8/NEWS	(original)
+++ branches/gnumeric-1-8/NEWS	Tue Jul  1 15:40:33 2008
@@ -4,10 +4,6 @@
 	* Fix ODS import failure on win32. [#536552]
 
 Morten:
-	* Fix bogus-xls problem.  [#540697]
-	* Fix EOMONTH issue.  [#540069]
-	* Fix phyper hang.  [#540211]
-	* Fix problems with invalid dates in fn-financial.  [#540690]
 	* Fix text export problem for times with fractional seconds.  [#534514]
 	* Fix openoffice -pedantic problem.  [#540180]
 	* Fix OPT_RGW hang.  [#534132]
@@ -19,6 +15,11 @@
 	* Add missing "return" in CODE.
 	* Fix EDATE issue.  [#539868]
 	* Fix DAYS360 and NETWORKDAYS for invalid dates.  [#540055]
+	* Fix bogus-xls problem.  [#540697]
+	* Fix EOMONTH issue.  [#540069]
+	* Fix phyper hang.  [#540211]
+	* Fix problems with invalid dates in fn-financial.  [#540690]
+	* Fix MATCH problem with singletons.  [#540996]
 
 --------------------------------------------------------------------------
 Gnumeric 1.8.3

Modified: branches/gnumeric-1-8/plugins/fn-lookup/functions.c
==============================================================================
--- branches/gnumeric-1-8/plugins/fn-lookup/functions.c	(original)
+++ branches/gnumeric-1-8/plugins/fn-lookup/functions.c	Tue Jul  1 15:40:33 2008
@@ -179,19 +179,22 @@
 		return current;
 	}
 
+ again:
 	if (sup) {
 		current++;
 		if (current > high && sup == started) {
-			current = orig - 1;
+			current = orig;
 			sup = FALSE;
+			goto again;
 		} else if (current > high && sup != started) {
 			return -1;
 		}
 	} else {
 		current--;
 		if (current < low && sup == started) {
-			current = orig + 1;
+			current = orig;
 			sup = TRUE;
+			goto again;
 		} else if (current < low && sup != started) {
 			return -1;
 		}