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 "recode-dialog.h"
42 #include "comments-dialog.h"
43 #include "variable-info-dialog.h"
44 #include "descriptives-dialog.h"
45 #include "crosstabs-dialog.h"
46 #include "frequencies-dialog.h"
47 #include "dict-display.h"
48 #include "clipboard.h"
50 #include "oneway-anova-dialog.h"
51 #include "t-test-independent-samples-dialog.h"
52 #include "t-test-one-sample.h"
53 #include "t-test-paired-samples.h"
55 #define _(msgid) gettext (msgid)
56 #define N_(msgid) msgid
58 #include "data-editor.h"
59 #include "syntax-editor.h"
60 #include <language/syntax-string-source.h>
61 #include <language/command.h>
62 #include <libpspp/syntax-gen.h>
63 #include "window-manager.h"
65 #include "psppire-data-store.h"
66 #include "psppire-var-store.h"
68 static void on_edit_copy (GtkMenuItem *, gpointer);
69 static void on_edit_cut (GtkMenuItem *, gpointer);
70 static void on_edit_paste (GtkAction *a, gpointer data);
73 static void create_data_sheet_variable_popup_menu (struct data_editor *);
74 static void create_data_sheet_cases_popup_menu (struct data_editor *);
76 static void popup_variable_menu (GtkSheet *, gint,
77 GdkEventButton *, gpointer data);
79 static void popup_cases_menu (GtkSheet *, gint,
80 GdkEventButton *, gpointer data);
82 /* Update the data_ref_entry with the reference of the active cell */
83 static gint update_data_ref_entry (const GtkSheet *sheet,
84 gint row, gint col, gpointer data);
86 static void register_data_editor_actions (struct data_editor *de);
88 static void insert_variable (GtkAction *, gpointer data);
89 static void insert_case (GtkAction *a, gpointer data);
90 static void delete_cases (GtkAction *a, gpointer data);
91 static void delete_variables (GtkAction *a, gpointer data);
93 static void toggle_value_labels (GtkToggleAction *a, gpointer data);
95 /* Switch between the VAR SHEET and the DATA SHEET */
97 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
98 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
101 /* Callback for when the dictionary changes properties*/
102 static void on_weight_change (GObject *, gint, gpointer);
103 static void on_filter_change (GObject *, gint, gpointer);
104 static void on_split_change (PsppireDict *, gpointer);
106 static void on_switch_sheet (GtkNotebook *notebook,
107 GtkNotebookPage *page,
111 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
113 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
115 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
117 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
119 static void fonts_activate (GtkMenuItem *, gpointer);
121 static void file_quit (GtkCheckMenuItem *, gpointer );
124 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
126 struct data_editor *de = data;
128 gtk_action_set_visible (de->delete_cases, var != -1);
133 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
135 struct data_editor *de = data;
137 gtk_action_set_visible (de->delete_variables, var != -1);
142 /* Run the EXECUTE command. */
144 execute (GtkMenuItem *mi, gpointer data)
146 struct getl_interface *sss = create_syntax_string_source ("EXECUTE.");
148 execute_syntax (sss);
152 transformation_change_callback (bool transformations_pending,
155 struct data_editor *de = data;
156 GtkWidget *menuitem =
157 get_widget_assert (de->xml, "transform_run-pending");
158 GtkWidget *status_label =
159 get_widget_assert (de->xml, "case-counter-area");
161 gtk_widget_set_sensitive (menuitem, transformations_pending);
164 if ( transformations_pending)
165 gtk_label_set_text (GTK_LABEL (status_label),
166 _("Transformations Pending"));
168 gtk_label_set_text (GTK_LABEL (status_label), "");
172 static void open_data_file (const gchar *, struct data_editor *);
175 /* Puts FILE_NAME into the recent list.
176 If it's already in the list, it moves it to the top
179 add_most_recent (const char *file_name)
181 #if RECENT_LISTS_AVAILABLE
183 GtkRecentManager *manager = gtk_recent_manager_get_default();
184 gchar *uri = g_filename_to_uri (file_name, NULL, NULL);
186 gtk_recent_manager_remove_item (manager, uri, NULL);
188 if ( ! gtk_recent_manager_add_item (manager, uri))
189 g_warning ("Could not add item %s to recent list\n",uri);
197 #if RECENT_LISTS_AVAILABLE
200 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
203 struct data_editor *de = user_data;
206 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
208 file = g_filename_from_uri (uri, NULL, NULL);
212 open_data_file (file, de);
218 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
222 struct syntax_editor *se ;
225 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
227 file = g_filename_from_uri (uri, NULL, NULL);
231 se = (struct syntax_editor *)
232 window_create (WINDOW_SYNTAX, file);
234 load_editor_from_file (se, file, NULL);
242 datum_entry_activate (GtkEntry *entry, gpointer data)
245 GtkSheet *data_sheet = GTK_SHEET (data);
246 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
248 const char *text = gtk_entry_get_text (entry);
250 gtk_sheet_get_active_cell (data_sheet, &row, &column);
252 if ( row == -1 || column == -1)
255 psppire_data_store_set_string (store, text, row, column);
259 /* Update the Edit->Paste menuitem
260 If PAGE is not -1 , then it should be set to the current page of
261 the data editors notebook widget.
262 If -1, then it'll be queried.
265 update_paste_menuitem (struct data_editor *de, gint page)
267 GtkWidget * edit_paste = get_widget_assert (de->xml, "edit_paste");
268 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
269 GtkSheet * data_sheet ;
273 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
276 if ( PAGE_VAR_SHEET == page )
278 /* We don't yet support pasting to the var sheet */
279 gtk_widget_set_sensitive (edit_paste, FALSE);
283 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
285 gtk_sheet_get_active_cell (data_sheet, &row, &column);
287 if ( row < 0 || column < 0 )
288 gtk_widget_set_sensitive (edit_paste, FALSE);
290 gtk_widget_set_sensitive (edit_paste, TRUE);
293 /* Update the Edit->Cut and Edit->Copy menuitems
294 If PAGE is not -1 , then it should be set to the current page of
295 the data editors notebook widget.
296 If -1, then it'll be queried.
299 update_cut_copy_menuitem (struct data_editor *de, gint page)
301 GtkWidget * edit_copy = get_widget_assert (de->xml, "edit_copy");
302 GtkWidget * edit_cut = get_widget_assert (de->xml, "edit_cut");
303 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
304 GtkSheet * data_sheet ;
308 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
311 if ( PAGE_VAR_SHEET == page )
313 /* We don't yet support copying from the var sheet */
314 gtk_widget_set_sensitive (edit_copy, FALSE);
315 gtk_widget_set_sensitive (edit_cut, FALSE);
319 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
321 gtk_sheet_get_active_cell (data_sheet, &row, &column);
323 if ( row < 0 || column < 0 )
325 gtk_widget_set_sensitive (edit_copy, FALSE);
326 gtk_widget_set_sensitive (edit_cut, FALSE);
330 gtk_widget_set_sensitive (edit_copy, TRUE);
331 gtk_widget_set_sensitive (edit_cut, TRUE);
335 /* Callback for when the datasheet's active cell becomes active/inactive */
337 on_data_sheet_activate_change (GtkSheet *sheet,
338 gint row, gint column, gpointer data)
340 struct data_editor *de = data;
342 update_paste_menuitem (de, -1);
343 update_cut_copy_menuitem (de, -1);
348 extern struct dataset *the_dataset;
351 Create a new data editor.
354 new_data_editor (void)
356 struct data_editor *de ;
357 struct editor_window *e;
358 GtkSheet *var_sheet ;
359 GtkSheet *data_sheet ;
361 GtkWidget *datum_entry;
363 de = g_malloc0 (sizeof (*de));
365 e = (struct editor_window *) de;
367 de->xml = XML_NEW ("data-editor.glade");
370 dataset_add_transform_change_callback (the_dataset,
371 transformation_change_callback,
374 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
375 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
378 g_signal_connect (G_OBJECT (data_sheet), "activate",
379 G_CALLBACK (on_data_sheet_activate_change), de);
381 g_signal_connect (G_OBJECT (data_sheet), "deactivate",
382 G_CALLBACK (on_data_sheet_activate_change), de);
385 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
387 g_assert(vs); /* Traps a possible bug in win32 build */
389 g_signal_connect (G_OBJECT (data_sheet), "activate",
390 G_CALLBACK (update_data_ref_entry),
393 datum_entry = get_widget_assert (de->xml, "datum_entry");
395 g_signal_connect (G_OBJECT (datum_entry), "activate",
396 G_CALLBACK (datum_entry_activate),
399 g_signal_connect (vs->dict, "weight-changed",
400 G_CALLBACK (on_weight_change),
403 g_signal_connect (vs->dict, "filter-changed",
404 G_CALLBACK (on_filter_change),
407 g_signal_connect (vs->dict, "split-changed",
408 G_CALLBACK (on_split_change),
411 connect_help (de->xml);
415 g_signal_connect (get_widget_assert (de->xml, "edit_copy"),
417 G_CALLBACK (on_edit_copy), de);
419 g_signal_connect (get_widget_assert (de->xml, "edit_cut"),
421 G_CALLBACK (on_edit_cut), de);
424 register_data_editor_actions (de);
426 de->toggle_value_labels =
427 gtk_toggle_action_new ("toggle-value-labels",
429 _("Show/hide value labels"),
430 "pspp-value-labels");
432 g_signal_connect (de->toggle_value_labels, "activate",
433 G_CALLBACK (toggle_value_labels), de);
436 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
437 get_widget_assert (de->xml,
438 "togglebutton-value-labels"));
441 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
442 get_widget_assert (de->xml,
443 "view_value-labels"));
446 gtk_action_new ("clear-cases",
448 _("Delete the cases at the selected position(s)"),
451 g_signal_connect (de->delete_cases, "activate",
452 G_CALLBACK (delete_cases), de);
454 gtk_action_connect_proxy (de->delete_cases,
455 get_widget_assert (de->xml, "edit_clear-cases"));
457 g_signal_connect (get_widget_assert (de->xml, "edit_paste"), "activate",
458 G_CALLBACK (on_edit_paste), de);
460 gtk_action_set_visible (de->delete_cases, FALSE);
462 de->delete_variables =
463 gtk_action_new ("clear-variables",
465 _("Delete the variables at the selected position(s)"),
466 "pspp-clear-variables");
468 g_signal_connect (de->delete_variables, "activate",
469 G_CALLBACK (delete_variables), de);
471 gtk_action_connect_proxy (de->delete_variables,
472 get_widget_assert (de->xml, "edit_clear-variables")
475 gtk_action_set_visible (de->delete_variables, FALSE);
477 de->insert_variable =
478 gtk_action_new ("insert-variable",
479 _("Insert Variable"),
480 _("Create a new variable at the current position"),
481 "pspp-insert-variable");
483 g_signal_connect (de->insert_variable, "activate",
484 G_CALLBACK (insert_variable), de);
487 gtk_action_connect_proxy (de->insert_variable,
488 get_widget_assert (de->xml, "button-insert-variable")
491 gtk_action_connect_proxy (de->insert_variable,
492 get_widget_assert (de->xml, "edit_insert-variable")
497 gtk_action_new ("insert-case",
499 _("Create a new case at the current position"),
502 g_signal_connect (de->insert_case, "activate",
503 G_CALLBACK (insert_case), de);
506 gtk_action_connect_proxy (de->insert_case,
507 get_widget_assert (de->xml, "button-insert-case")
511 gtk_action_connect_proxy (de->insert_case,
512 get_widget_assert (de->xml, "edit_insert-case")
517 de->invoke_goto_dialog =
518 gtk_action_new ("goto-case-dialog",
520 _("Jump to a Case in the Data Sheet"),
524 gtk_action_connect_proxy (de->invoke_goto_dialog,
525 get_widget_assert (de->xml, "button-goto-case")
528 gtk_action_connect_proxy (de->invoke_goto_dialog,
529 get_widget_assert (de->xml, "edit_goto-case")
533 g_signal_connect (de->invoke_goto_dialog, "activate",
534 G_CALLBACK (goto_case_dialog), de);
537 de->invoke_weight_cases_dialog =
538 gtk_action_new ("weight-cases-dialog",
540 _("Weight cases by variable"),
541 "pspp-weight-cases");
543 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
544 G_CALLBACK (weight_cases_dialog), de);
547 de->invoke_transpose_dialog =
548 gtk_action_new ("transpose-dialog",
550 _("Transpose the cases with the variables"),
554 g_signal_connect (de->invoke_transpose_dialog, "activate",
555 G_CALLBACK (transpose_dialog), de);
559 de->invoke_split_file_dialog =
560 gtk_action_new ("split-file-dialog",
562 _("Split the active file"),
565 g_signal_connect (de->invoke_split_file_dialog, "activate",
566 G_CALLBACK (split_file_dialog), de);
570 de->invoke_sort_cases_dialog =
571 gtk_action_new ("sort-cases-dialog",
573 _("Sort cases in the active file"),
576 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
577 G_CALLBACK (sort_cases_dialog), de);
579 de->invoke_select_cases_dialog =
580 gtk_action_new ("select-cases-dialog",
582 _("Select cases from the active file"),
583 "pspp-select-cases");
585 g_signal_connect (de->invoke_select_cases_dialog, "activate",
586 G_CALLBACK (select_cases_dialog), de);
589 de->invoke_compute_dialog =
590 gtk_action_new ("compute-dialog",
592 _("Compute new values for a variable"),
595 g_signal_connect (de->invoke_compute_dialog, "activate",
596 G_CALLBACK (compute_dialog), de);
598 de->invoke_oneway_anova_dialog =
599 gtk_action_new ("oneway-anova",
601 _("Perform one way analysis of variance"),
604 g_signal_connect (de->invoke_oneway_anova_dialog, "activate",
605 G_CALLBACK (oneway_anova_dialog), de);
607 de->invoke_t_test_independent_samples_dialog =
608 gtk_action_new ("t-test-independent-samples",
609 _("_Independent Samples T Test"),
610 _("Calculate T Test for samples from independent groups"),
613 g_signal_connect (de->invoke_t_test_independent_samples_dialog, "activate",
614 G_CALLBACK (t_test_independent_samples_dialog), de);
617 de->invoke_t_test_paired_samples_dialog =
618 gtk_action_new ("t-test-paired-samples",
619 _("_Paired Samples T Test"),
620 _("Calculate T Test for paired samples"),
623 g_signal_connect (de->invoke_t_test_paired_samples_dialog, "activate",
624 G_CALLBACK (t_test_paired_samples_dialog), de);
627 de->invoke_t_test_one_sample_dialog =
628 gtk_action_new ("t-test-one-sample",
629 _("One _Sample T Test"),
630 _("Calculate T Test for sample from a single distribution"),
633 g_signal_connect (de->invoke_t_test_one_sample_dialog, "activate",
634 G_CALLBACK (t_test_one_sample_dialog), de);
637 de->invoke_comments_dialog =
638 gtk_action_new ("commments-dialog",
639 _("Data File Comments"),
640 _("Commentary text for the data file"),
643 g_signal_connect (de->invoke_comments_dialog, "activate",
644 G_CALLBACK (comments_dialog), de);
646 de->invoke_find_dialog =
647 gtk_action_new ("find-dialog",
652 g_signal_connect (de->invoke_find_dialog, "activate",
653 G_CALLBACK (find_dialog), de);
656 de->invoke_rank_dialog =
657 gtk_action_new ("rank-dialog",
662 g_signal_connect (de->invoke_rank_dialog, "activate",
663 G_CALLBACK (rank_dialog), de);
666 de->invoke_recode_same_dialog =
667 gtk_action_new ("recode-same-dialog",
668 _("Recode into _Same Variables"),
669 _("Recode values into the same Variables"),
672 g_signal_connect (de->invoke_recode_same_dialog, "activate",
673 G_CALLBACK (recode_same_dialog), de);
676 de->invoke_recode_different_dialog =
677 gtk_action_new ("recode-different-dialog",
678 _("Recode into _Different Variables"),
679 _("Recode values into different Variables"),
680 "pspp-recode-different");
682 g_signal_connect (de->invoke_recode_different_dialog, "activate",
683 G_CALLBACK (recode_different_dialog), de);
686 de->invoke_variable_info_dialog =
687 gtk_action_new ("variable-info-dialog",
689 _("Jump to Variable"),
690 "pspp-goto-variable");
692 g_signal_connect (de->invoke_variable_info_dialog, "activate",
693 G_CALLBACK (variable_info_dialog), de);
695 de->invoke_descriptives_dialog =
696 gtk_action_new ("descriptives-dialog",
698 _("Calculate descriptive statistics (mean, variance, ...)"),
699 "pspp-descriptives");
701 g_signal_connect (de->invoke_descriptives_dialog, "activate",
702 G_CALLBACK (descriptives_dialog), de);
705 de->invoke_frequencies_dialog =
706 gtk_action_new ("frequencies-dialog",
708 _("Generate frequency statistics"),
711 g_signal_connect (de->invoke_frequencies_dialog, "activate",
712 G_CALLBACK (frequencies_dialog), de);
714 de->invoke_crosstabs_dialog =
715 gtk_action_new ("crosstabs-dialog",
717 _("Generate crosstabulations"),
720 g_signal_connect (de->invoke_crosstabs_dialog, "activate",
721 G_CALLBACK (crosstabs_dialog), de);
724 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
726 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
728 G_CALLBACK (gtk_action_activate),
729 de->action_data_new);
731 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
733 G_CALLBACK (gtk_action_activate),
734 de->action_data_open);
736 #if RECENT_LISTS_AVAILABLE
738 GtkRecentManager *rm = gtk_recent_manager_get_default ();
739 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
740 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
741 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
743 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
745 GtkRecentFilter *filter = gtk_recent_filter_new ();
747 gtk_widget_show (recent_data);
748 gtk_widget_show (recent_files);
749 gtk_widget_show (recent_separator);
751 gtk_recent_filter_add_pattern (filter, "*.sav");
752 gtk_recent_filter_add_pattern (filter, "*.SAV");
754 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
756 gtk_widget_set_sensitive (recent_data, TRUE);
757 g_signal_connect (menu, "selection-done",
758 G_CALLBACK (on_recent_data_select), de);
760 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
763 filter = gtk_recent_filter_new ();
764 menu = gtk_recent_chooser_menu_new_for_manager (rm);
766 gtk_recent_filter_add_pattern (filter, "*.sps");
767 gtk_recent_filter_add_pattern (filter, "*.SPS");
769 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
771 gtk_widget_set_sensitive (recent_files, TRUE);
772 g_signal_connect (menu, "selection-done",
773 G_CALLBACK (on_recent_files_select), de);
775 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
779 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
781 G_CALLBACK (new_syntax_window),
784 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
786 G_CALLBACK (open_syntax_window),
789 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
791 G_CALLBACK (gtk_action_activate),
792 de->action_data_save);
794 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
796 G_CALLBACK (gtk_action_activate),
797 de->action_data_save_as);
799 gtk_action_connect_proxy (de->invoke_find_dialog,
800 get_widget_assert (de->xml, "edit_find")
803 gtk_action_connect_proxy (de->invoke_find_dialog,
804 get_widget_assert (de->xml, "button-find")
807 gtk_action_connect_proxy (de->invoke_rank_dialog,
808 get_widget_assert (de->xml, "transform_rank")
811 gtk_action_connect_proxy (de->invoke_recode_same_dialog,
812 get_widget_assert (de->xml,
813 "transform_recode-same")
816 gtk_action_connect_proxy (de->invoke_recode_different_dialog,
817 get_widget_assert (de->xml,
818 "transform_recode-different")
821 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
822 get_widget_assert (de->xml, "data_weight-cases")
825 gtk_action_connect_proxy (de->invoke_transpose_dialog,
826 get_widget_assert (de->xml, "data_transpose")
829 gtk_action_connect_proxy (de->invoke_split_file_dialog,
830 get_widget_assert (de->xml, "data_split-file")
833 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
834 get_widget_assert (de->xml, "data_sort-cases")
837 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
838 get_widget_assert (de->xml, "data_select-cases")
841 gtk_action_connect_proxy (de->invoke_compute_dialog,
842 get_widget_assert (de->xml, "transform_compute")
845 gtk_action_connect_proxy (de->invoke_t_test_independent_samples_dialog,
846 get_widget_assert (de->xml,
851 gtk_action_connect_proxy (de->invoke_t_test_paired_samples_dialog,
852 get_widget_assert (de->xml,
857 gtk_action_connect_proxy (de->invoke_t_test_one_sample_dialog,
858 get_widget_assert (de->xml,
863 gtk_action_connect_proxy (de->invoke_oneway_anova_dialog,
864 get_widget_assert (de->xml,
869 gtk_action_connect_proxy (de->invoke_comments_dialog,
870 get_widget_assert (de->xml, "utilities_comments")
873 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
874 get_widget_assert (de->xml, "utilities_variables")
877 gtk_action_connect_proxy (de->invoke_descriptives_dialog,
878 get_widget_assert (de->xml, "analyze_descriptives")
881 gtk_action_connect_proxy (de->invoke_crosstabs_dialog,
882 get_widget_assert (de->xml, "crosstabs")
885 gtk_action_connect_proxy (de->invoke_frequencies_dialog,
886 get_widget_assert (de->xml, "analyze_frequencies")
889 g_signal_connect (get_widget_assert (de->xml,"help_about"),
891 G_CALLBACK (about_new),
895 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
897 G_CALLBACK (reference_manual),
900 g_signal_connect (data_sheet,
901 "double-click-column",
902 G_CALLBACK (click2column),
905 g_signal_connect (data_sheet,
907 G_CALLBACK (enable_delete_variables),
910 g_signal_connect (data_sheet,
912 G_CALLBACK (enable_delete_cases),
916 g_signal_connect (var_sheet,
918 GTK_SIGNAL_FUNC (click2row),
921 g_signal_connect_after (var_sheet,
923 G_CALLBACK (enable_delete_variables),
926 g_signal_connect (get_widget_assert (de->xml, "notebook"),
928 G_CALLBACK (on_switch_sheet), de);
931 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
933 G_CALLBACK (status_bar_activate), de);
936 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
938 G_CALLBACK (grid_lines_activate), de);
942 g_signal_connect (get_widget_assert (de->xml, "view_data"),
944 G_CALLBACK (data_sheet_activate), de);
946 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
948 G_CALLBACK (variable_sheet_activate), de);
952 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
954 G_CALLBACK (fonts_activate), de);
959 gtk_action_connect_proxy (de->action_data_open,
960 get_widget_assert (de->xml, "button-open")
963 gtk_action_connect_proxy (de->action_data_save,
964 get_widget_assert (de->xml, "button-save")
967 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
968 get_widget_assert (de->xml, "button-goto-variable")
971 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
972 get_widget_assert (de->xml, "button-weight-cases")
975 gtk_action_connect_proxy (de->invoke_split_file_dialog,
976 get_widget_assert (de->xml, "button-split-file")
979 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
980 get_widget_assert (de->xml, "button-select-cases")
984 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
986 G_CALLBACK (file_quit), de);
988 g_signal_connect (get_widget_assert (de->xml, "transform_run-pending"),
990 G_CALLBACK (execute), de);
993 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
995 G_CALLBACK (minimise_all_windows), NULL);
998 create_data_sheet_variable_popup_menu (de);
999 create_data_sheet_cases_popup_menu (de);
1001 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
1002 G_CALLBACK (popup_variable_menu), de);
1004 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
1005 G_CALLBACK (popup_cases_menu), de);
1011 /* Callback which occurs when the var sheet's row title
1012 button is double clicked */
1014 click2row (GtkWidget *w, gint row, gpointer data)
1016 struct data_editor *de = data;
1017 GtkSheetRange visible_range;
1019 gint current_row, current_column;
1021 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
1023 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1025 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
1026 ¤t_row, ¤t_column);
1028 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
1030 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
1032 if ( row < visible_range.col0 || row > visible_range.coli)
1034 gtk_sheet_moveto (GTK_SHEET (data_sheet),
1035 current_row, row, 0, 0);
1042 /* Callback which occurs when the data sheet's column title
1043 is double clicked */
1045 click2column (GtkWidget *w, gint col, gpointer data)
1047 struct data_editor *de = data;
1049 gint current_row, current_column;
1051 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
1053 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1055 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
1056 ¤t_row, ¤t_column);
1058 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
1065 new_data_window (GtkMenuItem *menuitem, gpointer parent)
1067 window_create (WINDOW_DATA, NULL);
1070 /* Callback for when the datasheet/varsheet is selected */
1072 on_switch_sheet (GtkNotebook *notebook,
1073 GtkNotebookPage *page,
1077 struct data_editor *de = user_data;
1079 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
1080 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
1084 case PAGE_VAR_SHEET:
1085 gtk_widget_hide (view_variables);
1086 gtk_widget_show (view_data);
1087 gtk_action_set_sensitive (de->insert_variable, TRUE);
1088 gtk_action_set_sensitive (de->insert_case, FALSE);
1089 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
1091 case PAGE_DATA_SHEET:
1092 gtk_widget_show (view_variables);
1093 gtk_widget_show (view_data);
1094 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
1095 gtk_action_set_sensitive (de->insert_case, TRUE);
1098 g_assert_not_reached ();
1102 update_paste_menuitem (de, page_num);
1103 update_cut_copy_menuitem (de, page_num);
1108 data_editor_select_sheet (struct data_editor *de, gint page)
1110 gtk_notebook_set_current_page
1112 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
1119 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
1121 struct data_editor *de = data;
1122 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
1124 if ( gtk_check_menu_item_get_active (menuitem) )
1125 gtk_widget_show (statusbar);
1127 gtk_widget_hide (statusbar);
1132 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
1134 struct data_editor *de = data;
1135 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
1137 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
1141 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
1148 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1150 struct data_editor *de = data;
1152 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1157 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1159 struct data_editor *de = data;
1161 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1166 fonts_activate (GtkMenuItem *menuitem, gpointer data)
1168 struct data_editor *de = data;
1170 gtk_font_selection_dialog_new (_("Font Selection"));
1172 gtk_window_set_transient_for (GTK_WINDOW (dialog),
1173 GTK_WINDOW (get_widget_assert (de->xml,
1175 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
1177 GtkSheet *data_sheet =
1178 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1180 GtkSheet *var_sheet =
1181 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1183 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1184 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
1186 const gchar *font = gtk_font_selection_dialog_get_font_name
1187 (GTK_FONT_SELECTION_DIALOG (dialog));
1189 PangoFontDescription* font_desc =
1190 pango_font_description_from_string (font);
1192 psppire_var_store_set_font (vs, font_desc);
1193 psppire_data_store_set_font (ds, font_desc);
1196 gtk_widget_hide (dialog);
1201 /* Callback for the value labels action */
1203 toggle_value_labels (GtkToggleAction *ta, gpointer data)
1205 struct data_editor *de = data;
1207 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1209 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1212 psppire_data_store_show_labels (ds,
1213 gtk_toggle_action_get_active (ta));
1216 extern PsppireDataStore *the_data_store ;
1219 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
1221 /* FIXME: Need to be more intelligent here.
1222 Give the user the opportunity to save any unsaved data.
1224 g_object_unref (the_data_store);
1229 delete_cases (GtkAction *action, gpointer data)
1231 struct data_editor *de = data;
1232 GtkSheet *data_sheet =
1233 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1235 GtkSheetRange range;
1237 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
1238 (gtk_sheet_get_model (data_sheet) );
1241 /* This shouldn't be able to happen, because the action
1242 should be disabled */
1243 g_return_if_fail (gtk_sheet_get_state (data_sheet)
1244 == GTK_SHEET_ROW_SELECTED );
1246 gtk_sheet_get_selected_range (data_sheet, &range);
1248 gtk_sheet_unselect_range (data_sheet);
1250 psppire_data_store_delete_cases (data_store, range.row0,
1251 1 + range.rowi - range.row0);
1256 delete_variables (GtkAction *a, gpointer data)
1258 struct data_editor *de = data;
1259 GtkSheetRange range;
1261 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
1264 const gint page = gtk_notebook_get_current_page (notebook);
1266 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
1267 (page == PAGE_VAR_SHEET) ?
1272 gtk_sheet_get_selected_range (sheet, &range);
1276 case PAGE_VAR_SHEET:
1278 PsppireVarStore *vs =
1279 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
1281 psppire_dict_delete_variables (vs->dict,
1288 case PAGE_DATA_SHEET:
1290 PsppireDataStore *ds =
1291 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1293 psppire_dict_delete_variables (ds->dict,
1302 gtk_sheet_unselect_range (sheet);
1306 insert_case (GtkAction *action, gpointer data)
1309 struct data_editor *de = data;
1311 GtkSheet *data_sheet =
1312 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1314 PsppireDataStore *ds = PSPPIRE_DATA_STORE
1315 (gtk_sheet_get_model (data_sheet) );
1318 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
1320 if (current_row < 0) current_row = 0;
1322 psppire_data_store_insert_new_case (ds, current_row);
1325 /* Insert a new variable before the current row in the variable sheet,
1326 or before the current column in the data sheet, whichever is selected */
1328 insert_variable (GtkAction *action, gpointer data)
1330 struct data_editor *de = data;
1333 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
1335 GtkSheet *var_sheet =
1336 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1338 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1339 (gtk_sheet_get_model (var_sheet) );
1341 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
1343 case PAGE_VAR_SHEET:
1344 posn = var_sheet->active_cell.row;
1346 case PAGE_DATA_SHEET:
1348 GtkSheet *data_sheet =
1349 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1351 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
1352 posn = data_sheet->range.col0;
1354 posn = data_sheet->active_cell.col;
1358 g_assert_not_reached ();
1361 if ( posn == -1 ) posn = 0;
1363 psppire_dict_insert_variable (vs->dict, posn, NULL);
1366 /* Callback for when the dictionary changes its split variables */
1368 on_split_change (PsppireDict *dict, gpointer data)
1370 struct data_editor *de = data;
1372 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1374 GtkWidget *split_status_area =
1375 get_widget_assert (de->xml, "split-file-status-area");
1377 if ( n_split_vars == 0 )
1379 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1385 const struct variable *const * split_vars =
1386 dict_get_split_vars (dict->dict);
1388 text = g_string_new (_("Split by "));
1390 for (i = 0 ; i < n_split_vars - 1; ++i )
1392 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1394 g_string_append (text, var_get_name (split_vars[i]));
1396 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1398 g_string_free (text, TRUE);
1403 /* Callback for when the dictionary changes its filter variable */
1405 on_filter_change (GObject *o, gint filter_index, gpointer data)
1407 struct data_editor *de = data;
1408 GtkWidget *filter_status_area =
1409 get_widget_assert (de->xml, "filter-use-status-area");
1411 if ( filter_index == -1 )
1413 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1417 GtkSheet *var_sheet =
1418 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1420 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1421 (gtk_sheet_get_model (var_sheet) );
1423 struct variable *var = psppire_dict_get_variable (vs->dict,
1426 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1428 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1434 /* Callback for when the dictionary changes its weights */
1436 on_weight_change (GObject *o, gint weight_index, gpointer data)
1438 struct data_editor *de = data;
1439 GtkWidget *weight_status_area =
1440 get_widget_assert (de->xml, "weight-status-area");
1442 if ( weight_index == -1 )
1444 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1448 GtkSheet *var_sheet =
1449 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1451 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1452 (gtk_sheet_get_model (var_sheet) );
1454 struct variable *var = psppire_dict_get_variable (vs->dict,
1457 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1459 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1468 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1469 static void new_file (GtkAction *, struct editor_window *de);
1470 static void open_data_dialog (GtkAction *, struct data_editor *de);
1471 static void data_save (GtkAction *action, struct data_editor *e);
1474 /* Create the GtkActions and connect to their signals */
1476 register_data_editor_actions (struct data_editor *de)
1478 de->action_data_open =
1479 gtk_action_new ("data-open-dialog",
1481 _("Open a data file"),
1484 g_signal_connect (de->action_data_open, "activate",
1485 G_CALLBACK (open_data_dialog), de);
1488 de->action_data_save = gtk_action_new ("data-save",
1490 _("Save data to file"),
1493 g_signal_connect (de->action_data_save, "activate",
1494 G_CALLBACK (data_save), de);
1498 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1500 _("Save data to file"),
1503 g_signal_connect (de->action_data_save_as, "activate",
1504 G_CALLBACK (data_save_as_dialog), de);
1506 de->action_data_new =
1507 gtk_action_new ("data-new",
1512 g_signal_connect (de->action_data_new, "activate",
1513 G_CALLBACK (new_file), de);
1516 /* Returns true if NAME has a suffix which might denote a PSPP file */
1518 name_has_suffix (const gchar *name)
1520 if ( g_str_has_suffix (name, ".sav"))
1522 if ( g_str_has_suffix (name, ".SAV"))
1524 if ( g_str_has_suffix (name, ".por"))
1526 if ( g_str_has_suffix (name, ".POR"))
1532 /* Append SUFFIX to the filename of DE */
1534 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1536 if ( ! name_has_suffix (de->file_name))
1538 gchar *s = de->file_name;
1539 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1544 /* Save DE to file */
1546 save_file (struct data_editor *de)
1548 struct getl_interface *sss;
1549 struct string file_name ;
1551 g_assert (de->file_name);
1553 ds_init_cstr (&file_name, de->file_name);
1554 gen_quoted_string (&file_name);
1556 if ( de->save_as_portable )
1558 append_filename_suffix (de, ".por");
1559 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1560 ds_cstr (&file_name));
1564 append_filename_suffix (de, ".sav");
1565 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1566 ds_cstr (&file_name));
1569 ds_destroy (&file_name);
1571 execute_syntax (sss);
1575 /* Callback for data_save action.
1576 If there's an existing file name, then just save,
1577 otherwise prompt for a file name, then save */
1579 data_save (GtkAction *action, struct data_editor *de)
1584 data_save_as_dialog (action, de);
1588 /* Callback for data_save_as action. Prompt for a filename and save */
1590 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1592 struct editor_window *e = (struct editor_window *) de;
1594 GtkWidget *button_sys;
1596 gtk_file_chooser_dialog_new (_("Save"),
1597 GTK_WINDOW (e->window),
1598 GTK_FILE_CHOOSER_ACTION_SAVE,
1599 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1600 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1603 GtkFileFilter *filter = gtk_file_filter_new ();
1604 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1605 gtk_file_filter_add_pattern (filter, "*.sav");
1606 gtk_file_filter_add_pattern (filter, "*.SAV");
1607 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1609 filter = gtk_file_filter_new ();
1610 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1611 gtk_file_filter_add_pattern (filter, "*.por");
1612 gtk_file_filter_add_pattern (filter, "*.POR");
1613 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1615 filter = gtk_file_filter_new ();
1616 gtk_file_filter_set_name (filter, _("All Files"));
1617 gtk_file_filter_add_pattern (filter, "*");
1618 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1621 GtkWidget *button_por;
1622 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1624 gtk_radio_button_new_with_label (NULL, _("System File"));
1627 gtk_radio_button_new_with_label
1628 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1629 _("Portable File"));
1631 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1632 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1634 gtk_widget_show_all (vbox);
1636 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1639 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1641 case GTK_RESPONSE_ACCEPT:
1643 g_free (de->file_name);
1646 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1648 de->save_as_portable =
1649 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1653 window_set_name_from_filename (e, de->file_name);
1660 gtk_widget_destroy (dialog);
1664 /* Callback for data_new action.
1665 Performs the NEW FILE command */
1667 new_file (GtkAction *action, struct editor_window *e)
1669 struct data_editor *de = (struct data_editor *) e;
1671 struct getl_interface *sss =
1672 create_syntax_string_source ("NEW FILE.");
1674 execute_syntax (sss);
1676 g_free (de->file_name);
1677 de->file_name = NULL;
1679 default_window_name (e);
1684 open_data_file (const gchar *file_name, struct data_editor *de)
1686 struct getl_interface *sss;
1687 struct string filename;
1689 ds_init_cstr (&filename, file_name);
1691 gen_quoted_string (&filename);
1693 sss = create_syntax_string_source ("GET FILE=%s.",
1694 ds_cstr (&filename));
1695 ds_destroy (&filename);
1697 if (execute_syntax (sss) )
1699 window_set_name_from_filename ((struct editor_window *) de, file_name);
1700 add_most_recent (file_name);
1706 /* Callback for the data_open action.
1707 Prompts for a filename and opens it */
1709 open_data_dialog (GtkAction *action, struct data_editor *de)
1711 struct editor_window *e = (struct editor_window *) de;
1714 gtk_file_chooser_dialog_new (_("Open"),
1715 GTK_WINDOW (e->window),
1716 GTK_FILE_CHOOSER_ACTION_OPEN,
1717 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1718 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1721 GtkFileFilter *filter = gtk_file_filter_new ();
1722 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1723 gtk_file_filter_add_pattern (filter, "*.sav");
1724 gtk_file_filter_add_pattern (filter, "*.SAV");
1725 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1727 filter = gtk_file_filter_new ();
1728 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1729 gtk_file_filter_add_pattern (filter, "*.por");
1730 gtk_file_filter_add_pattern (filter, "*.POR");
1731 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1733 filter = gtk_file_filter_new ();
1734 gtk_file_filter_set_name (filter, _("All Files"));
1735 gtk_file_filter_add_pattern (filter, "*");
1736 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1741 gchar *dir_name = g_path_get_dirname (de->file_name);
1742 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1747 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1749 case GTK_RESPONSE_ACCEPT:
1751 g_free (de->file_name);
1753 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1755 open_data_file (de->file_name, de);
1762 gtk_widget_destroy (dialog);
1767 /* Update the data_ref_entry with the reference of the active cell */
1769 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1771 GtkEntry *datum_entry;
1772 GladeXML *data_editor_xml = data;
1774 PsppireDataStore *data_store =
1775 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1777 g_return_val_if_fail (data_editor_xml, FALSE);
1781 GTK_ENTRY (get_widget_assert (data_editor_xml,
1786 const struct variable *var =
1787 psppire_dict_get_variable (data_store->dict, col);
1789 /* The entry where the reference to the current cell is displayed */
1790 GtkEntry *cell_ref_entry =
1791 GTK_ENTRY (get_widget_assert (data_editor_xml,
1795 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1796 var_get_name (var));
1798 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1802 gtk_entry_set_text (cell_ref_entry, s);
1812 psppire_data_store_get_string (data_store, row,
1813 var_get_dict_index(var));
1820 gtk_entry_set_text (datum_entry, text);
1832 gtk_entry_set_text (datum_entry, "");
1842 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1844 GString *string = g_string_new ("SORT CASES BY ");
1846 const struct variable *v =
1847 psppire_dict_get_variable (ds->dict, var);
1849 g_string_append_printf (string, "%s", var_get_name (v));
1852 g_string_append (string, " (D)");
1854 g_string_append (string, ".");
1856 execute_syntax (create_syntax_string_source (string->str));
1858 g_string_free (string, TRUE);
1863 sort_up (GtkMenuItem *item, gpointer data)
1865 GtkSheet *sheet = data;
1866 GtkSheetRange range;
1867 gtk_sheet_get_selected_range (sheet, &range);
1869 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1875 sort_down (GtkMenuItem *item, gpointer data)
1877 GtkSheet *sheet = data;
1878 GtkSheetRange range;
1879 gtk_sheet_get_selected_range (sheet, &range);
1881 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1889 create_data_sheet_variable_popup_menu (struct data_editor *de)
1891 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1892 GtkWidget *menu = gtk_menu_new ();
1894 GtkWidget *sort_ascending =
1895 gtk_menu_item_new_with_label (_("Sort Ascending"));
1897 GtkWidget *sort_descending =
1898 gtk_menu_item_new_with_label (_("Sort Descending"));
1901 GtkWidget *insert_variable =
1902 gtk_menu_item_new_with_label (_("Insert Variable"));
1904 GtkWidget *clear_variable =
1905 gtk_menu_item_new_with_label (_("Clear"));
1908 gtk_action_connect_proxy (de->insert_variable,
1912 gtk_action_connect_proxy (de->delete_variables,
1916 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1919 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1920 gtk_separator_menu_item_new ());
1923 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1926 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1927 gtk_separator_menu_item_new ());
1930 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1931 G_CALLBACK (sort_up), sheet);
1933 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1936 g_signal_connect (G_OBJECT (sort_descending), "activate",
1937 G_CALLBACK (sort_down), sheet);
1940 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1942 gtk_widget_show_all (menu);
1945 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1950 create_data_sheet_cases_popup_menu (struct data_editor *de)
1952 GtkWidget *menu = gtk_menu_new ();
1954 GtkWidget *insert_case =
1955 gtk_menu_item_new_with_label (_("Insert Case"));
1957 GtkWidget *delete_case =
1958 gtk_menu_item_new_with_label (_("Clear"));
1961 gtk_action_connect_proxy (de->insert_case,
1965 gtk_action_connect_proxy (de->delete_cases,
1969 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
1972 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1973 gtk_separator_menu_item_new ());
1976 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
1979 gtk_widget_show_all (menu);
1982 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
1987 popup_variable_menu (GtkSheet *sheet, gint column,
1988 GdkEventButton *event, gpointer data)
1990 struct data_editor *de = data;
1992 PsppireDataStore *data_store =
1993 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1995 const struct variable *v =
1996 psppire_dict_get_variable (data_store->dict, column);
1998 if ( v && event->button == 3)
2001 gtk_sheet_select_column (sheet, column);
2003 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
2004 NULL, NULL, NULL, NULL,
2005 event->button, event->time);
2011 popup_cases_menu (GtkSheet *sheet, gint row,
2012 GdkEventButton *event, gpointer data)
2014 struct data_editor *de = data;
2016 PsppireDataStore *data_store =
2017 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
2019 if ( row <= psppire_data_store_get_case_count (data_store) &&
2022 gtk_sheet_select_row (sheet, row);
2024 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
2025 NULL, NULL, NULL, NULL,
2026 event->button, event->time);
2032 on_edit_paste (GtkAction *a, gpointer data)
2034 GtkClipboard *clipboard = gtk_clipboard_get (GDK_SELECTION_CLIPBOARD);
2036 gtk_clipboard_request_contents (clipboard,
2037 gdk_atom_intern ("UTF8_STRING", TRUE),
2038 data_sheet_contents_received_callback,
2044 on_edit_copy (GtkMenuItem *m, gpointer data)
2046 struct data_editor *de = data;
2048 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
2051 data_sheet_set_clip (data_sheet);
2057 on_edit_cut (GtkMenuItem *m, gpointer data)
2059 struct data_editor *de = data;
2060 gint max_rows, max_columns;
2062 GtkSheetRange range;
2063 PsppireDataStore *ds;
2064 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
2067 data_sheet_set_clip (data_sheet);
2070 /* Now blank all the cells */
2071 gtk_sheet_get_selected_range (data_sheet, &range);
2073 ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
2076 /* If nothing selected, then use active cell */
2077 if ( range.row0 < 0 || range.col0 < 0 )
2080 gtk_sheet_get_active_cell (data_sheet, &row, &col);
2082 range.row0 = range.rowi = row;
2083 range.col0 = range.coli = col;
2086 /* The sheet range can include cells that do not include data.
2087 Exclude them from the range. */
2088 max_rows = psppire_data_store_get_case_count (ds);
2089 if (range.rowi >= max_rows)
2093 range.rowi = max_rows - 1;
2096 max_columns = dict_get_var_cnt (ds->dict->dict);
2097 if (range.coli >= max_columns)
2099 if (max_columns == 0)
2101 range.coli = max_columns - 1;
2104 g_return_if_fail (range.rowi >= range.row0);
2105 g_return_if_fail (range.row0 >= 0);
2106 g_return_if_fail (range.coli >= range.col0);
2107 g_return_if_fail (range.col0 >= 0);
2110 for (r = range.row0; r <= range.rowi ; ++r )
2114 for (c = range.col0 ; c <= range.coli; ++c)
2116 psppire_data_store_set_string (ds, "", r, c);
2120 /* and remove the selection */
2121 gtk_sheet_unselect_range (data_sheet);