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 #include "t-test-independent-samples-dialog.h"
49 #define _(msgid) gettext (msgid)
50 #define N_(msgid) msgid
52 #include "data-editor.h"
53 #include "syntax-editor.h"
54 #include <language/syntax-string-source.h>
55 #include <language/command.h>
56 #include <libpspp/syntax-gen.h>
57 #include "window-manager.h"
59 #include "psppire-data-store.h"
60 #include "psppire-var-store.h"
62 static void on_edit_copy (GtkMenuItem *, gpointer);
63 static void on_edit_cut (GtkMenuItem *, gpointer);
64 static void on_edit_paste (GtkAction *a, gpointer data);
67 static void create_data_sheet_variable_popup_menu (struct data_editor *);
68 static void create_data_sheet_cases_popup_menu (struct data_editor *);
70 static void popup_variable_menu (GtkSheet *, gint,
71 GdkEventButton *, gpointer data);
73 static void popup_cases_menu (GtkSheet *, gint,
74 GdkEventButton *, gpointer data);
76 /* Update the data_ref_entry with the reference of the active cell */
77 static gint update_data_ref_entry (const GtkSheet *sheet,
78 gint row, gint col, gpointer data);
80 static void register_data_editor_actions (struct data_editor *de);
82 static void insert_variable (GtkAction *, gpointer data);
83 static void insert_case (GtkAction *a, gpointer data);
84 static void delete_cases (GtkAction *a, gpointer data);
85 static void delete_variables (GtkAction *a, gpointer data);
87 static void toggle_value_labels (GtkToggleAction *a, gpointer data);
89 /* Switch between the VAR SHEET and the DATA SHEET */
91 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
92 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
95 /* Callback for when the dictionary changes properties*/
96 static void on_weight_change (GObject *, gint, gpointer);
97 static void on_filter_change (GObject *, gint, gpointer);
98 static void on_split_change (PsppireDict *, gpointer);
100 static void on_switch_sheet (GtkNotebook *notebook,
101 GtkNotebookPage *page,
105 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
107 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
109 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
111 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
113 static void fonts_activate (GtkMenuItem *, gpointer);
115 static void file_quit (GtkCheckMenuItem *, gpointer );
118 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
120 struct data_editor *de = data;
122 gtk_action_set_visible (de->delete_cases, var != -1);
127 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
129 struct data_editor *de = data;
131 gtk_action_set_visible (de->delete_variables, var != -1);
136 /* Run the EXECUTE command. */
138 execute (GtkMenuItem *mi, gpointer data)
140 struct getl_interface *sss = create_syntax_string_source ("EXECUTE.");
142 execute_syntax (sss);
146 transformation_change_callback (bool transformations_pending,
149 struct data_editor *de = data;
150 GtkWidget *menuitem =
151 get_widget_assert (de->xml, "transform_run-pending");
152 GtkWidget *status_label =
153 get_widget_assert (de->xml, "case-counter-area");
155 gtk_widget_set_sensitive (menuitem, transformations_pending);
158 if ( transformations_pending)
159 gtk_label_set_text (GTK_LABEL (status_label),
160 _("Transformations Pending"));
162 gtk_label_set_text (GTK_LABEL (status_label), "");
166 static void open_data_file (const gchar *, struct data_editor *);
169 /* Puts FILE_NAME into the recent list.
170 If it's already in the list, it moves it to the top
173 add_most_recent (const char *file_name)
175 #if RECENT_LISTS_AVAILABLE
177 GtkRecentManager *manager = gtk_recent_manager_get_default();
178 gchar *uri = g_filename_to_uri (file_name, NULL, NULL);
180 gtk_recent_manager_remove_item (manager, uri, NULL);
182 if ( ! gtk_recent_manager_add_item (manager, uri))
183 g_warning ("Could not add item %s to recent list\n",uri);
191 #if RECENT_LISTS_AVAILABLE
194 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
197 struct data_editor *de = user_data;
200 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
202 file = g_filename_from_uri (uri, NULL, NULL);
206 open_data_file (file, de);
212 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
216 struct syntax_editor *se ;
219 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
221 file = g_filename_from_uri (uri, NULL, NULL);
225 se = (struct syntax_editor *)
226 window_create (WINDOW_SYNTAX, file);
228 load_editor_from_file (se, file, NULL);
236 datum_entry_activate (GtkEntry *entry, gpointer data)
239 GtkSheet *data_sheet = GTK_SHEET (data);
240 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
242 const char *text = gtk_entry_get_text (entry);
244 gtk_sheet_get_active_cell (data_sheet, &row, &column);
246 if ( row == -1 || column == -1)
249 psppire_data_store_set_string (store, text, row, column);
253 /* Update the Edit->Paste menuitem
254 If PAGE is not -1 , then it should be set to the current page of
255 the data editors notebook widget.
256 If -1, then it'll be queried.
259 update_paste_menuitem (struct data_editor *de, gint page)
261 GtkWidget * edit_paste = get_widget_assert (de->xml, "edit_paste");
262 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
263 GtkSheet * data_sheet ;
267 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
270 if ( PAGE_VAR_SHEET == page )
272 /* We don't yet support pasting to the var sheet */
273 gtk_widget_set_sensitive (edit_paste, FALSE);
277 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
279 gtk_sheet_get_active_cell (data_sheet, &row, &column);
281 if ( row < 0 || column < 0 )
282 gtk_widget_set_sensitive (edit_paste, FALSE);
284 gtk_widget_set_sensitive (edit_paste, TRUE);
287 /* Update the Edit->Cut and Edit->Copy menuitems
288 If PAGE is not -1 , then it should be set to the current page of
289 the data editors notebook widget.
290 If -1, then it'll be queried.
293 update_cut_copy_menuitem (struct data_editor *de, gint page)
295 GtkWidget * edit_copy = get_widget_assert (de->xml, "edit_copy");
296 GtkWidget * edit_cut = get_widget_assert (de->xml, "edit_cut");
297 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
298 GtkSheet * data_sheet ;
302 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
305 if ( PAGE_VAR_SHEET == page )
307 /* We don't yet support copying from the var sheet */
308 gtk_widget_set_sensitive (edit_copy, FALSE);
309 gtk_widget_set_sensitive (edit_cut, FALSE);
313 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
315 gtk_sheet_get_active_cell (data_sheet, &row, &column);
317 if ( row < 0 || column < 0 )
319 gtk_widget_set_sensitive (edit_copy, FALSE);
320 gtk_widget_set_sensitive (edit_cut, FALSE);
324 gtk_widget_set_sensitive (edit_copy, TRUE);
325 gtk_widget_set_sensitive (edit_cut, TRUE);
329 /* Callback for when the datasheet's active cell becomes active/inactive */
331 on_data_sheet_activate_change (GtkSheet *sheet,
332 gint row, gint column, gpointer data)
334 struct data_editor *de = data;
336 update_paste_menuitem (de, -1);
337 update_cut_copy_menuitem (de, -1);
342 extern struct dataset *the_dataset;
345 Create a new data editor.
348 new_data_editor (void)
350 struct data_editor *de ;
351 struct editor_window *e;
352 GtkSheet *var_sheet ;
353 GtkSheet *data_sheet ;
355 GtkWidget *datum_entry;
357 de = g_malloc0 (sizeof (*de));
359 e = (struct editor_window *) de;
361 de->xml = XML_NEW ("data-editor.glade");
364 dataset_add_transform_change_callback (the_dataset,
365 transformation_change_callback,
368 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
369 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
372 g_signal_connect (G_OBJECT (data_sheet), "activate",
373 G_CALLBACK (on_data_sheet_activate_change), de);
375 g_signal_connect (G_OBJECT (data_sheet), "deactivate",
376 G_CALLBACK (on_data_sheet_activate_change), de);
379 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
381 g_assert(vs); /* Traps a possible bug in win32 build */
383 g_signal_connect (G_OBJECT (data_sheet), "activate",
384 G_CALLBACK (update_data_ref_entry),
387 datum_entry = get_widget_assert (de->xml, "datum_entry");
389 g_signal_connect (G_OBJECT (datum_entry), "activate",
390 G_CALLBACK (datum_entry_activate),
393 g_signal_connect (vs->dict, "weight-changed",
394 G_CALLBACK (on_weight_change),
397 g_signal_connect (vs->dict, "filter-changed",
398 G_CALLBACK (on_filter_change),
401 g_signal_connect (vs->dict, "split-changed",
402 G_CALLBACK (on_split_change),
405 connect_help (de->xml);
409 g_signal_connect (get_widget_assert (de->xml, "edit_copy"),
411 G_CALLBACK (on_edit_copy), de);
413 g_signal_connect (get_widget_assert (de->xml, "edit_cut"),
415 G_CALLBACK (on_edit_cut), de);
418 register_data_editor_actions (de);
420 de->toggle_value_labels =
421 gtk_toggle_action_new ("toggle-value-labels",
423 _("Show/hide value labels"),
424 "pspp-value-labels");
426 g_signal_connect (de->toggle_value_labels, "activate",
427 G_CALLBACK (toggle_value_labels), de);
430 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
431 get_widget_assert (de->xml,
432 "togglebutton-value-labels"));
435 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
436 get_widget_assert (de->xml,
437 "view_value-labels"));
440 gtk_action_new ("clear-cases",
442 _("Delete the cases at the selected position(s)"),
445 g_signal_connect (de->delete_cases, "activate",
446 G_CALLBACK (delete_cases), de);
448 gtk_action_connect_proxy (de->delete_cases,
449 get_widget_assert (de->xml, "edit_clear-cases"));
451 g_signal_connect (get_widget_assert (de->xml, "edit_paste"), "activate",
452 G_CALLBACK (on_edit_paste), de);
454 gtk_action_set_visible (de->delete_cases, FALSE);
456 de->delete_variables =
457 gtk_action_new ("clear-variables",
459 _("Delete the variables at the selected position(s)"),
460 "pspp-clear-variables");
462 g_signal_connect (de->delete_variables, "activate",
463 G_CALLBACK (delete_variables), de);
465 gtk_action_connect_proxy (de->delete_variables,
466 get_widget_assert (de->xml, "edit_clear-variables")
469 gtk_action_set_visible (de->delete_variables, FALSE);
471 de->insert_variable =
472 gtk_action_new ("insert-variable",
473 _("Insert Variable"),
474 _("Create a new variable at the current position"),
475 "pspp-insert-variable");
477 g_signal_connect (de->insert_variable, "activate",
478 G_CALLBACK (insert_variable), de);
481 gtk_action_connect_proxy (de->insert_variable,
482 get_widget_assert (de->xml, "button-insert-variable")
485 gtk_action_connect_proxy (de->insert_variable,
486 get_widget_assert (de->xml, "edit_insert-variable")
491 gtk_action_new ("insert-case",
493 _("Create a new case at the current position"),
496 g_signal_connect (de->insert_case, "activate",
497 G_CALLBACK (insert_case), de);
500 gtk_action_connect_proxy (de->insert_case,
501 get_widget_assert (de->xml, "button-insert-case")
505 gtk_action_connect_proxy (de->insert_case,
506 get_widget_assert (de->xml, "edit_insert-case")
511 de->invoke_goto_dialog =
512 gtk_action_new ("goto-case-dialog",
514 _("Jump to a Case in the Data Sheet"),
518 gtk_action_connect_proxy (de->invoke_goto_dialog,
519 get_widget_assert (de->xml, "button-goto-case")
522 gtk_action_connect_proxy (de->invoke_goto_dialog,
523 get_widget_assert (de->xml, "edit_goto-case")
527 g_signal_connect (de->invoke_goto_dialog, "activate",
528 G_CALLBACK (goto_case_dialog), de);
531 de->invoke_weight_cases_dialog =
532 gtk_action_new ("weight-cases-dialog",
534 _("Weight cases by variable"),
535 "pspp-weight-cases");
537 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
538 G_CALLBACK (weight_cases_dialog), de);
541 de->invoke_transpose_dialog =
542 gtk_action_new ("transpose-dialog",
544 _("Transpose the cases with the variables"),
548 g_signal_connect (de->invoke_transpose_dialog, "activate",
549 G_CALLBACK (transpose_dialog), de);
553 de->invoke_split_file_dialog =
554 gtk_action_new ("split-file-dialog",
556 _("Split the active file"),
559 g_signal_connect (de->invoke_split_file_dialog, "activate",
560 G_CALLBACK (split_file_dialog), de);
564 de->invoke_sort_cases_dialog =
565 gtk_action_new ("sort-cases-dialog",
567 _("Sort cases in the active file"),
570 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
571 G_CALLBACK (sort_cases_dialog), de);
573 de->invoke_select_cases_dialog =
574 gtk_action_new ("select-cases-dialog",
576 _("Select cases from the active file"),
577 "pspp-select-cases");
579 g_signal_connect (de->invoke_select_cases_dialog, "activate",
580 G_CALLBACK (select_cases_dialog), de);
583 de->invoke_compute_dialog =
584 gtk_action_new ("compute-dialog",
586 _("Compute new values for a variable"),
589 g_signal_connect (de->invoke_compute_dialog, "activate",
590 G_CALLBACK (compute_dialog), de);
594 de->invoke_t_test_independent_samples_dialog =
595 gtk_action_new ("t-test-independent-samples",
596 _("_Independent Samples T Test"),
597 _("Calculate T Test for samples from independent groups"),
600 g_signal_connect (de->invoke_t_test_independent_samples_dialog, "activate",
601 G_CALLBACK (t_test_independent_samples_dialog), de);
604 de->invoke_comments_dialog =
605 gtk_action_new ("commments-dialog",
606 _("Data File Comments"),
607 _("Commentary text for the data file"),
610 g_signal_connect (de->invoke_comments_dialog, "activate",
611 G_CALLBACK (comments_dialog), de);
613 de->invoke_find_dialog =
614 gtk_action_new ("find-dialog",
619 g_signal_connect (de->invoke_find_dialog, "activate",
620 G_CALLBACK (find_dialog), de);
623 de->invoke_variable_info_dialog =
624 gtk_action_new ("variable-info-dialog",
626 _("Jump to Variable"),
627 "pspp-goto-variable");
629 g_signal_connect (de->invoke_variable_info_dialog, "activate",
630 G_CALLBACK (variable_info_dialog), de);
632 de->invoke_descriptives_dialog =
633 gtk_action_new ("descriptives-dialog",
635 _("Calculate descriptive statistics (mean, variance, ...)"),
636 "pspp-descriptives");
638 g_signal_connect (de->invoke_descriptives_dialog, "activate",
639 G_CALLBACK (descriptives_dialog), de);
641 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
643 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
645 G_CALLBACK (gtk_action_activate),
646 de->action_data_new);
648 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
650 G_CALLBACK (gtk_action_activate),
651 de->action_data_open);
654 #if RECENT_LISTS_AVAILABLE
656 GtkRecentManager *rm = gtk_recent_manager_get_default ();
657 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
658 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
659 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
661 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
663 GtkRecentFilter *filter = gtk_recent_filter_new ();
665 gtk_widget_show (recent_data);
666 gtk_widget_show (recent_files);
667 gtk_widget_show (recent_separator);
669 gtk_recent_filter_add_pattern (filter, "*.sav");
670 gtk_recent_filter_add_pattern (filter, "*.SAV");
672 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
674 gtk_widget_set_sensitive (recent_data, TRUE);
675 g_signal_connect (menu, "selection-done",
676 G_CALLBACK (on_recent_data_select), de);
678 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
681 filter = gtk_recent_filter_new ();
682 menu = gtk_recent_chooser_menu_new_for_manager (rm);
684 gtk_recent_filter_add_pattern (filter, "*.sps");
685 gtk_recent_filter_add_pattern (filter, "*.SPS");
687 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
689 gtk_widget_set_sensitive (recent_files, TRUE);
690 g_signal_connect (menu, "selection-done",
691 G_CALLBACK (on_recent_files_select), de);
693 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
697 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
699 G_CALLBACK (new_syntax_window),
702 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
704 G_CALLBACK (open_syntax_window),
707 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
709 G_CALLBACK (gtk_action_activate),
710 de->action_data_save);
712 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
714 G_CALLBACK (gtk_action_activate),
715 de->action_data_save_as);
717 gtk_action_connect_proxy (de->invoke_find_dialog,
718 get_widget_assert (de->xml, "edit_find")
721 gtk_action_connect_proxy (de->invoke_find_dialog,
722 get_widget_assert (de->xml, "button-find")
725 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
726 get_widget_assert (de->xml, "data_weight-cases")
729 gtk_action_connect_proxy (de->invoke_transpose_dialog,
730 get_widget_assert (de->xml, "data_transpose")
733 gtk_action_connect_proxy (de->invoke_split_file_dialog,
734 get_widget_assert (de->xml, "data_split-file")
737 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
738 get_widget_assert (de->xml, "data_sort-cases")
741 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
742 get_widget_assert (de->xml, "data_select-cases")
745 gtk_action_connect_proxy (de->invoke_compute_dialog,
746 get_widget_assert (de->xml, "transform_compute")
749 gtk_action_connect_proxy (de->invoke_t_test_independent_samples_dialog,
750 get_widget_assert (de->xml,
755 gtk_action_connect_proxy (de->invoke_comments_dialog,
756 get_widget_assert (de->xml, "utilities_comments")
759 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
760 get_widget_assert (de->xml, "utilities_variables")
763 gtk_action_connect_proxy (de->invoke_descriptives_dialog,
764 get_widget_assert (de->xml, "analyze_descriptives")
767 g_signal_connect (get_widget_assert (de->xml,"help_about"),
769 G_CALLBACK (about_new),
773 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
775 G_CALLBACK (reference_manual),
778 g_signal_connect (data_sheet,
779 "double-click-column",
780 G_CALLBACK (click2column),
783 g_signal_connect (data_sheet,
785 G_CALLBACK (enable_delete_variables),
788 g_signal_connect (data_sheet,
790 G_CALLBACK (enable_delete_cases),
794 g_signal_connect (var_sheet,
796 GTK_SIGNAL_FUNC (click2row),
799 g_signal_connect_after (var_sheet,
801 G_CALLBACK (enable_delete_variables),
804 g_signal_connect (get_widget_assert (de->xml, "notebook"),
806 G_CALLBACK (on_switch_sheet), de);
809 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
811 G_CALLBACK (status_bar_activate), de);
814 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
816 G_CALLBACK (grid_lines_activate), de);
820 g_signal_connect (get_widget_assert (de->xml, "view_data"),
822 G_CALLBACK (data_sheet_activate), de);
824 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
826 G_CALLBACK (variable_sheet_activate), de);
830 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
832 G_CALLBACK (fonts_activate), de);
837 gtk_action_connect_proxy (de->action_data_open,
838 get_widget_assert (de->xml, "button-open")
841 gtk_action_connect_proxy (de->action_data_save,
842 get_widget_assert (de->xml, "button-save")
845 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
846 get_widget_assert (de->xml, "button-goto-variable")
849 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
850 get_widget_assert (de->xml, "button-weight-cases")
853 gtk_action_connect_proxy (de->invoke_split_file_dialog,
854 get_widget_assert (de->xml, "button-split-file")
857 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
858 get_widget_assert (de->xml, "button-select-cases")
862 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
864 G_CALLBACK (file_quit), de);
866 g_signal_connect (get_widget_assert (de->xml, "transform_run-pending"),
868 G_CALLBACK (execute), de);
871 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
873 G_CALLBACK (minimise_all_windows), NULL);
876 create_data_sheet_variable_popup_menu (de);
877 create_data_sheet_cases_popup_menu (de);
879 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
880 G_CALLBACK (popup_variable_menu), de);
882 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
883 G_CALLBACK (popup_cases_menu), de);
889 /* Callback which occurs when the var sheet's row title
890 button is double clicked */
892 click2row (GtkWidget *w, gint row, gpointer data)
894 struct data_editor *de = data;
895 GtkSheetRange visible_range;
897 gint current_row, current_column;
899 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
901 data_editor_select_sheet (de, PAGE_DATA_SHEET);
903 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
904 ¤t_row, ¤t_column);
906 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
908 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
910 if ( row < visible_range.col0 || row > visible_range.coli)
912 gtk_sheet_moveto (GTK_SHEET (data_sheet),
913 current_row, row, 0, 0);
920 /* Callback which occurs when the data sheet's column title
923 click2column (GtkWidget *w, gint col, gpointer data)
925 struct data_editor *de = data;
927 gint current_row, current_column;
929 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
931 data_editor_select_sheet (de, PAGE_VAR_SHEET);
933 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
934 ¤t_row, ¤t_column);
936 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
943 new_data_window (GtkMenuItem *menuitem, gpointer parent)
945 window_create (WINDOW_DATA, NULL);
948 /* Callback for when the datasheet/varsheet is selected */
950 on_switch_sheet (GtkNotebook *notebook,
951 GtkNotebookPage *page,
955 struct data_editor *de = user_data;
957 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
958 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
963 gtk_widget_hide (view_variables);
964 gtk_widget_show (view_data);
965 gtk_action_set_sensitive (de->insert_variable, TRUE);
966 gtk_action_set_sensitive (de->insert_case, FALSE);
967 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
969 case PAGE_DATA_SHEET:
970 gtk_widget_show (view_variables);
971 gtk_widget_show (view_data);
972 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
973 gtk_action_set_sensitive (de->insert_case, TRUE);
976 g_assert_not_reached ();
980 update_paste_menuitem (de, page_num);
981 update_cut_copy_menuitem (de, page_num);
986 data_editor_select_sheet (struct data_editor *de, gint page)
988 gtk_notebook_set_current_page
990 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
997 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
999 struct data_editor *de = data;
1000 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
1002 if ( gtk_check_menu_item_get_active (menuitem) )
1003 gtk_widget_show (statusbar);
1005 gtk_widget_hide (statusbar);
1010 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
1012 struct data_editor *de = data;
1013 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
1015 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
1019 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
1026 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1028 struct data_editor *de = data;
1030 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1035 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1037 struct data_editor *de = data;
1039 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1044 fonts_activate (GtkMenuItem *menuitem, gpointer data)
1046 struct data_editor *de = data;
1048 gtk_font_selection_dialog_new (_("Font Selection"));
1050 gtk_window_set_transient_for (GTK_WINDOW (dialog),
1051 GTK_WINDOW (get_widget_assert (de->xml,
1053 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
1055 GtkSheet *data_sheet =
1056 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1058 GtkSheet *var_sheet =
1059 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1061 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1062 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
1064 const gchar *font = gtk_font_selection_dialog_get_font_name
1065 (GTK_FONT_SELECTION_DIALOG (dialog));
1067 PangoFontDescription* font_desc =
1068 pango_font_description_from_string (font);
1070 psppire_var_store_set_font (vs, font_desc);
1071 psppire_data_store_set_font (ds, font_desc);
1074 gtk_widget_hide (dialog);
1079 /* Callback for the value labels action */
1081 toggle_value_labels (GtkToggleAction *ta, gpointer data)
1083 struct data_editor *de = data;
1085 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1087 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1090 psppire_data_store_show_labels (ds,
1091 gtk_toggle_action_get_active (ta));
1096 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
1098 /* FIXME: Need to be more intelligent here.
1099 Give the user the opportunity to save any unsaved data.
1105 delete_cases (GtkAction *action, gpointer data)
1107 struct data_editor *de = data;
1108 GtkSheet *data_sheet =
1109 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1111 GtkSheetRange range;
1113 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
1114 (gtk_sheet_get_model (data_sheet) );
1117 /* This shouldn't be able to happen, because the action
1118 should be disabled */
1119 g_return_if_fail (gtk_sheet_get_state (data_sheet)
1120 == GTK_SHEET_ROW_SELECTED );
1122 gtk_sheet_get_selected_range (data_sheet, &range);
1124 gtk_sheet_unselect_range (data_sheet);
1126 psppire_data_store_delete_cases (data_store, range.row0,
1127 1 + range.rowi - range.row0);
1132 delete_variables (GtkAction *a, gpointer data)
1134 struct data_editor *de = data;
1135 GtkSheetRange range;
1137 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
1140 const gint page = gtk_notebook_get_current_page (notebook);
1142 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
1143 (page == PAGE_VAR_SHEET) ?
1148 gtk_sheet_get_selected_range (sheet, &range);
1152 case PAGE_VAR_SHEET:
1154 PsppireVarStore *vs =
1155 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
1157 psppire_dict_delete_variables (vs->dict,
1164 case PAGE_DATA_SHEET:
1166 PsppireDataStore *ds =
1167 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1169 psppire_dict_delete_variables (ds->dict,
1178 gtk_sheet_unselect_range (sheet);
1182 insert_case (GtkAction *action, gpointer data)
1185 struct data_editor *de = data;
1187 GtkSheet *data_sheet =
1188 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1190 PsppireDataStore *ds = PSPPIRE_DATA_STORE
1191 (gtk_sheet_get_model (data_sheet) );
1194 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
1196 if (current_row < 0) current_row = 0;
1198 psppire_data_store_insert_new_case (ds, current_row);
1201 /* Insert a new variable before the current row in the variable sheet,
1202 or before the current column in the data sheet, whichever is selected */
1204 insert_variable (GtkAction *action, gpointer data)
1206 struct data_editor *de = data;
1209 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
1211 GtkSheet *var_sheet =
1212 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1214 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1215 (gtk_sheet_get_model (var_sheet) );
1217 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
1219 case PAGE_VAR_SHEET:
1220 posn = var_sheet->active_cell.row;
1222 case PAGE_DATA_SHEET:
1224 GtkSheet *data_sheet =
1225 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1227 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
1228 posn = data_sheet->range.col0;
1230 posn = data_sheet->active_cell.col;
1234 g_assert_not_reached ();
1237 if ( posn == -1 ) posn = 0;
1239 psppire_dict_insert_variable (vs->dict, posn, NULL);
1242 /* Callback for when the dictionary changes its split variables */
1244 on_split_change (PsppireDict *dict, gpointer data)
1246 struct data_editor *de = data;
1248 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1250 GtkWidget *split_status_area =
1251 get_widget_assert (de->xml, "split-file-status-area");
1253 if ( n_split_vars == 0 )
1255 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1261 const struct variable *const * split_vars =
1262 dict_get_split_vars (dict->dict);
1264 text = g_string_new (_("Split by "));
1266 for (i = 0 ; i < n_split_vars - 1; ++i )
1268 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1270 g_string_append (text, var_get_name (split_vars[i]));
1272 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1274 g_string_free (text, TRUE);
1279 /* Callback for when the dictionary changes its filter variable */
1281 on_filter_change (GObject *o, gint filter_index, gpointer data)
1283 struct data_editor *de = data;
1284 GtkWidget *filter_status_area =
1285 get_widget_assert (de->xml, "filter-use-status-area");
1287 if ( filter_index == -1 )
1289 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1293 GtkSheet *var_sheet =
1294 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1296 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1297 (gtk_sheet_get_model (var_sheet) );
1299 struct variable *var = psppire_dict_get_variable (vs->dict,
1302 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1304 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1310 /* Callback for when the dictionary changes its weights */
1312 on_weight_change (GObject *o, gint weight_index, gpointer data)
1314 struct data_editor *de = data;
1315 GtkWidget *weight_status_area =
1316 get_widget_assert (de->xml, "weight-status-area");
1318 if ( weight_index == -1 )
1320 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1324 GtkSheet *var_sheet =
1325 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1327 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1328 (gtk_sheet_get_model (var_sheet) );
1330 struct variable *var = psppire_dict_get_variable (vs->dict,
1333 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1335 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1344 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1345 static void new_file (GtkAction *, struct editor_window *de);
1346 static void open_data_dialog (GtkAction *, struct data_editor *de);
1347 static void data_save (GtkAction *action, struct data_editor *e);
1350 /* Create the GtkActions and connect to their signals */
1352 register_data_editor_actions (struct data_editor *de)
1354 de->action_data_open =
1355 gtk_action_new ("data-open-dialog",
1357 _("Open a data file"),
1360 g_signal_connect (de->action_data_open, "activate",
1361 G_CALLBACK (open_data_dialog), de);
1364 de->action_data_save = gtk_action_new ("data-save",
1366 _("Save data to file"),
1369 g_signal_connect (de->action_data_save, "activate",
1370 G_CALLBACK (data_save), de);
1374 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1376 _("Save data to file"),
1379 g_signal_connect (de->action_data_save_as, "activate",
1380 G_CALLBACK (data_save_as_dialog), de);
1382 de->action_data_new =
1383 gtk_action_new ("data-new",
1388 g_signal_connect (de->action_data_new, "activate",
1389 G_CALLBACK (new_file), de);
1392 /* Returns true if NAME has a suffix which might denote a PSPP file */
1394 name_has_suffix (const gchar *name)
1396 if ( g_str_has_suffix (name, ".sav"))
1398 if ( g_str_has_suffix (name, ".SAV"))
1400 if ( g_str_has_suffix (name, ".por"))
1402 if ( g_str_has_suffix (name, ".POR"))
1408 /* Append SUFFIX to the filename of DE */
1410 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1412 if ( ! name_has_suffix (de->file_name))
1414 gchar *s = de->file_name;
1415 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1420 /* Save DE to file */
1422 save_file (struct data_editor *de)
1424 struct getl_interface *sss;
1425 struct string file_name ;
1427 g_assert (de->file_name);
1429 ds_init_cstr (&file_name, de->file_name);
1430 gen_quoted_string (&file_name);
1432 if ( de->save_as_portable )
1434 append_filename_suffix (de, ".por");
1435 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1436 ds_cstr (&file_name));
1440 append_filename_suffix (de, ".sav");
1441 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1442 ds_cstr (&file_name));
1445 ds_destroy (&file_name);
1447 execute_syntax (sss);
1451 /* Callback for data_save action.
1452 If there's an existing file name, then just save,
1453 otherwise prompt for a file name, then save */
1455 data_save (GtkAction *action, struct data_editor *de)
1460 data_save_as_dialog (action, de);
1464 /* Callback for data_save_as action. Prompt for a filename and save */
1466 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1468 struct editor_window *e = (struct editor_window *) de;
1470 GtkWidget *button_sys;
1472 gtk_file_chooser_dialog_new (_("Save"),
1473 GTK_WINDOW (e->window),
1474 GTK_FILE_CHOOSER_ACTION_SAVE,
1475 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1476 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1479 GtkFileFilter *filter = gtk_file_filter_new ();
1480 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1481 gtk_file_filter_add_pattern (filter, "*.sav");
1482 gtk_file_filter_add_pattern (filter, "*.SAV");
1483 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1485 filter = gtk_file_filter_new ();
1486 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1487 gtk_file_filter_add_pattern (filter, "*.por");
1488 gtk_file_filter_add_pattern (filter, "*.POR");
1489 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1491 filter = gtk_file_filter_new ();
1492 gtk_file_filter_set_name (filter, _("All Files"));
1493 gtk_file_filter_add_pattern (filter, "*");
1494 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1497 GtkWidget *button_por;
1498 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1500 gtk_radio_button_new_with_label (NULL, _("System File"));
1503 gtk_radio_button_new_with_label
1504 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1505 _("Portable File"));
1507 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1508 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1510 gtk_widget_show_all (vbox);
1512 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1515 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1517 case GTK_RESPONSE_ACCEPT:
1519 g_free (de->file_name);
1522 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1524 de->save_as_portable =
1525 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1529 window_set_name_from_filename (e, de->file_name);
1536 gtk_widget_destroy (dialog);
1540 /* Callback for data_new action.
1541 Performs the NEW FILE command */
1543 new_file (GtkAction *action, struct editor_window *e)
1545 struct data_editor *de = (struct data_editor *) e;
1547 struct getl_interface *sss =
1548 create_syntax_string_source ("NEW FILE.");
1550 execute_syntax (sss);
1552 g_free (de->file_name);
1553 de->file_name = NULL;
1555 default_window_name (e);
1560 open_data_file (const gchar *file_name, struct data_editor *de)
1562 struct getl_interface *sss;
1563 struct string filename;
1565 ds_init_cstr (&filename, file_name);
1567 gen_quoted_string (&filename);
1569 sss = create_syntax_string_source ("GET FILE=%s.",
1570 ds_cstr (&filename));
1571 ds_destroy (&filename);
1573 if (execute_syntax (sss) )
1575 window_set_name_from_filename ((struct editor_window *) de, file_name);
1576 add_most_recent (file_name);
1582 /* Callback for the data_open action.
1583 Prompts for a filename and opens it */
1585 open_data_dialog (GtkAction *action, struct data_editor *de)
1587 struct editor_window *e = (struct editor_window *) de;
1590 gtk_file_chooser_dialog_new (_("Open"),
1591 GTK_WINDOW (e->window),
1592 GTK_FILE_CHOOSER_ACTION_OPEN,
1593 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1594 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1597 GtkFileFilter *filter = gtk_file_filter_new ();
1598 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1599 gtk_file_filter_add_pattern (filter, "*.sav");
1600 gtk_file_filter_add_pattern (filter, "*.SAV");
1601 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1603 filter = gtk_file_filter_new ();
1604 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1605 gtk_file_filter_add_pattern (filter, "*.por");
1606 gtk_file_filter_add_pattern (filter, "*.POR");
1607 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1609 filter = gtk_file_filter_new ();
1610 gtk_file_filter_set_name (filter, _("All Files"));
1611 gtk_file_filter_add_pattern (filter, "*");
1612 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1617 gchar *dir_name = g_path_get_dirname (de->file_name);
1618 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1623 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1625 case GTK_RESPONSE_ACCEPT:
1627 g_free (de->file_name);
1629 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1631 open_data_file (de->file_name, de);
1638 gtk_widget_destroy (dialog);
1643 /* Update the data_ref_entry with the reference of the active cell */
1645 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1647 GladeXML *data_editor_xml = data;
1649 PsppireDataStore *data_store =
1650 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1652 g_return_val_if_fail (data_editor_xml, FALSE);
1656 const struct variable *var =
1657 psppire_dict_get_variable (data_store->dict, col);
1659 /* The entry where the reference to the current cell is displayed */
1660 GtkEntry *cell_ref_entry =
1661 GTK_ENTRY (get_widget_assert (data_editor_xml,
1663 GtkEntry *datum_entry =
1664 GTK_ENTRY (get_widget_assert (data_editor_xml,
1669 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1670 var_get_name (var));
1672 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1676 gtk_entry_set_text (cell_ref_entry, s);
1681 gtk_entry_set_text (cell_ref_entry, "");
1687 psppire_data_store_get_string (data_store, row,
1688 var_get_dict_index(var));
1691 gtk_entry_set_text (datum_entry, text);
1696 gtk_entry_set_text (datum_entry, "");
1707 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1709 GString *string = g_string_new ("SORT CASES BY ");
1711 const struct variable *v =
1712 psppire_dict_get_variable (ds->dict, var);
1714 g_string_append_printf (string, "%s", var_get_name (v));
1717 g_string_append (string, " (D)");
1719 g_string_append (string, ".");
1721 execute_syntax (create_syntax_string_source (string->str));
1723 g_string_free (string, TRUE);
1728 sort_up (GtkMenuItem *item, gpointer data)
1730 GtkSheet *sheet = data;
1731 GtkSheetRange range;
1732 gtk_sheet_get_selected_range (sheet, &range);
1734 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1740 sort_down (GtkMenuItem *item, gpointer data)
1742 GtkSheet *sheet = data;
1743 GtkSheetRange range;
1744 gtk_sheet_get_selected_range (sheet, &range);
1746 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1754 create_data_sheet_variable_popup_menu (struct data_editor *de)
1756 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1757 GtkWidget *menu = gtk_menu_new ();
1759 GtkWidget *sort_ascending =
1760 gtk_menu_item_new_with_label (_("Sort Ascending"));
1762 GtkWidget *sort_descending =
1763 gtk_menu_item_new_with_label (_("Sort Descending"));
1766 GtkWidget *insert_variable =
1767 gtk_menu_item_new_with_label (_("Insert Variable"));
1769 GtkWidget *clear_variable =
1770 gtk_menu_item_new_with_label (_("Clear"));
1773 gtk_action_connect_proxy (de->insert_variable,
1777 gtk_action_connect_proxy (de->delete_variables,
1781 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1784 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1785 gtk_separator_menu_item_new ());
1788 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1791 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1792 gtk_separator_menu_item_new ());
1795 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1796 G_CALLBACK (sort_up), sheet);
1798 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1801 g_signal_connect (G_OBJECT (sort_descending), "activate",
1802 G_CALLBACK (sort_down), sheet);
1805 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1807 gtk_widget_show_all (menu);
1810 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1815 create_data_sheet_cases_popup_menu (struct data_editor *de)
1817 GtkWidget *menu = gtk_menu_new ();
1819 GtkWidget *insert_case =
1820 gtk_menu_item_new_with_label (_("Insert Case"));
1822 GtkWidget *delete_case =
1823 gtk_menu_item_new_with_label (_("Clear"));
1826 gtk_action_connect_proxy (de->insert_case,
1830 gtk_action_connect_proxy (de->delete_cases,
1834 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
1837 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1838 gtk_separator_menu_item_new ());
1841 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
1844 gtk_widget_show_all (menu);
1847 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
1852 popup_variable_menu (GtkSheet *sheet, gint column,
1853 GdkEventButton *event, gpointer data)
1855 struct data_editor *de = data;
1857 PsppireDataStore *data_store =
1858 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1860 const struct variable *v =
1861 psppire_dict_get_variable (data_store->dict, column);
1863 if ( v && event->button == 3)
1866 gtk_sheet_select_column (sheet, column);
1868 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
1869 NULL, NULL, NULL, NULL,
1870 event->button, event->time);
1876 popup_cases_menu (GtkSheet *sheet, gint row,
1877 GdkEventButton *event, gpointer data)
1879 struct data_editor *de = data;
1881 PsppireDataStore *data_store =
1882 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1884 if ( row <= psppire_data_store_get_case_count (data_store) &&
1887 gtk_sheet_select_row (sheet, row);
1889 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
1890 NULL, NULL, NULL, NULL,
1891 event->button, event->time);
1897 on_edit_paste (GtkAction *a, gpointer data)
1899 GtkClipboard *clipboard = gtk_clipboard_get (GDK_SELECTION_CLIPBOARD);
1901 gtk_clipboard_request_contents (clipboard,
1902 gdk_atom_intern ("UTF8_STRING", TRUE),
1903 data_sheet_contents_received_callback,
1909 on_edit_copy (GtkMenuItem *m, gpointer data)
1911 struct data_editor *de = data;
1913 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
1916 data_sheet_set_clip (data_sheet);
1922 on_edit_cut (GtkMenuItem *m, gpointer data)
1924 struct data_editor *de = data;
1925 gint max_rows, max_columns;
1927 GtkSheetRange range;
1928 PsppireDataStore *ds;
1929 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
1932 data_sheet_set_clip (data_sheet);
1935 /* Now blank all the cells */
1936 gtk_sheet_get_selected_range (data_sheet, &range);
1938 ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1941 /* If nothing selected, then use active cell */
1942 if ( range.row0 < 0 || range.col0 < 0 )
1945 gtk_sheet_get_active_cell (data_sheet, &row, &col);
1947 range.row0 = range.rowi = row;
1948 range.col0 = range.coli = col;
1951 /* The sheet range can include cells that do not include data.
1952 Exclude them from the range. */
1953 max_rows = psppire_data_store_get_case_count (ds);
1954 if (range.rowi >= max_rows)
1958 range.rowi = max_rows - 1;
1961 max_columns = dict_get_var_cnt (ds->dict->dict);
1962 if (range.coli >= max_columns)
1964 if (max_columns == 0)
1966 range.coli = max_columns - 1;
1969 g_return_if_fail (range.rowi >= range.row0);
1970 g_return_if_fail (range.row0 >= 0);
1971 g_return_if_fail (range.coli >= range.col0);
1972 g_return_if_fail (range.col0 >= 0);
1975 for (r = range.row0; r <= range.rowi ; ++r )
1979 for (c = range.col0 ; c <= range.coli; ++c)
1981 psppire_data_store_set_string (ds, "", r, c);
1985 /* and remove the selection */
1986 gtk_sheet_unselect_range (data_sheet);