sheet-view.c 26.4 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 "parse-util.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
 * Redraw selected range, do not honour spans
Jody Goldberg's avatar
Jody Goldberg committed
48
 */
Arturo Espinosa's avatar
Arturo Espinosa committed
49
void
Jody Goldberg's avatar
Jody Goldberg committed
50 51 52
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
53 54
{
	GnumericSheet *gsheet;
55
	GnomeCanvas *canvas;
Arturo Espinosa's avatar
Arturo Espinosa committed
56 57
	Sheet *sheet = sheet_view->sheet;
	int x, y, w, h;
58

Arturo Espinosa's avatar
Arturo Espinosa committed
59 60 61 62 63
	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));
64
	canvas = GNOME_CANVAS (gsheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
65

66 67 68 69
	if ((end_col < gsheet->col.first) ||
	    (end_row < gsheet->row.first) ||
	    (start_col > gsheet->col.last_visible) ||
	    (start_row > gsheet->row.last_visible))
70
		return;
71

72
	/* Only draw those regions that are visible */
73 74 75 76
	start_col = MAX (gsheet->col.first, start_col);
	start_row = MAX (gsheet->row.first, start_row);
	end_col =  MIN (gsheet->col.last_visible, end_col);
	end_row =  MIN (gsheet->row.last_visible, end_row);
Arturo Espinosa's avatar
Arturo Espinosa committed
77

78 79 80 81
	x = sheet_col_get_distance_pixels (sheet, gsheet->col.first, start_col);
	y = sheet_row_get_distance_pixels (sheet, gsheet->row.first, start_row);
	w = sheet_col_get_distance_pixels (sheet, start_col, end_col+1);
	h = sheet_row_get_distance_pixels (sheet, start_row, end_row+1);
Arturo Espinosa's avatar
Arturo Espinosa committed
82

83 84
	x += canvas->layout.xoffset - canvas->zoom_xofs;
	y += canvas->layout.yoffset - canvas->zoom_yofs;
Jody Goldberg's avatar
Jody Goldberg committed
85 86 87 88 89 90 91 92

#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) */
93
	gnome_canvas_request_redraw (GNOME_CANVAS (gsheet),
Jody Goldberg's avatar
Jody Goldberg committed
94 95
				     x-1, y-1,
				     x+w+1+1, y+h+1+1);
Arturo Espinosa's avatar
Arturo Espinosa committed
96 97 98
}

void
Jody Goldberg's avatar
Jody Goldberg committed
99 100 101
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
102
{
Jody Goldberg's avatar
Jody Goldberg committed
103
	GnumericSheet *gsheet;
Arturo Espinosa's avatar
Arturo Espinosa committed
104 105 106
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));

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

Jody Goldberg's avatar
Jody Goldberg committed
109
	if (col) {
110
		int left = 0, right = INT_MAX-1;
Jody Goldberg's avatar
Jody Goldberg committed
111 112 113 114 115 116 117
		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) {
118
				left = gsheet->col_offset.first +
119
				    sheet_col_get_distance_pixels (sheet_view->sheet,
120
							    gsheet->col.first, r->start.col);
Jody Goldberg's avatar
Jody Goldberg committed
121
				right = left +
122
				    sheet_col_get_distance_pixels (sheet_view->sheet,
Jody Goldberg's avatar
Jody Goldberg committed
123 124 125
							    r->start.col, r->end.col+1);
			}
		}
126
		/* Request excludes the far coordinate.  Add 1 to include them */
Jody Goldberg's avatar
Jody Goldberg committed
127 128
		gnome_canvas_request_redraw (
			GNOME_CANVAS (sheet_view->col_canvas),
129
			left, 0, right+1, INT_MAX);
Jody Goldberg's avatar
Jody Goldberg committed
130
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
131

Jody Goldberg's avatar
Jody Goldberg committed
132
	if (row) {
133
		int top = 0, bottom = INT_MAX-1;
Jody Goldberg's avatar
Jody Goldberg committed
134 135 136 137 138 139 140
		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) {
141
				top = gsheet->row_offset.first +
142
				    sheet_row_get_distance_pixels (sheet_view->sheet,
143
							    gsheet->row.first, r->start.row);
Jody Goldberg's avatar
Jody Goldberg committed
144
				bottom = top +
145
				    sheet_row_get_distance_pixels (sheet_view->sheet,
Jody Goldberg's avatar
Jody Goldberg committed
146 147 148
							    r->start.row, r->end.row+1);
			}
		}
149
		/* Request excludes the far coordinate.  Add 1 to include them */
Jody Goldberg's avatar
Jody Goldberg committed
150 151
		gnome_canvas_request_redraw (
			GNOME_CANVAS (sheet_view->row_canvas),
152
			0, top, INT_MAX, bottom+1);
Jody Goldberg's avatar
Jody Goldberg committed
153
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
154 155 156 157 158
}

void
sheet_view_set_zoom_factor (SheetView *sheet_view, double factor)
{
159 160
	GList *l;
	GnumericSheet *gsheet;
161 162
	ItemBar *col_item, *row_item;
	int h, w;
163

Arturo Espinosa's avatar
Arturo Espinosa committed
164 165
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));
166

167
	gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
168 169
	col_item = ITEM_BAR (sheet_view->col_item);
	row_item = ITEM_BAR (sheet_view->row_item);
170

171
	/* Set pixels_per_unit before the font.  The item bars look here for the number */
172
	gnome_canvas_set_pixels_per_unit (GNOME_CANVAS (gsheet), factor);
173

174
	/* resize the header fonts */
175 176 177 178 179 180 181
	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.
	 */
182

183 184 185 186 187 188
	/* 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);
189
	gnome_canvas_set_scroll_region (GNOME_CANVAS (sheet_view->col_canvas), 0, 0,
190
					1000000*factor, h);
191

192
	gtk_widget_set_usize (GTK_WIDGET (sheet_view->row_canvas), w, -1);
193
	gnome_canvas_set_scroll_region (GNOME_CANVAS (sheet_view->row_canvas), 0, 0,
194
					w, 1200000*factor);
195

196 197
	/* Recalibrate the starting offsets */
	gsheet->col_offset.first =
198
	    sheet_col_get_distance_pixels (sheet_view->sheet, 0, gsheet->col.first);
199
	gsheet->row_offset.first =
200
	    sheet_row_get_distance_pixels (sheet_view->sheet, 0, gsheet->row.first);
201

202 203 204 205 206 207 208
	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);
209 210 211 212 213 214 215

	/* 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
216 217 218 219 220 221 222 223 224 225 226
}

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)
{
227 228 229 230 231 232 233 234 235 236
	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
237 238 239 240 241

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

242
	*itemp = item;
Arturo Espinosa's avatar
Arturo Espinosa committed
243
	gtk_widget_show (canvas);
244

245
	return GNOME_CANVAS(canvas);
Arturo Espinosa's avatar
Arturo Espinosa committed
246 247
}

Jody Goldberg's avatar
Jody Goldberg committed
248 249 250
/* Manages the scrollbar dimensions and paging parameters. */
void
sheet_view_scrollbar_config (SheetView const *sheet_view)
Arturo Espinosa's avatar
Arturo Espinosa committed
251 252 253 254
{
	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
255
	Sheet         *sheet = sheet_view->sheet;
256 257
	int const last_col = gsheet->col.last_full;
	int const last_row = gsheet->row.last_full;
Arturo Espinosa's avatar
Arturo Espinosa committed
258

Jody Goldberg's avatar
Jody Goldberg committed
259
	va->upper = MAX (MAX (last_row,
260
			      sheet_view->sheet->rows.max_used),
261 262
			 MAX (sheet->cursor.move_corner.row,
			      sheet->cursor.base_corner.row));
263
	va->page_size = last_row - gsheet->row.first;
264
	va->value = gsheet->row.first;
Jody Goldberg's avatar
Jody Goldberg committed
265 266
	va->step_increment = va->page_increment =
	    va->page_size / 2;
267

Jody Goldberg's avatar
Jody Goldberg committed
268
	ha->upper = MAX (MAX (last_col,
269
			      sheet_view->sheet->cols.max_used),
270 271
			 MAX (sheet->cursor.move_corner.col,
			      sheet->cursor.base_corner.col));
272
	ha->page_size = last_col - gsheet->col.first;
273
	ha->value = gsheet->col.first;
Jody Goldberg's avatar
Jody Goldberg committed
274 275
	ha->step_increment = ha->page_increment =
	    ha->page_size / 2;
Arturo Espinosa's avatar
Arturo Espinosa committed
276 277 278 279 280

	gtk_adjustment_changed (va);
	gtk_adjustment_changed (ha);
}

281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302
/*
 * 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
303 304 305
static void
sheet_view_size_allocate (GtkWidget *widget, GtkAllocation *alloc, SheetView *sheet_view)
{
306
	sheet_view_make_edit_pos_visible (sheet_view);
Jody Goldberg's avatar
Jody Goldberg committed
307 308 309
	sheet_view_scrollbar_config (sheet_view);
}

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

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

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

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

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

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

344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368
struct closure_colrow_resize {
	int size_pixels;
	gboolean is_cols;
};

static gboolean
cb_colrow_resize (Sheet *sheet, Range const *r, gpointer user_data)
{
	struct closure_colrow_resize const *info = user_data;
	int tmp;

	if (info->is_cols) {
		if (r->start.row == 0 && r->end.row   >= SHEET_MAX_ROWS - 1)
			for (tmp = r->start.col; tmp <= r->end.col ; ++tmp) {
				sheet_col_set_size_pixels (sheet, tmp, info->size_pixels, TRUE);
				/* FIXME should be done later */
				sheet_recompute_spans_for_col (sheet, tmp);
			}
	} else if (r->start.col == 0 && r->end.col >= SHEET_MAX_COLS - 1)
		for (tmp = r->start.row; tmp <= r->end.row ; ++tmp)
			sheet_row_set_size_pixels (sheet, tmp, info->size_pixels, TRUE);

	return TRUE;
}

Arturo Espinosa's avatar
Arturo Espinosa committed
369
static void
370 371
sheet_view_col_size_changed (ItemBar *item_bar, int col, int width,
			     SheetView *sheet_view)
Arturo Espinosa's avatar
Arturo Espinosa committed
372 373
{
	Sheet *sheet = sheet_view->sheet;
374
	ItemBarSelectionType const type = sheet_col_selection_type (sheet, col);
375

376 377 378 379
	/*
	 * If the column that changed size is completely selected (top to
	 * bottom) then resize all other columns which are fully selected too.
	 */
380
 	if (type == ITEM_BAR_FULL_SELECTION) {
381 382 383 384
		struct closure_colrow_resize	closure;
		closure.size_pixels = width;
		closure.is_cols = TRUE;
		selection_foreach_range (sheet, &cb_colrow_resize, &closure);
Jody Goldberg's avatar
Jody Goldberg committed
385
	} else {
386
 		sheet_col_set_size_pixels (sheet, col, width, TRUE);
Jody Goldberg's avatar
Jody Goldberg committed
387 388 389
		/* FIXME should be done later */
		sheet_recompute_spans_for_col (sheet, col);
	}
390

Jody Goldberg's avatar
Jody Goldberg committed
391
	sheet_update (sheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
392 393 394
}

static void
395
sheet_view_row_selection_changed (ItemBar *item_bar, int row, int modifiers, SheetView *sheet_view)
Arturo Espinosa's avatar
Arturo Espinosa committed
396 397
{
	Sheet *sheet = sheet_view->sheet;
398
	GnumericSheet *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
399 400 401 402 403

	if (modifiers){
		if ((modifiers & GDK_SHIFT_MASK) && sheet->selections){
			SheetSelection *ss = sheet->selections->data;
			int start_row, end_row;
404 405 406 407

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

408
			sheet_selection_set (sheet,
409
					     gsheet->col.first, start_row,
410 411 412 413
					     0, start_row,
					     SHEET_MAX_COLS-1, end_row);
			return;
		}
414

415 416
		if (!(modifiers & GDK_CONTROL_MASK))
 			sheet_selection_reset_only (sheet);
417 418 419 420 421

		sheet_selection_add_range (sheet,
					   gsheet->col.first, row,
					   0, row,
					   SHEET_MAX_COLS-1, row);
422
	} else {
423
		sheet_selection_extend_to (sheet, SHEET_MAX_COLS-1, row);
424 425
		gnumeric_sheet_make_cell_visible (gsheet, gsheet->col.first, row, FALSE);
	}
Arturo Espinosa's avatar
Arturo Espinosa committed
426 427 428 429 430 431
}

static void
sheet_view_row_size_changed (ItemBar *item_bar, int row, int height, SheetView *sheet_view)
{
	Sheet *sheet = sheet_view->sheet;
432
	ItemBarSelectionType const type = sheet_row_selection_type (sheet, row);
433

434 435 436 437 438 439 440 441 442
	/*
	 * If the row that changed size is completely selected (left to
	 * right) then resize all other rows which are fully selected too.
	 */
 	if (type == ITEM_BAR_FULL_SELECTION) {
		struct closure_colrow_resize	closure;
		closure.size_pixels = height;
		closure.is_cols = FALSE;
		selection_foreach_range (sheet, &cb_colrow_resize, &closure);
443
	} else
444
		sheet_row_set_size_pixels (sheet, row, height, TRUE);
Jody Goldberg's avatar
Jody Goldberg committed
445 446

	sheet_update (sheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
447 448 449 450 451 452
}

static void
button_select_all (GtkWidget *the_button, SheetView *sheet_view)
{
	sheet_select_all (sheet_view->sheet);
453
	sheet_redraw_all (sheet_view->sheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
454 455 456 457 458
}

static void
vertical_scroll_change (GtkAdjustment *adj, SheetView *sheet_view)
{
459 460 461 462 463
	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
464 465 466 467 468
}

static void
horizontal_scroll_change (GtkAdjustment *adj, SheetView *sheet_view)
{
469 470 471 472
	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
473 474 475 476 477 478 479
	}
}

static int
horizontal_scroll_event (GtkScrollbar *scroll, GdkEvent *event, SheetView *sheet_view)
{
	if (event->type == GDK_BUTTON_PRESS){
480 481 482
		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
483
		gtk_widget_show_all (gtk_widget_get_toplevel (sheet_view->tip));
484 485

	} else if (event->type == GDK_BUTTON_RELEASE) {
486
		GnumericSheet  *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
487
		int col;
488

489 490 491 492 493 494
		/* 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
495

496 497
		col = GTK_ADJUSTMENT (sheet_view->ha)->value;

498
		gnumeric_sheet_set_left_col (gsheet, col);
499
		/* NOTE : Excel does not move the cursor, just scrolls the sheet. */
Arturo Espinosa's avatar
Arturo Espinosa committed
500
	}
501

Arturo Espinosa's avatar
Arturo Espinosa committed
502 503 504 505 506 507 508
	return FALSE;
}

static int
vertical_scroll_event (GtkScrollbar *scroll, GdkEvent *event, SheetView *sheet_view)
{
	if (event->type == GDK_BUTTON_PRESS){
509 510 511
		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
512
		gtk_widget_show_all (gtk_widget_get_toplevel (sheet_view->tip));
513 514

	} else if (event->type == GDK_BUTTON_RELEASE) {
515
		GnumericSheet  *gsheet = GNUMERIC_SHEET (sheet_view->sheet_view);
516
		int row;
517

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

525
		row = GTK_ADJUSTMENT (sheet_view->va)->value;
526

527
		gnumeric_sheet_set_top_row (gsheet, row);
528
		/* NOTE : Excel does not move the cursor, just scrolls the sheet. */
Arturo Espinosa's avatar
Arturo Espinosa committed
529 530 531 532 533
	}

	return FALSE;
}

534 535 536 537
static void
sheet_view_init (SheetView *sheet_view)
{
	GtkTable *table = GTK_TABLE (sheet_view);
538

539 540 541 542
	table->homogeneous = FALSE;
	gtk_table_resize (table, 4, 4);
}

Arturo Espinosa's avatar
Arturo Espinosa committed
543 544 545
static void
sheet_view_construct (SheetView *sheet_view)
{
546
	GnomeCanvasGroup *root_group;
Arturo Espinosa's avatar
Arturo Espinosa committed
547 548
	GtkTable  *table = GTK_TABLE (sheet_view);
	Sheet *sheet = sheet_view->sheet;
549

Arturo Espinosa's avatar
Arturo Espinosa committed
550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565
	/* 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);
566

Arturo Espinosa's avatar
Arturo Espinosa committed
567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583
	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
584

Arturo Espinosa's avatar
Arturo Espinosa committed
585 586 587 588
	gtk_signal_connect_after (
		GTK_OBJECT (sheet_view), "size_allocate",
		GTK_SIGNAL_FUNC (sheet_view_size_allocate), sheet_view);

589 590 591
	/* Create the object group inside the GnumericSheet */
	root_group = GNOME_CANVAS_GROUP (
		GNOME_CANVAS (sheet_view->sheet_view)->root);
592 593 594 595 596 597 598
	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));
599

Arturo Espinosa's avatar
Arturo Espinosa committed
600 601 602 603 604 605 606 607
	/* 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);

608 609 610 611 612 613 614 615 616 617
	/*
	 * 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));
618

Arturo Espinosa's avatar
Arturo Espinosa committed
619
	/* The select-all button */
620 621 622 623
	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
624
			    GTK_SIGNAL_FUNC (button_select_all), sheet_view);
625

Arturo Espinosa's avatar
Arturo Espinosa committed
626
	/* Scroll bars and their adjustments */
627 628
	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
629 630 631 632 633 634 635 636 637 638 639
	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);
640

Arturo Espinosa's avatar
Arturo Espinosa committed
641 642 643 644 645 646 647 648 649 650 651 652 653
	/* 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);
654
	sheet_view_set_zoom_factor (sheet_view, 1.);
655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671
}

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

673 674 675 676 677 678 679
	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
680 681 682 683 684 685 686 687 688
}

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

	sheet_view = gtk_type_new (sheet_view_get_type ());
	sheet_view->sheet = sheet;
689
	sheet_view->tip = NULL;
690

Arturo Espinosa's avatar
Arturo Espinosa committed
691
	sheet_view_construct (sheet_view);
692

Arturo Espinosa's avatar
Arturo Espinosa committed
693 694 695 696 697 698 699 700 701 702
	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)
703
		gtk_object_unref (GTK_OBJECT (sheet_view->tip));
704

Arturo Espinosa's avatar
Arturo Espinosa committed
705 706 707 708 709
	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
710
sheet_view_class_init (SheetViewClass *Class)
Arturo Espinosa's avatar
Arturo Espinosa committed
711 712 713
{
	GtkObjectClass *object_class;

Jody Goldberg's avatar
Jody Goldberg committed
714
	object_class = (GtkObjectClass *) Class;
Arturo Espinosa's avatar
Arturo Espinosa committed
715 716

	sheet_view_parent_class = gtk_type_class (gtk_table_get_type ());
717

Arturo Espinosa's avatar
Arturo Espinosa committed
718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742
	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;
}
743

Miguel de Icaza's avatar
New:  
Miguel de Icaza committed
744 745 746 747 748 749 750 751 752 753 754 755 756 757 758
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);
}
759 760 761

#define TRIANGLE_WIDTH 6

762 763
static GnomeCanvasPoints *
sheet_view_comment_get_points (SheetView *sheet_view, int col, int row)
764 765
{
	GnomeCanvasPoints *points;
766
	int x, y, i;
767 768 769

	points = gnome_canvas_points_new (3);

770 771
	x = sheet_col_get_distance_pixels (sheet_view->sheet, 0, col+1);
	y = 1+sheet_row_get_distance_pixels (sheet_view->sheet, 0, row);
772 773 774 775 776 777 778 779

	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;

780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795
	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;
796

797 798 799 800 801 802
	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);

803 804 805 806 807 808 809 810
	i = gnome_canvas_item_new (
		group, gnome_canvas_polygon_get_type (),
		"points",     points,
		"fill_color", "red",
		NULL);

	return i;
}
811 812 813 814 815 816 817 818 819 820 821 822 823 824

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
825
	gnome_canvas_points_free (points);
826 827
}

828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851
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;
852

853 854
	g_return_if_fail (sheet_view != NULL);
	g_return_if_fail (IS_SHEET_VIEW (sheet_view));
855

856 857 858 859 860
	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;
861

862 863 864
	for (l = sheet_view->sheet->selections; l; l = l->next){
		SheetSelection *ss = l->data;
		ItemCursor *item_cursor;
865

866 867 868 869 870 871 872 873 874 875 876 877 878 879 880
		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);
	}
}

881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897
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)
898
		gtk_widget_show (sheet_view->select_all_btn);
899
	else
900
		gtk_widget_hide (sheet_view->select_all_btn);
901 902 903 904 905 906 907 908 909 910 911

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

913
StyleFont *
914
sheet_view_get_style_font (const Sheet *sheet, MStyle const * const mstyle)
915 916
{
	/* Scale the font size by the average scaling factor for the
917
	 * display.  72dpi is base size
918 919 920 921 922 923 924 925 926
	 */

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

927
#if 0
928 929
#ifdef ENABLE_BONOBO
void
930
sheet_view_insert_object (SheetView *sheet_view, BonoboObjectClient *object)
931
{
Michael Meeks's avatar
Michael Meeks committed
932
/*	GtkWidget *view;*/
933 934 935 936 937

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

939
	/* view = gnome_bonobo_object_new_view (object); */
940 941 942
	g_warning ("Stick this into the SheetView");
}
#endif
943
#endif