cell.c 3.45 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
4
#include "gnumeric.h"
#include "eval.h"
Arturo Espinosa's avatar
Arturo Espinosa committed
5

6
7
8
9
10
11
12
13
14
15
void
cell_formula_changed (Cell *cell)
{
	g_return_if_fail (cell != NULL);
	
	sheet_cell_formula_link (cell);
	cell_add_dependencies (cell);
	cell_queue_recalc (cell);
}

Arturo Espinosa's avatar
Arturo Espinosa committed
16
17
18
19
void
cell_set_formula (Cell *cell, char *text)
{
	char *error_msg = NULL;
Arturo Espinosa's avatar
Arturo Espinosa committed
20

Arturo Espinosa's avatar
Arturo Espinosa committed
21
22
	g_return_if_fail (cell != NULL);
	g_return_if_fail (text != NULL);
23

Arturo Espinosa's avatar
Arturo Espinosa committed
24
25
26
27
28
29
30
31
32
33
	cell->parsed_node = expr_parse_string (&text [1],
					       cell->col->pos,
					       cell->row->pos,
					       &error_msg);
	if (cell->parsed_node == NULL){
		if (cell->text)
			string_unref_ptr (&cell->text);
		cell->text = string_get (error_msg);
		return;
	}
34
	cell_formula_changed (cell);
Arturo Espinosa's avatar
Arturo Espinosa committed
35
}
Arturo Espinosa's avatar
Arturo Espinosa committed
36

Arturo Espinosa's avatar
Arturo Espinosa committed
37
void
38
cell_calc_dimensions (Cell *cell)
Arturo Espinosa's avatar
Arturo Espinosa committed
39
40
{
	char    *rendered_text;
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
	GdkFont *font;

	g_return_if_fail (cell != NULL);
	
	rendered_text = CELL_TEXT_GET (cell);
	
	font = cell->style->font->font;
	
	cell->width = cell->col->margin_a + cell->col->margin_b + 
		gdk_text_width (font, rendered_text, strlen (rendered_text));
	cell->height = font->ascent + font->descent;
}

void
cell_set_text (Cell *cell, char *text)
{
Arturo Espinosa's avatar
Arturo Espinosa committed
57
58
59
60
	GList   *deps;
	
	g_return_if_fail (cell != NULL);
	g_return_if_fail (text != NULL);
Arturo Espinosa's avatar
Arturo Espinosa committed
61

Arturo Espinosa's avatar
Arturo Espinosa committed
62
63
	/* The value entered */
	if (cell->entered_text)
64
65
		string_unref (cell->entered_text);

Arturo Espinosa's avatar
Arturo Espinosa committed
66
67
68
69
	cell->entered_text = string_get (text);
	
	if (cell->parsed_node){
		cell_drop_dependencies (cell);
70
		sheet_cell_formula_unlink (cell);
71

Arturo Espinosa's avatar
Arturo Espinosa committed
72
		expr_tree_unref (cell->parsed_node);
73
		cell->parsed_node = NULL;
Arturo Espinosa's avatar
Arturo Espinosa committed
74
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
75
76
77
78
79
80
81
82
83
	
	if (text [0] == '='){
		cell_set_formula (cell, text); 
	} else {
		Value *v = g_new (Value, 1);
		int is_text = 0, is_float = 0;
		char *p;
		
		if (cell->text)
84
			string_unref (cell->text);
Arturo Espinosa's avatar
Arturo Espinosa committed
85

Arturo Espinosa's avatar
Arturo Espinosa committed
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
		cell->text = string_get (text);

		for (p = text; *p && !is_text; p++){
			switch (*p){
			case '0': case '1': case '2': case '3': case '4':
			case '5': case '6': case '7': case '8': case '9':
				break;
				
			case 'E': case 'e': case '+': case ':': case '.':
				is_float = 1;
				break;
			default:
				is_text = 1;
			}
		}
		if (is_text){
			v->type = VALUE_STRING;
			v->v.str = string_get (text);
		} else {
			if (is_float){
				v->type = VALUE_FLOAT;
				float_get_from_range (text, text+strlen(text),
						      &v->v.v_float);
			} else {
				v->type = VALUE_INTEGER;
				int_get_from_range (text, text+strlen (text),
						    &v->v.v_int);
			}
			/* FIXME: */
			/* In this case we need to format the text */
		}
		cell->value = v;
118
		cell_calc_dimensions (cell);
Arturo Espinosa's avatar
Arturo Espinosa committed
119
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
120

Arturo Espinosa's avatar
Arturo Espinosa committed
121
122
123
124
125
126
	/* Queue all of the dependencies for this cell */
	deps = cell_get_dependencies (cell->sheet,
				      cell->col->pos,
				      cell->row->pos);
	if (deps)
		cell_queue_recalc_list (deps);
Arturo Espinosa's avatar
Arturo Espinosa committed
127

Arturo Espinosa's avatar
Arturo Espinosa committed
128
129
130
	
	/* Finish setting the values for this cell */
	cell->flags = 0;
Arturo Espinosa's avatar
Arturo Espinosa committed
131
}
Arturo Espinosa's avatar
Arturo Espinosa committed
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149

/*
 * Makes a copy of a Cell
 */
Cell *
cell_copy (Cell *cell)
{
	Cell *new_cell;

	g_return_val_if_fail (cell != NULL, NULL);

	new_cell = g_new (Cell, 1);

	/* bitmap copy first */
	*new_cell = *cell;

	/* now copy propertly the rest */
	string_ref      (new_cell->entered_text);
150
151
	if (new_cell->parsed_node)
		expr_tree_ref   (new_cell->parsed_node);
Arturo Espinosa's avatar
Arturo Espinosa committed
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
	string_ref      (new_cell->text);
	
	new_cell->style = style_duplicate (new_cell->style);
	new_cell->value = value_duplicate (new_cell->value);

	return new_cell;
}

void
cell_destroy (Cell *cell)
{
	g_return_if_fail (cell != NULL);

	if (cell->parsed_node){
		expr_tree_unref (cell->parsed_node);
	}

	string_unref    (cell->entered_text);
	string_unref    (cell->text);
	style_destroy   (cell->style);
	value_release   (cell->value);
}