sheet-view.c 27 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"
Jody Goldberg's avatar
Jody Goldberg committed
25
#include "cellspan.h"
Arturo Espinosa's avatar
Arturo Espinosa committed
26 27 28 29 30 31 32 33

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));
34

Arturo Espinosa's avatar
Arturo Espinosa committed
35 36 37 38 39 40 41 42 43 44 45
	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);
}

Jody Goldberg's avatar
Jody Goldberg committed
46 47 48 49 50 51 52 53
/*
 * redraw a range and all of the associated spans.
 * TODO : this should have TWO cases.
 *     1) redraw just the selected region
 *         This is useful for cursor movement and the like.
 *     2) redraw including the spans.
 *         This is useful for changes to cell contents.
 */
Arturo Espinosa's avatar
Arturo Espinosa committed
54
void
Jody Goldberg's avatar
Jody Goldberg committed
55 56 57
sheet_view_redraw_cell_region (SheetView *sheet_view,
			       int start_col, int start_row,
			       int end_col, int end_row)
Arturo Espinosa's avatar
Arturo Espinosa committed
58 59
{
	GnumericSheet *gsheet;
60
	GnomeCanvas *canvas;
Arturo Espinosa's avatar
Arturo Espinosa committed
61
	Sheet *sheet = sheet_view->sheet;
Arturo Espinosa's avatar
Arturo Espinosa committed
62
	int first_col, first_row, last_col, last_row;
Jody Goldberg's avatar
Jody Goldberg committed
63
	int row, min_col, max_col;
Arturo Espinosa's avatar
Arturo Espinosa committed
64
	int x, y, w, h;
65

Arturo Espinosa's avatar
Arturo Espinosa committed
66 67 68 69 70
	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));
71
	canvas = GNOME_CANVAS (gsheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
72

73 74 75 76
	if ((end_col < gsheet->col.first) ||
	    (end_row < gsheet->row.first) ||
	    (start_col > gsheet->col.last_visible) ||
	    (start_row > gsheet->row.last_visible))
77
		return;
78

79
	/* The region on which we care to redraw */
80 81 82 83
	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);
84 85

	/* Initial values for min/max column computation */
Arturo Espinosa's avatar
Arturo Espinosa committed
86 87
	min_col = first_col;
	max_col = last_col;
88

Jody Goldberg's avatar
Jody Goldberg committed
89 90 91 92 93 94
	/*
	 * Check the first and last columns for spans
	 * and extend the region to include the maximum extent.
	 */
	for (row = first_row; row <= last_row; row++){
		ColRowInfo const * const ri = sheet_row_get (sheet, row);
95

Jody Goldberg's avatar
Jody Goldberg committed
96 97 98
		if (ri != NULL) {
			CellSpanInfo const * span0 =
			    row_span_get (ri, first_col);
99

Jody Goldberg's avatar
Jody Goldberg committed
100 101 102 103 104 105 106
			if (span0 != NULL) {
				min_col = MIN (span0->left, min_col);
				max_col = MAX (span0->right, max_col);
			}
			if (first_col != last_col) {
				CellSpanInfo const * span1 =
					row_span_get (ri, last_col);
Jody Goldberg's avatar
Jody Goldberg committed
107

Jody Goldberg's avatar
Jody Goldberg committed
108 109 110
				if (span1 != NULL) {
					min_col = MIN (span1->left, min_col);
					max_col = MAX (span1->right, max_col);
Jody Goldberg's avatar
Jody Goldberg committed
111
				}
112 113
			}
		}
Jody Goldberg's avatar
Jody Goldberg committed
114
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
115

116
	/* Only draw those regions that are visible */
117 118
	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
119

120 121
	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
122 123
	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
124

125 126
	x += canvas->layout.xoffset - canvas->zoom_xofs;
	y += canvas->layout.yoffset - canvas->zoom_yofs;
Jody Goldberg's avatar
Jody Goldberg committed
127 128 129 130 131 132 133 134

#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) */
135
	gnome_canvas_request_redraw (GNOME_CANVAS (gsheet),
Jody Goldberg's avatar
Jody Goldberg committed
136 137
				     x-1, y-1,
				     x+w+1+1, y+h+1+1);
Arturo Espinosa's avatar
Arturo Espinosa committed
138 139 140
}

void
Jody Goldberg's avatar
Jody Goldberg committed
141 142 143
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
144
{
Jody Goldberg's avatar
Jody Goldberg committed
145
	GnumericSheet *gsheet;
Arturo Espinosa's avatar
Arturo Espinosa committed
146 147 148
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));

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

Jody Goldberg's avatar
Jody Goldberg committed
151
	if (col) {
152
		int left = 0, right = INT_MAX-1;
Jody Goldberg's avatar
Jody Goldberg committed
153 154 155 156 157 158 159
		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) {
160
				left = gsheet->col_offset.first +
161
				    sheet_col_get_distance_pixels (sheet_view->sheet,
162
							    gsheet->col.first, r->start.col);
Jody Goldberg's avatar
Jody Goldberg committed
163
				right = left +
164
				    sheet_col_get_distance_pixels (sheet_view->sheet,
Jody Goldberg's avatar
Jody Goldberg committed
165 166 167
							    r->start.col, r->end.col+1);
			}
		}
168
		/* Request excludes the far coordinate.  Add 1 to include them */
Jody Goldberg's avatar
Jody Goldberg committed
169 170
		gnome_canvas_request_redraw (
			GNOME_CANVAS (sheet_view->col_canvas),
171
			left, 0, right+1, INT_MAX);
Jody Goldberg's avatar
Jody Goldberg committed
172
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
173

Jody Goldberg's avatar
Jody Goldberg committed
174
	if (row) {
175
		int top = 0, bottom = INT_MAX-1;
Jody Goldberg's avatar
Jody Goldberg committed
176 177 178 179 180 181 182
		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) {
183
				top = gsheet->row_offset.first +
184
				    sheet_row_get_distance_pixels (sheet_view->sheet,
185
							    gsheet->row.first, r->start.row);
Jody Goldberg's avatar
Jody Goldberg committed
186
				bottom = top +
187
				    sheet_row_get_distance_pixels (sheet_view->sheet,
Jody Goldberg's avatar
Jody Goldberg committed
188 189 190
							    r->start.row, r->end.row+1);
			}
		}
191
		/* Request excludes the far coordinate.  Add 1 to include them */
Jody Goldberg's avatar
Jody Goldberg committed
192 193
		gnome_canvas_request_redraw (
			GNOME_CANVAS (sheet_view->row_canvas),
194
			0, top, INT_MAX, bottom+1);
Jody Goldberg's avatar
Jody Goldberg committed
195
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
196 197 198 199 200
}

void
sheet_view_set_zoom_factor (SheetView *sheet_view, double factor)
{
201 202
	GList *l;
	GnumericSheet *gsheet;
203 204
	ItemBar *col_item, *row_item;
	int h, w;
205

Arturo Espinosa's avatar
Arturo Espinosa committed
206 207
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));
208

209
	gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
210 211
	col_item = ITEM_BAR (sheet_view->col_item);
	row_item = ITEM_BAR (sheet_view->row_item);
212

213
	/* Set pixels_per_unit before the font.  The item bars look here for the number */
214
	gnome_canvas_set_pixels_per_unit (GNOME_CANVAS (gsheet), factor);
215

216
	/* resize the header fonts */
217 218 219 220 221 222 223
	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.
	 */
224

225 226 227 228 229 230
	/* 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);
231
	gnome_canvas_set_scroll_region (GNOME_CANVAS (sheet_view->col_canvas), 0, 0,
232
					1000000*factor, h);
233

234
	gtk_widget_set_usize (GTK_WIDGET (sheet_view->row_canvas), w, -1);
235
	gnome_canvas_set_scroll_region (GNOME_CANVAS (sheet_view->row_canvas), 0, 0,
236
					w, 1200000*factor);
237

238 239
	/* Recalibrate the starting offsets */
	gsheet->col_offset.first =
240
	    sheet_col_get_distance_pixels (sheet_view->sheet, 0, gsheet->col.first);
241
	gsheet->row_offset.first =
242
	    sheet_row_get_distance_pixels (sheet_view->sheet, 0, gsheet->row.first);
243

244 245 246 247 248 249 250
	if (GTK_WIDGET_REALIZED (gsheet))
		/* Ensure that the current cell remains visible when we zoom */
		gnumeric_sheet_make_cell_visible
			(gsheet,
			 sheet_view->sheet->cursor.edit_pos.col,
			 sheet_view->sheet->cursor.edit_pos.row,
			 TRUE);
251 252 253 254 255 256 257

	/* 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
258 259 260 261 262 263 264 265 266 267 268
}

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)
{
269 270 271 272 273 274 275 276 277 278
	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
279 280 281 282 283

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

284
	*itemp = item;
Arturo Espinosa's avatar
Arturo Espinosa committed
285
	gtk_widget_show (canvas);
286

287
	return GNOME_CANVAS(canvas);
Arturo Espinosa's avatar
Arturo Espinosa committed
288 289
}

Jody Goldberg's avatar
Jody Goldberg committed
290 291 292
/* Manages the scrollbar dimensions and paging parameters. */
void
sheet_view_scrollbar_config (SheetView const *sheet_view)
Arturo Espinosa's avatar
Arturo Espinosa committed
293 294 295 296
{
	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
297
	Sheet         *sheet = sheet_view->sheet;
298 299
	int const last_col = gsheet->col.last_full;
	int const last_row = gsheet->row.last_full;
Arturo Espinosa's avatar
Arturo Espinosa committed
300

Jody Goldberg's avatar
Jody Goldberg committed
301
	va->upper = MAX (MAX (last_row,
302
			      sheet_view->sheet->rows.max_used),
303 304
			 MAX (sheet->cursor.move_corner.row,
			      sheet->cursor.base_corner.row));
305
	va->page_size = last_row - gsheet->row.first;
306
	va->value = gsheet->row.first;
Jody Goldberg's avatar
Jody Goldberg committed
307 308
	va->step_increment = va->page_increment =
	    va->page_size / 2;
309

Jody Goldberg's avatar
Jody Goldberg committed
310
	ha->upper = MAX (MAX (last_col,
311
			      sheet_view->sheet->cols.max_used),
312 313
			 MAX (sheet->cursor.move_corner.col,
			      sheet->cursor.base_corner.col));
314
	ha->page_size = last_col - gsheet->col.first;
315
	ha->value = gsheet->col.first;
Jody Goldberg's avatar
Jody Goldberg committed
316 317
	ha->step_increment = ha->page_increment =
	    ha->page_size / 2;
Arturo Espinosa's avatar
Arturo Espinosa committed
318 319 320 321 322

	gtk_adjustment_changed (va);
	gtk_adjustment_changed (ha);
}

323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344
/*
 * sheet_view_make_edit_pos_visible
 * @sheet_view  Sheet view
 *
 * Make the cell at the edit position visible.
 *
 * To be called from the "size_allocate" signal handler when the geometry of a
 * new sheet view has been configured. 
 */
static void
sheet_view_make_edit_pos_visible (SheetView const *sheet_view)
{
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);

	gnumeric_sheet_make_cell_visible
		(gsheet,
		 sheet_view->sheet->cursor.edit_pos.col,
		 sheet_view->sheet->cursor.edit_pos.row,
		 TRUE);

}

Jody Goldberg's avatar
Jody Goldberg committed
345 346 347
static void
sheet_view_size_allocate (GtkWidget *widget, GtkAllocation *alloc, SheetView *sheet_view)
{
348
	sheet_view_make_edit_pos_visible (sheet_view);
Jody Goldberg's avatar
Jody Goldberg committed
349 350 351
	sheet_view_scrollbar_config (sheet_view);
}

Arturo Espinosa's avatar
Arturo Espinosa committed
352
static void
353 354
sheet_view_col_selection_changed (ItemBar *item_bar, int col, int modifiers, SheetView *sheet_view)
{
Arturo Espinosa's avatar
Arturo Espinosa committed
355
	Sheet *sheet = sheet_view->sheet;
356 357
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);

358
	/* Ensure that the col exists, ignore result */
359 360
	sheet_col_fetch (sheet, col);

361 362 363 364
	if (modifiers){
		if ((modifiers & GDK_SHIFT_MASK) && sheet->selections){
			SheetSelection *ss = sheet->selections->data;
			int start_col, end_col;
365 366 367 368

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

369
			sheet_selection_set (sheet,
370
					     start_col, gsheet->row.first,
371 372 373 374
					     start_col, 0,
					     end_col, SHEET_MAX_ROWS-1);
			return;
		}
375

376 377
		if (!(modifiers & GDK_CONTROL_MASK))
			sheet_selection_reset_only (sheet);
378

379 380 381 382
		sheet_selection_add_range (sheet,
					   col, gsheet->row.first,
					   col, 0,
					   col, SHEET_MAX_ROWS-1);
Arturo Espinosa's avatar
Arturo Espinosa committed
383
	} else
384
		sheet_selection_extend_to (sheet, col, SHEET_MAX_ROWS - 1);
Arturo Espinosa's avatar
Arturo Espinosa committed
385 386 387 388 389 390
}

static void
sheet_view_col_size_changed (ItemBar *item_bar, int col, int width, SheetView *sheet_view)
{
	Sheet *sheet = sheet_view->sheet;
391 392 393 394
	ItemBarSelectionType type;

	type = sheet_col_selection_type (sheet, col);

395 396 397
 	if (type == ITEM_BAR_FULL_SELECTION) {
		int i = sheet->cols.max_used;
		for (;i >= 0 ; --i) {
Jody Goldberg's avatar
Jody Goldberg committed
398
 			ColRowInfo const * const ci = sheet_col_get (sheet, i);
399 400
			if (ci == NULL)
				continue;
401

Jody Goldberg's avatar
Jody Goldberg committed
402 403 404 405 406
 			if (sheet_col_selection_type (sheet, ci->pos) == ITEM_BAR_FULL_SELECTION) {
 				sheet_col_set_size_pixels (sheet, i, width, TRUE);
				/* FIXME should be done later */
				sheet_recompute_spans_for_col (sheet, i);
			}
407
 		}
Jody Goldberg's avatar
Jody Goldberg committed
408
	} else {
409
 		sheet_col_set_size_pixels (sheet, col, width, TRUE);
Jody Goldberg's avatar
Jody Goldberg committed
410 411 412
		/* FIXME should be done later */
		sheet_recompute_spans_for_col (sheet, col);
	}
413

Jody Goldberg's avatar
Jody Goldberg committed
414
	sheet_update (sheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
415 416 417
}

static void
418
sheet_view_row_selection_changed (ItemBar *item_bar, int row, int modifiers, SheetView *sheet_view)
Arturo Espinosa's avatar
Arturo Espinosa committed
419 420
{
	Sheet *sheet = sheet_view->sheet;
421
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
422

423 424
	/* Ensure that the row exists, ignore result */
	sheet_row_fetch (sheet, row);
425

426 427 428 429
	if (modifiers){
		if ((modifiers & GDK_SHIFT_MASK) && sheet->selections){
			SheetSelection *ss = sheet->selections->data;
			int start_row, end_row;
430 431 432 433

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

434
			sheet_selection_set (sheet,
435
					     gsheet->col.first, start_row,
436 437 438 439
					     0, start_row,
					     SHEET_MAX_COLS-1, end_row);
			return;
		}
440

441 442
		if (!(modifiers & GDK_CONTROL_MASK))
 			sheet_selection_reset_only (sheet);
443 444 445 446 447

		sheet_selection_add_range (sheet,
					   gsheet->col.first, row,
					   0, row,
					   SHEET_MAX_COLS-1, row);
Arturo Espinosa's avatar
Arturo Espinosa committed
448
	} else
449
		sheet_selection_extend_to (sheet, SHEET_MAX_COLS-1, row);
Arturo Espinosa's avatar
Arturo Espinosa committed
450 451 452 453 454 455
}

static void
sheet_view_row_size_changed (ItemBar *item_bar, int row, int height, SheetView *sheet_view)
{
	Sheet *sheet = sheet_view->sheet;
456 457 458 459
	ItemBarSelectionType type;

	type = sheet_row_selection_type (sheet, row);

460 461 462
	if (type == ITEM_BAR_FULL_SELECTION) {
		int i;
		for (i = sheet->rows.max_used; i >= 0 ; --i) {
Jody Goldberg's avatar
Jody Goldberg committed
463
 			ColRowInfo const * const ri = sheet_row_get (sheet, i);
464 465
			if (ri == NULL)
				continue;
466

467
			if (sheet_row_selection_type (sheet, ri->pos) == ITEM_BAR_FULL_SELECTION)
Jody Goldberg's avatar
Jody Goldberg committed
468
				sheet_row_set_size_pixels (sheet, ri->pos, height, TRUE);
469
		}
470
	} else
471
		sheet_row_set_size_pixels (sheet, row, height, TRUE);
Jody Goldberg's avatar
Jody Goldberg committed
472 473

	sheet_update (sheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
474 475 476 477 478 479
}

static void
button_select_all (GtkWidget *the_button, SheetView *sheet_view)
{
	sheet_select_all (sheet_view->sheet);
480
	sheet_redraw_all (sheet_view->sheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
481 482 483 484 485
}

static void
vertical_scroll_change (GtkAdjustment *adj, SheetView *sheet_view)
{
486 487 488 489 490
	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
491 492 493 494 495
}

static void
horizontal_scroll_change (GtkAdjustment *adj, SheetView *sheet_view)
{
496 497 498 499
	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
500 501 502 503 504 505 506
	}
}

static int
horizontal_scroll_event (GtkScrollbar *scroll, GdkEvent *event, SheetView *sheet_view)
{
	if (event->type == GDK_BUTTON_PRESS){
507 508 509
		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
510
		gtk_widget_show_all (gtk_widget_get_toplevel (sheet_view->tip));
511 512 513 514
	}
	else if (event->type == GDK_BUTTON_RELEASE)
	{
		GnumericSheet  *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
515
		int col;
516

517 518 519 520 521 522
		/* 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
523

524 525
		col = GTK_ADJUSTMENT (sheet_view->ha)->value;

526
		gnumeric_sheet_set_left_col (gsheet, col);
527
		/* NOTE : Excel does not move the cursor, just scrolls the sheet. */
Arturo Espinosa's avatar
Arturo Espinosa committed
528
	}
529

Arturo Espinosa's avatar
Arturo Espinosa committed
530 531 532 533 534 535 536
	return FALSE;
}

static int
vertical_scroll_event (GtkScrollbar *scroll, GdkEvent *event, SheetView *sheet_view)
{
	if (event->type == GDK_BUTTON_PRESS){
537 538 539
		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
540
		gtk_widget_show_all (gtk_widget_get_toplevel (sheet_view->tip));
541 542 543 544
	}
	else if (event->type == GDK_BUTTON_RELEASE)
	{
		GnumericSheet  *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
545
		int row;
546

547 548 549 550 551 552
		/* 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
553

554
		row = GTK_ADJUSTMENT (sheet_view->va)->value;
555

556
		gnumeric_sheet_set_top_row (gsheet, row);
557
		/* NOTE : Excel does not move the cursor, just scrolls the sheet. */
Arturo Espinosa's avatar
Arturo Espinosa committed
558 559 560 561 562
	}

	return FALSE;
}

563 564 565 566
static void
sheet_view_init (SheetView *sheet_view)
{
	GtkTable *table = GTK_TABLE (sheet_view);
567

568 569 570 571
	table->homogeneous = FALSE;
	gtk_table_resize (table, 4, 4);
}

Arturo Espinosa's avatar
Arturo Espinosa committed
572 573 574
static void
sheet_view_construct (SheetView *sheet_view)
{
575
	GnomeCanvasGroup *root_group;
Arturo Espinosa's avatar
Arturo Espinosa committed
576 577
	GtkTable  *table = GTK_TABLE (sheet_view);
	Sheet *sheet = sheet_view->sheet;
578

Arturo Espinosa's avatar
Arturo Espinosa committed
579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594
	/* 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);
595

Arturo Espinosa's avatar
Arturo Espinosa committed
596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612
	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
613

Arturo Espinosa's avatar
Arturo Espinosa committed
614 615 616 617
	gtk_signal_connect_after (
		GTK_OBJECT (sheet_view), "size_allocate",
		GTK_SIGNAL_FUNC (sheet_view_size_allocate), sheet_view);

618 619 620
	/* Create the object group inside the GnumericSheet */
	root_group = GNOME_CANVAS_GROUP (
		GNOME_CANVAS (sheet_view->sheet_view)->root);
621 622 623 624 625 626 627
	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));
628

Arturo Espinosa's avatar
Arturo Espinosa committed
629 630 631 632 633 634 635 636
	/* 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);

637 638 639 640 641 642 643 644 645 646
	/*
	 * 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));
647

Arturo Espinosa's avatar
Arturo Espinosa committed
648
	/* The select-all button */
649 650 651 652
	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
653
			    GTK_SIGNAL_FUNC (button_select_all), sheet_view);
654

Arturo Espinosa's avatar
Arturo Espinosa committed
655
	/* Scroll bars and their adjustments */
656 657
	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
658 659 660 661 662 663 664 665 666 667 668
	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);
669

Arturo Espinosa's avatar
Arturo Espinosa committed
670 671 672 673 674 675 676 677 678 679 680 681 682
	/* 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);
683
	sheet_view_set_zoom_factor (sheet_view, 1.);
684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700
}

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));
	}
701

702 703 704 705 706 707 708
	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
709 710 711 712 713 714 715 716 717
}

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

	sheet_view = gtk_type_new (sheet_view_get_type ());
	sheet_view->sheet = sheet;
718
	sheet_view->tip = NULL;
719

Arturo Espinosa's avatar
Arturo Espinosa committed
720
	sheet_view_construct (sheet_view);
721

Arturo Espinosa's avatar
Arturo Espinosa committed
722 723 724 725 726 727 728 729 730 731
	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)
732
		gtk_object_unref (GTK_OBJECT (sheet_view->tip));
733

Arturo Espinosa's avatar
Arturo Espinosa committed
734 735 736 737 738
	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
739
sheet_view_class_init (SheetViewClass *Class)
Arturo Espinosa's avatar
Arturo Espinosa committed
740 741 742
{
	GtkObjectClass *object_class;

Jody Goldberg's avatar
Jody Goldberg committed
743
	object_class = (GtkObjectClass *) Class;
Arturo Espinosa's avatar
Arturo Espinosa committed
744 745

	sheet_view_parent_class = gtk_type_class (gtk_table_get_type ());
746

Arturo Espinosa's avatar
Arturo Espinosa committed
747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771
	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;
}
772

Miguel de Icaza's avatar
New:  
Miguel de Icaza committed
773 774 775 776 777 778 779 780 781 782 783 784 785 786 787
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);
}
788 789 790

#define TRIANGLE_WIDTH 6

791 792
static GnomeCanvasPoints *
sheet_view_comment_get_points (SheetView *sheet_view, int col, int row)
793 794
{
	GnomeCanvasPoints *points;
795
	int x, y, i;
796 797 798

	points = gnome_canvas_points_new (3);

799 800
	x = sheet_col_get_distance_pixels (sheet_view->sheet, 0, col+1);
	y = 1+sheet_row_get_distance_pixels (sheet_view->sheet, 0, row);
801 802 803 804 805 806 807 808

	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;

809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824
	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;
825

826 827 828 829 830 831
	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);

832 833 834 835 836 837 838 839
	i = gnome_canvas_item_new (
		group, gnome_canvas_polygon_get_type (),
		"points",     points,
		"fill_color", "red",
		NULL);

	return i;
}
840 841 842 843 844 845 846 847 848 849 850 851 852 853

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);
Morten Welinder's avatar
Morten Welinder committed
854
	g_free (points);
855 856
}

857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880
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;
881

882 883
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));
884

885 886 887 888 889
	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;
890

891 892 893
	for (l = sheet_view->sheet->selections; l; l = l->next){
		SheetSelection *ss = l->data;
		ItemCursor *item_cursor;
894

895 896 897 898 899 900 901 902 903 904 905 906 907 908 909
		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);
	}
}

910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926
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)
927
		gtk_widget_show (sheet_view->select_all_btn);
928
	else
929
		gtk_widget_hide (sheet_view->select_all_btn);
930 931 932 933 934 935 936 937 938 939 940

	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);
}
941

942
StyleFont *
943
sheet_view_get_style_font (const Sheet *sheet, MStyle const * const mstyle)
944 945
{
	/* Scale the font size by the average scaling factor for the
946
	 * display.  72dpi is base size
947 948 949 950 951 952 953 954 955
	 */

	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);
}

956
#if 0
957 958
#ifdef ENABLE_BONOBO
void
959
sheet_view_insert_object (SheetView *sheet_view, BonoboObjectClient *object)
960
{
Michael Meeks's avatar
Michael Meeks committed
961
/*	GtkWidget *view;*/
962 963 964 965 966

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

968
	/* view = gnome_bonobo_object_new_view (object); */
969 970 971
	g_warning ("Stick this into the SheetView");
}
#endif
972
#endif