sheet-control-gui.c 25.6 KB
Newer Older
Arturo Espinosa's avatar
Arturo Espinosa committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
/*
 * sheet-view.c: Implements a view of the Sheet.
 *
 * Author:
 *    Miguel de Icaza (miguel@kernel.org)
 *
 */
#include <config.h>

#include <gnome.h>
#include <gdk/gdkkeysyms.h>
#include <gdk/gdkx.h>
#include <string.h>
#include "gnumeric.h"
#include "gnumeric-sheet.h"
16
#include "workbook.h"
17
#include "cell.h"
Michael Meeks's avatar
Michael Meeks committed
18
#include "selection.h"
Michael Meeks's avatar
Michael Meeks committed
19
#include "sheet-object.h"
20
#include "item-cursor.h"
21
#include "gnumeric-util.h"
22
#include "utils.h"
23
#include "selection.h"
24
#include "application.h"
Arturo Espinosa's avatar
Arturo Espinosa committed
25
26
27
28
29
30
31
32

static GtkTableClass *sheet_view_parent_class;

void
sheet_view_redraw_all (SheetView *sheet_view)
{
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));
33

Arturo Espinosa's avatar
Arturo Espinosa committed
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
	gnome_canvas_request_redraw (
		GNOME_CANVAS (sheet_view->sheet_view),
		0, 0, INT_MAX, INT_MAX);
	gnome_canvas_request_redraw (
		GNOME_CANVAS (sheet_view->col_canvas),
		0, 0, INT_MAX, INT_MAX);
	gnome_canvas_request_redraw (
		GNOME_CANVAS (sheet_view->row_canvas),
		0, 0, INT_MAX, INT_MAX);
}

void
sheet_view_redraw_cell_region (SheetView *sheet_view, int start_col, int start_row, int end_col, int end_row)
{
	GnumericSheet *gsheet;
49
	GnomeCanvas *canvas;
Arturo Espinosa's avatar
Arturo Espinosa committed
50
	Sheet *sheet = sheet_view->sheet;
Arturo Espinosa's avatar
Arturo Espinosa committed
51
	int first_col, first_row, last_col, last_row;
52
	int col, row, min_col, max_col;
Arturo Espinosa's avatar
Arturo Espinosa committed
53
	int x, y, w, h;
54

Arturo Espinosa's avatar
Arturo Espinosa committed
55
56
57
58
59
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));

	gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
	g_return_if_fail (GNUMERIC_IS_SHEET (gsheet));
60
	canvas = GNOME_CANVAS (gsheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
61

62
63
64
65
	if ((end_col < gsheet->col.first) ||
	    (end_row < gsheet->row.first) ||
	    (start_col > gsheet->col.last_visible) ||
	    (start_row > gsheet->row.last_visible))
66
		return;
67

68
	/* The region on which we care to redraw */
69
70
71
72
	first_col = MAX (gsheet->col.first, start_col);
	first_row = MAX (gsheet->row.first, start_row);
	last_col =  MIN (gsheet->col.last_visible, end_col);
	last_row =  MIN (gsheet->row.last_visible, end_row);
73
74

	/* Initial values for min/max column computation */
Arturo Espinosa's avatar
Arturo Espinosa committed
75
76
	min_col = first_col;
	max_col = last_col;
77
78

	/* Find the range of columns that require a redraw */
Arturo Espinosa's avatar
Arturo Espinosa committed
79
80
	for (col = first_col; col <= last_col; col++)
		for (row = first_row; row <= last_row; row++){
81
82
83
84
85
86
			Cell *cell;
			int  col1, col2;

			cell = sheet_cell_get (sheet, col, row);

			if (cell){
87
				cell_calculate_span (cell, &col1, &col2);
88
89
90
91

				min_col = MIN (col1, min_col);
				max_col = MAX (col2, max_col);
			}
92

93
		}
Arturo Espinosa's avatar
Arturo Espinosa committed
94

95
	/* Only draw those regions that are visible */
96
97
	min_col = MAX (MIN (first_col, min_col), gsheet->col.first);
	max_col = MIN (MAX (last_col, max_col), gsheet->col.last_visible);
Arturo Espinosa's avatar
Arturo Espinosa committed
98

99
100
	x = sheet_col_get_distance_pixels (sheet, gsheet->col.first, min_col);
	y = sheet_row_get_distance_pixels (sheet, gsheet->row.first, first_row);
Jody Goldberg's avatar
Jody Goldberg committed
101
102
	w = sheet_col_get_distance_pixels (sheet, min_col, max_col+1);
	h = sheet_row_get_distance_pixels (sheet, first_row, last_row+1);
Arturo Espinosa's avatar
Arturo Espinosa committed
103

104
105
	x += canvas->layout.xoffset - canvas->zoom_xofs;
	y += canvas->layout.yoffset - canvas->zoom_yofs;
Jody Goldberg's avatar
Jody Goldberg committed
106
107
108
109
110
111
112
113

#if 0
	fprintf (stderr, "%s%d:", col_name(min_col), first_row+1);
	fprintf (stderr, "%s%d\n", col_name(max_col), last_row+1);
#endif

	/* redraw a border of 1 pixel around the region to handle thick borders
	 * NOTE the 2nd coordinates are excluded so add 1 extra (+1border +1include) */
114
	gnome_canvas_request_redraw (GNOME_CANVAS (gsheet),
Jody Goldberg's avatar
Jody Goldberg committed
115
116
				     x-1, y-1,
				     x+w+1+1, y+h+1+1);
Arturo Espinosa's avatar
Arturo Espinosa committed
117
118
119
}

void
Jody Goldberg's avatar
Jody Goldberg committed
120
121
122
sheet_view_redraw_headers (SheetView *sheet_view,
			   gboolean const col, gboolean const row,
			   Range const * r /* optional == NULL */)
Arturo Espinosa's avatar
Arturo Espinosa committed
123
{
Jody Goldberg's avatar
Jody Goldberg committed
124
	GnumericSheet *gsheet;
Arturo Espinosa's avatar
Arturo Espinosa committed
125
126
127
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));

Jody Goldberg's avatar
Jody Goldberg committed
128
	gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
Arturo Espinosa's avatar
Arturo Espinosa committed
129

Jody Goldberg's avatar
Jody Goldberg committed
130
	if (col) {
131
		int left = 0, right = INT_MAX-1;
Jody Goldberg's avatar
Jody Goldberg committed
132
133
134
135
136
137
138
		if (r != NULL) {
			int const size = r->end.col - r->start.col;
/* A rough heuristic guess of the number of when the
 * trade off point of redrawing all vs calculating the
 * redraw size is crossed */
#define COL_HEURISTIC	20
			if (-COL_HEURISTIC < size && size < COL_HEURISTIC) {
139
				left = gsheet->col_offset.first +
140
				    sheet_col_get_distance_pixels (sheet_view->sheet,
141
							    gsheet->col.first, r->start.col);
Jody Goldberg's avatar
Jody Goldberg committed
142
				right = left +
143
				    sheet_col_get_distance_pixels (sheet_view->sheet,
Jody Goldberg's avatar
Jody Goldberg committed
144
145
146
							    r->start.col, r->end.col+1);
			}
		}
147
		/* Request excludes the far coordinate.  Add 1 to include them */
Jody Goldberg's avatar
Jody Goldberg committed
148
149
		gnome_canvas_request_redraw (
			GNOME_CANVAS (sheet_view->col_canvas),
150
			left, 0, right+1, INT_MAX);
Jody Goldberg's avatar
Jody Goldberg committed
151
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
152

Jody Goldberg's avatar
Jody Goldberg committed
153
	if (row) {
154
		int top = 0, bottom = INT_MAX-1;
Jody Goldberg's avatar
Jody Goldberg committed
155
156
157
158
159
160
161
		if (r != NULL) {
			int const size = r->end.row - r->start.row;
/* A rough heuristic guess of the number of when the
 * trade off point of redrawing all vs calculating the
 * redraw size is crossed */
#define ROW_HEURISTIC	50
			if (-ROW_HEURISTIC < size && size < ROW_HEURISTIC) {
162
				top = gsheet->row_offset.first +
163
				    sheet_row_get_distance_pixels (sheet_view->sheet,
164
							    gsheet->row.first, r->start.row);
Jody Goldberg's avatar
Jody Goldberg committed
165
				bottom = top +
166
				    sheet_row_get_distance_pixels (sheet_view->sheet,
Jody Goldberg's avatar
Jody Goldberg committed
167
168
169
							    r->start.row, r->end.row+1);
			}
		}
170
		/* Request excludes the far coordinate.  Add 1 to include them */
Jody Goldberg's avatar
Jody Goldberg committed
171
172
		gnome_canvas_request_redraw (
			GNOME_CANVAS (sheet_view->row_canvas),
173
			0, top, INT_MAX, bottom+1);
Jody Goldberg's avatar
Jody Goldberg committed
174
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
175
176
177
178
179
}

void
sheet_view_set_zoom_factor (SheetView *sheet_view, double factor)
{
180
181
	GList *l;
	GnumericSheet *gsheet;
182
183
	ItemBar *col_item, *row_item;
	int h, w;
184

Arturo Espinosa's avatar
Arturo Espinosa committed
185
186
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));
187

188
	gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
189
190
	col_item = ITEM_BAR (sheet_view->col_item);
	row_item = ITEM_BAR (sheet_view->row_item);
191

192
	/* Set pixels_per_unit before the font.  The item bars look here for the number */
193
	gnome_canvas_set_pixels_per_unit (GNOME_CANVAS (gsheet), factor);
194

195
	/* resize the header fonts */
196
197
198
199
200
201
202
	item_bar_fonts_init (col_item);
	item_bar_fonts_init (row_item);

	/*
	 * Use the size of the bold header font to size the free dimensions
	 * No need to zoom, the size of the font takes that into consideration.
	 */
203

204
205
206
207
208
209
	/* 2 pixels above and below */
	h = 2 + 2 + style_font_get_height (col_item->bold_font);
	/* 5 pixels left and right plus the width of the widest string I can think of */
	w = 5 + 5 + gdk_string_width (style_font_gdk_font (col_item->bold_font), "88888");

	gtk_widget_set_usize (GTK_WIDGET (sheet_view->col_canvas), -1, h);
210
	gnome_canvas_set_scroll_region (GNOME_CANVAS (sheet_view->col_canvas), 0, 0,
211
					1000000*factor, h);
212

213
	gtk_widget_set_usize (GTK_WIDGET (sheet_view->row_canvas), w, -1);
214
	gnome_canvas_set_scroll_region (GNOME_CANVAS (sheet_view->row_canvas), 0, 0,
215
					w, 1200000*factor);
216

217
218
	/* Recalibrate the starting offsets */
	gsheet->col_offset.first =
219
	    sheet_col_get_distance_pixels (sheet_view->sheet, 0, gsheet->col.first);
220
	gsheet->row_offset.first =
221
	    sheet_row_get_distance_pixels (sheet_view->sheet, 0, gsheet->row.first);
222
223
224

	/* Ensure that the current cell remains visible when we zoom */
	gnumeric_sheet_make_cell_visible (gsheet,
225
226
227
					  sheet_view->sheet->cursor.edit_pos.col,
					  sheet_view->sheet->cursor.edit_pos.row,
					  TRUE);
228
229
230
231
232
233
234

	/* Repsition the cursor */
	item_cursor_reposition (gsheet->item_cursor);

	/* Adjust the animated cursors */
	for (l = sheet_view->anted_cursors; l; l = l->next)
		item_cursor_reposition (ITEM_CURSOR (l->data));
Arturo Espinosa's avatar
Arturo Espinosa committed
235
236
237
238
239
240
241
242
243
244
245
}

static void
canvas_bar_realized (GtkWidget *widget, gpointer data)
{
	gdk_window_set_back_pixmap (GTK_LAYOUT (widget)->bin_window, NULL, FALSE);
}

static GnomeCanvas *
new_canvas_bar (SheetView *sheet_view, GtkOrientation o, GnomeCanvasItem **itemp)
{
246
247
248
249
250
251
252
253
254
255
	GtkWidget *canvas =
	    gnome_canvas_new ();
	GnomeCanvasGroup *group =
	    GNOME_CANVAS_GROUP (GNOME_CANVAS (canvas)->root);
	GnomeCanvasItem *item =
	    gnome_canvas_item_new (group,
				   item_bar_get_type (),
				   "ItemBar::SheetView", sheet_view,
				   "ItemBar::Orientation", o,
				   NULL);
Arturo Espinosa's avatar
Arturo Espinosa committed
256
257
258
259
260

	gtk_signal_connect (GTK_OBJECT (canvas), "realize",
			    (GtkSignalFunc) canvas_bar_realized,
			    NULL);

261
	*itemp = item;
Arturo Espinosa's avatar
Arturo Espinosa committed
262
	gtk_widget_show (canvas);
263

264
	return GNOME_CANVAS(canvas);
Arturo Espinosa's avatar
Arturo Espinosa committed
265
266
}

Jody Goldberg's avatar
Jody Goldberg committed
267
268
269
/* Manages the scrollbar dimensions and paging parameters. */
void
sheet_view_scrollbar_config (SheetView const *sheet_view)
Arturo Espinosa's avatar
Arturo Espinosa committed
270
271
272
273
{
	GtkAdjustment *va = GTK_ADJUSTMENT (sheet_view->va);
	GtkAdjustment *ha = GTK_ADJUSTMENT (sheet_view->ha);
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
Jody Goldberg's avatar
Jody Goldberg committed
274
	Sheet         *sheet = sheet_view->sheet;
275
276
	int const last_col = gsheet->col.last_full;
	int const last_row = gsheet->row.last_full;
Arturo Espinosa's avatar
Arturo Espinosa committed
277

Jody Goldberg's avatar
Jody Goldberg committed
278
	va->upper = MAX (MAX (last_row,
279
			      sheet_view->sheet->rows.max_used),
280
281
			 MAX (sheet->cursor.move_corner.row,
			      sheet->cursor.base_corner.row));
282
	va->page_size = last_row - gsheet->row.first;
283
	va->value = gsheet->row.first;
Jody Goldberg's avatar
Jody Goldberg committed
284
285
	va->step_increment = va->page_increment =
	    va->page_size / 2;
286

Jody Goldberg's avatar
Jody Goldberg committed
287
	ha->upper = MAX (MAX (last_col,
288
			      sheet_view->sheet->cols.max_used),
289
290
			 MAX (sheet->cursor.move_corner.col,
			      sheet->cursor.base_corner.col));
291
	ha->page_size = last_col - gsheet->col.first;
292
	ha->value = gsheet->col.first;
Jody Goldberg's avatar
Jody Goldberg committed
293
294
	ha->step_increment = ha->page_increment =
	    ha->page_size / 2;
Arturo Espinosa's avatar
Arturo Espinosa committed
295
296
297
298
299

	gtk_adjustment_changed (va);
	gtk_adjustment_changed (ha);
}

Jody Goldberg's avatar
Jody Goldberg committed
300
301
302
303
304
305
static void
sheet_view_size_allocate (GtkWidget *widget, GtkAllocation *alloc, SheetView *sheet_view)
{
	sheet_view_scrollbar_config (sheet_view);
}

Arturo Espinosa's avatar
Arturo Espinosa committed
306
static void
307
308
sheet_view_col_selection_changed (ItemBar *item_bar, int col, int modifiers, SheetView *sheet_view)
{
Arturo Espinosa's avatar
Arturo Espinosa committed
309
	Sheet *sheet = sheet_view->sheet;
310
311
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);

312
	/* Ensure that the col exists, ignore result */
313
314
	sheet_col_fetch (sheet, col);

315
316
317
318
	if (modifiers){
		if ((modifiers & GDK_SHIFT_MASK) && sheet->selections){
			SheetSelection *ss = sheet->selections->data;
			int start_col, end_col;
319
320
321
322

			start_col = MIN (ss->user.start.col, col);
			end_col = MAX (ss->user.end.col, col);

323
			sheet_selection_set (sheet,
324
					     start_col, gsheet->row.first,
325
326
327
328
					     start_col, 0,
					     end_col, SHEET_MAX_ROWS-1);
			return;
		}
329

330
331
		if (!(modifiers & GDK_CONTROL_MASK))
			sheet_selection_reset_only (sheet);
332

333
334
335
336
		sheet_selection_add_range (sheet,
					   col, gsheet->row.first,
					   col, 0,
					   col, SHEET_MAX_ROWS-1);
Arturo Espinosa's avatar
Arturo Espinosa committed
337
	} else
338
		sheet_selection_extend_to (sheet, col, SHEET_MAX_ROWS - 1);
Arturo Espinosa's avatar
Arturo Espinosa committed
339
340
341
342
343
344
}

static void
sheet_view_col_size_changed (ItemBar *item_bar, int col, int width, SheetView *sheet_view)
{
	Sheet *sheet = sheet_view->sheet;
345
346
347
348
	ItemBarSelectionType type;

	type = sheet_col_selection_type (sheet, col);

349
350
351
352
353
354
 	if (type == ITEM_BAR_FULL_SELECTION) {
		int i = sheet->cols.max_used;
		for (;i >= 0 ; --i) {
 			ColRowInfo *ci = sheet_col_get (sheet, i);
			if (ci == NULL)
				continue;
355

356
 			if (sheet_col_selection_type (sheet, ci->pos) == ITEM_BAR_FULL_SELECTION)
357
 				sheet_col_set_size_pixels (sheet, ci->pos, width, TRUE);
358
 		}
359
	} else
360
 		sheet_col_set_size_pixels (sheet, col, width, TRUE);
361

Arturo Espinosa's avatar
Arturo Espinosa committed
362
363
364
365
	gnumeric_sheet_compute_visible_ranges (GNUMERIC_SHEET (sheet_view->sheet_view));
}

static void
366
sheet_view_row_selection_changed (ItemBar *item_bar, int row, int modifiers, SheetView *sheet_view)
Arturo Espinosa's avatar
Arturo Espinosa committed
367
368
{
	Sheet *sheet = sheet_view->sheet;
369
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
370

371
372
	/* Ensure that the row exists, ignore result */
	sheet_row_fetch (sheet, row);
373

374
375
376
377
	if (modifiers){
		if ((modifiers & GDK_SHIFT_MASK) && sheet->selections){
			SheetSelection *ss = sheet->selections->data;
			int start_row, end_row;
378
379
380
381

			start_row = MIN (ss->user.start.row, row);
			end_row = MAX (ss->user.end.row, row);

382
			sheet_selection_set (sheet,
383
					     gsheet->col.first, start_row,
384
385
386
387
					     0, start_row,
					     SHEET_MAX_COLS-1, end_row);
			return;
		}
388

389
390
		if (!(modifiers & GDK_CONTROL_MASK))
 			sheet_selection_reset_only (sheet);
391
392
393
394
395

		sheet_selection_add_range (sheet,
					   gsheet->col.first, row,
					   0, row,
					   SHEET_MAX_COLS-1, row);
Arturo Espinosa's avatar
Arturo Espinosa committed
396
	} else
397
		sheet_selection_extend_to (sheet, SHEET_MAX_COLS-1, row);
Arturo Espinosa's avatar
Arturo Espinosa committed
398
399
400
401
402
403
}

static void
sheet_view_row_size_changed (ItemBar *item_bar, int row, int height, SheetView *sheet_view)
{
	Sheet *sheet = sheet_view->sheet;
404
405
406
407
	ItemBarSelectionType type;

	type = sheet_row_selection_type (sheet, row);

408
409
410
411
412
413
	if (type == ITEM_BAR_FULL_SELECTION) {
		int i;
		for (i = sheet->rows.max_used; i >= 0 ; --i) {
 			ColRowInfo *ri = sheet_row_get (sheet, i);
			if (ri == NULL)
				continue;
414

415
			if (sheet_row_selection_type (sheet, ri->pos) == ITEM_BAR_FULL_SELECTION)
416
					sheet_row_set_size_pixels (sheet, ri->pos, height, TRUE);
417
		}
418
	} else
419
		sheet_row_set_size_pixels (sheet, row, height, TRUE);
Arturo Espinosa's avatar
Arturo Espinosa committed
420
421
422
423
424
425
}

static void
button_select_all (GtkWidget *the_button, SheetView *sheet_view)
{
	sheet_select_all (sheet_view->sheet);
426
	sheet_redraw_all (sheet_view->sheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
427
428
429
430
431
}

static void
vertical_scroll_change (GtkAdjustment *adj, SheetView *sheet_view)
{
432
433
434
435
436
	if (sheet_view->tip) {
		char buffer [20 + sizeof (long) * 4];
		snprintf (buffer, sizeof (buffer), _("Row: %d"), (int) adj->value + 1);
		gtk_label_set_text (GTK_LABEL (sheet_view->tip), buffer);
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
437
438
439
440
441
}

static void
horizontal_scroll_change (GtkAdjustment *adj, SheetView *sheet_view)
{
442
443
444
445
	if (sheet_view->tip) {
		char buffer [20 + sizeof (long) * 4];
		snprintf (buffer, sizeof (buffer), _("Column: %s"), col_name (adj->value));
		gtk_label_set_text (GTK_LABEL (sheet_view->tip), buffer);
Arturo Espinosa's avatar
Arturo Espinosa committed
446
447
448
449
450
451
452
	}
}

static int
horizontal_scroll_event (GtkScrollbar *scroll, GdkEvent *event, SheetView *sheet_view)
{
	if (event->type == GDK_BUTTON_PRESS){
453
454
455
		sheet_view->tip = gnumeric_create_tooltip ();
		horizontal_scroll_change (GTK_ADJUSTMENT (sheet_view->ha), sheet_view);
		gnumeric_position_tooltip (sheet_view->tip, 1);
Arturo Espinosa's avatar
Arturo Espinosa committed
456
		gtk_widget_show_all (gtk_widget_get_toplevel (sheet_view->tip));
457
458
459
460
	}
	else if (event->type == GDK_BUTTON_RELEASE)
	{
		GnumericSheet  *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
461
		int col;
462

463
464
465
466
467
468
		/* A button release can be generated without a press by people
		 * with mouse wheels */
		if (sheet_view->tip) {
			gtk_widget_destroy (gtk_widget_get_toplevel (sheet_view->tip));
			sheet_view->tip = NULL;
		}
Arturo Espinosa's avatar
Arturo Espinosa committed
469

470
471
		col = GTK_ADJUSTMENT (sheet_view->ha)->value;

472
		gnumeric_sheet_set_left_col (gsheet, col);
473
		/* NOTE : Excel does not move the cursor, just scrolls the sheet. */
Arturo Espinosa's avatar
Arturo Espinosa committed
474
	}
475

Arturo Espinosa's avatar
Arturo Espinosa committed
476
477
478
479
480
481
482
	return FALSE;
}

static int
vertical_scroll_event (GtkScrollbar *scroll, GdkEvent *event, SheetView *sheet_view)
{
	if (event->type == GDK_BUTTON_PRESS){
483
484
485
		sheet_view->tip = gnumeric_create_tooltip ();
		vertical_scroll_change (GTK_ADJUSTMENT (sheet_view->va), sheet_view);
		gnumeric_position_tooltip (sheet_view->tip, 0);
Arturo Espinosa's avatar
Arturo Espinosa committed
486
		gtk_widget_show_all (gtk_widget_get_toplevel (sheet_view->tip));
487
488
489
490
	}
	else if (event->type == GDK_BUTTON_RELEASE)
	{
		GnumericSheet  *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
491
		int row;
492

493
494
495
496
497
498
		/* A button release can be generated without a press by people
		 * with mouse wheels */
		if (sheet_view->tip) {
			gtk_widget_destroy (gtk_widget_get_toplevel (sheet_view->tip));
			sheet_view->tip = NULL;
		}
Arturo Espinosa's avatar
Arturo Espinosa committed
499

500
		row = GTK_ADJUSTMENT (sheet_view->va)->value;
501

502
		gnumeric_sheet_set_top_row (gsheet, row);
503
		/* NOTE : Excel does not move the cursor, just scrolls the sheet. */
Arturo Espinosa's avatar
Arturo Espinosa committed
504
505
506
507
508
	}

	return FALSE;
}

509
510
511
512
static void
sheet_view_init (SheetView *sheet_view)
{
	GtkTable *table = GTK_TABLE (sheet_view);
513

514
515
516
517
	table->homogeneous = FALSE;
	gtk_table_resize (table, 4, 4);
}

Arturo Espinosa's avatar
Arturo Espinosa committed
518
519
520
static void
sheet_view_construct (SheetView *sheet_view)
{
521
	GnomeCanvasGroup *root_group;
Arturo Espinosa's avatar
Arturo Espinosa committed
522
523
	GtkTable  *table = GTK_TABLE (sheet_view);
	Sheet *sheet = sheet_view->sheet;
524

Arturo Espinosa's avatar
Arturo Espinosa committed
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
	/* Column canvas */
	sheet_view->col_canvas = new_canvas_bar (sheet_view, GTK_ORIENTATION_HORIZONTAL, &sheet_view->col_item);
	gtk_table_attach (table, GTK_WIDGET (sheet_view->col_canvas),
			  1, 2, 0, 1,
			  GTK_EXPAND | GTK_FILL | GTK_SHRINK,
			  GTK_FILL,
			  0, 0);
	gtk_signal_connect (GTK_OBJECT (sheet_view->col_item), "selection_changed",
			    GTK_SIGNAL_FUNC (sheet_view_col_selection_changed),
			    sheet_view);
	gtk_signal_connect (GTK_OBJECT (sheet_view->col_item), "size_changed",
			    GTK_SIGNAL_FUNC (sheet_view_col_size_changed),
			    sheet_view);

	/* Row canvas */
	sheet_view->row_canvas = new_canvas_bar (sheet_view, GTK_ORIENTATION_VERTICAL, &sheet_view->row_item);
541

Arturo Espinosa's avatar
Arturo Espinosa committed
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
	gtk_table_attach (table, GTK_WIDGET (sheet_view->row_canvas),
			  0, 1, 1, 2,
			  GTK_FILL, GTK_EXPAND | GTK_FILL | GTK_SHRINK,
			  0, 0);
	gtk_signal_connect (GTK_OBJECT (sheet_view->row_item), "selection_changed",
			    GTK_SIGNAL_FUNC (sheet_view_row_selection_changed),
			    sheet_view);
	gtk_signal_connect (GTK_OBJECT (sheet_view->row_item), "size_changed",
			    GTK_SIGNAL_FUNC (sheet_view_row_size_changed),
			    sheet_view);


	/* Create the gnumeric sheet canvas */
	sheet_view->sheet_view = gnumeric_sheet_new (
		sheet_view,
		ITEM_BAR (sheet_view->col_item),
		ITEM_BAR (sheet_view->row_item));
Michael Meeks's avatar
Michael Meeks committed
559

Arturo Espinosa's avatar
Arturo Espinosa committed
560
561
562
563
	gtk_signal_connect_after (
		GTK_OBJECT (sheet_view), "size_allocate",
		GTK_SIGNAL_FUNC (sheet_view_size_allocate), sheet_view);

564
565
566
	/* Create the object group inside the GnumericSheet */
	root_group = GNOME_CANVAS_GROUP (
		GNOME_CANVAS (sheet_view->sheet_view)->root);
567
568
569
570
571
572
573
	sheet_view->object_group = GNOME_CANVAS_GROUP (
		gnome_canvas_item_new (
			root_group,
			gnome_canvas_group_get_type (),
			"x", 0.0,
			"y", 0.0,
			NULL));
574

Arturo Espinosa's avatar
Arturo Espinosa committed
575
576
577
578
579
580
581
582
	/* Attach the GnumericSheet */
	gtk_table_attach (table, sheet_view->sheet_view,
			  1, 2, 1, 2,
			  GTK_EXPAND | GTK_FILL | GTK_SHRINK,
			  GTK_EXPAND | GTK_FILL | GTK_SHRINK,
			  0, 0);
	gtk_widget_show (sheet_view->sheet_view);

583
584
585
586
587
588
589
590
591
592
	/*
	 * The selection group
	 */
	sheet_view->selection_group = GNOME_CANVAS_GROUP (
		gnome_canvas_item_new (
			root_group,
			gnome_canvas_group_get_type (),
			"x", 0.0,
			"y", 0.0,
			NULL));
593

Arturo Espinosa's avatar
Arturo Espinosa committed
594
	/* The select-all button */
595
596
597
598
	sheet_view->select_all_btn = gtk_button_new ();
	GTK_WIDGET_UNSET_FLAGS (sheet_view->select_all_btn, GTK_CAN_FOCUS);
	gtk_table_attach (table, sheet_view->select_all_btn, 0, 1, 0, 1, GTK_FILL, GTK_FILL, 0, 0);
	gtk_signal_connect (GTK_OBJECT (sheet_view->select_all_btn), "clicked",
Arturo Espinosa's avatar
Arturo Espinosa committed
599
			    GTK_SIGNAL_FUNC (button_select_all), sheet_view);
600

Arturo Espinosa's avatar
Arturo Espinosa committed
601
	/* Scroll bars and their adjustments */
602
603
	sheet_view->va = gtk_adjustment_new (0.0, 0.0, sheet->rows.max_used, 1.0, 1.0, 1.0);
	sheet_view->ha = gtk_adjustment_new (0.0, 0.0, sheet->cols.max_used, 1.0, 1.0, 1.0);
Arturo Espinosa's avatar
Arturo Espinosa committed
604
605
606
607
608
609
610
611
612
613
614
	sheet_view->hs = gtk_hscrollbar_new (GTK_ADJUSTMENT (sheet_view->ha));
	sheet_view->vs = gtk_vscrollbar_new (GTK_ADJUSTMENT (sheet_view->va));

	gtk_signal_connect (GTK_OBJECT (sheet_view->ha), "value_changed",
			    GTK_SIGNAL_FUNC (horizontal_scroll_change), sheet_view);
	gtk_signal_connect (GTK_OBJECT (sheet_view->va), "value_changed",
			    GTK_SIGNAL_FUNC (vertical_scroll_change), sheet_view);
	gtk_signal_connect (GTK_OBJECT (sheet_view->hs), "event",
			    GTK_SIGNAL_FUNC (horizontal_scroll_event), sheet_view);
	gtk_signal_connect (GTK_OBJECT (sheet_view->vs), "event",
			    GTK_SIGNAL_FUNC (vertical_scroll_event), sheet_view);
615

Arturo Espinosa's avatar
Arturo Espinosa committed
616
617
618
619
620
621
622
623
624
625
626
627
628
	/* Attach the horizontal scroll */
	gtk_table_attach (table, sheet_view->hs,
			  1, 2, 2, 3,
			  GTK_EXPAND | GTK_FILL | GTK_SHRINK,
			  GTK_FILL,
			  0, 0);

	/* Attach the vertical scroll */
	gtk_table_attach (table, sheet_view->vs,
			  2, 3, 1, 2,
			  GTK_FILL,
			  GTK_EXPAND | GTK_FILL | GTK_SHRINK,
			  0, 0);
629
	sheet_view_set_zoom_factor (sheet_view, 1.);
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
}

void
sheet_view_set_header_visibility (SheetView *sheet_view,
				  gboolean col_headers_visible,
				  gboolean row_headers_visible)
{
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));

	if (col_headers_visible){
		if (!GTK_WIDGET_VISIBLE (GTK_WIDGET (sheet_view->col_canvas)))
			gtk_widget_show (GTK_WIDGET (sheet_view->col_canvas));
	} else {
		if (GTK_WIDGET_VISIBLE (GTK_WIDGET (sheet_view->col_canvas)))
			gtk_widget_hide (GTK_WIDGET (sheet_view->col_canvas));
	}
647

648
649
650
651
652
653
654
	if (row_headers_visible){
		if (!GTK_WIDGET_VISIBLE (GTK_WIDGET (sheet_view->row_canvas)))
			gtk_widget_show (GTK_WIDGET (sheet_view->row_canvas));
	} else {
		if (GTK_WIDGET_VISIBLE (GTK_WIDGET (sheet_view->row_canvas)))
			gtk_widget_hide (GTK_WIDGET (sheet_view->row_canvas));
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
655
656
657
658
659
660
661
662
663
}

GtkWidget *
sheet_view_new (Sheet *sheet)
{
	SheetView *sheet_view;

	sheet_view = gtk_type_new (sheet_view_get_type ());
	sheet_view->sheet = sheet;
664
	sheet_view->tip = NULL;
665

Arturo Espinosa's avatar
Arturo Espinosa committed
666
	sheet_view_construct (sheet_view);
667

Arturo Espinosa's avatar
Arturo Espinosa committed
668
669
670
671
672
673
674
675
676
677
	return GTK_WIDGET (sheet_view);
}

static void
sheet_view_destroy (GtkObject *object)
{
	SheetView *sheet_view = SHEET_VIEW (object);

	/* Add shutdown code here */
	if (sheet_view->tip)
678
		gtk_object_unref (GTK_OBJECT (sheet_view->tip));
679

Arturo Espinosa's avatar
Arturo Espinosa committed
680
681
682
683
684
	if (GTK_OBJECT_CLASS (sheet_view_parent_class)->destroy)
		(*GTK_OBJECT_CLASS (sheet_view_parent_class)->destroy)(object);
}

static void
Jody Goldberg's avatar
Jody Goldberg committed
685
sheet_view_class_init (SheetViewClass *Class)
Arturo Espinosa's avatar
Arturo Espinosa committed
686
687
688
{
	GtkObjectClass *object_class;

Jody Goldberg's avatar
Jody Goldberg committed
689
	object_class = (GtkObjectClass *) Class;
Arturo Espinosa's avatar
Arturo Espinosa committed
690
691

	sheet_view_parent_class = gtk_type_class (gtk_table_get_type ());
692

Arturo Espinosa's avatar
Arturo Espinosa committed
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
	object_class->destroy = sheet_view_destroy;
}

GtkType
sheet_view_get_type (void)
{
	static GtkType sheet_view_type = 0;

	if (!sheet_view_type){
		GtkTypeInfo sheet_view_info = {
			"SheetView",
			sizeof (SheetView),
			sizeof (SheetViewClass),
			(GtkClassInitFunc) sheet_view_class_init,
			(GtkObjectInitFunc) sheet_view_init,
			NULL, /* reserved 1 */
			NULL, /* reserved 2 */
			(GtkClassInitFunc) NULL
		};

		sheet_view_type = gtk_type_unique (gtk_table_get_type (), &sheet_view_info);
	}

	return sheet_view_type;
}
718

Miguel de Icaza's avatar
New:    
Miguel de Icaza committed
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
void
sheet_view_hide_cursor (SheetView *sheet_view)
{
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);

	item_cursor_set_visibility (gsheet->item_cursor, FALSE);
}

void
sheet_view_show_cursor (SheetView *sheet_view)
{
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);

	item_cursor_set_visibility (gsheet->item_cursor, TRUE);
}
734
735
736

#define TRIANGLE_WIDTH 6

737
738
static GnomeCanvasPoints *
sheet_view_comment_get_points (SheetView *sheet_view, int col, int row)
739
740
{
	GnomeCanvasPoints *points;
741
	int x, y, i;
742
743
744

	points = gnome_canvas_points_new (3);

745
746
	x = sheet_col_get_distance_pixels (sheet_view->sheet, 0, col+1);
	y = 1+sheet_row_get_distance_pixels (sheet_view->sheet, 0, row);
747
748
749
750
751
752
753
754

	points->coords [0] = x - TRIANGLE_WIDTH;
	points->coords [1] = y;
	points->coords [2] = x;
	points->coords [3] = y;
	points->coords [4] = x;
	points->coords [5] = y + TRIANGLE_WIDTH;

755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
	for (i = 0; i < 3; i++){
		gnome_canvas_c2w (GNOME_CANVAS (sheet_view->sheet_view),
				  points->coords [i*2],
				  points->coords [i*2+1],
				  &(points->coords [i*2]),
				  &(points->coords [i*2+1]));
	}
	return points;
}

GnomeCanvasItem *
sheet_view_comment_create_marker (SheetView *sheet_view, int col, int row)
{
	GnomeCanvasPoints *points;
	GnomeCanvasGroup *group;
	GnomeCanvasItem *i;
771

772
773
774
775
776
777
	g_return_val_if_fail (sheet_view != NULL, NULL);
	g_return_val_if_fail (IS_SHEET_VIEW (sheet_view), NULL);

	group = GNOME_CANVAS_GROUP (GNOME_CANVAS (sheet_view->sheet_view)->root);
	points = sheet_view_comment_get_points (sheet_view, col, row);

778
779
780
781
782
783
784
785
	i = gnome_canvas_item_new (
		group, gnome_canvas_polygon_get_type (),
		"points",     points,
		"fill_color", "red",
		NULL);

	return i;
}
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801

void
sheet_view_comment_relocate (SheetView *sheet_view, int col, int row, GnomeCanvasItem *o)
{
	GnomeCanvasPoints *points;

	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));
	g_return_if_fail (o != NULL);
	g_return_if_fail (GNOME_IS_CANVAS_ITEM (o));

	points = sheet_view_comment_get_points (sheet_view, col, row);

	gnome_canvas_item_set (o, "points", points, NULL);
}

802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
void
sheet_view_selection_unant (SheetView *sheet_view)
{
	GList *l;

	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));

	if (sheet_view->anted_cursors == NULL)
		return;

	for (l = sheet_view->anted_cursors; l; l = l->next)
		gtk_object_destroy (GTK_OBJECT (l->data));

	g_list_free (sheet_view->anted_cursors);
	sheet_view->anted_cursors = NULL;
}

void
sheet_view_selection_ant (SheetView *sheet_view)
{
	GnomeCanvasGroup *group;
	ItemGrid *grid;
	GList *l;
826

827
828
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));
829

830
831
832
833
834
	if (sheet_view->anted_cursors)
		sheet_view_selection_unant (sheet_view);

	group = sheet_view->selection_group;
	grid = GNUMERIC_SHEET (sheet_view->sheet_view)->item_grid;
835

836
837
838
	for (l = sheet_view->sheet->selections; l; l = l->next){
		SheetSelection *ss = l->data;
		ItemCursor *item_cursor;
839

840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
		item_cursor = ITEM_CURSOR (gnome_canvas_item_new (
			group, item_cursor_get_type (),
			"Sheet", sheet_view->sheet,
			"Grid",  grid,
			"Style", ITEM_CURSOR_ANTED,
			NULL));
		item_cursor_set_bounds (
			item_cursor,
			ss->user.start.col, ss->user.start.row,
			ss->user.end.col, ss->user.end.row);

		sheet_view->anted_cursors = g_list_prepend (sheet_view->anted_cursors, item_cursor);
	}
}

855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
void
sheet_view_adjust_preferences (SheetView *sheet_view)
{
	Sheet *sheet = sheet_view->sheet;
	Workbook *wb = sheet->workbook;

	if (sheet->show_col_header)
		gtk_widget_show (GTK_WIDGET (sheet_view->col_canvas));
	else
		gtk_widget_hide (GTK_WIDGET (sheet_view->col_canvas));

	if (sheet->show_row_header)
		gtk_widget_show (GTK_WIDGET (sheet_view->row_canvas));
	else
		gtk_widget_hide (GTK_WIDGET (sheet_view->row_canvas));

	if (sheet->show_col_header && sheet->show_row_header)
872
		gtk_widget_show (sheet_view->select_all_btn);
873
	else
874
		gtk_widget_hide (sheet_view->select_all_btn);
875
876
877
878
879
880
881
882
883
884
885

	if (wb->show_horizontal_scrollbar)
		gtk_widget_show (sheet_view->hs);
	else
		gtk_widget_hide (sheet_view->hs);

	if (wb->show_vertical_scrollbar)
		gtk_widget_show (sheet_view->vs);
	else
		gtk_widget_hide (sheet_view->vs);
}
886

887
888
889
890
StyleFont *
sheet_view_get_style_font (const Sheet *sheet, MStyle *mstyle)
{
	/* Scale the font size by the average scaling factor for the
891
	 * display.  72dpi is base size
892
893
894
895
896
897
898
899
900
	 */

	double const zoom = sheet->last_zoom_factor_used;
	double const res  = MIN(application_display_dpi_get (FALSE),
				application_display_dpi_get (TRUE)) / 72.;

	return mstyle_get_font (mstyle, zoom * res);
}

901
#if 0
902
903
#ifdef ENABLE_BONOBO
void
904
sheet_view_insert_object (SheetView *sheet_view, BonoboObjectClient *object)
905
{
Michael Meeks's avatar
Michael Meeks committed
906
/*	GtkWidget *view;*/
907
908
909
910
911

	/*
	 * Commented out because the new_view api changed and it isn't
	 * used anyways.
	 */
912

913
	/* view = gnome_bonobo_object_new_view (object); */
914
915
916
	g_warning ("Stick this into the SheetView");
}
#endif
917
#endif