1 /* PSPPIRE - a graphical user interface for PSPP.
2 Copyright (C) 2006, 2007 Free Software Foundation
4 This program is free software: you can redistribute it and/or modify
5 it under the terms of the GNU General Public License as published by
6 the Free Software Foundation, either version 3 of the License, or
7 (at your option) any later version.
9 This program is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU General Public License for more details.
14 You should have received a copy of the GNU General Public License
15 along with this program. If not, see <http://www.gnu.org/licenses/>. */
21 #include <glade/glade.h>
24 #include "window-manager.h"
25 #include <gtksheet/gtksheet.h>
29 #include <data/procedure.h>
30 #include "psppire-dialog.h"
31 #include "psppire-selector.h"
32 #include "weight-cases-dialog.h"
33 #include "split-file-dialog.h"
34 #include "transpose-dialog.h"
35 #include "sort-cases-dialog.h"
36 #include "select-cases-dialog.h"
37 #include "compute-dialog.h"
38 #include "goto-case-dialog.h"
39 #include "find-dialog.h"
40 #include "comments-dialog.h"
41 #include "variable-info-dialog.h"
42 #include "dict-display.h"
43 #include "clipboard.h"
45 #define _(msgid) gettext (msgid)
46 #define N_(msgid) msgid
48 #include "data-editor.h"
49 #include "syntax-editor.h"
50 #include <language/syntax-string-source.h>
51 #include <language/command.h>
52 #include <libpspp/syntax-gen.h>
53 #include "window-manager.h"
55 #include "psppire-data-store.h"
56 #include "psppire-var-store.h"
58 static void on_edit_copy (GtkMenuItem *, gpointer);
59 static void on_edit_cut (GtkMenuItem *, gpointer);
60 static void on_edit_paste (GtkAction *a, gpointer data);
63 static void create_data_sheet_variable_popup_menu (struct data_editor *);
64 static void create_data_sheet_cases_popup_menu (struct data_editor *);
66 static void popup_variable_menu (GtkSheet *, gint,
67 GdkEventButton *, gpointer data);
69 static void popup_cases_menu (GtkSheet *, gint,
70 GdkEventButton *, gpointer data);
72 /* Update the data_ref_entry with the reference of the active cell */
73 static gint update_data_ref_entry (const GtkSheet *sheet,
74 gint row, gint col, gpointer data);
76 static void register_data_editor_actions (struct data_editor *de);
78 static void insert_variable (GtkAction *, gpointer data);
79 static void insert_case (GtkAction *a, gpointer data);
80 static void delete_cases (GtkAction *a, gpointer data);
81 static void delete_variables (GtkAction *a, gpointer data);
83 static void toggle_value_labels (GtkToggleAction *a, gpointer data);
85 /* Switch between the VAR SHEET and the DATA SHEET */
87 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
88 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
91 /* Callback for when the dictionary changes properties*/
92 static void on_weight_change (GObject *, gint, gpointer);
93 static void on_filter_change (GObject *, gint, gpointer);
94 static void on_split_change (PsppireDict *, gpointer);
96 static void on_switch_sheet (GtkNotebook *notebook,
97 GtkNotebookPage *page,
101 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
103 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
105 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
107 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
109 static void fonts_activate (GtkMenuItem *, gpointer);
111 static void file_quit (GtkCheckMenuItem *, gpointer );
114 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
116 struct data_editor *de = data;
118 gtk_action_set_visible (de->delete_cases, var != -1);
123 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
125 struct data_editor *de = data;
127 gtk_action_set_visible (de->delete_variables, var != -1);
132 /* Run the EXECUTE command. */
134 execute (GtkMenuItem *mi, gpointer data)
136 struct getl_interface *sss = create_syntax_string_source ("EXECUTE.");
138 execute_syntax (sss);
142 transformation_change_callback (bool transformations_pending,
145 struct data_editor *de = data;
146 GtkWidget *menuitem =
147 get_widget_assert (de->xml, "transform_run-pending");
148 GtkWidget *status_label =
149 get_widget_assert (de->xml, "case-counter-area");
151 gtk_widget_set_sensitive (menuitem, transformations_pending);
154 if ( transformations_pending)
155 gtk_label_set_text (GTK_LABEL (status_label),
156 _("Transformations Pending"));
158 gtk_label_set_text (GTK_LABEL (status_label), "");
162 static void open_data_file (const gchar *, struct data_editor *);
165 /* Puts FILE_NAME into the recent list.
166 If it's already in the list, it moves it to the top
169 add_most_recent (const char *file_name)
171 #if RECENT_LISTS_AVAILABLE
173 GtkRecentManager *manager = gtk_recent_manager_get_default();
174 gchar *uri = g_filename_to_uri (file_name, NULL, NULL);
176 gtk_recent_manager_remove_item (manager, uri, NULL);
178 if ( ! gtk_recent_manager_add_item (manager, uri))
179 g_warning ("Could not add item %s to recent list\n",uri);
187 #if RECENT_LISTS_AVAILABLE
190 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
193 struct data_editor *de = user_data;
196 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
198 file = g_filename_from_uri (uri, NULL, NULL);
202 open_data_file (file, de);
208 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
212 struct syntax_editor *se ;
215 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
217 file = g_filename_from_uri (uri, NULL, NULL);
221 se = (struct syntax_editor *)
222 window_create (WINDOW_SYNTAX, file);
224 load_editor_from_file (se, file, NULL);
232 datum_entry_activate (GtkEntry *entry, gpointer data)
235 GtkSheet *data_sheet = GTK_SHEET (data);
236 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
238 const char *text = gtk_entry_get_text (entry);
240 gtk_sheet_get_active_cell (data_sheet, &row, &column);
242 if ( row == -1 || column == -1)
245 psppire_data_store_set_string (store, text, row, column);
249 /* Update the Edit->Paste menuitem
250 If PAGE is not -1 , then it should be set to the current page of
251 the data editors notebook widget.
252 If -1, then it'll be queried.
255 update_paste_menuitem (struct data_editor *de, gint page)
257 GtkWidget * edit_paste = get_widget_assert (de->xml, "edit_paste");
258 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
259 GtkSheet * data_sheet ;
263 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
266 if ( PAGE_VAR_SHEET == page )
268 /* We don't yet support pasting to the var sheet */
269 gtk_widget_set_sensitive (edit_paste, FALSE);
273 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
275 gtk_sheet_get_active_cell (data_sheet, &row, &column);
277 if ( row < 0 || column < 0 )
278 gtk_widget_set_sensitive (edit_paste, FALSE);
280 gtk_widget_set_sensitive (edit_paste, TRUE);
283 /* Update the Edit->Cut and Edit->Copy menuitems
284 If PAGE is not -1 , then it should be set to the current page of
285 the data editors notebook widget.
286 If -1, then it'll be queried.
289 update_cut_copy_menuitem (struct data_editor *de, gint page)
291 GtkWidget * edit_copy = get_widget_assert (de->xml, "edit_copy");
292 GtkWidget * edit_cut = get_widget_assert (de->xml, "edit_cut");
293 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
294 GtkSheet * data_sheet ;
298 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
301 if ( PAGE_VAR_SHEET == page )
303 /* We don't yet support copying from the var sheet */
304 gtk_widget_set_sensitive (edit_copy, FALSE);
305 gtk_widget_set_sensitive (edit_cut, FALSE);
309 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
311 gtk_sheet_get_active_cell (data_sheet, &row, &column);
313 if ( row < 0 || column < 0 )
315 gtk_widget_set_sensitive (edit_copy, FALSE);
316 gtk_widget_set_sensitive (edit_cut, FALSE);
320 gtk_widget_set_sensitive (edit_copy, TRUE);
321 gtk_widget_set_sensitive (edit_cut, TRUE);
325 /* Callback for when the datasheet's active cell becomes active/inactive */
327 on_data_sheet_activate_change (GtkSheet *sheet,
328 gint row, gint column, gpointer data)
330 struct data_editor *de = data;
332 update_paste_menuitem (de, -1);
333 update_cut_copy_menuitem (de, -1);
338 extern struct dataset *the_dataset;
341 Create a new data editor.
344 new_data_editor (void)
346 struct data_editor *de ;
347 struct editor_window *e;
348 GtkSheet *var_sheet ;
349 GtkSheet *data_sheet ;
351 GtkWidget *datum_entry;
353 de = g_malloc0 (sizeof (*de));
355 e = (struct editor_window *) de;
357 de->xml = XML_NEW ("data-editor.glade");
360 dataset_add_transform_change_callback (the_dataset,
361 transformation_change_callback,
364 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
365 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
368 g_signal_connect (G_OBJECT (data_sheet), "activate",
369 G_CALLBACK (on_data_sheet_activate_change), de);
371 g_signal_connect (G_OBJECT (data_sheet), "deactivate",
372 G_CALLBACK (on_data_sheet_activate_change), de);
375 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
377 g_assert(vs); /* Traps a possible bug in win32 build */
379 g_signal_connect (G_OBJECT (data_sheet), "activate",
380 G_CALLBACK (update_data_ref_entry),
383 datum_entry = get_widget_assert (de->xml, "datum_entry");
385 g_signal_connect (G_OBJECT (datum_entry), "activate",
386 G_CALLBACK (datum_entry_activate),
389 g_signal_connect (vs->dict, "weight-changed",
390 G_CALLBACK (on_weight_change),
393 g_signal_connect (vs->dict, "filter-changed",
394 G_CALLBACK (on_filter_change),
397 g_signal_connect (vs->dict, "split-changed",
398 G_CALLBACK (on_split_change),
401 connect_help (de->xml);
405 g_signal_connect (get_widget_assert (de->xml, "edit_copy"),
407 G_CALLBACK (on_edit_copy), de);
409 g_signal_connect (get_widget_assert (de->xml, "edit_cut"),
411 G_CALLBACK (on_edit_cut), de);
414 register_data_editor_actions (de);
416 de->toggle_value_labels =
417 gtk_toggle_action_new ("toggle-value-labels",
419 _("Show/hide value labels"),
420 "pspp-value-labels");
422 g_signal_connect (de->toggle_value_labels, "activate",
423 G_CALLBACK (toggle_value_labels), de);
426 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
427 get_widget_assert (de->xml,
428 "togglebutton-value-labels"));
431 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
432 get_widget_assert (de->xml,
433 "view_value-labels"));
436 gtk_action_new ("clear-cases",
438 _("Delete the cases at the selected position(s)"),
441 g_signal_connect (de->delete_cases, "activate",
442 G_CALLBACK (delete_cases), de);
444 gtk_action_connect_proxy (de->delete_cases,
445 get_widget_assert (de->xml, "edit_clear-cases"));
447 g_signal_connect (get_widget_assert (de->xml, "edit_paste"), "activate",
448 G_CALLBACK (on_edit_paste), de);
450 gtk_action_set_visible (de->delete_cases, FALSE);
452 de->delete_variables =
453 gtk_action_new ("clear-variables",
455 _("Delete the variables at the selected position(s)"),
456 "pspp-clear-variables");
458 g_signal_connect (de->delete_variables, "activate",
459 G_CALLBACK (delete_variables), de);
461 gtk_action_connect_proxy (de->delete_variables,
462 get_widget_assert (de->xml, "edit_clear-variables")
465 gtk_action_set_visible (de->delete_variables, FALSE);
467 de->insert_variable =
468 gtk_action_new ("insert-variable",
469 _("Insert Variable"),
470 _("Create a new variable at the current position"),
471 "pspp-insert-variable");
473 g_signal_connect (de->insert_variable, "activate",
474 G_CALLBACK (insert_variable), de);
477 gtk_action_connect_proxy (de->insert_variable,
478 get_widget_assert (de->xml, "button-insert-variable")
481 gtk_action_connect_proxy (de->insert_variable,
482 get_widget_assert (de->xml, "edit_insert-variable")
487 gtk_action_new ("insert-case",
489 _("Create a new case at the current position"),
492 g_signal_connect (de->insert_case, "activate",
493 G_CALLBACK (insert_case), de);
496 gtk_action_connect_proxy (de->insert_case,
497 get_widget_assert (de->xml, "button-insert-case")
501 gtk_action_connect_proxy (de->insert_case,
502 get_widget_assert (de->xml, "edit_insert-case")
507 de->invoke_goto_dialog =
508 gtk_action_new ("goto-case-dialog",
510 _("Jump to a Case in the Data Sheet"),
514 gtk_action_connect_proxy (de->invoke_goto_dialog,
515 get_widget_assert (de->xml, "button-goto-case")
518 gtk_action_connect_proxy (de->invoke_goto_dialog,
519 get_widget_assert (de->xml, "edit_goto-case")
523 g_signal_connect (de->invoke_goto_dialog, "activate",
524 G_CALLBACK (goto_case_dialog), de);
527 de->invoke_weight_cases_dialog =
528 gtk_action_new ("weight-cases-dialog",
530 _("Weight cases by variable"),
531 "pspp-weight-cases");
533 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
534 G_CALLBACK (weight_cases_dialog), de);
537 de->invoke_transpose_dialog =
538 gtk_action_new ("transpose-dialog",
540 _("Transpose the cases with the variables"),
544 g_signal_connect (de->invoke_transpose_dialog, "activate",
545 G_CALLBACK (transpose_dialog), de);
549 de->invoke_split_file_dialog =
550 gtk_action_new ("split-file-dialog",
552 _("Split the active file"),
555 g_signal_connect (de->invoke_split_file_dialog, "activate",
556 G_CALLBACK (split_file_dialog), de);
560 de->invoke_sort_cases_dialog =
561 gtk_action_new ("sort-cases-dialog",
563 _("Sort cases in the active file"),
566 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
567 G_CALLBACK (sort_cases_dialog), de);
569 de->invoke_select_cases_dialog =
570 gtk_action_new ("select-cases-dialog",
572 _("Select cases from the active file"),
573 "pspp-select-cases");
575 g_signal_connect (de->invoke_select_cases_dialog, "activate",
576 G_CALLBACK (select_cases_dialog), de);
579 de->invoke_compute_dialog =
580 gtk_action_new ("compute-dialog",
582 _("Compute new values for a variable"),
585 g_signal_connect (de->invoke_compute_dialog, "activate",
586 G_CALLBACK (compute_dialog), de);
588 de->invoke_comments_dialog =
589 gtk_action_new ("commments-dialog",
590 _("Data File Comments"),
591 _("Commentary text for the data file"),
594 g_signal_connect (de->invoke_comments_dialog, "activate",
595 G_CALLBACK (comments_dialog), de);
597 de->invoke_find_dialog =
598 gtk_action_new ("find-dialog",
603 g_signal_connect (de->invoke_find_dialog, "activate",
604 G_CALLBACK (find_dialog), de);
607 de->invoke_variable_info_dialog =
608 gtk_action_new ("variable-info-dialog",
610 _("Jump to Variable"),
611 "pspp-goto-variable");
613 g_signal_connect (de->invoke_variable_info_dialog, "activate",
614 G_CALLBACK (variable_info_dialog), de);
616 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
618 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
620 G_CALLBACK (gtk_action_activate),
621 de->action_data_new);
623 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
625 G_CALLBACK (gtk_action_activate),
626 de->action_data_open);
629 #if RECENT_LISTS_AVAILABLE
631 GtkRecentManager *rm = gtk_recent_manager_get_default ();
632 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
633 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
634 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
636 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
638 GtkRecentFilter *filter = gtk_recent_filter_new ();
640 gtk_widget_show (recent_data);
641 gtk_widget_show (recent_files);
642 gtk_widget_show (recent_separator);
644 gtk_recent_filter_add_pattern (filter, "*.sav");
645 gtk_recent_filter_add_pattern (filter, "*.SAV");
647 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
649 gtk_widget_set_sensitive (recent_data, TRUE);
650 g_signal_connect (menu, "selection-done",
651 G_CALLBACK (on_recent_data_select), de);
653 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
656 filter = gtk_recent_filter_new ();
657 menu = gtk_recent_chooser_menu_new_for_manager (rm);
659 gtk_recent_filter_add_pattern (filter, "*.sps");
660 gtk_recent_filter_add_pattern (filter, "*.SPS");
662 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
664 gtk_widget_set_sensitive (recent_files, TRUE);
665 g_signal_connect (menu, "selection-done",
666 G_CALLBACK (on_recent_files_select), de);
668 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
672 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
674 G_CALLBACK (new_syntax_window),
677 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
679 G_CALLBACK (open_syntax_window),
682 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
684 G_CALLBACK (gtk_action_activate),
685 de->action_data_save);
687 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
689 G_CALLBACK (gtk_action_activate),
690 de->action_data_save_as);
692 gtk_action_connect_proxy (de->invoke_find_dialog,
693 get_widget_assert (de->xml, "edit_find")
696 gtk_action_connect_proxy (de->invoke_find_dialog,
697 get_widget_assert (de->xml, "button-find")
700 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
701 get_widget_assert (de->xml, "data_weight-cases")
704 gtk_action_connect_proxy (de->invoke_transpose_dialog,
705 get_widget_assert (de->xml, "data_transpose")
708 gtk_action_connect_proxy (de->invoke_split_file_dialog,
709 get_widget_assert (de->xml, "data_split-file")
712 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
713 get_widget_assert (de->xml, "data_sort-cases")
716 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
717 get_widget_assert (de->xml, "data_select-cases")
720 gtk_action_connect_proxy (de->invoke_compute_dialog,
721 get_widget_assert (de->xml, "transform_compute")
724 gtk_action_connect_proxy (de->invoke_comments_dialog,
725 get_widget_assert (de->xml, "utilities_comments")
728 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
729 get_widget_assert (de->xml, "utilities_variables")
732 g_signal_connect (get_widget_assert (de->xml,"help_about"),
734 G_CALLBACK (about_new),
738 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
740 G_CALLBACK (reference_manual),
743 g_signal_connect (data_sheet,
744 "double-click-column",
745 G_CALLBACK (click2column),
748 g_signal_connect (data_sheet,
750 G_CALLBACK (enable_delete_variables),
753 g_signal_connect (data_sheet,
755 G_CALLBACK (enable_delete_cases),
759 g_signal_connect (var_sheet,
761 GTK_SIGNAL_FUNC (click2row),
764 g_signal_connect_after (var_sheet,
766 G_CALLBACK (enable_delete_variables),
769 g_signal_connect (get_widget_assert (de->xml, "notebook"),
771 G_CALLBACK (on_switch_sheet), de);
774 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
776 G_CALLBACK (status_bar_activate), de);
779 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
781 G_CALLBACK (grid_lines_activate), de);
785 g_signal_connect (get_widget_assert (de->xml, "view_data"),
787 G_CALLBACK (data_sheet_activate), de);
789 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
791 G_CALLBACK (variable_sheet_activate), de);
795 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
797 G_CALLBACK (fonts_activate), de);
802 gtk_action_connect_proxy (de->action_data_open,
803 get_widget_assert (de->xml, "button-open")
806 gtk_action_connect_proxy (de->action_data_save,
807 get_widget_assert (de->xml, "button-save")
810 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
811 get_widget_assert (de->xml, "button-goto-variable")
814 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
815 get_widget_assert (de->xml, "button-weight-cases")
818 gtk_action_connect_proxy (de->invoke_split_file_dialog,
819 get_widget_assert (de->xml, "button-split-file")
822 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
823 get_widget_assert (de->xml, "button-select-cases")
827 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
829 G_CALLBACK (file_quit), de);
831 g_signal_connect (get_widget_assert (de->xml, "transform_run-pending"),
833 G_CALLBACK (execute), de);
836 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
838 G_CALLBACK (minimise_all_windows), NULL);
841 create_data_sheet_variable_popup_menu (de);
842 create_data_sheet_cases_popup_menu (de);
844 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
845 G_CALLBACK (popup_variable_menu), de);
847 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
848 G_CALLBACK (popup_cases_menu), de);
854 /* Callback which occurs when the var sheet's row title
855 button is double clicked */
857 click2row (GtkWidget *w, gint row, gpointer data)
859 struct data_editor *de = data;
860 GtkSheetRange visible_range;
862 gint current_row, current_column;
864 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
866 data_editor_select_sheet (de, PAGE_DATA_SHEET);
868 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
869 ¤t_row, ¤t_column);
871 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
873 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
875 if ( row < visible_range.col0 || row > visible_range.coli)
877 gtk_sheet_moveto (GTK_SHEET (data_sheet),
878 current_row, row, 0, 0);
885 /* Callback which occurs when the data sheet's column title
888 click2column (GtkWidget *w, gint col, gpointer data)
890 struct data_editor *de = data;
892 gint current_row, current_column;
894 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
896 data_editor_select_sheet (de, PAGE_VAR_SHEET);
898 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
899 ¤t_row, ¤t_column);
901 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
908 new_data_window (GtkMenuItem *menuitem, gpointer parent)
910 window_create (WINDOW_DATA, NULL);
913 /* Callback for when the datasheet/varsheet is selected */
915 on_switch_sheet (GtkNotebook *notebook,
916 GtkNotebookPage *page,
920 struct data_editor *de = user_data;
922 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
923 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
928 gtk_widget_hide (view_variables);
929 gtk_widget_show (view_data);
930 gtk_action_set_sensitive (de->insert_variable, TRUE);
931 gtk_action_set_sensitive (de->insert_case, FALSE);
932 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
934 case PAGE_DATA_SHEET:
935 gtk_widget_show (view_variables);
936 gtk_widget_show (view_data);
937 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
938 gtk_action_set_sensitive (de->insert_case, TRUE);
941 g_assert_not_reached ();
945 update_paste_menuitem (de, page_num);
946 update_cut_copy_menuitem (de, page_num);
951 data_editor_select_sheet (struct data_editor *de, gint page)
953 gtk_notebook_set_current_page
955 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
962 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
964 struct data_editor *de = data;
965 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
967 if ( gtk_check_menu_item_get_active (menuitem) )
968 gtk_widget_show (statusbar);
970 gtk_widget_hide (statusbar);
975 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
977 struct data_editor *de = data;
978 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
980 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
984 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
991 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
993 struct data_editor *de = data;
995 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1000 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1002 struct data_editor *de = data;
1004 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1009 fonts_activate (GtkMenuItem *menuitem, gpointer data)
1011 struct data_editor *de = data;
1013 gtk_font_selection_dialog_new (_("Font Selection"));
1015 gtk_window_set_transient_for (GTK_WINDOW (dialog),
1016 GTK_WINDOW (get_widget_assert (de->xml,
1018 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
1020 GtkSheet *data_sheet =
1021 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1023 GtkSheet *var_sheet =
1024 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1026 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1027 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
1029 const gchar *font = gtk_font_selection_dialog_get_font_name
1030 (GTK_FONT_SELECTION_DIALOG (dialog));
1032 PangoFontDescription* font_desc =
1033 pango_font_description_from_string (font);
1035 psppire_var_store_set_font (vs, font_desc);
1036 psppire_data_store_set_font (ds, font_desc);
1039 gtk_widget_hide (dialog);
1044 /* Callback for the value labels action */
1046 toggle_value_labels (GtkToggleAction *ta, gpointer data)
1048 struct data_editor *de = data;
1050 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1052 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1055 psppire_data_store_show_labels (ds,
1056 gtk_toggle_action_get_active (ta));
1061 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
1063 /* FIXME: Need to be more intelligent here.
1064 Give the user the opportunity to save any unsaved data.
1070 delete_cases (GtkAction *action, gpointer data)
1072 struct data_editor *de = data;
1073 GtkSheet *data_sheet =
1074 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1076 GtkSheetRange range;
1078 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
1079 (gtk_sheet_get_model (data_sheet) );
1082 /* This shouldn't be able to happen, because the action
1083 should be disabled */
1084 g_return_if_fail (gtk_sheet_get_state (data_sheet)
1085 == GTK_SHEET_ROW_SELECTED );
1087 gtk_sheet_get_selected_range (data_sheet, &range);
1089 gtk_sheet_unselect_range (data_sheet);
1091 psppire_data_store_delete_cases (data_store, range.row0,
1092 1 + range.rowi - range.row0);
1097 delete_variables (GtkAction *a, gpointer data)
1099 struct data_editor *de = data;
1100 GtkSheetRange range;
1102 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
1105 const gint page = gtk_notebook_get_current_page (notebook);
1107 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
1108 (page == PAGE_VAR_SHEET) ?
1113 gtk_sheet_get_selected_range (sheet, &range);
1117 case PAGE_VAR_SHEET:
1119 PsppireVarStore *vs =
1120 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
1122 psppire_dict_delete_variables (vs->dict,
1129 case PAGE_DATA_SHEET:
1131 PsppireDataStore *ds =
1132 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1134 psppire_dict_delete_variables (ds->dict,
1143 gtk_sheet_unselect_range (sheet);
1147 insert_case (GtkAction *action, gpointer data)
1150 struct data_editor *de = data;
1152 GtkSheet *data_sheet =
1153 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1155 PsppireDataStore *ds = PSPPIRE_DATA_STORE
1156 (gtk_sheet_get_model (data_sheet) );
1159 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
1161 if (current_row < 0) current_row = 0;
1163 psppire_data_store_insert_new_case (ds, current_row);
1166 /* Insert a new variable before the current row in the variable sheet,
1167 or before the current column in the data sheet, whichever is selected */
1169 insert_variable (GtkAction *action, gpointer data)
1171 struct data_editor *de = data;
1174 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
1176 GtkSheet *var_sheet =
1177 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1179 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1180 (gtk_sheet_get_model (var_sheet) );
1182 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
1184 case PAGE_VAR_SHEET:
1185 posn = var_sheet->active_cell.row;
1187 case PAGE_DATA_SHEET:
1189 GtkSheet *data_sheet =
1190 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1192 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
1193 posn = data_sheet->range.col0;
1195 posn = data_sheet->active_cell.col;
1199 g_assert_not_reached ();
1202 if ( posn == -1 ) posn = 0;
1204 psppire_dict_insert_variable (vs->dict, posn, NULL);
1207 /* Callback for when the dictionary changes its split variables */
1209 on_split_change (PsppireDict *dict, gpointer data)
1211 struct data_editor *de = data;
1213 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1215 GtkWidget *split_status_area =
1216 get_widget_assert (de->xml, "split-file-status-area");
1218 if ( n_split_vars == 0 )
1220 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1226 const struct variable *const * split_vars =
1227 dict_get_split_vars (dict->dict);
1229 text = g_string_new (_("Split by "));
1231 for (i = 0 ; i < n_split_vars - 1; ++i )
1233 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1235 g_string_append (text, var_get_name (split_vars[i]));
1237 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1239 g_string_free (text, TRUE);
1244 /* Callback for when the dictionary changes its filter variable */
1246 on_filter_change (GObject *o, gint filter_index, gpointer data)
1248 struct data_editor *de = data;
1249 GtkWidget *filter_status_area =
1250 get_widget_assert (de->xml, "filter-use-status-area");
1252 if ( filter_index == -1 )
1254 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1258 GtkSheet *var_sheet =
1259 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1261 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1262 (gtk_sheet_get_model (var_sheet) );
1264 struct variable *var = psppire_dict_get_variable (vs->dict,
1267 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1269 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1275 /* Callback for when the dictionary changes its weights */
1277 on_weight_change (GObject *o, gint weight_index, gpointer data)
1279 struct data_editor *de = data;
1280 GtkWidget *weight_status_area =
1281 get_widget_assert (de->xml, "weight-status-area");
1283 if ( weight_index == -1 )
1285 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1289 GtkSheet *var_sheet =
1290 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1292 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1293 (gtk_sheet_get_model (var_sheet) );
1295 struct variable *var = psppire_dict_get_variable (vs->dict,
1298 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1300 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1309 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1310 static void new_file (GtkAction *, struct editor_window *de);
1311 static void open_data_dialog (GtkAction *, struct data_editor *de);
1312 static void data_save (GtkAction *action, struct data_editor *e);
1315 /* Create the GtkActions and connect to their signals */
1317 register_data_editor_actions (struct data_editor *de)
1319 de->action_data_open =
1320 gtk_action_new ("data-open-dialog",
1322 _("Open a data file"),
1325 g_signal_connect (de->action_data_open, "activate",
1326 G_CALLBACK (open_data_dialog), de);
1329 de->action_data_save = gtk_action_new ("data-save",
1331 _("Save data to file"),
1334 g_signal_connect (de->action_data_save, "activate",
1335 G_CALLBACK (data_save), de);
1339 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1341 _("Save data to file"),
1344 g_signal_connect (de->action_data_save_as, "activate",
1345 G_CALLBACK (data_save_as_dialog), de);
1347 de->action_data_new =
1348 gtk_action_new ("data-new",
1353 g_signal_connect (de->action_data_new, "activate",
1354 G_CALLBACK (new_file), de);
1357 /* Returns true if NAME has a suffix which might denote a PSPP file */
1359 name_has_suffix (const gchar *name)
1361 if ( g_str_has_suffix (name, ".sav"))
1363 if ( g_str_has_suffix (name, ".SAV"))
1365 if ( g_str_has_suffix (name, ".por"))
1367 if ( g_str_has_suffix (name, ".POR"))
1373 /* Append SUFFIX to the filename of DE */
1375 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1377 if ( ! name_has_suffix (de->file_name))
1379 gchar *s = de->file_name;
1380 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1385 /* Save DE to file */
1387 save_file (struct data_editor *de)
1389 struct getl_interface *sss;
1390 struct string file_name ;
1392 g_assert (de->file_name);
1394 ds_init_cstr (&file_name, de->file_name);
1395 gen_quoted_string (&file_name);
1397 if ( de->save_as_portable )
1399 append_filename_suffix (de, ".por");
1400 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1401 ds_cstr (&file_name));
1405 append_filename_suffix (de, ".sav");
1406 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1407 ds_cstr (&file_name));
1410 ds_destroy (&file_name);
1412 execute_syntax (sss);
1416 /* Callback for data_save action.
1417 If there's an existing file name, then just save,
1418 otherwise prompt for a file name, then save */
1420 data_save (GtkAction *action, struct data_editor *de)
1425 data_save_as_dialog (action, de);
1429 /* Callback for data_save_as action. Prompt for a filename and save */
1431 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1433 struct editor_window *e = (struct editor_window *) de;
1435 GtkWidget *button_sys;
1437 gtk_file_chooser_dialog_new (_("Save"),
1438 GTK_WINDOW (e->window),
1439 GTK_FILE_CHOOSER_ACTION_SAVE,
1440 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1441 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1444 GtkFileFilter *filter = gtk_file_filter_new ();
1445 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1446 gtk_file_filter_add_pattern (filter, "*.sav");
1447 gtk_file_filter_add_pattern (filter, "*.SAV");
1448 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1450 filter = gtk_file_filter_new ();
1451 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1452 gtk_file_filter_add_pattern (filter, "*.por");
1453 gtk_file_filter_add_pattern (filter, "*.POR");
1454 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1456 filter = gtk_file_filter_new ();
1457 gtk_file_filter_set_name (filter, _("All Files"));
1458 gtk_file_filter_add_pattern (filter, "*");
1459 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1462 GtkWidget *button_por;
1463 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1465 gtk_radio_button_new_with_label (NULL, _("System File"));
1468 gtk_radio_button_new_with_label
1469 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1470 _("Portable File"));
1472 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1473 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1475 gtk_widget_show_all (vbox);
1477 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1480 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1482 case GTK_RESPONSE_ACCEPT:
1484 g_free (de->file_name);
1487 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1489 de->save_as_portable =
1490 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1494 window_set_name_from_filename (e, de->file_name);
1501 gtk_widget_destroy (dialog);
1505 /* Callback for data_new action.
1506 Performs the NEW FILE command */
1508 new_file (GtkAction *action, struct editor_window *e)
1510 struct data_editor *de = (struct data_editor *) e;
1512 struct getl_interface *sss =
1513 create_syntax_string_source ("NEW FILE.");
1515 execute_syntax (sss);
1517 g_free (de->file_name);
1518 de->file_name = NULL;
1520 default_window_name (e);
1525 open_data_file (const gchar *file_name, struct data_editor *de)
1527 struct getl_interface *sss;
1528 struct string filename;
1530 ds_init_cstr (&filename, file_name);
1532 gen_quoted_string (&filename);
1534 sss = create_syntax_string_source ("GET FILE=%s.",
1535 ds_cstr (&filename));
1536 ds_destroy (&filename);
1538 if (execute_syntax (sss) )
1540 window_set_name_from_filename ((struct editor_window *) de, file_name);
1541 add_most_recent (file_name);
1547 /* Callback for the data_open action.
1548 Prompts for a filename and opens it */
1550 open_data_dialog (GtkAction *action, struct data_editor *de)
1552 struct editor_window *e = (struct editor_window *) de;
1555 gtk_file_chooser_dialog_new (_("Open"),
1556 GTK_WINDOW (e->window),
1557 GTK_FILE_CHOOSER_ACTION_OPEN,
1558 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1559 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1562 GtkFileFilter *filter = gtk_file_filter_new ();
1563 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1564 gtk_file_filter_add_pattern (filter, "*.sav");
1565 gtk_file_filter_add_pattern (filter, "*.SAV");
1566 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1568 filter = gtk_file_filter_new ();
1569 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1570 gtk_file_filter_add_pattern (filter, "*.por");
1571 gtk_file_filter_add_pattern (filter, "*.POR");
1572 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1574 filter = gtk_file_filter_new ();
1575 gtk_file_filter_set_name (filter, _("All Files"));
1576 gtk_file_filter_add_pattern (filter, "*");
1577 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1582 gchar *dir_name = g_path_get_dirname (de->file_name);
1583 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1588 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1590 case GTK_RESPONSE_ACCEPT:
1592 g_free (de->file_name);
1594 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1596 open_data_file (de->file_name, de);
1603 gtk_widget_destroy (dialog);
1608 /* Update the data_ref_entry with the reference of the active cell */
1610 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1612 GladeXML *data_editor_xml = data;
1614 PsppireDataStore *data_store =
1615 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1617 g_return_val_if_fail (data_editor_xml, FALSE);
1621 const struct variable *var =
1622 psppire_dict_get_variable (data_store->dict, col);
1624 /* The entry where the reference to the current cell is displayed */
1625 GtkEntry *cell_ref_entry =
1626 GTK_ENTRY (get_widget_assert (data_editor_xml,
1628 GtkEntry *datum_entry =
1629 GTK_ENTRY (get_widget_assert (data_editor_xml,
1634 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1635 var_get_name (var));
1637 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1641 gtk_entry_set_text (cell_ref_entry, s);
1646 gtk_entry_set_text (cell_ref_entry, "");
1652 psppire_data_store_get_string (data_store, row,
1653 var_get_dict_index(var));
1656 gtk_entry_set_text (datum_entry, text);
1661 gtk_entry_set_text (datum_entry, "");
1672 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1674 GString *string = g_string_new ("SORT CASES BY ");
1676 const struct variable *v =
1677 psppire_dict_get_variable (ds->dict, var);
1679 g_string_append_printf (string, "%s", var_get_name (v));
1682 g_string_append (string, " (D)");
1684 g_string_append (string, ".");
1686 execute_syntax (create_syntax_string_source (string->str));
1688 g_string_free (string, TRUE);
1693 sort_up (GtkMenuItem *item, gpointer data)
1695 GtkSheet *sheet = data;
1696 GtkSheetRange range;
1697 gtk_sheet_get_selected_range (sheet, &range);
1699 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1705 sort_down (GtkMenuItem *item, gpointer data)
1707 GtkSheet *sheet = data;
1708 GtkSheetRange range;
1709 gtk_sheet_get_selected_range (sheet, &range);
1711 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1719 create_data_sheet_variable_popup_menu (struct data_editor *de)
1721 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1722 GtkWidget *menu = gtk_menu_new ();
1724 GtkWidget *sort_ascending =
1725 gtk_menu_item_new_with_label (_("Sort Ascending"));
1727 GtkWidget *sort_descending =
1728 gtk_menu_item_new_with_label (_("Sort Descending"));
1731 GtkWidget *insert_variable =
1732 gtk_menu_item_new_with_label (_("Insert Variable"));
1734 GtkWidget *clear_variable =
1735 gtk_menu_item_new_with_label (_("Clear"));
1738 gtk_action_connect_proxy (de->insert_variable,
1742 gtk_action_connect_proxy (de->delete_variables,
1746 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1749 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1750 gtk_separator_menu_item_new ());
1753 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1756 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1757 gtk_separator_menu_item_new ());
1760 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1761 G_CALLBACK (sort_up), sheet);
1763 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1766 g_signal_connect (G_OBJECT (sort_descending), "activate",
1767 G_CALLBACK (sort_down), sheet);
1770 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1772 gtk_widget_show_all (menu);
1775 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1780 create_data_sheet_cases_popup_menu (struct data_editor *de)
1782 GtkWidget *menu = gtk_menu_new ();
1784 GtkWidget *insert_case =
1785 gtk_menu_item_new_with_label (_("Insert Case"));
1787 GtkWidget *delete_case =
1788 gtk_menu_item_new_with_label (_("Clear"));
1791 gtk_action_connect_proxy (de->insert_case,
1795 gtk_action_connect_proxy (de->delete_cases,
1799 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
1802 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1803 gtk_separator_menu_item_new ());
1806 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
1809 gtk_widget_show_all (menu);
1812 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
1817 popup_variable_menu (GtkSheet *sheet, gint column,
1818 GdkEventButton *event, gpointer data)
1820 struct data_editor *de = data;
1822 PsppireDataStore *data_store =
1823 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1825 const struct variable *v =
1826 psppire_dict_get_variable (data_store->dict, column);
1828 if ( v && event->button == 3)
1831 gtk_sheet_select_column (sheet, column);
1833 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
1834 NULL, NULL, NULL, NULL,
1835 event->button, event->time);
1841 popup_cases_menu (GtkSheet *sheet, gint row,
1842 GdkEventButton *event, gpointer data)
1844 struct data_editor *de = data;
1846 PsppireDataStore *data_store =
1847 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1849 if ( row <= psppire_data_store_get_case_count (data_store) &&
1852 gtk_sheet_select_row (sheet, row);
1854 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
1855 NULL, NULL, NULL, NULL,
1856 event->button, event->time);
1862 on_edit_paste (GtkAction *a, gpointer data)
1864 GtkClipboard *clipboard = gtk_clipboard_get (GDK_SELECTION_CLIPBOARD);
1866 gtk_clipboard_request_contents (clipboard,
1867 gdk_atom_intern ("UTF8_STRING", TRUE),
1868 data_sheet_contents_received_callback,
1874 on_edit_copy (GtkMenuItem *m, gpointer data)
1876 struct data_editor *de = data;
1878 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
1881 data_sheet_set_clip (data_sheet);
1887 on_edit_cut (GtkMenuItem *m, gpointer data)
1889 struct data_editor *de = data;
1890 gint max_rows, max_columns;
1892 GtkSheetRange range;
1893 PsppireDataStore *ds;
1894 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
1897 data_sheet_set_clip (data_sheet);
1900 /* Now blank all the cells */
1901 gtk_sheet_get_selected_range (data_sheet, &range);
1903 ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1906 /* If nothing selected, then use active cell */
1907 if ( range.row0 < 0 || range.col0 < 0 )
1910 gtk_sheet_get_active_cell (data_sheet, &row, &col);
1912 range.row0 = range.rowi = row;
1913 range.col0 = range.coli = col;
1916 /* The sheet range can include cells that do not include data.
1917 Exclude them from the range. */
1918 max_rows = psppire_data_store_get_case_count (ds);
1919 if (range.rowi >= max_rows)
1923 range.rowi = max_rows - 1;
1926 max_columns = dict_get_var_cnt (ds->dict->dict);
1927 if (range.coli >= max_columns)
1929 if (max_columns == 0)
1931 range.coli = max_columns - 1;
1934 g_return_if_fail (range.rowi >= range.row0);
1935 g_return_if_fail (range.row0 >= 0);
1936 g_return_if_fail (range.coli >= range.col0);
1937 g_return_if_fail (range.col0 >= 0);
1940 for (r = range.row0; r <= range.rowi ; ++r )
1944 for (c = range.col0 ; c <= range.coli; ++c)
1946 psppire_data_store_set_string (ds, "", r, c);
1950 /* and remove the selection */
1951 gtk_sheet_unselect_range (data_sheet);