3 * commands.c: Handlers to undo & redo commands
5 * Copyright (C) 1999-2008 Jody Goldberg (jody@gnome.org)
6 * Copyright (C) 2002-2008 Morten Welinder (terra@gnome.org)
8 * Contributors : Almer S. Tigelaar (almer@gnome.org)
9 * Andreas J. Guelzow (aguelzow@taliesin.ca)
11 * This program is free software; you can redistribute it and/or
12 * modify it under the terms of the GNU General Public License as
13 * published by the Free Software Foundation; either version 2 of the
14 * License, or (at your option) version 3.
16 * This program is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 * GNU General Public License for more details.
21 * You should have received a copy of the GNU General Public License
22 * along with this program; if not, write to the Free Software
23 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
26 #include <gnumeric-config.h>
27 #include <glib/gi18n-lib.h>
30 #include <gnm-command-impl.h>
32 #include <application.h>
34 #include <sheet-view.h>
35 #include <sheet-style.h>
36 #include <gnm-format.h>
37 #include <format-template.h>
38 #include <command-context.h>
39 #include <workbook-control.h>
40 #include <workbook-view.h>
41 #include <workbook-priv.h> /* For the undo/redo queues and the FOREACH */
44 #include <dependent.h>
48 #include <expr-name.h>
50 #include <sheet-merge.h>
51 #include <parse-util.h>
52 #include <print-info.h>
53 #include <clipboard.h>
54 #include <selection.h>
56 #include <style-border.h>
57 #include <tools/auto-correct.h>
58 #include <sheet-autofill.h>
63 #include <sheet-object-cell-comment.h>
64 #include <sheet-object-widget.h>
65 #include <sheet-object.h>
66 #include <sheet-object-component.h>
67 #include <sheet-object-graph.h>
68 #include <sheet-control.h>
69 #include <sheet-control-gui.h>
70 #include <sheet-utils.h>
71 #include <style-color.h>
72 #include <sheet-filter.h>
73 #include <auto-format.h>
74 #include <tools/dao.h>
75 #include <gnumeric-conf.h>
76 #include <tools/scenarios.h>
77 #include <tools/data-shuffling.h>
78 #include <tools/tabulate.h>
82 #include <goffice/goffice.h>
83 #include <gsf/gsf-doc-meta-data.h>
86 #define UNICODE_ELLIPSIS "\xe2\x80\xa6"
90 * There are several distinct stages to wrapping each command.
92 * 1) Find the appropriate place(s) in the catch all calls to activations
93 * of this logical function. Be careful. This should only be called by
94 * user initiated actions, not internal commands.
96 * 2) Copy the boiler plate code into place and implement the descriptor.
98 * 3) Implement the guts of the support functions.
100 * That way undo redo just become applications of the old or the new styles.
103 * 1) redo : this should be renamed 'exec' and should be the place that the
104 * the actual command executes. This avoid duplicating the code for
105 * application and re-application.
107 * 2) The command objects are responsible for generating recalc and redraw
108 * events. None of the internal utility routines should do so. Those are
109 * expensive events and should only be done once per command to avoid
110 * duplicating work. The lower levels can queue redraws if they must, and
111 * flag state changes but the call to gnm_app_recalc and sheet_update is
114 * FIXME: Filter the list of commands when a sheet is deleted.
116 * TODO : Possibly clear lists on save.
118 * TODO : Reqs for selective undo
121 * - undoable preference setting ? XL does not have this. Do we want it ?
123 /******************************************************************/
125 #define GNM_COMMAND(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), GNM_COMMAND_TYPE, GnmCommand))
126 #define GNM_COMMAND_CLASS(k) (G_TYPE_CHECK_CLASS_CAST ((k), GNM_COMMAND_TYPE, GnmCommandClass))
127 #define GNM_IS_COMMAND(o) (G_TYPE_CHECK_INSTANCE_TYPE ((o), GNM_COMMAND_TYPE))
128 #define CMD_CLASS(o) GNM_COMMAND_CLASS (G_OBJECT_GET_CLASS(cmd))
130 GSF_CLASS (GnmCommand
, gnm_command
, NULL
, NULL
, G_TYPE_OBJECT
)
133 gnm_command_finalize (GObject
*obj
)
135 GnmCommand
*cmd
= GNM_COMMAND (obj
);
136 GObjectClass
*parent
;
138 /* The const was to avoid accidental changes elsewhere */
139 g_free ((gchar
*)cmd
->cmd_descriptor
);
140 cmd
->cmd_descriptor
= NULL
;
142 parent
= g_type_class_peek (g_type_parent(G_TYPE_FROM_INSTANCE (obj
)));
143 (*parent
->finalize
) (obj
);
146 /******************************************************************/
149 gnm_cmd_trunc_descriptor (GString
*src
, gboolean
*truncated
)
151 int max_len
= gnm_conf_get_undo_max_descriptor_width ();
158 while ((pos
= strchr(src
->str
, '\n')) != NULL
||
159 (pos
= strchr(src
->str
, '\r')) != NULL
)
162 len
= g_utf8_strlen (src
->str
, -1);
165 *truncated
= (len
> max_len
);
168 gchar
* last
= g_utf8_offset_to_pointer (src
->str
,
170 g_string_truncate (src
, last
- src
->str
);
171 g_string_append (src
, UNICODE_ELLIPSIS
);
178 * cmd_cell_range_is_locked_effective:
181 * @wbc: #WorkbookControl
182 * @cmd_name: the command name.
184 * checks whether the cells are effectively locked
186 * static gboolean cmd_cell_range_is_locked_effective
189 * Do not use this function unless the sheet is part of the
190 * workbook with the given wbc (otherwise the results may be strange)
192 * Returns: %TRUE if there was a problem, %FALSE otherwise.
195 cmd_cell_range_is_locked_effective (Sheet
*sheet
, GnmRange
*range
,
196 WorkbookControl
*wbc
, char const *cmd_name
)
199 WorkbookView
*wbv
= wb_control_view (wbc
);
201 if (wbv
->is_protected
|| sheet
->is_protected
)
202 for (i
= range
->start
.row
; i
<= range
->end
.row
; i
++)
203 for (j
= range
->start
.col
; j
<= range
->end
.col
; j
++)
204 if (gnm_style_get_contents_locked (sheet_style_get (sheet
, j
, i
))) {
205 char *r
= global_range_name (sheet
, range
);
206 char *text
= g_strdup_printf (wbv
->is_protected
?
207 _("%s is locked. Unprotect the workbook to enable editing.") :
208 _("%s is locked. Unprotect the sheet to enable editing."),
210 go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc
),
220 * checks whether the cells are effectively locked
222 * static gboolean cmd_dao_is_locked_effective
225 * Do not use this function unless the sheet is part of the
226 * workbook with the given wbcg (otherwise the results may be strange)
228 * Returns: %TRUE if there was a problem, %FALSE otherwise.
231 cmd_dao_is_locked_effective (data_analysis_output_t
*dao
,
232 WorkbookControl
*wbc
, char const *cmd_name
)
235 range_init (&range
, dao
->start_col
, dao
->start_row
,
236 dao
->start_col
+ dao
->cols
- 1, dao
->start_row
+ dao
->rows
- 1);
237 return (dao
->type
!= NewWorkbookOutput
&&
238 cmd_cell_range_is_locked_effective (dao
->sheet
, &range
, wbc
, cmd_name
));
242 * cmd_selection_is_locked_effective: (skip)
243 * checks whether the selection is effectively locked
245 * static gboolean cmd_selection_is_locked_effective
247 * Do not use this function unless the sheet is part of the
248 * workbook with the given wbcg (otherwise the results may be strange)
250 * Returns: %TRUE if there was a problem, %FALSE otherwise.
253 cmd_selection_is_locked_effective (Sheet
*sheet
, GSList
*selection
,
254 WorkbookControl
*wbc
, char const *cmd_name
)
256 for (; selection
; selection
= selection
->next
) {
257 GnmRange
*range
= selection
->data
;
258 if (cmd_cell_range_is_locked_effective (sheet
, range
, wbc
, cmd_name
))
265 * A helper routine to select a range and make sure the top-left
269 select_range (Sheet
*sheet
, const GnmRange
*r
, WorkbookControl
*wbc
)
273 if (sheet
->workbook
!= wb_control_get_workbook (wbc
)) {
275 * We could try to pick a random wbc for the sheet's
276 * workbook. But not right now.
281 wb_control_sheet_focus (wbc
, sheet
);
282 sv
= sheet_get_view (sheet
, wb_control_view (wbc
));
283 sv_selection_reset (sv
);
284 sv_selection_add_range (sv
, r
);
285 gnm_sheet_view_make_cell_visible (sv
, r
->start
.col
, r
->start
.row
, FALSE
);
289 * A helper routine to select a list of ranges and make sure the top-left
290 * corner of the last is visible.
293 select_selection (Sheet
*sheet
, GSList
*selection
, WorkbookControl
*wbc
)
295 SheetView
*sv
= sheet_get_view (sheet
, wb_control_view (wbc
));
296 const GnmRange
*r0
= NULL
;
299 g_return_if_fail (selection
!= NULL
);
301 wb_control_sheet_focus (wbc
, sheet
);
302 sv_selection_reset (sv
);
303 for (l
= selection
; l
; l
= l
->next
) {
304 GnmRange
const *r
= l
->data
;
305 sv_selection_add_range (sv
, r
);
308 gnm_sheet_view_make_cell_visible (sv
, r0
->start
.col
, r0
->start
.row
, FALSE
);
313 * with a list of commands.
314 * @cmd_list: The command list to check.
316 * Utility routine to get the descriptor associated
317 * Returns : A static reference to a descriptor. DO NOT free this.
320 get_menu_label (GSList
*cmd_list
)
322 if (cmd_list
!= NULL
) {
323 GnmCommand
*cmd
= GNM_COMMAND (cmd_list
->data
);
324 return cmd
->cmd_descriptor
;
331 * undo_redo_menu_labels:
332 * @wb: The book whose undo/redo queues we are modifying
334 * Another utility to set the menus correctly.
337 undo_redo_menu_labels (Workbook
*wb
)
339 char const *undo_label
= get_menu_label (wb
->undo_commands
);
340 char const *redo_label
= get_menu_label (wb
->redo_commands
);
342 WORKBOOK_FOREACH_CONTROL (wb
, view
, control
,
343 wb_control_undo_redo_labels (control
, undo_label
, redo_label
);
348 update_after_action (Sheet
*sheet
, WorkbookControl
*wbc
)
353 g_return_if_fail (IS_SHEET (sheet
));
355 sheet_mark_dirty (sheet
);
356 sheet_update (sheet
);
358 if (sheet
->workbook
== wb_control_get_workbook (wbc
))
359 WORKBOOK_VIEW_FOREACH_CONTROL (wb_control_view (wbc
), control
,
360 wb_control_sheet_focus (control
, sheet
););
361 } else if (wbc
!= NULL
) {
362 Sheet
*sheet
= wb_control_cur_sheet (wbc
);
364 sheet_update (sheet
);
371 * @wbc: The workbook control which issued the request.
372 * Any user level errors generated by undoing will be reported
375 * Undo the last command executed.
378 command_undo (WorkbookControl
*wbc
)
381 GnmCommandClass
*klass
;
382 Workbook
*wb
= wb_control_get_workbook (wbc
);
384 g_return_if_fail (wb
!= NULL
);
385 g_return_if_fail (wb
->undo_commands
!= NULL
);
387 cmd
= GNM_COMMAND (wb
->undo_commands
->data
);
388 g_return_if_fail (cmd
!= NULL
);
390 klass
= CMD_CLASS (cmd
);
391 g_return_if_fail (klass
!= NULL
);
395 /* TRUE indicates a failure to undo. Leave the command where it is */
396 if (!klass
->undo_cmd (cmd
, wbc
)) {
397 gboolean undo_cleared
;
399 update_after_action (cmd
->sheet
, wbc
);
401 if (!cmd
->workbook_modified_before_do
)
402 go_doc_set_dirty (GO_DOC (wb
), FALSE
);
405 * A few commands clear the undo queue. For those, we do not
406 * want to stuff the cmd object on the redo queue.
408 undo_cleared
= (wb
->undo_commands
== NULL
);
411 wb
->undo_commands
= g_slist_remove (wb
->undo_commands
, cmd
);
412 wb
->redo_commands
= g_slist_prepend (wb
->redo_commands
, cmd
);
414 WORKBOOK_FOREACH_CONTROL (wb
, view
, control
, {
415 wb_control_undo_redo_pop (control
, TRUE
);
416 wb_control_undo_redo_push (control
, FALSE
, cmd
->cmd_descriptor
, cmd
);
418 undo_redo_menu_labels (wb
);
419 /* TODO : Should we mark the workbook as clean or pristine too */
423 g_object_unref (cmd
);
428 * @wbc: The workbook control which issued the request.
430 * Redo the last command that was undone.
431 * Any user level errors generated by redoing will be reported
435 command_redo (WorkbookControl
*wbc
)
438 GnmCommandClass
*klass
;
439 Workbook
*wb
= wb_control_get_workbook (wbc
);
441 g_return_if_fail (wb
);
442 g_return_if_fail (wb
->redo_commands
);
444 cmd
= GNM_COMMAND (wb
->redo_commands
->data
);
445 g_return_if_fail (cmd
!= NULL
);
447 klass
= CMD_CLASS (cmd
);
448 g_return_if_fail (klass
!= NULL
);
452 cmd
->workbook_modified_before_do
=
453 go_doc_is_dirty (wb_control_get_doc (wbc
));
455 /* TRUE indicates a failure to redo. Leave the command where it is */
456 if (!klass
->redo_cmd (cmd
, wbc
)) {
457 gboolean redo_cleared
;
459 update_after_action (cmd
->sheet
, wbc
);
462 * A few commands clear the undo queue. For those, we do not
463 * want to stuff the cmd object on the redo queue.
465 redo_cleared
= (wb
->redo_commands
== NULL
);
468 wb
->redo_commands
= g_slist_remove (wb
->redo_commands
, cmd
);
469 wb
->undo_commands
= g_slist_prepend (wb
->undo_commands
, cmd
);
471 WORKBOOK_FOREACH_CONTROL (wb
, view
, control
, {
472 wb_control_undo_redo_push (control
, TRUE
, cmd
->cmd_descriptor
, cmd
);
473 wb_control_undo_redo_pop (control
, FALSE
);
475 undo_redo_menu_labels (wb
);
479 g_object_unref (cmd
);
484 * @wbc: The workbook control which issued the request.
486 * Repeat the last command (if possible)
488 * Any user level errors generated by redoing will be reported
492 command_repeat (WorkbookControl
*wbc
)
495 GnmCommandClass
*klass
;
496 Workbook
*wb
= wb_control_get_workbook (wbc
);
498 g_return_if_fail (wb
);
499 g_return_if_fail (wb
->undo_commands
);
501 cmd
= GNM_COMMAND (wb
->undo_commands
->data
);
502 g_return_if_fail (cmd
!= NULL
);
504 klass
= CMD_CLASS (cmd
);
505 g_return_if_fail (klass
!= NULL
);
507 if (klass
->repeat_cmd
!= NULL
)
508 (*klass
->repeat_cmd
) (cmd
, wbc
);
512 * command_setup_combos:
515 * Initialize the combos to correspond to the current undo/redo state.
518 command_setup_combos (WorkbookControl
*wbc
)
520 char const *undo_label
= NULL
, *redo_label
= NULL
;
522 Workbook
*wb
= wb_control_get_workbook (wbc
);
524 g_return_if_fail (wb
);
526 wb_control_undo_redo_truncate (wbc
, 0, TRUE
);
527 tmp
= g_slist_reverse (wb
->undo_commands
);
528 for (ptr
= tmp
; ptr
!= NULL
; ptr
= ptr
->next
) {
529 undo_label
= get_menu_label (ptr
);
530 wb_control_undo_redo_push (wbc
, TRUE
, undo_label
, ptr
->data
);
532 if (g_slist_reverse (tmp
)) {} /* ignore, list is in undo_commands */
534 wb_control_undo_redo_truncate (wbc
, 0, FALSE
);
535 tmp
= g_slist_reverse (wb
->redo_commands
);
536 for (ptr
= tmp
; ptr
!= NULL
; ptr
= ptr
->next
) {
537 redo_label
= get_menu_label (ptr
);
538 wb_control_undo_redo_push (wbc
, FALSE
, redo_label
, ptr
->data
);
540 if (g_slist_reverse (tmp
)) {} /* ignore, list is in redo_commands */
542 /* update the menus too */
543 wb_control_undo_redo_labels (wbc
, undo_label
, redo_label
);
547 * command_list_release:
548 * @cmds: (element-type GObject): the set of commands to free.
550 * command_list_release : utility routine to free the resources associated
551 * with a list of commands.
553 * NOTE : remember to NULL the list when you are done.
556 command_list_release (GSList
*cmd_list
)
558 while (cmd_list
!= NULL
) {
559 GObject
*cmd
= G_OBJECT (cmd_list
->data
);
561 g_return_if_fail (cmd
!= NULL
);
563 g_object_unref (cmd
);
564 cmd_list
= g_slist_remove (cmd_list
, cmd_list
->data
);
569 * Each undo item has a certain size. The size of typing a value into
570 * a cell is the unit size. A large autoformat could have a size of
571 * hundreds or even thousands.
573 * We wish to have the same undo behaviour across platforms, so please
574 * don't use sizeof in computing the undo size.
577 #undef DEBUG_TRUNCATE_UNDO
580 * Truncate the undo list if it is too big.
582 * Returns -1 if no truncation was done, or else the number of elements
586 truncate_undo_info (Workbook
*wb
)
593 size_left
= gnm_conf_get_undo_size ();
594 max_num
= gnm_conf_get_undo_maxnum ();
596 #ifdef DEBUG_TRUNCATE_UNDO
597 g_printerr ("Undo sizes:");
600 for (l
= wb
->undo_commands
, prev
= NULL
, ok_count
= 0;
602 prev
= l
, l
= l
->next
, ok_count
++) {
604 GnmCommand
*cmd
= GNM_COMMAND (l
->data
);
605 int size
= cmd
->size
;
609 * We could g_assert, but that would cause data loss.
610 * Instead, just continue.
612 g_warning ("Faulty undo_size_func, please report.");
616 #ifdef DEBUG_TRUNCATE_UNDO
617 g_printerr (" %d", size
);
620 /* Keep at least one undo item. */
621 if (ok_count
>= max_num
|| (size
> size_left
&& ok_count
>= 1)) {
622 /* Current item is too big; truncate list here. */
623 command_list_release (l
);
627 wb
->undo_commands
= NULL
;
628 #ifdef DEBUG_TRUNCATE_UNDO
629 g_printerr ("[trunc]\n");
635 * In order to allow a series of useful small items behind
636 * a big item, leave at least 10% of current item's size.
638 min_leave
= size
/ 10;
639 size_left
= MAX (size_left
- size
, min_leave
);
642 #ifdef DEBUG_TRUNCATE_UNDO
650 * command_register_undo:
651 * @wbc: The workbook control that issued the command.
652 * @cmd: The new command to add.
654 * An internal utility to tack a new command
655 * onto the undo list.
658 command_register_undo (WorkbookControl
*wbc
, GObject
*obj
)
664 g_return_if_fail (wbc
!= NULL
);
665 wb
= wb_control_get_workbook (wbc
);
667 cmd
= GNM_COMMAND (obj
);
668 g_return_if_fail (cmd
!= NULL
);
670 command_list_release (wb
->redo_commands
);
671 wb
->redo_commands
= NULL
;
673 g_object_ref (obj
); /* keep a ref in case it gets truncated away */
674 wb
->undo_commands
= g_slist_prepend (wb
->undo_commands
, cmd
);
675 undo_trunc
= truncate_undo_info (wb
);
677 WORKBOOK_FOREACH_CONTROL (wb
, view
, control
, {
678 wb_control_undo_redo_push (control
, TRUE
, cmd
->cmd_descriptor
, cmd
);
680 wb_control_undo_redo_truncate (control
, undo_trunc
, TRUE
);
681 wb_control_undo_redo_truncate (control
, 0, FALSE
);
683 undo_redo_menu_labels (wb
);
684 g_object_unref (obj
);
689 * gnm_command_push_undo:
690 * @wbc: The workbook control that issued the command.
691 * @obj: The new command to add.
693 * An internal utility to tack a new command
694 * onto the undo list.
696 * Returns: %TRUE if there was a problem, %FALSE otherwise.
703 * the caller is expected to have ensured:
705 * 1) that no array is being split
706 * 2) that the range is not locked.
709 * We will free the selection but nothing else.
711 * Returns: %TRUE if there was a problem, %FALSE otherwise.
714 gnm_command_push_undo (WorkbookControl
*wbc
, GObject
*obj
)
718 GnmCommandClass
*klass
;
720 g_return_val_if_fail (wbc
!= NULL
, TRUE
);
722 cmd
= GNM_COMMAND (obj
);
723 cmd
->workbook_modified_before_do
=
724 go_doc_is_dirty (wb_control_get_doc (wbc
));
726 g_return_val_if_fail (cmd
!= NULL
, TRUE
);
728 klass
= CMD_CLASS (cmd
);
729 g_return_val_if_fail (klass
!= NULL
, TRUE
);
731 /* TRUE indicates a failure to do the command */
732 trouble
= klass
->redo_cmd (cmd
, wbc
);
733 update_after_action (cmd
->sheet
, wbc
);
736 command_register_undo (wbc
, obj
);
738 g_object_unref (obj
);
744 * command_undo_sheet_delete deletes the sheet without deleting the current cmd.
745 * returns true if is indeed deleted the sheet.
746 * Note: only call this for a sheet of your current workbook from the undo procedure
750 command_undo_sheet_delete (Sheet
* sheet
)
752 Workbook
*wb
= sheet
->workbook
;
754 g_return_val_if_fail (IS_SHEET (sheet
), FALSE
);
756 if (wb
->redo_commands
!= NULL
) {
757 command_list_release (wb
->redo_commands
);
758 wb
->redo_commands
= NULL
;
759 WORKBOOK_FOREACH_CONTROL (wb
, view
, ctl
,
760 wb_control_undo_redo_truncate (ctl
, 0, FALSE
););
761 undo_redo_menu_labels (wb
);
764 workbook_sheet_delete (sheet
);
769 /******************************************************************/
772 cmd_set_text_full_check_texpr (GnmCellIter
const *iter
, GnmExprTop
const *texpr
)
774 if (iter
->cell
== NULL
||
775 !gnm_expr_top_equal (iter
->cell
->base
.texpr
, texpr
))
776 return VALUE_TERMINATE
;
781 cmd_set_text_full_check_text (GnmCellIter
const *iter
, char *text
)
785 gboolean quoted
= FALSE
;
787 if (gnm_cell_is_blank (iter
->cell
))
788 return ((text
== NULL
|| text
[0] == '\0') ? NULL
: VALUE_TERMINATE
);
790 if (text
== NULL
|| text
[0] == '\0')
791 return VALUE_TERMINATE
;
793 old_text
= gnm_cell_get_text_for_editing (iter
->cell
, NULL
, "ed
);
794 same
= g_strcmp0 (old_text
, text
) == 0;
796 if (!same
&& !quoted
&& iter
->cell
->value
&& VALUE_IS_STRING (iter
->cell
->value
)
798 same
= g_strcmp0 (old_text
, text
+ 1) == 0;
802 return (same
? NULL
: VALUE_TERMINATE
);
806 cmd_set_text_full_check_markup (GnmCellIter
const *iter
, PangoAttrList
*markup
)
808 PangoAttrList
const *old_markup
= NULL
;
809 gboolean same_markup
;
811 g_return_val_if_fail (iter
->cell
!= NULL
, NULL
);
813 if (iter
->cell
->value
&& VALUE_IS_STRING (iter
->cell
->value
)) {
814 const GOFormat
*fmt
= VALUE_FMT (iter
->cell
->value
);
815 if (fmt
&& go_format_is_markup (fmt
)) {
816 old_markup
= go_format_get_markup (fmt
);
817 if (go_pango_attr_list_is_empty (old_markup
))
822 same_markup
= gnm_pango_attr_list_equal (old_markup
, markup
);
824 return same_markup
? NULL
: VALUE_TERMINATE
;
830 * the caller is expected to have ensured:
832 * 1) that no array is being split
833 * 2) that the range is not locked.
836 * We will free the selection but nothing else.
838 * Returns: %TRUE if there was a problem, %FALSE otherwise.
841 cmd_set_text_full (WorkbookControl
*wbc
, GSList
*selection
, GnmEvalPos
*ep
,
842 char const *new_text
, PangoAttrList
*markup
,
843 gboolean autocorrect
)
846 char const *expr_txt
;
847 GnmExprTop
const *texpr
= NULL
;
850 gboolean result
, autofit_col
= FALSE
, same_text_and_not_same_markup
= FALSE
;
853 Sheet
*sheet
= ep
->sheet
;
855 ColRowIndexList
*cri_col_list
= NULL
, *cri_row_list
= NULL
;
856 GOFormat
const *format
= gnm_style_get_format
857 (sheet_style_get (sheet
, ep
->eval
.col
, ep
->eval
.row
));
859 g_return_val_if_fail (selection
!= NULL
, TRUE
);
861 parse_pos_init_evalpos (&pp
, ep
);
862 name
= undo_range_list_name (sheet
, selection
);
864 if ((format
== NULL
) || !go_format_is_text (format
)) {
865 expr_txt
= gnm_expr_char_start_p (new_text
);
866 if (expr_txt
!= NULL
)
867 texpr
= gnm_expr_parse_str
868 (expr_txt
, &pp
, GNM_EXPR_PARSE_DEFAULT
,
869 sheet_get_conventions (sheet
), NULL
);
874 GnmStyle
*new_style
= NULL
;
875 gboolean same_texpr
= TRUE
;
877 /* We should check whether we are in fact changing anything: */
878 for (l
= selection
; l
!= NULL
&& same_texpr
; l
= l
->next
) {
879 GnmRange
*r
= l
->data
;
881 sheet_foreach_cell_in_range
882 (sheet
, CELL_ITER_ALL
, r
,
883 (CellIterFunc
) cmd_set_text_full_check_texpr
,
886 same_texpr
= (val
!= VALUE_TERMINATE
);
887 if (val
!= NULL
&& same_texpr
)
892 gnm_expr_top_unref (texpr
);
894 range_fragment_free (selection
);
898 text
= g_strdup_printf (_("Inserting expression in %s"), name
);
900 if (go_format_is_general (format
)) {
901 sf
= gnm_auto_style_format_suggest (texpr
, ep
);
903 new_style
= gnm_style_new ();
904 gnm_style_set_format (new_style
, sf
);
905 go_format_unref (sf
);
909 for (l
= selection
; l
!= NULL
; l
= l
->next
) {
911 undo
= go_undo_combine
912 (undo
, clipboard_copy_range_undo (sheet
, l
->data
));
913 sr
= gnm_sheet_range_new (sheet
, l
->data
);
914 redo
= go_undo_combine
915 (redo
, sheet_range_set_expr_undo (sr
, texpr
));
917 sr
= gnm_sheet_range_new (sheet
, l
->data
);
918 redo
= go_undo_combine
919 (redo
, sheet_apply_style_undo (sr
, new_style
));
923 gnm_style_unref (new_style
);
924 gnm_expr_top_unref (texpr
);
928 PangoAttrList
*adj_markup
= NULL
;
930 gboolean same_text
= TRUE
;
931 gboolean same_markup
= TRUE
;
933 if (new_text
== NULL
)
935 else if (autocorrect
)
936 corrected
= autocorrect_tool (new_text
);
938 corrected
= g_strdup (new_text
);
940 if (corrected
&& (corrected
[0] == '\'') && corrected
[1] == '\0') {
942 corrected
= g_strdup ("");
945 /* We should check whether we are in fact changing anything: */
947 for (l
= selection
; l
!= NULL
&& same_text
; l
= l
->next
) {
948 GnmRange
*r
= l
->data
;
950 sheet_foreach_cell_in_range
951 (sheet
, CELL_ITER_ALL
, r
,
952 (CellIterFunc
) cmd_set_text_full_check_text
,
953 (gpointer
) corrected
);
955 same_text
= (val
!= VALUE_TERMINATE
);
956 if (val
!= NULL
&& same_text
)
960 if (go_pango_attr_list_is_empty (markup
))
962 if (markup
&& corrected
&& corrected
[0] == '\'') {
963 markup
= adj_markup
= pango_attr_list_copy (markup
);
964 go_pango_attr_list_erase (adj_markup
, 0, 1);
968 for (l
= selection
; l
!= NULL
&& same_text
; l
= l
->next
) {
969 GnmRange
*r
= l
->data
;
971 sheet_foreach_cell_in_range
972 (sheet
, CELL_ITER_IGNORE_BLANK
, r
,
973 (CellIterFunc
) cmd_set_text_full_check_markup
,
976 same_markup
= (val
!= VALUE_TERMINATE
);
977 if (val
!= NULL
&& same_markup
)
984 range_fragment_free (selection
);
986 pango_attr_list_unref (adj_markup
);
990 text
= g_strdup_printf (_("Editing style of %s"), name
);
992 text_str
= gnm_cmd_trunc_descriptor (g_string_new (corrected
), NULL
);
993 text
= g_strdup_printf (_("Typing \"%s\" in %s"), text_str
->str
, name
);
994 g_string_free (text_str
, TRUE
);
997 for (l
= selection
; l
!= NULL
; l
= l
->next
) {
999 undo
= go_undo_combine
1000 (undo
, clipboard_copy_range_undo (sheet
, l
->data
));
1002 sr
= gnm_sheet_range_new (sheet
, l
->data
);
1003 redo
= go_undo_combine
1004 (redo
, sheet_range_set_text_undo
1008 sr
= gnm_sheet_range_new (sheet
, l
->data
);
1009 /* Note: order of combination matters!! */
1010 redo
= go_undo_combine
1011 (sheet_range_set_markup_undo (sr
, markup
), redo
);
1016 pango_attr_list_unref (adj_markup
);
1019 same_text_and_not_same_markup
= (same_text
&& !same_markup
);
1023 /* We are combining this since we don't want to apply and undo twice.*/
1024 if (same_text_and_not_same_markup
|| !autofit_col
) {
1025 GnmCell
*cell
= sheet_cell_fetch
1026 (sheet
, ep
->eval
.col
, ep
->eval
.row
);
1029 go_undo_undo (redo
);
1030 nvis
= !VALUE_IS_STRING (cell
->value
);
1033 if (same_text_and_not_same_markup
)
1034 /* We only have to do something if at least one cell */
1035 /* now contains a string, but they contain all the same thing. */
1036 same_text_and_not_same_markup
= nvis
;
1037 go_undo_undo (undo
);
1039 if (same_text_and_not_same_markup
) {
1040 /*We had the same text and different markup but we are not entering strings. */
1041 g_object_unref (undo
);
1042 g_object_unref (redo
);
1044 range_fragment_free (selection
);
1047 for (l
= selection
; l
!= NULL
; l
= l
->next
) {
1048 GnmRange
*r
= l
->data
;
1051 new_r
= g_new (GnmRange
, 1);
1053 redo
= go_undo_combine
1056 (GOUndoBinaryFunc
) colrow_autofit_row
,
1059 cri_row_list
= colrow_get_index_list
1060 (r
->start
.row
, r
->end
.row
, cri_row_list
);
1063 new_r
= g_new (GnmRange
, 1);
1065 redo
= go_undo_combine
1068 (GOUndoBinaryFunc
) colrow_autofit_col
,
1071 cri_col_list
= colrow_get_index_list
1072 (r
->start
.col
, r
->end
.col
, cri_col_list
);
1076 undo
= go_undo_combine (undo
,
1077 gnm_undo_colrow_restore_state_group_new
1080 colrow_get_sizes (sheet
, TRUE
,
1081 cri_col_list
, -1)));
1082 undo
= go_undo_combine (undo
,
1083 gnm_undo_colrow_restore_state_group_new
1086 colrow_get_sizes (sheet
, FALSE
,
1087 cri_row_list
, -1)));
1089 result
= cmd_generic (wbc
, text
, undo
, redo
);
1091 range_fragment_free (selection
);
1098 * the caller is expected to have ensured:
1100 * 1) that no array is being split
1101 * 2) that the range is not locked.
1103 * Returns: %TRUE if there was a problem, %FALSE otherwise.
1106 cmd_area_set_text (WorkbookControl
*wbc
, SheetView
*sv
,
1107 char const *new_text
, PangoAttrList
*markup
)
1111 GSList
*selection
= selection_get_ranges (sv
, FALSE
);
1113 eval_pos_init_editpos (&ep
, sv
);
1114 result
= cmd_set_text_full (wbc
, selection
, &ep
,
1115 new_text
, markup
, TRUE
);
1120 cmd_set_text (WorkbookControl
*wbc
,
1121 Sheet
*sheet
, GnmCellPos
const *pos
,
1122 char const *new_text
,
1123 PangoAttrList
*markup
,
1124 gboolean autocorrect
)
1126 GnmCell
const *cell
;
1132 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
1133 g_return_val_if_fail (new_text
!= NULL
, TRUE
);
1135 /* Ensure that we are not splitting up an array */
1136 cell
= sheet_cell_get (sheet
, pos
->col
, pos
->row
);
1137 if (gnm_cell_is_nonsingleton_array (cell
)) {
1138 gnm_cmd_context_error_splits_array (GO_CMD_CONTEXT (wbc
),
1139 _("Set Text"), NULL
);
1143 eval_pos_init_pos (&ep
, sheet
, pos
);
1144 r
= g_new (GnmRange
, 1);
1145 r
->start
= r
->end
= *pos
;
1146 selection
= g_slist_prepend (NULL
, r
);
1147 result
= cmd_set_text_full (wbc
, selection
, &ep
,
1148 new_text
, markup
, autocorrect
);
1154 * cmd_area_set_array_expr
1156 * the caller is expected to have ensured:
1158 * 1) that no array is being split
1159 * 2) that the selection consists of a single range
1160 * 3) that the range is not locked.
1162 * Returns: %TRUE if there was a problem, %FALSE otherwise.
1165 cmd_area_set_array_expr (WorkbookControl
*wbc
, SheetView
*sv
,
1166 GnmExprTop
const *texpr
)
1168 GSList
*selection
= selection_get_ranges (sv
, FALSE
);
1169 GOUndo
*undo
= NULL
;
1170 GOUndo
*redo
= NULL
;
1172 Sheet
*sheet
= sv_sheet (sv
);
1178 g_return_val_if_fail (selection
!= NULL
, TRUE
);
1179 g_return_val_if_fail (selection
->next
== NULL
, TRUE
);
1181 name
= undo_range_list_name (sheet
, selection
);
1182 text
= g_strdup_printf (_("Inserting array expression in %s"), name
);
1185 r
= selection
->data
;
1187 undo
= clipboard_copy_range_undo (sheet
, selection
->data
);
1189 sr
= gnm_sheet_range_new (sheet
, r
);
1190 redo
= gnm_cell_set_array_formula_undo (sr
, texpr
);
1191 redo
= go_undo_combine
1193 (sheet
, g_memdup (r
, sizeof (*r
)),
1194 (GOUndoBinaryFunc
) colrow_autofit_col
,
1197 redo
= go_undo_combine
1199 (sheet
, g_memdup (r
, sizeof (*r
)),
1200 (GOUndoBinaryFunc
) colrow_autofit_row
,
1204 range_fragment_free (selection
);
1205 result
= cmd_generic (wbc
, text
, undo
, redo
);
1211 * cmd_create_data_table
1213 * the caller is expected to have ensured:
1215 * 1) that no array is being split
1216 * 2) that the range is not locked.
1218 * Returns: %TRUE if there was a problem, %FALSE otherwise.
1221 cmd_create_data_table (WorkbookControl
*wbc
, Sheet
*sheet
, GnmRange
const *r
,
1222 char const *col_input
, char const *row_input
)
1224 GOUndo
*undo
= NULL
;
1225 GOUndo
*redo
= NULL
;
1231 GnmExprTop
const *texpr
;
1233 name
= undo_range_name (sheet
, r
);
1234 text
= g_strdup_printf (_("Creating a Data Table in %s"), name
);
1237 undo
= clipboard_copy_range_undo (sheet
, r
);
1239 sr
= gnm_sheet_range_new (sheet
, r
);
1240 parse_pos_init (&pp
, NULL
, sheet
, r
->start
.col
, r
->start
.row
);
1241 name
= g_strdup_printf ("TABLE(%s,%s)", row_input
, col_input
);
1242 texpr
= gnm_expr_parse_str
1243 (name
, &pp
, GNM_EXPR_PARSE_DEFAULT
,
1244 sheet_get_conventions (sheet
), NULL
);
1247 if (texpr
== NULL
) {
1248 g_object_unref (undo
);
1253 redo
= gnm_cell_set_array_formula_undo (sr
, texpr
);
1254 gnm_expr_top_unref (texpr
);
1256 result
= cmd_generic (wbc
, text
, undo
, redo
);
1261 /******************************************************************/
1263 #define CMD_INS_DEL_COLROW_TYPE (cmd_ins_del_colrow_get_type ())
1264 #define CMD_INS_DEL_COLROW(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_INS_DEL_COLROW_TYPE, CmdInsDelColRow))
1275 GnmRange
*cutcopied
;
1276 SheetView
*cut_copy_view
;
1278 gboolean (*redo_action
) (Sheet
*sheet
, int col
, int count
,
1279 GOUndo
**pundo
, GOCmdContext
*cc
);
1281 gboolean (*repeat_action
) (WorkbookControl
*wbc
, Sheet
*sheet
,
1282 int start
, int count
);
1288 cmd_ins_del_colrow_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
1290 CmdInsDelColRow
const *orig
= (CmdInsDelColRow
const *) cmd
;
1291 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
1292 Sheet
*sheet
= sv_sheet (sv
);
1293 GnmRange
const *r
= selection_first_range (sv
,
1294 GO_CMD_CONTEXT (wbc
), _("Ins/Del Column/Row"));
1301 start
= r
->start
.col
, count
= range_width (r
);
1303 start
= r
->start
.row
, count
= range_height (r
);
1305 orig
->repeat_action (wbc
, sheet
, start
, count
);
1308 MAKE_GNM_COMMAND (CmdInsDelColRow
, cmd_ins_del_colrow
, cmd_ins_del_colrow_repeat
)
1311 cmd_ins_del_colrow_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
1313 CmdInsDelColRow
*me
= CMD_INS_DEL_COLROW (cmd
);
1316 go_undo_undo (me
->undo
);
1317 g_object_unref (me
->undo
);
1321 /* Ins/Del Row/Col re-ants things completely to account
1322 * for the shift of col/rows.
1324 if (me
->cutcopied
!= NULL
&& me
->cut_copy_view
!= NULL
)
1325 gnm_app_clipboard_cut_copy (wbc
, me
->is_cut
, me
->cut_copy_view
,
1326 me
->cutcopied
, FALSE
);
1332 cmd_ins_del_colrow_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
1334 CmdInsDelColRow
*me
= CMD_INS_DEL_COLROW (cmd
);
1335 GOCmdContext
*cc
= GO_CMD_CONTEXT (wbc
);
1336 int idx
= me
->index
;
1337 int count
= me
->count
;
1339 if (me
->redo_action (me
->sheet
, idx
, count
, &me
->undo
, cc
)) {
1344 /* Ins/Del Row/Col re-ants things completely to account
1345 * for the shift of col/rows. */
1346 if (me
->cutcopied
!= NULL
&& me
->cut_copy_view
!= NULL
) {
1348 GnmRange s
= *me
->cutcopied
;
1349 int key
= me
->is_insert
? count
: -count
;
1350 int threshold
= me
->is_insert
? idx
: idx
+ 1;
1353 * Really only applies if the regions that are
1354 * inserted/deleted are above the cut/copied region.
1357 if (threshold
<= s
.start
.col
) {
1361 } else if (threshold
<= s
.start
.row
) {
1366 gnm_app_clipboard_cut_copy (wbc
, me
->is_cut
,
1370 gnm_app_clipboard_unant ();
1377 cmd_ins_del_colrow_finalize (GObject
*cmd
)
1379 CmdInsDelColRow
*me
= CMD_INS_DEL_COLROW (cmd
);
1382 g_object_unref (me
->undo
);
1384 g_free (me
->cutcopied
);
1386 gnm_sheet_view_weak_unref (&(me
->cut_copy_view
));
1388 gnm_command_finalize (cmd
);
1392 cmd_ins_del_colrow (WorkbookControl
*wbc
,
1394 gboolean is_cols
, gboolean is_insert
,
1395 char const *descriptor
, int index
, int count
)
1397 CmdInsDelColRow
*me
;
1401 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
1402 g_return_val_if_fail (count
> 0, TRUE
);
1404 me
= g_object_new (CMD_INS_DEL_COLROW_TYPE
, NULL
);
1407 me
->is_cols
= is_cols
;
1408 me
->is_insert
= is_insert
;
1411 me
->redo_action
= me
->is_insert
1412 ? (me
->is_cols
? sheet_insert_cols
: sheet_insert_rows
)
1413 : (me
->is_cols
? sheet_delete_cols
: sheet_delete_rows
);
1414 me
->repeat_action
= me
->is_insert
1415 ? (me
->is_cols
? cmd_insert_cols
: cmd_insert_rows
)
1416 : (me
->is_cols
? cmd_delete_cols
: cmd_delete_rows
);
1418 /* Range that will get deleted. */
1419 first
= me
->is_insert
1420 ? colrow_max (is_cols
, sheet
) - count
1422 last
= first
+ count
- 1;
1423 (is_cols
? range_init_cols
: range_init_rows
) (&r
, sheet
, first
, last
);
1425 /* Note: redo_action checks for array subdivision. */
1427 /* Check for locks */
1428 if (cmd_cell_range_is_locked_effective (sheet
, &r
, wbc
, descriptor
)) {
1429 g_object_unref (me
);
1433 /* We store the cut or/copied range if applicable */
1434 if (!gnm_app_clipboard_is_empty () &&
1435 gnm_app_clipboard_area_get () &&
1436 sheet
== gnm_app_clipboard_sheet_get ()) {
1437 me
->cutcopied
= gnm_range_dup (gnm_app_clipboard_area_get ());
1438 me
->is_cut
= gnm_app_clipboard_is_cut ();
1439 gnm_sheet_view_weak_ref (gnm_app_clipboard_sheet_view_get (),
1440 &(me
->cut_copy_view
));
1442 me
->cutcopied
= NULL
;
1444 me
->cmd
.sheet
= sheet
;
1445 me
->cmd
.size
= count
* 10; /* FIXME? */
1446 me
->cmd
.cmd_descriptor
= descriptor
;
1448 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
1452 cmd_insert_cols (WorkbookControl
*wbc
,
1453 Sheet
*sheet
, int start_col
, int count
)
1458 range_init_full_sheet (&r
, sheet
);
1459 r
.start
.col
= r
.end
.col
- count
+ 1;
1461 if (!sheet_range_trim (sheet
, &r
, FALSE
, FALSE
)) {
1462 go_gtk_notice_dialog (wbcg_toplevel (WBC_GTK (wbc
)), GTK_MESSAGE_ERROR
,
1463 ngettext ("Inserting %i column before column %s would push data off the sheet. "
1464 "Please enlarge the sheet first.",
1465 "Inserting %i columns before column %s would push data off the sheet. "
1466 "Please enlarge the sheet first.",
1468 count
, col_name (start_col
));
1472 mesg
= g_strdup_printf
1473 (ngettext ("Inserting %d column before %s",
1474 "Inserting %d columns before %s",
1476 count
, col_name (start_col
));
1477 return cmd_ins_del_colrow (wbc
, sheet
, TRUE
, TRUE
, mesg
, start_col
, count
);
1481 cmd_insert_rows (WorkbookControl
*wbc
,
1482 Sheet
*sheet
, int start_row
, int count
)
1487 range_init_full_sheet (&r
, sheet
);
1488 r
.start
.row
= r
.end
.row
- count
+ 1;
1490 if (!sheet_range_trim (sheet
, &r
, FALSE
, FALSE
)) {
1491 go_gtk_notice_dialog (wbcg_toplevel (WBC_GTK (wbc
)), GTK_MESSAGE_ERROR
,
1492 ngettext ("Inserting %i row before row %s would push data off the sheet. "
1493 "Please enlarge the sheet first.",
1494 "Inserting %i rows before row %s would push data off the sheet. "
1495 "Please enlarge the sheet first.",
1497 count
, row_name (start_row
));
1501 mesg
= g_strdup_printf
1502 (ngettext ("Inserting %d row before %s",
1503 "Inserting %d rows before %s",
1505 count
, row_name (start_row
));
1506 return cmd_ins_del_colrow (wbc
, sheet
, FALSE
, TRUE
, mesg
, start_row
, count
);
1510 cmd_delete_cols (WorkbookControl
*wbc
,
1511 Sheet
*sheet
, int start_col
, int count
)
1513 char *mesg
= g_strdup_printf ((count
> 1)
1514 ? _("Deleting columns %s")
1515 : _("Deleting column %s"),
1516 cols_name (start_col
, start_col
+ count
- 1));
1517 return cmd_ins_del_colrow (wbc
, sheet
, TRUE
, FALSE
, mesg
, start_col
, count
);
1521 cmd_delete_rows (WorkbookControl
*wbc
,
1522 Sheet
*sheet
, int start_row
, int count
)
1524 char *mesg
= g_strdup_printf ((count
> 1)
1525 ? _("Deleting rows %s")
1526 : _("Deleting row %s"),
1527 rows_name (start_row
, start_row
+ count
- 1));
1528 return cmd_ins_del_colrow (wbc
, sheet
, FALSE
, FALSE
, mesg
, start_row
, count
);
1531 /******************************************************************/
1536 } cmd_selection_clear_row_handler_t
;
1539 cmd_selection_clear_row_handler (GnmColRowIter
const *iter
,
1540 cmd_selection_clear_row_handler_t
*data
)
1542 if ((!iter
->cri
->in_filter
) || iter
->cri
->visible
) {
1543 GnmRange
*r
= gnm_range_dup (data
->r
);
1544 r
->start
.row
= r
->end
.row
= iter
->pos
;
1545 data
->selection
= g_slist_prepend (data
->selection
, r
);
1551 cmd_selection_clear (WorkbookControl
*wbc
, int clear_flags
)
1553 char *names
, *descriptor
;
1555 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
1556 GSList
*selection
= selection_get_ranges (sv
, FALSE
/* No intersection */);
1557 Sheet
*sheet
= sv_sheet (sv
);
1560 GOUndo
*undo
= NULL
;
1561 GOUndo
*redo
= NULL
;
1564 if ((clear_flags
& CLEAR_FILTERED_ONLY
) != 0 && sheet
->filters
!= NULL
) {
1565 /* We need to modify the selection to only include filtered rows. */
1566 cmd_selection_clear_row_handler_t data
;
1567 data
.selection
= selection
;
1568 for (ranges
= selection
; ranges
!= NULL
; ranges
= ranges
->next
) {
1570 data
.r
= ranges
->data
;
1571 filter
= gnm_sheet_filter_intersect_rows
1572 (sheet
, data
.r
->start
.row
, data
.r
->end
.row
);
1574 sheet_colrow_foreach (sheet
, FALSE
,
1577 (ColRowHandler
) cmd_selection_clear_row_handler
,
1579 g_free (ranges
->data
);
1580 ranges
->data
= NULL
;
1583 selection
= g_slist_remove_all (data
.selection
, NULL
);
1586 /* We should first determine whether we break anything by clearing */
1587 /* Check for array subdivision *//* Check for locked cells */
1588 if (sheet_ranges_split_region (sheet
, selection
,
1589 GO_CMD_CONTEXT (wbc
), _("Clear")) ||
1590 cmd_selection_is_locked_effective (sheet
, selection
, wbc
, _("Clear"))) {
1591 range_fragment_free (selection
);
1596 /* We now need to build the descriptor */
1597 /* Collect clear types for descriptor */
1598 if (clear_flags
!= (CLEAR_VALUES
| CLEAR_FORMATS
| CLEAR_COMMENTS
)) {
1599 GSList
*m
, *l
= NULL
;
1600 types
= g_string_new (NULL
);
1601 if (clear_flags
& CLEAR_VALUES
)
1602 l
= g_slist_append (l
, g_string_new (_("contents")));
1603 if (clear_flags
& CLEAR_FORMATS
)
1604 l
= g_slist_append (l
, g_string_new (_("formats")));
1605 if (clear_flags
& CLEAR_COMMENTS
)
1606 l
= g_slist_append (l
, g_string_new (_("comments")));
1607 /* Using a list for this may seem overkill, but is really the only
1608 * right way to do this
1610 for (m
= l
; m
!= NULL
; m
= m
->next
) {
1611 GString
*s
= m
->data
;
1613 g_string_append_len (types
, s
->str
, s
->len
);
1614 g_string_free (s
, TRUE
);
1617 g_string_append (types
, ", ");
1621 types
= g_string_new (_("all"));
1622 /* The range name string will automatically be truncated, we don't
1623 * need to truncate the "types" list because it will not grow
1626 names
= undo_range_list_name (sheet
, selection
);
1627 descriptor
= g_strdup_printf (_("Clearing %s in %s"), types
->str
, names
);
1629 g_string_free (types
, TRUE
);
1630 size
= g_slist_length (selection
);
1632 clear_flags
|= CLEAR_NOCHECKARRAY
;
1634 if (clear_flags
& (CLEAR_VALUES
| CLEAR_FORMATS
))
1635 clear_flags
|= CLEAR_RECALC_DEPS
;
1637 /* We are now ready to build the redo and undo items */
1638 for (ranges
= selection
; ranges
!= NULL
; ranges
= ranges
->next
) {
1639 GnmRange
const *r
= ranges
->data
;
1640 GnmSheetRange
*sr
= gnm_sheet_range_new (sheet
, r
);
1642 undo
= go_undo_combine (undo
, clipboard_copy_range_undo (sheet
, r
));
1643 redo
= go_undo_combine
1644 (redo
, sheet_clear_region_undo
1648 range_fragment_free (selection
);
1650 result
= cmd_generic_with_size (wbc
, descriptor
, size
, undo
, redo
);
1651 g_free (descriptor
);
1656 /******************************************************************/
1658 #define CMD_FORMAT_TYPE (cmd_format_get_type ())
1659 #define CMD_FORMAT(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_FORMAT_TYPE, CmdFormat))
1663 GnmStyleList
*styles
;
1664 ColRowIndexList
*rows
;
1665 ColRowStateGroup
*old_heights
;
1666 } CmdFormatOldStyle
;
1672 GnmStyle
*new_style
;
1673 GnmBorder
**borders
;
1677 cmd_format_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
1679 CmdFormat
const *orig
= (CmdFormat
const *) cmd
;
1682 if (orig
->new_style
)
1683 gnm_style_ref (orig
->new_style
);
1685 for (i
= GNM_STYLE_BORDER_TOP
; i
< GNM_STYLE_BORDER_EDGE_MAX
; i
++)
1686 gnm_style_border_ref (orig
->borders
[i
]);
1688 cmd_selection_format (wbc
, orig
->new_style
, orig
->borders
, NULL
);
1690 MAKE_GNM_COMMAND (CmdFormat
, cmd_format
, cmd_format_repeat
)
1693 cmd_format_undo (GnmCommand
*cmd
,
1694 G_GNUC_UNUSED WorkbookControl
*wbc
)
1696 CmdFormat
*me
= CMD_FORMAT (cmd
);
1698 g_return_val_if_fail (me
!= NULL
, TRUE
);
1700 if (me
->old_styles
) {
1701 GSList
*rstyles
= g_slist_reverse (g_slist_copy (me
->old_styles
));
1702 GSList
*rsel
= g_slist_reverse (g_slist_copy (me
->selection
));
1705 for (l1
= rstyles
, l2
= rsel
; l1
; l1
= l1
->next
, l2
= l2
->next
) {
1706 CmdFormatOldStyle
*os
= l1
->data
;
1707 GnmRange
const *r
= l2
->data
;
1708 GnmSpanCalcFlags flags
= sheet_style_set_list
1710 &os
->pos
, os
->styles
, NULL
, NULL
);
1712 if (os
->old_heights
) {
1713 colrow_restore_state_group (me
->cmd
.sheet
, FALSE
,
1716 colrow_state_group_destroy (os
->old_heights
);
1717 os
->old_heights
= NULL
;
1718 colrow_index_list_destroy (os
->rows
);
1722 sheet_range_calc_spans (me
->cmd
.sheet
, r
, flags
);
1723 sheet_flag_style_update_range (me
->cmd
.sheet
, r
);
1726 sheet_redraw_all (me
->cmd
.sheet
, FALSE
);
1727 g_slist_free (rstyles
);
1728 g_slist_free (rsel
);
1731 select_selection (me
->cmd
.sheet
, me
->selection
, wbc
);
1737 cmd_format_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
1739 CmdFormat
*me
= CMD_FORMAT (cmd
);
1741 gboolean re_fit_height
;
1743 g_return_val_if_fail (me
!= NULL
, TRUE
);
1745 /* Check for locked cells */
1746 if (cmd_selection_is_locked_effective (me
->cmd
.sheet
, me
->selection
,
1747 wbc
, _("Changing Format")))
1750 re_fit_height
= me
->new_style
&&
1751 (GNM_SPANCALC_ROW_HEIGHT
& gnm_style_required_spanflags (me
->new_style
));
1753 for (l1
= me
->old_styles
, l2
= me
->selection
; l2
; l1
= l1
->next
, l2
= l2
->next
) {
1754 CmdFormatOldStyle
*os
= l1
->data
;
1755 GnmRange
const *r
= l2
->data
;
1758 sheet_apply_border (me
->cmd
.sheet
, r
, me
->borders
);
1759 if (me
->new_style
) {
1760 gnm_style_ref (me
->new_style
);
1761 sheet_apply_style (me
->cmd
.sheet
, r
, me
->new_style
);
1763 colrow_autofit (me
->cmd
.sheet
, r
, FALSE
, FALSE
,
1765 &os
->rows
, &os
->old_heights
);
1768 sheet_flag_style_update_range (me
->cmd
.sheet
, r
);
1770 sheet_redraw_all (me
->cmd
.sheet
, FALSE
);
1771 sheet_mark_dirty (me
->cmd
.sheet
);
1773 select_selection (me
->cmd
.sheet
, me
->selection
, wbc
);
1779 cmd_format_finalize (GObject
*cmd
)
1781 CmdFormat
*me
= CMD_FORMAT (cmd
);
1785 gnm_style_unref (me
->new_style
);
1786 me
->new_style
= NULL
;
1789 for (i
= GNM_STYLE_BORDER_TOP
; i
< GNM_STYLE_BORDER_EDGE_MAX
; i
++)
1790 gnm_style_border_unref (me
->borders
[i
]);
1791 g_free (me
->borders
);
1795 if (me
->old_styles
!= NULL
) {
1798 for (l
= me
->old_styles
; l
!= NULL
; l
= g_slist_remove (l
, l
->data
)) {
1799 CmdFormatOldStyle
*os
= l
->data
;
1801 style_list_free (os
->styles
);
1802 colrow_index_list_destroy (os
->rows
);
1803 colrow_state_group_destroy (os
->old_heights
);
1806 me
->old_styles
= NULL
;
1809 range_fragment_free (me
->selection
);
1810 me
->selection
= NULL
;
1812 gnm_command_finalize (cmd
);
1816 * cmd_format: (skip)
1817 * @wbc: the workbook control.
1819 * @style: (transfer full): style to apply to the selection
1820 * @borders: (nullable) (transfer full): borders to apply to the selection
1821 * @opt_translated_name: An optional name to use in place of 'Format Cells'
1823 * If borders is non-%NULL, then the GnmBorder references are passed,
1824 * the GnmStyle reference is also passed.
1826 * Returns: %TRUE if there was a problem, %FALSE otherwise.
1829 cmd_selection_format (WorkbookControl
*wbc
,
1830 GnmStyle
*style
, GnmBorder
**borders
,
1831 char const *opt_translated_name
)
1835 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
1837 me
= g_object_new (CMD_FORMAT_TYPE
, NULL
);
1839 me
->selection
= selection_get_ranges (sv
, FALSE
); /* TRUE ? */
1840 me
->new_style
= style
;
1842 me
->cmd
.sheet
= sv_sheet (sv
);
1843 me
->cmd
.size
= 1; /* Updated below. */
1845 me
->old_styles
= NULL
;
1846 for (l
= me
->selection
; l
; l
= l
->next
) {
1847 GnmRange
const *sel_r
= l
->data
;
1848 GnmRange range
= *sel_r
;
1849 CmdFormatOldStyle
*os
;
1851 /* Store the containing range to handle borders */
1852 if (borders
!= NULL
) {
1853 if (range
.start
.col
> 0) range
.start
.col
--;
1854 if (range
.start
.row
> 0) range
.start
.row
--;
1855 if (range
.end
.col
< gnm_sheet_get_last_col (me
->cmd
.sheet
)) range
.end
.col
++;
1856 if (range
.end
.row
< gnm_sheet_get_last_row (me
->cmd
.sheet
)) range
.end
.row
++;
1859 os
= g_new (CmdFormatOldStyle
, 1);
1861 os
->styles
= sheet_style_get_range (me
->cmd
.sheet
, &range
);
1862 os
->pos
= range
.start
;
1864 os
->old_heights
= NULL
;
1866 me
->cmd
.size
+= g_slist_length (os
->styles
);
1867 me
->old_styles
= g_slist_append (me
->old_styles
, os
);
1873 me
->borders
= g_new (GnmBorder
*, GNM_STYLE_BORDER_EDGE_MAX
);
1874 for (i
= GNM_STYLE_BORDER_TOP
; i
< GNM_STYLE_BORDER_EDGE_MAX
; i
++)
1875 me
->borders
[i
] = borders
[i
];
1879 if (opt_translated_name
== NULL
) {
1880 char *names
= undo_range_list_name (me
->cmd
.sheet
, me
->selection
);
1882 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Changing format of %s"), names
);
1885 me
->cmd
.cmd_descriptor
= g_strdup (opt_translated_name
);
1887 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
1890 /******************************************************************/
1893 cmd_selection_format_toggle_font_style_filter (PangoAttribute
*attribute
, PangoAttrType
*pt
)
1895 return ((attribute
->klass
->type
== *pt
) ||
1896 ((PANGO_ATTR_RISE
== *pt
) && (attribute
->klass
->type
== PANGO_ATTR_SCALE
)));
1905 cmd_selection_format_toggle_font_style_cb (GnmCellIter
const *iter
, csftfs
*closure
)
1907 if (iter
->cell
&& iter
->cell
->value
&& VALUE_IS_STRING (iter
->cell
->value
)) {
1908 const GOFormat
*fmt
= VALUE_FMT (iter
->cell
->value
);
1909 if (fmt
&& go_format_is_markup (fmt
)) {
1910 const PangoAttrList
*old_markup
=
1911 go_format_get_markup (fmt
);
1912 PangoAttrList
*new_markup
= pango_attr_list_copy ((PangoAttrList
*)old_markup
);
1913 PangoAttrList
*other
= pango_attr_list_filter
1915 (PangoAttrFilterFunc
) cmd_selection_format_toggle_font_style_filter
,
1917 if (other
!= NULL
) {
1920 range_init_cellpos (&r
, &iter
->pp
.eval
);
1921 sr
= gnm_sheet_range_new (iter
->pp
.sheet
, &r
);
1922 closure
->undo
= go_undo_combine (closure
->undo
,
1923 sheet_range_set_markup_undo (sr
, new_markup
));
1925 pango_attr_list_unref (new_markup
);
1926 pango_attr_list_unref (other
);
1933 cmd_selection_format_toggle_font_style (WorkbookControl
*wbc
,
1934 GnmStyle
*style
, GnmStyleElement t
)
1936 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
1937 Sheet
*sheet
= sv
->sheet
;
1938 GSList
*selection
= selection_get_ranges (sv
, FALSE
), *l
;
1941 GOUndo
*undo
= NULL
;
1942 GOUndo
*redo
= NULL
;
1947 case MSTYLE_FONT_BOLD
:
1948 pt
= PANGO_ATTR_WEIGHT
;
1950 case MSTYLE_FONT_ITALIC
:
1951 pt
= PANGO_ATTR_STYLE
;
1953 case MSTYLE_FONT_UNDERLINE
:
1954 pt
= PANGO_ATTR_UNDERLINE
;
1956 case MSTYLE_FONT_STRIKETHROUGH
:
1957 pt
= PANGO_ATTR_STRIKETHROUGH
;
1959 case MSTYLE_FONT_SCRIPT
:
1960 pt
= PANGO_ATTR_RISE
; /* and PANGO_ATTR_SCALE (see ) */
1963 pt
= PANGO_ATTR_INVALID
;
1968 name
= undo_range_list_name (sheet
, selection
);
1969 text
= g_strdup_printf (_("Setting Font Style of %s"), name
);
1972 for (l
= selection
; l
!= NULL
; l
= l
->next
) {
1974 undo
= go_undo_combine
1975 (undo
, clipboard_copy_range_undo (sheet
, l
->data
));
1976 sr
= gnm_sheet_range_new (sheet
, l
->data
);
1977 redo
= go_undo_combine
1978 (redo
, sheet_apply_style_undo (sr
, style
));
1979 if (pt
!= PANGO_ATTR_INVALID
) {
1981 closure
.undo
= NULL
;
1983 sheet_foreach_cell_in_range
1984 (sheet
, CELL_ITER_IGNORE_BLANK
, &sr
->range
,
1985 (CellIterFunc
) cmd_selection_format_toggle_font_style_cb
,
1987 redo
= go_undo_combine (redo
, closure
.undo
);
1990 gnm_style_unref (style
);
1991 result
= cmd_generic (wbc
, text
, undo
, redo
);
1993 range_fragment_free (selection
);
1999 /******************************************************************/
2003 cmd_resize_colrow (WorkbookControl
*wbc
, Sheet
*sheet
,
2004 gboolean is_cols
, ColRowIndexList
*selection
,
2009 GOUndo
*undo
= NULL
;
2010 GOUndo
*redo
= NULL
;
2011 gboolean is_single
, result
;
2013 ColRowStateGroup
*saved_state
;
2015 list
= colrow_index_list_to_string (selection
, is_cols
, &is_single
);
2016 gnm_cmd_trunc_descriptor (list
, NULL
);
2021 ? g_strdup_printf (_("Autofitting column %s"), list
->str
)
2022 : g_strdup_printf (_("Autofitting row %s"), list
->str
);
2023 else if (new_size
> 0)
2025 ? g_strdup_printf (ngettext ("Setting width of column %s to %d pixel",
2026 "Setting width of column %s to %d pixels",
2028 list
->str
, new_size
)
2029 : g_strdup_printf (ngettext ("Setting height of row %s to %d pixel",
2030 "Setting height of row %s to %d pixels",
2032 list
->str
, new_size
);
2034 ? g_strdup_printf (_("Setting width of column %s to default"),
2037 _("Setting height of row %s to default"), list
->str
);
2041 ? g_strdup_printf (_("Autofitting columns %s"), list
->str
)
2042 : g_strdup_printf (_("Autofitting rows %s"), list
->str
);
2043 else if (new_size
> 0)
2045 ? g_strdup_printf (ngettext("Setting width of columns %s to %d pixel",
2046 "Setting width of columns %s to %d pixels",
2048 list
->str
, new_size
)
2049 : g_strdup_printf (ngettext("Setting height of rows %s to %d pixel",
2050 "Setting height of rows %s to %d pixels",
2052 list
->str
, new_size
);
2055 _("Setting width of columns %s to default"), list
->str
)
2057 _("Setting height of rows %s to default"), list
->str
);
2059 g_string_free (list
, TRUE
);
2061 saved_state
= colrow_get_sizes (sheet
, is_cols
, selection
, new_size
);
2062 undo
= gnm_undo_colrow_restore_state_group_new
2063 (sheet
, is_cols
, colrow_index_list_copy (selection
), saved_state
);
2065 redo
= gnm_undo_colrow_set_sizes_new (sheet
, is_cols
, selection
, new_size
, NULL
);
2067 result
= cmd_generic_with_size (wbc
, text
, size
, undo
, redo
);
2074 cmd_autofit_selection (WorkbookControl
*wbc
, SheetView
*sv
, Sheet
*sheet
, gboolean fit_width
,
2075 ColRowIndexList
*selectionlist
)
2077 GOUndo
*undo
= NULL
;
2078 GOUndo
*redo
= NULL
;
2080 ColRowStateGroup
*saved_state
;
2081 GSList
*l
, *selection
= selection_get_ranges (sv
, TRUE
);
2082 gchar
*names
= undo_range_list_name (sheet
, selection
);
2083 gchar
const *format
= fit_width
?
2084 N_("Autofitting width of %s") : N_("Autofitting height of %s");
2085 gchar
*text
= g_strdup_printf (_(format
), names
);
2089 saved_state
= colrow_get_sizes (sheet
, fit_width
, selectionlist
, -1);
2090 undo
= gnm_undo_colrow_restore_state_group_new
2091 (sheet
, fit_width
, colrow_index_list_copy (selectionlist
), saved_state
);
2093 for (l
= selection
; l
!= NULL
; l
= l
->next
)
2094 redo
= go_undo_combine
2095 (redo
, gnm_undo_colrow_set_sizes_new
2096 (sheet
, fit_width
, NULL
, -1, l
->data
));
2098 result
= cmd_generic (wbc
, text
, undo
, redo
);
2104 /******************************************************************/
2106 #define CMD_SORT_TYPE (cmd_sort_get_type ())
2107 #define CMD_SORT(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SORT_TYPE, CmdSort))
2114 GnmCellRegion
*old_contents
;
2117 MAKE_GNM_COMMAND (CmdSort
, cmd_sort
, NULL
)
2120 cmd_sort_finalize (GObject
*cmd
)
2122 CmdSort
*me
= CMD_SORT (cmd
);
2124 if (me
->data
!= NULL
)
2125 gnm_sort_data_destroy (me
->data
);
2127 if (me
->old_contents
!= NULL
)
2128 cellregion_unref (me
->old_contents
);
2130 gnm_command_finalize (cmd
);
2134 cmd_sort_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
2136 CmdSort
*me
= CMD_SORT (cmd
);
2137 GnmSortData
*data
= me
->data
;
2140 paste_target_init (&pt
, data
->sheet
, data
->range
,
2141 PASTE_CONTENTS
| PASTE_FORMATS
|
2142 (data
->retain_formats
? PASTE_FORMATS
: 0));
2143 clipboard_paste_region (me
->old_contents
,
2145 GO_CMD_CONTEXT (wbc
));
2151 cmd_sort_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
2153 CmdSort
*me
= CMD_SORT (cmd
);
2154 GnmSortData
*data
= me
->data
;
2156 /* Check for locks */
2157 if (cmd_cell_range_is_locked_effective
2158 (data
->sheet
, data
->range
, wbc
, _("Sorting")))
2162 gnm_sort_position (data
, me
->perm
, GO_CMD_CONTEXT (wbc
));
2165 clipboard_copy_range (data
->sheet
, data
->range
);
2166 me
->cmd
.size
= cellregion_cmd_size (me
->old_contents
);
2167 me
->perm
= gnm_sort_contents (data
, GO_CMD_CONTEXT (wbc
));
2174 cmd_sort (WorkbookControl
*wbc
, GnmSortData
*data
)
2179 g_return_val_if_fail (data
!= NULL
, TRUE
);
2181 desc
= g_strdup_printf (_("Sorting %s"), range_as_string (data
->range
));
2182 if (sheet_range_contains_merges_or_arrays (data
->sheet
, data
->range
, GO_CMD_CONTEXT (wbc
), desc
, TRUE
, TRUE
)) {
2183 gnm_sort_data_destroy (data
);
2188 me
= g_object_new (CMD_SORT_TYPE
, NULL
);
2192 me
->cmd
.sheet
= data
->sheet
;
2193 me
->cmd
.size
= 1; /* Changed in initial redo. */
2194 me
->cmd
.cmd_descriptor
= desc
;
2196 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
2199 /******************************************************************/
2201 #define CMD_COLROW_HIDE_TYPE (cmd_colrow_hide_get_type ())
2202 #define CMD_COLROW_HIDE(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_COLROW_HIDE_TYPE, CmdColRowHide))
2208 ColRowVisList
*hide
, *show
;
2212 cmd_colrow_hide_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
2214 CmdColRowHide
const *orig
= (CmdColRowHide
const *) cmd
;
2215 cmd_selection_colrow_hide (wbc
, orig
->is_cols
, orig
->show
!= NULL
);
2217 MAKE_GNM_COMMAND (CmdColRowHide
, cmd_colrow_hide
, cmd_colrow_hide_repeat
)
2220 * cmd_colrow_hide_correct_selection:
2222 * Try to ensure that the selection/cursor is set to a visible row/col
2224 * Added to fix bug 38179
2225 * Removed because the result is irritating and the bug is actually XL
2229 cmd_colrow_hide_correct_selection (G_GNUC_UNUSED CmdColRowHide
*me
, G_GNUC_UNUSED WorkbookControl
*wbc
)
2233 SheetView
*sv
= sheet_get_view (me
->cmd
.sheet
,
2234 wb_control_view (wbc
));
2236 index
= colrow_find_adjacent_visible (me
->cmd
.sheet
, me
->is_cols
,
2237 me
->is_cols
? sv
->edit_pos
.col
: sv
->edit_pos
.row
,
2240 x
= me
->is_cols
? sv
->edit_pos
.row
: index
;
2241 y
= me
->is_cols
? index
: sv
->edit_pos
.col
;
2244 sv_selection_reset (sv
);
2246 sv_selection_add_full (sv
, y
, x
, y
, 0,
2247 y
, gnm_sheet_get_last_row (sheet
),
2248 GNM_SELECTION_MODE_ADD
);
2250 sv_selection_add_full (sv
, y
, x
, 0, x
,
2251 gnm_sheet_get_last_col (sheet
), x
,
2252 GNM_SELECTION_MODE_ADD
);
2258 cmd_colrow_hide_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
2260 CmdColRowHide
*me
= CMD_COLROW_HIDE (cmd
);
2262 g_return_val_if_fail (me
!= NULL
, TRUE
);
2264 colrow_set_visibility_list (me
->cmd
.sheet
, me
->is_cols
,
2266 colrow_set_visibility_list (me
->cmd
.sheet
, me
->is_cols
,
2269 if (me
->show
!= NULL
)
2270 cmd_colrow_hide_correct_selection (me
, wbc
);
2276 cmd_colrow_hide_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
2278 CmdColRowHide
*me
= CMD_COLROW_HIDE (cmd
);
2280 g_return_val_if_fail (me
!= NULL
, TRUE
);
2282 colrow_set_visibility_list (me
->cmd
.sheet
, me
->is_cols
,
2284 colrow_set_visibility_list (me
->cmd
.sheet
, me
->is_cols
,
2287 if (me
->hide
!= NULL
)
2288 cmd_colrow_hide_correct_selection (me
, wbc
);
2294 cmd_colrow_hide_finalize (GObject
*cmd
)
2296 CmdColRowHide
*me
= CMD_COLROW_HIDE (cmd
);
2297 colrow_vis_list_destroy (me
->hide
);
2299 colrow_vis_list_destroy (me
->show
);
2301 gnm_command_finalize (cmd
);
2305 cmd_selection_colrow_hide (WorkbookControl
*wbc
,
2306 gboolean is_cols
, gboolean visible
)
2309 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
2312 GSList
*show
= NULL
, *hide
= NULL
;
2315 show
= colrow_get_visibility_toggle (sv
, is_cols
, TRUE
);
2317 hide
= colrow_get_visibility_toggle (sv
, is_cols
, FALSE
);
2318 n
= colrow_vis_list_length (hide
) + colrow_vis_list_length (show
);
2319 sheet
= sv_sheet (sv
);
2322 /* If these are the last colrows to hide, check with the user */
2325 int i
, max
= gnm_sheet_get_max_cols (sheet
);
2327 for (i
= 0 ; i
< max
; i
++)
2329 (ci
= sheet_col_get (sheet
, i
)) ||
2333 int i
, max
= gnm_sheet_get_max_rows (sheet
);
2335 for (i
= 0 ; i
< max
; i
++)
2337 (ci
= sheet_row_get (sheet
, i
)) ||
2342 gchar
const *text
= is_cols
?
2343 _("Are you sure that you want to hide all columns? "
2344 "If you do so you can unhide them with the "
2345 "'Format\342\206\222Column\342\206\222Unhide' "
2347 _("Are you sure that you want to hide all rows? "
2348 "If you do so you can unhide them with the "
2349 "'Format\342\206\222Row\342\206\222Unhide' "
2351 if (!go_gtk_query_yes_no (wbcg_toplevel (WBC_GTK (wbc
)),
2352 FALSE
, "%s", text
)) {
2353 colrow_vis_list_destroy (show
);
2354 colrow_vis_list_destroy (hide
);
2360 me
= g_object_new (CMD_COLROW_HIDE_TYPE
, NULL
);
2363 me
->is_cols
= is_cols
;
2364 me
->cmd
.sheet
= sheet
;
2365 me
->cmd
.size
= 1 + g_slist_length (hide
) + g_slist_length (show
);
2366 me
->cmd
.cmd_descriptor
= g_strdup (is_cols
2367 ? (visible
? _("Unhide columns") : _("Hide columns"))
2368 : (visible
? _("Unhide rows") : _("Hide rows")));
2370 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
2374 cmd_selection_outline_change (WorkbookControl
*wbc
,
2375 gboolean is_cols
, int index
, int depth
)
2378 ColRowInfo
const *cri
;
2379 int first
= -1, last
= -1;
2380 gboolean visible
= FALSE
;
2382 Sheet
*sheet
= wb_control_cur_sheet (wbc
);
2383 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
2385 cri
= sheet_colrow_get_info (sheet
, index
, is_cols
);
2387 d
= cri
->outline_level
;
2391 /* Nodes only collapse when selected directly, selecting at a lower
2392 * level is a standard toggle. */
2394 if ((is_cols
? sheet
->outline_symbols_right
: sheet
->outline_symbols_below
)) {
2396 ColRowInfo
const *prev
=
2397 sheet_colrow_get (sheet
, index
-1, is_cols
);
2399 if (prev
!= NULL
&& prev
->outline_level
> d
) {
2400 visible
= (depth
== d
&& cri
->is_collapsed
);
2402 first
= colrow_find_outline_bound (sheet
, is_cols
,
2406 } else if (index
+1 < colrow_max (is_cols
, sheet
)) {
2407 ColRowInfo
const *next
=
2408 sheet_colrow_get (sheet
, index
+1, is_cols
);
2410 if (next
!= NULL
&& next
->outline_level
> d
) {
2411 visible
= (depth
== d
&& cri
->is_collapsed
);
2413 last
= colrow_find_outline_bound (sheet
, is_cols
,
2419 /* If nothing done yet do a simple collapse */
2420 if (first
< 0 && cri
->outline_level
> 0) {
2423 first
= colrow_find_outline_bound (sheet
, is_cols
, index
, depth
, FALSE
);
2424 last
= colrow_find_outline_bound (sheet
, is_cols
, index
, depth
, TRUE
);
2427 if (first
== last
&& depth
> cri
->outline_level
)
2431 if (first
< 0 || last
< 0)
2434 me
= g_object_new (CMD_COLROW_HIDE_TYPE
, NULL
);
2436 me
->is_cols
= is_cols
;
2437 me
->hide
= me
->show
= NULL
;
2439 me
->show
= colrow_get_outline_toggle (sv_sheet (sv
), is_cols
,
2442 me
->hide
= colrow_get_outline_toggle (sv_sheet (sv
), is_cols
,
2443 FALSE
, first
, last
);
2445 me
->cmd
.sheet
= sv_sheet (sv
);
2446 me
->cmd
.size
= 1 + g_slist_length (me
->show
) + g_slist_length (me
->hide
);
2447 me
->cmd
.cmd_descriptor
= g_strdup (is_cols
2448 ? (visible
? _("Expand columns") : _("Collapse columns"))
2449 : (visible
? _("Expand rows") : _("Collapse rows")));
2451 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
2455 cmd_global_outline_change (WorkbookControl
*wbc
, gboolean is_cols
, int depth
)
2458 ColRowVisList
*hide
, *show
;
2459 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
2461 colrow_get_global_outline (sv_sheet (sv
), is_cols
, depth
, &show
, &hide
);
2463 if (show
== NULL
&& hide
== NULL
)
2466 me
= g_object_new (CMD_COLROW_HIDE_TYPE
, NULL
);
2467 me
->is_cols
= is_cols
;
2470 me
->cmd
.sheet
= sv_sheet (sv
);
2471 me
->cmd
.size
= 1 + g_slist_length (me
->show
) + g_slist_length (me
->hide
);
2472 me
->cmd
.cmd_descriptor
= g_strdup_printf (is_cols
2473 ? _("Show column outline %d") : _("Show row outline %d"), depth
);
2475 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
2478 /******************************************************************/
2480 #define CMD_GROUP_TYPE (cmd_group_get_type ())
2481 #define CMD_GROUP(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_GROUP_TYPE, CmdGroup))
2492 cmd_group_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
2494 CmdGroup
const *orig
= (CmdGroup
const *) cmd
;
2495 cmd_selection_group (wbc
, orig
->is_cols
, orig
->group
);
2497 MAKE_GNM_COMMAND (CmdGroup
, cmd_group
, cmd_group_repeat
)
2500 cmd_group_undo (GnmCommand
*cmd
,
2501 G_GNUC_UNUSED WorkbookControl
*wbc
)
2503 CmdGroup
const *me
= CMD_GROUP (cmd
);
2504 sheet_colrow_group_ungroup (me
->cmd
.sheet
,
2505 &me
->range
, me
->is_cols
, !me
->group
);
2510 cmd_group_redo (GnmCommand
*cmd
,
2511 G_GNUC_UNUSED WorkbookControl
*wbc
)
2513 CmdGroup
const *me
= CMD_GROUP (cmd
);
2514 sheet_colrow_group_ungroup (me
->cmd
.sheet
,
2515 &me
->range
, me
->is_cols
, me
->group
);
2520 cmd_group_finalize (GObject
*cmd
)
2522 gnm_command_finalize (cmd
);
2526 cmd_selection_group (WorkbookControl
*wbc
,
2527 gboolean is_cols
, gboolean group
)
2533 g_return_val_if_fail (wbc
!= NULL
, TRUE
);
2535 sv
= wb_control_cur_sheet_view (wbc
);
2536 r
= *selection_first_range (sv
, NULL
, NULL
);
2538 /* Check if this really is possible and display an error if it's not */
2539 if (sheet_colrow_can_group (sv
->sheet
, &r
, is_cols
) != group
) {
2541 go_cmd_context_error_system (GO_CMD_CONTEXT (wbc
), is_cols
2542 ? _("Those columns are already grouped")
2543 : _("Those rows are already grouped"));
2547 /* see if the user selected the col/row with the marker too */
2549 if (r
.start
.col
!= r
.end
.col
) {
2550 if (sv
->sheet
->outline_symbols_right
)
2556 if (r
.start
.row
!= r
.end
.row
) {
2557 if (sv
->sheet
->outline_symbols_below
)
2564 if (sheet_colrow_can_group (sv
->sheet
, &r
, is_cols
) != group
) {
2565 go_cmd_context_error_system (GO_CMD_CONTEXT (wbc
), is_cols
2566 ? _("Those columns are not grouped, you can't ungroup them")
2567 : _("Those rows are not grouped, you can't ungroup them"));
2572 me
= g_object_new (CMD_GROUP_TYPE
, NULL
);
2573 me
->is_cols
= is_cols
;
2577 me
->cmd
.sheet
= sv
->sheet
;
2579 me
->cmd
.cmd_descriptor
= is_cols
2580 ? g_strdup_printf (group
? _("Group columns %s") : _("Ungroup columns %s"),
2581 cols_name (me
->range
.start
.col
, me
->range
.end
.col
))
2582 : g_strdup_printf (group
? _("Group rows %d:%d") : _("Ungroup rows %d:%d"),
2583 me
->range
.start
.row
+ 1, me
->range
.end
.row
+ 1);
2585 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
2588 /******************************************************************/
2590 #define CMD_PASTE_CUT_TYPE (cmd_paste_cut_get_type ())
2591 #define CMD_PASTE_CUT(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_PASTE_CUT_TYPE, CmdPasteCut))
2596 GnmExprRelocateInfo info
;
2597 GSList
*paste_contents
;
2599 gboolean move_selection
;
2600 ColRowStateList
*saved_sizes
;
2602 /* handle redo-ing an undo with contents from a deleted sheet */
2603 GnmCellRegion
*deleted_sheet_contents
;
2606 MAKE_GNM_COMMAND (CmdPasteCut
, cmd_paste_cut
, NULL
)
2610 GnmCellRegion
*contents
;
2614 * cmd_paste_cut_update:
2616 * Utility routine to update things when we are transfering between sheets and
2620 cmd_paste_cut_update (GnmExprRelocateInfo
const *info
,
2621 G_GNUC_UNUSED WorkbookControl
*wbc
)
2623 Sheet
*o
= info
->origin_sheet
;
2624 Sheet
*t
= info
->target_sheet
;
2626 /* Dirty and update both sheets */
2627 sheet_mark_dirty (t
);
2630 if (IS_SHEET (o
) && o
!= t
) {
2631 sheet_mark_dirty (o
);
2637 cmd_paste_cut_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
2639 CmdPasteCut
*me
= CMD_PASTE_CUT (cmd
);
2640 GnmExprRelocateInfo reverse
;
2642 g_return_val_if_fail (me
!= NULL
, TRUE
);
2643 g_return_val_if_fail (me
->paste_contents
!= NULL
, TRUE
);
2644 g_return_val_if_fail (me
->deleted_sheet_contents
== NULL
, TRUE
);
2646 reverse
.reloc_type
= GNM_EXPR_RELOCATE_MOVE_RANGE
;
2647 reverse
.target_sheet
= me
->info
.origin_sheet
;
2648 reverse
.origin_sheet
= me
->info
.target_sheet
;
2649 reverse
.origin
= me
->info
.origin
;
2650 range_translate (&reverse
.origin
,
2651 me
->info
.origin_sheet
, /* FIXME: What sheet? */
2652 me
->info
.col_offset
,
2653 me
->info
.row_offset
);
2654 reverse
.col_offset
= -me
->info
.col_offset
;
2655 reverse
.row_offset
= -me
->info
.row_offset
;
2657 /* Move things back being careful NOT to invalidate the src region */
2658 if (IS_SHEET (me
->info
.origin_sheet
))
2659 sheet_move_range (&reverse
, NULL
, GO_CMD_CONTEXT (wbc
));
2661 me
->deleted_sheet_contents
= clipboard_copy_range (
2662 reverse
.origin_sheet
, &reverse
.origin
);
2664 /* Restore the original row heights */
2665 colrow_set_states (me
->info
.target_sheet
, FALSE
,
2666 reverse
.origin
.start
.row
, me
->saved_sizes
);
2667 colrow_state_list_destroy (me
->saved_sizes
);
2668 me
->saved_sizes
= NULL
;
2670 if (me
->reloc_undo
) {
2671 go_undo_undo (me
->reloc_undo
);
2672 g_object_unref (me
->reloc_undo
);
2673 me
->reloc_undo
= NULL
;
2676 while (me
->paste_contents
) {
2677 PasteContent
*pc
= me
->paste_contents
->data
;
2678 me
->paste_contents
= g_slist_remove (me
->paste_contents
, pc
);
2680 clipboard_paste_region (pc
->contents
, &pc
->pt
, GO_CMD_CONTEXT (wbc
));
2681 cellregion_unref (pc
->contents
);
2685 /* Force update of the status area */
2686 sheet_flag_status_update_range (me
->info
.target_sheet
, NULL
);
2688 cmd_paste_cut_update (&me
->info
, wbc
);
2690 /* Select the original region */
2691 if (me
->move_selection
&& IS_SHEET (me
->info
.origin_sheet
))
2692 select_range (me
->info
.origin_sheet
,
2700 cmd_paste_cut_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
2702 CmdPasteCut
*me
= CMD_PASTE_CUT (cmd
);
2705 g_return_val_if_fail (me
!= NULL
, TRUE
);
2706 g_return_val_if_fail (me
->paste_contents
== NULL
, TRUE
);
2708 tmp
= me
->info
.origin
;
2709 range_translate (&tmp
, me
->info
.origin_sheet
, /* FIXME: What sheet? */
2710 me
->info
.col_offset
, me
->info
.row_offset
);
2711 range_normalize (&tmp
);
2713 g_return_val_if_fail (range_is_sane (&tmp
), TRUE
);
2715 if (me
->info
.origin_sheet
!= me
->info
.target_sheet
||
2716 !range_overlap (&me
->info
.origin
, &tmp
)) {
2717 PasteContent
*pc
= g_new (PasteContent
, 1);
2718 paste_target_init (&pc
->pt
, me
->info
.target_sheet
, &tmp
, PASTE_ALL_SHEET
);
2719 pc
->contents
= clipboard_copy_range (me
->info
.target_sheet
, &tmp
);
2720 me
->paste_contents
= g_slist_prepend (me
->paste_contents
, pc
);
2722 /* need to store any portions of the paste target
2723 * that do not overlap with the source.
2725 GSList
*ptr
, *frag
= range_split_ranges (&me
->info
.origin
, &tmp
);
2726 for (ptr
= frag
; ptr
!= NULL
; ptr
= ptr
->next
) {
2727 GnmRange
*r
= ptr
->data
;
2729 if (!range_overlap (&me
->info
.origin
, r
)) {
2730 PasteContent
*pc
= g_new (PasteContent
, 1);
2731 paste_target_init (&pc
->pt
, me
->info
.target_sheet
, r
, PASTE_ALL_SHEET
);
2732 pc
->contents
= clipboard_copy_range (me
->info
.target_sheet
, r
);
2733 me
->paste_contents
= g_slist_prepend (me
->paste_contents
, pc
);
2737 g_slist_free (frag
);
2740 /* rare corner case. If the origin sheet has been deleted */
2741 if (!IS_SHEET (me
->info
.origin_sheet
)) {
2743 paste_target_init (&pt
, me
->info
.target_sheet
, &tmp
, PASTE_ALL_SHEET
);
2744 sheet_clear_region (pt
.sheet
,
2745 tmp
.start
.col
, tmp
.start
.row
, tmp
.end
.col
, tmp
.end
.row
,
2746 CLEAR_VALUES
| CLEAR_MERGES
| CLEAR_NOCHECKARRAY
| CLEAR_RECALC_DEPS
,
2747 GO_CMD_CONTEXT (wbc
));
2748 clipboard_paste_region (me
->deleted_sheet_contents
,
2749 &pt
, GO_CMD_CONTEXT (wbc
));
2750 cellregion_unref (me
->deleted_sheet_contents
);
2751 me
->deleted_sheet_contents
= NULL
;
2753 sheet_move_range (&me
->info
, &me
->reloc_undo
, GO_CMD_CONTEXT (wbc
));
2755 cmd_paste_cut_update (&me
->info
, wbc
);
2757 /* Backup row heights and adjust row heights to fit */
2758 me
->saved_sizes
= colrow_get_states (me
->info
.target_sheet
, FALSE
, tmp
.start
.row
, tmp
.end
.row
);
2759 rows_height_update (me
->info
.target_sheet
, &tmp
, FALSE
);
2761 /* Make sure the destination is selected */
2762 if (me
->move_selection
)
2763 select_range (me
->info
.target_sheet
, &tmp
, wbc
);
2769 cmd_paste_cut_finalize (GObject
*cmd
)
2771 CmdPasteCut
*me
= CMD_PASTE_CUT (cmd
);
2773 if (me
->saved_sizes
)
2774 me
->saved_sizes
= colrow_state_list_destroy (me
->saved_sizes
);
2775 while (me
->paste_contents
) {
2776 PasteContent
*pc
= me
->paste_contents
->data
;
2777 me
->paste_contents
= g_slist_remove (me
->paste_contents
, pc
);
2778 cellregion_unref (pc
->contents
);
2781 if (me
->reloc_undo
) {
2782 g_object_unref (me
->reloc_undo
);
2783 me
->reloc_undo
= NULL
;
2785 if (me
->deleted_sheet_contents
) {
2786 cellregion_unref (me
->deleted_sheet_contents
);
2787 me
->deleted_sheet_contents
= NULL
;
2790 gnm_command_finalize (cmd
);
2794 cmd_paste_cut (WorkbookControl
*wbc
, GnmExprRelocateInfo
const *info
,
2795 gboolean move_selection
, char *descriptor
)
2801 g_return_val_if_fail (info
!= NULL
, TRUE
);
2803 /* This is vacuous */
2804 if (info
->origin_sheet
== info
->target_sheet
&&
2805 info
->col_offset
== 0 && info
->row_offset
== 0)
2808 /* FIXME: Do we want to show the destination range as well ? */
2809 where
= undo_range_name (info
->origin_sheet
, &info
->origin
);
2810 if (descriptor
== NULL
)
2811 descriptor
= g_strdup_printf (_("Moving %s"), where
);
2814 g_return_val_if_fail (info
!= NULL
, TRUE
);
2817 if (range_translate (&r
, info
->target_sheet
,
2818 info
->col_offset
, info
->row_offset
)) {
2820 go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc
), descriptor
,
2821 _("is beyond sheet boundaries"));
2822 g_free (descriptor
);
2826 /* Check array subdivision & merged regions */
2827 if (sheet_range_splits_region (info
->target_sheet
, &r
,
2828 (info
->origin_sheet
== info
->target_sheet
)
2829 ? &info
->origin
: NULL
, GO_CMD_CONTEXT (wbc
), descriptor
)) {
2830 g_free (descriptor
);
2834 me
= g_object_new (CMD_PASTE_CUT_TYPE
, NULL
);
2837 me
->paste_contents
= NULL
;
2838 me
->deleted_sheet_contents
= NULL
;
2839 me
->reloc_undo
= NULL
;
2840 me
->move_selection
= move_selection
;
2841 me
->saved_sizes
= NULL
;
2843 me
->cmd
.sheet
= NULL
; /* we have potentially two different. */
2844 me
->cmd
.size
= 1; /* FIXME? */
2845 me
->cmd
.cmd_descriptor
= descriptor
;
2847 /* NOTE : if the destination workbook is different from the source
2848 * workbook should we have undo elements in both menus ?? It seems
2849 * poor form to hit undo in 1 window and effect another...
2851 * Maybe queue it as two different commands, as a clear in one book
2852 * and a paste in the other. This is not symmetric though. What
2853 * happens to the cells in the original sheet that now reference the
2854 * cells in the other? When do they reset to the original?
2856 * Probably when the clear in the original is undone.
2859 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
2862 /******************************************************************/
2865 warn_if_date_trouble (WorkbookControl
*wbc
, GnmCellRegion
*cr
)
2867 Workbook
*wb
= wb_control_get_workbook (wbc
);
2868 const GODateConventions
*wb_date_conv
= workbook_date_conv (wb
);
2870 if (cr
->date_conv
== NULL
)
2872 if (go_date_conv_equal (cr
->date_conv
, wb_date_conv
))
2875 /* We would like to show a warning, but it seems we cannot via a context. */
2878 err
= g_error_new (go_error_invalid(), 0,
2879 _("Copying between files with different date conventions.\n"
2880 "It is possible that some dates could be copied\n"
2882 go_cmd_context_error (GO_CMD_CONTEXT (wbc
), err
);
2888 #define CMD_PASTE_COPY_TYPE (cmd_paste_copy_get_type ())
2889 #define CMD_PASTE_COPY(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_PASTE_COPY_TYPE, CmdPasteCopy))
2894 GnmCellRegion
*contents
;
2895 GSList
*pasted_objects
,*orig_contents_objects
;
2897 gboolean has_been_through_cycle
;
2898 gboolean only_objects
;
2899 gboolean single_merge_to_single_merge
;
2903 cmd_paste_copy_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
2905 CmdPasteCopy
const *orig
= (CmdPasteCopy
const *) cmd
;
2906 GnmPasteTarget new_dst
;
2907 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
2908 GnmRange
const *r
= selection_first_range (sv
,
2909 GO_CMD_CONTEXT (wbc
), _("Paste Copy"));
2910 GnmCellRegion
*newcr
;
2915 paste_target_init (&new_dst
, sv_sheet (sv
), r
, orig
->dst
.paste_flags
);
2916 newcr
= clipboard_copy_range (orig
->dst
.sheet
, &orig
->dst
.range
);
2917 cmd_paste_copy (wbc
, &new_dst
, newcr
);
2918 cellregion_unref (newcr
);
2920 MAKE_GNM_COMMAND (CmdPasteCopy
, cmd_paste_copy
, cmd_paste_copy_repeat
)
2923 by_addr (gconstpointer a
, gconstpointer b
)
2925 if (GPOINTER_TO_UINT (a
) < GPOINTER_TO_UINT (b
))
2927 if (GPOINTER_TO_UINT (a
) > GPOINTER_TO_UINT (b
))
2934 * @sheet: #Sheet to query
2935 * @old: (element-type SheetObject): list of objects to disregard
2937 * Returns: (transfer full) (element-type SheetObject): A list of new objects
2938 * in sheet since @old was collected.
2941 get_new_objects (Sheet
*sheet
, GSList
*old
)
2944 g_slist_sort (g_slist_copy_deep (sheet
->sheet_objects
,
2945 (GCopyFunc
)g_object_ref
,
2948 GSList
*p
= objs
, *last
= NULL
;
2952 while (p
&& (c
= by_addr (p
->data
, old
->data
)) < 0) {
2960 GSList
*next
= p
->next
;
2974 cmd_paste_copy_select_obj (SheetObject
*so
, SheetControlGUI
*scg
)
2976 scg_object_select (scg
, so
);
2980 cmd_paste_copy_impl (GnmCommand
*cmd
, WorkbookControl
*wbc
,
2983 CmdPasteCopy
*me
= CMD_PASTE_COPY (cmd
);
2984 GnmCellRegion
*contents
;
2985 GSList
*old_objects
;
2987 g_return_val_if_fail (me
!= NULL
, TRUE
);
2988 g_return_val_if_fail (me
->contents
!= NULL
, TRUE
);
2990 g_slist_foreach (me
->pasted_objects
,
2991 (GFunc
)sheet_object_clear_sheet
,
2993 g_slist_free_full (me
->pasted_objects
, (GDestroyNotify
)g_object_unref
);
2994 me
->pasted_objects
= NULL
;
2995 old_objects
= get_new_objects (me
->dst
.sheet
, NULL
);
2997 contents
= clipboard_copy_range (me
->dst
.sheet
, &me
->dst
.range
);
2998 if (me
->has_been_through_cycle
)
2999 me
->dst
.paste_flags
=
3001 PASTE_COLUMN_WIDTHS
| PASTE_ROW_HEIGHTS
|
3002 (me
->dst
.paste_flags
& PASTE_ALL_SHEET
);
3004 if (clipboard_paste_region (me
->contents
, &me
->dst
,
3005 GO_CMD_CONTEXT (wbc
))) {
3006 /* There was a problem, avoid leaking */
3007 cellregion_unref (contents
);
3008 g_slist_free_full (old_objects
, g_object_unref
);
3012 me
->pasted_objects
= get_new_objects (me
->dst
.sheet
, old_objects
);
3013 g_slist_free_full (old_objects
, g_object_unref
);
3015 if (!is_undo
&& !me
->has_been_through_cycle
) {
3016 colrow_autofit (me
->dst
.sheet
, &me
->dst
.range
, FALSE
, FALSE
,
3019 colrow_autofit (me
->dst
.sheet
, &me
->dst
.range
, TRUE
, TRUE
,
3025 // We cannot use the random set of objects at the target
3026 // location. http://bugzilla.gnome.org/show_bug.cgi?id=308300
3027 g_slist_free_full (contents
->objects
, g_object_unref
);
3028 contents
->objects
= g_slist_copy_deep
3029 (me
->orig_contents_objects
,
3030 (GCopyFunc
)sheet_object_dup
, NULL
);
3033 for (l
= contents
->objects
; l
; l
= l
->next
) {
3034 SheetObject
*so
= l
->data
;
3035 if (sheet_object_get_sheet (so
)) {
3036 g_object_unref (so
);
3039 // Object got deleted by paste, so keep it for
3040 // undo. See bugzilla 732653
3044 g_slist_remove_all (contents
->objects
, NULL
);
3047 cellregion_unref (me
->contents
);
3048 me
->contents
= contents
;
3049 me
->has_been_through_cycle
= TRUE
;
3051 /* Select the newly pasted contents (this queues a redraw) */
3052 if (me
->only_objects
&& GNM_IS_WBC_GTK (wbc
)) {
3053 SheetControlGUI
*scg
=
3054 wbcg_get_nth_scg (WBC_GTK (wbc
),
3055 cmd
->sheet
->index_in_wb
);
3056 scg_object_unselect (scg
, NULL
);
3057 g_slist_foreach (me
->pasted_objects
,
3058 (GFunc
) cmd_paste_copy_select_obj
, scg
);
3060 select_range (me
->dst
.sheet
, &me
->dst
.range
, wbc
);
3066 cmd_paste_copy_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3068 return cmd_paste_copy_impl (cmd
, wbc
, TRUE
);
3072 cmd_paste_copy_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3074 return cmd_paste_copy_impl (cmd
, wbc
, FALSE
);
3078 cmd_paste_copy_finalize (GObject
*cmd
)
3080 CmdPasteCopy
*me
= CMD_PASTE_COPY (cmd
);
3083 cellregion_unref (me
->contents
);
3084 me
->contents
= NULL
;
3086 g_slist_free_full (me
->pasted_objects
, (GDestroyNotify
)g_object_unref
);
3087 g_slist_free_full (me
->orig_contents_objects
, (GDestroyNotify
)g_object_unref
);
3088 gnm_command_finalize (cmd
);
3095 * @cr: (transfer none):
3097 * Returns: %TRUE if there was a problem, %FALSE otherwise.
3100 cmd_paste_copy (WorkbookControl
*wbc
,
3101 GnmPasteTarget
const *pt
, GnmCellRegion
*cr
)
3104 int n_r
= 1, n_c
= 1;
3106 GnmRange
const *merge_src
;
3108 g_return_val_if_fail (pt
!= NULL
, TRUE
);
3109 g_return_val_if_fail (IS_SHEET (pt
->sheet
), TRUE
);
3110 g_return_val_if_fail (cr
!= NULL
, TRUE
);
3112 cellregion_ref (cr
);
3114 me
= g_object_new (CMD_PASTE_COPY_TYPE
, NULL
);
3116 me
->cmd
.sheet
= pt
->sheet
;
3117 me
->cmd
.size
= 1; /* FIXME? */
3119 range_name
= undo_range_name (pt
->sheet
, &pt
->range
);
3120 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Pasting into %s"),
3122 g_free (range_name
);
3126 me
->has_been_through_cycle
= FALSE
;
3127 me
->only_objects
= (cr
->cols
< 1 || cr
->rows
< 1);
3128 me
->pasted_objects
= NULL
;
3129 me
->orig_contents_objects
=
3130 g_slist_copy_deep (cr
->objects
,
3131 (GCopyFunc
)sheet_object_dup
, NULL
);
3132 me
->single_merge_to_single_merge
= FALSE
;
3134 /* If the input is only objects ignore all this range stuff */
3135 if (!me
->only_objects
) {
3136 /* see if we need to do any tiling */
3137 GnmRange
*r
= &me
->dst
.range
;
3138 if (g_slist_length (cr
->merged
) == 1 &&
3139 (NULL
!= (merge_src
= cr
->merged
->data
)) &&
3140 range_height (merge_src
) == cr
->rows
&&
3141 range_width (merge_src
) == cr
->cols
) {
3142 /* We are copying from a single merge */
3143 GnmRange
const *merge
= gnm_sheet_merge_is_corner (pt
->sheet
, &r
->start
);
3144 if (merge
!= NULL
&& range_equal (r
, merge
)) {
3145 /* To a single merge */
3146 me
->single_merge_to_single_merge
= TRUE
;
3148 me
->dst
.paste_flags
|= PASTE_DONT_MERGE
;
3153 if (pt
->paste_flags
& PASTE_TRANSPOSE
) {
3154 n_c
= range_width (r
) / cr
->rows
;
3155 if (n_c
< 1) n_c
= 1;
3156 r
->end
.col
= r
->start
.col
+ n_c
* cr
->rows
- 1;
3158 n_r
= range_height (r
) / cr
->cols
;
3159 if (n_r
< 1) n_r
= 1;
3160 r
->end
.row
= r
->start
.row
+ n_r
* cr
->cols
- 1;
3162 /* Before looking for tiling if we are not transposing,
3163 * allow pasting a full col or row from a single cell */
3164 n_c
= range_width (r
);
3165 if (n_c
== 1 && cr
->cols
== gnm_sheet_get_max_cols (me
->cmd
.sheet
)) {
3167 r
->end
.col
= gnm_sheet_get_last_col (me
->cmd
.sheet
);
3170 if (n_c
< 1) n_c
= 1;
3171 r
->end
.col
= r
->start
.col
+ n_c
* cr
->cols
- 1;
3174 n_r
= range_height (r
);
3175 if (n_r
== 1 && cr
->rows
== gnm_sheet_get_max_rows (me
->cmd
.sheet
)) {
3177 r
->end
.row
= gnm_sheet_get_last_row (me
->cmd
.sheet
);
3180 if (n_r
< 1) n_r
= 1;
3181 r
->end
.row
= r
->start
.row
+ n_r
* cr
->rows
- 1;
3185 if (cr
->cols
!= 1 || cr
->rows
!= 1) {
3186 /* Note: when the source is a single cell, a single target merge is special */
3187 /* see clipboard.c (clipboard_paste_region) */
3188 GnmRange
const *merge
= gnm_sheet_merge_is_corner (pt
->sheet
, &r
->start
);
3189 if (merge
!= NULL
&& range_equal (r
, merge
)) {
3190 /* destination is a single merge */
3191 /* enlarge it such that the source fits */
3192 if (pt
->paste_flags
& PASTE_TRANSPOSE
) {
3193 if ((r
->end
.col
- r
->start
.col
+ 1) < cr
->rows
)
3194 r
->end
.col
= r
->start
.col
+ cr
->rows
- 1;
3195 if ((r
->end
.row
- r
->start
.row
+ 1) < cr
->cols
)
3196 r
->end
.row
= r
->start
.row
+ cr
->cols
- 1;
3198 if ((r
->end
.col
- r
->start
.col
+ 1) < cr
->cols
)
3199 r
->end
.col
= r
->start
.col
+ cr
->cols
- 1;
3200 if ((r
->end
.row
- r
->start
.row
+ 1) < cr
->rows
)
3201 r
->end
.row
= r
->start
.row
+ cr
->rows
- 1;
3207 if (n_c
* (gnm_float
)n_r
> 10000.) {
3208 char *number
= g_strdup_printf ("%0.0" GNM_FORMAT_f
,
3209 (gnm_float
)n_c
* (gnm_float
)n_r
);
3210 gboolean result
= go_gtk_query_yes_no (wbcg_toplevel (WBC_GTK (wbc
)), FALSE
,
3211 _("Do you really want to paste "
3212 "%s copies?"), number
);
3215 g_object_unref (me
);
3221 /* Use translate to do a quiet sanity check */
3222 if (range_translate (&me
->dst
.range
, pt
->sheet
, 0, 0)) {
3223 go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc
),
3224 me
->cmd
.cmd_descriptor
,
3225 _("is beyond sheet boundaries"));
3226 g_object_unref (me
);
3230 /* no need to test if all we have are objects or are copying from */
3231 /*a single merge to a single merge*/
3232 if ((!me
->only_objects
) && (!me
->single_merge_to_single_merge
)&&
3233 sheet_range_splits_region (pt
->sheet
, &me
->dst
.range
,
3234 NULL
, GO_CMD_CONTEXT (wbc
), me
->cmd
.cmd_descriptor
)) {
3235 g_object_unref (me
);
3239 warn_if_date_trouble (wbc
, cr
);
3241 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
3244 /******************************************************************/
3246 #define CMD_AUTOFILL_TYPE (cmd_autofill_get_type ())
3247 #define CMD_AUTOFILL(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_AUTOFILL_TYPE, CmdAutofill))
3252 GnmCellRegion
*contents
;
3255 int base_col
, base_row
, w
, h
, end_col
, end_row
;
3256 gboolean default_increment
;
3257 gboolean inverse_autofill
;
3258 ColRowIndexList
*columns
;
3259 ColRowStateGroup
*old_widths
;
3263 cmd_autofill_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
3265 CmdAutofill
const *orig
= (CmdAutofill
const *) cmd
;
3266 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
3267 GnmRange
const *r
= selection_first_range (sv
,
3268 GO_CMD_CONTEXT (wbc
), _("Autofill"));
3273 cmd_autofill (wbc
, sv_sheet (sv
), orig
->default_increment
,
3274 r
->start
.col
, r
->start
.row
, range_width (r
), range_height (r
),
3275 r
->start
.col
+ (orig
->end_col
- orig
->base_col
),
3276 r
->start
.row
+ (orig
->end_row
- orig
->base_row
),
3277 orig
->inverse_autofill
);
3279 MAKE_GNM_COMMAND (CmdAutofill
, cmd_autofill
, cmd_autofill_repeat
)
3282 cmd_autofill_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3284 CmdAutofill
*me
= CMD_AUTOFILL (cmd
);
3287 g_return_val_if_fail (wbc
!= NULL
, TRUE
);
3288 g_return_val_if_fail (me
!= NULL
, TRUE
);
3289 g_return_val_if_fail (me
->contents
!= NULL
, TRUE
);
3291 res
= clipboard_paste_region (me
->contents
, &me
->dst
, GO_CMD_CONTEXT (wbc
));
3292 cellregion_unref (me
->contents
);
3293 me
->contents
= NULL
;
3295 if (me
->old_widths
) {
3296 colrow_restore_state_group (me
->cmd
.sheet
, TRUE
,
3299 colrow_state_group_destroy (me
->old_widths
);
3300 me
->old_widths
= NULL
;
3301 colrow_index_list_destroy (me
->columns
);
3308 select_range (me
->dst
.sheet
, &me
->src
, wbc
);
3314 cmd_autofill_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3316 CmdAutofill
*me
= CMD_AUTOFILL (cmd
);
3319 g_return_val_if_fail (me
!= NULL
, TRUE
);
3320 g_return_val_if_fail (me
->contents
== NULL
, TRUE
);
3322 me
->contents
= clipboard_copy_range (me
->dst
.sheet
, &me
->dst
.range
);
3324 g_return_val_if_fail (me
->contents
!= NULL
, TRUE
);
3326 /* FIXME : when we split autofill to support hints and better validation
3327 * move this in there.
3329 /* MW: May 2006: we support hints now. What's this about? */
3330 sheet_clear_region (me
->dst
.sheet
,
3331 me
->dst
.range
.start
.col
, me
->dst
.range
.start
.row
,
3332 me
->dst
.range
.end
.col
, me
->dst
.range
.end
.row
,
3333 CLEAR_VALUES
| CLEAR_MERGES
| CLEAR_NOCHECKARRAY
| CLEAR_RECALC_DEPS
,
3334 GO_CMD_CONTEXT (wbc
));
3336 if (me
->cmd
.size
== 1)
3337 me
->cmd
.size
+= cellregion_cmd_size (me
->contents
);
3338 if (me
->inverse_autofill
)
3339 gnm_autofill_fill (me
->dst
.sheet
, me
->default_increment
,
3340 me
->end_col
, me
->end_row
, me
->w
, me
->h
,
3341 me
->base_col
, me
->base_row
);
3343 gnm_autofill_fill (me
->dst
.sheet
, me
->default_increment
,
3344 me
->base_col
, me
->base_row
, me
->w
, me
->h
,
3345 me
->end_col
, me
->end_row
);
3347 colrow_autofit (me
->cmd
.sheet
, &me
->dst
.range
, TRUE
, TRUE
,
3349 &me
->columns
, &me
->old_widths
);
3351 sheet_region_queue_recalc (me
->dst
.sheet
, &me
->dst
.range
);
3352 sheet_range_calc_spans (me
->dst
.sheet
, &me
->dst
.range
, GNM_SPANCALC_RENDER
);
3353 sheet_flag_status_update_range (me
->dst
.sheet
, &me
->dst
.range
);
3355 r
= range_union (&me
->dst
.range
, &me
->src
);
3356 select_range (me
->dst
.sheet
, &r
, wbc
);
3362 cmd_autofill_finalize (GObject
*cmd
)
3364 CmdAutofill
*me
= CMD_AUTOFILL (cmd
);
3367 cellregion_unref (me
->contents
);
3368 me
->contents
= NULL
;
3370 colrow_index_list_destroy (me
->columns
);
3371 colrow_state_group_destroy (me
->old_widths
);
3372 gnm_command_finalize (cmd
);
3376 cmd_autofill (WorkbookControl
*wbc
, Sheet
*sheet
,
3377 gboolean default_increment
,
3378 int base_col
, int base_row
,
3379 int w
, int h
, int end_col
, int end_row
,
3380 gboolean inverse_autofill
)
3383 GnmRange target
, src
;
3385 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
3387 /* This would be meaningless */
3388 if (base_col
+w
-1 == end_col
&& base_row
+h
-1 == end_row
)
3391 if (inverse_autofill
) {
3392 if (end_col
!= base_col
+ w
- 1) {
3393 range_init (&target
, base_col
, base_row
,
3394 end_col
- w
, end_row
);
3395 range_init (&src
, end_col
- w
+ 1, base_row
,
3398 range_init (&target
, base_col
, base_row
,
3399 end_col
, end_row
- h
);
3400 range_init (&src
, base_col
, end_row
- h
+ 1,
3404 if (end_col
!= base_col
+ w
- 1) {
3405 range_init (&target
, base_col
+ w
, base_row
,
3407 range_init (&src
, base_col
, base_row
,
3408 base_col
+ w
- 1, end_row
);
3410 range_init (&target
, base_col
, base_row
+ h
,
3412 range_init (&src
, base_col
, base_row
,
3413 end_col
, base_row
+ h
- 1);
3417 /* We don't support clearing regions, when a user uses the autofill
3418 * cursor to 'shrink' a selection
3420 if (target
.start
.col
> target
.end
.col
|| target
.start
.row
> target
.end
.row
)
3423 /* Check arrays or merged regions in src or target regions */
3424 if (sheet_range_splits_region (sheet
, &target
, NULL
, GO_CMD_CONTEXT (wbc
), _("Autofill")) ||
3425 sheet_range_splits_region (sheet
, &src
, NULL
, GO_CMD_CONTEXT (wbc
), _("Autofill")))
3428 me
= g_object_new (CMD_AUTOFILL_TYPE
, NULL
);
3430 me
->contents
= NULL
;
3431 me
->dst
.sheet
= sheet
;
3432 me
->dst
.paste_flags
= PASTE_CONTENTS
| PASTE_FORMATS
;
3433 me
->dst
.range
= target
;
3436 me
->base_col
= base_col
;
3437 me
->base_row
= base_row
,
3440 me
->end_col
= end_col
;
3441 me
->end_row
= end_row
;
3442 me
->default_increment
= default_increment
;
3443 me
->inverse_autofill
= inverse_autofill
;
3445 me
->cmd
.sheet
= sheet
;
3446 me
->cmd
.size
= 1; /* Changed in initial redo. */
3447 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Autofilling %s"),
3448 range_as_string (&me
->dst
.range
));
3450 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
3453 /******************************************************************/
3455 #define CMD_COPYREL_TYPE (cmd_copyrel_get_type ())
3456 #define CMD_COPYREL(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_COPYREL_TYPE, CmdCopyRel))
3462 GnmPasteTarget dst
, src
;
3468 cmd_copyrel_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
3470 CmdCopyRel
const *orig
= (CmdCopyRel
const *) cmd
;
3471 cmd_copyrel (wbc
, orig
->dx
, orig
->dy
, orig
->name
);
3473 MAKE_GNM_COMMAND (CmdCopyRel
, cmd_copyrel
, cmd_copyrel_repeat
)
3476 cmd_copyrel_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3478 CmdCopyRel
*me
= CMD_COPYREL (cmd
);
3480 g_return_val_if_fail (wbc
!= NULL
, TRUE
);
3481 g_return_val_if_fail (me
!= NULL
, TRUE
);
3482 g_return_val_if_fail (me
->undo
!= NULL
, TRUE
);
3484 go_undo_undo (me
->undo
);
3486 /* Select the newly pasted contents (this queues a redraw) */
3487 select_range (me
->dst
.sheet
, &me
->dst
.range
, wbc
);
3493 cmd_copyrel_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3495 CmdCopyRel
*me
= CMD_COPYREL (cmd
);
3496 GnmCellRegion
*contents
;
3499 g_return_val_if_fail (me
!= NULL
, TRUE
);
3501 sheet_clear_region (me
->dst
.sheet
,
3502 me
->dst
.range
.start
.col
, me
->dst
.range
.start
.row
,
3503 me
->dst
.range
.end
.col
, me
->dst
.range
.end
.row
,
3504 CLEAR_VALUES
| CLEAR_MERGES
| CLEAR_NOCHECKARRAY
| CLEAR_RECALC_DEPS
,
3505 GO_CMD_CONTEXT (wbc
));
3507 contents
= clipboard_copy_range (me
->src
.sheet
, &me
->src
.range
);
3508 res
= clipboard_paste_region (contents
, &me
->dst
, GO_CMD_CONTEXT (wbc
));
3509 cellregion_unref (contents
);
3513 sheet_region_queue_recalc (me
->dst
.sheet
, &me
->dst
.range
);
3514 sheet_range_calc_spans (me
->dst
.sheet
, &me
->dst
.range
, GNM_SPANCALC_RENDER
);
3515 sheet_flag_status_update_range (me
->dst
.sheet
, &me
->dst
.range
);
3517 /* Select the newly pasted contents (this queues a redraw) */
3518 select_range (me
->dst
.sheet
, &me
->dst
.range
, wbc
);
3524 cmd_copyrel_finalize (GObject
*cmd
)
3526 CmdCopyRel
*me
= CMD_COPYREL (cmd
);
3529 g_object_unref (me
->undo
);
3531 gnm_command_finalize (cmd
);
3535 cmd_copyrel (WorkbookControl
*wbc
,
3540 GnmRange target
, src
;
3541 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
3542 Sheet
*sheet
= sv
->sheet
;
3543 GnmRange
const *selr
=
3544 selection_first_range (sv
, GO_CMD_CONTEXT (wbc
), name
);
3546 g_return_val_if_fail (dx
== 0 || dy
== 0, TRUE
);
3552 range_normalize (&target
);
3553 src
.start
= src
.end
= target
.start
;
3556 src
.end
.col
= target
.end
.col
;
3557 if (target
.start
.row
!= target
.end
.row
)
3560 src
.start
.row
= src
.end
.row
= (target
.start
.row
+ dy
);
3564 src
.end
.row
= target
.end
.row
;
3565 if (target
.start
.col
!= target
.end
.col
)
3568 src
.start
.col
= src
.end
.col
= (target
.start
.col
+ dx
);
3571 if (src
.start
.col
< 0 || src
.start
.col
>= gnm_sheet_get_max_cols (sheet
) ||
3572 src
.start
.row
< 0 || src
.start
.row
>= gnm_sheet_get_max_rows (sheet
))
3575 /* Check arrays or merged regions in src or target regions */
3576 if (sheet_range_splits_region (sheet
, &target
, NULL
, GO_CMD_CONTEXT (wbc
), name
) ||
3577 sheet_range_splits_region (sheet
, &src
, NULL
, GO_CMD_CONTEXT (wbc
), name
))
3580 me
= g_object_new (CMD_COPYREL_TYPE
, NULL
);
3582 me
->dst
.sheet
= sheet
;
3583 me
->dst
.paste_flags
= PASTE_CONTENTS
| PASTE_FORMATS
;
3584 me
->dst
.range
= target
;
3585 me
->src
.sheet
= sheet
;
3586 me
->src
.paste_flags
= PASTE_CONTENTS
| PASTE_FORMATS
;
3587 me
->src
.range
= src
;
3591 me
->undo
= clipboard_copy_range_undo (me
->dst
.sheet
, &me
->dst
.range
);
3593 me
->cmd
.sheet
= sheet
;
3595 me
->cmd
.cmd_descriptor
= g_strdup (name
);
3597 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
3600 /******************************************************************/
3603 #define CMD_AUTOFORMAT_TYPE (cmd_autoformat_get_type ())
3604 #define CMD_AUTOFORMAT(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_AUTOFORMAT_TYPE, CmdAutoFormat))
3608 GnmStyleList
*styles
;
3609 } CmdAutoFormatOldStyle
;
3614 GSList
*selection
; /* Selections on the sheet */
3615 GSList
*old_styles
; /* Older styles, one style_list per selection range*/
3617 GnmFT
*ft
; /* Template that has been applied */
3621 cmd_autoformat_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
3623 CmdAutoFormat
const *orig
= (CmdAutoFormat
const *) cmd
;
3624 cmd_selection_autoformat (wbc
, gnm_ft_clone (orig
->ft
));
3626 MAKE_GNM_COMMAND (CmdAutoFormat
, cmd_autoformat
, cmd_autoformat_repeat
)
3629 cmd_autoformat_undo (GnmCommand
*cmd
,
3630 G_GNUC_UNUSED WorkbookControl
*wbc
)
3632 CmdAutoFormat
*me
= CMD_AUTOFORMAT (cmd
);
3634 g_return_val_if_fail (me
!= NULL
, TRUE
);
3636 if (me
->old_styles
) {
3637 GSList
*l1
= me
->old_styles
;
3638 GSList
*l2
= me
->selection
;
3640 for (; l1
; l1
= l1
->next
, l2
= l2
->next
) {
3642 CmdAutoFormatOldStyle
*os
= l1
->data
;
3643 GnmSpanCalcFlags flags
= sheet_style_set_list (me
->cmd
.sheet
,
3644 &os
->pos
, os
->styles
, NULL
, NULL
);
3646 g_return_val_if_fail (l2
&& l2
->data
, TRUE
);
3649 sheet_range_calc_spans (me
->cmd
.sheet
, r
, flags
);
3650 if (flags
!= GNM_SPANCALC_SIMPLE
)
3651 rows_height_update (me
->cmd
.sheet
, r
, TRUE
);
3659 cmd_autoformat_redo (GnmCommand
*cmd
,
3660 G_GNUC_UNUSED WorkbookControl
*wbc
)
3662 CmdAutoFormat
*me
= CMD_AUTOFORMAT (cmd
);
3664 g_return_val_if_fail (me
!= NULL
, TRUE
);
3666 gnm_ft_apply_to_sheet_regions (me
->ft
,
3667 me
->cmd
.sheet
, me
->selection
);
3673 cmd_autoformat_finalize (GObject
*cmd
)
3675 CmdAutoFormat
*me
= CMD_AUTOFORMAT (cmd
);
3677 if (me
->old_styles
!= NULL
) {
3680 for (l
= me
->old_styles
; l
!= NULL
; l
= g_slist_remove (l
, l
->data
)) {
3681 CmdAutoFormatOldStyle
*os
= l
->data
;
3684 style_list_free (os
->styles
);
3689 me
->old_styles
= NULL
;
3692 range_fragment_free (me
->selection
);
3693 me
->selection
= NULL
;
3695 gnm_ft_free (me
->ft
);
3697 gnm_command_finalize (cmd
);
3701 * cmd_selection_autoformat:
3702 * @wbc: the context.
3703 * @ft: The format template that was applied
3705 * Returns: %TRUE if there was a problem, %FALSE otherwise.
3708 cmd_selection_autoformat (WorkbookControl
*wbc
, GnmFT
*ft
)
3713 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
3715 me
= g_object_new (CMD_AUTOFORMAT_TYPE
, NULL
);
3717 me
->selection
= selection_get_ranges (sv
, FALSE
); /* Regions may overlap */
3719 me
->cmd
.sheet
= sv_sheet (sv
);
3720 me
->cmd
.size
= 1; /* FIXME? */
3722 if (!gnm_ft_check_valid (ft
, me
->selection
, GO_CMD_CONTEXT (wbc
))) {
3723 g_object_unref (me
);
3727 me
->old_styles
= NULL
;
3728 for (l
= me
->selection
; l
; l
= l
->next
) {
3729 CmdFormatOldStyle
*os
;
3730 GnmRange range
= *((GnmRange
const *) l
->data
);
3732 /* Store the containing range to handle borders */
3733 if (range
.start
.col
> 0) range
.start
.col
--;
3734 if (range
.start
.row
> 0) range
.start
.row
--;
3735 if (range
.end
.col
< gnm_sheet_get_last_col (sv
->sheet
)) range
.end
.col
++;
3736 if (range
.end
.row
< gnm_sheet_get_last_row (sv
->sheet
)) range
.end
.row
++;
3738 os
= g_new (CmdFormatOldStyle
, 1);
3740 os
->styles
= sheet_style_get_range (me
->cmd
.sheet
, &range
);
3741 os
->pos
= range
.start
;
3743 me
->old_styles
= g_slist_append (me
->old_styles
, os
);
3746 names
= undo_range_list_name (me
->cmd
.sheet
, me
->selection
);
3747 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Autoformatting %s"),
3751 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
3754 /******************************************************************/
3756 #define CMD_UNMERGE_CELLS_TYPE (cmd_unmerge_cells_get_type ())
3757 #define CMD_UNMERGE_CELLS(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_UNMERGE_CELLS_TYPE, CmdUnmergeCells))
3763 GArray
*unmerged_regions
;
3768 cmd_unmerge_cells_repeat (G_GNUC_UNUSED GnmCommand
const *cmd
, WorkbookControl
*wbc
)
3770 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
3771 GSList
*range_list
= selection_get_ranges (sv
, FALSE
);
3772 cmd_unmerge_cells (wbc
, sv_sheet (sv
), range_list
);
3773 range_fragment_free (range_list
);
3775 MAKE_GNM_COMMAND (CmdUnmergeCells
, cmd_unmerge_cells
, cmd_unmerge_cells_repeat
)
3778 cmd_unmerge_cells_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3780 CmdUnmergeCells
*me
= CMD_UNMERGE_CELLS (cmd
);
3783 g_return_val_if_fail (me
!= NULL
, TRUE
);
3784 g_return_val_if_fail (me
->unmerged_regions
!= NULL
, TRUE
);
3786 for (i
= 0 ; i
< me
->unmerged_regions
->len
; ++i
) {
3787 GnmRange
const *tmp
= &(g_array_index (me
->unmerged_regions
, GnmRange
, i
));
3788 sheet_redraw_range (me
->cmd
.sheet
, tmp
);
3789 gnm_sheet_merge_add (me
->cmd
.sheet
, tmp
, TRUE
, GO_CMD_CONTEXT (wbc
));
3790 sheet_range_calc_spans (me
->cmd
.sheet
, tmp
, GNM_SPANCALC_RE_RENDER
);
3793 g_array_free (me
->unmerged_regions
, TRUE
);
3794 me
->unmerged_regions
= NULL
;
3800 cmd_unmerge_cells_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3802 CmdUnmergeCells
*me
= CMD_UNMERGE_CELLS (cmd
);
3805 g_return_val_if_fail (me
!= NULL
, TRUE
);
3806 g_return_val_if_fail (me
->unmerged_regions
== NULL
, TRUE
);
3808 me
->unmerged_regions
= g_array_new (FALSE
, FALSE
, sizeof (GnmRange
));
3809 for (i
= 0 ; i
< me
->ranges
->len
; ++i
) {
3810 GSList
*ptr
, *merged
= gnm_sheet_merge_get_overlap (me
->cmd
.sheet
,
3811 &(g_array_index (me
->ranges
, GnmRange
, i
)));
3812 for (ptr
= merged
; ptr
!= NULL
; ptr
= ptr
->next
) {
3813 GnmRange
const *pr
= ptr
->data
;
3814 GnmRange
const tmp
= *pr
;
3815 g_array_append_val (me
->unmerged_regions
, tmp
);
3816 gnm_sheet_merge_remove (me
->cmd
.sheet
, &tmp
);
3817 sheet_range_calc_spans (me
->cmd
.sheet
, &tmp
,
3818 GNM_SPANCALC_RE_RENDER
);
3820 g_slist_free (merged
);
3827 cmd_unmerge_cells_finalize (GObject
*cmd
)
3829 CmdUnmergeCells
*me
= CMD_UNMERGE_CELLS (cmd
);
3831 if (me
->unmerged_regions
!= NULL
) {
3832 g_array_free (me
->unmerged_regions
, TRUE
);
3833 me
->unmerged_regions
= NULL
;
3835 if (me
->ranges
!= NULL
) {
3836 g_array_free (me
->ranges
, TRUE
);
3840 gnm_command_finalize (cmd
);
3844 * cmd_unmerge_cells:
3845 * @wbc: the context.
3847 * @selection: (element-type GnmRange): selection.
3849 * Returns: %TRUE if there was a problem, %FALSE otherwise.
3852 cmd_unmerge_cells (WorkbookControl
*wbc
, Sheet
*sheet
, GSList
const *selection
)
3854 CmdUnmergeCells
*me
;
3857 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
3859 me
= g_object_new (CMD_UNMERGE_CELLS_TYPE
, NULL
);
3861 me
->cmd
.sheet
= sheet
;
3864 names
= undo_range_list_name (sheet
, selection
);
3865 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Unmerging %s"), names
);
3868 me
->unmerged_regions
= NULL
;
3869 me
->ranges
= g_array_new (FALSE
, FALSE
, sizeof (GnmRange
));
3870 for ( ; selection
!= NULL
; selection
= selection
->next
) {
3871 GSList
*merged
= gnm_sheet_merge_get_overlap (sheet
, selection
->data
);
3872 if (merged
!= NULL
) {
3873 g_array_append_val (me
->ranges
, *(GnmRange
*)selection
->data
);
3874 g_slist_free (merged
);
3878 if (me
->ranges
->len
<= 0) {
3879 g_object_unref (me
);
3883 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
3886 /******************************************************************/
3888 #define CMD_MERGE_CELLS_TYPE (cmd_merge_cells_get_type ())
3889 #define CMD_MERGE_CELLS(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_MERGE_CELLS_TYPE, CmdMergeCells))
3894 GSList
*old_contents
;
3899 cmd_merge_cells_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
);
3901 MAKE_GNM_COMMAND (CmdMergeCells
, cmd_merge_cells
, cmd_merge_cells_repeat
)
3904 cmd_merge_cells_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
3906 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
3907 GSList
*range_list
= selection_get_ranges (sv
, FALSE
);
3908 cmd_merge_cells (wbc
, sv_sheet (sv
), range_list
,
3909 CMD_MERGE_CELLS (cmd
)->center
);
3910 range_fragment_free (range_list
);
3914 cmd_merge_cells_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3916 CmdMergeCells
*me
= CMD_MERGE_CELLS (cmd
);
3919 g_return_val_if_fail (me
!= NULL
, TRUE
);
3921 for (i
= 0 ; i
< me
->ranges
->len
; ++i
) {
3922 GnmRange
const *r
= &(g_array_index (me
->ranges
, GnmRange
, i
));
3923 gnm_sheet_merge_remove (me
->cmd
.sheet
, r
);
3926 /* Avoid pasting comments that are at 0,0. Redo copies the target
3927 * region (including all comments) . If there was a comment in the top
3928 * left we would end up duplicating it. */
3929 flags
= PASTE_CONTENTS
| PASTE_FORMATS
| PASTE_COMMENTS
|
3930 PASTE_IGNORE_COMMENTS_AT_ORIGIN
;
3932 flags
|= PASTE_FORMATS
;
3933 for (i
= 0 ; i
< me
->ranges
->len
; ++i
) {
3934 GnmRange
const *r
= &(g_array_index (me
->ranges
, GnmRange
, i
));
3938 g_return_val_if_fail (me
->old_contents
!= NULL
, TRUE
);
3940 c
= me
->old_contents
->data
;
3941 clipboard_paste_region (c
,
3942 paste_target_init (&pt
, me
->cmd
.sheet
, r
, flags
),
3943 GO_CMD_CONTEXT (wbc
));
3944 cellregion_unref (c
);
3945 me
->old_contents
= g_slist_remove (me
->old_contents
, c
);
3947 g_return_val_if_fail (me
->old_contents
== NULL
, TRUE
);
3953 cmd_merge_cells_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
3955 CmdMergeCells
*me
= CMD_MERGE_CELLS (cmd
);
3956 GnmStyle
*align_center
= NULL
;
3960 g_return_val_if_fail (me
!= NULL
, TRUE
);
3963 align_center
= gnm_style_new ();
3964 gnm_style_set_align_h (align_center
, GNM_HALIGN_CENTER
);
3966 sheet
= me
->cmd
.sheet
;
3967 for (i
= 0 ; i
< me
->ranges
->len
; ++i
) {
3968 GnmRange
const *r
= &(g_array_index (me
->ranges
, GnmRange
, i
));
3969 GSList
*ptr
, *merged
= gnm_sheet_merge_get_overlap (sheet
, r
);
3971 /* save contents before removing contained merged regions */
3972 me
->old_contents
= g_slist_prepend (me
->old_contents
,
3973 clipboard_copy_range (sheet
, r
));
3974 for (ptr
= merged
; ptr
!= NULL
; ptr
= ptr
->next
)
3975 gnm_sheet_merge_remove (sheet
, ptr
->data
);
3976 g_slist_free (merged
);
3978 gnm_sheet_merge_add (sheet
, r
, TRUE
, GO_CMD_CONTEXT (wbc
));
3980 sheet_apply_style (me
->cmd
.sheet
, r
, align_center
);
3984 gnm_style_unref (align_center
);
3985 me
->old_contents
= g_slist_reverse (me
->old_contents
);
3990 cmd_merge_cells_finalize (GObject
*cmd
)
3992 CmdMergeCells
*me
= CMD_MERGE_CELLS (cmd
);
3994 if (me
->old_contents
!= NULL
) {
3996 for (l
= me
->old_contents
; l
!= NULL
; l
= g_slist_remove (l
, l
->data
))
3997 cellregion_unref (l
->data
);
3998 me
->old_contents
= NULL
;
4001 if (me
->ranges
!= NULL
) {
4002 g_array_free (me
->ranges
, TRUE
);
4006 gnm_command_finalize (cmd
);
4011 * @wbc: the context.
4013 * @selection: (element-type GnmRange): selection.
4016 * Returns: %TRUE if there was a problem, %FALSE otherwise.
4019 cmd_merge_cells (WorkbookControl
*wbc
, Sheet
*sheet
, GSList
const *selection
,
4025 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
4027 me
= g_object_new (CMD_MERGE_CELLS_TYPE
, NULL
);
4029 me
->cmd
.sheet
= sheet
;
4032 names
= undo_range_list_name (sheet
, selection
);
4033 me
->cmd
.cmd_descriptor
=
4034 g_strdup_printf ((center
? _("Merge and Center %s") :_("Merging %s")), names
);
4037 me
->center
= center
;
4038 me
->ranges
= g_array_new (FALSE
, FALSE
, sizeof (GnmRange
));
4039 for ( ; selection
!= NULL
; selection
= selection
->next
) {
4040 GnmRange
const *exist
;
4041 GnmRange
const *r
= selection
->data
;
4042 if (range_is_singleton (selection
->data
))
4044 if (NULL
!= (exist
= gnm_sheet_merge_is_corner (sheet
, &r
->start
)) &&
4045 range_equal (r
, exist
))
4047 g_array_append_val (me
->ranges
, *(GnmRange
*)selection
->data
);
4050 if (me
->ranges
->len
<= 0) {
4051 g_object_unref (me
);
4055 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
4058 /******************************************************************/
4060 #define CMD_SEARCH_REPLACE_TYPE (cmd_search_replace_get_type())
4061 #define CMD_SEARCH_REPLACE(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SEARCH_REPLACE_TYPE, CmdSearchReplace))
4065 GnmSearchReplace
*sr
;
4068 * Undo/redo use this list of SearchReplaceItems to do their
4069 * work. Note, that it is possible for a cell to occur
4070 * multiple times in the list.
4075 MAKE_GNM_COMMAND (CmdSearchReplace
, cmd_search_replace
, NULL
)
4077 typedef enum { SRI_text
, SRI_comment
} SearchReplaceItemType
;
4081 SearchReplaceItemType old_type
, new_type
;
4086 } SearchReplaceItem
;
4090 cmd_search_replace_update_after_action (CmdSearchReplace
*me
,
4091 WorkbookControl
*wbc
)
4094 Sheet
*last_sheet
= NULL
;
4096 for (tmp
= me
->cells
; tmp
; tmp
= tmp
->next
) {
4097 SearchReplaceItem
*sri
= tmp
->data
;
4098 if (sri
->pos
.sheet
!= last_sheet
) {
4099 last_sheet
= sri
->pos
.sheet
;
4100 update_after_action (last_sheet
, wbc
);
4107 cmd_search_replace_undo (GnmCommand
*cmd
,
4108 WorkbookControl
*wbc
)
4110 CmdSearchReplace
*me
= CMD_SEARCH_REPLACE (cmd
);
4113 /* Undo does replacements backwards. */
4114 for (tmp
= g_list_last (me
->cells
); tmp
; tmp
= tmp
->prev
) {
4115 SearchReplaceItem
*sri
= tmp
->data
;
4116 switch (sri
->old_type
) {
4119 GnmCell
*cell
= sheet_cell_get (sri
->pos
.sheet
,
4122 sheet_cell_set_text (cell
, sri
->old
.text
, NULL
);
4127 GnmComment
*comment
=
4128 sheet_get_comment (sri
->pos
.sheet
,
4131 cell_comment_text_set (comment
, sri
->old
.comment
);
4133 g_warning ("Undo/redo broken.");
4139 cmd_search_replace_update_after_action (me
, wbc
);
4145 cmd_search_replace_redo (GnmCommand
*cmd
,
4146 WorkbookControl
*wbc
)
4148 CmdSearchReplace
*me
= CMD_SEARCH_REPLACE (cmd
);
4151 /* Redo does replacements forward. */
4152 for (tmp
= me
->cells
; tmp
; tmp
= tmp
->next
) {
4153 SearchReplaceItem
*sri
= tmp
->data
;
4154 switch (sri
->new_type
) {
4157 GnmCell
*cell
= sheet_cell_get (sri
->pos
.sheet
,
4160 sheet_cell_set_text (cell
, sri
->new.text
, NULL
);
4165 GnmComment
*comment
=
4166 sheet_get_comment (sri
->pos
.sheet
,
4169 cell_comment_text_set (comment
, sri
->new.comment
);
4171 g_warning ("Undo/redo broken.");
4177 cmd_search_replace_update_after_action (me
, wbc
);
4183 cmd_search_replace_do_cell (CmdSearchReplace
*me
, GnmEvalPos
*ep
,
4186 GnmSearchReplace
*sr
= me
->sr
;
4188 GnmSearchReplaceCellResult cell_res
;
4189 GnmSearchReplaceCommentResult comment_res
;
4191 if (gnm_search_replace_cell (sr
, ep
, TRUE
, &cell_res
)) {
4192 GnmExprTop
const *texpr
;
4197 parse_pos_init_evalpos (&pp
, ep
);
4198 parse_text_value_or_expr (&pp
, cell_res
.new_text
, &val
, &texpr
);
4201 * FIXME: this is a hack, but parse_text_value_or_expr
4202 * does not have a better way of signaling an error.
4205 gnm_expr_char_start_p (cell_res
.new_text
) &&
4206 !go_format_is_text (gnm_cell_get_format (cell_res
.cell
)));
4207 value_release (val
);
4208 if (texpr
) gnm_expr_top_unref (texpr
);
4212 gnm_search_replace_query_fail (sr
, &cell_res
);
4213 g_free (cell_res
.old_text
);
4214 g_free (cell_res
.new_text
);
4217 switch (sr
->error_behaviour
) {
4218 case GNM_SRE_ERROR
: {
4219 GnmExprTop
const *ee
=
4221 (gnm_expr_new_funcall1
4222 (gnm_func_lookup ("ERROR", NULL
),
4223 gnm_expr_new_constant
4224 (value_new_string_nocopy (cell_res
.new_text
))));
4225 GnmConventionsOut out
;
4227 out
.accum
= g_string_new ("=");
4229 out
.convs
= pp
.sheet
->convs
;
4230 gnm_expr_top_as_gstring (ee
, &out
);
4231 gnm_expr_top_unref (ee
);
4232 cell_res
.new_text
= g_string_free (out
.accum
, FALSE
);
4236 case GNM_SRE_STRING
: {
4237 GString
*s
= g_string_new ("'");
4238 g_string_append (s
, cell_res
.new_text
);
4239 g_free (cell_res
.new_text
);
4240 cell_res
.new_text
= g_string_free (s
, FALSE
);
4245 g_assert_not_reached ();
4253 if (!err
&& !test_run
) {
4254 int res
= gnm_search_replace_query_cell
4256 gboolean doit
= (res
== GTK_RESPONSE_YES
);
4258 if (res
== GTK_RESPONSE_CANCEL
) {
4259 g_free (cell_res
.old_text
);
4260 g_free (cell_res
.new_text
);
4265 SearchReplaceItem
*sri
= g_new (SearchReplaceItem
, 1);
4267 sheet_cell_set_text (cell_res
.cell
, cell_res
.new_text
, NULL
);
4270 sri
->old_type
= sri
->new_type
= SRI_text
;
4271 sri
->old
.text
= cell_res
.old_text
;
4272 sri
->new.text
= cell_res
.new_text
;
4273 me
->cells
= g_list_prepend (me
->cells
, sri
);
4275 cell_res
.old_text
= cell_res
.new_text
= NULL
;
4279 g_free (cell_res
.new_text
);
4280 g_free (cell_res
.old_text
);
4284 gnm_search_replace_comment (sr
, ep
, TRUE
, &comment_res
)) {
4285 int res
= gnm_search_replace_query_comment
4286 (sr
, ep
, &comment_res
);
4287 gboolean doit
= (res
== GTK_RESPONSE_YES
);
4290 SearchReplaceItem
*sri
= g_new (SearchReplaceItem
, 1);
4292 sri
->old_type
= sri
->new_type
= SRI_comment
;
4293 sri
->old
.comment
= g_strdup (comment_res
.old_text
);
4294 sri
->new.comment
= comment_res
.new_text
;
4295 me
->cells
= g_list_prepend (me
->cells
, sri
);
4297 cell_comment_text_set (comment_res
.comment
, comment_res
.new_text
);
4299 g_free (comment_res
.new_text
);
4300 if (res
== GTK_RESPONSE_CANCEL
)
4310 cmd_search_replace_do (CmdSearchReplace
*me
, gboolean test_run
,
4311 WorkbookControl
*wbc
)
4313 GnmSearchReplace
*sr
= me
->sr
;
4315 gboolean result
= FALSE
;
4319 switch (sr
->error_behaviour
) {
4323 case GNM_SRE_STRING
:
4324 /* An error is not a problem. */
4332 cells
= gnm_search_collect_cells (sr
);
4334 for (i
= 0; i
< cells
->len
; i
++) {
4335 GnmEvalPos
*ep
= g_ptr_array_index (cells
, i
);
4337 if (cmd_search_replace_do_cell (me
, ep
, test_run
)) {
4343 gnm_search_collect_cells_free (cells
);
4346 /* Cells were added in the wrong order. Correct. */
4347 me
->cells
= g_list_reverse (me
->cells
);
4349 cmd_search_replace_update_after_action (me
, wbc
);
4357 cmd_search_replace_finalize (GObject
*cmd
)
4359 CmdSearchReplace
*me
= CMD_SEARCH_REPLACE (cmd
);
4362 for (tmp
= me
->cells
; tmp
; tmp
= tmp
->next
) {
4363 SearchReplaceItem
*sri
= tmp
->data
;
4364 switch (sri
->old_type
) {
4366 g_free (sri
->old
.text
);
4369 g_free (sri
->old
.comment
);
4372 switch (sri
->new_type
) {
4374 g_free (sri
->new.text
);
4377 g_free (sri
->new.comment
);
4382 g_list_free (me
->cells
);
4383 g_object_unref (me
->sr
);
4385 gnm_command_finalize (cmd
);
4389 cmd_search_replace (WorkbookControl
*wbc
, GnmSearchReplace
*sr
)
4391 CmdSearchReplace
*me
;
4393 g_return_val_if_fail (sr
!= NULL
, TRUE
);
4395 me
= g_object_new (CMD_SEARCH_REPLACE_TYPE
, NULL
);
4398 me
->sr
= g_object_ref (sr
);
4400 me
->cmd
.sheet
= NULL
;
4401 me
->cmd
.size
= 1; /* Corrected below. */
4402 me
->cmd
.cmd_descriptor
= g_strdup (_("Search and Replace"));
4404 if (cmd_search_replace_do (me
, TRUE
, wbc
)) {
4405 /* There was an error and nothing was done. */
4406 g_object_unref (me
);
4410 cmd_search_replace_do (me
, FALSE
, wbc
);
4411 me
->cmd
.size
+= g_list_length (me
->cells
);
4413 command_register_undo (wbc
, G_OBJECT (me
));
4417 /******************************************************************/
4419 #define CMD_COLROW_STD_SIZE_TYPE (cmd_colrow_std_size_get_type ())
4420 #define CMD_COLROW_STD_SIZE(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_COLROW_STD_SIZE_TYPE, CmdColRowStdSize))
4431 MAKE_GNM_COMMAND (CmdColRowStdSize
, cmd_colrow_std_size
, NULL
)
4434 cmd_colrow_std_size_undo (GnmCommand
*cmd
,
4435 G_GNUC_UNUSED WorkbookControl
*wbc
)
4437 CmdColRowStdSize
*me
= CMD_COLROW_STD_SIZE (cmd
);
4439 g_return_val_if_fail (me
!= NULL
, TRUE
);
4440 g_return_val_if_fail (me
->old_default
!= 0, TRUE
);
4443 sheet_col_set_default_size_pts (me
->sheet
, me
->old_default
);
4445 sheet_row_set_default_size_pts (me
->sheet
, me
->old_default
);
4447 me
->old_default
= 0;
4453 cmd_colrow_std_size_redo (GnmCommand
*cmd
,
4454 G_GNUC_UNUSED WorkbookControl
*wbc
)
4456 CmdColRowStdSize
*me
= CMD_COLROW_STD_SIZE (cmd
);
4458 g_return_val_if_fail (me
!= NULL
, TRUE
);
4459 g_return_val_if_fail (me
->old_default
== 0, TRUE
);
4462 me
->old_default
= sheet_col_get_default_size_pts (me
->sheet
);
4463 sheet_col_set_default_size_pts (me
->sheet
, me
->new_default
);
4465 me
->old_default
= sheet_row_get_default_size_pts (me
->sheet
);
4466 sheet_row_set_default_size_pts (me
->sheet
, me
->new_default
);
4472 cmd_colrow_std_size_finalize (GObject
*cmd
)
4474 gnm_command_finalize (cmd
);
4478 cmd_colrow_std_size (WorkbookControl
*wbc
, Sheet
*sheet
,
4479 gboolean is_cols
, double new_default
)
4481 CmdColRowStdSize
*me
;
4483 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
4485 me
= g_object_new (CMD_COLROW_STD_SIZE_TYPE
, NULL
);
4488 me
->is_cols
= is_cols
;
4489 me
->new_default
= new_default
;
4490 me
->old_default
= 0;
4492 me
->cmd
.sheet
= sheet
;
4493 me
->cmd
.size
= 1; /* Changed in initial redo. */
4494 me
->cmd
.cmd_descriptor
= is_cols
4495 ? g_strdup_printf (_("Setting default width of columns to %.2fpts"), new_default
)
4496 : g_strdup_printf (_("Setting default height of rows to %.2fpts"), new_default
);
4498 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
4501 /******************************************************************/
4503 #define CMD_ZOOM_TYPE (cmd_zoom_get_type ())
4504 #define CMD_ZOOM(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_ZOOM_TYPE, CmdZoom))
4511 double *old_factors
;
4514 MAKE_GNM_COMMAND (CmdZoom
, cmd_zoom
, NULL
)
4517 cmd_zoom_undo (GnmCommand
*cmd
,
4518 G_GNUC_UNUSED WorkbookControl
*wbc
)
4520 CmdZoom
*me
= CMD_ZOOM (cmd
);
4524 g_return_val_if_fail (me
!= NULL
, TRUE
);
4525 g_return_val_if_fail (me
->sheets
!= NULL
, TRUE
);
4526 g_return_val_if_fail (me
->old_factors
!= NULL
, TRUE
);
4528 for (i
= 0, l
= me
->sheets
; l
!= NULL
; l
= l
->next
, i
++) {
4529 Sheet
*sheet
= l
->data
;
4530 g_object_set (sheet
, "zoom-factor", me
->old_factors
[i
], NULL
);
4537 cmd_zoom_redo (GnmCommand
*cmd
,
4538 G_GNUC_UNUSED WorkbookControl
*wbc
)
4540 CmdZoom
*me
= CMD_ZOOM (cmd
);
4543 g_return_val_if_fail (me
!= NULL
, TRUE
);
4544 g_return_val_if_fail (me
->sheets
!= NULL
, TRUE
);
4546 for (l
= me
->sheets
; l
!= NULL
; l
= l
->next
) {
4547 Sheet
*sheet
= l
->data
;
4548 g_object_set (sheet
, "zoom-factor", me
->new_factor
, NULL
);
4555 cmd_zoom_finalize (GObject
*cmd
)
4557 CmdZoom
*me
= CMD_ZOOM (cmd
);
4559 g_slist_free (me
->sheets
);
4560 g_free (me
->old_factors
);
4562 gnm_command_finalize (cmd
);
4567 * @wbc: #WorkbookControl
4568 * @sheets: (element-type Sheet) (transfer container):
4571 * Returns: %TRUE if there was a problem, %FALSE otherwise.
4574 cmd_zoom (WorkbookControl
*wbc
, GSList
*sheets
, double factor
)
4581 g_return_val_if_fail (wbc
!= NULL
, TRUE
);
4582 g_return_val_if_fail (sheets
!= NULL
, TRUE
);
4584 me
= g_object_new (CMD_ZOOM_TYPE
, NULL
);
4586 me
->sheets
= sheets
;
4587 me
->old_factors
= g_new0 (double, g_slist_length (sheets
));
4588 me
->new_factor
= factor
;
4590 /* Make a list of all sheets to zoom and save zoom factor for each */
4591 namelist
= g_string_new (NULL
);
4592 for (i
= 0, l
= me
->sheets
; l
!= NULL
; l
= l
->next
, i
++) {
4593 Sheet
*sheet
= l
->data
;
4595 g_string_append (namelist
, sheet
->name_unquoted
);
4596 me
->old_factors
[i
] = sheet
->last_zoom_factor_used
;
4599 g_string_append (namelist
, ", ");
4602 /* Make sure the string doesn't get overly wide */
4603 gnm_cmd_trunc_descriptor (namelist
, NULL
);
4605 me
->cmd
.sheet
= NULL
;
4607 me
->cmd
.cmd_descriptor
=
4608 g_strdup_printf (_("Zoom %s to %.0f%%"), namelist
->str
, factor
* 100);
4610 g_string_free (namelist
, TRUE
);
4612 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
4615 /******************************************************************/
4617 #define CMD_OBJECTS_DELETE_TYPE (cmd_objects_delete_get_type ())
4618 #define CMD_OBJECTS_DELETE(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_OBJECTS_DELETE_TYPE, CmdObjectsDelete))
4626 MAKE_GNM_COMMAND (CmdObjectsDelete
, cmd_objects_delete
, NULL
)
4629 cmd_objects_delete_redo (GnmCommand
*cmd
,
4630 G_GNUC_UNUSED WorkbookControl
*wbc
)
4632 CmdObjectsDelete
*me
= CMD_OBJECTS_DELETE (cmd
);
4633 g_slist_foreach (me
->objects
, (GFunc
) sheet_object_clear_sheet
, NULL
);
4638 cmd_objects_restore_location (SheetObject
*so
, gint location
)
4640 gint loc
= sheet_object_get_stacking (so
);
4641 if (loc
!= location
)
4642 sheet_object_adjust_stacking(so
, location
- loc
);
4646 cmd_objects_delete_undo (GnmCommand
*cmd
,
4647 G_GNUC_UNUSED WorkbookControl
*wbc
)
4649 CmdObjectsDelete
*me
= CMD_OBJECTS_DELETE (cmd
);
4653 g_slist_foreach (me
->objects
,
4654 (GFunc
) sheet_object_set_sheet
, me
->cmd
.sheet
);
4656 for (l
= me
->objects
, i
= 0; l
; l
= l
->next
, i
++)
4657 cmd_objects_restore_location (GNM_SO (l
->data
),
4658 g_array_index(me
->location
,
4664 cmd_objects_delete_finalize (GObject
*cmd
)
4666 CmdObjectsDelete
*me
= CMD_OBJECTS_DELETE (cmd
);
4667 g_slist_free_full (me
->objects
, g_object_unref
);
4669 g_array_free (me
->location
, TRUE
);
4670 me
->location
= NULL
;
4672 gnm_command_finalize (cmd
);
4676 cmd_objects_store_location (SheetObject
*so
, GArray
*location
)
4678 gint loc
= sheet_object_get_stacking (so
);
4679 g_array_append_val (location
, loc
);
4683 * cmd_objects_delete:
4684 * @wbc: #WorkbookControl
4685 * @objects: (element-type SheetObject) (transfer container): the objects to
4689 * Returns: %TRUE if there was a problem, %FALSE otherwise.
4692 cmd_objects_delete (WorkbookControl
*wbc
, GSList
*objects
,
4695 CmdObjectsDelete
*me
;
4697 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
4698 g_return_val_if_fail (objects
!= NULL
, TRUE
);
4700 me
= g_object_new (CMD_OBJECTS_DELETE_TYPE
, NULL
);
4702 me
->objects
= objects
;
4703 g_slist_foreach (me
->objects
, (GFunc
) g_object_ref
, NULL
);
4705 me
->location
= g_array_new (FALSE
, FALSE
, sizeof (gint
));
4706 g_slist_foreach (me
->objects
, (GFunc
) cmd_objects_store_location
,
4709 me
->cmd
.sheet
= sheet_object_get_sheet (objects
->data
);
4711 me
->cmd
.cmd_descriptor
= g_strdup (name
? name
: _("Delete Object"));
4713 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
4716 /******************************************************************/
4720 * @wbc: #WorkbookControl
4721 * @objects: (element-type SheetObject) (transfer container): the objects to move.
4722 * @anchors: (element-type SheetObjectAnchor) (transfer full): the anchors for the objects.
4726 * Returns: %TRUE if there was a problem, %FALSE otherwise.
4729 cmd_objects_move (WorkbookControl
*wbc
, GSList
*objects
, GSList
*anchors
,
4730 gboolean objects_created
, char const *name
)
4732 GOUndo
*undo
= NULL
;
4733 GOUndo
*redo
= NULL
;
4734 gboolean result
= TRUE
;
4736 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
4738 undo
= sheet_object_move_undo (objects
, objects_created
);
4739 redo
= sheet_object_move_do (objects
, anchors
, objects_created
);
4741 result
= cmd_generic (wbc
, name
, undo
, redo
);
4743 g_slist_free (objects
);
4744 g_slist_free_full (anchors
, g_free
);
4749 /******************************************************************/
4751 #define CMD_REORGANIZE_SHEETS_TYPE (cmd_reorganize_sheets_get_type ())
4752 #define CMD_REORGANIZE_SHEETS(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_REORGANIZE_SHEETS_TYPE, CmdReorganizeSheets))
4757 WorkbookSheetState
*old
;
4758 WorkbookSheetState
*new;
4762 } CmdReorganizeSheets
;
4764 MAKE_GNM_COMMAND (CmdReorganizeSheets
, cmd_reorganize_sheets
, NULL
)
4767 cmd_reorganize_sheets_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
4769 CmdReorganizeSheets
*me
= CMD_REORGANIZE_SHEETS (cmd
);
4770 workbook_sheet_state_restore (me
->wb
, me
->old
);
4771 if (me
->undo_sheet
) {
4772 WORKBOOK_VIEW_FOREACH_CONTROL (wb_control_view (wbc
), control
,
4773 wb_control_sheet_focus (control
, me
->undo_sheet
););
4779 cmd_reorganize_sheets_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
4781 CmdReorganizeSheets
*me
= CMD_REORGANIZE_SHEETS (cmd
);
4786 workbook_sheet_state_restore (me
->wb
, me
->new);
4787 if (me
->redo_sheet
) {
4788 WORKBOOK_VIEW_FOREACH_CONTROL (wb_control_view (wbc
), control
,
4789 wb_control_sheet_focus (control
, me
->redo_sheet
););
4797 cmd_reorganize_sheets_finalize (GObject
*cmd
)
4799 CmdReorganizeSheets
*me
= CMD_REORGANIZE_SHEETS (cmd
);
4802 workbook_sheet_state_free (me
->old
);
4804 workbook_sheet_state_free (me
->new);
4806 gnm_command_finalize (cmd
);
4810 cmd_reorganize_sheets (WorkbookControl
*wbc
,
4811 WorkbookSheetState
*old_state
,
4814 CmdReorganizeSheets
*me
;
4815 Workbook
*wb
= wb_control_get_workbook (wbc
);
4817 me
= g_object_new (CMD_REORGANIZE_SHEETS_TYPE
, NULL
);
4819 me
->old
= old_state
;
4820 me
->new = workbook_sheet_state_new (me
->wb
);
4822 me
->undo_sheet
= undo_sheet
;
4823 me
->redo_sheet
= wb_control_cur_sheet (wbc
);
4825 me
->cmd
.sheet
= NULL
;
4826 me
->cmd
.size
= workbook_sheet_state_size (me
->old
) +
4827 workbook_sheet_state_size (me
->new);
4828 me
->cmd
.cmd_descriptor
=
4829 workbook_sheet_state_diff (me
->old
, me
->new);
4831 if (me
->cmd
.cmd_descriptor
)
4832 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
4835 g_object_unref (me
);
4839 /******************************************************************/
4842 cmd_rename_sheet (WorkbookControl
*wbc
,
4844 char const *new_name
)
4846 WorkbookSheetState
*old_state
;
4849 g_return_val_if_fail (new_name
!= NULL
, TRUE
);
4850 g_return_val_if_fail (sheet
!= NULL
, TRUE
);
4852 if (*new_name
== 0) {
4853 go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc
), _("Name"), _("Sheet names must be non-empty."));
4857 collision
= workbook_sheet_by_name (sheet
->workbook
, new_name
);
4858 if (collision
&& collision
!= sheet
) {
4859 GError
*err
= g_error_new (go_error_invalid(), 0,
4860 _("A workbook cannot have two sheets with the same name."));
4861 go_cmd_context_error (GO_CMD_CONTEXT (wbc
), err
);
4866 old_state
= workbook_sheet_state_new (sheet
->workbook
);
4867 g_object_set (sheet
, "name", new_name
, NULL
);
4868 return cmd_reorganize_sheets (wbc
, old_state
, sheet
);
4871 /******************************************************************/
4873 #define CMD_RESIZE_SHEETS_TYPE (cmd_resize_sheets_get_type ())
4874 #define CMD_RESIZE_SHEETS(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_RESIZE_SHEETS_TYPE, CmdResizeSheets))
4883 MAKE_GNM_COMMAND (CmdResizeSheets
, cmd_resize_sheets
, NULL
)
4886 cmd_resize_sheets_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
4888 CmdResizeSheets
*me
= CMD_RESIZE_SHEETS (cmd
);
4889 GOCmdContext
*cc
= GO_CMD_CONTEXT (wbc
);
4891 go_undo_undo_with_data (me
->undo
, cc
);
4892 g_object_unref (me
->undo
);
4899 cmd_resize_sheets_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
4901 CmdResizeSheets
*me
= CMD_RESIZE_SHEETS (cmd
);
4902 GOCmdContext
*cc
= GO_CMD_CONTEXT (wbc
);
4905 for (l
= me
->sheets
; l
; l
= l
->next
) {
4906 Sheet
*sheet
= l
->data
;
4908 GOUndo
*u
= gnm_sheet_resize (sheet
, me
->cols
, me
->rows
,
4910 me
->undo
= go_undo_combine (me
->undo
, u
);
4914 go_undo_undo_with_data (me
->undo
, cc
);
4923 cmd_resize_sheets_finalize (GObject
*cmd
)
4925 CmdResizeSheets
*me
= CMD_RESIZE_SHEETS (cmd
);
4927 g_slist_free (me
->sheets
);
4929 g_object_unref (me
->undo
);
4933 gnm_command_finalize (cmd
);
4937 * cmd_resize_sheets:
4938 * @wbc: #WorkbookControl
4939 * @sheets: (element-type Sheet) (transfer container): the sheets to resize.
4940 * @cols: new columns number.
4941 * @rows: new rows number.
4943 * Returns: %TRUE if there was a problem, %FALSE otherwise.
4946 cmd_resize_sheets (WorkbookControl
*wbc
,
4950 CmdResizeSheets
*me
;
4952 me
= g_object_new (CMD_RESIZE_SHEETS_TYPE
, NULL
);
4953 me
->sheets
= sheets
;
4956 me
->cmd
.sheet
= sheets
? sheets
->data
: NULL
;
4958 me
->cmd
.cmd_descriptor
= g_strdup (_("Resizing sheet"));
4961 gnm_sheet_valid_size (cols
, rows
))
4962 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
4965 g_object_unref (me
);
4969 /******************************************************************/
4971 #define CMD_SET_COMMENT_TYPE (cmd_set_comment_get_type ())
4972 #define CMD_SET_COMMENT(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SET_COMMENT_TYPE, CmdSetComment))
4983 PangoAttrList
*old_attributes
;
4984 PangoAttrList
*new_attributes
;
4987 MAKE_GNM_COMMAND (CmdSetComment
, cmd_set_comment
, NULL
)
4990 cmd_set_comment_apply (Sheet
*sheet
, GnmCellPos
*pos
,
4991 char const *text
, PangoAttrList
*attributes
,
4994 GnmComment
*comment
;
4995 Workbook
*wb
= sheet
->workbook
;
4997 comment
= sheet_get_comment (sheet
, pos
);
5000 g_object_set (G_OBJECT (comment
), "text", text
,
5002 "markup", attributes
, NULL
);
5006 mr
= gnm_sheet_merge_contains_pos (sheet
, pos
);
5009 sheet_objects_clear (sheet
, mr
, GNM_CELL_COMMENT_TYPE
, NULL
);
5012 r
.start
= r
.end
= *pos
;
5013 sheet_objects_clear (sheet
, &r
, GNM_CELL_COMMENT_TYPE
, NULL
);
5016 } else if (text
&& (strlen (text
) > 0)) {
5017 cell_set_comment (sheet
, pos
, author
, text
, attributes
);
5019 sheet_mark_dirty (sheet
);
5021 WORKBOOK_FOREACH_CONTROL (wb
, view
, ctl
,
5022 wb_control_menu_state_update (ctl
, MS_COMMENT_LINKS
););
5028 cmd_set_comment_undo (GnmCommand
*cmd
,
5029 G_GNUC_UNUSED WorkbookControl
*wbc
)
5031 CmdSetComment
*me
= CMD_SET_COMMENT (cmd
);
5033 return cmd_set_comment_apply (me
->sheet
, &me
->pos
,
5034 me
->old_text
, me
->old_attributes
,
5039 cmd_set_comment_redo (GnmCommand
*cmd
,
5040 G_GNUC_UNUSED WorkbookControl
*wbc
)
5042 CmdSetComment
*me
= CMD_SET_COMMENT (cmd
);
5044 return cmd_set_comment_apply (me
->sheet
, &me
->pos
,
5045 me
->new_text
, me
->new_attributes
,
5050 cmd_set_comment_finalize (GObject
*cmd
)
5052 CmdSetComment
*me
= CMD_SET_COMMENT (cmd
);
5054 g_free (me
->new_text
);
5055 me
->new_text
= NULL
;
5057 g_free (me
->old_text
);
5058 me
->old_text
= NULL
;
5060 g_free (me
->new_author
);
5061 me
->new_author
= NULL
;
5063 g_free (me
->old_author
);
5064 me
->old_author
= NULL
;
5066 if (me
->old_attributes
!= NULL
) {
5067 pango_attr_list_unref (me
->old_attributes
);
5068 me
->old_attributes
= NULL
;
5071 if (me
->new_attributes
!= NULL
) {
5072 pango_attr_list_unref (me
->new_attributes
);
5073 me
->new_attributes
= NULL
;
5076 gnm_command_finalize (cmd
);
5080 cmd_set_comment (WorkbookControl
*wbc
,
5081 Sheet
*sheet
, GnmCellPos
const *pos
,
5082 char const *new_text
,
5083 PangoAttrList
*attr
,
5084 char const *new_author
)
5087 GnmComment
*comment
;
5090 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
5091 g_return_val_if_fail (new_text
!= NULL
, TRUE
);
5093 me
= g_object_new (CMD_SET_COMMENT_TYPE
, NULL
);
5095 me
->cmd
.sheet
= sheet
;
5097 if (strlen (new_text
) < 1)
5098 me
->new_text
= NULL
;
5100 me
->new_text
= g_strdup (new_text
);
5101 if (strlen (new_author
) < 1)
5102 me
->new_author
= NULL
;
5104 me
->new_author
= g_strdup (new_author
);
5106 pango_attr_list_ref (attr
);
5107 me
->new_attributes
= attr
;
5108 where
= undo_cell_pos_name (sheet
, pos
);
5109 me
->cmd
.cmd_descriptor
=
5110 g_strdup_printf (me
->new_text
== NULL
?
5111 _("Clearing comment of %s") :
5112 _("Setting comment of %s"),
5115 me
->old_text
= NULL
;
5116 me
->old_author
= NULL
;
5117 me
->old_attributes
= NULL
;
5120 comment
= sheet_get_comment (sheet
, pos
);
5122 g_object_get (G_OBJECT (comment
),
5123 "text", &(me
->old_text
),
5124 "author", &(me
->old_author
),
5125 "markup", &(me
->old_attributes
), NULL
);
5126 if (me
->old_attributes
!= NULL
)
5127 pango_attr_list_ref (me
->old_attributes
);
5128 me
->old_text
= g_strdup (me
->old_text
);
5129 me
->old_author
= g_strdup (me
->old_author
);
5132 /* Register the command object */
5133 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
5136 /******************************************************************/
5138 #define CMD_ANALYSIS_TOOL_TYPE (cmd_analysis_tool_get_type ())
5139 #define CMD_ANALYSIS_TOOL(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_ANALYSIS_TOOL_TYPE, CmdAnalysis_Tool))
5144 data_analysis_output_t
*dao
;
5146 gboolean specs_owned
;
5147 analysis_tool_engine engine
;
5148 data_analysis_output_type_t type
;
5150 ColRowStateList
*col_info
;
5151 ColRowStateList
*row_info
;
5153 GnmCellRegion
*old_contents
;
5154 GSList
*newSheetObjects
;
5157 MAKE_GNM_COMMAND (CmdAnalysis_Tool
, cmd_analysis_tool
, NULL
)
5160 cmd_analysis_tool_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
5162 CmdAnalysis_Tool
*me
= CMD_ANALYSIS_TOOL (cmd
);
5165 g_return_val_if_fail (me
!= NULL
, TRUE
);
5167 /* The old view might not exist anymore */
5171 case NewSheetOutput
:
5172 if (!command_undo_sheet_delete (me
->dao
->sheet
))
5174 me
->dao
->sheet
= NULL
;
5176 case NewWorkbookOutput
:
5177 g_warning ("How did we get here?");
5182 sheet_clear_region (me
->dao
->sheet
,
5183 me
->old_range
.start
.col
, me
->old_range
.start
.row
,
5184 me
->old_range
.end
.col
, me
->old_range
.end
.row
,
5185 CLEAR_COMMENTS
| CLEAR_FORMATS
| CLEAR_NOCHECKARRAY
|
5186 CLEAR_RECALC_DEPS
| CLEAR_VALUES
| CLEAR_MERGES
,
5187 GO_CMD_CONTEXT (wbc
));
5188 clipboard_paste_region (me
->old_contents
,
5189 paste_target_init (&pt
, me
->dao
->sheet
, &me
->old_range
, PASTE_ALL_SHEET
),
5190 GO_CMD_CONTEXT (wbc
));
5191 cellregion_unref (me
->old_contents
);
5192 me
->old_contents
= NULL
;
5194 dao_set_colrow_state_list (me
->dao
, TRUE
, me
->col_info
);
5195 me
->col_info
= colrow_state_list_destroy (me
->col_info
);
5198 dao_set_colrow_state_list (me
->dao
, FALSE
, me
->row_info
);
5199 me
->row_info
= colrow_state_list_destroy (me
->row_info
);
5201 if (me
->newSheetObjects
== NULL
)
5202 me
->newSheetObjects
= dao_surrender_so (me
->dao
);
5203 g_slist_foreach (me
->newSheetObjects
, (GFunc
)sheet_object_clear_sheet
, NULL
);
5204 sheet_update (me
->dao
->sheet
);
5211 cmd_analysis_tool_draw_old_so (SheetObject
*so
, data_analysis_output_t
*dao
)
5214 dao_set_sheet_object (dao
, 0, 1, so
);
5218 cmd_analysis_tool_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
5220 gpointer continuity
= NULL
;
5221 CmdAnalysis_Tool
*me
= CMD_ANALYSIS_TOOL (cmd
);
5222 GOCmdContext
*cc
= GO_CMD_CONTEXT (wbc
);
5224 g_return_val_if_fail (me
!= NULL
, TRUE
);
5226 /* The old view might not exist anymore */
5230 me
->col_info
= colrow_state_list_destroy (me
->col_info
);
5231 me
->col_info
= dao_get_colrow_state_list (me
->dao
, TRUE
);
5233 me
->row_info
= colrow_state_list_destroy (me
->row_info
);
5234 me
->row_info
= dao_get_colrow_state_list (me
->dao
, FALSE
);
5236 if (me
->engine (cc
, me
->dao
, me
->specs
, TOOL_ENGINE_PREPARE_OUTPUT_RANGE
, NULL
)
5237 || me
->engine (cc
, me
->dao
, me
->specs
, TOOL_ENGINE_UPDATE_DESCRIPTOR
,
5238 &me
->cmd
.cmd_descriptor
)
5239 || cmd_dao_is_locked_effective (me
->dao
, wbc
, me
->cmd
.cmd_descriptor
)
5240 || me
->engine (cc
, me
->dao
, me
->specs
, TOOL_ENGINE_LAST_VALIDITY_CHECK
, &continuity
))
5244 case NewSheetOutput
:
5245 me
->old_contents
= NULL
;
5247 case NewWorkbookOutput
:
5248 /* No undo in this case (see below) */
5249 me
->old_contents
= NULL
;
5253 range_init (&me
->old_range
, me
->dao
->start_col
, me
->dao
->start_row
,
5254 me
->dao
->start_col
+ me
->dao
->cols
- 1,
5255 me
->dao
->start_row
+ me
->dao
->rows
- 1);
5256 me
->old_contents
= clipboard_copy_range (me
->dao
->sheet
, &me
->old_range
);
5260 if (me
->newSheetObjects
!= NULL
)
5261 dao_set_omit_so (me
->dao
, TRUE
);
5263 if (me
->engine (cc
, me
->dao
, me
->specs
, TOOL_ENGINE_FORMAT_OUTPUT_RANGE
, NULL
))
5266 if (me
->engine (cc
, me
->dao
, me
->specs
, TOOL_ENGINE_PERFORM_CALC
, &continuity
)) {
5267 if (me
->type
== RangeOutput
) {
5268 g_warning ("This is too late for failure! The target region has "
5269 "already been formatted!");
5273 if (me
->newSheetObjects
!= NULL
)
5275 GSList
*l
= g_slist_reverse
5276 (g_slist_copy (me
->newSheetObjects
));
5278 dao_set_omit_so (me
->dao
, FALSE
);
5280 (GFunc
) cmd_analysis_tool_draw_old_so
,
5286 g_warning ("There shouldn't be any data left in here!");
5289 dao_autofit_columns (me
->dao
);
5290 sheet_mark_dirty (me
->dao
->sheet
);
5291 sheet_update (me
->dao
->sheet
);
5293 /* The concept of an undo if we create a new worksheet is extremely strange,
5294 * since we have separate undo/redo queues per worksheet.
5295 * Users can simply delete the worksheet if they so desire.
5298 return (me
->type
== NewWorkbookOutput
);
5302 cmd_analysis_tool_finalize (GObject
*cmd
)
5304 CmdAnalysis_Tool
*me
= CMD_ANALYSIS_TOOL (cmd
);
5307 me
->col_info
= colrow_state_list_destroy (me
->col_info
);
5309 me
->row_info
= colrow_state_list_destroy (me
->row_info
);
5311 me
->engine (NULL
, me
->dao
, me
->specs
, TOOL_ENGINE_CLEAN_UP
, NULL
);
5313 if (me
->specs_owned
) {
5317 if (me
->old_contents
)
5318 cellregion_unref (me
->old_contents
);
5320 g_slist_free_full (me
->newSheetObjects
, g_object_unref
);
5322 gnm_command_finalize (cmd
);
5326 * cmd_analysis_tool: (skip)
5327 * Note: this takes ownership of specs and dao if the command
5330 * Returns: %TRUE if there was a problem, %FALSE otherwise.
5333 cmd_analysis_tool (WorkbookControl
*wbc
, G_GNUC_UNUSED Sheet
*sheet
,
5334 data_analysis_output_t
*dao
, gpointer specs
,
5335 analysis_tool_engine engine
, gboolean always_take_ownership
)
5337 CmdAnalysis_Tool
*me
;
5339 GOCmdContext
*cc
= GO_CMD_CONTEXT (wbc
);
5341 g_return_val_if_fail (dao
!= NULL
, TRUE
);
5342 g_return_val_if_fail (specs
!= NULL
, TRUE
);
5343 g_return_val_if_fail (engine
!= NULL
, TRUE
);
5345 me
= g_object_new (CMD_ANALYSIS_TOOL_TYPE
, NULL
);
5349 /* Store the specs for the object */
5351 me
->specs_owned
= always_take_ownership
;
5353 me
->engine
= engine
;
5354 me
->cmd
.cmd_descriptor
= NULL
;
5355 if (me
->engine (cc
, me
->dao
, me
->specs
, TOOL_ENGINE_UPDATE_DAO
, NULL
)) {
5356 g_object_unref (me
);
5359 me
->engine (cc
, me
->dao
, me
->specs
, TOOL_ENGINE_UPDATE_DESCRIPTOR
,
5360 &me
->cmd
.cmd_descriptor
);
5361 me
->cmd
.sheet
= NULL
;
5362 me
->type
= dao
->type
;
5363 me
->row_info
= NULL
;
5364 me
->col_info
= NULL
;
5366 /* We divide by 2 since many cells will be empty*/
5367 me
->cmd
.size
= 1 + dao
->rows
* dao
->cols
/ 2;
5369 /* Register the command object */
5370 trouble
= gnm_command_push_undo (wbc
, G_OBJECT (me
));
5373 me
->specs_owned
= TRUE
;
5378 /******************************************************************/
5380 #define CMD_MERGE_DATA_TYPE (cmd_merge_data_get_type ())
5381 #define CMD_MERGE_DATA(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_MERGE_DATA_TYPE, CmdMergeData))
5385 GnmValue
*merge_zone
;
5386 GSList
*merge_fields
;
5393 MAKE_GNM_COMMAND (CmdMergeData
, cmd_merge_data
, NULL
)
5396 cmd_merge_data_delete_sheets (gpointer data
, gpointer success
)
5398 Sheet
*sheet
= data
;
5400 if (!command_undo_sheet_delete (sheet
))
5401 *(gboolean
*)success
= FALSE
;
5405 cmd_merge_data_undo (GnmCommand
*cmd
,
5406 G_GNUC_UNUSED WorkbookControl
*wbc
)
5408 CmdMergeData
*me
= CMD_MERGE_DATA (cmd
);
5409 gboolean success
= TRUE
;
5411 g_slist_foreach (me
->sheet_list
, cmd_merge_data_delete_sheets
, &success
);
5412 g_slist_free (me
->sheet_list
);
5413 me
->sheet_list
= NULL
;
5419 cmd_merge_data_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
5421 CmdMergeData
*me
= CMD_MERGE_DATA (cmd
);
5423 GnmCellRegion
*merge_contents
;
5424 GnmRangeRef
*cell
= &me
->merge_zone
->v_range
.cell
;
5426 GSList
*this_field
= me
->merge_fields
;
5427 GSList
*this_data
= me
->merge_data
;
5428 Sheet
*source_sheet
= cell
->a
.sheet
;
5429 GSList
*target_sheet
;
5430 GnmRange target_range
;
5431 ColRowStateList
*state_col
;
5432 ColRowStateList
*state_row
;
5434 range_init (&target_range
, cell
->a
.col
, cell
->a
.row
,
5435 cell
->b
.col
, cell
->b
.row
);
5436 merge_contents
= clipboard_copy_range (source_sheet
, &target_range
);
5437 state_col
= colrow_get_states (source_sheet
, TRUE
, target_range
.start
.col
,
5438 target_range
.end
.col
);
5439 state_row
= colrow_get_states (source_sheet
, FALSE
, target_range
.start
.row
,
5440 target_range
.end
.row
);
5442 for (i
= 0; i
< me
->n
; i
++) {
5445 new_sheet
= workbook_sheet_add (me
->sheet
->workbook
, -1,
5446 gnm_sheet_get_max_cols (me
->sheet
),
5447 gnm_sheet_get_max_rows (me
->sheet
));
5448 me
->sheet_list
= g_slist_prepend (me
->sheet_list
, new_sheet
);
5450 colrow_set_states (new_sheet
, TRUE
, target_range
.start
.col
, state_col
);
5451 colrow_set_states (new_sheet
, FALSE
, target_range
.start
.row
, state_row
);
5452 sheet_objects_dup (source_sheet
, new_sheet
, &target_range
);
5453 clipboard_paste_region (merge_contents
,
5454 paste_target_init (&pt
, new_sheet
, &target_range
, PASTE_ALL_SHEET
),
5455 GO_CMD_CONTEXT (wbc
));
5457 cellregion_unref (merge_contents
);
5458 me
->sheet_list
= g_slist_reverse (me
->sheet_list
);
5459 colrow_state_list_destroy (state_col
);
5460 colrow_state_list_destroy (state_row
);
5462 while (this_field
) {
5463 int col_source
, row_source
;
5464 int col_target
, row_target
;
5466 g_return_val_if_fail (this_data
!= NULL
, TRUE
);
5467 cell
= &((GnmValue
*)this_field
->data
)->v_range
.cell
;
5468 col_target
= cell
->a
.col
;
5469 row_target
= cell
->a
.row
;
5471 cell
= &((GnmValue
*)this_data
->data
)->v_range
.cell
;
5472 col_source
= cell
->a
.col
;
5473 row_source
= cell
->a
.row
;
5474 source_sheet
= cell
->a
.sheet
;
5476 target_sheet
= me
->sheet_list
;
5477 while (target_sheet
) {
5478 GnmCell
*source_cell
= sheet_cell_get (source_sheet
,
5479 col_source
, row_source
);
5480 if (source_cell
== NULL
) {
5481 GnmCell
*target_cell
= sheet_cell_get ((Sheet
*)target_sheet
->data
,
5482 col_target
, row_target
);
5483 if (target_cell
!= NULL
)
5484 gnm_cell_set_value (target_cell
,
5485 value_new_empty ());
5487 GnmCell
*target_cell
= sheet_cell_fetch ((Sheet
*)target_sheet
->data
,
5488 col_target
, row_target
);
5489 gnm_cell_set_value (target_cell
,
5490 value_dup (source_cell
->value
));
5492 target_sheet
= target_sheet
->next
;
5496 this_field
= this_field
->next
;
5497 this_data
= this_data
->next
;
5504 cmd_merge_data_finalize (GObject
*cmd
)
5506 CmdMergeData
*me
= CMD_MERGE_DATA (cmd
);
5508 value_release (me
->merge_zone
);
5509 me
->merge_zone
= NULL
;
5510 range_list_destroy (me
->merge_data
);
5511 me
->merge_data
= NULL
;
5512 range_list_destroy (me
->merge_fields
);
5513 me
->merge_fields
= NULL
;
5514 g_slist_free (me
->sheet_list
);
5515 me
->sheet_list
= NULL
;
5518 gnm_command_finalize (cmd
);
5523 * @wbc: #WorkbookControl
5525 * @merge_zone: (transfer full): #GnmValue
5526 * @merge_fields: (element-type GnmRange) (transfer full):
5527 * @merge_data: (element-type GnmRange) (transfer full):
5529 * Returns: %TRUE if there was a problem, %FALSE otherwise.
5532 cmd_merge_data (WorkbookControl
*wbc
, Sheet
*sheet
,
5533 GnmValue
*merge_zone
, GSList
*merge_fields
, GSList
*merge_data
)
5538 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
5539 g_return_val_if_fail (merge_zone
!= NULL
, TRUE
);
5540 g_return_val_if_fail (merge_fields
!= NULL
, TRUE
);
5541 g_return_val_if_fail (merge_data
!= NULL
, TRUE
);
5543 me
= g_object_new (CMD_MERGE_DATA_TYPE
, NULL
);
5545 me
->cmd
.sheet
= sheet
;
5547 me
->cmd
.size
= 1 + g_slist_length (merge_fields
);
5548 me
->cmd
.cmd_descriptor
=
5549 g_strdup_printf (_("Merging data into %s"), value_peek_string (merge_zone
));
5551 me
->merge_zone
= merge_zone
;
5552 me
->merge_fields
= merge_fields
;
5553 me
->merge_data
= merge_data
;
5554 me
->sheet_list
= NULL
;
5556 cell
= &((GnmValue
*)merge_data
->data
)->v_range
.cell
;
5557 me
->n
= cell
->b
.row
- cell
->a
.row
+ 1;
5559 /* Register the command object */
5560 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
5563 /******************************************************************/
5565 #define CMD_CHANGE_META_DATA_TYPE (cmd_change_summary_get_type ())
5566 #define CMD_CHANGE_META_DATA(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_CHANGE_META_DATA_TYPE, CmdChangeMetaData))
5570 GSList
*changed_props
;
5571 GSList
*removed_names
;
5572 } CmdChangeMetaData
;
5574 MAKE_GNM_COMMAND (CmdChangeMetaData
, cmd_change_summary
, NULL
)
5577 cmd_change_summary_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
5579 CmdChangeMetaData
*me
= CMD_CHANGE_META_DATA (cmd
);
5580 GsfDocMetaData
*meta
= go_doc_get_meta_data (wb_control_get_doc (wbc
));
5581 GSList
*ptr
, *old_vals
= NULL
, *dropped
= NULL
;
5585 for (ptr
= me
->removed_names
; ptr
!= NULL
; ptr
= ptr
->next
) {
5586 if (NULL
!= (prop
= gsf_doc_meta_data_steal (meta
, ptr
->data
)))
5587 old_vals
= g_slist_prepend (old_vals
, prop
);
5590 g_slist_free (me
->removed_names
);
5592 for (ptr
= me
->changed_props
; ptr
!= NULL
; ptr
= ptr
->next
) {
5593 name
= gsf_doc_prop_get_name (ptr
->data
);
5594 if (NULL
!= (prop
= gsf_doc_meta_data_steal (meta
, name
)))
5595 old_vals
= g_slist_prepend (old_vals
, prop
);
5597 dropped
= g_slist_prepend (old_vals
, g_strdup (name
));
5598 gsf_doc_meta_data_store (meta
, ptr
->data
);
5600 g_slist_free (me
->changed_props
);
5602 me
->removed_names
= dropped
;
5603 me
->changed_props
= old_vals
;
5604 go_doc_update_meta_data (wb_control_get_doc (wbc
));
5610 cmd_change_summary_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
5612 return cmd_change_summary_undo (cmd
, wbc
);
5616 cmd_change_summary_finalize (GObject
*cmd
)
5618 CmdChangeMetaData
*me
= CMD_CHANGE_META_DATA (cmd
);
5620 g_slist_free_full (me
->changed_props
, (GDestroyNotify
)gsf_doc_prop_free
);
5621 me
->changed_props
= NULL
;
5622 g_slist_free_full (me
->removed_names
, g_free
);
5623 me
->removed_names
= NULL
;
5625 gnm_command_finalize (cmd
);
5629 * cmd_change_meta_data:
5630 * @wbc: #WorkbookControl
5631 * @changes: (element-type GsfDocMetaData) (transfer full): the changed metadata.
5632 * @removed: (element-type GsfDocMetaData) (transfer full): the removed metadata.
5634 * Returns: %TRUE if there was a problem, %FALSE otherwise.
5637 cmd_change_meta_data (WorkbookControl
*wbc
, GSList
*changes
, GSList
*removed
)
5639 CmdChangeMetaData
*me
= g_object_new (CMD_CHANGE_META_DATA_TYPE
, NULL
);
5641 me
->changed_props
= changes
;
5642 me
->removed_names
= removed
;
5643 me
->cmd
.sheet
= NULL
;
5645 me
->cmd
.size
= g_slist_length (changes
) + g_slist_length (removed
);
5646 me
->cmd
.cmd_descriptor
= g_strdup_printf (
5647 _("Changing workbook properties"));
5648 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
5651 /******************************************************************/
5653 #define CMD_OBJECT_RAISE_TYPE (cmd_object_raise_get_type ())
5654 #define CMD_OBJECT_RAISE(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_OBJECT_RAISE_TYPE, CmdObjectRaise))
5659 CmdObjectRaiseSelector dir
;
5660 gint changed_positions
;
5663 MAKE_GNM_COMMAND (CmdObjectRaise
, cmd_object_raise
, NULL
)
5666 cmd_object_raise_redo (GnmCommand
*cmd
,
5667 G_GNUC_UNUSED WorkbookControl
*wbc
)
5669 CmdObjectRaise
*me
= CMD_OBJECT_RAISE (cmd
);
5671 case cmd_object_pull_to_front
:
5672 me
->changed_positions
= sheet_object_adjust_stacking (me
->so
, G_MAXINT
/2);
5674 case cmd_object_pull_forward
:
5675 me
->changed_positions
= sheet_object_adjust_stacking (me
->so
, 1);
5677 case cmd_object_push_backward
:
5678 me
->changed_positions
= sheet_object_adjust_stacking (me
->so
, -1);
5680 case cmd_object_push_to_back
:
5681 me
->changed_positions
= sheet_object_adjust_stacking (me
->so
, G_MININT
/2);
5688 cmd_object_raise_undo (GnmCommand
*cmd
,
5689 G_GNUC_UNUSED WorkbookControl
*wbc
)
5691 CmdObjectRaise
*me
= CMD_OBJECT_RAISE (cmd
);
5692 if (me
->changed_positions
!= 0)
5693 sheet_object_adjust_stacking (me
->so
, - me
->changed_positions
);
5698 cmd_object_raise_finalize (GObject
*cmd
)
5700 CmdObjectRaise
*me
= CMD_OBJECT_RAISE (cmd
);
5701 g_object_unref (me
->so
);
5702 gnm_command_finalize (cmd
);
5706 cmd_object_raise (WorkbookControl
*wbc
, SheetObject
*so
, CmdObjectRaiseSelector dir
)
5710 g_return_val_if_fail (GNM_IS_SO (so
), TRUE
);
5712 me
= g_object_new (CMD_OBJECT_RAISE_TYPE
, NULL
);
5717 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
5720 case cmd_object_pull_to_front
:
5721 me
->cmd
.cmd_descriptor
= g_strdup (_("Pull Object to the Front"));
5723 case cmd_object_pull_forward
:
5724 me
->cmd
.cmd_descriptor
= g_strdup (_("Pull Object Forward"));
5726 case cmd_object_push_backward
:
5727 me
->cmd
.cmd_descriptor
= g_strdup (_("Push Object Backward"));
5729 case cmd_object_push_to_back
:
5730 me
->cmd
.cmd_descriptor
= g_strdup (_("Push Object to the Back"));
5734 me
->changed_positions
= 0;
5736 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
5739 /******************************************************************/
5741 #define CMD_PRINT_SETUP_TYPE (cmd_print_setup_get_type ())
5742 #define CMD_PRINT_SETUP(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_PRINT_SETUP_TYPE, CmdPrintSetup))
5748 GnmPrintInformation
*new_pi
;
5751 MAKE_GNM_COMMAND (CmdPrintSetup
, cmd_print_setup
, NULL
)
5754 update_sheet_graph_cb (Sheet
*sheet
)
5756 g_return_if_fail (IS_SHEET (sheet
) && sheet
->sheet_type
== GNM_SHEET_OBJECT
);
5758 sheet_object_graph_ensure_size (GNM_SO (sheet
->sheet_objects
->data
));
5762 cmd_print_setup_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
5764 CmdPrintSetup
*me
= CMD_PRINT_SETUP (cmd
);
5769 g_return_val_if_fail (me
->old_pi
!= NULL
, TRUE
);
5771 if (me
->cmd
.sheet
) {
5772 GnmPrintInformation
*pi
= me
->old_pi
->data
;
5773 gnm_print_info_free (me
->cmd
.sheet
->print_info
);
5774 me
->cmd
.sheet
->print_info
= gnm_print_info_dup (pi
);
5775 if (me
->cmd
.sheet
->sheet_type
== GNM_SHEET_OBJECT
)
5776 update_sheet_graph_cb (me
->cmd
.sheet
);
5778 book
= wb_control_get_workbook(wbc
);
5779 n
= workbook_sheet_count (book
);
5781 g_return_val_if_fail (g_slist_length (infos
) == n
, TRUE
);
5783 for (i
= 0 ; i
< n
; i
++) {
5784 GnmPrintInformation
*pi
= infos
->data
;
5785 Sheet
*sheet
= workbook_sheet_by_index (book
, i
);
5787 g_return_val_if_fail (infos
!= NULL
, TRUE
);
5789 gnm_print_info_free (sheet
->print_info
);
5790 sheet
->print_info
= gnm_print_info_dup (pi
);
5791 if (sheet
->sheet_type
== GNM_SHEET_OBJECT
)
5792 update_sheet_graph_cb (sheet
);
5793 infos
= infos
->next
;
5800 cmd_print_setup_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
5802 CmdPrintSetup
*me
= CMD_PRINT_SETUP (cmd
);
5805 gboolean save_pis
= (me
->old_pi
== NULL
);
5807 if (me
->cmd
.sheet
) {
5809 me
->old_pi
= g_slist_append (me
->old_pi
, me
->cmd
.sheet
->print_info
);
5811 gnm_print_info_free (me
->cmd
.sheet
->print_info
);
5812 me
->cmd
.sheet
->print_info
= gnm_print_info_dup (me
->new_pi
);
5813 if (me
->cmd
.sheet
->sheet_type
== GNM_SHEET_OBJECT
)
5814 update_sheet_graph_cb (me
->cmd
.sheet
);
5816 book
= wb_control_get_workbook(wbc
);
5817 n
= workbook_sheet_count (book
);
5818 for (i
= 0 ; i
< n
; i
++) {
5819 Sheet
*sheet
= workbook_sheet_by_index (book
, i
);
5820 sheet_mark_dirty (sheet
);
5822 me
->old_pi
= g_slist_prepend (me
->old_pi
, sheet
->print_info
);
5824 gnm_print_info_free (sheet
->print_info
);
5825 sheet
->print_info
= gnm_print_info_dup (me
->new_pi
);
5826 if (sheet
->sheet_type
== GNM_SHEET_OBJECT
)
5827 update_sheet_graph_cb (sheet
);
5830 me
->old_pi
= g_slist_reverse (me
->old_pi
);
5836 cmd_print_setup_finalize (GObject
*cmd
)
5838 CmdPrintSetup
*me
= CMD_PRINT_SETUP (cmd
);
5839 GSList
*list
= me
->old_pi
;
5842 gnm_print_info_free (me
->new_pi
);
5843 for (; list
; list
= list
->next
)
5844 gnm_print_info_free ((GnmPrintInformation
*) list
->data
);
5845 g_slist_free (me
->old_pi
);
5846 gnm_command_finalize (cmd
);
5850 cmd_print_setup (WorkbookControl
*wbc
, Sheet
*sheet
, GnmPrintInformation
const *pi
)
5854 me
= g_object_new (CMD_PRINT_SETUP_TYPE
, NULL
);
5856 me
->cmd
.sheet
= sheet
;
5859 me
->cmd
.cmd_descriptor
=
5860 g_strdup_printf (_("Page Setup For %s"), sheet
->name_unquoted
);
5862 me
->cmd
.cmd_descriptor
= g_strdup (_("Page Setup For All Sheets"));
5864 me
->new_pi
= gnm_print_info_dup (pi
);
5866 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
5869 /******************************************************************/
5871 #define CMD_DEFINE_NAME_TYPE (cmd_define_name_get_type ())
5872 #define CMD_DEFINE_NAME(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_DEFINE_NAME_TYPE, CmdDefineName))
5879 GnmExprTop
const *texpr
;
5881 gboolean placeholder
;
5884 MAKE_GNM_COMMAND (CmdDefineName
, cmd_define_name
, NULL
)
5887 cmd_define_name_undo (GnmCommand
*cmd
,
5888 WorkbookControl
*wbc
)
5890 CmdDefineName
*me
= CMD_DEFINE_NAME (cmd
);
5891 GnmNamedExpr
*nexpr
= expr_name_lookup (&(me
->pp
), me
->name
);
5892 GnmExprTop
const *texpr
= nexpr
->texpr
;
5894 gnm_expr_top_ref (texpr
);
5896 expr_name_remove (nexpr
);
5897 else if (me
->placeholder
)
5898 expr_name_downgrade_to_placeholder (nexpr
);
5900 expr_name_set_expr (nexpr
, me
->texpr
); /* restore old def */
5904 WORKBOOK_FOREACH_VIEW (wb_control_get_workbook (wbc
), each_wbv
, {
5905 wb_view_menus_update (each_wbv
);
5911 cmd_define_name_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
5913 CmdDefineName
*me
= CMD_DEFINE_NAME (cmd
);
5914 GnmNamedExpr
*nexpr
= expr_name_lookup (&(me
->pp
), me
->name
);
5916 me
->new_name
= (nexpr
== NULL
);
5917 me
->placeholder
= (nexpr
!= NULL
)
5918 && expr_name_is_placeholder (nexpr
);
5920 if (me
->new_name
|| me
->placeholder
) {
5922 nexpr
= expr_name_add (&me
->pp
, me
->name
, me
->texpr
, &err
, TRUE
, NULL
);
5923 if (nexpr
== NULL
) {
5924 go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc
), _("Name"), err
);
5929 } else { /* changing the definition */
5930 GnmExprTop
const *tmp
= nexpr
->texpr
;
5931 gnm_expr_top_ref (tmp
);
5932 expr_name_set_expr (nexpr
, me
->texpr
);
5933 me
->texpr
= tmp
; /* store the old definition */
5935 WORKBOOK_FOREACH_VIEW (wb_control_get_workbook (wbc
), each_wbv
, {
5936 wb_view_menus_update (each_wbv
);
5943 cmd_define_name_finalize (GObject
*cmd
)
5945 CmdDefineName
*me
= CMD_DEFINE_NAME (cmd
);
5947 g_free (me
->name
); me
->name
= NULL
;
5950 gnm_expr_top_unref (me
->texpr
);
5954 gnm_command_finalize (cmd
);
5962 * @texpr: (transfer full): #GnmExprTop
5963 * @descriptor: optional descriptor.
5965 * If the @name has never been defined in context @pp create a new name
5966 * If its a placeholder assign @texpr to it and make it real
5967 * If it already exists as a real name just assign @expr.
5969 * Returns: %TRUE if there was a problem, %FALSE otherwise.
5972 cmd_define_name (WorkbookControl
*wbc
, char const *name
,
5973 GnmParsePos
const *pp
, GnmExprTop
const *texpr
,
5974 char const *descriptor
)
5977 GnmNamedExpr
*nexpr
;
5980 g_return_val_if_fail (name
!= NULL
, TRUE
);
5981 g_return_val_if_fail (pp
!= NULL
, TRUE
);
5982 g_return_val_if_fail (texpr
!= NULL
, TRUE
);
5984 if (name
[0] == '\0') {
5985 go_cmd_context_error_invalid
5986 (GO_CMD_CONTEXT (wbc
), _("Defined Name"),
5987 _("An empty string is not allowed as defined name."));
5988 gnm_expr_top_unref (texpr
);
5992 sheet
= wb_control_cur_sheet (wbc
);
5993 if (!expr_name_validate (name
)) {
5994 gchar
*err
= g_strdup_printf
5995 (_("'%s' is not allowed as defined name."), name
);
5996 go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc
),
5997 _("Defined Name"), err
);
5999 gnm_expr_top_unref (texpr
);
6003 if (expr_name_check_for_loop (name
, texpr
)) {
6004 go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc
), name
,
6005 _("has a circular reference"));
6006 gnm_expr_top_unref (texpr
);
6009 nexpr
= expr_name_lookup (pp
, name
);
6010 if (nexpr
!= NULL
&& !expr_name_is_placeholder (nexpr
) &&
6011 gnm_expr_top_equal (texpr
, nexpr
->texpr
)) {
6012 gnm_expr_top_unref (texpr
);
6013 return FALSE
; /* expr is not changing, do nothing */
6016 me
= g_object_new (CMD_DEFINE_NAME_TYPE
, NULL
);
6017 me
->name
= g_strdup (name
);
6021 me
->cmd
.sheet
= sheet
;
6024 if (descriptor
== NULL
) {
6028 /* Underscores need to be doubled. */
6029 res
= g_string_new (NULL
);
6030 for (tmp
= name
; *tmp
; tmp
++) {
6032 g_string_append_c (res
, '_');
6033 g_string_append_c (res
, *tmp
);
6036 nexpr
= expr_name_lookup (pp
, name
);
6037 if (nexpr
== NULL
|| expr_name_is_placeholder (nexpr
))
6038 me
->cmd
.cmd_descriptor
=
6039 g_strdup_printf (_("Define Name %s"), res
->str
);
6041 me
->cmd
.cmd_descriptor
=
6042 g_strdup_printf (_("Update Name %s"), res
->str
);
6043 g_string_free (res
, TRUE
);
6045 me
->cmd
.cmd_descriptor
= g_strdup (descriptor
);
6047 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6050 /******************************************************************/
6052 #define CMD_REMOVE_NAME_TYPE (cmd_remove_name_get_type ())
6053 #define CMD_REMOVE_NAME(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_REMOVE_NAME_TYPE, CmdRemoveName))
6059 GnmNamedExpr
*nexpr
;
6060 const GnmExprTop
*texpr
;
6063 MAKE_GNM_COMMAND (CmdRemoveName
, cmd_remove_name
, NULL
)
6066 cmd_remove_name_undo (GnmCommand
*cmd
,
6067 G_GNUC_UNUSED WorkbookControl
*wbc
)
6069 CmdRemoveName
*me
= CMD_REMOVE_NAME (cmd
);
6070 GnmNamedExpr
*nexpr
=
6071 expr_name_add (&me
->nexpr
->pos
, expr_name_name (me
->nexpr
),
6072 me
->texpr
, NULL
, TRUE
, NULL
);
6075 expr_name_ref (nexpr
);
6076 expr_name_unref (me
->nexpr
);
6080 g_warning ("Redefining name failed.");
6086 cmd_remove_name_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
6088 CmdRemoveName
*me
= CMD_REMOVE_NAME (cmd
);
6090 me
->texpr
= me
->nexpr
->texpr
;
6091 gnm_expr_top_ref (me
->texpr
);
6092 expr_name_downgrade_to_placeholder (me
->nexpr
);
6098 cmd_remove_name_finalize (GObject
*cmd
)
6100 CmdRemoveName
*me
= CMD_REMOVE_NAME (cmd
);
6102 expr_name_unref (me
->nexpr
);
6105 gnm_expr_top_unref (me
->texpr
);
6109 gnm_command_finalize (cmd
);
6115 * @nexpr: name to remove.
6117 * Returns TRUE on error
6120 cmd_remove_name (WorkbookControl
*wbc
, GnmNamedExpr
*nexpr
)
6124 g_return_val_if_fail (wbc
!= NULL
, TRUE
);
6125 g_return_val_if_fail (nexpr
!= NULL
, TRUE
);
6126 g_return_val_if_fail (!expr_name_is_placeholder (nexpr
), TRUE
);
6128 expr_name_ref (nexpr
);
6130 me
= g_object_new (CMD_REMOVE_NAME_TYPE
, NULL
);
6133 me
->cmd
.sheet
= wb_control_cur_sheet (wbc
);
6135 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Remove Name %s"),
6136 expr_name_name (nexpr
));
6138 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6141 /******************************************************************/
6143 #define CMD_RESCOPE_NAME_TYPE (cmd_rescope_name_get_type ())
6144 #define CMD_RESCOPE_NAME(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_RESCOPE_NAME_TYPE, CmdRescopeName))
6148 GnmNamedExpr
*nexpr
;
6152 MAKE_GNM_COMMAND (CmdRescopeName
, cmd_rescope_name
, NULL
)
6155 cmd_rescope_name_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6157 CmdRescopeName
*me
= CMD_RESCOPE_NAME (cmd
);
6158 Sheet
*old_scope
= me
->nexpr
->pos
.sheet
;
6160 GnmParsePos pp
= me
->nexpr
->pos
;
6162 pp
.sheet
= me
->scope
;
6163 err
= expr_name_set_pos (me
->nexpr
, &pp
);
6166 go_cmd_context_error_invalid (GO_CMD_CONTEXT (wbc
), _("Change Scope of Name"), err
);
6171 me
->scope
= old_scope
;
6176 cmd_rescope_name_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6178 return cmd_rescope_name_redo (cmd
, wbc
);
6183 cmd_rescope_name_finalize (GObject
*cmd
)
6185 CmdRescopeName
*me
= CMD_RESCOPE_NAME (cmd
);
6187 expr_name_unref (me
->nexpr
);
6188 gnm_command_finalize (cmd
);
6194 * @nexpr: name to rescope.
6197 * Returns: %TRUE if there was a problem, %FALSE otherwise.
6200 cmd_rescope_name (WorkbookControl
*wbc
, GnmNamedExpr
*nexpr
, Sheet
*scope
)
6204 g_return_val_if_fail (wbc
!= NULL
, TRUE
);
6205 g_return_val_if_fail (nexpr
!= NULL
, TRUE
);
6206 g_return_val_if_fail (!expr_name_is_placeholder (nexpr
), TRUE
);
6208 expr_name_ref (nexpr
);
6210 me
= g_object_new (CMD_RESCOPE_NAME_TYPE
, NULL
);
6213 me
->cmd
.sheet
= wb_control_cur_sheet (wbc
);
6215 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Change Scope of Name %s"),
6216 expr_name_name (nexpr
));
6218 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6220 /******************************************************************/
6222 #define CMD_SCENARIO_ADD_TYPE (cmd_scenario_add_get_type ())
6223 #define CMD_SCENARIO_ADD(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SCENARIO_ADD_TYPE, CmdScenarioAdd))
6227 GnmScenario
*scenario
;
6230 MAKE_GNM_COMMAND (CmdScenarioAdd
, cmd_scenario_add
, NULL
)
6233 cmd_scenario_add_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
6235 CmdScenarioAdd
*me
= CMD_SCENARIO_ADD (cmd
);
6236 GnmScenario
*sc
= g_object_ref (me
->scenario
);
6237 gnm_sheet_scenario_add (sc
->sheet
, sc
);
6242 cmd_scenario_add_undo (GnmCommand
*cmd
,
6243 G_GNUC_UNUSED WorkbookControl
*wbc
)
6245 CmdScenarioAdd
*me
= CMD_SCENARIO_ADD (cmd
);
6246 GnmScenario
*sc
= me
->scenario
;
6247 gnm_sheet_scenario_remove (sc
->sheet
, sc
);
6252 cmd_scenario_add_finalize (GObject
*cmd
)
6254 CmdScenarioAdd
*me
= CMD_SCENARIO_ADD (cmd
);
6256 g_object_unref (me
->scenario
);
6257 gnm_command_finalize (cmd
);
6261 * cmd_scenario_add: (skip)
6263 * @s: (transfer full):
6266 * Returns: %TRUE if there was a problem, %FALSE otherwise.
6269 cmd_scenario_add (WorkbookControl
*wbc
, GnmScenario
*s
, Sheet
*sheet
)
6273 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
6274 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
6276 me
= g_object_new (CMD_SCENARIO_ADD_TYPE
, NULL
);
6278 me
->scenario
= s
; /* Take ownership */
6279 me
->cmd
.sheet
= sheet
;
6281 me
->cmd
.cmd_descriptor
= g_strdup (_("Add scenario"));
6283 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6286 /******************************************************************/
6288 #define CMD_SCENARIO_MNGR_TYPE (cmd_scenario_mngr_get_type ())
6289 #define CMD_SCENARIO_MNGR(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SCENARIO_MNGR_TYPE, CmdScenarioMngr))
6297 MAKE_GNM_COMMAND (CmdScenarioMngr
, cmd_scenario_mngr
, NULL
)
6300 cmd_scenario_mngr_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
6302 CmdScenarioMngr
*me
= CMD_SCENARIO_MNGR (cmd
);
6304 me
->undo
= gnm_scenario_apply (me
->sc
);
6309 cmd_scenario_mngr_undo (GnmCommand
*cmd
,
6310 G_GNUC_UNUSED WorkbookControl
*wbc
)
6312 CmdScenarioMngr
*me
= CMD_SCENARIO_MNGR (cmd
);
6313 go_undo_undo_with_data (me
->undo
, GO_CMD_CONTEXT (wbc
));
6314 g_object_unref (me
->undo
);
6320 cmd_scenario_mngr_finalize (GObject
*cmd
)
6322 CmdScenarioMngr
*me
= CMD_SCENARIO_MNGR (cmd
);
6324 g_object_unref (me
->sc
);
6326 g_object_unref (me
->undo
);
6328 gnm_command_finalize (cmd
);
6332 cmd_scenario_mngr (WorkbookControl
*wbc
, GnmScenario
*sc
, GOUndo
*undo
)
6334 CmdScenarioMngr
*me
;
6336 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
6337 g_return_val_if_fail (GNM_IS_SCENARIO (sc
), TRUE
);
6339 me
= g_object_new (CMD_SCENARIO_MNGR_TYPE
, NULL
);
6341 me
->sc
= g_object_ref (sc
);
6342 me
->undo
= g_object_ref (undo
);
6343 me
->cmd
.sheet
= sc
->sheet
;
6345 me
->cmd
.cmd_descriptor
= g_strdup (_("Scenario Show"));
6347 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6350 /******************************************************************/
6352 #define CMD_DATA_SHUFFLE_TYPE (cmd_data_shuffle_get_type ())
6353 #define CMD_DATA_SHUFFLE(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_DATA_SHUFFLE_TYPE, CmdDataShuffle))
6357 data_shuffling_t
*ds
;
6360 MAKE_GNM_COMMAND (CmdDataShuffle
, cmd_data_shuffle
, NULL
)
6363 cmd_data_shuffle_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
6365 CmdDataShuffle
*me
= CMD_DATA_SHUFFLE (cmd
);
6367 data_shuffling_redo (me
->ds
);
6372 cmd_data_shuffle_undo (GnmCommand
*cmd
,
6373 G_GNUC_UNUSED WorkbookControl
*wbc
)
6375 CmdDataShuffle
*me
= CMD_DATA_SHUFFLE (cmd
);
6377 data_shuffling_redo (me
->ds
);
6382 cmd_data_shuffle_finalize (GObject
*cmd
)
6384 CmdDataShuffle
*me
= CMD_DATA_SHUFFLE (cmd
);
6386 data_shuffling_free (me
->ds
);
6387 gnm_command_finalize (cmd
);
6391 cmd_data_shuffle (WorkbookControl
*wbc
, data_shuffling_t
*sc
, Sheet
*sheet
)
6395 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
6396 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
6398 me
= g_object_new (CMD_DATA_SHUFFLE_TYPE
, NULL
);
6401 me
->cmd
.sheet
= sheet
;
6403 me
->cmd
.cmd_descriptor
= g_strdup (_("Shuffle Data"));
6405 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6408 /******************************************************************/
6410 #define CMD_TEXT_TO_COLUMNS_TYPE (cmd_text_to_columns_get_type ())
6411 #define CMD_TEXT_TO_COLUMNS(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_TEXT_TO_COLUMNS_TYPE, CmdTextToColumns))
6416 GnmCellRegion
*contents
;
6420 ColRowStateList
*saved_sizes
;
6423 MAKE_GNM_COMMAND (CmdTextToColumns
, cmd_text_to_columns
, NULL
)
6426 cmd_text_to_columns_impl (GnmCommand
*cmd
, WorkbookControl
*wbc
,
6429 CmdTextToColumns
*me
= CMD_TEXT_TO_COLUMNS (cmd
);
6430 GnmCellRegion
*contents
;
6432 g_return_val_if_fail (me
!= NULL
, TRUE
);
6433 g_return_val_if_fail (me
->contents
!= NULL
, TRUE
);
6435 contents
= clipboard_copy_range (me
->dst
.sheet
, &me
->dst
.range
);
6436 if (clipboard_paste_region (me
->contents
, &me
->dst
, GO_CMD_CONTEXT (wbc
))) {
6437 /* There was a problem, avoid leaking */
6438 cellregion_unref (contents
);
6442 cellregion_unref (me
->contents
);
6445 colrow_set_states (me
->dst
.sheet
, FALSE
,
6446 me
->dst
.range
.start
.row
, me
->saved_sizes
);
6447 colrow_state_list_destroy (me
->saved_sizes
);
6448 me
->saved_sizes
= NULL
;
6450 me
->saved_sizes
= colrow_get_states (me
->dst
.sheet
,
6451 FALSE
, me
->dst
.range
.start
.row
, me
->dst
.range
.end
.row
);
6452 rows_height_update (me
->dst
.sheet
, &me
->dst
.range
, FALSE
);
6455 me
->contents
= contents
;
6457 /* Select the newly pasted contents (this queues a redraw) */
6458 select_range (me
->dst
.sheet
, &me
->dst
.range
, wbc
);
6464 cmd_text_to_columns_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6466 return cmd_text_to_columns_impl (cmd
, wbc
, TRUE
);
6470 cmd_text_to_columns_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6472 return cmd_text_to_columns_impl (cmd
, wbc
, FALSE
);
6476 cmd_text_to_columns_finalize (GObject
*cmd
)
6478 CmdTextToColumns
*me
= CMD_TEXT_TO_COLUMNS (cmd
);
6480 if (me
->saved_sizes
)
6481 me
->saved_sizes
= colrow_state_list_destroy (me
->saved_sizes
);
6483 cellregion_unref (me
->contents
);
6484 me
->contents
= NULL
;
6486 gnm_command_finalize (cmd
);
6490 cmd_text_to_columns (WorkbookControl
*wbc
,
6491 GnmRange
const *src
, Sheet
*src_sheet
,
6492 GnmRange
const *target
, Sheet
*target_sheet
,
6493 GnmCellRegion
*contents
)
6495 CmdTextToColumns
*me
;
6496 char *src_range_name
, *target_range_name
;
6498 g_return_val_if_fail (contents
!= NULL
, TRUE
);
6500 src_range_name
= undo_range_name (src_sheet
, src
);
6501 target_range_name
= undo_range_name (target_sheet
, target
);
6503 me
= g_object_new (CMD_TEXT_TO_COLUMNS_TYPE
, NULL
);
6505 me
->cmd
.sheet
= (src_sheet
== target_sheet
? src_sheet
: NULL
);
6506 me
->cmd
.size
= 1; /* FIXME? */
6507 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Text (%s) to Columns (%s)"),
6510 me
->dst
.range
= *target
;
6511 me
->dst
.sheet
= target_sheet
;
6512 me
->dst
.paste_flags
= PASTE_CONTENTS
| PASTE_FORMATS
;
6514 me
->src_sheet
= src_sheet
;
6515 me
->contents
= contents
;
6516 me
->saved_sizes
= NULL
;
6518 g_free (src_range_name
);
6519 g_free (target_range_name
);
6521 /* Check array subdivision & merged regions */
6522 if (sheet_range_splits_region (target_sheet
, &me
->dst
.range
,
6523 NULL
, GO_CMD_CONTEXT (wbc
), me
->cmd
.cmd_descriptor
)) {
6524 g_object_unref (me
);
6528 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6531 /******************************************************************/
6533 #define CMD_GENERIC_TYPE (cmd_generic_get_type ())
6534 #define CMD_GENERIC(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_GENERIC_TYPE, CmdGeneric))
6538 GOUndo
*undo
, *redo
;
6541 MAKE_GNM_COMMAND (CmdGeneric
, cmd_generic
, NULL
)
6544 cmd_generic_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6546 CmdGeneric
*me
= CMD_GENERIC (cmd
);
6547 go_undo_undo_with_data (me
->undo
, GO_CMD_CONTEXT (wbc
));
6552 cmd_generic_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6554 CmdGeneric
*me
= CMD_GENERIC (cmd
);
6555 go_undo_undo_with_data (me
->redo
, GO_CMD_CONTEXT (wbc
));
6560 cmd_generic_finalize (GObject
*cmd
)
6562 CmdGeneric
*me
= CMD_GENERIC (cmd
);
6564 g_object_unref (me
->undo
);
6565 g_object_unref (me
->redo
);
6567 gnm_command_finalize (cmd
);
6571 cmd_generic_with_size (WorkbookControl
*wbc
, const char *txt
,
6573 GOUndo
*undo
, GOUndo
*redo
)
6577 g_return_val_if_fail (GO_IS_UNDO (undo
), TRUE
);
6578 g_return_val_if_fail (GO_IS_UNDO (redo
), TRUE
);
6580 me
= g_object_new (CMD_GENERIC_TYPE
, NULL
);
6582 me
->cmd
.sheet
= wb_control_cur_sheet (wbc
);
6583 me
->cmd
.size
= size
;
6584 me
->cmd
.cmd_descriptor
= g_strdup (txt
);
6589 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6593 cmd_generic (WorkbookControl
*wbc
, const char *txt
, GOUndo
*undo
, GOUndo
*redo
)
6595 return cmd_generic_with_size (wbc
, txt
, 1, undo
, redo
);
6598 /******************************************************************/
6600 #define CMD_GOAL_SEEK_TYPE (cmd_goal_seek_get_type ())
6601 #define CMD_GOAL_SEEK(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_GOAL_SEEK_TYPE, CmdGoalSeek))
6611 MAKE_GNM_COMMAND (CmdGoalSeek
, cmd_goal_seek
, NULL
)
6614 cmd_goal_seek_impl (GnmCell
*cell
, GnmValue
*value
)
6616 sheet_cell_set_value (cell
, value_dup(value
));
6622 cmd_goal_seek_undo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
6624 CmdGoalSeek
*me
= CMD_GOAL_SEEK (cmd
);
6626 return cmd_goal_seek_impl (me
->cell
, me
->ov
);
6630 cmd_goal_seek_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
6632 CmdGoalSeek
*me
= CMD_GOAL_SEEK (cmd
);
6634 return cmd_goal_seek_impl (me
->cell
, me
->nv
);
6638 cmd_goal_seek_finalize (GObject
*cmd
)
6640 CmdGoalSeek
*me
= CMD_GOAL_SEEK (cmd
);
6642 value_release (me
->ov
);
6644 value_release (me
->nv
);
6647 gnm_command_finalize (cmd
);
6651 cmd_goal_seek (WorkbookControl
*wbc
, GnmCell
*cell
, GnmValue
*ov
, GnmValue
*nv
)
6656 g_return_val_if_fail (cell
!= NULL
, TRUE
);
6657 g_return_val_if_fail (ov
!= NULL
|| nv
!= NULL
, TRUE
);
6659 me
= g_object_new (CMD_GOAL_SEEK_TYPE
, NULL
);
6661 me
->cmd
.sheet
= cell
->base
.sheet
;
6663 range_init_cellpos (&range
, &cell
->pos
);
6664 me
->cmd
.cmd_descriptor
= g_strdup_printf
6665 (_("Goal Seek (%s)"), undo_range_name (cell
->base
.sheet
, &range
));
6672 me
->ov
= value_dup (cell
->value
);
6674 me
->nv
= value_dup (cell
->value
);
6676 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6679 /******************************************************************/
6682 #define CMD_FREEZE_PANES_TYPE (cmd_freeze_panes_get_type ())
6683 #define CMD_FREEZE_PANES(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_FREEZE_PANES_TYPE, CmdFreezePanes))
6692 MAKE_GNM_COMMAND (CmdFreezePanes
, cmd_freeze_panes
, NULL
)
6695 cmd_freeze_panes_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6697 CmdFreezePanes
*me
= CMD_FREEZE_PANES (cmd
);
6703 cmd_freeze_panes_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6705 CmdFreezePanes
*me
= CMD_FREEZE_PANES (cmd
);
6711 cmd_freeze_panes_finalize (GObject
*cmd
)
6713 CmdFreezePanes
*me
= CMD_FREEZE_PANES (cmd
);
6715 gnm_command_finalize (cmd
);
6720 * @wbc: where to report errors
6721 * @sv: the view to freeze
6725 * Returns: %TRUE if there was a problem, %FALSE otherwise.
6728 cmd_freeze_panes (WorkbookControl
*wbc
, SheetView
*sv
,
6729 GnmCellPos
const *frozen
, GnmCellPos
const *unfrozen
)
6733 g_return_val_if_fail (name
!= NULL
, TRUE
);
6734 g_return_val_if_fail (pp
!= NULL
, TRUE
);
6735 g_return_val_if_fail (expr
!= NULL
, TRUE
);
6737 me
= g_object_new (CMD_FREEZE_PANES_TYPE
, NULL
);
6740 me
->unfrozen
= expr
;
6741 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6747 /******************************************************************/
6750 #define CMD_TABULATE_TYPE (cmd_tabulate_get_type ())
6751 #define CMD_TABULATE(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_TABULATE_TYPE, CmdTabulate))
6756 GnmTabulateInfo
*data
;
6759 MAKE_GNM_COMMAND (CmdTabulate
, cmd_tabulate
, NULL
)
6762 cmd_tabulate_cmp_f (gconstpointer a
,
6765 guint
const a_val
= GPOINTER_TO_INT (a
);
6766 guint
const b_val
= GPOINTER_TO_INT (b
);
6776 cmd_tabulate_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6778 CmdTabulate
*me
= CMD_TABULATE (cmd
);
6780 gboolean res
= TRUE
;
6782 me
->sheet_idx
= g_slist_sort (me
->sheet_idx
,
6783 cmd_tabulate_cmp_f
);
6785 for (l
= me
->sheet_idx
; l
!= NULL
; l
= l
->next
) {
6786 int i
= GPOINTER_TO_INT (l
->data
);
6788 workbook_sheet_by_index (wb_control_get_workbook (wbc
),
6790 res
= res
&& command_undo_sheet_delete (new_sheet
);
6796 cmd_tabulate_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
6798 CmdTabulate
*me
= CMD_TABULATE (cmd
);
6800 g_slist_free (me
->sheet_idx
);
6801 me
->sheet_idx
= do_tabulation (wbc
, me
->data
);
6803 return (me
->sheet_idx
== NULL
);
6807 cmd_tabulate_finalize (GObject
*cmd
)
6809 CmdTabulate
*me
= CMD_TABULATE (cmd
);
6811 g_free (me
->data
->cells
);
6812 g_free (me
->data
->minima
);
6813 g_free (me
->data
->maxima
);
6814 g_free (me
->data
->steps
);
6816 gnm_command_finalize (cmd
);
6820 cmd_tabulate (WorkbookControl
*wbc
, gpointer data
)
6824 g_return_val_if_fail (data
!= NULL
, TRUE
);
6826 me
= g_object_new (CMD_TABULATE_TYPE
, NULL
);
6828 me
->cmd
.sheet
= NULL
;
6830 me
->cmd
.cmd_descriptor
=
6831 g_strdup_printf (_("Tabulating Dependencies"));
6833 me
->sheet_idx
= NULL
;
6835 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6838 /******************************************************************/
6840 #define CMD_SO_GRAPH_CONFIG_TYPE (cmd_so_graph_config_get_type ())
6841 #define CMD_SO_GRAPH_CONFIG(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_GRAPH_CONFIG_TYPE, CmdSOGraphConfig))
6846 GogGraph
*new_graph
;
6847 GogGraph
*old_graph
;
6850 MAKE_GNM_COMMAND (CmdSOGraphConfig
, cmd_so_graph_config
, NULL
)
6853 cmd_so_graph_config_redo (GnmCommand
*cmd
,
6854 G_GNUC_UNUSED WorkbookControl
*wbc
)
6856 CmdSOGraphConfig
*me
= CMD_SO_GRAPH_CONFIG (cmd
);
6857 sheet_object_graph_set_gog (me
->so
, me
->new_graph
);
6862 cmd_so_graph_config_undo (GnmCommand
*cmd
,
6863 G_GNUC_UNUSED WorkbookControl
*wbc
)
6865 CmdSOGraphConfig
*me
= CMD_SO_GRAPH_CONFIG (cmd
);
6866 sheet_object_graph_set_gog (me
->so
, me
->old_graph
);
6871 cmd_so_graph_config_finalize (GObject
*cmd
)
6873 CmdSOGraphConfig
*me
= CMD_SO_GRAPH_CONFIG (cmd
);
6875 g_object_unref (me
->so
);
6876 g_object_unref (me
->new_graph
);
6877 g_object_unref (me
->old_graph
);
6879 gnm_command_finalize (cmd
);
6883 cmd_so_graph_config (WorkbookControl
*wbc
, SheetObject
*so
,
6884 GObject
*n_graph
, GObject
*o_graph
)
6886 CmdSOGraphConfig
*me
;
6888 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
6889 g_return_val_if_fail (GNM_IS_SO_GRAPH (so
), TRUE
);
6890 g_return_val_if_fail (GOG_IS_GRAPH (n_graph
), TRUE
);
6891 g_return_val_if_fail (GOG_IS_GRAPH (o_graph
), TRUE
);
6893 me
= g_object_new (CMD_SO_GRAPH_CONFIG_TYPE
, NULL
);
6898 me
->new_graph
= GOG_GRAPH (n_graph
);
6899 g_object_ref (me
->new_graph
);
6900 me
->old_graph
= GOG_GRAPH (o_graph
);
6901 g_object_ref (me
->old_graph
);
6903 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
6905 me
->cmd
.cmd_descriptor
= g_strdup (_("Reconfigure Graph"));
6907 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6910 /******************************************************************/
6912 #define CMD_SO_COMPONENT_CONFIG_TYPE (cmd_so_component_config_get_type ())
6913 #define CMD_SO_COMPONENT_CONFIG(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_COMPONENT_CONFIG_TYPE, CmdSOComponentConfig))
6918 GOComponent
*new_obj
;
6919 GOComponent
*old_obj
;
6920 } CmdSOComponentConfig
;
6922 MAKE_GNM_COMMAND (CmdSOComponentConfig
, cmd_so_component_config
, NULL
)
6925 cmd_so_component_config_redo (GnmCommand
*cmd
,
6926 G_GNUC_UNUSED WorkbookControl
*wbc
)
6928 CmdSOComponentConfig
*me
= CMD_SO_COMPONENT_CONFIG (cmd
);
6929 sheet_object_component_set_component (me
->so
, me
->new_obj
);
6934 cmd_so_component_config_undo (GnmCommand
*cmd
,
6935 G_GNUC_UNUSED WorkbookControl
*wbc
)
6937 CmdSOComponentConfig
*me
= CMD_SO_COMPONENT_CONFIG (cmd
);
6938 sheet_object_component_set_component (me
->so
, me
->old_obj
);
6943 cmd_so_component_config_finalize (GObject
*cmd
)
6945 CmdSOComponentConfig
*me
= CMD_SO_COMPONENT_CONFIG (cmd
);
6947 g_object_unref (me
->so
);
6948 g_object_unref (me
->new_obj
);
6949 g_object_unref (me
->old_obj
);
6951 gnm_command_finalize (cmd
);
6955 cmd_so_component_config (WorkbookControl
*wbc
, SheetObject
*so
,
6956 GObject
*n_obj
, GObject
*o_obj
)
6958 CmdSOComponentConfig
*me
;
6960 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
6961 g_return_val_if_fail (GNM_IS_SO_COMPONENT (so
), TRUE
);
6962 g_return_val_if_fail (GO_IS_COMPONENT (n_obj
), TRUE
);
6963 g_return_val_if_fail (GO_IS_COMPONENT (o_obj
), TRUE
);
6965 me
= g_object_new (CMD_SO_COMPONENT_CONFIG_TYPE
, NULL
);
6970 me
->new_obj
= GO_COMPONENT (g_object_ref (n_obj
));
6971 me
->old_obj
= GO_COMPONENT (g_object_ref (o_obj
));
6973 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
6975 me
->cmd
.cmd_descriptor
= g_strdup (_("Reconfigure Object"));
6977 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
6980 /******************************************************************/
6982 #define CMD_TOGGLE_RTL_TYPE (cmd_toggle_rtl_get_type ())
6983 #define CMD_TOGGLE_RTL(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_TOGGLE_RTL_TYPE, CmdToggleRTL))
6985 typedef GnmCommand CmdToggleRTL
;
6987 MAKE_GNM_COMMAND (CmdToggleRTL
, cmd_toggle_rtl
, NULL
)
6990 cmd_toggle_rtl_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
6992 go_object_toggle (cmd
->sheet
, "text-is-rtl");
6997 cmd_toggle_rtl_undo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
6999 return cmd_toggle_rtl_redo (cmd
, wbc
);
7003 cmd_toggle_rtl_finalize (GObject
*cmd
)
7005 gnm_command_finalize (cmd
);
7009 cmd_toggle_rtl (WorkbookControl
*wbc
, Sheet
*sheet
)
7013 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7014 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
7016 me
= g_object_new (CMD_TOGGLE_RTL_TYPE
, NULL
);
7019 me
->cmd_descriptor
= g_strdup (sheet
->text_is_rtl
? _("Left to Right") : _("Right to Left"));
7021 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7024 /******************************************************************/
7026 #define CMD_SO_SET_VALUE_TYPE (cmd_so_set_value_get_type ())
7027 #define CMD_SO_SET_VALUE(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_SET_VALUE_TYPE, CmdSOSetValue))
7036 MAKE_GNM_COMMAND (CmdSOSetValue
, cmd_so_set_value
, NULL
)
7039 cmd_so_set_value_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7041 CmdSOSetValue
*me
= CMD_SO_SET_VALUE (cmd
);
7042 Sheet
*sheet
= me
->ref
.sheet
;
7043 GnmCell
*cell
= sheet_cell_fetch (sheet
, me
->ref
.col
, me
->ref
.row
);
7045 sheet_cell_set_value (cell
, value_dup (me
->val
));
7046 sheet_update (sheet
);
7052 cmd_so_set_value_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
7054 CmdSOSetValue
*me
= CMD_SO_SET_VALUE (cmd
);
7056 go_undo_undo_with_data (me
->undo
, GO_CMD_CONTEXT (wbc
));
7062 cmd_so_set_value_finalize (GObject
*cmd
)
7064 CmdSOSetValue
*me
= CMD_SO_SET_VALUE (cmd
);
7066 value_release (me
->val
);
7067 g_object_unref (me
->undo
);
7069 gnm_command_finalize (cmd
);
7073 cmd_so_set_value (WorkbookControl
*wbc
,
7075 const GnmCellRef
*pref
,
7082 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7084 r
.start
.col
= r
.end
.col
= pref
->col
;
7085 r
.start
.row
= r
.end
.row
= pref
->row
;
7087 me
= g_object_new (CMD_SO_SET_VALUE_TYPE
, NULL
);
7088 me
->cmd
.sheet
= sheet
;
7090 me
->cmd
.cmd_descriptor
= g_strdup (text
);
7093 me
->undo
= clipboard_copy_range_undo (pref
->sheet
, &r
);
7095 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7098 /******************************************************************/
7100 #define CMD_HYPERLINK_TYPE (cmd_hyperlink_get_type ())
7101 #define CMD_HYPERLINK(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_HYPERLINK_TYPE, CmdHyperlink))
7106 GnmStyle
*new_style
;
7109 gboolean update_size
;
7113 cmd_hyperlink_repeat (GnmCommand
const *cmd
, WorkbookControl
*wbc
)
7115 CmdHyperlink
const *orig
= (CmdHyperlink
const *) cmd
;
7117 if (orig
->new_style
)
7118 gnm_style_ref (orig
->new_style
);
7120 cmd_selection_hyperlink (wbc
, orig
->new_style
, NULL
,
7121 g_strdup (orig
->opt_content
));
7123 MAKE_GNM_COMMAND (CmdHyperlink
, cmd_hyperlink
, cmd_hyperlink_repeat
)
7126 cmd_hyperlink_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
7128 CmdHyperlink
*me
= CMD_HYPERLINK (cmd
);
7129 Workbook
*wb
= wb_control_get_workbook (wbc
);
7132 go_undo_undo (me
->undo
);
7133 g_clear_object (&me
->undo
);
7136 select_selection (me
->cmd
.sheet
, me
->selection
, wbc
);
7138 WORKBOOK_FOREACH_CONTROL (wb
, view
, ctl
, {
7139 wb_control_menu_state_update (ctl
, MS_COMMENT_LINKS
);
7146 cb_hyperlink_set_text (GnmCellIter
const *iter
, gpointer user
)
7148 CmdHyperlink
*me
= user
;
7149 GnmCell
*cell
= iter
->cell
;
7152 cell
= sheet_cell_fetch (iter
->pp
.sheet
,
7156 /* We skip non-empty cells. */
7157 if (gnm_cell_is_empty (cell
) &&
7158 !gnm_cell_is_nonsingleton_array (cell
)) {
7159 sheet_cell_set_value (cell
, value_new_string (me
->opt_content
));
7160 if (me
->update_size
)
7168 cmd_hyperlink_redo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
7170 CmdHyperlink
*me
= CMD_HYPERLINK (cmd
);
7172 Workbook
*wb
= wb_control_get_workbook (wbc
);
7175 g_return_val_if_fail (me
!= NULL
, TRUE
);
7177 sheet
= me
->cmd
.sheet
;
7179 /* Check for locked cells */
7180 if (cmd_selection_is_locked_effective (sheet
, me
->selection
,
7181 wbc
, _("Changing Hyperlink")))
7184 me
->undo
= clipboard_copy_ranges_undo (sheet
, me
->selection
);
7186 for (l
= me
->selection
; l
; l
= l
->next
) {
7187 GnmRange
const *r
= l
->data
;
7189 if (me
->new_style
) {
7190 gnm_style_ref (me
->new_style
);
7191 sheet_apply_style (sheet
, r
, me
->new_style
);
7192 sheet_flag_style_update_range (sheet
, r
);
7195 if (me
->opt_content
) {
7196 sheet_foreach_cell_in_range (sheet
, CELL_ITER_ALL
, r
,
7197 cb_hyperlink_set_text
,
7201 me
->update_size
= FALSE
;
7203 sheet_redraw_all (sheet
, FALSE
);
7204 sheet_mark_dirty (sheet
);
7206 select_selection (sheet
, me
->selection
, wbc
);
7208 WORKBOOK_FOREACH_CONTROL (wb
, view
, ctl
,
7209 wb_control_menu_state_update (ctl
, MS_COMMENT_LINKS
););
7215 cmd_hyperlink_finalize (GObject
*cmd
)
7217 CmdHyperlink
*me
= CMD_HYPERLINK (cmd
);
7219 g_clear_object (&me
->undo
);
7222 gnm_style_unref (me
->new_style
);
7223 me
->new_style
= NULL
;
7225 range_fragment_free (me
->selection
);
7226 me
->selection
= NULL
;
7228 g_free (me
->opt_content
);
7230 gnm_command_finalize (cmd
);
7234 * cmd_selection_hyperlink:
7235 * @wbc: the workbook control.
7236 * @style: (transfer full): style to apply to the selection
7237 * @opt_translated_name: An optional name to use in place of 'Hyperlink Cells'
7238 * @opt_content: optional content for otherwise empty cells.
7240 * Returns: %TRUE if there was a problem, %FALSE otherwise.
7243 cmd_selection_hyperlink (WorkbookControl
*wbc
,
7245 char const *opt_translated_name
,
7249 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
7251 me
= g_object_new (CMD_HYPERLINK_TYPE
, NULL
);
7253 me
->selection
= selection_get_ranges (sv
, FALSE
); /* TRUE ? */
7254 me
->new_style
= style
;
7256 me
->cmd
.sheet
= sv_sheet (sv
);
7257 me
->cmd
.size
= 1; /* Updated later. */
7258 me
->update_size
= TRUE
;
7260 me
->opt_content
= opt_content
;
7262 if (opt_translated_name
== NULL
) {
7263 char *names
= undo_range_list_name (me
->cmd
.sheet
, me
->selection
);
7265 me
->cmd
.cmd_descriptor
= g_strdup_printf (_("Changing hyperlink of %s"), names
);
7268 me
->cmd
.cmd_descriptor
= g_strdup (opt_translated_name
);
7271 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7274 /******************************************************************/
7277 #define CMD_SO_SET_LINKS_TYPE (cmd_so_set_links_get_type ())
7278 #define CMD_SO_SET_LINKS(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_SET_LINKS_TYPE, CmdSOSetLink))
7283 GnmExprTop
const *output
;
7284 GnmExprTop
const *content
;
7288 MAKE_GNM_COMMAND (CmdSOSetLink
, cmd_so_set_links
, NULL
)
7291 cmd_so_set_links_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7293 CmdSOSetLink
*me
= CMD_SO_SET_LINKS (cmd
);
7294 GnmExprTop
const *old_output
;
7295 GnmExprTop
const *old_content
;
7296 gboolean old_as_index
;
7298 old_content
= sheet_widget_list_base_get_content_link (me
->so
);
7299 old_output
= sheet_widget_list_base_get_result_link (me
->so
);
7300 old_as_index
= sheet_widget_list_base_result_type_is_index (me
->so
);
7302 sheet_widget_list_base_set_links
7303 (me
->so
, me
->output
, me
->content
);
7304 if (old_as_index
!= me
->as_index
) {
7305 sheet_widget_list_base_set_result_type (me
->so
, me
->as_index
);
7306 me
->as_index
= old_as_index
;
7309 gnm_expr_top_unref (me
->output
);
7311 gnm_expr_top_unref (me
->content
);
7312 me
->output
= old_output
;
7313 me
->content
= old_content
;
7319 cmd_so_set_links_undo (GnmCommand
*cmd
, WorkbookControl
*wbc
)
7321 return cmd_so_set_links_redo (cmd
, wbc
);
7325 cmd_so_set_links_finalize (GObject
*cmd
)
7327 CmdSOSetLink
*me
= CMD_SO_SET_LINKS (cmd
);
7330 gnm_expr_top_unref (me
->output
);
7332 gnm_expr_top_unref (me
->content
);
7333 gnm_command_finalize (cmd
);
7337 cmd_so_set_links (WorkbookControl
*wbc
,
7339 GnmExprTop
const *output
,
7340 GnmExprTop
const *content
,
7345 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7347 me
= g_object_new (CMD_SO_SET_LINKS_TYPE
, NULL
);
7348 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
7350 me
->cmd
.cmd_descriptor
= g_strdup (_("Configure List"));
7352 me
->output
= output
;
7353 me
->content
= content
;
7354 me
->as_index
= as_index
;
7356 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7359 /******************************************************************/
7363 #define CMD_SO_SET_FRAME_LABEL_TYPE (cmd_so_set_frame_label_get_type ())
7364 #define CMD_SO_SET_FRAME_LABEL(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_SET_FRAME_LABEL_TYPE, CmdSOSetFrameLabel))
7371 } CmdSOSetFrameLabel
;
7373 MAKE_GNM_COMMAND (CmdSOSetFrameLabel
, cmd_so_set_frame_label
, NULL
)
7376 cmd_so_set_frame_label_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7378 CmdSOSetFrameLabel
*me
= CMD_SO_SET_FRAME_LABEL (cmd
);
7380 sheet_widget_frame_set_label (me
->so
, me
->new_label
);
7386 cmd_so_set_frame_label_undo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7388 CmdSOSetFrameLabel
*me
= CMD_SO_SET_FRAME_LABEL (cmd
);
7390 sheet_widget_frame_set_label (me
->so
, me
->old_label
);
7396 cmd_so_set_frame_label_finalize (GObject
*cmd
)
7398 CmdSOSetFrameLabel
*me
= CMD_SO_SET_FRAME_LABEL (cmd
);
7400 g_free (me
->old_label
);
7401 me
->old_label
= NULL
;
7403 g_free (me
->new_label
);
7404 me
->new_label
= NULL
;
7406 gnm_command_finalize (cmd
);
7410 cmd_so_set_frame_label (WorkbookControl
*wbc
,
7412 char *old_label
, char *new_label
)
7414 CmdSOSetFrameLabel
*me
;
7416 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7418 me
= g_object_new (CMD_SO_SET_FRAME_LABEL_TYPE
, NULL
);
7419 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
7421 me
->cmd
.cmd_descriptor
= g_strdup (_("Set Frame Label"));
7423 me
->old_label
= old_label
;
7424 me
->new_label
= new_label
;
7426 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7429 /******************************************************************/
7430 #define CMD_SO_SET_BUTTON_TYPE (cmd_so_set_button_get_type ())
7431 #define CMD_SO_SET_BUTTON(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_SET_BUTTON_TYPE, CmdSOSetButton))
7436 GnmExprTop
const *new_link
;
7437 GnmExprTop
const *old_link
;
7442 MAKE_GNM_COMMAND (CmdSOSetButton
, cmd_so_set_button
, NULL
)
7445 cmd_so_set_button_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7447 CmdSOSetButton
*me
= CMD_SO_SET_BUTTON (cmd
);
7449 sheet_widget_button_set_link (me
->so
, me
->new_link
);
7450 sheet_widget_button_set_label (me
->so
, me
->new_label
);
7456 cmd_so_set_button_undo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7458 CmdSOSetButton
*me
= CMD_SO_SET_BUTTON (cmd
);
7460 sheet_widget_button_set_link (me
->so
, me
->old_link
);
7461 sheet_widget_button_set_label (me
->so
, me
->old_label
);
7467 cmd_so_set_button_finalize (GObject
*cmd
)
7469 CmdSOSetButton
*me
= CMD_SO_SET_BUTTON (cmd
);
7472 gnm_expr_top_unref (me
->new_link
);
7474 gnm_expr_top_unref (me
->old_link
);
7475 g_free (me
->old_label
);
7476 g_free (me
->new_label
);
7477 gnm_command_finalize (cmd
);
7481 cmd_so_set_button (WorkbookControl
*wbc
,
7482 SheetObject
*so
, GnmExprTop
const *lnk
,
7483 char *old_label
, char *new_label
)
7487 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7489 me
= g_object_new (CMD_SO_SET_BUTTON_TYPE
, NULL
);
7490 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
7492 me
->cmd
.cmd_descriptor
= g_strdup (_("Configure Button"));
7495 me
->old_label
= old_label
;
7496 me
->new_label
= new_label
;
7498 me
->old_link
= sheet_widget_button_get_link (so
);
7500 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7503 /******************************************************************/
7504 #define CMD_SO_SET_RADIO_BUTTON_TYPE (cmd_so_set_radio_button_get_type ())
7505 #define CMD_SO_SET_RADIO_BUTTON(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_SET_RADIO_BUTTON_TYPE, CmdSOSetRadioButton))
7510 GnmExprTop
const *new_link
;
7511 GnmExprTop
const *old_link
;
7514 GnmValue
*old_value
;
7515 GnmValue
*new_value
;
7516 } CmdSOSetRadioButton
;
7518 MAKE_GNM_COMMAND (CmdSOSetRadioButton
, cmd_so_set_radio_button
, NULL
)
7521 cmd_so_set_radio_button_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7523 CmdSOSetRadioButton
*me
= CMD_SO_SET_RADIO_BUTTON (cmd
);
7525 sheet_widget_radio_button_set_link (me
->so
, me
->new_link
);
7526 sheet_widget_radio_button_set_label (me
->so
, me
->new_label
);
7527 sheet_widget_radio_button_set_value (me
->so
, me
->new_value
);
7533 cmd_so_set_radio_button_undo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7535 CmdSOSetRadioButton
*me
= CMD_SO_SET_RADIO_BUTTON (cmd
);
7537 sheet_widget_radio_button_set_link (me
->so
, me
->old_link
);
7538 sheet_widget_radio_button_set_label (me
->so
, me
->old_label
);
7539 sheet_widget_radio_button_set_value (me
->so
, me
->old_value
);
7545 cmd_so_set_radio_button_finalize (GObject
*cmd
)
7547 CmdSOSetRadioButton
*me
= CMD_SO_SET_RADIO_BUTTON (cmd
);
7550 gnm_expr_top_unref (me
->new_link
);
7552 gnm_expr_top_unref (me
->old_link
);
7553 g_free (me
->old_label
);
7554 g_free (me
->new_label
);
7555 value_release (me
->old_value
);
7556 value_release (me
->new_value
);
7557 gnm_command_finalize (cmd
);
7561 cmd_so_set_radio_button (WorkbookControl
*wbc
,
7562 SheetObject
*so
, GnmExprTop
const *lnk
,
7563 char *old_label
, char *new_label
,
7564 GnmValue
*old_value
, GnmValue
*new_value
)
7566 CmdSOSetRadioButton
*me
;
7568 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7570 me
= g_object_new (CMD_SO_SET_RADIO_BUTTON_TYPE
, NULL
);
7571 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
7573 me
->cmd
.cmd_descriptor
= g_strdup (_("Configure Radio Button"));
7576 me
->old_label
= old_label
;
7577 me
->new_label
= new_label
;
7578 me
->old_value
= old_value
;
7579 me
->new_value
= new_value
;
7581 me
->old_link
= sheet_widget_radio_button_get_link (so
);
7583 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7586 /******************************************************************/
7587 #define CMD_SO_SET_CHECKBOX_TYPE (cmd_so_set_checkbox_get_type ())
7588 #define CMD_SO_SET_CHECKBOX(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_SET_CHECKBOX_TYPE, CmdSOSetCheckbox))
7593 GnmExprTop
const *new_link
;
7594 GnmExprTop
const *old_link
;
7599 MAKE_GNM_COMMAND (CmdSOSetCheckbox
, cmd_so_set_checkbox
, NULL
)
7602 cmd_so_set_checkbox_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7604 CmdSOSetCheckbox
*me
= CMD_SO_SET_CHECKBOX (cmd
);
7606 sheet_widget_checkbox_set_link (me
->so
, me
->new_link
);
7607 sheet_widget_checkbox_set_label (me
->so
, me
->new_label
);
7613 cmd_so_set_checkbox_undo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7615 CmdSOSetCheckbox
*me
= CMD_SO_SET_CHECKBOX (cmd
);
7617 sheet_widget_checkbox_set_link (me
->so
, me
->old_link
);
7618 sheet_widget_checkbox_set_label (me
->so
, me
->old_label
);
7624 cmd_so_set_checkbox_finalize (GObject
*cmd
)
7626 CmdSOSetCheckbox
*me
= CMD_SO_SET_CHECKBOX (cmd
);
7629 gnm_expr_top_unref (me
->new_link
);
7631 gnm_expr_top_unref (me
->old_link
);
7632 g_free (me
->old_label
);
7633 g_free (me
->new_label
);
7634 gnm_command_finalize (cmd
);
7638 cmd_so_set_checkbox (WorkbookControl
*wbc
,
7639 SheetObject
*so
, GnmExprTop
const *lnk
,
7640 char *old_label
, char *new_label
)
7642 CmdSOSetCheckbox
*me
;
7644 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7646 me
= g_object_new (CMD_SO_SET_CHECKBOX_TYPE
, NULL
);
7647 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
7649 me
->cmd
.cmd_descriptor
= g_strdup (_("Configure Checkbox"));
7652 me
->old_label
= old_label
;
7653 me
->new_label
= new_label
;
7655 me
->old_link
= sheet_widget_checkbox_get_link (so
);
7657 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7660 /******************************************************************/
7662 #define CMD_SO_SET_ADJUSTMENT_TYPE (cmd_so_set_adjustment_get_type ())
7663 #define CMD_SO_SET_ADJUSTMENT(o) (G_TYPE_CHECK_INSTANCE_CAST ((o), CMD_SO_SET_ADJUSTMENT_TYPE, CmdSOSetAdjustment))
7668 GnmExprTop
const *new_link
;
7669 GnmExprTop
const *old_link
;
7674 gboolean old_horizontal
;
7675 } CmdSOSetAdjustment
;
7677 MAKE_GNM_COMMAND (CmdSOSetAdjustment
, cmd_so_set_adjustment
, NULL
)
7680 cmd_so_set_adjustment_adj (CmdSOSetAdjustment
*me
)
7682 GtkAdjustment
*adj
= sheet_widget_adjustment_get_adjustment (me
->so
);
7684 double old_lower
= gtk_adjustment_get_lower (adj
);
7685 double old_upper
= gtk_adjustment_get_upper (adj
);
7686 double old_step
= gtk_adjustment_get_step_increment (adj
);
7687 double old_page
= gtk_adjustment_get_page_increment (adj
);
7688 gboolean old_horizontal
;
7689 g_object_get (G_OBJECT (me
->so
), "horizontal", &old_horizontal
, NULL
);
7691 gtk_adjustment_configure (adj
,
7692 gtk_adjustment_get_value (adj
),
7697 gtk_adjustment_get_page_size (adj
));
7698 g_object_set (G_OBJECT (me
->so
), "horizontal", me
->old_horizontal
, NULL
);
7700 me
->old_lower
= old_lower
;
7701 me
->old_upper
= old_upper
;
7702 me
->old_step
= old_step
;
7703 me
->old_page
= old_page
;
7704 me
->old_horizontal
= old_horizontal
;
7708 cmd_so_set_adjustment_redo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7710 CmdSOSetAdjustment
*me
= CMD_SO_SET_ADJUSTMENT (cmd
);
7712 sheet_widget_adjustment_set_link (me
->so
, me
->new_link
);
7713 cmd_so_set_adjustment_adj (me
);
7718 cmd_so_set_adjustment_undo (GnmCommand
*cmd
, G_GNUC_UNUSED WorkbookControl
*wbc
)
7720 CmdSOSetAdjustment
*me
= CMD_SO_SET_ADJUSTMENT (cmd
);
7722 sheet_widget_adjustment_set_link (me
->so
, me
->old_link
);
7723 cmd_so_set_adjustment_adj (me
);
7729 cmd_so_set_adjustment_finalize (GObject
*cmd
)
7731 CmdSOSetAdjustment
*me
= CMD_SO_SET_ADJUSTMENT (cmd
);
7734 gnm_expr_top_unref (me
->new_link
);
7736 gnm_expr_top_unref (me
->old_link
);
7737 gnm_command_finalize (cmd
);
7741 cmd_so_set_adjustment (WorkbookControl
*wbc
,
7742 SheetObject
*so
, GnmExprTop
const *lnk
,
7743 gboolean horizontal
,
7744 int lower
, int upper
,
7746 char const *undo_label
)
7748 CmdSOSetAdjustment
*me
;
7750 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7752 me
= g_object_new (CMD_SO_SET_ADJUSTMENT_TYPE
, NULL
);
7753 me
->cmd
.sheet
= sheet_object_get_sheet (so
);
7755 me
->cmd
.cmd_descriptor
= g_strdup ((undo_label
== NULL
) ?
7756 _("Configure Adjustment") : _(undo_label
));
7759 me
->old_lower
= lower
;
7760 me
->old_upper
= upper
;
7761 me
->old_step
= step
;
7762 me
->old_page
= page
;
7763 me
->old_horizontal
= horizontal
;
7765 me
->old_link
= sheet_widget_adjustment_get_link (so
);
7767 return gnm_command_push_undo (wbc
, G_OBJECT (me
));
7770 /******************************************************************/
7773 cmd_autofilter_add_remove (WorkbookControl
*wbc
)
7775 SheetView
*sv
= wb_control_cur_sheet_view (wbc
);
7776 GnmFilter
*f
= gnm_sheet_view_editpos_in_filter (sv
);
7777 gboolean add
= (f
== NULL
);
7778 char *descr
= NULL
, *name
= NULL
;
7779 GOUndo
*undo
= NULL
;
7780 GOUndo
*redo
= NULL
;
7786 GnmRange
const *src
= selection_first_range (sv
,
7787 GO_CMD_CONTEXT (wbc
), _("Add Filter"));
7788 GnmFilter
*f_old
= NULL
;
7793 f_old
= gnm_sheet_filter_intersect_rows
7794 (sv
->sheet
, src
->start
.row
, src
->end
.row
);
7796 if (f_old
!= NULL
) {
7797 GnmRange
*r
= gnm_sheet_filter_can_be_extended
7798 (sv
->sheet
, f_old
, src
);
7801 name
= undo_range_name (sv
->sheet
, &(f_old
->r
));
7802 error
= g_strdup_printf
7803 (_("Auto Filter blocked by %s"),
7806 go_cmd_context_error_invalid
7807 (GO_CMD_CONTEXT (wbc
),
7808 _("AutoFilter"), error
);
7812 /* extending existing filter. */
7813 undo
= go_undo_binary_new
7814 (gnm_filter_ref (f_old
), sv
->sheet
,
7815 (GOUndoBinaryFunc
) gnm_filter_attach
,
7816 (GFreeFunc
) gnm_filter_unref
,
7818 redo
= go_undo_unary_new
7819 (gnm_filter_ref (f_old
),
7820 (GOUndoUnaryFunc
) gnm_filter_remove
,
7821 (GFreeFunc
) gnm_filter_unref
);
7822 gnm_filter_remove (f_old
);
7826 /* if only one row is selected
7827 * assume that the user wants to
7828 * filter the region below this row. */
7830 if (src
->start
.row
== src
->end
.row
)
7831 gnm_sheet_guess_region (sv
->sheet
, ®ion
);
7832 if (region
.start
.row
== region
.end
.row
) {
7833 go_cmd_context_error_invalid
7834 (GO_CMD_CONTEXT (wbc
),
7836 _("Requires more than 1 row"));
7840 f
= gnm_filter_new (sv
->sheet
, ®ion
);
7842 go_cmd_context_error_invalid
7843 (GO_CMD_CONTEXT (wbc
),
7845 _("Unable to create Autofilter"));
7847 gnm_filter_attach (f_old
, sv
->sheet
);
7851 gnm_filter_remove (f
);
7853 gnm_filter_attach (f_old
, sv
->sheet
);
7855 redo
= go_undo_combine (go_undo_binary_new
7856 (gnm_filter_ref (f
), sv
->sheet
,
7857 (GOUndoBinaryFunc
) gnm_filter_attach
,
7858 (GFreeFunc
) gnm_filter_unref
,
7860 undo
= go_undo_combine (undo
,
7863 (GOUndoUnaryFunc
) gnm_filter_remove
,
7864 (GFreeFunc
) gnm_filter_unref
));
7866 name
= undo_range_name (sv
->sheet
, &(f
->r
));
7867 descr
= g_strdup_printf
7868 ((f_old
== NULL
) ? _("Add Autofilter to %s")
7869 : _("Extend Autofilter to %s"),
7872 undo
= go_undo_binary_new
7873 (gnm_filter_ref (f
), sv
->sheet
,
7874 (GOUndoBinaryFunc
) gnm_filter_attach
,
7875 (GFreeFunc
) gnm_filter_unref
,
7877 redo
= go_undo_unary_new
7878 (gnm_filter_ref (f
),
7879 (GOUndoUnaryFunc
) gnm_filter_remove
,
7880 (GFreeFunc
) gnm_filter_unref
);
7881 name
= undo_range_name (sv
->sheet
, &(f
->r
));
7882 descr
= g_strdup_printf (_("Remove Autofilter from %s"),
7885 result
= cmd_generic (wbc
, descr
, undo
, redo
);
7893 /******************************************************************/
7895 gboolean
cmd_autofilter_set_condition (WorkbookControl
*wbc
,
7896 GnmFilter
*filter
, unsigned i
,
7897 GnmFilterCondition
*cond
)
7899 char *descr
= NULL
, *name
= NULL
;
7900 GOUndo
*undo
= NULL
;
7901 GOUndo
*redo
= NULL
;
7904 undo
= gnm_undo_filter_set_condition_new (filter
, i
,
7906 g_return_val_if_fail (undo
!= NULL
, TRUE
);
7907 redo
= gnm_undo_filter_set_condition_new (filter
, i
,
7909 g_return_val_if_fail (redo
!= NULL
, TRUE
);
7911 name
= undo_range_name (filter
->sheet
, &(filter
->r
));
7912 descr
= g_strdup_printf (_("Change filter condition for %s"),
7915 result
= cmd_generic (wbc
, descr
, undo
, redo
);
7923 /******************************************************************/
7926 cmd_page_breaks_set_breaks (Sheet
*sheet
,
7927 GnmPageBreaks
const *breaks
)
7929 print_info_set_breaks (sheet
->print_info
, gnm_page_breaks_dup (breaks
));
7931 SHEET_FOREACH_CONTROL (sheet
, sv
, sc
, wb_control_menu_state_update (sc_wbc (sc
), MS_PAGE_BREAKS
););
7935 cmd_page_breaks_clear (WorkbookControl
*wbc
, Sheet
*sheet
)
7937 GOUndo
*undo
= NULL
;
7938 GOUndo
*redo
= NULL
;
7940 g_return_val_if_fail (GNM_IS_WBC (wbc
), TRUE
);
7941 g_return_val_if_fail (sheet
!= NULL
, TRUE
);
7943 if (sheet
->print_info
->page_breaks
.v
!= NULL
) {
7944 redo
= go_undo_binary_new
7946 gnm_page_breaks_new (TRUE
),
7947 (GOUndoBinaryFunc
) cmd_page_breaks_set_breaks
,
7949 (GFreeFunc
) gnm_page_breaks_free
);
7950 undo
= go_undo_binary_new
7953 (sheet
->print_info
->page_breaks
.v
),
7954 (GOUndoBinaryFunc
) cmd_page_breaks_set_breaks
,
7956 (GFreeFunc
) gnm_page_breaks_free
);
7959 if (sheet
->print_info
->page_breaks
.h
!= NULL
) {
7960 redo
= go_undo_combine
7964 gnm_page_breaks_new (FALSE
),
7965 (GOUndoBinaryFunc
) cmd_page_breaks_set_breaks
,
7967 (GFreeFunc
) gnm_page_breaks_free
));
7969 undo
= go_undo_combine
7974 (sheet
->print_info
->page_breaks
.h
),
7975 (GOUndoBinaryFunc
) cmd_page_breaks_set_breaks
,
7977 (GFreeFunc
) gnm_page_breaks_free
));
7981 return cmd_generic (wbc
, _("Clear All Page Breaks"), undo
, redo
);
7987 cmd_page_break_toggle (WorkbookControl
*wbc
, Sheet
*sheet
, gboolean is_vert
)
7989 SheetView
const *sv
= wb_control_cur_sheet_view (wbc
);
7990 gint col
= sv
->edit_pos
.col
;
7991 gint row
= sv
->edit_pos
.row
;
7992 int rc
= is_vert
? col
: row
;
7993 GnmPageBreaks
*old
, *new, *target
;
7994 GnmPageBreakType type
;
7999 target
= is_vert
? sheet
->print_info
->page_breaks
.v
8000 : sheet
->print_info
->page_breaks
.h
;
8002 old
= (target
== NULL
) ? gnm_page_breaks_new (is_vert
)
8003 : gnm_page_breaks_dup (target
);
8004 new = gnm_page_breaks_dup (old
);
8006 if (gnm_page_breaks_get_break (new, rc
) != GNM_PAGE_BREAK_MANUAL
) {
8007 type
= GNM_PAGE_BREAK_MANUAL
;
8008 label
= is_vert
? _("Remove Column Page Break") : _("Remove Row Page Break");
8010 type
= GNM_PAGE_BREAK_NONE
;
8011 label
= is_vert
? _("Add Column Page Break") : _("Add Row Page Break");
8014 gnm_page_breaks_set_break (new, rc
, type
);
8016 redo
= go_undo_binary_new
8018 (GOUndoBinaryFunc
) cmd_page_breaks_set_breaks
,
8020 (GFreeFunc
) gnm_page_breaks_free
);
8021 undo
= go_undo_binary_new
8023 (GOUndoBinaryFunc
) cmd_page_breaks_set_breaks
,
8025 (GFreeFunc
) gnm_page_breaks_free
);
8027 return cmd_generic (wbc
, label
, undo
, redo
);
8030 /******************************************************************/