expr.c 10.8 KB
Newer Older
1
#include <config.h>
Arturo Espinosa's avatar
Arturo Espinosa committed
2
#include <gnome.h>
Arturo Espinosa's avatar
Arturo Espinosa committed
3
#include <math.h>
Arturo Espinosa's avatar
Arturo Espinosa committed
4
#include "gnumeric.h"
Arturo Espinosa's avatar
Arturo Espinosa committed
5
#include "expr.h"
6 7

char *parser_expr;
8
ParseErr parser_error;
9 10
ExprTree *parser_result;
int parser_col, parser_row;
11

12 13
ExprTree *
expr_parse_string (char *expr, int col, int row, char **error_msg)
14 15
{
	parser_expr = expr;
16
	parser_error = PARSE_OK;
17 18 19
	parser_col = col;
	parser_row = row;
		
20
	yyparse ();
21 22 23
	switch (parser_error){
	case PARSE_OK:
		*error_msg = NULL;
24
		parser_result->ref_count = 1;
Arturo Espinosa's avatar
Arturo Espinosa committed
25
		return parser_result;
26

Arturo Espinosa's avatar
Arturo Espinosa committed
27 28 29 30
	case PARSE_ERR_SYNTAX:
		*error_msg = _("Syntax error");
		break;
			
31 32 33 34
	case PARSE_ERR_NO_QUOTE:
		*error_msg = _("Missing quote");
		break;
	}
35 36 37
	return NULL;
}

38 39 40 41 42 43 44
/*
 * eval_expr_release:
 * @ExprTree:  The tree to be released
 *
 * This releases all of the resources used by a tree.  
 * It is only used internally by eval_expr_unref
 */
Arturo Espinosa's avatar
Arturo Espinosa committed
45
void
46
eval_expr_release (ExprTree *tree)
47
{
48
	g_return_if_fail (tree != NULL);
49
	
50
	switch (tree->oper){
51 52 53
	case OP_VAR:
		break;
		
54
	case OP_CONSTANT:
55
		value_release (tree->u.constant);
56 57 58
		break;
		
	case OP_FUNCALL:
59
		symbol_unref (tree->u.function.symbol);
60 61 62 63 64 65 66 67
		break;

	case OP_ADD:
	case OP_SUB:
	case OP_MULT:
	case OP_DIV:
	case OP_EXP:
	case OP_CONCAT:
68 69
		eval_expr_release (tree->u.binary.value_a);
		eval_expr_release (tree->u.binary.value_b);
70 71 72
		break;

	case OP_NEG:
73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
		eval_expr_release (tree->u.value);
		break;
		
	default:
		g_warning ("Unknown ExprTree type passed to eval_expr_release\n");
	}
	g_free (tree);
}

void
expr_tree_ref (ExprTree *tree)
{
	g_return_if_fail (tree != NULL);
	g_return_if_fail (tree->ref_count > 0);

	tree->ref_count++;
}

void
expr_tree_unref (ExprTree *tree)
{
	g_return_if_fail (tree != NULL);
	g_return_if_fail (tree->ref_count > 0);

	tree->ref_count--;
	if (tree->ref_count == 0)
		eval_expr_release (tree);
}

void
value_release (Value *value)
{
Arturo Espinosa's avatar
Arturo Espinosa committed
105 106
	g_return_if_fail (value != NULL);
	
107 108 109 110 111 112 113
	switch (value->type){
	case VALUE_STRING:
		string_unref (value->v.str);
		break;

	case VALUE_INTEGER:
		mpz_clear (value->v.v_int);
114 115
		break;
		
116 117 118 119
	case VALUE_FLOAT:
		mpf_clear (value->v.v_float);
		break;

Arturo Espinosa's avatar
Arturo Espinosa committed
120 121 122 123 124 125 126 127 128 129 130
	case VALUE_ARRAY: {
		GList *l;

		for (l = value->v.array; l; l = l->next)
			value_release (l->data);
		g_list_free (l);
	}
	
	case VALUE_CELLRANGE:
		break;
		
131
	default:
132
		g_warning ("Unknown value type passed to value_release\n");
133
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
134
	g_free (value);
135
}
136

Arturo Espinosa's avatar
Arturo Espinosa committed
137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166
/*
 * Copies a Value.
 */
void
value_copy_to (Value *dest, Value *source)
{
	g_return_if_fail (dest != NULL);
	g_return_if_fail (source != NULL);

	dest->type = source->type;
	
	switch (source->type){
	case VALUE_STRING:
		dest->v.str = source->v.str;
		string_ref (dest->v.str);
		break;

	case VALUE_INTEGER:
		dest->v.v_int = source->v.v_int;
		break;

	case VALUE_FLOAT:
		dest->v.v_float = source->v.v_float;
		break;

	default:
		g_warning ("value_copy_to: VALUE type not yet supported\n");
	}
}

Arturo Espinosa's avatar
Arturo Espinosa committed
167 168 169 170
/*
 * Casts a value to float if it is integer, and returns
 * a new Value * if required
 */
171
Value *
172
value_cast_to_float (Value *v)
Arturo Espinosa's avatar
Arturo Espinosa committed
173 174 175 176 177 178 179 180 181 182 183
{
	Value *newv;
	
	g_return_val_if_fail (VALUE_IS_NUMBER (v), NULL);

	if (v->type == VALUE_FLOAT)
		return v;
	
	newv = g_new (Value, 1);
	newv->type = VALUE_FLOAT;
	mpf_set_z (newv->v.v_float, v->v.v_int);
184
	value_release (v);
Arturo Espinosa's avatar
Arturo Espinosa committed
185 186 187 188
	
	return newv;
}

Arturo Espinosa's avatar
Arturo Espinosa committed
189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215
int
value_get_bool (Value *v, int *err)
{
	*err = 0;

	if (v->type == VALUE_STRING)
		return atoi (v->v.str->str);

	if (v->type == VALUE_CELLRANGE){
		*err = 1;
		return 0;
	}

	if (v->type == VALUE_INTEGER)
		return v->v.v_int != 0;

	if (v->type == VALUE_FLOAT)
		return v->v.v_float != 0.0;

	if (v->type == VALUE_ARRAY)
		return 0;
	
	g_warning ("Unhandled value in value_get_boolean");

	return 0;
}

Arturo Espinosa's avatar
Arturo Espinosa committed
216 217 218 219 220 221 222 223 224 225 226 227 228 229 230
float_t
value_get_as_double (Value *v)
{
	if (v->type == VALUE_STRING){
		return atof (v->v.str->str);
	}

	if (v->type == VALUE_CELLRANGE){
		g_warning ("Getting range as a double: what to do?");
		return 0.0;
	}

	if (v->type == VALUE_INTEGER)
		return (float_t) v->v.v_int;

Arturo Espinosa's avatar
Arturo Espinosa committed
231 232 233
	if (v->type == VALUE_ARRAY)
		return 0.0;
	
Arturo Espinosa's avatar
Arturo Espinosa committed
234
	return (float_t) v->v.v_float;
Arturo Espinosa's avatar
Arturo Espinosa committed
235 236
}

Arturo Espinosa's avatar
Arturo Espinosa committed
237 238
static Value *
eval_cell_value (Sheet *sheet, Value *value)
239
{
Arturo Espinosa's avatar
Arturo Espinosa committed
240 241 242 243 244 245 246 247
	Value *res;
	
	res = g_new (Value, 1);
	res->type = value->type;
	
	switch (res->type){
	case VALUE_STRING:
		res->v.str = value->v.str;
248
		string_ref (res->v.str);
Arturo Espinosa's avatar
Arturo Espinosa committed
249 250 251 252 253 254 255 256 257 258 259
		break;
		
	case VALUE_INTEGER:
		mpz_init (res->v.v_int);
		mpz_set  (res->v.v_int, value->v.v_int);
		break;
		
	case VALUE_FLOAT:
		mpf_init (res->v.v_float);
		mpf_set (res->v.v_float, value->v.v_float);
		break;
Arturo Espinosa's avatar
Arturo Espinosa committed
260 261 262 263 264 265 266

	case VALUE_ARRAY:
		g_warning ("VALUE_ARRAY not handled in eval_cell_value\n");
		res->type = VALUE_INTEGER;
		res->v.v_int = 0;
		break;
			
Arturo Espinosa's avatar
Arturo Espinosa committed
267 268 269 270 271 272 273
	case VALUE_CELLRANGE:
		res->v.cell_range = value->v.cell_range;
		break;
	}
	return res;
}

Arturo Espinosa's avatar
Arturo Espinosa committed
274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316
static Value *
eval_funcall (Sheet *sheet, ExprTree *tree, int eval_col, int eval_row, char **error_string)
{
	FunctionDefinition *fd;
	GList *l;
	int argc, arg, i;
	Value *v;
	
	fd = (FunctionDefinition *) tree->u.function.symbol->data;
	
	l = tree->u.function.arg_list;
	argc = g_list_length (l);

	if (fd->expr_fn)
	{
		/* Functions that deal with ExprNodes */
		v = fd->expr_fn (sheet, l, eval_col, eval_row, error_string);
	}
	else
	{
		/* Functions that take pre-computed Values */
		Value **values;
		int fn_argc;
		char *arg_type = fd->args;
		
		fn_argc = strlen (fd->args);
		
		if (fn_argc != argc){
			*error_string = _("Invalid number of arguments");
			return NULL;
		}

		values = g_new (Value *, argc);
		
		for (arg = 0; l; l = l->next, arg++, arg_type++){
			ExprTree *t = (ExprTree *) l->data;
			
			v = eval_expr (sheet, t, eval_col, eval_row, error_string);
			if (v == NULL)
				goto free_list;
			
			values [arg] = v;
		}
317
		v = fd->fn (values, error_string);
Arturo Espinosa's avatar
Arturo Espinosa committed
318 319 320 321 322 323 324 325 326 327

	free_list:
		for (i = 0; i < arg; i++)
			value_release (values [i]);
		g_free (values);
		return v;
	}
	return v;
}

Arturo Espinosa's avatar
Arturo Espinosa committed
328 329 330 331 332 333 334 335 336 337 338 339 340
enum {
	IS_EQUAL,
	IS_LESS,
	IS_BIGGER,
};

static int
compare (Value *a, Value *b)
{
	g_warning ("Value comparission is not yet implemented\n");
	return IS_EQUAL;
}

Arturo Espinosa's avatar
Arturo Espinosa committed
341
Value *
342
eval_expr (void *asheet, ExprTree *tree, int eval_col, int eval_row, char **error_string)
Arturo Espinosa's avatar
Arturo Espinosa committed
343 344 345
{
	Value *a, *b, *res;
	Sheet *sheet = asheet;
Arturo Espinosa's avatar
Arturo Espinosa committed
346 347 348 349 350

	g_return_val_if_fail (tree != NULL, NULL);
	g_return_val_if_fail (asheet != NULL, NULL);
	g_return_val_if_fail (error_string != NULL, NULL);
	g_return_val_if_fail (IS_SHEET (asheet), NULL);
Arturo Espinosa's avatar
Arturo Espinosa committed
351
	
352
	switch (tree->oper){
Arturo Espinosa's avatar
Arturo Espinosa committed
353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409
	case OP_EQUAL:
	case OP_NOT_EQUAL:
	case OP_GT:
	case OP_GTE:
	case OP_LT:
	case OP_LTE: {
		int comp;
		
		a = eval_expr (sheet, tree->u.binary.value_a,
			       eval_col, eval_row, error_string);
		b = eval_expr (sheet, tree->u.binary.value_b,
			       eval_col, eval_row, error_string);
		if (!(a && b)){
			if (a)
				value_release (a);
			if (b)
				value_release (b);
			return NULL;
		}
		res = g_new (Value, 1);
		res->type = VALUE_INTEGER;

		comp = compare (a, b);

		switch (tree->oper){
		case OP_EQUAL:
			res->v.v_int = comp == IS_EQUAL;
			break;

		case OP_GT:
			res->v.v_int = comp == IS_BIGGER;
			break;

		case OP_LT:
			res->v.v_int = comp == IS_LESS;
			break;

		case OP_LTE:
			res->v.v_int = (comp == IS_EQUAL || comp == IS_LESS);
			break;

		case OP_GTE:
			res->v.v_int = (comp == IS_EQUAL || comp == IS_BIGGER);
			break;

		case OP_NOT_EQUAL:
			res->v.v_int = comp != IS_EQUAL;
			break;
			
		default:
			g_warning ("This should never be reached: comparission ops\n");
		}
		value_release (a);
		value_release (b);
		return res;
	}
	
Arturo Espinosa's avatar
Arturo Espinosa committed
410 411 412 413 414
	case OP_ADD:
	case OP_SUB:
	case OP_MULT:
	case OP_DIV:
	case OP_EXP:
415 416 417 418
		a = eval_expr (sheet, tree->u.binary.value_a,
			       eval_col, eval_row, error_string);
		b = eval_expr (sheet, tree->u.binary.value_b,
			       eval_col, eval_row, error_string);
Arturo Espinosa's avatar
Arturo Espinosa committed
419 420 421

		if (!(a && b)){
			if (a)
422
				value_release (a);
Arturo Espinosa's avatar
Arturo Espinosa committed
423
			if (b)
424
				value_release (b);
Arturo Espinosa's avatar
Arturo Espinosa committed
425 426 427 428
			return NULL;
		}
		
		if (!VALUE_IS_NUMBER (a) || !VALUE_IS_NUMBER (b)){
429 430
			value_release (a);
			value_release (b);
Arturo Espinosa's avatar
Arturo Espinosa committed
431 432 433 434 435 436 437 438
			*error_string = _("Type mismatch");
			return NULL;
		}
		
		res = g_new (Value, 1);
		if (a->type == VALUE_INTEGER && b->type == VALUE_INTEGER){
			res->type = VALUE_INTEGER;
			
439
			switch (tree->oper){
Arturo Espinosa's avatar
Arturo Espinosa committed
440
			case OP_ADD:
Arturo Espinosa's avatar
Arturo Espinosa committed
441
				res->v.v_int = a->v.v_int + b->v.v_int;
Arturo Espinosa's avatar
Arturo Espinosa committed
442 443 444
				break;
				
			case OP_SUB:
Arturo Espinosa's avatar
Arturo Espinosa committed
445
				res->v.v_int = a->v.v_int - b->v.v_int;
Arturo Espinosa's avatar
Arturo Espinosa committed
446 447 448
				break;
				
			case OP_MULT:
Arturo Espinosa's avatar
Arturo Espinosa committed
449
				res->v.v_int = a->v.v_int * b->v.v_int;
Arturo Espinosa's avatar
Arturo Espinosa committed
450
				break;
Arturo Espinosa's avatar
Arturo Espinosa committed
451

Arturo Espinosa's avatar
Arturo Espinosa committed
452
			case OP_DIV:
Arturo Espinosa's avatar
Arturo Espinosa committed
453
				if (b->v.v_int == 0){
454 455 456
					value_release (a);
					value_release (b);
					value_release (res);
Arturo Espinosa's avatar
Arturo Espinosa committed
457 458 459 460
					*error_string = _("Division by zero");
					return NULL;
				}
					
Arturo Espinosa's avatar
Arturo Espinosa committed
461
				res->v.v_int =  a->v.v_int / b->v.v_int;
Arturo Espinosa's avatar
Arturo Espinosa committed
462 463
				break;
				
Arturo Espinosa's avatar
Arturo Espinosa committed
464 465
			case OP_EXP: 
				res->v.v_int = pow (a->v.v_int, b->v.v_int);
Arturo Espinosa's avatar
Arturo Espinosa committed
466 467 468 469 470
				break;
			default:
			}
		} else {
			res->type = VALUE_FLOAT;
Arturo Espinosa's avatar
Arturo Espinosa committed
471
			res->v.v_float = 0.0;
472 473
			a = value_cast_to_float (a);
			b = value_cast_to_float (b);
Arturo Espinosa's avatar
Arturo Espinosa committed
474
			
475
			switch (tree->oper){
Arturo Espinosa's avatar
Arturo Espinosa committed
476
			case OP_ADD:
Arturo Espinosa's avatar
Arturo Espinosa committed
477
				res->v.v_float = a->v.v_float + b->v.v_float;
Arturo Espinosa's avatar
Arturo Espinosa committed
478 479 480
				break;
				
			case OP_SUB:
Arturo Espinosa's avatar
Arturo Espinosa committed
481
				res->v.v_float = a->v.v_float - b->v.v_float;
Arturo Espinosa's avatar
Arturo Espinosa committed
482 483 484
				break;
				
			case OP_MULT:
Arturo Espinosa's avatar
Arturo Espinosa committed
485
				res->v.v_float = a->v.v_float * b->v.v_float;
Arturo Espinosa's avatar
Arturo Espinosa committed
486 487 488
				break;
				
			case OP_DIV:
Arturo Espinosa's avatar
Arturo Espinosa committed
489
				if (b->v.v_float == 0.0){
490 491 492
					value_release (a);
					value_release (b);
					value_release (res);
Arturo Espinosa's avatar
Arturo Espinosa committed
493 494 495
					*error_string = _("Division by zero");
					return NULL;
				}
Arturo Espinosa's avatar
Arturo Espinosa committed
496 497

				res->v.v_float = a->v.v_float / b->v.v_float;
Arturo Espinosa's avatar
Arturo Espinosa committed
498 499 500
				break;
				
			case OP_EXP:
Arturo Espinosa's avatar
Arturo Espinosa committed
501
				res->v.v_float = pow (a->v.v_float, b->v.v_float);
Arturo Espinosa's avatar
Arturo Espinosa committed
502 503 504 505
				break;
			default:
			}
		}
506 507
		value_release (a);
		value_release (b);
Arturo Espinosa's avatar
Arturo Espinosa committed
508 509 510 511 512 513 514 515
		return res;
		
	case OP_CONCAT:
		g_warning ("Concat not implemented yet\n");
		*error_string = _("OOPS");
		return NULL;

	case OP_FUNCALL:
Arturo Espinosa's avatar
Arturo Espinosa committed
516
		return eval_funcall (sheet, tree, eval_col, eval_row, error_string);
Arturo Espinosa's avatar
Arturo Espinosa committed
517 518

	case OP_CONSTANT:
519
		return eval_cell_value (sheet, tree->u.constant);
Arturo Espinosa's avatar
Arturo Espinosa committed
520 521

	case OP_VAR:{
522
		CellRef *ref;
Arturo Espinosa's avatar
Arturo Espinosa committed
523 524 525 526 527 528 529 530 531 532 533 534 535
		Cell *cell;
		int col, row;
		
		if (sheet == NULL){
			/* Only the test program requests this */
			res = g_new (Value, 1);

			res->type = VALUE_FLOAT;
			res->v.v_float = 3.14;
			
			return res;
		}

536
		ref = &tree->u.constant->v.cell;
Arturo Espinosa's avatar
Arturo Espinosa committed
537
		cell_get_abs_col_row (&tree->u.constant->v.cell, eval_col, eval_row, &col, &row);
538
		
Arturo Espinosa's avatar
Arturo Espinosa committed
539 540
		cell = sheet_cell_get (sheet, col, row);
		
Arturo Espinosa's avatar
Arturo Espinosa committed
541
		if (!cell || !cell->value){
Arturo Espinosa's avatar
Arturo Espinosa committed
542 543 544 545 546 547 548 549 550 551
			res = g_new (Value, 1);
			
			res->type = VALUE_INTEGER;
			res->v.v_int = 0;
		} else {
			return eval_cell_value (sheet, cell->value);
		}
		return res;
	}
	case OP_NEG:
552 553
		a = eval_expr (sheet, tree->u.value,
			       eval_col, eval_row, error_string);
Arturo Espinosa's avatar
Arturo Espinosa committed
554 555 556 557
		if (!a)
			return NULL;
		if (!VALUE_IS_NUMBER (a)){
			*error_string = _("Type mismatch");
558
			value_release (a);
Arturo Espinosa's avatar
Arturo Espinosa committed
559 560 561 562
			return NULL;
		}
		res = g_new (Value, 1);
		if (a->type == VALUE_INTEGER){
Arturo Espinosa's avatar
Arturo Espinosa committed
563
			res->v.v_int = -a->v.v_int;
Arturo Espinosa's avatar
Arturo Espinosa committed
564
		} else {
Arturo Espinosa's avatar
Arturo Espinosa committed
565
			res->v.v_float = -a->v.v_float;
Arturo Espinosa's avatar
Arturo Espinosa committed
566
		}
567
		value_release (a);
Arturo Espinosa's avatar
Arturo Espinosa committed
568
		return res;
569
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
570 571 572
	
	*error_string = _("Unknown evaluation error");
	return NULL;
573
}
Arturo Espinosa's avatar
Arturo Espinosa committed
574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590

void
cell_get_abs_col_row (CellRef *cell_ref, int eval_col, int eval_row, int *col, int *row)
{
	g_return_if_fail (cell_ref != NULL);

	if (cell_ref->col_relative)
		*col = eval_col + cell_ref->col;
	else
		*col = cell_ref->col;

	if (cell_ref->row_relative)
		*row = eval_row + cell_ref->row;
	else
		*row = cell_ref->row;
}