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 "rank-dialog.h"
41 #include "comments-dialog.h"
42 #include "variable-info-dialog.h"
43 #include "descriptives-dialog.h"
44 #include "dict-display.h"
45 #include "clipboard.h"
47 #include "t-test-independent-samples-dialog.h"
50 #define _(msgid) gettext (msgid)
51 #define N_(msgid) msgid
53 #include "data-editor.h"
54 #include "syntax-editor.h"
55 #include <language/syntax-string-source.h>
56 #include <language/command.h>
57 #include <libpspp/syntax-gen.h>
58 #include "window-manager.h"
60 #include "psppire-data-store.h"
61 #include "psppire-var-store.h"
63 static void on_edit_copy (GtkMenuItem *, gpointer);
64 static void on_edit_cut (GtkMenuItem *, gpointer);
65 static void on_edit_paste (GtkAction *a, gpointer data);
68 static void create_data_sheet_variable_popup_menu (struct data_editor *);
69 static void create_data_sheet_cases_popup_menu (struct data_editor *);
71 static void popup_variable_menu (GtkSheet *, gint,
72 GdkEventButton *, gpointer data);
74 static void popup_cases_menu (GtkSheet *, gint,
75 GdkEventButton *, gpointer data);
77 /* Update the data_ref_entry with the reference of the active cell */
78 static gint update_data_ref_entry (const GtkSheet *sheet,
79 gint row, gint col, gpointer data);
81 static void register_data_editor_actions (struct data_editor *de);
83 static void insert_variable (GtkAction *, gpointer data);
84 static void insert_case (GtkAction *a, gpointer data);
85 static void delete_cases (GtkAction *a, gpointer data);
86 static void delete_variables (GtkAction *a, gpointer data);
88 static void toggle_value_labels (GtkToggleAction *a, gpointer data);
90 /* Switch between the VAR SHEET and the DATA SHEET */
92 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
93 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
96 /* Callback for when the dictionary changes properties*/
97 static void on_weight_change (GObject *, gint, gpointer);
98 static void on_filter_change (GObject *, gint, gpointer);
99 static void on_split_change (PsppireDict *, gpointer);
101 static void on_switch_sheet (GtkNotebook *notebook,
102 GtkNotebookPage *page,
106 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
108 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
110 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
112 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
114 static void fonts_activate (GtkMenuItem *, gpointer);
116 static void file_quit (GtkCheckMenuItem *, gpointer );
119 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
121 struct data_editor *de = data;
123 gtk_action_set_visible (de->delete_cases, var != -1);
128 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
130 struct data_editor *de = data;
132 gtk_action_set_visible (de->delete_variables, var != -1);
137 /* Run the EXECUTE command. */
139 execute (GtkMenuItem *mi, gpointer data)
141 struct getl_interface *sss = create_syntax_string_source ("EXECUTE.");
143 execute_syntax (sss);
147 transformation_change_callback (bool transformations_pending,
150 struct data_editor *de = data;
151 GtkWidget *menuitem =
152 get_widget_assert (de->xml, "transform_run-pending");
153 GtkWidget *status_label =
154 get_widget_assert (de->xml, "case-counter-area");
156 gtk_widget_set_sensitive (menuitem, transformations_pending);
159 if ( transformations_pending)
160 gtk_label_set_text (GTK_LABEL (status_label),
161 _("Transformations Pending"));
163 gtk_label_set_text (GTK_LABEL (status_label), "");
167 static void open_data_file (const gchar *, struct data_editor *);
170 /* Puts FILE_NAME into the recent list.
171 If it's already in the list, it moves it to the top
174 add_most_recent (const char *file_name)
176 #if RECENT_LISTS_AVAILABLE
178 GtkRecentManager *manager = gtk_recent_manager_get_default();
179 gchar *uri = g_filename_to_uri (file_name, NULL, NULL);
181 gtk_recent_manager_remove_item (manager, uri, NULL);
183 if ( ! gtk_recent_manager_add_item (manager, uri))
184 g_warning ("Could not add item %s to recent list\n",uri);
192 #if RECENT_LISTS_AVAILABLE
195 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
198 struct data_editor *de = user_data;
201 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
203 file = g_filename_from_uri (uri, NULL, NULL);
207 open_data_file (file, de);
213 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
217 struct syntax_editor *se ;
220 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
222 file = g_filename_from_uri (uri, NULL, NULL);
226 se = (struct syntax_editor *)
227 window_create (WINDOW_SYNTAX, file);
229 load_editor_from_file (se, file, NULL);
237 datum_entry_activate (GtkEntry *entry, gpointer data)
240 GtkSheet *data_sheet = GTK_SHEET (data);
241 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
243 const char *text = gtk_entry_get_text (entry);
245 gtk_sheet_get_active_cell (data_sheet, &row, &column);
247 if ( row == -1 || column == -1)
250 psppire_data_store_set_string (store, text, row, column);
254 /* Update the Edit->Paste menuitem
255 If PAGE is not -1 , then it should be set to the current page of
256 the data editors notebook widget.
257 If -1, then it'll be queried.
260 update_paste_menuitem (struct data_editor *de, gint page)
262 GtkWidget * edit_paste = get_widget_assert (de->xml, "edit_paste");
263 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
264 GtkSheet * data_sheet ;
268 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
271 if ( PAGE_VAR_SHEET == page )
273 /* We don't yet support pasting to the var sheet */
274 gtk_widget_set_sensitive (edit_paste, FALSE);
278 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
280 gtk_sheet_get_active_cell (data_sheet, &row, &column);
282 if ( row < 0 || column < 0 )
283 gtk_widget_set_sensitive (edit_paste, FALSE);
285 gtk_widget_set_sensitive (edit_paste, TRUE);
288 /* Update the Edit->Cut and Edit->Copy menuitems
289 If PAGE is not -1 , then it should be set to the current page of
290 the data editors notebook widget.
291 If -1, then it'll be queried.
294 update_cut_copy_menuitem (struct data_editor *de, gint page)
296 GtkWidget * edit_copy = get_widget_assert (de->xml, "edit_copy");
297 GtkWidget * edit_cut = get_widget_assert (de->xml, "edit_cut");
298 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
299 GtkSheet * data_sheet ;
303 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
306 if ( PAGE_VAR_SHEET == page )
308 /* We don't yet support copying from the var sheet */
309 gtk_widget_set_sensitive (edit_copy, FALSE);
310 gtk_widget_set_sensitive (edit_cut, FALSE);
314 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
316 gtk_sheet_get_active_cell (data_sheet, &row, &column);
318 if ( row < 0 || column < 0 )
320 gtk_widget_set_sensitive (edit_copy, FALSE);
321 gtk_widget_set_sensitive (edit_cut, FALSE);
325 gtk_widget_set_sensitive (edit_copy, TRUE);
326 gtk_widget_set_sensitive (edit_cut, TRUE);
330 /* Callback for when the datasheet's active cell becomes active/inactive */
332 on_data_sheet_activate_change (GtkSheet *sheet,
333 gint row, gint column, gpointer data)
335 struct data_editor *de = data;
337 update_paste_menuitem (de, -1);
338 update_cut_copy_menuitem (de, -1);
343 extern struct dataset *the_dataset;
346 Create a new data editor.
349 new_data_editor (void)
351 struct data_editor *de ;
352 struct editor_window *e;
353 GtkSheet *var_sheet ;
354 GtkSheet *data_sheet ;
356 GtkWidget *datum_entry;
358 de = g_malloc0 (sizeof (*de));
360 e = (struct editor_window *) de;
362 de->xml = XML_NEW ("data-editor.glade");
365 dataset_add_transform_change_callback (the_dataset,
366 transformation_change_callback,
369 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
370 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
373 g_signal_connect (G_OBJECT (data_sheet), "activate",
374 G_CALLBACK (on_data_sheet_activate_change), de);
376 g_signal_connect (G_OBJECT (data_sheet), "deactivate",
377 G_CALLBACK (on_data_sheet_activate_change), de);
380 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
382 g_assert(vs); /* Traps a possible bug in win32 build */
384 g_signal_connect (G_OBJECT (data_sheet), "activate",
385 G_CALLBACK (update_data_ref_entry),
388 datum_entry = get_widget_assert (de->xml, "datum_entry");
390 g_signal_connect (G_OBJECT (datum_entry), "activate",
391 G_CALLBACK (datum_entry_activate),
394 g_signal_connect (vs->dict, "weight-changed",
395 G_CALLBACK (on_weight_change),
398 g_signal_connect (vs->dict, "filter-changed",
399 G_CALLBACK (on_filter_change),
402 g_signal_connect (vs->dict, "split-changed",
403 G_CALLBACK (on_split_change),
406 connect_help (de->xml);
410 g_signal_connect (get_widget_assert (de->xml, "edit_copy"),
412 G_CALLBACK (on_edit_copy), de);
414 g_signal_connect (get_widget_assert (de->xml, "edit_cut"),
416 G_CALLBACK (on_edit_cut), de);
419 register_data_editor_actions (de);
421 de->toggle_value_labels =
422 gtk_toggle_action_new ("toggle-value-labels",
424 _("Show/hide value labels"),
425 "pspp-value-labels");
427 g_signal_connect (de->toggle_value_labels, "activate",
428 G_CALLBACK (toggle_value_labels), de);
431 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
432 get_widget_assert (de->xml,
433 "togglebutton-value-labels"));
436 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
437 get_widget_assert (de->xml,
438 "view_value-labels"));
441 gtk_action_new ("clear-cases",
443 _("Delete the cases at the selected position(s)"),
446 g_signal_connect (de->delete_cases, "activate",
447 G_CALLBACK (delete_cases), de);
449 gtk_action_connect_proxy (de->delete_cases,
450 get_widget_assert (de->xml, "edit_clear-cases"));
452 g_signal_connect (get_widget_assert (de->xml, "edit_paste"), "activate",
453 G_CALLBACK (on_edit_paste), de);
455 gtk_action_set_visible (de->delete_cases, FALSE);
457 de->delete_variables =
458 gtk_action_new ("clear-variables",
460 _("Delete the variables at the selected position(s)"),
461 "pspp-clear-variables");
463 g_signal_connect (de->delete_variables, "activate",
464 G_CALLBACK (delete_variables), de);
466 gtk_action_connect_proxy (de->delete_variables,
467 get_widget_assert (de->xml, "edit_clear-variables")
470 gtk_action_set_visible (de->delete_variables, FALSE);
472 de->insert_variable =
473 gtk_action_new ("insert-variable",
474 _("Insert Variable"),
475 _("Create a new variable at the current position"),
476 "pspp-insert-variable");
478 g_signal_connect (de->insert_variable, "activate",
479 G_CALLBACK (insert_variable), de);
482 gtk_action_connect_proxy (de->insert_variable,
483 get_widget_assert (de->xml, "button-insert-variable")
486 gtk_action_connect_proxy (de->insert_variable,
487 get_widget_assert (de->xml, "edit_insert-variable")
492 gtk_action_new ("insert-case",
494 _("Create a new case at the current position"),
497 g_signal_connect (de->insert_case, "activate",
498 G_CALLBACK (insert_case), de);
501 gtk_action_connect_proxy (de->insert_case,
502 get_widget_assert (de->xml, "button-insert-case")
506 gtk_action_connect_proxy (de->insert_case,
507 get_widget_assert (de->xml, "edit_insert-case")
512 de->invoke_goto_dialog =
513 gtk_action_new ("goto-case-dialog",
515 _("Jump to a Case in the Data Sheet"),
519 gtk_action_connect_proxy (de->invoke_goto_dialog,
520 get_widget_assert (de->xml, "button-goto-case")
523 gtk_action_connect_proxy (de->invoke_goto_dialog,
524 get_widget_assert (de->xml, "edit_goto-case")
528 g_signal_connect (de->invoke_goto_dialog, "activate",
529 G_CALLBACK (goto_case_dialog), de);
532 de->invoke_weight_cases_dialog =
533 gtk_action_new ("weight-cases-dialog",
535 _("Weight cases by variable"),
536 "pspp-weight-cases");
538 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
539 G_CALLBACK (weight_cases_dialog), de);
542 de->invoke_transpose_dialog =
543 gtk_action_new ("transpose-dialog",
545 _("Transpose the cases with the variables"),
549 g_signal_connect (de->invoke_transpose_dialog, "activate",
550 G_CALLBACK (transpose_dialog), de);
554 de->invoke_split_file_dialog =
555 gtk_action_new ("split-file-dialog",
557 _("Split the active file"),
560 g_signal_connect (de->invoke_split_file_dialog, "activate",
561 G_CALLBACK (split_file_dialog), de);
565 de->invoke_sort_cases_dialog =
566 gtk_action_new ("sort-cases-dialog",
568 _("Sort cases in the active file"),
571 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
572 G_CALLBACK (sort_cases_dialog), de);
574 de->invoke_select_cases_dialog =
575 gtk_action_new ("select-cases-dialog",
577 _("Select cases from the active file"),
578 "pspp-select-cases");
580 g_signal_connect (de->invoke_select_cases_dialog, "activate",
581 G_CALLBACK (select_cases_dialog), de);
584 de->invoke_compute_dialog =
585 gtk_action_new ("compute-dialog",
587 _("Compute new values for a variable"),
590 g_signal_connect (de->invoke_compute_dialog, "activate",
591 G_CALLBACK (compute_dialog), de);
595 de->invoke_t_test_independent_samples_dialog =
596 gtk_action_new ("t-test-independent-samples",
597 _("_Independent Samples T Test"),
598 _("Calculate T Test for samples from independent groups"),
601 g_signal_connect (de->invoke_t_test_independent_samples_dialog, "activate",
602 G_CALLBACK (t_test_independent_samples_dialog), de);
605 de->invoke_comments_dialog =
606 gtk_action_new ("commments-dialog",
607 _("Data File Comments"),
608 _("Commentary text for the data file"),
611 g_signal_connect (de->invoke_comments_dialog, "activate",
612 G_CALLBACK (comments_dialog), de);
614 de->invoke_find_dialog =
615 gtk_action_new ("find-dialog",
620 g_signal_connect (de->invoke_find_dialog, "activate",
621 G_CALLBACK (find_dialog), de);
624 de->invoke_rank_dialog =
625 gtk_action_new ("rank-dialog",
630 g_signal_connect (de->invoke_rank_dialog, "activate",
631 G_CALLBACK (rank_dialog), de);
634 de->invoke_variable_info_dialog =
635 gtk_action_new ("variable-info-dialog",
637 _("Jump to Variable"),
638 "pspp-goto-variable");
640 g_signal_connect (de->invoke_variable_info_dialog, "activate",
641 G_CALLBACK (variable_info_dialog), de);
643 de->invoke_descriptives_dialog =
644 gtk_action_new ("descriptives-dialog",
646 _("Calculate descriptive statistics (mean, variance, ...)"),
647 "pspp-descriptives");
649 g_signal_connect (de->invoke_descriptives_dialog, "activate",
650 G_CALLBACK (descriptives_dialog), de);
652 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
654 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
656 G_CALLBACK (gtk_action_activate),
657 de->action_data_new);
659 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
661 G_CALLBACK (gtk_action_activate),
662 de->action_data_open);
665 #if RECENT_LISTS_AVAILABLE
667 GtkRecentManager *rm = gtk_recent_manager_get_default ();
668 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
669 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
670 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
672 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
674 GtkRecentFilter *filter = gtk_recent_filter_new ();
676 gtk_widget_show (recent_data);
677 gtk_widget_show (recent_files);
678 gtk_widget_show (recent_separator);
680 gtk_recent_filter_add_pattern (filter, "*.sav");
681 gtk_recent_filter_add_pattern (filter, "*.SAV");
683 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
685 gtk_widget_set_sensitive (recent_data, TRUE);
686 g_signal_connect (menu, "selection-done",
687 G_CALLBACK (on_recent_data_select), de);
689 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
692 filter = gtk_recent_filter_new ();
693 menu = gtk_recent_chooser_menu_new_for_manager (rm);
695 gtk_recent_filter_add_pattern (filter, "*.sps");
696 gtk_recent_filter_add_pattern (filter, "*.SPS");
698 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
700 gtk_widget_set_sensitive (recent_files, TRUE);
701 g_signal_connect (menu, "selection-done",
702 G_CALLBACK (on_recent_files_select), de);
704 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
708 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
710 G_CALLBACK (new_syntax_window),
713 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
715 G_CALLBACK (open_syntax_window),
718 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
720 G_CALLBACK (gtk_action_activate),
721 de->action_data_save);
723 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
725 G_CALLBACK (gtk_action_activate),
726 de->action_data_save_as);
728 gtk_action_connect_proxy (de->invoke_find_dialog,
729 get_widget_assert (de->xml, "edit_find")
732 gtk_action_connect_proxy (de->invoke_find_dialog,
733 get_widget_assert (de->xml, "button-find")
736 gtk_action_connect_proxy (de->invoke_rank_dialog,
737 get_widget_assert (de->xml, "transform_rank")
740 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
741 get_widget_assert (de->xml, "data_weight-cases")
744 gtk_action_connect_proxy (de->invoke_transpose_dialog,
745 get_widget_assert (de->xml, "data_transpose")
748 gtk_action_connect_proxy (de->invoke_split_file_dialog,
749 get_widget_assert (de->xml, "data_split-file")
752 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
753 get_widget_assert (de->xml, "data_sort-cases")
756 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
757 get_widget_assert (de->xml, "data_select-cases")
760 gtk_action_connect_proxy (de->invoke_compute_dialog,
761 get_widget_assert (de->xml, "transform_compute")
764 gtk_action_connect_proxy (de->invoke_t_test_independent_samples_dialog,
765 get_widget_assert (de->xml,
770 gtk_action_connect_proxy (de->invoke_comments_dialog,
771 get_widget_assert (de->xml, "utilities_comments")
774 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
775 get_widget_assert (de->xml, "utilities_variables")
778 gtk_action_connect_proxy (de->invoke_descriptives_dialog,
779 get_widget_assert (de->xml, "analyze_descriptives")
782 g_signal_connect (get_widget_assert (de->xml,"help_about"),
784 G_CALLBACK (about_new),
788 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
790 G_CALLBACK (reference_manual),
793 g_signal_connect (data_sheet,
794 "double-click-column",
795 G_CALLBACK (click2column),
798 g_signal_connect (data_sheet,
800 G_CALLBACK (enable_delete_variables),
803 g_signal_connect (data_sheet,
805 G_CALLBACK (enable_delete_cases),
809 g_signal_connect (var_sheet,
811 GTK_SIGNAL_FUNC (click2row),
814 g_signal_connect_after (var_sheet,
816 G_CALLBACK (enable_delete_variables),
819 g_signal_connect (get_widget_assert (de->xml, "notebook"),
821 G_CALLBACK (on_switch_sheet), de);
824 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
826 G_CALLBACK (status_bar_activate), de);
829 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
831 G_CALLBACK (grid_lines_activate), de);
835 g_signal_connect (get_widget_assert (de->xml, "view_data"),
837 G_CALLBACK (data_sheet_activate), de);
839 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
841 G_CALLBACK (variable_sheet_activate), de);
845 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
847 G_CALLBACK (fonts_activate), de);
852 gtk_action_connect_proxy (de->action_data_open,
853 get_widget_assert (de->xml, "button-open")
856 gtk_action_connect_proxy (de->action_data_save,
857 get_widget_assert (de->xml, "button-save")
860 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
861 get_widget_assert (de->xml, "button-goto-variable")
864 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
865 get_widget_assert (de->xml, "button-weight-cases")
868 gtk_action_connect_proxy (de->invoke_split_file_dialog,
869 get_widget_assert (de->xml, "button-split-file")
872 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
873 get_widget_assert (de->xml, "button-select-cases")
877 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
879 G_CALLBACK (file_quit), de);
881 g_signal_connect (get_widget_assert (de->xml, "transform_run-pending"),
883 G_CALLBACK (execute), de);
886 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
888 G_CALLBACK (minimise_all_windows), NULL);
891 create_data_sheet_variable_popup_menu (de);
892 create_data_sheet_cases_popup_menu (de);
894 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
895 G_CALLBACK (popup_variable_menu), de);
897 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
898 G_CALLBACK (popup_cases_menu), de);
904 /* Callback which occurs when the var sheet's row title
905 button is double clicked */
907 click2row (GtkWidget *w, gint row, gpointer data)
909 struct data_editor *de = data;
910 GtkSheetRange visible_range;
912 gint current_row, current_column;
914 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
916 data_editor_select_sheet (de, PAGE_DATA_SHEET);
918 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
919 ¤t_row, ¤t_column);
921 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
923 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
925 if ( row < visible_range.col0 || row > visible_range.coli)
927 gtk_sheet_moveto (GTK_SHEET (data_sheet),
928 current_row, row, 0, 0);
935 /* Callback which occurs when the data sheet's column title
938 click2column (GtkWidget *w, gint col, gpointer data)
940 struct data_editor *de = data;
942 gint current_row, current_column;
944 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
946 data_editor_select_sheet (de, PAGE_VAR_SHEET);
948 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
949 ¤t_row, ¤t_column);
951 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
958 new_data_window (GtkMenuItem *menuitem, gpointer parent)
960 window_create (WINDOW_DATA, NULL);
963 /* Callback for when the datasheet/varsheet is selected */
965 on_switch_sheet (GtkNotebook *notebook,
966 GtkNotebookPage *page,
970 struct data_editor *de = user_data;
972 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
973 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
978 gtk_widget_hide (view_variables);
979 gtk_widget_show (view_data);
980 gtk_action_set_sensitive (de->insert_variable, TRUE);
981 gtk_action_set_sensitive (de->insert_case, FALSE);
982 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
984 case PAGE_DATA_SHEET:
985 gtk_widget_show (view_variables);
986 gtk_widget_show (view_data);
987 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
988 gtk_action_set_sensitive (de->insert_case, TRUE);
991 g_assert_not_reached ();
995 update_paste_menuitem (de, page_num);
996 update_cut_copy_menuitem (de, page_num);
1001 data_editor_select_sheet (struct data_editor *de, gint page)
1003 gtk_notebook_set_current_page
1005 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
1012 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
1014 struct data_editor *de = data;
1015 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
1017 if ( gtk_check_menu_item_get_active (menuitem) )
1018 gtk_widget_show (statusbar);
1020 gtk_widget_hide (statusbar);
1025 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
1027 struct data_editor *de = data;
1028 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
1030 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
1034 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
1041 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1043 struct data_editor *de = data;
1045 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1050 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1052 struct data_editor *de = data;
1054 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1059 fonts_activate (GtkMenuItem *menuitem, gpointer data)
1061 struct data_editor *de = data;
1063 gtk_font_selection_dialog_new (_("Font Selection"));
1065 gtk_window_set_transient_for (GTK_WINDOW (dialog),
1066 GTK_WINDOW (get_widget_assert (de->xml,
1068 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
1070 GtkSheet *data_sheet =
1071 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1073 GtkSheet *var_sheet =
1074 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1076 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1077 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
1079 const gchar *font = gtk_font_selection_dialog_get_font_name
1080 (GTK_FONT_SELECTION_DIALOG (dialog));
1082 PangoFontDescription* font_desc =
1083 pango_font_description_from_string (font);
1085 psppire_var_store_set_font (vs, font_desc);
1086 psppire_data_store_set_font (ds, font_desc);
1089 gtk_widget_hide (dialog);
1094 /* Callback for the value labels action */
1096 toggle_value_labels (GtkToggleAction *ta, gpointer data)
1098 struct data_editor *de = data;
1100 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1102 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1105 psppire_data_store_show_labels (ds,
1106 gtk_toggle_action_get_active (ta));
1111 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
1113 /* FIXME: Need to be more intelligent here.
1114 Give the user the opportunity to save any unsaved data.
1120 delete_cases (GtkAction *action, gpointer data)
1122 struct data_editor *de = data;
1123 GtkSheet *data_sheet =
1124 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1126 GtkSheetRange range;
1128 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
1129 (gtk_sheet_get_model (data_sheet) );
1132 /* This shouldn't be able to happen, because the action
1133 should be disabled */
1134 g_return_if_fail (gtk_sheet_get_state (data_sheet)
1135 == GTK_SHEET_ROW_SELECTED );
1137 gtk_sheet_get_selected_range (data_sheet, &range);
1139 gtk_sheet_unselect_range (data_sheet);
1141 psppire_data_store_delete_cases (data_store, range.row0,
1142 1 + range.rowi - range.row0);
1147 delete_variables (GtkAction *a, gpointer data)
1149 struct data_editor *de = data;
1150 GtkSheetRange range;
1152 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
1155 const gint page = gtk_notebook_get_current_page (notebook);
1157 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
1158 (page == PAGE_VAR_SHEET) ?
1163 gtk_sheet_get_selected_range (sheet, &range);
1167 case PAGE_VAR_SHEET:
1169 PsppireVarStore *vs =
1170 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
1172 psppire_dict_delete_variables (vs->dict,
1179 case PAGE_DATA_SHEET:
1181 PsppireDataStore *ds =
1182 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1184 psppire_dict_delete_variables (ds->dict,
1193 gtk_sheet_unselect_range (sheet);
1197 insert_case (GtkAction *action, gpointer data)
1200 struct data_editor *de = data;
1202 GtkSheet *data_sheet =
1203 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1205 PsppireDataStore *ds = PSPPIRE_DATA_STORE
1206 (gtk_sheet_get_model (data_sheet) );
1209 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
1211 if (current_row < 0) current_row = 0;
1213 psppire_data_store_insert_new_case (ds, current_row);
1216 /* Insert a new variable before the current row in the variable sheet,
1217 or before the current column in the data sheet, whichever is selected */
1219 insert_variable (GtkAction *action, gpointer data)
1221 struct data_editor *de = data;
1224 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
1226 GtkSheet *var_sheet =
1227 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1229 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1230 (gtk_sheet_get_model (var_sheet) );
1232 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
1234 case PAGE_VAR_SHEET:
1235 posn = var_sheet->active_cell.row;
1237 case PAGE_DATA_SHEET:
1239 GtkSheet *data_sheet =
1240 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1242 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
1243 posn = data_sheet->range.col0;
1245 posn = data_sheet->active_cell.col;
1249 g_assert_not_reached ();
1252 if ( posn == -1 ) posn = 0;
1254 psppire_dict_insert_variable (vs->dict, posn, NULL);
1257 /* Callback for when the dictionary changes its split variables */
1259 on_split_change (PsppireDict *dict, gpointer data)
1261 struct data_editor *de = data;
1263 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1265 GtkWidget *split_status_area =
1266 get_widget_assert (de->xml, "split-file-status-area");
1268 if ( n_split_vars == 0 )
1270 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1276 const struct variable *const * split_vars =
1277 dict_get_split_vars (dict->dict);
1279 text = g_string_new (_("Split by "));
1281 for (i = 0 ; i < n_split_vars - 1; ++i )
1283 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1285 g_string_append (text, var_get_name (split_vars[i]));
1287 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1289 g_string_free (text, TRUE);
1294 /* Callback for when the dictionary changes its filter variable */
1296 on_filter_change (GObject *o, gint filter_index, gpointer data)
1298 struct data_editor *de = data;
1299 GtkWidget *filter_status_area =
1300 get_widget_assert (de->xml, "filter-use-status-area");
1302 if ( filter_index == -1 )
1304 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1308 GtkSheet *var_sheet =
1309 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1311 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1312 (gtk_sheet_get_model (var_sheet) );
1314 struct variable *var = psppire_dict_get_variable (vs->dict,
1317 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1319 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1325 /* Callback for when the dictionary changes its weights */
1327 on_weight_change (GObject *o, gint weight_index, gpointer data)
1329 struct data_editor *de = data;
1330 GtkWidget *weight_status_area =
1331 get_widget_assert (de->xml, "weight-status-area");
1333 if ( weight_index == -1 )
1335 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1339 GtkSheet *var_sheet =
1340 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1342 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1343 (gtk_sheet_get_model (var_sheet) );
1345 struct variable *var = psppire_dict_get_variable (vs->dict,
1348 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1350 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1359 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1360 static void new_file (GtkAction *, struct editor_window *de);
1361 static void open_data_dialog (GtkAction *, struct data_editor *de);
1362 static void data_save (GtkAction *action, struct data_editor *e);
1365 /* Create the GtkActions and connect to their signals */
1367 register_data_editor_actions (struct data_editor *de)
1369 de->action_data_open =
1370 gtk_action_new ("data-open-dialog",
1372 _("Open a data file"),
1375 g_signal_connect (de->action_data_open, "activate",
1376 G_CALLBACK (open_data_dialog), de);
1379 de->action_data_save = gtk_action_new ("data-save",
1381 _("Save data to file"),
1384 g_signal_connect (de->action_data_save, "activate",
1385 G_CALLBACK (data_save), de);
1389 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1391 _("Save data to file"),
1394 g_signal_connect (de->action_data_save_as, "activate",
1395 G_CALLBACK (data_save_as_dialog), de);
1397 de->action_data_new =
1398 gtk_action_new ("data-new",
1403 g_signal_connect (de->action_data_new, "activate",
1404 G_CALLBACK (new_file), de);
1407 /* Returns true if NAME has a suffix which might denote a PSPP file */
1409 name_has_suffix (const gchar *name)
1411 if ( g_str_has_suffix (name, ".sav"))
1413 if ( g_str_has_suffix (name, ".SAV"))
1415 if ( g_str_has_suffix (name, ".por"))
1417 if ( g_str_has_suffix (name, ".POR"))
1423 /* Append SUFFIX to the filename of DE */
1425 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1427 if ( ! name_has_suffix (de->file_name))
1429 gchar *s = de->file_name;
1430 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1435 /* Save DE to file */
1437 save_file (struct data_editor *de)
1439 struct getl_interface *sss;
1440 struct string file_name ;
1442 g_assert (de->file_name);
1444 ds_init_cstr (&file_name, de->file_name);
1445 gen_quoted_string (&file_name);
1447 if ( de->save_as_portable )
1449 append_filename_suffix (de, ".por");
1450 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1451 ds_cstr (&file_name));
1455 append_filename_suffix (de, ".sav");
1456 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1457 ds_cstr (&file_name));
1460 ds_destroy (&file_name);
1462 execute_syntax (sss);
1466 /* Callback for data_save action.
1467 If there's an existing file name, then just save,
1468 otherwise prompt for a file name, then save */
1470 data_save (GtkAction *action, struct data_editor *de)
1475 data_save_as_dialog (action, de);
1479 /* Callback for data_save_as action. Prompt for a filename and save */
1481 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1483 struct editor_window *e = (struct editor_window *) de;
1485 GtkWidget *button_sys;
1487 gtk_file_chooser_dialog_new (_("Save"),
1488 GTK_WINDOW (e->window),
1489 GTK_FILE_CHOOSER_ACTION_SAVE,
1490 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1491 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1494 GtkFileFilter *filter = gtk_file_filter_new ();
1495 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1496 gtk_file_filter_add_pattern (filter, "*.sav");
1497 gtk_file_filter_add_pattern (filter, "*.SAV");
1498 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1500 filter = gtk_file_filter_new ();
1501 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1502 gtk_file_filter_add_pattern (filter, "*.por");
1503 gtk_file_filter_add_pattern (filter, "*.POR");
1504 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1506 filter = gtk_file_filter_new ();
1507 gtk_file_filter_set_name (filter, _("All Files"));
1508 gtk_file_filter_add_pattern (filter, "*");
1509 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1512 GtkWidget *button_por;
1513 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1515 gtk_radio_button_new_with_label (NULL, _("System File"));
1518 gtk_radio_button_new_with_label
1519 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1520 _("Portable File"));
1522 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1523 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1525 gtk_widget_show_all (vbox);
1527 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1530 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1532 case GTK_RESPONSE_ACCEPT:
1534 g_free (de->file_name);
1537 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1539 de->save_as_portable =
1540 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1544 window_set_name_from_filename (e, de->file_name);
1551 gtk_widget_destroy (dialog);
1555 /* Callback for data_new action.
1556 Performs the NEW FILE command */
1558 new_file (GtkAction *action, struct editor_window *e)
1560 struct data_editor *de = (struct data_editor *) e;
1562 struct getl_interface *sss =
1563 create_syntax_string_source ("NEW FILE.");
1565 execute_syntax (sss);
1567 g_free (de->file_name);
1568 de->file_name = NULL;
1570 default_window_name (e);
1575 open_data_file (const gchar *file_name, struct data_editor *de)
1577 struct getl_interface *sss;
1578 struct string filename;
1580 ds_init_cstr (&filename, file_name);
1582 gen_quoted_string (&filename);
1584 sss = create_syntax_string_source ("GET FILE=%s.",
1585 ds_cstr (&filename));
1586 ds_destroy (&filename);
1588 if (execute_syntax (sss) )
1590 window_set_name_from_filename ((struct editor_window *) de, file_name);
1591 add_most_recent (file_name);
1597 /* Callback for the data_open action.
1598 Prompts for a filename and opens it */
1600 open_data_dialog (GtkAction *action, struct data_editor *de)
1602 struct editor_window *e = (struct editor_window *) de;
1605 gtk_file_chooser_dialog_new (_("Open"),
1606 GTK_WINDOW (e->window),
1607 GTK_FILE_CHOOSER_ACTION_OPEN,
1608 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1609 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1612 GtkFileFilter *filter = gtk_file_filter_new ();
1613 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1614 gtk_file_filter_add_pattern (filter, "*.sav");
1615 gtk_file_filter_add_pattern (filter, "*.SAV");
1616 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1618 filter = gtk_file_filter_new ();
1619 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1620 gtk_file_filter_add_pattern (filter, "*.por");
1621 gtk_file_filter_add_pattern (filter, "*.POR");
1622 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1624 filter = gtk_file_filter_new ();
1625 gtk_file_filter_set_name (filter, _("All Files"));
1626 gtk_file_filter_add_pattern (filter, "*");
1627 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1632 gchar *dir_name = g_path_get_dirname (de->file_name);
1633 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1638 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1640 case GTK_RESPONSE_ACCEPT:
1642 g_free (de->file_name);
1644 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1646 open_data_file (de->file_name, de);
1653 gtk_widget_destroy (dialog);
1658 /* Update the data_ref_entry with the reference of the active cell */
1660 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1662 GladeXML *data_editor_xml = data;
1664 PsppireDataStore *data_store =
1665 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1667 g_return_val_if_fail (data_editor_xml, FALSE);
1671 const struct variable *var =
1672 psppire_dict_get_variable (data_store->dict, col);
1674 /* The entry where the reference to the current cell is displayed */
1675 GtkEntry *cell_ref_entry =
1676 GTK_ENTRY (get_widget_assert (data_editor_xml,
1678 GtkEntry *datum_entry =
1679 GTK_ENTRY (get_widget_assert (data_editor_xml,
1684 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1685 var_get_name (var));
1687 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1691 gtk_entry_set_text (cell_ref_entry, s);
1696 gtk_entry_set_text (cell_ref_entry, "");
1702 psppire_data_store_get_string (data_store, row,
1703 var_get_dict_index(var));
1706 gtk_entry_set_text (datum_entry, text);
1711 gtk_entry_set_text (datum_entry, "");
1722 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1724 GString *string = g_string_new ("SORT CASES BY ");
1726 const struct variable *v =
1727 psppire_dict_get_variable (ds->dict, var);
1729 g_string_append_printf (string, "%s", var_get_name (v));
1732 g_string_append (string, " (D)");
1734 g_string_append (string, ".");
1736 execute_syntax (create_syntax_string_source (string->str));
1738 g_string_free (string, TRUE);
1743 sort_up (GtkMenuItem *item, gpointer data)
1745 GtkSheet *sheet = data;
1746 GtkSheetRange range;
1747 gtk_sheet_get_selected_range (sheet, &range);
1749 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1755 sort_down (GtkMenuItem *item, gpointer data)
1757 GtkSheet *sheet = data;
1758 GtkSheetRange range;
1759 gtk_sheet_get_selected_range (sheet, &range);
1761 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1769 create_data_sheet_variable_popup_menu (struct data_editor *de)
1771 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1772 GtkWidget *menu = gtk_menu_new ();
1774 GtkWidget *sort_ascending =
1775 gtk_menu_item_new_with_label (_("Sort Ascending"));
1777 GtkWidget *sort_descending =
1778 gtk_menu_item_new_with_label (_("Sort Descending"));
1781 GtkWidget *insert_variable =
1782 gtk_menu_item_new_with_label (_("Insert Variable"));
1784 GtkWidget *clear_variable =
1785 gtk_menu_item_new_with_label (_("Clear"));
1788 gtk_action_connect_proxy (de->insert_variable,
1792 gtk_action_connect_proxy (de->delete_variables,
1796 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1799 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1800 gtk_separator_menu_item_new ());
1803 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1806 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1807 gtk_separator_menu_item_new ());
1810 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1811 G_CALLBACK (sort_up), sheet);
1813 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1816 g_signal_connect (G_OBJECT (sort_descending), "activate",
1817 G_CALLBACK (sort_down), sheet);
1820 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1822 gtk_widget_show_all (menu);
1825 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1830 create_data_sheet_cases_popup_menu (struct data_editor *de)
1832 GtkWidget *menu = gtk_menu_new ();
1834 GtkWidget *insert_case =
1835 gtk_menu_item_new_with_label (_("Insert Case"));
1837 GtkWidget *delete_case =
1838 gtk_menu_item_new_with_label (_("Clear"));
1841 gtk_action_connect_proxy (de->insert_case,
1845 gtk_action_connect_proxy (de->delete_cases,
1849 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
1852 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1853 gtk_separator_menu_item_new ());
1856 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
1859 gtk_widget_show_all (menu);
1862 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
1867 popup_variable_menu (GtkSheet *sheet, gint column,
1868 GdkEventButton *event, gpointer data)
1870 struct data_editor *de = data;
1872 PsppireDataStore *data_store =
1873 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1875 const struct variable *v =
1876 psppire_dict_get_variable (data_store->dict, column);
1878 if ( v && event->button == 3)
1881 gtk_sheet_select_column (sheet, column);
1883 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
1884 NULL, NULL, NULL, NULL,
1885 event->button, event->time);
1891 popup_cases_menu (GtkSheet *sheet, gint row,
1892 GdkEventButton *event, gpointer data)
1894 struct data_editor *de = data;
1896 PsppireDataStore *data_store =
1897 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1899 if ( row <= psppire_data_store_get_case_count (data_store) &&
1902 gtk_sheet_select_row (sheet, row);
1904 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
1905 NULL, NULL, NULL, NULL,
1906 event->button, event->time);
1912 on_edit_paste (GtkAction *a, gpointer data)
1914 GtkClipboard *clipboard = gtk_clipboard_get (GDK_SELECTION_CLIPBOARD);
1916 gtk_clipboard_request_contents (clipboard,
1917 gdk_atom_intern ("UTF8_STRING", TRUE),
1918 data_sheet_contents_received_callback,
1924 on_edit_copy (GtkMenuItem *m, gpointer data)
1926 struct data_editor *de = data;
1928 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
1931 data_sheet_set_clip (data_sheet);
1937 on_edit_cut (GtkMenuItem *m, gpointer data)
1939 struct data_editor *de = data;
1940 gint max_rows, max_columns;
1942 GtkSheetRange range;
1943 PsppireDataStore *ds;
1944 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
1947 data_sheet_set_clip (data_sheet);
1950 /* Now blank all the cells */
1951 gtk_sheet_get_selected_range (data_sheet, &range);
1953 ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1956 /* If nothing selected, then use active cell */
1957 if ( range.row0 < 0 || range.col0 < 0 )
1960 gtk_sheet_get_active_cell (data_sheet, &row, &col);
1962 range.row0 = range.rowi = row;
1963 range.col0 = range.coli = col;
1966 /* The sheet range can include cells that do not include data.
1967 Exclude them from the range. */
1968 max_rows = psppire_data_store_get_case_count (ds);
1969 if (range.rowi >= max_rows)
1973 range.rowi = max_rows - 1;
1976 max_columns = dict_get_var_cnt (ds->dict->dict);
1977 if (range.coli >= max_columns)
1979 if (max_columns == 0)
1981 range.coli = max_columns - 1;
1984 g_return_if_fail (range.rowi >= range.row0);
1985 g_return_if_fail (range.row0 >= 0);
1986 g_return_if_fail (range.coli >= range.col0);
1987 g_return_if_fail (range.col0 >= 0);
1990 for (r = range.row0; r <= range.rowi ; ++r )
1994 for (c = range.col0 ; c <= range.coli; ++c)
1996 psppire_data_store_set_string (ds, "", r, c);
2000 /* and remove the selection */
2001 gtk_sheet_unselect_range (data_sheet);