cmd-edit.c 12.4 KB
Newer Older
1
/* vim: set sw=8: -*- Mode: C; tab-width: 8; indent-tabs-mode: t; c-basic-offset: 8 -*- */
Jody Goldberg's avatar
Jody Goldberg committed
2 3 4
/*
 * cmd-edit.c: Various commands to be used by the edit menu.
 *
Jody Goldberg's avatar
Jody Goldberg committed
5
 * Copyright (C) 2000 Jody Goldberg (jody@gnome.org)
Jody Goldberg's avatar
Jody Goldberg committed
6 7 8 9 10 11 12 13 14 15 16 17 18
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License as
 * published by the Free Software Foundation; either version 2 of the
 * License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
J.H.M. Dassen (Ray)'s avatar
J.H.M. Dassen (Ray) committed
19
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301
Jody Goldberg's avatar
Jody Goldberg committed
20 21
 * USA
 */
22
#include <gnumeric-config.h>
23
#include <glib/gi18n-lib.h>
24
#include "gnumeric.h"
Jody Goldberg's avatar
Jody Goldberg committed
25
#include "cmd-edit.h"
26

27
#include "application.h"
28 29
#include "command-context.h"
#include "workbook-control.h"
30
#include "workbook.h"
Jody Goldberg's avatar
Jody Goldberg committed
31
#include "sheet.h"
32
#include "sheet-view.h"
Jody Goldberg's avatar
Jody Goldberg committed
33 34
#include "cell.h"
#include "expr.h"
35
#include "expr-impl.h"
36
#include "dependent.h"
37
#include "selection.h"
Jody Goldberg's avatar
Jody Goldberg committed
38
#include "parse-util.h"
39 40 41
#include "ranges.h"
#include "commands.h"
#include "clipboard.h"
Morten Welinder's avatar
Morten Welinder committed
42
#include "value.h"
43
#include "wbc-gtk.h"
44

Jody Goldberg's avatar
Jody Goldberg committed
45
/**
46
 * sv_select_cur_row:
Jody Goldberg's avatar
Jody Goldberg committed
47
 * @sv: The sheet
Jody Goldberg's avatar
Jody Goldberg committed
48 49 50 51
 *
 * Selects an entire row
 */
void
52
sv_select_cur_row (SheetView *sv)
Jody Goldberg's avatar
Jody Goldberg committed
53
{
Jody Goldberg's avatar
Jody Goldberg committed
54
	GnmRange const *sel = selection_first_range (sv,  NULL, NULL);
Jody Goldberg's avatar
Jody Goldberg committed
55
	if (sel != NULL) {
Jody Goldberg's avatar
Jody Goldberg committed
56
		GnmRange r = *sel;
Jody Goldberg's avatar
Jody Goldberg committed
57
		sv_selection_reset (sv);
58 59 60 61 62
		sv_selection_add_full 
			(sv,
			 sv->edit_pos.col, sv->edit_pos.row,
			 0, r.start.row, gnm_sheet_get_last_col (sv->sheet), r.end.row, 
			 GNM_SELECTION_MODE_ADD);
Jody Goldberg's avatar
Jody Goldberg committed
63
		sheet_update (sv->sheet);
Jody Goldberg's avatar
Jody Goldberg committed
64
	}
Jody Goldberg's avatar
Jody Goldberg committed
65 66 67
}

/**
68
 * sv_select_cur_col:
Jody Goldberg's avatar
Jody Goldberg committed
69
 * @sv: The sheet
Jody Goldberg's avatar
Jody Goldberg committed
70 71 72 73
 *
 * Selects an entire column
 */
void
74
sv_select_cur_col (SheetView *sv)
Jody Goldberg's avatar
Jody Goldberg committed
75
{
Jody Goldberg's avatar
Jody Goldberg committed
76
	GnmRange const *sel = selection_first_range (sv,  NULL, NULL);
Jody Goldberg's avatar
Jody Goldberg committed
77
	if (sel != NULL) {
Jody Goldberg's avatar
Jody Goldberg committed
78
		GnmRange r = *sel;
Jody Goldberg's avatar
Jody Goldberg committed
79
		sv_selection_reset (sv);
80 81 82 83 84
		sv_selection_add_full 
			(sv,
			 sv->edit_pos.col, sv->edit_pos.row,
			 r.start.col, 0, r.end.col, gnm_sheet_get_last_row (sv->sheet), 
			 GNM_SELECTION_MODE_ADD);
Jody Goldberg's avatar
Jody Goldberg committed
85
		sheet_update (sv->sheet);
Jody Goldberg's avatar
Jody Goldberg committed
86
	}
Jody Goldberg's avatar
Jody Goldberg committed
87 88 89
}

/**
90
 * sv_select_cur_array :
Jody Goldberg's avatar
Jody Goldberg committed
91
 * @sv: The sheet
Jody Goldberg's avatar
Jody Goldberg committed
92
 *
93 94
 * If the editpos is part of an array clear the selection and select the array.
 **/
Jody Goldberg's avatar
Jody Goldberg committed
95
void
96
sv_select_cur_array (SheetView *sv)
Jody Goldberg's avatar
Jody Goldberg committed
97
{
98 99 100
	GnmRange a;
	int const c = sv->edit_pos.col;
	int const r = sv->edit_pos.row;
Jody Goldberg's avatar
Jody Goldberg committed
101

102
	if (!gnm_cell_array_bound (sheet_cell_get (sv->sheet, c, r), &a))
Jody Goldberg's avatar
Jody Goldberg committed
103 104
		return;

105
	/* leave the edit pos where it is, select the entire array. */
Jody Goldberg's avatar
Jody Goldberg committed
106
	sv_selection_reset (sv);
107
	sv_selection_add_full (sv, c, r,
108 109
			       a.start.col, a.start.row, a.end.col, a.end.row, 
			       GNM_SELECTION_MODE_ADD);
Jody Goldberg's avatar
Jody Goldberg committed
110
	sheet_update (sv->sheet);
Jody Goldberg's avatar
Jody Goldberg committed
111 112 113 114 115
}

static gint
cb_compare_deps (gconstpointer a, gconstpointer b)
{
116 117
	GnmCell const *cell_a = a;
	GnmCell const *cell_b = b;
Jody Goldberg's avatar
Jody Goldberg committed
118 119
	int tmp;

120 121 122
	if (cell_a->base.sheet != cell_b->base.sheet)
		return cell_a->base.sheet->index_in_wb - cell_b->base.sheet->index_in_wb;

123
	tmp = cell_a->pos.row - cell_b->pos.row;
Jody Goldberg's avatar
Jody Goldberg committed
124 125
	if (tmp != 0)
		return tmp;
126
	return cell_a->pos.col - cell_b->pos.col;
Jody Goldberg's avatar
Jody Goldberg committed
127 128
}

Jody Goldberg's avatar
Jody Goldberg committed
129
static void
130
cb_collect_deps (GnmDependent *dep, gpointer user)
Jody Goldberg's avatar
Jody Goldberg committed
131
{
132
	if (dependent_is_cell (dep)) {
Jody Goldberg's avatar
Jody Goldberg committed
133 134 135 136 137
		GList **list = (GList **)user;
		*list = g_list_prepend (*list, dep);
	}
}

Jody Goldberg's avatar
Jody Goldberg committed
138
/**
139
 * sv_select_cur_depends :
Jody Goldberg's avatar
Jody Goldberg committed
140
 * @sv: The sheet
Jody Goldberg's avatar
Jody Goldberg committed
141 142 143 144
 *
 * Select all cells that depend on the expression in the current cell.
 */
void
145
sv_select_cur_depends (SheetView *sv)
Jody Goldberg's avatar
Jody Goldberg committed
146
{
147
	GnmCell  *cur_cell, dummy;
Jody Goldberg's avatar
Jody Goldberg committed
148
	GList *deps = NULL, *ptr = NULL;
Jody Goldberg's avatar
Jody Goldberg committed
149

Jody Goldberg's avatar
Jody Goldberg committed
150
	g_return_if_fail (IS_SHEET_VIEW (sv));
Jody Goldberg's avatar
Jody Goldberg committed
151

Jody Goldberg's avatar
Jody Goldberg committed
152
	cur_cell = sheet_cell_get (sv->sheet,
153 154 155 156 157 158
		sv->edit_pos.col, sv->edit_pos.row);
	if (cur_cell == NULL) {
		dummy.base.sheet = sv_sheet (sv);
		dummy.pos = sv->edit_pos;
		cur_cell = &dummy;
	}
Jody Goldberg's avatar
Jody Goldberg committed
159

Jody Goldberg's avatar
Jody Goldberg committed
160
	cell_foreach_dep (cur_cell, cb_collect_deps, &deps);
Jody Goldberg's avatar
Jody Goldberg committed
161 162 163
	if (deps == NULL)
		return;

Jody Goldberg's avatar
Jody Goldberg committed
164
	sv_selection_reset (sv);
Jody Goldberg's avatar
Jody Goldberg committed
165 166 167

	/* Short circuit */
	if (g_list_length (deps) == 1) {
168
		GnmCell *cell = deps->data;
169 170
		sv_selection_add_pos (sv, cell->pos.col, cell->pos.row, 
				      GNM_SELECTION_MODE_ADD);
Jody Goldberg's avatar
Jody Goldberg committed
171
	} else {
Jody Goldberg's avatar
Jody Goldberg committed
172
		GnmRange *cur = NULL;
Jody Goldberg's avatar
Jody Goldberg committed
173 174 175 176
		ptr = NULL;

		/* Merge the sorted list of cells into rows */
		for (deps = g_list_sort (deps, &cb_compare_deps) ; deps ; ) {
177
			GnmCell *cell = deps->data;
Jody Goldberg's avatar
Jody Goldberg committed
178 179

			if (cur == NULL ||
180 181
			    cur->end.row != cell->pos.row ||
			    cur->end.col+1 != cell->pos.col) {
Jody Goldberg's avatar
Jody Goldberg committed
182 183
				if (cur)
					ptr = g_list_prepend (ptr, cur);
Jody Goldberg's avatar
Jody Goldberg committed
184
				cur = g_new (GnmRange, 1);
185 186
				cur->start.row = cur->end.row = cell->pos.row;
				cur->start.col = cur->end.col = cell->pos.col;
Jody Goldberg's avatar
Jody Goldberg committed
187
			} else
188
				cur->end.col = cell->pos.col;
Jody Goldberg's avatar
Jody Goldberg committed
189 190 191 192 193 194 195 196 197

			deps = g_list_remove (deps, cell);
		}
		if (cur)
			ptr = g_list_prepend (ptr, cur);

		/* Merge the coalesced rows into ranges */
		deps = ptr;
		for (ptr = NULL ; deps ; ) {
Jody Goldberg's avatar
Jody Goldberg committed
198
			GnmRange *r1 = deps->data;
Jody Goldberg's avatar
Jody Goldberg committed
199 200 201
			GList *fwd;

			for (fwd = deps->next ; fwd ; ) {
Jody Goldberg's avatar
Jody Goldberg committed
202
				GnmRange *r2 = fwd->data;
Jody Goldberg's avatar
Jody Goldberg committed
203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219

				if (r1->start.col == r2->start.col &&
				    r1->end.col == r2->end.col &&
				    r1->start.row-1 == r2->end.row) {
					r1->start.row = r2->start.row;
					g_free (fwd->data);
					fwd = g_list_remove (fwd, r2);
				} else
					fwd = fwd->next;
			}

			ptr = g_list_prepend (ptr, r1);
			deps = g_list_remove (deps, r1);
		}

		/* now select the ranges */
		while (ptr) {
220
			sv_selection_add_range (sv, ptr->data);
Jody Goldberg's avatar
Jody Goldberg committed
221
			g_free (ptr->data);
222
			ptr = g_list_remove (ptr, ptr->data);
Jody Goldberg's avatar
Jody Goldberg committed
223 224
		}
	}
Jody Goldberg's avatar
Jody Goldberg committed
225
	sheet_update (sv->sheet);
Jody Goldberg's avatar
Jody Goldberg committed
226 227 228
}

/**
229
 * sv_select_cur_inputs :
Jody Goldberg's avatar
Jody Goldberg committed
230
 * @sv: The sheet
Jody Goldberg's avatar
Jody Goldberg committed
231 232 233
 *
 * Select all cells that are direct potential inputs to the
 * current cell.
234
 **/
Jody Goldberg's avatar
Jody Goldberg committed
235
void
236
sv_select_cur_inputs (SheetView *sv)
Jody Goldberg's avatar
Jody Goldberg committed
237
{
238 239
	GnmCell  *cell;
	GSList   *ranges, *ptr;
Morten Welinder's avatar
Morten Welinder committed
240
	GnmEvalPos ep;
Jody Goldberg's avatar
Jody Goldberg committed
241

Jody Goldberg's avatar
Jody Goldberg committed
242
	g_return_if_fail (IS_SHEET_VIEW (sv));
Jody Goldberg's avatar
Jody Goldberg committed
243

Jody Goldberg's avatar
Jody Goldberg committed
244
	cell = sheet_cell_get (sv->sheet,
245
		sv->edit_pos.col, sv->edit_pos.row);
246
	if (cell == NULL || !gnm_cell_has_expr (cell))
Jody Goldberg's avatar
Jody Goldberg committed
247
		return;
248
	ranges = gnm_expr_top_get_ranges (cell->base.texpr);
249 250 251
	if (ranges == NULL)
		return;

Morten Welinder's avatar
Morten Welinder committed
252 253 254 255
	ep.eval = sv->edit_pos;
	ep.sheet = sv->sheet;
	ep.dep = NULL;

256
	sv_selection_reset (sv);
Morten Welinder's avatar
Morten Welinder committed
257 258 259 260 261
	for (ptr = ranges ; ptr != NULL ; ptr = ptr->next) {
		GnmValue *v = ptr->data;
		GnmRangeRef const *r = value_get_rangeref (v);

#warning "FIXME: What do we do in these 3D cases?"
262 263 264 265 266 267 268 269 270 271 272
		if ((r->a.sheet == r->b.sheet) && 
		    (r->a.sheet == NULL || r->a.sheet == sv->sheet)) {
		      gint row, col;
		      row = gnm_cellref_get_row (&r->a, &ep);
		      col = gnm_cellref_get_col (&r->a, &ep);
		      sv_selection_add_full 
			      (sv, col, row, col, row,
			       gnm_cellref_get_col (&r->b, &ep),
			       gnm_cellref_get_row (&r->b, &ep), 
			       GNM_SELECTION_MODE_ADD);
		    }
Morten Welinder's avatar
Morten Welinder committed
273 274
		value_release (v);
	}
275
	g_slist_free (ranges);
Jody Goldberg's avatar
Jody Goldberg committed
276

Jody Goldberg's avatar
Jody Goldberg committed
277
	sheet_update (sv->sheet);
Jody Goldberg's avatar
Jody Goldberg committed
278
}
279 280 281 282 283 284 285 286 287 288 289 290 291 292 293

/**
 * cmd_paste :
 * @sheet: The destination sheet
 * @range : The range to paste to within the destination sheet.
 * @flags: Any paste special flags.
 *
 * Pastes the current cut buffer, copy buffer, or X selection to
 * the destination sheet range.
 *
 * When pasting a cut the destination MUST be the same size as the src.
 *
 * When pasting a copy the destination can be a singleton, or an integer
 * multiple of the size of the source.  This is not tested here.
 * Full undo support.
294
 **/
295
void
Morten Welinder's avatar
Morten Welinder committed
296
cmd_paste (WorkbookControl *wbc, GnmPasteTarget const *pt)
297
{
Morten Welinder's avatar
Morten Welinder committed
298
	GnmCellRegion  *content;
Jody Goldberg's avatar
Jody Goldberg committed
299
	GnmRange const *src_range;
300

301
	g_return_if_fail (pt != NULL);
302 303
	g_return_if_fail (IS_SHEET (pt->sheet));

Jody Goldberg's avatar
Jody Goldberg committed
304 305
	src_range = gnm_app_clipboard_area_get ();
	content = gnm_app_clipboard_contents_get ();
306 307 308

	if (content == NULL && src_range != NULL) {
		/* Pasting a Cut */
309
		GnmExprRelocateInfo rinfo;
Jody Goldberg's avatar
Jody Goldberg committed
310
		Sheet *src_sheet = gnm_app_clipboard_sheet_get ();
311 312 313

		/* Validate the size & shape of the target here. */
		int const cols = (src_range->end.col - src_range->start.col);
314
		int const rows = (src_range->end.row - src_range->start.row);
315

Jody Goldberg's avatar
Jody Goldberg committed
316
		GnmRange dst = pt->range;
317 318 319 320 321 322 323

		if (range_is_singleton (&dst)) {
			dst.end.col = dst.start.col + cols;
			dst.end.row = dst.start.row + rows;
		} else if ((dst.end.col - dst.start.col) != cols ||
			   (dst.end.row - dst.start.row) != rows) {

Miguel de Icaza's avatar
Miguel de Icaza committed
324
			char *msg = g_strdup_printf (
325 326 327 328 329
				_("destination has a different shape (%dRx%dC) than the original (%dRx%dC)\n\n"
				  "Try selecting a single cell or an area of the same shape and size."),
				(dst.end.row - dst.start.row)+1,
				(dst.end.col - dst.start.col)+1,
				rows+1, cols+1);
330
			go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc),
331
				_("Unable to paste into selection"), msg);
332 333 334 335
			g_free (msg);
			return;
		}

336
		rinfo.reloc_type = GNM_EXPR_RELOCATE_MOVE_RANGE;
337 338 339 340 341 342
		rinfo.origin = *src_range;
		rinfo.col_offset = dst.start.col - rinfo.origin.start.col;
		rinfo.row_offset = dst.start.row - rinfo.origin.start.row;
		rinfo.origin_sheet = src_sheet;
		rinfo.target_sheet = pt->sheet;

343
		if (!cmd_paste_cut (wbc, &rinfo, TRUE, NULL))
Jody Goldberg's avatar
Jody Goldberg committed
344
			gnm_app_clipboard_clear (TRUE);
345 346

	/* If this application has marked a selection use it */
347
	} else if (content != NULL) {
348
		cmd_paste_copy (wbc, pt, content);
349 350 351
		/* We don't own the contents, so don't unref it.  */
	} else {
		/* See if the control has access to information to paste */
352
		wb_control_paste_from_selection (wbc, pt);
353
	}
354 355 356 357
}

/**
 * cmd_paste_to_selection :
Jody Goldberg's avatar
Jody Goldberg committed
358
 * @dest_sv: The sheet into which things should be pasted
359 360 361 362 363 364
 * @flags: special paste flags (eg transpose)
 *
 * Using the current selection as a target
 * Full undo support.
 */
void
Jody Goldberg's avatar
Jody Goldberg committed
365
cmd_paste_to_selection (WorkbookControl *wbc, SheetView *dest_sv, int paste_flags)
366
{
Jody Goldberg's avatar
Jody Goldberg committed
367
	GnmRange const *r;
Morten Welinder's avatar
Morten Welinder committed
368
	GnmPasteTarget pt;
369

370 371
	r = selection_first_range (dest_sv, GO_CMD_CONTEXT (wbc), _("Paste"));
	if (!r)
372 373
		return;

Jody Goldberg's avatar
Jody Goldberg committed
374
	pt.sheet = dest_sv->sheet;
375
	pt.range = *r;
376
	pt.paste_flags = paste_flags;
377
	cmd_paste (wbc, &pt);
378
}
379 380 381

/**
 * cmd_shift_rows:
382
 * @wbc :	The error context.
383 384 385 386 387 388 389 390 391 392
 * @sheet	the sheet
 * @col		column marking the start of the shift
 * @start_row	first row
 * @end_row	end row
 * @count	numbers of columns to shift.  negative numbers will
 *		delete count columns, positive number will insert
 *		count columns.
 *
 * Takes the cells in the region (col,start_row):(MAX_COL,end_row)
 * and copies them @count units (possibly negative) to the right.
393
 **/
394
void
395
cmd_shift_rows (WorkbookControl *wbc, Sheet *sheet,
396 397
		int col, int start_row, int end_row, int count)
{
398
	GnmExprRelocateInfo rinfo;
399
	char *desc;
400

401
	rinfo.reloc_type = GNM_EXPR_RELOCATE_MOVE_RANGE;
402 403 404 405 406 407
	rinfo.col_offset = count;
	rinfo.row_offset = 0;
	rinfo.origin_sheet = rinfo.target_sheet = sheet;
	rinfo.origin.start.row = start_row;
	rinfo.origin.start.col = col;
	rinfo.origin.end.row = end_row;
408
	rinfo.origin.end.col = gnm_sheet_get_last_col (sheet);
409 410 411 412 413 414 415


	if (count > 0) {
		GnmRange r = rinfo.origin;
		r.start.col = r.end.col - count + 1;

		if (!sheet_is_region_empty (sheet, &r)) {
Morten Welinder's avatar
Morten Welinder committed
416
			go_gtk_notice_dialog (wbcg_toplevel (WBC_GTK (wbc)), GTK_MESSAGE_ERROR,
417 418 419
					      _("Inserting these cells would push data off the sheet. "
						"Please enlarge the sheet first."));
			return;
Morten Welinder's avatar
Morten Welinder committed
420
		}
Jody Goldberg's avatar
typo.  
Jody Goldberg committed
421
		rinfo.origin.end.col -= count;
422
	}
423

424 425 426 427
	desc = g_strdup_printf ((start_row != end_row)
				? _("Shift rows %s")
				: _("Shift row %s"),
				rows_name (start_row, end_row));
428
	cmd_paste_cut (wbc, &rinfo, FALSE, desc);
429 430 431 432
}

/**
 * cmd_shift_cols:
433
 * @wbc:	The error context.
434 435 436 437 438
 * @sheet:	the sheet
 * @start_col:	first column
 * @end_col:	end column
 * @row:	row marking the start of the shift
 * @count:	numbers of rows to shift.  a negative numbers will
439 440 441 442 443 444 445
 *		delete count rows, positive number will insert
 *		count rows.
 *
 * Takes the cells in the region (start_col,row):(end_col,MAX_ROW)
 * and copies them @count units (possibly negative) downwards.
 */
void
446
cmd_shift_cols (WorkbookControl *wbc, Sheet *sheet,
447 448
		int start_col, int end_col, int row, int count)
{
449
	GnmExprRelocateInfo rinfo;
450
	char *desc;
451

452
	rinfo.reloc_type = GNM_EXPR_RELOCATE_MOVE_RANGE;
453 454 455 456 457 458
	rinfo.col_offset = 0;
	rinfo.row_offset = count;
	rinfo.origin_sheet = rinfo.target_sheet = sheet;
	rinfo.origin.start.col = start_col;
	rinfo.origin.start.row = row;
	rinfo.origin.end.col = end_col;
459
	rinfo.origin.end.row = gnm_sheet_get_last_row (sheet);
460 461 462 463 464
	if (count > 0) {
		GnmRange r = rinfo.origin;
		r.start.row = r.end.row - count + 1;

		if (!sheet_is_region_empty (sheet, &r)) {
Morten Welinder's avatar
Morten Welinder committed
465
			go_gtk_notice_dialog (wbcg_toplevel (WBC_GTK (wbc)), GTK_MESSAGE_ERROR,
466 467 468
					      _("Inserting these cells would push data off the sheet. "
						"Please enlarge the sheet first."));
			return;
Morten Welinder's avatar
Morten Welinder committed
469
		}
Jody Goldberg's avatar
typo.  
Jody Goldberg committed
470
		rinfo.origin.end.row -= count;
471
	}
472

473 474 475 476
	desc = g_strdup_printf ((start_col != end_col)
				? _("Shift columns %s")
				: _("Shift column %s"),
				cols_name (start_col, end_col));
477
	cmd_paste_cut (wbc, &rinfo, FALSE, desc);
478
}