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 "descriptives-dialog.h"
43 #include "dict-display.h"
44 #include "clipboard.h"
46 #define _(msgid) gettext (msgid)
47 #define N_(msgid) msgid
49 #include "data-editor.h"
50 #include "syntax-editor.h"
51 #include <language/syntax-string-source.h>
52 #include <language/command.h>
53 #include <libpspp/syntax-gen.h>
54 #include "window-manager.h"
56 #include "psppire-data-store.h"
57 #include "psppire-var-store.h"
59 static void on_edit_copy (GtkMenuItem *, gpointer);
60 static void on_edit_cut (GtkMenuItem *, gpointer);
61 static void on_edit_paste (GtkAction *a, gpointer data);
64 static void create_data_sheet_variable_popup_menu (struct data_editor *);
65 static void create_data_sheet_cases_popup_menu (struct data_editor *);
67 static void popup_variable_menu (GtkSheet *, gint,
68 GdkEventButton *, gpointer data);
70 static void popup_cases_menu (GtkSheet *, gint,
71 GdkEventButton *, gpointer data);
73 /* Update the data_ref_entry with the reference of the active cell */
74 static gint update_data_ref_entry (const GtkSheet *sheet,
75 gint row, gint col, gpointer data);
77 static void register_data_editor_actions (struct data_editor *de);
79 static void insert_variable (GtkAction *, gpointer data);
80 static void insert_case (GtkAction *a, gpointer data);
81 static void delete_cases (GtkAction *a, gpointer data);
82 static void delete_variables (GtkAction *a, gpointer data);
84 static void toggle_value_labels (GtkToggleAction *a, gpointer data);
86 /* Switch between the VAR SHEET and the DATA SHEET */
88 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
89 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
92 /* Callback for when the dictionary changes properties*/
93 static void on_weight_change (GObject *, gint, gpointer);
94 static void on_filter_change (GObject *, gint, gpointer);
95 static void on_split_change (PsppireDict *, gpointer);
97 static void on_switch_sheet (GtkNotebook *notebook,
98 GtkNotebookPage *page,
102 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
104 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
106 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
108 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
110 static void fonts_activate (GtkMenuItem *, gpointer);
112 static void file_quit (GtkCheckMenuItem *, gpointer );
115 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
117 struct data_editor *de = data;
119 gtk_action_set_visible (de->delete_cases, var != -1);
124 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
126 struct data_editor *de = data;
128 gtk_action_set_visible (de->delete_variables, var != -1);
133 /* Run the EXECUTE command. */
135 execute (GtkMenuItem *mi, gpointer data)
137 struct getl_interface *sss = create_syntax_string_source ("EXECUTE.");
139 execute_syntax (sss);
143 transformation_change_callback (bool transformations_pending,
146 struct data_editor *de = data;
147 GtkWidget *menuitem =
148 get_widget_assert (de->xml, "transform_run-pending");
149 GtkWidget *status_label =
150 get_widget_assert (de->xml, "case-counter-area");
152 gtk_widget_set_sensitive (menuitem, transformations_pending);
155 if ( transformations_pending)
156 gtk_label_set_text (GTK_LABEL (status_label),
157 _("Transformations Pending"));
159 gtk_label_set_text (GTK_LABEL (status_label), "");
163 static void open_data_file (const gchar *, struct data_editor *);
166 /* Puts FILE_NAME into the recent list.
167 If it's already in the list, it moves it to the top
170 add_most_recent (const char *file_name)
172 #if RECENT_LISTS_AVAILABLE
174 GtkRecentManager *manager = gtk_recent_manager_get_default();
175 gchar *uri = g_filename_to_uri (file_name, NULL, NULL);
177 gtk_recent_manager_remove_item (manager, uri, NULL);
179 if ( ! gtk_recent_manager_add_item (manager, uri))
180 g_warning ("Could not add item %s to recent list\n",uri);
188 #if RECENT_LISTS_AVAILABLE
191 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
194 struct data_editor *de = user_data;
197 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
199 file = g_filename_from_uri (uri, NULL, NULL);
203 open_data_file (file, de);
209 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
213 struct syntax_editor *se ;
216 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
218 file = g_filename_from_uri (uri, NULL, NULL);
222 se = (struct syntax_editor *)
223 window_create (WINDOW_SYNTAX, file);
225 load_editor_from_file (se, file, NULL);
233 datum_entry_activate (GtkEntry *entry, gpointer data)
236 GtkSheet *data_sheet = GTK_SHEET (data);
237 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
239 const char *text = gtk_entry_get_text (entry);
241 gtk_sheet_get_active_cell (data_sheet, &row, &column);
243 if ( row == -1 || column == -1)
246 psppire_data_store_set_string (store, text, row, column);
250 /* Update the Edit->Paste menuitem
251 If PAGE is not -1 , then it should be set to the current page of
252 the data editors notebook widget.
253 If -1, then it'll be queried.
256 update_paste_menuitem (struct data_editor *de, gint page)
258 GtkWidget * edit_paste = get_widget_assert (de->xml, "edit_paste");
259 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
260 GtkSheet * data_sheet ;
264 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
267 if ( PAGE_VAR_SHEET == page )
269 /* We don't yet support pasting to the var sheet */
270 gtk_widget_set_sensitive (edit_paste, FALSE);
274 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
276 gtk_sheet_get_active_cell (data_sheet, &row, &column);
278 if ( row < 0 || column < 0 )
279 gtk_widget_set_sensitive (edit_paste, FALSE);
281 gtk_widget_set_sensitive (edit_paste, TRUE);
284 /* Update the Edit->Cut and Edit->Copy menuitems
285 If PAGE is not -1 , then it should be set to the current page of
286 the data editors notebook widget.
287 If -1, then it'll be queried.
290 update_cut_copy_menuitem (struct data_editor *de, gint page)
292 GtkWidget * edit_copy = get_widget_assert (de->xml, "edit_copy");
293 GtkWidget * edit_cut = get_widget_assert (de->xml, "edit_cut");
294 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
295 GtkSheet * data_sheet ;
299 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
302 if ( PAGE_VAR_SHEET == page )
304 /* We don't yet support copying from the var sheet */
305 gtk_widget_set_sensitive (edit_copy, FALSE);
306 gtk_widget_set_sensitive (edit_cut, FALSE);
310 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
312 gtk_sheet_get_active_cell (data_sheet, &row, &column);
314 if ( row < 0 || column < 0 )
316 gtk_widget_set_sensitive (edit_copy, FALSE);
317 gtk_widget_set_sensitive (edit_cut, FALSE);
321 gtk_widget_set_sensitive (edit_copy, TRUE);
322 gtk_widget_set_sensitive (edit_cut, TRUE);
326 /* Callback for when the datasheet's active cell becomes active/inactive */
328 on_data_sheet_activate_change (GtkSheet *sheet,
329 gint row, gint column, gpointer data)
331 struct data_editor *de = data;
333 update_paste_menuitem (de, -1);
334 update_cut_copy_menuitem (de, -1);
339 extern struct dataset *the_dataset;
342 Create a new data editor.
345 new_data_editor (void)
347 struct data_editor *de ;
348 struct editor_window *e;
349 GtkSheet *var_sheet ;
350 GtkSheet *data_sheet ;
352 GtkWidget *datum_entry;
354 de = g_malloc0 (sizeof (*de));
356 e = (struct editor_window *) de;
358 de->xml = XML_NEW ("data-editor.glade");
361 dataset_add_transform_change_callback (the_dataset,
362 transformation_change_callback,
365 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
366 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
369 g_signal_connect (G_OBJECT (data_sheet), "activate",
370 G_CALLBACK (on_data_sheet_activate_change), de);
372 g_signal_connect (G_OBJECT (data_sheet), "deactivate",
373 G_CALLBACK (on_data_sheet_activate_change), de);
376 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
378 g_assert(vs); /* Traps a possible bug in win32 build */
380 g_signal_connect (G_OBJECT (data_sheet), "activate",
381 G_CALLBACK (update_data_ref_entry),
384 datum_entry = get_widget_assert (de->xml, "datum_entry");
386 g_signal_connect (G_OBJECT (datum_entry), "activate",
387 G_CALLBACK (datum_entry_activate),
390 g_signal_connect (vs->dict, "weight-changed",
391 G_CALLBACK (on_weight_change),
394 g_signal_connect (vs->dict, "filter-changed",
395 G_CALLBACK (on_filter_change),
398 g_signal_connect (vs->dict, "split-changed",
399 G_CALLBACK (on_split_change),
402 connect_help (de->xml);
406 g_signal_connect (get_widget_assert (de->xml, "edit_copy"),
408 G_CALLBACK (on_edit_copy), de);
410 g_signal_connect (get_widget_assert (de->xml, "edit_cut"),
412 G_CALLBACK (on_edit_cut), de);
415 register_data_editor_actions (de);
417 de->toggle_value_labels =
418 gtk_toggle_action_new ("toggle-value-labels",
420 _("Show/hide value labels"),
421 "pspp-value-labels");
423 g_signal_connect (de->toggle_value_labels, "activate",
424 G_CALLBACK (toggle_value_labels), de);
427 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
428 get_widget_assert (de->xml,
429 "togglebutton-value-labels"));
432 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
433 get_widget_assert (de->xml,
434 "view_value-labels"));
437 gtk_action_new ("clear-cases",
439 _("Delete the cases at the selected position(s)"),
442 g_signal_connect (de->delete_cases, "activate",
443 G_CALLBACK (delete_cases), de);
445 gtk_action_connect_proxy (de->delete_cases,
446 get_widget_assert (de->xml, "edit_clear-cases"));
448 g_signal_connect (get_widget_assert (de->xml, "edit_paste"), "activate",
449 G_CALLBACK (on_edit_paste), de);
451 gtk_action_set_visible (de->delete_cases, FALSE);
453 de->delete_variables =
454 gtk_action_new ("clear-variables",
456 _("Delete the variables at the selected position(s)"),
457 "pspp-clear-variables");
459 g_signal_connect (de->delete_variables, "activate",
460 G_CALLBACK (delete_variables), de);
462 gtk_action_connect_proxy (de->delete_variables,
463 get_widget_assert (de->xml, "edit_clear-variables")
466 gtk_action_set_visible (de->delete_variables, FALSE);
468 de->insert_variable =
469 gtk_action_new ("insert-variable",
470 _("Insert Variable"),
471 _("Create a new variable at the current position"),
472 "pspp-insert-variable");
474 g_signal_connect (de->insert_variable, "activate",
475 G_CALLBACK (insert_variable), de);
478 gtk_action_connect_proxy (de->insert_variable,
479 get_widget_assert (de->xml, "button-insert-variable")
482 gtk_action_connect_proxy (de->insert_variable,
483 get_widget_assert (de->xml, "edit_insert-variable")
488 gtk_action_new ("insert-case",
490 _("Create a new case at the current position"),
493 g_signal_connect (de->insert_case, "activate",
494 G_CALLBACK (insert_case), de);
497 gtk_action_connect_proxy (de->insert_case,
498 get_widget_assert (de->xml, "button-insert-case")
502 gtk_action_connect_proxy (de->insert_case,
503 get_widget_assert (de->xml, "edit_insert-case")
508 de->invoke_goto_dialog =
509 gtk_action_new ("goto-case-dialog",
511 _("Jump to a Case in the Data Sheet"),
515 gtk_action_connect_proxy (de->invoke_goto_dialog,
516 get_widget_assert (de->xml, "button-goto-case")
519 gtk_action_connect_proxy (de->invoke_goto_dialog,
520 get_widget_assert (de->xml, "edit_goto-case")
524 g_signal_connect (de->invoke_goto_dialog, "activate",
525 G_CALLBACK (goto_case_dialog), de);
528 de->invoke_weight_cases_dialog =
529 gtk_action_new ("weight-cases-dialog",
531 _("Weight cases by variable"),
532 "pspp-weight-cases");
534 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
535 G_CALLBACK (weight_cases_dialog), de);
538 de->invoke_transpose_dialog =
539 gtk_action_new ("transpose-dialog",
541 _("Transpose the cases with the variables"),
545 g_signal_connect (de->invoke_transpose_dialog, "activate",
546 G_CALLBACK (transpose_dialog), de);
550 de->invoke_split_file_dialog =
551 gtk_action_new ("split-file-dialog",
553 _("Split the active file"),
556 g_signal_connect (de->invoke_split_file_dialog, "activate",
557 G_CALLBACK (split_file_dialog), de);
561 de->invoke_sort_cases_dialog =
562 gtk_action_new ("sort-cases-dialog",
564 _("Sort cases in the active file"),
567 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
568 G_CALLBACK (sort_cases_dialog), de);
570 de->invoke_select_cases_dialog =
571 gtk_action_new ("select-cases-dialog",
573 _("Select cases from the active file"),
574 "pspp-select-cases");
576 g_signal_connect (de->invoke_select_cases_dialog, "activate",
577 G_CALLBACK (select_cases_dialog), de);
580 de->invoke_compute_dialog =
581 gtk_action_new ("compute-dialog",
583 _("Compute new values for a variable"),
586 g_signal_connect (de->invoke_compute_dialog, "activate",
587 G_CALLBACK (compute_dialog), de);
589 de->invoke_comments_dialog =
590 gtk_action_new ("commments-dialog",
591 _("Data File Comments"),
592 _("Commentary text for the data file"),
595 g_signal_connect (de->invoke_comments_dialog, "activate",
596 G_CALLBACK (comments_dialog), de);
598 de->invoke_find_dialog =
599 gtk_action_new ("find-dialog",
604 g_signal_connect (de->invoke_find_dialog, "activate",
605 G_CALLBACK (find_dialog), de);
608 de->invoke_variable_info_dialog =
609 gtk_action_new ("variable-info-dialog",
611 _("Jump to Variable"),
612 "pspp-goto-variable");
614 g_signal_connect (de->invoke_variable_info_dialog, "activate",
615 G_CALLBACK (variable_info_dialog), de);
617 de->invoke_descriptives_dialog =
618 gtk_action_new ("descriptives-dialog",
620 _("Calculate descriptive statistics (mean, variance, ...)"),
621 "pspp-descriptives");
623 g_signal_connect (de->invoke_descriptives_dialog, "activate",
624 G_CALLBACK (descriptives_dialog), de);
626 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
628 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
630 G_CALLBACK (gtk_action_activate),
631 de->action_data_new);
633 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
635 G_CALLBACK (gtk_action_activate),
636 de->action_data_open);
639 #if RECENT_LISTS_AVAILABLE
641 GtkRecentManager *rm = gtk_recent_manager_get_default ();
642 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
643 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
644 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
646 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
648 GtkRecentFilter *filter = gtk_recent_filter_new ();
650 gtk_widget_show (recent_data);
651 gtk_widget_show (recent_files);
652 gtk_widget_show (recent_separator);
654 gtk_recent_filter_add_pattern (filter, "*.sav");
655 gtk_recent_filter_add_pattern (filter, "*.SAV");
657 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
659 gtk_widget_set_sensitive (recent_data, TRUE);
660 g_signal_connect (menu, "selection-done",
661 G_CALLBACK (on_recent_data_select), de);
663 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
666 filter = gtk_recent_filter_new ();
667 menu = gtk_recent_chooser_menu_new_for_manager (rm);
669 gtk_recent_filter_add_pattern (filter, "*.sps");
670 gtk_recent_filter_add_pattern (filter, "*.SPS");
672 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
674 gtk_widget_set_sensitive (recent_files, TRUE);
675 g_signal_connect (menu, "selection-done",
676 G_CALLBACK (on_recent_files_select), de);
678 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
682 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
684 G_CALLBACK (new_syntax_window),
687 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
689 G_CALLBACK (open_syntax_window),
692 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
694 G_CALLBACK (gtk_action_activate),
695 de->action_data_save);
697 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
699 G_CALLBACK (gtk_action_activate),
700 de->action_data_save_as);
702 gtk_action_connect_proxy (de->invoke_find_dialog,
703 get_widget_assert (de->xml, "edit_find")
706 gtk_action_connect_proxy (de->invoke_find_dialog,
707 get_widget_assert (de->xml, "button-find")
710 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
711 get_widget_assert (de->xml, "data_weight-cases")
714 gtk_action_connect_proxy (de->invoke_transpose_dialog,
715 get_widget_assert (de->xml, "data_transpose")
718 gtk_action_connect_proxy (de->invoke_split_file_dialog,
719 get_widget_assert (de->xml, "data_split-file")
722 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
723 get_widget_assert (de->xml, "data_sort-cases")
726 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
727 get_widget_assert (de->xml, "data_select-cases")
730 gtk_action_connect_proxy (de->invoke_compute_dialog,
731 get_widget_assert (de->xml, "transform_compute")
734 gtk_action_connect_proxy (de->invoke_comments_dialog,
735 get_widget_assert (de->xml, "utilities_comments")
738 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
739 get_widget_assert (de->xml, "utilities_variables")
742 gtk_action_connect_proxy (de->invoke_descriptives_dialog,
743 get_widget_assert (de->xml, "analyze_descriptives")
746 g_signal_connect (get_widget_assert (de->xml,"help_about"),
748 G_CALLBACK (about_new),
752 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
754 G_CALLBACK (reference_manual),
757 g_signal_connect (data_sheet,
758 "double-click-column",
759 G_CALLBACK (click2column),
762 g_signal_connect (data_sheet,
764 G_CALLBACK (enable_delete_variables),
767 g_signal_connect (data_sheet,
769 G_CALLBACK (enable_delete_cases),
773 g_signal_connect (var_sheet,
775 GTK_SIGNAL_FUNC (click2row),
778 g_signal_connect_after (var_sheet,
780 G_CALLBACK (enable_delete_variables),
783 g_signal_connect (get_widget_assert (de->xml, "notebook"),
785 G_CALLBACK (on_switch_sheet), de);
788 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
790 G_CALLBACK (status_bar_activate), de);
793 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
795 G_CALLBACK (grid_lines_activate), de);
799 g_signal_connect (get_widget_assert (de->xml, "view_data"),
801 G_CALLBACK (data_sheet_activate), de);
803 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
805 G_CALLBACK (variable_sheet_activate), de);
809 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
811 G_CALLBACK (fonts_activate), de);
816 gtk_action_connect_proxy (de->action_data_open,
817 get_widget_assert (de->xml, "button-open")
820 gtk_action_connect_proxy (de->action_data_save,
821 get_widget_assert (de->xml, "button-save")
824 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
825 get_widget_assert (de->xml, "button-goto-variable")
828 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
829 get_widget_assert (de->xml, "button-weight-cases")
832 gtk_action_connect_proxy (de->invoke_split_file_dialog,
833 get_widget_assert (de->xml, "button-split-file")
836 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
837 get_widget_assert (de->xml, "button-select-cases")
841 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
843 G_CALLBACK (file_quit), de);
845 g_signal_connect (get_widget_assert (de->xml, "transform_run-pending"),
847 G_CALLBACK (execute), de);
850 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
852 G_CALLBACK (minimise_all_windows), NULL);
855 create_data_sheet_variable_popup_menu (de);
856 create_data_sheet_cases_popup_menu (de);
858 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
859 G_CALLBACK (popup_variable_menu), de);
861 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
862 G_CALLBACK (popup_cases_menu), de);
868 /* Callback which occurs when the var sheet's row title
869 button is double clicked */
871 click2row (GtkWidget *w, gint row, gpointer data)
873 struct data_editor *de = data;
874 GtkSheetRange visible_range;
876 gint current_row, current_column;
878 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
880 data_editor_select_sheet (de, PAGE_DATA_SHEET);
882 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
883 ¤t_row, ¤t_column);
885 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
887 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
889 if ( row < visible_range.col0 || row > visible_range.coli)
891 gtk_sheet_moveto (GTK_SHEET (data_sheet),
892 current_row, row, 0, 0);
899 /* Callback which occurs when the data sheet's column title
902 click2column (GtkWidget *w, gint col, gpointer data)
904 struct data_editor *de = data;
906 gint current_row, current_column;
908 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
910 data_editor_select_sheet (de, PAGE_VAR_SHEET);
912 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
913 ¤t_row, ¤t_column);
915 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
922 new_data_window (GtkMenuItem *menuitem, gpointer parent)
924 window_create (WINDOW_DATA, NULL);
927 /* Callback for when the datasheet/varsheet is selected */
929 on_switch_sheet (GtkNotebook *notebook,
930 GtkNotebookPage *page,
934 struct data_editor *de = user_data;
936 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
937 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
942 gtk_widget_hide (view_variables);
943 gtk_widget_show (view_data);
944 gtk_action_set_sensitive (de->insert_variable, TRUE);
945 gtk_action_set_sensitive (de->insert_case, FALSE);
946 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
948 case PAGE_DATA_SHEET:
949 gtk_widget_show (view_variables);
950 gtk_widget_show (view_data);
951 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
952 gtk_action_set_sensitive (de->insert_case, TRUE);
955 g_assert_not_reached ();
959 update_paste_menuitem (de, page_num);
960 update_cut_copy_menuitem (de, page_num);
965 data_editor_select_sheet (struct data_editor *de, gint page)
967 gtk_notebook_set_current_page
969 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
976 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
978 struct data_editor *de = data;
979 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
981 if ( gtk_check_menu_item_get_active (menuitem) )
982 gtk_widget_show (statusbar);
984 gtk_widget_hide (statusbar);
989 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
991 struct data_editor *de = data;
992 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
994 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
998 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
1005 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1007 struct data_editor *de = data;
1009 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1014 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1016 struct data_editor *de = data;
1018 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1023 fonts_activate (GtkMenuItem *menuitem, gpointer data)
1025 struct data_editor *de = data;
1027 gtk_font_selection_dialog_new (_("Font Selection"));
1029 gtk_window_set_transient_for (GTK_WINDOW (dialog),
1030 GTK_WINDOW (get_widget_assert (de->xml,
1032 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
1034 GtkSheet *data_sheet =
1035 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1037 GtkSheet *var_sheet =
1038 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1040 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1041 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
1043 const gchar *font = gtk_font_selection_dialog_get_font_name
1044 (GTK_FONT_SELECTION_DIALOG (dialog));
1046 PangoFontDescription* font_desc =
1047 pango_font_description_from_string (font);
1049 psppire_var_store_set_font (vs, font_desc);
1050 psppire_data_store_set_font (ds, font_desc);
1053 gtk_widget_hide (dialog);
1058 /* Callback for the value labels action */
1060 toggle_value_labels (GtkToggleAction *ta, gpointer data)
1062 struct data_editor *de = data;
1064 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1066 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1069 psppire_data_store_show_labels (ds,
1070 gtk_toggle_action_get_active (ta));
1075 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
1077 /* FIXME: Need to be more intelligent here.
1078 Give the user the opportunity to save any unsaved data.
1084 delete_cases (GtkAction *action, gpointer data)
1086 struct data_editor *de = data;
1087 GtkSheet *data_sheet =
1088 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1090 GtkSheetRange range;
1092 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
1093 (gtk_sheet_get_model (data_sheet) );
1096 /* This shouldn't be able to happen, because the action
1097 should be disabled */
1098 g_return_if_fail (gtk_sheet_get_state (data_sheet)
1099 == GTK_SHEET_ROW_SELECTED );
1101 gtk_sheet_get_selected_range (data_sheet, &range);
1103 gtk_sheet_unselect_range (data_sheet);
1105 psppire_data_store_delete_cases (data_store, range.row0,
1106 1 + range.rowi - range.row0);
1111 delete_variables (GtkAction *a, gpointer data)
1113 struct data_editor *de = data;
1114 GtkSheetRange range;
1116 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
1119 const gint page = gtk_notebook_get_current_page (notebook);
1121 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
1122 (page == PAGE_VAR_SHEET) ?
1127 gtk_sheet_get_selected_range (sheet, &range);
1131 case PAGE_VAR_SHEET:
1133 PsppireVarStore *vs =
1134 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
1136 psppire_dict_delete_variables (vs->dict,
1143 case PAGE_DATA_SHEET:
1145 PsppireDataStore *ds =
1146 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1148 psppire_dict_delete_variables (ds->dict,
1157 gtk_sheet_unselect_range (sheet);
1161 insert_case (GtkAction *action, gpointer data)
1164 struct data_editor *de = data;
1166 GtkSheet *data_sheet =
1167 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1169 PsppireDataStore *ds = PSPPIRE_DATA_STORE
1170 (gtk_sheet_get_model (data_sheet) );
1173 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
1175 if (current_row < 0) current_row = 0;
1177 psppire_data_store_insert_new_case (ds, current_row);
1180 /* Insert a new variable before the current row in the variable sheet,
1181 or before the current column in the data sheet, whichever is selected */
1183 insert_variable (GtkAction *action, gpointer data)
1185 struct data_editor *de = data;
1188 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
1190 GtkSheet *var_sheet =
1191 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1193 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1194 (gtk_sheet_get_model (var_sheet) );
1196 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
1198 case PAGE_VAR_SHEET:
1199 posn = var_sheet->active_cell.row;
1201 case PAGE_DATA_SHEET:
1203 GtkSheet *data_sheet =
1204 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1206 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
1207 posn = data_sheet->range.col0;
1209 posn = data_sheet->active_cell.col;
1213 g_assert_not_reached ();
1216 if ( posn == -1 ) posn = 0;
1218 psppire_dict_insert_variable (vs->dict, posn, NULL);
1221 /* Callback for when the dictionary changes its split variables */
1223 on_split_change (PsppireDict *dict, gpointer data)
1225 struct data_editor *de = data;
1227 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1229 GtkWidget *split_status_area =
1230 get_widget_assert (de->xml, "split-file-status-area");
1232 if ( n_split_vars == 0 )
1234 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1240 const struct variable *const * split_vars =
1241 dict_get_split_vars (dict->dict);
1243 text = g_string_new (_("Split by "));
1245 for (i = 0 ; i < n_split_vars - 1; ++i )
1247 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1249 g_string_append (text, var_get_name (split_vars[i]));
1251 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1253 g_string_free (text, TRUE);
1258 /* Callback for when the dictionary changes its filter variable */
1260 on_filter_change (GObject *o, gint filter_index, gpointer data)
1262 struct data_editor *de = data;
1263 GtkWidget *filter_status_area =
1264 get_widget_assert (de->xml, "filter-use-status-area");
1266 if ( filter_index == -1 )
1268 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1272 GtkSheet *var_sheet =
1273 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1275 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1276 (gtk_sheet_get_model (var_sheet) );
1278 struct variable *var = psppire_dict_get_variable (vs->dict,
1281 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1283 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1289 /* Callback for when the dictionary changes its weights */
1291 on_weight_change (GObject *o, gint weight_index, gpointer data)
1293 struct data_editor *de = data;
1294 GtkWidget *weight_status_area =
1295 get_widget_assert (de->xml, "weight-status-area");
1297 if ( weight_index == -1 )
1299 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1303 GtkSheet *var_sheet =
1304 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1306 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1307 (gtk_sheet_get_model (var_sheet) );
1309 struct variable *var = psppire_dict_get_variable (vs->dict,
1312 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1314 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1323 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1324 static void new_file (GtkAction *, struct editor_window *de);
1325 static void open_data_dialog (GtkAction *, struct data_editor *de);
1326 static void data_save (GtkAction *action, struct data_editor *e);
1329 /* Create the GtkActions and connect to their signals */
1331 register_data_editor_actions (struct data_editor *de)
1333 de->action_data_open =
1334 gtk_action_new ("data-open-dialog",
1336 _("Open a data file"),
1339 g_signal_connect (de->action_data_open, "activate",
1340 G_CALLBACK (open_data_dialog), de);
1343 de->action_data_save = gtk_action_new ("data-save",
1345 _("Save data to file"),
1348 g_signal_connect (de->action_data_save, "activate",
1349 G_CALLBACK (data_save), de);
1353 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1355 _("Save data to file"),
1358 g_signal_connect (de->action_data_save_as, "activate",
1359 G_CALLBACK (data_save_as_dialog), de);
1361 de->action_data_new =
1362 gtk_action_new ("data-new",
1367 g_signal_connect (de->action_data_new, "activate",
1368 G_CALLBACK (new_file), de);
1371 /* Returns true if NAME has a suffix which might denote a PSPP file */
1373 name_has_suffix (const gchar *name)
1375 if ( g_str_has_suffix (name, ".sav"))
1377 if ( g_str_has_suffix (name, ".SAV"))
1379 if ( g_str_has_suffix (name, ".por"))
1381 if ( g_str_has_suffix (name, ".POR"))
1387 /* Append SUFFIX to the filename of DE */
1389 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1391 if ( ! name_has_suffix (de->file_name))
1393 gchar *s = de->file_name;
1394 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1399 /* Save DE to file */
1401 save_file (struct data_editor *de)
1403 struct getl_interface *sss;
1404 struct string file_name ;
1406 g_assert (de->file_name);
1408 ds_init_cstr (&file_name, de->file_name);
1409 gen_quoted_string (&file_name);
1411 if ( de->save_as_portable )
1413 append_filename_suffix (de, ".por");
1414 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1415 ds_cstr (&file_name));
1419 append_filename_suffix (de, ".sav");
1420 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1421 ds_cstr (&file_name));
1424 ds_destroy (&file_name);
1426 execute_syntax (sss);
1430 /* Callback for data_save action.
1431 If there's an existing file name, then just save,
1432 otherwise prompt for a file name, then save */
1434 data_save (GtkAction *action, struct data_editor *de)
1439 data_save_as_dialog (action, de);
1443 /* Callback for data_save_as action. Prompt for a filename and save */
1445 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1447 struct editor_window *e = (struct editor_window *) de;
1449 GtkWidget *button_sys;
1451 gtk_file_chooser_dialog_new (_("Save"),
1452 GTK_WINDOW (e->window),
1453 GTK_FILE_CHOOSER_ACTION_SAVE,
1454 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1455 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1458 GtkFileFilter *filter = gtk_file_filter_new ();
1459 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1460 gtk_file_filter_add_pattern (filter, "*.sav");
1461 gtk_file_filter_add_pattern (filter, "*.SAV");
1462 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1464 filter = gtk_file_filter_new ();
1465 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1466 gtk_file_filter_add_pattern (filter, "*.por");
1467 gtk_file_filter_add_pattern (filter, "*.POR");
1468 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1470 filter = gtk_file_filter_new ();
1471 gtk_file_filter_set_name (filter, _("All Files"));
1472 gtk_file_filter_add_pattern (filter, "*");
1473 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1476 GtkWidget *button_por;
1477 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1479 gtk_radio_button_new_with_label (NULL, _("System File"));
1482 gtk_radio_button_new_with_label
1483 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1484 _("Portable File"));
1486 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1487 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1489 gtk_widget_show_all (vbox);
1491 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1494 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1496 case GTK_RESPONSE_ACCEPT:
1498 g_free (de->file_name);
1501 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1503 de->save_as_portable =
1504 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1508 window_set_name_from_filename (e, de->file_name);
1515 gtk_widget_destroy (dialog);
1519 /* Callback for data_new action.
1520 Performs the NEW FILE command */
1522 new_file (GtkAction *action, struct editor_window *e)
1524 struct data_editor *de = (struct data_editor *) e;
1526 struct getl_interface *sss =
1527 create_syntax_string_source ("NEW FILE.");
1529 execute_syntax (sss);
1531 g_free (de->file_name);
1532 de->file_name = NULL;
1534 default_window_name (e);
1539 open_data_file (const gchar *file_name, struct data_editor *de)
1541 struct getl_interface *sss;
1542 struct string filename;
1544 ds_init_cstr (&filename, file_name);
1546 gen_quoted_string (&filename);
1548 sss = create_syntax_string_source ("GET FILE=%s.",
1549 ds_cstr (&filename));
1550 ds_destroy (&filename);
1552 if (execute_syntax (sss) )
1554 window_set_name_from_filename ((struct editor_window *) de, file_name);
1555 add_most_recent (file_name);
1561 /* Callback for the data_open action.
1562 Prompts for a filename and opens it */
1564 open_data_dialog (GtkAction *action, struct data_editor *de)
1566 struct editor_window *e = (struct editor_window *) de;
1569 gtk_file_chooser_dialog_new (_("Open"),
1570 GTK_WINDOW (e->window),
1571 GTK_FILE_CHOOSER_ACTION_OPEN,
1572 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1573 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1576 GtkFileFilter *filter = gtk_file_filter_new ();
1577 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1578 gtk_file_filter_add_pattern (filter, "*.sav");
1579 gtk_file_filter_add_pattern (filter, "*.SAV");
1580 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1582 filter = gtk_file_filter_new ();
1583 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1584 gtk_file_filter_add_pattern (filter, "*.por");
1585 gtk_file_filter_add_pattern (filter, "*.POR");
1586 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1588 filter = gtk_file_filter_new ();
1589 gtk_file_filter_set_name (filter, _("All Files"));
1590 gtk_file_filter_add_pattern (filter, "*");
1591 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1596 gchar *dir_name = g_path_get_dirname (de->file_name);
1597 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1602 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1604 case GTK_RESPONSE_ACCEPT:
1606 g_free (de->file_name);
1608 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1610 open_data_file (de->file_name, de);
1617 gtk_widget_destroy (dialog);
1622 /* Update the data_ref_entry with the reference of the active cell */
1624 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1626 GladeXML *data_editor_xml = data;
1628 PsppireDataStore *data_store =
1629 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1631 g_return_val_if_fail (data_editor_xml, FALSE);
1635 const struct variable *var =
1636 psppire_dict_get_variable (data_store->dict, col);
1638 /* The entry where the reference to the current cell is displayed */
1639 GtkEntry *cell_ref_entry =
1640 GTK_ENTRY (get_widget_assert (data_editor_xml,
1642 GtkEntry *datum_entry =
1643 GTK_ENTRY (get_widget_assert (data_editor_xml,
1648 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1649 var_get_name (var));
1651 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1655 gtk_entry_set_text (cell_ref_entry, s);
1660 gtk_entry_set_text (cell_ref_entry, "");
1666 psppire_data_store_get_string (data_store, row,
1667 var_get_dict_index(var));
1670 gtk_entry_set_text (datum_entry, text);
1675 gtk_entry_set_text (datum_entry, "");
1686 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1688 GString *string = g_string_new ("SORT CASES BY ");
1690 const struct variable *v =
1691 psppire_dict_get_variable (ds->dict, var);
1693 g_string_append_printf (string, "%s", var_get_name (v));
1696 g_string_append (string, " (D)");
1698 g_string_append (string, ".");
1700 execute_syntax (create_syntax_string_source (string->str));
1702 g_string_free (string, TRUE);
1707 sort_up (GtkMenuItem *item, gpointer data)
1709 GtkSheet *sheet = data;
1710 GtkSheetRange range;
1711 gtk_sheet_get_selected_range (sheet, &range);
1713 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1719 sort_down (GtkMenuItem *item, gpointer data)
1721 GtkSheet *sheet = data;
1722 GtkSheetRange range;
1723 gtk_sheet_get_selected_range (sheet, &range);
1725 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1733 create_data_sheet_variable_popup_menu (struct data_editor *de)
1735 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1736 GtkWidget *menu = gtk_menu_new ();
1738 GtkWidget *sort_ascending =
1739 gtk_menu_item_new_with_label (_("Sort Ascending"));
1741 GtkWidget *sort_descending =
1742 gtk_menu_item_new_with_label (_("Sort Descending"));
1745 GtkWidget *insert_variable =
1746 gtk_menu_item_new_with_label (_("Insert Variable"));
1748 GtkWidget *clear_variable =
1749 gtk_menu_item_new_with_label (_("Clear"));
1752 gtk_action_connect_proxy (de->insert_variable,
1756 gtk_action_connect_proxy (de->delete_variables,
1760 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1763 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1764 gtk_separator_menu_item_new ());
1767 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1770 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1771 gtk_separator_menu_item_new ());
1774 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1775 G_CALLBACK (sort_up), sheet);
1777 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1780 g_signal_connect (G_OBJECT (sort_descending), "activate",
1781 G_CALLBACK (sort_down), sheet);
1784 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1786 gtk_widget_show_all (menu);
1789 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1794 create_data_sheet_cases_popup_menu (struct data_editor *de)
1796 GtkWidget *menu = gtk_menu_new ();
1798 GtkWidget *insert_case =
1799 gtk_menu_item_new_with_label (_("Insert Case"));
1801 GtkWidget *delete_case =
1802 gtk_menu_item_new_with_label (_("Clear"));
1805 gtk_action_connect_proxy (de->insert_case,
1809 gtk_action_connect_proxy (de->delete_cases,
1813 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
1816 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1817 gtk_separator_menu_item_new ());
1820 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
1823 gtk_widget_show_all (menu);
1826 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
1831 popup_variable_menu (GtkSheet *sheet, gint column,
1832 GdkEventButton *event, gpointer data)
1834 struct data_editor *de = data;
1836 PsppireDataStore *data_store =
1837 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1839 const struct variable *v =
1840 psppire_dict_get_variable (data_store->dict, column);
1842 if ( v && event->button == 3)
1845 gtk_sheet_select_column (sheet, column);
1847 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
1848 NULL, NULL, NULL, NULL,
1849 event->button, event->time);
1855 popup_cases_menu (GtkSheet *sheet, gint row,
1856 GdkEventButton *event, gpointer data)
1858 struct data_editor *de = data;
1860 PsppireDataStore *data_store =
1861 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1863 if ( row <= psppire_data_store_get_case_count (data_store) &&
1866 gtk_sheet_select_row (sheet, row);
1868 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
1869 NULL, NULL, NULL, NULL,
1870 event->button, event->time);
1876 on_edit_paste (GtkAction *a, gpointer data)
1878 GtkClipboard *clipboard = gtk_clipboard_get (GDK_SELECTION_CLIPBOARD);
1880 gtk_clipboard_request_contents (clipboard,
1881 gdk_atom_intern ("UTF8_STRING", TRUE),
1882 data_sheet_contents_received_callback,
1888 on_edit_copy (GtkMenuItem *m, gpointer data)
1890 struct data_editor *de = data;
1892 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
1895 data_sheet_set_clip (data_sheet);
1901 on_edit_cut (GtkMenuItem *m, gpointer data)
1903 struct data_editor *de = data;
1904 gint max_rows, max_columns;
1906 GtkSheetRange range;
1907 PsppireDataStore *ds;
1908 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
1911 data_sheet_set_clip (data_sheet);
1914 /* Now blank all the cells */
1915 gtk_sheet_get_selected_range (data_sheet, &range);
1917 ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1920 /* If nothing selected, then use active cell */
1921 if ( range.row0 < 0 || range.col0 < 0 )
1924 gtk_sheet_get_active_cell (data_sheet, &row, &col);
1926 range.row0 = range.rowi = row;
1927 range.col0 = range.coli = col;
1930 /* The sheet range can include cells that do not include data.
1931 Exclude them from the range. */
1932 max_rows = psppire_data_store_get_case_count (ds);
1933 if (range.rowi >= max_rows)
1937 range.rowi = max_rows - 1;
1940 max_columns = dict_get_var_cnt (ds->dict->dict);
1941 if (range.coli >= max_columns)
1943 if (max_columns == 0)
1945 range.coli = max_columns - 1;
1948 g_return_if_fail (range.rowi >= range.row0);
1949 g_return_if_fail (range.row0 >= 0);
1950 g_return_if_fail (range.coli >= range.col0);
1951 g_return_if_fail (range.col0 >= 0);
1954 for (r = range.row0; r <= range.rowi ; ++r )
1958 for (c = range.col0 ; c <= range.coli; ++c)
1960 psppire_data_store_set_string (ds, "", r, c);
1964 /* and remove the selection */
1965 gtk_sheet_unselect_range (data_sheet);