expr.c 39.9 KB
Newer Older
Miguel de Icaza's avatar
Miguel de Icaza committed
1
/*
Morten Welinder's avatar
Morten Welinder committed
2
 * expr.c: Expression evaluation in Gnumeric
Miguel de Icaza's avatar
Miguel de Icaza committed
3 4 5 6
 *
 * Author:
 *   Miguel de Icaza (miguel@gnu.org).
 */
7
#include <config.h>
Arturo Espinosa's avatar
Arturo Espinosa committed
8
#include <gnome.h>
Arturo Espinosa's avatar
Arturo Espinosa committed
9
#include <math.h>
10
#include <string.h>
11
#include <locale.h>
Arturo Espinosa's avatar
Arturo Espinosa committed
12
#include "gnumeric.h"
Arturo Espinosa's avatar
Arturo Espinosa committed
13
#include "expr.h"
14
#include "expr-name.h"
Arturo Espinosa's avatar
Arturo Espinosa committed
15
#include "eval.h"
Miguel de Icaza's avatar
Today:  
Miguel de Icaza committed
16
#include "format.h"
17
#include "func.h"
18
#include "gutils.h"
19
#include "ranges.h"
20
#include "workbook.h"
21

22
EvalPosition *
23
eval_pos_init (EvalPosition *eval_pos, Sheet *sheet, int col, int row)
24
{
25 26 27 28 29
	g_return_val_if_fail (sheet != NULL, NULL);
	g_return_val_if_fail (eval_pos != NULL, NULL);
	g_return_val_if_fail (IS_SHEET (sheet), NULL);

	eval_pos->sheet = sheet;
Jody Goldberg's avatar
Jody Goldberg committed
30 31
	eval_pos->eval.col = col;
	eval_pos->eval.row = row;
32

33
	return eval_pos;
34
}
35

36 37 38 39
/*
 * Supply either a sheet (preferred) or a workbook.
 */

40
ParsePosition *
41
parse_pos_init (ParsePosition *pp, Workbook *wb, Sheet *sheet, int col, int row)
42
{
43
	g_return_val_if_fail (wb || sheet, NULL);
44 45
	g_return_val_if_fail (pp != NULL, NULL);

46 47
	pp->sheet = sheet;
	pp->wb = sheet ? sheet->workbook : wb;
48 49 50 51 52 53
	pp->col = col;
	pp->row = row;

	return pp;
}

54
EvalPosition *
55
eval_pos_cell (EvalPosition *eval_pos, Cell *cell)
56
{
57 58 59
	g_return_val_if_fail (eval_pos != NULL, NULL);
	g_return_val_if_fail (cell != NULL, NULL);
	g_return_val_if_fail (cell->sheet != NULL, NULL);
60 61
	g_return_val_if_fail (IS_SHEET (cell->sheet), NULL);

62 63 64 65 66
	return eval_pos_init (
		eval_pos,
		cell->sheet,
		cell->col->pos,
		cell->row->pos);
67
}
68

69 70 71 72 73 74 75 76 77 78 79
ParsePosition *
parse_pos_cell (ParsePosition *pp, Cell *cell)
{
	g_return_val_if_fail (pp != NULL, NULL);
	g_return_val_if_fail (cell != NULL, NULL);
	g_return_val_if_fail (cell->sheet != NULL, NULL);
	g_return_val_if_fail (IS_SHEET (cell->sheet), NULL);
	g_return_val_if_fail (cell->sheet->workbook != NULL, NULL);

	return parse_pos_init (
		pp,
80 81
		NULL,
		cell->sheet,
82 83 84 85
		cell->col->pos,
		cell->row->pos);
}

86
ExprTree *
Morten Welinder's avatar
Morten Welinder committed
87
expr_tree_new_constant (Value *v)
88
{
89 90 91
	ExprTree *ans;

	ans = g_new (ExprTree, 1);
92 93 94 95 96 97 98
	if (!ans)
		return NULL;
	
	ans->ref_count = 1;
	ans->oper = OPER_CONSTANT;
	ans->u.constant = v;

Morten Welinder's avatar
Morten Welinder committed
99 100 101 102 103 104 105 106 107
	return ans;
}

ExprTree *
expr_tree_new_unary  (Operation op, ExprTree *e)
{
	ExprTree *ans;

	ans = g_new (ExprTree, 1);
108 109 110 111 112 113 114
	if (!ans)
		return NULL;

	ans->ref_count = 1;
	ans->oper = op;
	ans->u.value = e;

Morten Welinder's avatar
Morten Welinder committed
115 116 117 118 119 120 121 122 123 124
	return ans;
}


ExprTree *
expr_tree_new_binary (ExprTree *l, Operation op, ExprTree *r)
{
	ExprTree *ans;

	ans = g_new (ExprTree, 1);
125 126 127 128 129 130 131 132
	if (!ans)
		return NULL;
	
	ans->ref_count = 1;
	ans->oper = op;
	ans->u.binary.value_a = l;
	ans->u.binary.value_b = r;

Morten Welinder's avatar
Morten Welinder committed
133 134 135 136 137 138 139 140 141 142
	return ans;
}

ExprTree *
expr_tree_new_funcall (Symbol *sym, GList *args)
{
	ExprTree *ans;
	g_return_val_if_fail (sym, NULL);

	ans = g_new (ExprTree, 1);
143 144 145 146 147 148 149 150
	if (!ans)
		return NULL;
	
	ans->ref_count = 1;
	ans->oper = OPER_FUNCALL;
	ans->u.function.symbol = sym;;
	ans->u.function.arg_list = args;

Morten Welinder's avatar
Morten Welinder committed
151 152
	return ans;
}
153
       
154 155 156 157 158 159 160 161 162 163 164
int
expr_tree_get_const_int (ExprTree const * const expr)
{
	g_return_val_if_fail (expr != NULL, 0);
	g_return_val_if_fail (expr->oper == OPER_CONSTANT, 0);
	g_return_val_if_fail (expr->u.constant, 0);
	g_return_val_if_fail (expr->u.constant->type == VALUE_INTEGER, 0);

	return expr->u.constant->v.v_int;
}

165 166 167 168 169 170 171 172 173 174 175
char const *
expr_tree_get_const_str (ExprTree const *const expr)
{
	g_return_val_if_fail (expr != NULL, NULL);
	g_return_val_if_fail (expr->oper == OPER_CONSTANT, NULL);
	g_return_val_if_fail (expr->u.constant, NULL);
	g_return_val_if_fail (expr->u.constant->type == VALUE_STRING, NULL);

	return expr->u.constant->v.str->str;
}

176
ExprTree *
177
expr_parse_string (const char *expr, const ParsePosition *pp,
Morten Welinder's avatar
Morten Welinder committed
178
		   char **desired_format, char **error_msg)
179 180 181 182
{
	ExprTree *tree;
	g_return_val_if_fail (expr != NULL, NULL);

183
	switch (gnumeric_expr_parser (expr, pp, desired_format, &tree)) {
184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202
	case PARSE_OK:
		*error_msg = NULL;
		return tree;

	case PARSE_ERR_SYNTAX:
		*error_msg = _("Syntax error");
		break;

	case PARSE_ERR_NO_QUOTE:
		*error_msg = _("Missing quote");
		break;
	default:
		g_assert_not_reached ();
		*error_msg = _("Impossible!");
		break;
	}
	return NULL;
}

Michael Meeks's avatar
Michael Meeks committed
203 204 205 206 207 208 209 210 211 212 213 214 215 216 217
ExprTree *
expr_tree_new_name (const ExprName *name)
{
	ExprTree *ans;

	ans = g_new (ExprTree, 1);
	if (!ans)
		return NULL;
	
	ans->ref_count = 1;
	ans->oper = OPER_NAME;
	ans->u.name = name;

	return ans;
}
218 219 220 221 222 223 224 225 226 227 228 229 230 231 232

/*ExprTree *
expr_tree_new (void)
{
	ExprTree *ans;

	ans = g_new (ExprTree, 1);
	if (!ans)
		return NULL;
	
	ans->ref_count = 1;
	ans->oper = OPER_CONSTANT;
	ans->u.constant = NULL;
	return ans;
}*/
Morten Welinder's avatar
Morten Welinder committed
233 234 235 236 237 238 239

ExprTree *
expr_tree_new_var (const CellRef *cr)
{
	ExprTree *ans;

	ans = g_new (ExprTree, 1);
240 241 242 243 244 245 246
	if (!ans)
		return NULL;
	
	ans->ref_count = 1;
	ans->oper = OPER_VAR;
	ans->u.ref = *cr;

247 248 249
	return ans;
}

Morten Welinder's avatar
Morten Welinder committed
250 251 252 253
ExprTree *
expr_tree_new_error (const char *txt)
{
	Symbol *func;
Morten Welinder's avatar
Morten Welinder committed
254 255 256 257 258 259 260 261 262
	GList *args = NULL;

	if (strcmp (txt, gnumeric_err_NA) == 0) {
		func = symbol_lookup (global_symbol_table, "NA");
	} else {
		func = symbol_lookup (global_symbol_table, "ERROR");
		args = g_list_prepend (NULL,
				       expr_tree_new_constant (value_new_string (txt)));
	}
Morten Welinder's avatar
Morten Welinder committed
263 264

	symbol_ref (func);
Morten Welinder's avatar
Morten Welinder committed
265
	return expr_tree_new_funcall (func, args);
Morten Welinder's avatar
Morten Welinder committed
266 267
}

268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290
ExprTree *
expr_tree_array_formula (int const x, int const y, int const rows, int const cols)
{
	ExprTree *ans;

	ans = g_new (ExprTree, 1);
	if (ans == NULL)
		return NULL;
	
	ans->ref_count = 1;
	ans->oper = OPER_ARRAY;
	ans->u.array.x = x;
	ans->u.array.y = y;
	ans->u.array.rows = rows;
	ans->u.array.cols = cols;
	ans->u.array.corner.func.value = NULL;
	ans->u.array.corner.func.expr = NULL;
	ans->u.array.corner.cell = NULL;
	return ans;
}


static ExprTree *
291
expr_tree_array_formula_corner (ExprTree const *expr, EvalPosition const *pos)
292
{
293
	Cell * corner = expr->u.array.corner.cell;
294

295 296 297 298 299 300
	/* Attempt to set the corner if it is not already set */
	if (corner == NULL) {
		g_return_val_if_fail (pos != NULL, NULL);
		g_return_val_if_fail (pos->sheet != NULL, NULL);

		corner = sheet_cell_get (pos->sheet,
Jody Goldberg's avatar
Jody Goldberg committed
301 302
					 pos->eval.col - expr->u.array.x,
					 pos->eval.row - expr->u.array.y);
303 304 305 306
		((ExprTree *)expr)->u.array.corner.cell = corner;
	}

	g_return_val_if_fail (corner != NULL, NULL);
307 308 309 310 311
	g_return_val_if_fail (corner->parsed_node != NULL, NULL);

	/* Sanity check incase the corner gets removed for some reason */
	g_return_val_if_fail (corner->parsed_node != (void *)0xdeadbeef, NULL);
	g_return_val_if_fail (corner->parsed_node->oper == OPER_ARRAY, NULL);
312 313
	g_return_val_if_fail (corner->parsed_node->u.array.x == 0, NULL);
	g_return_val_if_fail (corner->parsed_node->u.array.y == 0, NULL);
314 315 316 317

	return corner->parsed_node;
}

Arturo Espinosa's avatar
Arturo Espinosa committed
318 319 320 321
/*
 * expr_tree_ref:
 * Increments the ref_count for part of a tree
 */
322 323 324 325 326 327
void
expr_tree_ref (ExprTree *tree)
{
	g_return_if_fail (tree != NULL);
	g_return_if_fail (tree->ref_count > 0);

Morten Welinder's avatar
Morten Welinder committed
328
	tree->ref_count++;
Arturo Espinosa's avatar
Arturo Espinosa committed
329 330 331 332 333
}

static void
do_expr_tree_unref (ExprTree *tree)
{
Morten Welinder's avatar
Morten Welinder committed
334 335 336
	if (--tree->ref_count > 0)
		return;

Arturo Espinosa's avatar
Arturo Espinosa committed
337
	switch (tree->oper){
338
	case OPER_VAR:
Arturo Espinosa's avatar
Arturo Espinosa committed
339
		break;
340

341
	case OPER_CONSTANT:
Morten Welinder's avatar
Morten Welinder committed
342
		value_release (tree->u.constant);
Arturo Espinosa's avatar
Arturo Espinosa committed
343
		break;
344

Morten Welinder's avatar
Morten Welinder committed
345 346 347 348 349 350 351
	case OPER_FUNCALL: {
		GList *l;

		for (l = tree->u.function.arg_list; l; l = l->next)
			do_expr_tree_unref (l->data);
		g_list_free (tree->u.function.arg_list);
		symbol_unref (tree->u.function.symbol);
Arturo Espinosa's avatar
Arturo Espinosa committed
352
		break;
Morten Welinder's avatar
Morten Welinder committed
353
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
354

Michael Meeks's avatar
Michael Meeks committed
355 356 357
	case OPER_NAME:
		break;

358
	case OPER_ANY_BINARY:
Arturo Espinosa's avatar
Arturo Espinosa committed
359 360 361 362
		do_expr_tree_unref (tree->u.binary.value_a);
		do_expr_tree_unref (tree->u.binary.value_b);
		break;

363
	case OPER_ANY_UNARY:
Arturo Espinosa's avatar
Arturo Espinosa committed
364 365
		do_expr_tree_unref (tree->u.value);
		break;
366
	case OPER_ARRAY:
367 368 369
		if (tree->u.array.x == 0 && tree->u.array.y == 0) {
			if (tree->u.array.corner.func.value)
				value_release (tree->u.array.corner.func.value);
370
			do_expr_tree_unref (tree->u.array.corner.func.expr);
371
		}
372
		break;
373 374 375
	default:
		g_warning ("do_expr_tree_unref error\n");
		break;
Arturo Espinosa's avatar
Arturo Espinosa committed
376
	}
377

Morten Welinder's avatar
Morten Welinder committed
378
	g_free (tree);
379 380
}

Morten Welinder's avatar
Morten Welinder committed
381 382 383 384 385 386
/*
 * expr_tree_unref:
 * Decrements the ref_count for part of a tree.  (All trees are expected
 * to have been created with a ref-count of one, so when we hit zero, we
 * go down over the tree and unref the tree and its leaves stuff.)
 */
387 388 389 390 391 392
void
expr_tree_unref (ExprTree *tree)
{
	g_return_if_fail (tree != NULL);
	g_return_if_fail (tree->ref_count > 0);

Arturo Espinosa's avatar
Arturo Espinosa committed
393
	do_expr_tree_unref (tree);
394 395
}

396
static Value *
397
eval_funcall (EvalPosition const * const pos, ExprTree const *tree)
Arturo Espinosa's avatar
Arturo Espinosa committed
398
{
399
	FunctionEvalInfo ei;
400
	const Symbol *sym;
Arturo Espinosa's avatar
Arturo Espinosa committed
401
	FunctionDefinition *fd;
Michael Meeks's avatar
Michael Meeks committed
402
	GList *args;
403

404
	g_return_val_if_fail (pos != NULL, NULL);
Michael Meeks's avatar
Michael Meeks committed
405
	g_return_val_if_fail (tree != NULL, NULL);
406

407
	sym = tree->u.function.symbol;
408 409

	if (sym->type != SYMBOL_FUNCTION)
410
		return value_new_error (pos, _("Internal error"));
411

412
	fd = (FunctionDefinition *)sym->data;
413 414
	ei.func_def = fd;
	ei.pos = pos;
Michael Meeks's avatar
Michael Meeks committed
415
	args = tree->u.function.arg_list;
416

417
	return function_call_with_list (&ei, args);
Arturo Espinosa's avatar
Arturo Espinosa committed
418 419
}

Jody Goldberg's avatar
Jody Goldberg committed
420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468
/**
 * expr_implicit_intersection :
 * @ei: EvalInfo containing valid fd!
 * @v: a VALUE_CELLRANGE
 * 
 * Attempt to find the intersection between the calling cell and
 * some element of the 1 one unit wide or tall range.
 *
 * Always release the value passed in.
 *
 * Return value: 
 *     If the intersection succeeded return a duplicate of the value
 *     at the intersection point.  This value needs to be freed.
 **/
Value *
expr_implicit_intersection (EvalPosition const * const pos,
			    Value * const v)
{
	/*
	 * Handle the implicit union of a single row or
	 * column with the eval position.
	 * NOTE : We do not need to know if this is expression is
	 * being evaluated as an array or not because we can differentiate
	 * based on the required type for the argument.
	 */
	Value *res = NULL;
	CellRef const * const a = & v->v.cell_range.cell_a;
	CellRef const * const b = & v->v.cell_range.cell_b;

	if (a->sheet == b->sheet) {
		int a_col, a_row, b_col, b_row;
		cell_get_abs_col_row (a, &pos->eval, &a_col, &a_row);
		cell_get_abs_col_row (b, &pos->eval, &b_col, &b_row);
		if (a_row == b_row) {
			int const c = pos->eval.col;
			if (a_col <= c && c <= b_col)
				res = value_duplicate (value_area_get_x_y (pos, v, c - a_col, 0));
		}

		if (a_col == b_col) {
			int const r = pos->eval.row;
			if (a_row <= r && r <= b_row)
				res = value_duplicate (value_area_get_x_y (pos, v, 0, r - a_row));
		}
	}
	value_release (v);
	return res;
}

469
typedef enum {
Arturo Espinosa's avatar
Arturo Espinosa committed
470 471
	IS_EQUAL,
	IS_LESS,
472
	IS_GREATER,
473
	TYPE_MISMATCH
474 475 476
} compare_t;

static compare_t
477
compare_bool_bool (Value const * const va, Value const * const vb)
478
{
479 480 481 482 483 484 485 486 487 488 489 490 491
	gboolean err; /* Ignored */
	gboolean const a = value_get_as_bool (va, &err);
	gboolean const b = value_get_as_bool (vb, &err);
	if (a)
		return b ? IS_EQUAL : IS_GREATER;
	return b ? IS_LESS : IS_EQUAL;
}

static compare_t
compare_int_int (Value const * const va, Value const * const vb)
{
	int const a = value_get_as_int (va);
	int const b = value_get_as_int (vb);
492 493 494 495 496 497 498 499 500
	if (a == b)
		return IS_EQUAL;
	else if (a < b)
		return IS_LESS;
	else
		return IS_GREATER;
}

static compare_t
501
compare_float_float (Value const * const va, Value const * const vb)
502
{
503 504
	float_t const a = value_get_as_float (va);
	float_t const b = value_get_as_float (vb);
505 506 507 508 509 510 511
	if (a == b)
		return IS_EQUAL;
	else if (a < b)
		return IS_LESS;
	else
		return IS_GREATER;
}
Arturo Espinosa's avatar
Arturo Espinosa committed
512

513 514
/*
 * Compares two (Value *) and returns one of compare_t
Jody Goldberg's avatar
Jody Goldberg committed
515 516 517
 *
 * if pos is non null it will perform implict intersection for
 * cellranges.
518 519
 */
static compare_t
Jody Goldberg's avatar
Jody Goldberg committed
520
compare (Value const * const a, Value const * const b)
Arturo Espinosa's avatar
Arturo Espinosa committed
521
{
522 523
	ValueType ta, tb;

524 525 526 527
	/* Handle trivial and double NULL case */
	if (a == b)
		return IS_EQUAL;

528 529
	ta = value_is_empty_cell (a) ? VALUE_EMPTY : a->type;
	tb = value_is_empty_cell (b) ? VALUE_EMPTY : b->type;
530

531 532 533 534 535 536
	/* string > empty */
	if (ta == VALUE_STRING) {
		switch (tb) {
		/* Strings are > (empty, or number) */
		case VALUE_EMPTY : case VALUE_INTEGER : case VALUE_FLOAT :
			return IS_GREATER;
537

538 539 540
		/* Strings are < FALSE ?? */
		case VALUE_BOOLEAN :
			return IS_LESS;
541

542 543 544 545 546 547 548 549 550 551 552 553
		/* If both are strings compare as string */
		case VALUE_STRING :
		{
			int const t = strcasecmp (a->v.str->str, b->v.str->str);
			if (t == 0)
				return IS_EQUAL;
			else if (t > 0)
				return IS_GREATER;
			else
				return IS_LESS;
		}
		default :
554
			return TYPE_MISMATCH;
555
		}
556 557 558 559 560
	} else if (tb == VALUE_STRING) {
		switch (ta) {
		/* (empty, or number) < String */
		case VALUE_EMPTY : case VALUE_INTEGER : case VALUE_FLOAT :
			return IS_LESS;
561

562 563 564
		/* Strings are < FALSE ?? */
		case VALUE_BOOLEAN :
			return IS_GREATER;
565

566
		default :
567
			return TYPE_MISMATCH;
568 569 570
		}
	}

571 572 573 574 575 576
	/* Booleans > all numbers (Why did excel do this ??) */
	if (ta == VALUE_BOOLEAN && (tb == VALUE_INTEGER || tb == VALUE_FLOAT))
		return IS_GREATER;
	if (tb == VALUE_BOOLEAN && (ta == VALUE_INTEGER || ta == VALUE_FLOAT))
		return IS_LESS;

577 578 579
	switch ((ta > tb) ? ta : tb) {
	case VALUE_EMPTY:	/* Empty Empty compare */
		return IS_EQUAL;
580

581 582
	case VALUE_BOOLEAN:
		return compare_bool_bool (a, b);
583

584 585 586 587 588 589 590 591
	case VALUE_INTEGER:
		return compare_int_int (a, b);

	case VALUE_FLOAT:
		return compare_float_float (a, b);
	default:
		return TYPE_MISMATCH;
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
592 593
}

594 595 596 597 598
/*
 * Utility routine to ensure that all elements of a range are recalced as
 * necessary.
 */
static void
599
eval_range (EvalPosition const * const pos, Value *v)
600 601 602 603
{
	int start_col, start_row, end_col, end_row;
	CellRef * a = &v->v.cell_range.cell_a;
	CellRef * b = &v->v.cell_range.cell_b;
604
	Sheet * sheet = a->sheet ? a->sheet : pos->sheet;
605 606
	Cell * cell;
	int r, c;
607
	int const gen = pos->sheet->workbook->generation;
608

609 610
	cell_get_abs_col_row (a, &pos->eval, &start_col, &start_row);
	cell_get_abs_col_row (b, &pos->eval, &end_col, &end_row);
611

Michael Meeks's avatar
Michael Meeks committed
612
	if (b->sheet && a->sheet != b->sheet) {
613 614 615 616 617 618 619 620 621
		g_warning ("3D references not-fully supported.\n"
			   "Recalc may be incorrect");
		return;
	}

	for (r = start_row; r <= end_row; ++r)
		for (c = start_col; c <= end_col; ++c) {
			if ((cell = sheet_cell_get (sheet, c, r)) == NULL)
				continue;
622 623
			if (cell->generation != gen)
				cell_eval (cell);
624 625 626
		}
}

627
static Value *
628
eval_expr_real (EvalPosition const * const pos, ExprTree const * const tree,
629
		ExprEvalFlags const flags)
Arturo Espinosa's avatar
Arturo Espinosa committed
630
{
631
	Value *res = NULL, *a = NULL, *b = NULL;
632
	
Arturo Espinosa's avatar
Arturo Espinosa committed
633
	g_return_val_if_fail (tree != NULL, NULL);
634
	g_return_val_if_fail (pos != NULL, NULL);
635

636
	switch (tree->oper){
637 638 639 640 641 642
	case OPER_EQUAL:
	case OPER_NOT_EQUAL:
	case OPER_GT:
	case OPER_GTE:
	case OPER_LT:
	case OPER_LTE: {
Arturo Espinosa's avatar
Arturo Espinosa committed
643
		int comp;
644

645
		a = eval_expr_real (pos, tree->u.binary.value_a, flags);
Jody Goldberg's avatar
Jody Goldberg committed
646 647
		if (a != NULL) {
			if (a->type == VALUE_CELLRANGE) {
648
				a = expr_implicit_intersection (pos, a);
Jody Goldberg's avatar
Jody Goldberg committed
649
				if (a == NULL)
650
					return value_new_error (pos, gnumeric_err_VALUE);
Jody Goldberg's avatar
Jody Goldberg committed
651 652 653
			} else if (a->type == VALUE_ERROR)
				return a;
		}
Morten Welinder's avatar
Morten Welinder committed
654

655
		b = eval_expr_real (pos, tree->u.binary.value_b, flags);
Jody Goldberg's avatar
Jody Goldberg committed
656 657 658
		if (b != NULL) {
			Value *res = NULL;
			if (b->type == VALUE_CELLRANGE) {
659
				b = expr_implicit_intersection (pos, b);
Jody Goldberg's avatar
Jody Goldberg committed
660
				if (b == NULL)
661
					res = value_new_error (pos, gnumeric_err_VALUE);
Jody Goldberg's avatar
Jody Goldberg committed
662 663 664 665 666 667 668 669
			} else if (b->type == VALUE_ERROR)
				res = b;

			if (res != NULL) {
				if (a != NULL)
					value_release (a);
				return res;
			}
Morten Welinder's avatar
Morten Welinder committed
670
		}
671

Arturo Espinosa's avatar
Arturo Espinosa committed
672 673
		comp = compare (a, b);

674 675 676 677
		if (a != NULL)
			value_release (a);
		if (b != NULL)
			value_release (b);
678

Michael Meeks's avatar
Michael Meeks committed
679
		if (comp == TYPE_MISMATCH) {
680 681 682 683 684 685 686 687 688
			/* TODO TODO TODO : Make error more informative
			 *    regarding what is comparing to what
			 */
			/* For equality comparisons even errors are ok */
			if (tree->oper == OPER_EQUAL)
				return value_new_bool (FALSE);
			if (tree->oper == OPER_NOT_EQUAL)
				return value_new_bool (TRUE);

689
			return value_new_error (pos, gnumeric_err_VALUE);
690
		}
691

Michael Meeks's avatar
Michael Meeks committed
692
		switch (tree->oper) {
693
		case OPER_EQUAL:
694
			res = value_new_bool (comp == IS_EQUAL);
Arturo Espinosa's avatar
Arturo Espinosa committed
695 696
			break;

697
		case OPER_GT:
698
			res = value_new_bool (comp == IS_GREATER);
Arturo Espinosa's avatar
Arturo Espinosa committed
699 700
			break;

701
		case OPER_LT:
702
			res = value_new_bool (comp == IS_LESS);
Arturo Espinosa's avatar
Arturo Espinosa committed
703 704
			break;

705 706
		case OPER_NOT_EQUAL:
			res = value_new_bool (comp != IS_EQUAL);
Arturo Espinosa's avatar
Arturo Espinosa committed
707 708
			break;

709 710
		case OPER_LTE:
			res = value_new_bool (comp != IS_GREATER);
Arturo Espinosa's avatar
Arturo Espinosa committed
711 712
			break;

713 714
		case OPER_GTE:
			res = value_new_bool (comp != IS_LESS);
Arturo Espinosa's avatar
Arturo Espinosa committed
715
			break;
716

Arturo Espinosa's avatar
Arturo Espinosa committed
717
		default:
718
			g_assert_not_reached ();
719
			res = value_new_error (pos,
720
						_("Internal type error"));
Arturo Espinosa's avatar
Arturo Espinosa committed
721
		}
Morten Welinder's avatar
Morten Welinder committed
722
		return res;
Arturo Espinosa's avatar
Arturo Espinosa committed
723
	}
724

725 726 727 728 729
	case OPER_ADD:
	case OPER_SUB:
	case OPER_MULT:
	case OPER_DIV:
	case OPER_EXP:
730 731 732 733 734 735 736 737 738
		/*
		 * Priority
		 * 1) Error from A
		 * 2) #!VALUE error if A is not a number
		 * 3) Error from B
		 * 4) #!VALUE error if B is not a number
		 * 5) result of operation, or error specific to the operation
		 */

739 740 741
	        /* Ensure a != NULL */
		a = eval_expr (pos, tree->u.binary.value_a,
			       flags & (~EVAL_PERMIT_EMPTY));
Jody Goldberg's avatar
Jody Goldberg committed
742 743 744

		/* Handle implicit intersection */
		if (a->type == VALUE_CELLRANGE) {
745
			a = expr_implicit_intersection (pos, a);
Jody Goldberg's avatar
Jody Goldberg committed
746
			if (a == NULL)
747
				return value_new_error (pos, gnumeric_err_VALUE);
Jody Goldberg's avatar
Jody Goldberg committed
748 749
		}

750 751
		/* 1) Error from A */
		if (a->type == VALUE_ERROR)
752
			return a;
753

754 755 756
		/* 2) #!VALUE error if A is not a number */
		if (!VALUE_IS_NUMBER (a)) {
			value_release (a);
757
			return value_new_error (pos, gnumeric_err_VALUE);
758 759 760
		}

	        /* Garantees that b != NULL */
761 762
		b = eval_expr (pos, tree->u.binary.value_b,
			       flags & (~EVAL_PERMIT_EMPTY));
Arturo Espinosa's avatar
Arturo Espinosa committed
763

Jody Goldberg's avatar
Jody Goldberg committed
764 765
		/* Handle implicit intersection */
		if (b->type == VALUE_CELLRANGE) {
766
			b = expr_implicit_intersection (pos, a);
Jody Goldberg's avatar
Jody Goldberg committed
767
			if (b == NULL)
768
				return value_new_error (pos, gnumeric_err_VALUE);
Jody Goldberg's avatar
Jody Goldberg committed
769 770
		}

771 772
		/* 3) Error from B */
		if (b->type == VALUE_ERROR) {
773
			value_release (a);
774
			return b;
Arturo Espinosa's avatar
Arturo Espinosa committed
775
		}
776

777 778
		/* 4) #!VALUE error if B is not a number */
		if (!VALUE_IS_NUMBER (b)) {
779 780
			value_release (a);
			value_release (b);
781
			return value_new_error (pos, gnumeric_err_VALUE);
Arturo Espinosa's avatar
Arturo Espinosa committed
782
		}
783

784
		if (a->type != VALUE_FLOAT && b->type != VALUE_FLOAT){
Morten Welinder's avatar
Morten Welinder committed
785
			int ia = value_get_as_int (a);
786
			int ib = value_get_as_int (b);
787 788 789
			double dres;
			int ires;

Morten Welinder's avatar
Morten Welinder committed
790 791
			value_release (a);
			value_release (b);
792

793 794
			/* FIXME: we could use simple (cheap) heuristics to
			   catch most cases where overflow will not happen.  */
795
			switch (tree->oper){
796 797 798 799 800 801 802 803
			case OPER_ADD:
				dres = (double)ia + (double)ib;
				ires = (int)dres;
				if (dres == ires)
					return value_new_int (ires);
				else
					return value_new_float ((float_t) dres);

804
			case OPER_SUB:
805 806 807 808 809 810
				dres = (double)ia - (double)ib;
				ires = (int)dres;
				if (dres == ires)
					return value_new_int (ires);
				else
					return value_new_float ((float_t) dres);
811

812
			case OPER_MULT:
813 814 815 816 817 818
				dres = (double)ia * (double)ib;
				ires = (int)dres;
				if (dres == ires)
					return value_new_int (ires);
				else
					return value_new_float ((float_t) dres);
Arturo Espinosa's avatar
Arturo Espinosa committed
819

820
			case OPER_DIV:
821
				if (ib == 0)
822
					return value_new_error (pos, gnumeric_err_DIV0);
823 824 825 826 827 828
				dres = (double)ia / (double)ib;
				ires = (int)dres;
				if (dres == ires)
					return value_new_int (ires);
				else
					return value_new_float ((float_t) dres);
829 830

			case OPER_EXP:
831
				if (ia == 0 && ib <= 0)
832
					return value_new_error (pos, gnumeric_err_NUM);
833 834 835 836 837 838 839
				dres = pow ((double)ia, (double)ib);
				ires = (int)dres;
				if (dres == ires)
					return value_new_int (ires);
				else
					return value_new_float ((float_t) dres);

Arturo Espinosa's avatar
Arturo Espinosa committed
840
			default:
841
				abort ();
Arturo Espinosa's avatar
Arturo Espinosa committed
842 843
			}
		} else {
Arturo Espinosa's avatar
Arturo Espinosa committed
844 845
			float_t const va = value_get_as_float (a);
			float_t const vb = value_get_as_float (b);
846 847
			value_release (a);
			value_release (b);
848

849
			switch (tree->oper){
850
			case OPER_ADD:
Arturo Espinosa's avatar
Arturo Espinosa committed
851
				return value_new_float (va + vb);
852

853
			case OPER_SUB:
Arturo Espinosa's avatar
Arturo Espinosa committed
854
				return value_new_float (va - vb);
855

856
			case OPER_MULT:
Arturo Espinosa's avatar
Arturo Espinosa committed
857
				return value_new_float (va * vb);
858

859
			case OPER_DIV:
860
				return (vb == 0.0)
861
				    ? value_new_error (pos,
862
						       gnumeric_err_DIV0)
Arturo Espinosa's avatar
Arturo Espinosa committed
863
				    : value_new_float (va / vb);
864

865
			case OPER_EXP:
866 867
				if ((va == 0 && vb <= 0) ||
				    (va < 0 && vb != (int)vb))
868
					return value_new_error (pos, gnumeric_err_NUM);
Arturo Espinosa's avatar
Arturo Espinosa committed
869
				return value_new_float (pow (va, vb));
870

Arturo Espinosa's avatar
Arturo Espinosa committed
871
			default:
872
				break;
Arturo Espinosa's avatar
Arturo Espinosa committed
873 874
			}
		}
875
		return value_new_error (pos, _("Unknown operator"));
876

Jody Goldberg's avatar
Jody Goldberg committed
877
	case OPER_PERCENT:
Jody Goldberg's avatar
Jody Goldberg committed
878 879
	case OPER_UNARY_NEG:
	case OPER_UNARY_PLUS:
880
	        /* Garantees that a != NULL */
881
		a = eval_expr (pos, tree->u.value, flags & (~EVAL_PERMIT_EMPTY));
Jody Goldberg's avatar
Jody Goldberg committed
882 883 884

		/* Handle implicit intersection */
		if (a->type == VALUE_CELLRANGE) {
885
			a = expr_implicit_intersection (pos, a);
Jody Goldberg's avatar
Jody Goldberg committed
886
			if (a == NULL)
887
				return value_new_error (pos, gnumeric_err_VALUE);
Jody Goldberg's avatar
Jody Goldberg committed
888 889
		}

890 891
		if (a->type == VALUE_ERROR)
			return a;
Jody Goldberg's avatar
Jody Goldberg committed
892

Jody Goldberg's avatar
Jody Goldberg committed
893 894 895
		if (tree->oper == OPER_UNARY_PLUS)
			return a;

896 897
		if (!VALUE_IS_NUMBER (a)){
			value_release (a);
898
			return value_new_error (pos, gnumeric_err_VALUE);
899
		}
Jody Goldberg's avatar
Jody Goldberg committed
900
		if (tree->oper == OPER_UNARY_NEG) {
Jody Goldberg's avatar
Jody Goldberg committed
901 902 903 904 905 906 907 908
			if (a->type == VALUE_INTEGER)
				res = value_new_int (-a->v.v_int);
			else if (a->type == VALUE_FLOAT)
				res = value_new_float (-a->v.v_float);
			else
				res = value_new_bool (!a->v.v_float);
		} else
			res = value_new_float (value_get_as_float (a) * .01);
909
		value_release (a);
Morten Welinder's avatar
Morten Welinder committed
910
		return res;
911

912
	case OPER_CONCAT: {
913 914
		char *sa, *sb, *tmp;

915
		a = eval_expr_real (pos, tree->u.binary.value_a, flags);
916
		if (a != NULL && a->type == VALUE_ERROR)
917
			return a;
918
		b = eval_expr_real (pos, tree->u.binary.value_b, flags);
919 920 921
		if (b != NULL && b->type == VALUE_ERROR) {
			if (a != NULL)
				value_release (a);
922
			return b;
923 924
		}

Michael Meeks's avatar
Michael Meeks committed
925 926
		sa = value_get_as_string (a);
		sb = value_get_as_string (b);
Jeff Garzik's avatar
Jeff Garzik committed
927
		tmp = g_strconcat (sa, sb, NULL);
Morten Welinder's avatar
Morten Welinder committed
928 929
		res = value_new_string (tmp);

930 931 932 933
		g_free (sa);
		g_free (sb);
		g_free (tmp);

934
		if (a != NULL)
935
		value_release (a);
936
		if (b != NULL)
937
		value_release (b);
Morten Welinder's avatar
Morten Welinder committed
938
		return res;
939
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
940

941
	case OPER_FUNCALL:
942
		return eval_funcall (pos, tree);
Arturo Espinosa's avatar
Arturo Espinosa committed
943

Michael Meeks's avatar
Michael Meeks committed
944
	case OPER_NAME:
945
		return eval_expr_name (pos, tree->u.name, flags);
Michael Meeks's avatar
Michael Meeks committed
946

947
	case OPER_VAR: {
948
		Sheet *cell_sheet;
949
		CellRef const *ref;
Arturo Espinosa's avatar
Arturo Espinosa committed
950 951
		Cell *cell;
		int col, row;
952

953
		if (pos->sheet == NULL) {
Arturo Espinosa's avatar
Arturo Espinosa committed
954
			/* Only the test program requests this */
Morten Welinder's avatar
Morten Welinder committed
955
			return value_new_float (3.14);
Arturo Espinosa's avatar
Arturo Espinosa committed
956 957
		}

958
		ref = &tree->u.ref;
959
		cell_get_abs_col_row (ref, &pos->eval, &col, &row);
Arturo Espinosa's avatar
Today:  
Arturo Espinosa committed
960

961
		cell_sheet = eval_sheet (ref->sheet, pos->sheet);
962
		cell = sheet_cell_get (cell_sheet, col, row);
963 964
		if (cell == NULL)
			return NULL;
965

966
		if (cell->generation != pos->sheet->workbook->generation)
967
			cell_eval (cell);
968

969
		return value_duplicate (cell->value);
Arturo Espinosa's avatar
Arturo Espinosa committed
970
	}
971

972
	case OPER_CONSTANT:
973
		res = tree->u.constant;
974 975
		if (res->type != VALUE_CELLRANGE)
			return value_duplicate (res);
976
		if (flags & EVAL_PERMIT_NON_SCALAR) {
977
			eval_range (pos, res);
978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021
			return value_duplicate (res);
		} else {
			/*
			 * Handle the implicit union of a single row or
			 * column with the eval position.
			 * NOTE : We do not need to know if this is expression is
			 * being evaluated as an array or not because we can differentiate
			 * based on the required type for the argument.
			 */
			CellRef const * const a = & res->v.cell_range.cell_a;
			CellRef const * const b = & res->v.cell_range.cell_b;
			gboolean found = FALSE;

			if (a->sheet == b->sheet) {
				int a_col, a_row, b_col, b_row;
				int c = pos->eval.col;
				int r = pos->eval.row;

				cell_get_abs_col_row (a, &pos->eval, &a_col, &a_row);
				cell_get_abs_col_row (b, &pos->eval, &b_col, &b_row);
				if (a_row == b_row) {
					if (a_col <= c && c <= b_col) {
						r = a_row;
						found = TRUE;
					}
				} else if (a_col == b_col) {
					if (a_row <= r && r <= b_row) {
						c = a_col;
						found = TRUE;
					}
				}
				if (found) {
					Cell * cell = sheet_cell_get (pos->sheet, c, r);
					if (cell == NULL)
						return NULL;

					if (cell->generation != pos->sheet->workbook->generation)
						cell_eval (cell);

					return value_duplicate (cell->value);
				}
			}
			return value_new_error (pos, gnumeric_err_VALUE);
		}
1022

1023 1024 1025
	case OPER_ARRAY:
	{
		/* The upper left corner manages the recalc of the expr */
1026 1027
		int x = tree->u.array.x;
		int y = tree->u.array.y;
1028
		if (x == 0 && y == 0){
1029 1030 1031 1032 1033 1034
			/* Release old value if necessary */
			a = tree->u.array.corner.func.value;
			if (a != NULL)
				value_release (a);

			/* Store real result (cast away const)*/
Jody Goldberg's avatar
Jody Goldberg committed
1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049
			/* FIXME : Call a wrapper routine that will iterate over the
			 * the array and evaluate the expression for all elements
			 *
			 * Figure out when to iterate and when to do array operations.
			 * ie
			 * A1:A3 = '=B1:B3^2'  Will iterate over all the elements and
			 *     re-evaluate.
			 * whereas
			 * A1:A3 = '=bob(B1:B3)'  Will call bob once if it returns an
			 *     array.
			 *
			 * This may be as simple as evaluating the corner.  If that is
			 * is an array return the result, else build an array and
			 * iterate over the elements, but that theory needs validation.
			 */
1050
			a = eval_expr_real (pos, tree->u.array.corner.func.expr, FALSE);
1051
			*((Value **)&(tree->u.array.corner.func.value)) = a;
1052
		} else {
1053
			ExprTree const * const array =
1054
			    expr_tree_array_formula_corner (tree, pos);
1055 1056 1057 1058
			if (array)
				a = array->u.array.corner.func.value;
			else
				a = NULL;
1059
		}
1060

1061 1062
		if (a != NULL &&
		    (a->type == VALUE_CELLRANGE || a->type == VALUE_ARRAY)) {
1063 1064
			int const num_x = value_area_get_width (pos, a);
			int const num_y = value_area_get_height (pos, a);
1065

1066
			/* Evaluate relative to the upper left corner */
1067
			EvalPosition tmp_ep = *pos;
Jody Goldberg's avatar
Jody Goldberg committed
1068 1069
			tmp_ep.eval.col -= x;
			tmp_ep.eval.row -= y;
1070 1071 1072 1073 1074 1075 1076

			/* If the src array is 1 element wide or tall we wrap */
			if (x >= 1 && num_x == 1)
				x = 0;
			if (y >= 1 && num_y == 1)
				y = 0;
			if (x >= num_x || y >= num_y)
1077
				return value_new_error (pos, gnumeric_err_NA);
1078 1079 1080

			a = (Value *)value_area_get_x_y (&tmp_ep, a, x, y);
		}
1081 1082 1083

		if (a == NULL)
			return NULL;
1084 1085
		return value_duplicate (a);
	}
1086
	}
1087

1088
	return value_new_error (pos, _("Unknown evaluation error"));
1089 1090 1091
}

Value *
1092 1093
eval_expr (EvalPosition const * const pos, ExprTree const *tree,
	   ExprEvalFlags const flags)
1094
{
1095 1096
	Value * res = eval_expr_real (pos, tree, flags);

Jody Goldberg's avatar
Jody Goldberg committed
1097 1098 1099
	if (res == NULL)
		return (flags & EVAL_PERMIT_EMPTY)
		    ? NULL : value_new_int (0);