[gnumeric] ADDRESS: A non-existing sheet is perfectly valid for this function.



commit 903956a0c8343813c8d224036fb3f73b752f93a0
Author: Morten Welinder <terra gnome org>
Date:   Tue May 17 14:16:12 2011 -0400

    ADDRESS: A non-existing sheet is perfectly valid for this function.
    
    Really.

 plugins/fn-lookup/functions.c |    6 ++++--
 1 files changed, 4 insertions(+), 2 deletions(-)
---
diff --git a/plugins/fn-lookup/functions.c b/plugins/fn-lookup/functions.c
index 493e0b1..1bb9782 100644
--- a/plugins/fn-lookup/functions.c
+++ b/plugins/fn-lookup/functions.c
@@ -762,8 +762,10 @@ gnumeric_address (GnmFuncEvalInfo *ei, GnmValue const * const *args)
 	if (sheet_name) {
 		sheet = workbook_sheet_by_name (ei->pos->sheet->workbook,
 						sheet_name);
-		if (!sheet)
-			return value_new_error_VALUE (ei->pos);
+		if (!sheet) {
+			/* Use evaluation sheet if named sheet does not exist.  */
+			sheet = ei->pos->sheet;
+		}
 	} else
 		sheet = ei->pos->sheet;
 



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]