1 /* vim: set sw=8: -*- Mode: C; tab-width: 8; indent-tabs-mode: t; c-basic-offset: 8 -*- */
4 * workbook.c: workbook model and manipulation utilities
7 * Miguel de Icaza (miguel@gnu.org).
8 * Jody Goldberg (jody@gnome.org)
10 * (C) 1998, 1999, 2000 Miguel de Icaza
11 * (C) 2000-2001 Ximian, Inc.
12 * (C) 2002-2007 Jody Goldberg
13 * Copyright (C) 1999-2009 Morten Welinder (terra@gnome.org)
15 #include <gnumeric-config.h>
17 #include "workbook-priv.h"
18 #include "compilation.h"
20 #include "workbook-view.h"
21 #include "workbook-control.h"
22 #include "command-context.h"
23 #include "application.h"
24 #include "gnumeric-conf.h"
26 #include "sheet-view.h"
27 #include "sheet-control.h"
30 #include "expr-name.h"
31 #include "dependent.h"
36 #include "libgnumeric.h"
38 #include "gnm-marshalers.h"
39 #include "style-color.h"
40 #include "sheet-style.h"
41 #include "sheet-object-graph.h"
43 #include <goffice/goffice.h>
45 #include <gsf/gsf-doc-meta-data.h>
46 #include <gsf/gsf-impl-utils.h>
47 #include <gsf/gsf-meta-names.h>
54 * @wb_views: (element-type WorkbookView):
67 static guint signals
[LAST_SIGNAL
] = { 0 };
68 static GObjectClass
*workbook_parent_class
;
71 cb_saver_finalize (Workbook
*wb
, GOFileSaver
*saver
)
73 g_return_if_fail (GO_IS_FILE_SAVER (saver
));
74 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
75 g_return_if_fail (wb
->file_saver
== saver
);
76 wb
->file_saver
= NULL
;
79 cb_exporter_finalize (Workbook
*wb
, GOFileSaver
*saver
)
81 g_return_if_fail (GO_IS_FILE_SAVER (saver
));
82 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
83 g_return_if_fail (wb
->file_exporter
== saver
);
84 workbook_set_file_exporter (wb
, NULL
);
88 workbook_update_history (Workbook
*wb
, GnmFileSaveAsStyle type
)
90 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
93 case GNM_FILE_SAVE_AS_STYLE_SAVE
:
94 if (wb
->doc
.uri
&& wb
->file_format_level
>= GO_FILE_FL_MANUAL_REMEMBER
) {
95 const char *mimetype
= wb
->file_saver
96 ? go_file_saver_get_mime_type (wb
->file_saver
)
98 gnm_app_history_add (wb
->doc
.uri
, mimetype
);
101 case GNM_FILE_SAVE_AS_STYLE_EXPORT
:
103 if (wb
->last_export_uri
&&
104 wb
->file_export_format_level
>= GO_FILE_FL_MANUAL_REMEMBER
) {
105 const char *mimetype
= wb
->file_exporter
106 ? go_file_saver_get_mime_type (wb
->file_exporter
)
108 gnm_app_history_add (wb
->last_export_uri
, mimetype
);
115 workbook_update_graphs (Workbook
*wb
)
117 WORKBOOK_FOREACH_SHEET (wb
, sheet
, ({
118 GSList
*l
, *graphs
= sheet_objects_get (sheet
, NULL
, GNM_SO_GRAPH_TYPE
);
119 for (l
= graphs
; l
; l
= l
->next
) {
120 SheetObject
*sog
= l
->data
;
121 gog_graph_force_update (sheet_object_graph_get_gog (sog
));
123 g_slist_free (graphs
);
129 workbook_dispose (GObject
*wb_object
)
131 Workbook
*wb
= WORKBOOK (wb_object
);
132 GSList
*sheets
, *ptr
;
133 GSList
*controls
= NULL
;
135 wb
->during_destruction
= TRUE
;
138 workbook_set_saveinfo (wb
, GO_FILE_FL_AUTO
, NULL
);
139 if (wb
->file_exporter
)
140 workbook_set_saveinfo (wb
, GO_FILE_FL_WRITE_ONLY
, NULL
);
141 workbook_set_last_export_uri (wb
, NULL
);
143 // Remove all the sheet controls to avoid displaying while we exit
144 // However, hold on to a ref for each -- dialogs like to refer
145 // to ->wbcg during destruction
146 WORKBOOK_FOREACH_CONTROL (wb
, view
, control
,
147 controls
= g_slist_prepend (controls
, g_object_ref (control
));
148 wb_control_sheet_remove_all (control
););
150 /* Get rid of all the views */
151 WORKBOOK_FOREACH_VIEW (wb
, wbv
, {
152 wb_view_detach_from_workbook (wbv
);
153 g_object_unref (wbv
);
155 if (wb
->wb_views
!= NULL
)
156 g_warning ("Unexpected left over views");
158 command_list_release (wb
->undo_commands
);
159 wb
->undo_commands
= NULL
;
160 command_list_release (wb
->redo_commands
);
161 wb
->redo_commands
= NULL
;
163 dependents_workbook_destroy (wb
);
165 /* Copy the set of sheets, the list changes under us. */
166 sheets
= workbook_sheets (wb
);
168 /* Remove all contents while all sheets still exist */
169 for (ptr
= sheets
; ptr
!= NULL
; ptr
= ptr
->next
) {
170 Sheet
*sheet
= ptr
->data
;
173 sheet_destroy_contents (sheet
);
174 range_init_full_sheet (&r
, sheet
);
175 sheet_style_set_range (sheet
, &r
, sheet_style_default (sheet
));
178 /* Now remove the sheets themselves */
179 for (ptr
= sheets
; ptr
!= NULL
; ptr
= ptr
->next
) {
180 Sheet
*sheet
= ptr
->data
;
181 workbook_sheet_delete (sheet
);
183 g_slist_free (sheets
);
185 // Now get rid of the control refs
186 g_slist_free_full (controls
, g_object_unref
);
188 workbook_parent_class
->dispose (wb_object
);
192 workbook_finalize (GObject
*obj
)
194 Workbook
*wb
= WORKBOOK (obj
);
196 /* Remove ourselves from the list of workbooks. */
197 gnm_app_workbook_list_remove (wb
);
199 if (wb
->sheet_local_functions
) {
200 g_hash_table_destroy (wb
->sheet_local_functions
);
201 wb
->sheet_local_functions
= NULL
;
204 /* Now do deletions that will put this workbook into a weird
205 state. Careful here. */
206 g_hash_table_destroy (wb
->sheet_hash_private
);
207 wb
->sheet_hash_private
= NULL
;
209 g_ptr_array_free (wb
->sheets
, TRUE
);
212 workbook_parent_class
->finalize (obj
);
216 workbook_init (GObject
*object
)
218 Workbook
*wb
= WORKBOOK (object
);
220 wb
->is_placeholder
= FALSE
;
222 wb
->sheets
= g_ptr_array_new ();
223 wb
->sheet_hash_private
= g_hash_table_new (g_str_hash
, g_str_equal
);
224 wb
->sheet_order_dependents
= NULL
;
225 wb
->sheet_local_functions
= NULL
;
226 wb
->names
= gnm_named_expr_collection_new ();
228 /* Nothing to undo or redo */
229 wb
->undo_commands
= wb
->redo_commands
= NULL
;
231 /* default to no iteration */
232 wb
->iteration
.enabled
= TRUE
;
233 wb
->iteration
.max_number
= 100;
234 wb
->iteration
.tolerance
= .001;
235 wb
->recalc_auto
= TRUE
;
237 workbook_set_1904 (wb
, FALSE
);
239 wb
->file_format_level
= GO_FILE_FL_NEW
;
240 wb
->file_export_format_level
= GO_FILE_FL_NEW
;
241 wb
->file_saver
= NULL
;
242 wb
->file_exporter
= NULL
;
243 wb
->last_export_uri
= NULL
;
245 wb
->during_destruction
= FALSE
;
246 wb
->being_reordered
= FALSE
;
247 wb
->recursive_dirty_enabled
= TRUE
;
249 gnm_app_workbook_list_add (wb
);
253 workbook_get_property (GObject
*object
, guint property_id
,
254 GValue
*value
, GParamSpec
*pspec
)
256 Workbook
*wb
= (Workbook
*)object
;
258 switch (property_id
) {
259 case PROP_RECALC_MODE
:
260 g_value_set_boolean (value
, wb
->recalc_auto
);
263 G_OBJECT_WARN_INVALID_PROPERTY_ID (object
, property_id
, pspec
);
269 workbook_set_property (GObject
*object
, guint property_id
,
270 const GValue
*value
, GParamSpec
*pspec
)
272 Workbook
*wb
= (Workbook
*)object
;
274 switch (property_id
) {
275 case PROP_RECALC_MODE
:
276 workbook_set_recalcmode (wb
, g_value_get_boolean (value
));
279 G_OBJECT_WARN_INVALID_PROPERTY_ID (object
, property_id
, pspec
);
285 workbook_constructor (GType type
,
286 guint n_construct_properties
,
287 GObjectConstructParam
*construct_params
)
291 static int count
= 0;
293 GOFileSaver
*def_save
= go_file_saver_get_default ();
294 char const *extension
= NULL
;
296 obj
= workbook_parent_class
->constructor
297 (type
, n_construct_properties
, construct_params
);
300 if (def_save
!= NULL
)
301 extension
= go_file_saver_get_extension (def_save
);
302 if (extension
== NULL
)
303 extension
= "gnumeric";
305 /* Assign a default name */
307 char *name
, *nameutf8
, *uri
;
310 nameutf8
= g_strdup_printf (_("Book%d.%s"), count
, extension
);
311 name
= g_filename_from_utf8 (nameutf8
, -1, NULL
, NULL
, NULL
);
313 name
= g_strdup_printf ("Book%d.%s", count
, extension
);
315 uri
= go_filename_to_uri (name
);
317 is_unique
= go_doc_set_uri (GO_DOC (wb
), uri
);
322 } while (!is_unique
);
324 gnm_insert_meta_date (GO_DOC (wb
), GSF_META_NAME_DATE_CREATED
);
330 workbook_class_init (GObjectClass
*gobject_class
)
332 workbook_parent_class
= g_type_class_peek_parent (gobject_class
);
334 gobject_class
->constructor
= workbook_constructor
;
335 gobject_class
->set_property
= workbook_set_property
;
336 gobject_class
->get_property
= workbook_get_property
;
337 gobject_class
->finalize
= workbook_finalize
;
338 gobject_class
->dispose
= workbook_dispose
;
340 g_object_class_install_property (gobject_class
, PROP_RECALC_MODE
,
341 g_param_spec_boolean ("recalc-mode",
343 P_("Enable automatic recalculation."),
348 signals
[SHEET_ORDER_CHANGED
] = g_signal_new ("sheet_order_changed",
351 G_STRUCT_OFFSET (WorkbookClass
, sheet_order_changed
),
353 g_cclosure_marshal_VOID__VOID
,
357 signals
[SHEET_ADDED
] = g_signal_new ("sheet_added",
360 G_STRUCT_OFFSET (WorkbookClass
, sheet_added
),
362 g_cclosure_marshal_VOID__VOID
,
366 signals
[SHEET_DELETED
] = g_signal_new ("sheet_deleted",
369 G_STRUCT_OFFSET (WorkbookClass
, sheet_deleted
),
371 g_cclosure_marshal_VOID__VOID
,
379 * Returns: A new empty #Workbook with a unique name.
384 return g_object_new (GNM_WORKBOOK_TYPE
, NULL
);
388 * workbook_sheet_name_strip_number:
389 * @name: name to strip number from
390 * @number: returns the number stripped off, or 1 if no number.
392 * Gets a name in the form of "Sheet (10)", "Stuff" or "Dummy ((((,"
393 * and returns the real name of the sheet "Sheet ", "Stuff", "Dummy ((((,"
394 * without the copy number.
397 workbook_sheet_name_strip_number (char *name
, unsigned int *number
)
399 char *end
, *p
, *pend
;
403 g_return_if_fail (*name
!= 0);
405 end
= name
+ strlen (name
) - 1;
409 for (p
= end
; p
> name
; p
--)
410 if (!g_ascii_isdigit (p
[-1]))
413 if (p
== name
|| p
[-1] != '(')
417 ul
= strtoul (p
, &pend
, 10);
418 if (pend
!= end
|| ul
!= (unsigned int)ul
|| errno
== ERANGE
)
421 *number
= (unsigned)ul
;
426 * workbook_new_with_sheets:
427 * @sheet_count: initial number of sheets to create.
429 * Returns: a #Workbook with @sheet_count allocated
433 workbook_new_with_sheets (int sheet_count
)
435 Workbook
*wb
= workbook_new ();
436 int cols
= gnm_conf_get_core_workbook_n_cols ();
437 int rows
= gnm_conf_get_core_workbook_n_rows ();
438 if (!gnm_sheet_valid_size (cols
, rows
))
439 gnm_sheet_suggest_size (&cols
, &rows
);
440 while (sheet_count
-- > 0)
441 workbook_sheet_add (wb
, -1, cols
, rows
);
442 go_doc_set_dirty (GO_DOC (wb
), FALSE
);
443 go_doc_set_pristine (GO_DOC (wb
), TRUE
);
448 * workbook_set_saveinfo:
449 * @wb: the workbook to modify
450 * @lev: the file format level
451 * @saver: (nullable): the file saver.
453 * If level is sufficiently advanced, assign the info.
455 * Returns: %TRUE if save info was set and history may require updating
457 * FIXME : Add a check to ensure the name is unique.
460 workbook_set_saveinfo (Workbook
*wb
, GOFileFormatLevel level
, GOFileSaver
*fs
)
462 g_return_val_if_fail (wb
!= NULL
, FALSE
);
463 g_return_val_if_fail (level
> GO_FILE_FL_NONE
&& level
< GO_FILE_FL_LAST
,
466 if (level
!= GO_FILE_FL_AUTO
) {
467 if (wb
->file_exporter
!= NULL
)
468 g_object_weak_unref (G_OBJECT (wb
->file_exporter
),
469 (GWeakNotify
) cb_exporter_finalize
, wb
);
470 workbook_set_file_exporter (wb
, fs
);
472 g_object_weak_ref (G_OBJECT (fs
),
473 (GWeakNotify
) cb_exporter_finalize
, wb
);
475 if (wb
->file_saver
!= NULL
)
476 g_object_weak_unref (G_OBJECT (wb
->file_saver
),
477 (GWeakNotify
) cb_saver_finalize
, wb
);
481 g_object_weak_ref (G_OBJECT (fs
),
482 (GWeakNotify
) cb_saver_finalize
, wb
);
485 if (level
!= GO_FILE_FL_AUTO
) {
486 wb
->file_export_format_level
= level
;
489 wb
->file_format_level
= level
;
494 * workbook_get_file_saver:
497 * Returns: (transfer none): the saver for the Workbook.
500 workbook_get_file_saver (Workbook
*wb
)
502 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), NULL
);
504 return wb
->file_saver
;
508 * workbook_get_file_exporter:
511 * Returns: (transfer none): the exporter for the Workbook.
514 workbook_get_file_exporter (Workbook
*wb
)
516 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), NULL
);
518 return wb
->file_exporter
;
522 * workbook_get_last_export_uri:
525 * Returns: (transfer none): the URI for export.
528 workbook_get_last_export_uri (Workbook
*wb
)
530 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), NULL
);
532 return wb
->last_export_uri
;
536 workbook_set_file_exporter (Workbook
*wb
, GOFileSaver
*fs
)
538 wb
->file_exporter
= fs
;
539 WORKBOOK_FOREACH_CONTROL (wb
, wbv
, wbc
,
540 wb_control_menu_state_update (wbc
, MS_FILE_EXPORT_IMPORT
););
544 workbook_set_last_export_uri (Workbook
*wb
, const gchar
*uri
)
546 char *s
= g_strdup (uri
);
547 g_free (wb
->last_export_uri
);
548 wb
->last_export_uri
= s
;
549 WORKBOOK_FOREACH_CONTROL (wb
, wbv
, wbc
,
550 wb_control_menu_state_update (wbc
, MS_FILE_EXPORT_IMPORT
););
555 * workbook_foreach_cell_in_range:
556 * @pos: The position the range is relative to.
557 * @cell_range: A value containing a range;
558 * @flags: if TRUE only existing cells are sent to the handler.
559 * @handler: (scope call): The operator to apply to each cell.
560 * @closure: User data.
562 * The supplied value must be a cellrange.
563 * The range bounds are calculated relative to the eval position
565 * For each existing cell in the range specified, invoke the
566 * callback routine. If the only_existing flag is TRUE, then
567 * callbacks are only invoked for existing cells.
569 * Note: this function does not honour the CELL_ITER_IGNORE_SUBTOTAL flag.
572 * non-NULL on error, or VALUE_TERMINATE if some invoked routine requested
573 * to stop (by returning non-NULL).
576 workbook_foreach_cell_in_range (GnmEvalPos
const *pos
,
577 GnmValue
const *cell_range
,
579 CellIterFunc handler
,
583 Sheet
*start_sheet
, *end_sheet
;
585 g_return_val_if_fail (pos
!= NULL
, NULL
);
586 g_return_val_if_fail (cell_range
!= NULL
, NULL
);
587 g_return_val_if_fail (VALUE_IS_CELLRANGE (cell_range
), NULL
);
589 gnm_rangeref_normalize (&cell_range
->v_range
.cell
, pos
,
590 &start_sheet
, &end_sheet
, &r
);
592 if (start_sheet
!= end_sheet
) {
594 Workbook
const *wb
= start_sheet
->workbook
;
595 int i
= start_sheet
->index_in_wb
;
596 int stop
= end_sheet
->index_in_wb
;
597 if (i
> stop
) { int tmp
= i
; i
= stop
; stop
= tmp
; }
599 g_return_val_if_fail (end_sheet
->workbook
== wb
, VALUE_TERMINATE
);
601 for (; i
<= stop
; i
++) {
602 res
= sheet_foreach_cell_in_range (
603 g_ptr_array_index (wb
->sheets
, i
), flags
, &r
,
611 return sheet_foreach_cell_in_range (start_sheet
, flags
, &r
,
617 * @wb: The workbook to find cells in.
618 * @comments: If true, include cells with only comments also.
619 * @vis: How visible a sheet needs to be in order to be considered.
621 * Collects a GPtrArray of GnmEvalPos pointers for all cells in a workbook.
622 * No particular order should be assumed.
624 * Returns: (element-type GnmEvalPos) (transfer container): the cells array
627 workbook_cells (Workbook
*wb
, gboolean comments
, GnmSheetVisibility vis
)
629 GPtrArray
*cells
= g_ptr_array_new ();
631 g_return_val_if_fail (wb
!= NULL
, cells
);
633 WORKBOOK_FOREACH_SHEET (wb
, sheet
, {
634 size_t oldlen
= cells
->len
;
637 if (sheet
->visibility
> vis
)
640 scells
= sheet_cell_positions (sheet
, comments
);
641 g_ptr_array_set_size (cells
, oldlen
+ scells
->len
);
642 memcpy (&g_ptr_array_index (cells
, oldlen
),
643 &g_ptr_array_index (scells
, 0),
644 scells
->len
* sizeof (GnmEvalPos
*));
646 g_ptr_array_free (scells
, TRUE
);
653 workbook_share_expressions (Workbook
*wb
, gboolean freeit
)
655 GnmExprSharer
*es
= gnm_expr_sharer_new ();
657 WORKBOOK_FOREACH_DEPENDENT (wb
, dep
, {
658 if (dependent_is_cell (dep
)) {
659 /* Hopefully safe, even when linked. */
660 dep
->texpr
= gnm_expr_sharer_share (es
, dep
->texpr
);
662 /* Not sure we want to touch this here. */
666 if (gnm_debug_flag ("expr-sharer")) {
667 g_printerr ("Sharing report for %s\n", go_doc_get_uri (GO_DOC (wb
)));
668 gnm_expr_sharer_report (es
);
672 gnm_expr_sharer_destroy (es
);
680 workbook_optimize_style (Workbook
*wb
)
682 WORKBOOK_FOREACH_SHEET (wb
, sheet
, {
683 sheet_style_optimize (sheet
);
688 * workbook_foreach_name:
690 * @globals_only: whether to apply only to global names.
691 * @func: (scope call): The operator to apply to each cell.
696 workbook_foreach_name (Workbook
const *wb
, gboolean globals_only
,
697 GHFunc func
, gpointer data
)
699 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
702 gnm_named_expr_collection_foreach (wb
->names
, func
, data
);
705 WORKBOOK_FOREACH_SHEET (wb
, sheet
, {
706 gnm_sheet_foreach_name (sheet
, func
, data
);
713 workbook_enable_recursive_dirty (Workbook
*wb
, gboolean enable
)
717 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), FALSE
);
719 old
= wb
->recursive_dirty_enabled
;
720 wb
->recursive_dirty_enabled
= enable
;
725 workbook_set_recalcmode (Workbook
*wb
, gboolean is_auto
)
727 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
730 if (is_auto
== wb
->recalc_auto
)
733 wb
->recalc_auto
= is_auto
;
734 g_object_notify (G_OBJECT (wb
), "recalc-mode");
738 workbook_get_recalcmode (Workbook
const *wb
)
740 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), FALSE
);
741 return wb
->recalc_auto
;
745 workbook_iteration_enabled (Workbook
*wb
, gboolean enable
)
747 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
748 wb
->iteration
.enabled
= enable
;
752 workbook_iteration_max_number (Workbook
*wb
, int max_number
)
754 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
755 g_return_if_fail (max_number
>= 0);
756 wb
->iteration
.max_number
= max_number
;
760 workbook_iteration_tolerance (Workbook
*wb
, double tolerance
)
762 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
763 g_return_if_fail (tolerance
>= 0);
765 wb
->iteration
.tolerance
= tolerance
;
769 workbook_attach_view (WorkbookView
*wbv
)
773 g_return_if_fail (GNM_IS_WORKBOOK_VIEW (wbv
));
775 wb
= wb_view_get_workbook (wbv
);
776 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
778 if (wb
->wb_views
== NULL
)
779 wb
->wb_views
= g_ptr_array_new ();
780 g_ptr_array_add (wb
->wb_views
, wbv
);
784 workbook_detach_view (WorkbookView
*wbv
)
786 g_return_if_fail (GNM_IS_WORKBOOK_VIEW (wbv
));
787 g_return_if_fail (GNM_IS_WORKBOOK (wbv
->wb
));
789 WORKBOOK_FOREACH_SHEET (wbv
->wb
, sheet
, {
790 SheetView
*sv
= sheet_get_view (sheet
, wbv
);
791 gnm_sheet_view_dispose (sv
);
794 g_ptr_array_remove (wbv
->wb
->wb_views
, wbv
);
795 if (wbv
->wb
->wb_views
->len
== 0) {
796 g_ptr_array_free (wbv
->wb
->wb_views
, TRUE
);
797 wbv
->wb
->wb_views
= NULL
;
801 /*****************************************************************************/
807 * Get an ordered list of the sheets in the workbook
809 * Returns: (element-type Sheet) (transfer container): the sheets list.
812 workbook_sheets (Workbook
const *wb
)
816 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), NULL
);
819 int i
= wb
->sheets
->len
;
821 list
= g_slist_prepend (list
,
822 g_ptr_array_index (wb
->sheets
, i
));
829 workbook_sheet_count (Workbook
const *wb
)
831 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), 0);
833 return wb
->sheets
? wb
->sheets
->len
: 0;
837 pre_sheet_index_change (Workbook
*wb
)
839 g_return_if_fail (!wb
->being_reordered
);
841 wb
->being_reordered
= TRUE
;
843 if (wb
->sheet_order_dependents
!= NULL
)
844 g_hash_table_foreach (wb
->sheet_order_dependents
,
845 (GHFunc
)dependent_unlink
,
850 post_sheet_index_change (Workbook
*wb
)
852 g_return_if_fail (wb
->being_reordered
);
854 if (wb
->sheet_order_dependents
!= NULL
)
855 g_hash_table_foreach (wb
->sheet_order_dependents
,
856 (GHFunc
)dependent_link
,
859 wb
->being_reordered
= FALSE
;
861 if (wb
->during_destruction
)
864 g_signal_emit (G_OBJECT (wb
), signals
[SHEET_ORDER_CHANGED
], 0);
868 workbook_sheet_index_update (Workbook
*wb
, int start
)
872 for (i
= wb
->sheets
->len
; i
-- > start
; ) {
873 Sheet
*sheet
= g_ptr_array_index (wb
->sheets
, i
);
874 sheet
->index_in_wb
= i
;
879 * workbook_sheet_by_index:
880 * @wb: workbook to lookup the sheet on
881 * @i: the sheet index we are looking for.
883 * Return value: (transfer none) (nullable): A #Sheet
886 workbook_sheet_by_index (Workbook
const *wb
, int i
)
888 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), NULL
);
889 g_return_val_if_fail (i
>= -1, NULL
);
891 // i = -1 is special, return NULL
892 if (i
== -1 || i
>= (int)wb
->sheets
->len
)
895 return g_ptr_array_index (wb
->sheets
, i
);
899 * workbook_sheet_by_name:
900 * @wb: workbook to lookup the sheet on
901 * @sheet_name: the sheet name we are looking for. This is case insensitive.
903 * Return value: (transfer none) (nullable): A #Sheet
906 workbook_sheet_by_name (Workbook
const *wb
, char const *name
)
911 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), NULL
);
912 g_return_val_if_fail (name
!= NULL
, NULL
);
914 tmp
= g_utf8_casefold (name
, -1);
915 sheet
= g_hash_table_lookup (wb
->sheet_hash_private
, tmp
);
922 * Find a sheet to focus on, left or right of sheet_index.
925 workbook_focus_other_sheet (Workbook
*wb
, Sheet
*sheet
)
929 int sheet_index
= sheet
->index_in_wb
;
931 for (i
= sheet_index
; !focus
&& --i
>= 0; ) {
932 Sheet
*this_sheet
= g_ptr_array_index (wb
->sheets
, i
);
933 if (this_sheet
->visibility
== GNM_SHEET_VISIBILITY_VISIBLE
)
937 for (i
= sheet_index
; !focus
&& ++i
< (int)wb
->sheets
->len
; ) {
938 Sheet
*this_sheet
= g_ptr_array_index (wb
->sheets
, i
);
939 if (this_sheet
->visibility
== GNM_SHEET_VISIBILITY_VISIBLE
)
943 WORKBOOK_FOREACH_VIEW (wb
, wbv
, {
944 if (sheet
== wb_view_cur_sheet (wbv
))
945 wb_view_sheet_focus (wbv
, focus
);
952 * workbook_sheet_remove_controls:
956 * Remove the visible #SheetControls of a sheet and shut them down politely.
958 * Returns %TRUE if there are any remaining sheets visible
961 workbook_sheet_remove_controls (Workbook
*wb
, Sheet
*sheet
)
965 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), TRUE
);
966 g_return_val_if_fail (IS_SHEET (sheet
), TRUE
);
967 g_return_val_if_fail (sheet
->workbook
== wb
, TRUE
);
968 g_return_val_if_fail (workbook_sheet_by_name (wb
, sheet
->name_unquoted
) == sheet
, TRUE
);
970 /* Finish any object editing */
971 SHEET_FOREACH_CONTROL (sheet
, view
, control
,
972 sc_mode_edit (control
););
974 /* If not exiting, adjust the focus for any views whose focus sheet
975 * was the one being deleted, and prepare to recalc */
976 if (!wb
->during_destruction
)
977 focus
= workbook_focus_other_sheet (wb
, sheet
);
979 WORKBOOK_FOREACH_CONTROL (wb
, wbv
, wbc
,
980 wb_control_sheet_remove (wbc
, sheet
););
982 return focus
!= NULL
;
986 * workbook_sheet_attach_at_pos:
988 * @new_sheet: A #Sheet
989 * @pos: position to attach @new_sheet at, -1 meaning at the end
991 * Add @new_sheet to @wb, placing it at @pos.
994 workbook_sheet_attach_at_pos (Workbook
*wb
, Sheet
*new_sheet
, int pos
)
996 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
997 g_return_if_fail (IS_SHEET (new_sheet
));
998 g_return_if_fail (new_sheet
->workbook
== wb
);
999 g_return_if_fail (pos
>= -1 && pos
<= (int)wb
->sheets
->len
);
1002 pos
= wb
->sheets
->len
;
1004 pre_sheet_index_change (wb
);
1006 g_object_ref (new_sheet
);
1007 g_ptr_array_insert (wb
->sheets
, pos
, (gpointer
)new_sheet
);
1008 workbook_sheet_index_update (wb
, pos
);
1009 g_hash_table_insert (wb
->sheet_hash_private
,
1010 new_sheet
->name_case_insensitive
,
1013 WORKBOOK_FOREACH_VIEW (wb
, view
,
1014 wb_view_sheet_add (view
, new_sheet
););
1016 /* Do not signal until after adding the views [#314208] */
1017 post_sheet_index_change (wb
);
1019 go_doc_set_dirty (GO_DOC (wb
), TRUE
);
1023 * workbook_sheet_attach:
1025 * @new_sheet: (transfer full): A #Sheet to attach
1027 * Add @new_sheet to @wb, placing it at the end. SURPRISE: This assumes
1028 * a ref to the sheet.
1031 workbook_sheet_attach (Workbook
*wb
, Sheet
*new_sheet
)
1033 workbook_sheet_attach_at_pos (wb
, new_sheet
, -1);
1034 /* Balance the ref added by the above call. */
1035 g_object_unref (new_sheet
);
1039 * workbook_sheet_add:
1041 * @pos: position to add, -1 meaning at end.
1042 * @columns: the sheet columns number.
1043 * @rows: the sheet rows number.
1045 * Create and name a new sheet, putting it at position @pos. The sheet
1046 * returned is not ref'd. (The ref belongs to the workbook.)
1048 * Return value: (transfer none): the new sheet.
1051 workbook_sheet_add (Workbook
*wb
, int pos
, int columns
, int rows
)
1053 char *name
= workbook_sheet_get_free_name (wb
, _("Sheet"), TRUE
, FALSE
);
1054 Sheet
*new_sheet
= sheet_new (wb
, name
, columns
, rows
);
1057 workbook_sheet_attach_at_pos (wb
, new_sheet
, pos
);
1059 /* FIXME: Why here? */
1060 g_signal_emit (G_OBJECT (wb
), signals
[SHEET_ADDED
], 0);
1062 g_object_unref (new_sheet
);
1068 * workbook_sheet_add_with_type:
1070 * @sheet_type: the sheet type.
1071 * @pos: position to add, -1 meaning append.
1072 * @columns: the sheet columns number.
1073 * @rows: the sheet rows number.
1075 * Create and name a new sheet, putting it at position @pos. The sheet
1076 * returned is not ref'd. (The ref belongs to the workbook.)
1078 * Return value: (transfer none): the new sheet.
1081 workbook_sheet_add_with_type (Workbook
*wb
, GnmSheetType sheet_type
, int pos
, int columns
, int rows
)
1083 char *name
= workbook_sheet_get_free_name (wb
, (sheet_type
== GNM_SHEET_OBJECT
)? _("Graph"): _("Sheet"), TRUE
, FALSE
);
1084 Sheet
*new_sheet
= sheet_new_with_type (wb
, name
, sheet_type
, columns
, rows
);
1087 workbook_sheet_attach_at_pos (wb
, new_sheet
, pos
);
1089 /* FIXME: Why here? */
1090 g_signal_emit (G_OBJECT (wb
), signals
[SHEET_ADDED
], 0);
1092 g_object_unref (new_sheet
);
1098 * workbook_sheet_delete:
1099 * @sheet: the #Sheet that we want to delete from its workbook
1101 * This function detaches the given sheet from its parent workbook and
1102 * invalidates all references to the deleted sheet from other sheets and
1103 * clears all references in the clipboard to this sheet.
1106 workbook_sheet_delete (Sheet
*sheet
)
1111 g_return_if_fail (IS_SHEET (sheet
));
1112 g_return_if_fail (GNM_IS_WORKBOOK (sheet
->workbook
));
1114 wb
= sheet
->workbook
;
1115 sheet_index
= sheet
->index_in_wb
;
1117 if (gnm_debug_flag ("sheets"))
1118 g_printerr ("Removing sheet %s from %s\n",
1119 sheet
->name_unquoted
,
1120 go_doc_get_uri (GO_DOC (wb
)));
1122 gnm_app_clipboard_invalidate_sheet (sheet
);
1124 if (!wb
->during_destruction
) {
1125 workbook_focus_other_sheet (wb
, sheet
);
1126 /* During destruction this was already done. */
1127 dependents_invalidate_sheet (sheet
, FALSE
);
1128 workbook_sheet_remove_controls (wb
, sheet
);
1131 /* All is fine, remove the sheet */
1132 pre_sheet_index_change (wb
);
1133 g_ptr_array_remove_index (wb
->sheets
, sheet_index
);
1134 workbook_sheet_index_update (wb
, sheet_index
);
1135 sheet
->index_in_wb
= -1;
1136 g_hash_table_remove (wb
->sheet_hash_private
, sheet
->name_case_insensitive
);
1137 post_sheet_index_change (wb
);
1139 /* Clear the controls first, before we potentially update */
1140 SHEET_FOREACH_VIEW (sheet
, view
, gnm_sheet_view_dispose (view
););
1142 g_signal_emit_by_name (G_OBJECT (sheet
), "detached_from_workbook", wb
);
1143 g_object_unref (sheet
);
1145 if (!wb
->during_destruction
)
1146 go_doc_set_dirty (GO_DOC (wb
), TRUE
);
1147 g_signal_emit (G_OBJECT (wb
), signals
[SHEET_DELETED
], 0);
1149 if (!wb
->during_destruction
)
1150 workbook_queue_all_recalc (wb
);
1154 * workbook_sheet_move:
1155 * @sheet: #Sheet to move
1156 * @direction: number of spots to move, positive for right and negative
1159 * Moves the sheet up or down @direction spots in the sheet list
1160 * If @direction is negative, move left. If positive, move right.
1163 workbook_sheet_move (Sheet
*sheet
, int direction
)
1166 gint old_pos
, new_pos
;
1168 g_return_if_fail (IS_SHEET (sheet
));
1170 wb
= sheet
->workbook
;
1172 pre_sheet_index_change (wb
);
1173 old_pos
= sheet
->index_in_wb
;
1174 new_pos
= old_pos
+ direction
;
1176 if (0 <= new_pos
&& new_pos
< workbook_sheet_count (wb
)) {
1177 int min_pos
= MIN (old_pos
, new_pos
);
1178 int max_pos
= MAX (old_pos
, new_pos
);
1180 g_ptr_array_remove_index (wb
->sheets
, old_pos
);
1181 g_ptr_array_insert (wb
->sheets
, new_pos
, sheet
);
1183 for (; max_pos
>= min_pos
; max_pos
--) {
1184 Sheet
*sheet
= g_ptr_array_index (wb
->sheets
, max_pos
);
1185 sheet
->index_in_wb
= max_pos
;
1189 post_sheet_index_change (wb
);
1191 go_doc_set_dirty (GO_DOC (wb
), TRUE
);
1195 * workbook_sheet_get_free_name:
1196 * @wb: #Workbook for which the new name can be used
1197 * @base: base for the name, e. g. "Sheet"
1198 * @always_suffix: if true, add suffix even if the name "base" is not in use.
1199 * @handle_counter: strip counter if necessary
1201 * Gets a new unquoted name for a sheets such that it does not exist on the
1204 * Returns: (transfer full): a unique sheet name
1207 workbook_sheet_get_free_name (Workbook
*wb
,
1209 gboolean always_suffix
,
1210 gboolean handle_counter
)
1212 char const *name_format
;
1213 char *name
, *base_name
;
1217 g_return_val_if_fail (wb
!= NULL
, NULL
);
1219 if (!always_suffix
&& (workbook_sheet_by_name (wb
, base
) == NULL
))
1220 return g_strdup (base
); /* Name not in use */
1222 base_name
= g_strdup (base
);
1223 if (handle_counter
) {
1224 workbook_sheet_name_strip_number (base_name
, &i
);
1225 name_format
= "%s(%u)";
1227 name_format
= "%s%u";
1229 limit
= workbook_sheet_count (wb
) + 2;
1230 name
= g_malloc (strlen (base_name
) + strlen (name_format
) + 10);
1231 while (limit
-- > 0) {
1233 sprintf (name
, name_format
, base_name
, i
);
1234 if (workbook_sheet_by_name (wb
, name
) == NULL
) {
1240 /* We should not get here. */
1241 g_warning ("There is trouble at the mill.");
1245 name
= g_strdup_printf ("%s (%i)", base
, 2);
1250 * workbook_sheet_rename:
1251 * @wb: #Workbook in which to rename sheets
1252 * @sheet_indices: (element-type int): list of sheet indices (ignore -1)
1253 * @new_names: (element-type utf8): list of new names
1255 * Adjusts the names of the sheets. We assume that everything is
1256 * valid. If in doubt call workbook_sheet_reorder_check first.
1258 * Returns: %FALSE when it was successful
1261 workbook_sheet_rename (Workbook
*wb
,
1262 GSList
*sheet_indices
,
1264 G_GNUC_UNUSED GOCmdContext
*cc
)
1266 GSList
*sheet_index
= sheet_indices
;
1267 GSList
*new_name
= new_names
;
1269 while (new_name
&& sheet_index
) {
1270 int ix
= GPOINTER_TO_INT (sheet_index
->data
);
1271 const char *name
= new_name
->data
;
1273 g_hash_table_remove (wb
->sheet_hash_private
, name
);
1274 sheet_index
= sheet_index
->next
;
1275 new_name
= new_name
->next
;
1278 sheet_index
= sheet_indices
;
1279 new_name
= new_names
;
1280 while (new_name
&& sheet_index
) {
1281 int ix
= GPOINTER_TO_INT (sheet_index
->data
);
1282 const char *name
= new_name
->data
;
1284 Sheet
*sheet
= workbook_sheet_by_index (wb
, ix
);
1285 g_object_set (sheet
, "name", name
, NULL
);
1287 sheet_index
= sheet_index
->next
;
1288 new_name
= new_name
->next
;
1295 * workbook_find_command:
1297 * @is_undo: undo vs redo
1300 * Returns: the 1 based index of the @key command, or 0 if it is not found
1301 * (which would be a programmer error).
1304 workbook_find_command (Workbook
*wb
, gboolean is_undo
, gpointer cmd
)
1309 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), 0);
1311 ptr
= is_undo
? wb
->undo_commands
: wb
->redo_commands
;
1312 for ( ; ptr
!= NULL
; ptr
= ptr
->next
, n
++)
1313 if (ptr
->data
== cmd
)
1315 g_warning ("%s command : %p not found", is_undo
? "undo" : "redo", cmd
);
1320 * workbook_sheet_reorder:
1321 * @wb: workbook to reorder
1322 * @new_order: (element-type Sheet): list of #Sheet
1324 * Adjusts the order of the sheets.
1326 * Returns %FALSE when it was successful
1329 workbook_sheet_reorder (Workbook
*wb
, GSList
*new_order
)
1335 g_return_val_if_fail (GNM_IS_WORKBOOK (wb
), FALSE
);
1336 g_return_val_if_fail (g_slist_length (new_order
) == wb
->sheets
->len
, FALSE
);
1338 pre_sheet_index_change (wb
);
1340 for (ptr
= new_order
; NULL
!= ptr
; ptr
= ptr
->next
, pos
++) {
1341 g_ptr_array_index (wb
->sheets
, pos
) = sheet
= ptr
->data
;
1342 sheet
->index_in_wb
= pos
;
1345 post_sheet_index_change (wb
);
1351 * workbook_date_conv:
1354 * Returns: (transfer none): the date conventions in effect for the workbook.
1356 GODateConventions
const *
1357 workbook_date_conv (Workbook
const *wb
)
1359 g_return_val_if_fail (wb
!= NULL
, NULL
);
1360 return wb
->date_conv
;
1364 * workbook_set_date_conv:
1366 * @date_conv: new date convention
1368 * Sets the date convention @date_conv.
1369 * NOTE : THIS IS NOT A SMART ROUTINE. If you want to actually change this
1370 * We'll need to recalc and rerender everything. That will need to be done
1374 workbook_set_date_conv (Workbook
*wb
, GODateConventions
const *date_conv
)
1376 g_return_if_fail (GNM_IS_WORKBOOK (wb
));
1377 g_return_if_fail (date_conv
!= NULL
);
1379 wb
->date_conv
= date_conv
;
1383 workbook_set_1904 (Workbook
*wb
, gboolean base1904
)
1385 GODateConventions
const *date_conv
=
1386 go_date_conv_from_str (base1904
? "Apple:1904" : "Lotus:1900");
1387 workbook_set_date_conv (wb
, date_conv
);
1391 * workbook_get_sheet_size:
1394 * Returns: (transfer none): the current sheet size for @wb.
1396 GnmSheetSize
const *
1397 workbook_get_sheet_size (Workbook
const *wb
)
1399 if (wb
== NULL
|| workbook_sheet_count (wb
) == 0) {
1400 static const GnmSheetSize max_size
= {
1401 GNM_MAX_COLS
, GNM_MAX_ROWS
1407 return gnm_sheet_get_size (workbook_sheet_by_index (wb
, 0));
1410 /* ------------------------------------------------------------------------- */
1415 } WorkbookSheetStateSheet
;
1417 struct _WorkbookSheetState
{
1420 WorkbookSheetStateSheet
*sheets
;
1425 WorkbookSheetState
*
1426 workbook_sheet_state_new (const Workbook
*wb
)
1429 WorkbookSheetState
*wss
= g_new (WorkbookSheetState
, 1);
1431 wss
->properties
= go_object_properties_collect (G_OBJECT (wb
));
1432 wss
->n_sheets
= workbook_sheet_count (wb
);
1433 wss
->sheets
= g_new (WorkbookSheetStateSheet
, wss
->n_sheets
);
1434 for (i
= 0; i
< wss
->n_sheets
; i
++) {
1435 WorkbookSheetStateSheet
*wsss
= wss
->sheets
+ i
;
1436 wsss
->sheet
= g_object_ref (workbook_sheet_by_index (wb
, i
));
1437 wsss
->properties
= go_object_properties_collect (G_OBJECT (wsss
->sheet
));
1444 workbook_sheet_state_free (WorkbookSheetState
*wss
)
1448 if (!wss
|| wss
->ref_count
-- > 1)
1451 go_object_properties_free (wss
->properties
);
1453 for (i
= 0; i
< wss
->n_sheets
; i
++) {
1454 WorkbookSheetStateSheet
*wsss
= wss
->sheets
+ i
;
1455 g_object_unref (wsss
->sheet
);
1456 go_object_properties_free (wsss
->properties
);
1458 g_free (wss
->sheets
);
1462 static WorkbookSheetState
*
1463 workbook_sheet_state_ref (WorkbookSheetState
*wss
)
1470 workbook_sheet_state_get_type (void)
1475 t
= g_boxed_type_register_static ("WorkbookSheetState",
1476 (GBoxedCopyFunc
)workbook_sheet_state_ref
,
1477 (GBoxedFreeFunc
)workbook_sheet_state_free
);
1483 workbook_sheet_state_restore (Workbook
*wb
, const WorkbookSheetState
*wss
)
1487 /* Get rid of sheets that shouldn't be there. */
1488 for (i
= workbook_sheet_count (wb
) ; i
-- > 0; ) {
1489 Sheet
*sheet
= workbook_sheet_by_index (wb
, i
);
1491 for (j
= 0; j
< wss
->n_sheets
; j
++)
1492 if (sheet
== wss
->sheets
[j
].sheet
)
1494 if (j
== wss
->n_sheets
)
1495 workbook_sheet_delete (sheet
);
1498 /* Attach new sheets and handle order. */
1499 for (i
= 0; i
< wss
->n_sheets
; i
++) {
1500 Sheet
*sheet
= wss
->sheets
[i
].sheet
;
1501 if (sheet
->index_in_wb
!= i
) {
1502 if (sheet
->index_in_wb
== -1) {
1503 workbook_sheet_attach_at_pos (wb
, sheet
, i
);
1504 dependents_revive_sheet (sheet
);
1507 * There might be a smarter way of getting more
1508 * sheets into place faster. This will at
1511 workbook_sheet_move (sheet
, i
- sheet
->index_in_wb
);
1514 go_object_properties_apply (G_OBJECT (sheet
),
1515 wss
->sheets
[i
].properties
,
1519 go_object_properties_apply (G_OBJECT (wb
), wss
->properties
, TRUE
);
1523 workbook_sheet_state_size (const WorkbookSheetState
*wss
)
1525 int size
= 1 + g_slist_length (wss
->properties
);
1527 for (i
= 0; i
< wss
->n_sheets
; i
++) {
1528 WorkbookSheetStateSheet
*wsss
= wss
->sheets
+ i
;
1529 size
+= 5; /* For ->sheet. */
1530 size
+= g_slist_length (wsss
->properties
);
1535 GNM_BEGIN_KILL_SWITCH_WARNING
1537 workbook_sheet_state_diff (const WorkbookSheetState
*wss_a
, const WorkbookSheetState
*wss_b
)
1540 WSS_SHEET_RENAMED
= 1,
1541 WSS_SHEET_ADDED
= 2,
1542 WSS_SHEET_TAB_COLOR
= 4,
1543 WSS_SHEET_PROPERTIES
= 8,
1544 WSS_SHEET_DELETED
= 16,
1545 WSS_SHEET_ORDER
= 32,
1546 WSS_FUNNY
= 0x40000000
1550 int n_added
, n_deleted
= 0;
1552 for (ia
= 0; ia
< wss_a
->n_sheets
; ia
++) {
1553 Sheet
*sheet
= wss_a
->sheets
[ia
].sheet
;
1558 for (ib
= 0; ib
< wss_b
->n_sheets
; ib
++)
1559 if (sheet
== wss_b
->sheets
[ib
].sheet
)
1561 if (ib
== wss_b
->n_sheets
) {
1562 what
|= WSS_SHEET_DELETED
;
1569 what
|= WSS_SHEET_ORDER
;
1570 /* We do not count reordered sheet. */
1573 pa
= wss_a
->sheets
[ia
].properties
;
1574 pb
= wss_b
->sheets
[ib
].properties
;
1575 for (; pa
&& pb
; pa
= pa
->next
->next
, pb
= pb
->next
->next
) {
1576 GParamSpec
*pspec
= pa
->data
;
1577 const GValue
*va
= pa
->next
->data
;
1578 const GValue
*vb
= pb
->next
->data
;
1579 if (pspec
!= pb
->data
)
1582 if (g_param_values_cmp (pspec
, va
, vb
) == 0)
1586 if (strcmp (pspec
->name
, "name") == 0)
1587 what
|= WSS_SHEET_RENAMED
;
1588 else if (strcmp (pspec
->name
, "tab-foreground") == 0)
1589 what
|= WSS_SHEET_TAB_COLOR
;
1590 else if (strcmp (pspec
->name
, "tab-background") == 0)
1591 what
|= WSS_SHEET_TAB_COLOR
;
1593 what
|= WSS_SHEET_PROPERTIES
;
1601 n_added
= wss_b
->n_sheets
- (wss_a
->n_sheets
- n_deleted
);
1603 what
|= WSS_SHEET_ADDED
;
1608 case WSS_SHEET_RENAMED
:
1609 return g_strdup_printf (ngettext ("Renaming sheet", "Renaming %d sheets", n
), n
);
1610 case WSS_SHEET_ADDED
:
1611 return g_strdup_printf (ngettext ("Adding sheet", "Adding %d sheets", n
), n
);
1612 case WSS_SHEET_ADDED
| WSS_SHEET_ORDER
:
1614 * This is most likely just a sheet inserted, but it just
1615 * might be a compound operation. Lie.
1617 return g_strdup_printf (ngettext ("Inserting sheet", "Inserting %d sheets", n
), n
);
1618 case WSS_SHEET_TAB_COLOR
:
1619 return g_strdup (_("Changing sheet tab colors"));
1620 case WSS_SHEET_PROPERTIES
:
1621 return g_strdup (_("Changing sheet properties"));
1622 case WSS_SHEET_DELETED
:
1623 case WSS_SHEET_DELETED
| WSS_SHEET_ORDER
:
1625 * This is most likely just a sheet delete, but it just
1626 * might be a compound operation. Lie.
1628 return g_strdup_printf (ngettext ("Deleting sheet", "Deleting %d sheets", n
), n
);
1629 case WSS_SHEET_ORDER
:
1630 return g_strdup (_("Changing sheet order"));
1632 return g_strdup (_("Reorganizing Sheets"));
1635 GNM_END_KILL_SWITCH_WARNING
1637 /* ------------------------------------------------------------------------- */
1639 GSF_CLASS (Workbook
, workbook
,
1640 workbook_class_init
, workbook_init
,