sheet-view.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