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 "text-data-import-dialog.h"
48 #include "dict-display.h"
49 #include "clipboard.h"
51 #include "oneway-anova-dialog.h"
52 #include "t-test-independent-samples-dialog.h"
53 #include "t-test-one-sample.h"
54 #include "t-test-paired-samples.h"
56 #define _(msgid) gettext (msgid)
57 #define N_(msgid) msgid
59 #include "data-editor.h"
60 #include "syntax-editor.h"
61 #include <language/syntax-string-source.h>
62 #include <language/command.h>
63 #include <libpspp/syntax-gen.h>
64 #include "window-manager.h"
66 #include "psppire-data-store.h"
67 #include "psppire-var-store.h"
69 static void on_edit_copy (GtkMenuItem *, gpointer);
70 static void on_edit_cut (GtkMenuItem *, gpointer);
71 static void on_edit_paste (GtkAction *a, gpointer data);
74 static void create_data_sheet_variable_popup_menu (struct data_editor *);
75 static void create_data_sheet_cases_popup_menu (struct data_editor *);
77 static void popup_variable_menu (GtkSheet *, gint,
78 GdkEventButton *, gpointer data);
80 static void popup_cases_menu (GtkSheet *, gint,
81 GdkEventButton *, gpointer data);
83 /* Update the data_ref_entry with the reference of the active cell */
84 static gint update_data_ref_entry (const GtkSheet *sheet,
85 gint row, gint col, gpointer data);
87 static void register_data_editor_actions (struct data_editor *de);
89 static void insert_variable (GtkAction *, gpointer data);
90 static void insert_case (GtkAction *a, gpointer data);
91 static void delete_cases (GtkAction *a, gpointer data);
92 static void delete_variables (GtkAction *a, gpointer data);
94 static void toggle_value_labels (GtkToggleAction *a, gpointer data);
96 /* Switch between the VAR SHEET and the DATA SHEET */
98 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
99 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
102 /* Callback for when the dictionary changes properties*/
103 static void on_weight_change (GObject *, gint, gpointer);
104 static void on_filter_change (GObject *, gint, gpointer);
105 static void on_split_change (PsppireDict *, gpointer);
107 static void on_switch_sheet (GtkNotebook *notebook,
108 GtkNotebookPage *page,
112 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
114 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
116 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
118 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
120 static void fonts_activate (GtkMenuItem *, gpointer);
122 static void file_quit (GtkCheckMenuItem *, gpointer );
125 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
127 struct data_editor *de = data;
129 gtk_action_set_visible (de->delete_cases, var != -1);
134 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
136 struct data_editor *de = data;
138 gtk_action_set_visible (de->delete_variables, var != -1);
143 /* Run the EXECUTE command. */
145 execute (GtkMenuItem *mi, gpointer data)
147 struct getl_interface *sss = create_syntax_string_source ("EXECUTE.");
149 execute_syntax (sss);
153 transformation_change_callback (bool transformations_pending,
156 struct data_editor *de = data;
157 GtkWidget *menuitem =
158 get_widget_assert (de->xml, "transform_run-pending");
159 GtkWidget *status_label =
160 get_widget_assert (de->xml, "case-counter-area");
162 gtk_widget_set_sensitive (menuitem, transformations_pending);
165 if ( transformations_pending)
166 gtk_label_set_text (GTK_LABEL (status_label),
167 _("Transformations Pending"));
169 gtk_label_set_text (GTK_LABEL (status_label), "");
173 static void open_data_file (const gchar *, struct data_editor *);
176 /* Puts FILE_NAME into the recent list.
177 If it's already in the list, it moves it to the top
180 add_most_recent (const char *file_name)
182 #if RECENT_LISTS_AVAILABLE
184 GtkRecentManager *manager = gtk_recent_manager_get_default();
185 gchar *uri = g_filename_to_uri (file_name, NULL, NULL);
187 gtk_recent_manager_remove_item (manager, uri, NULL);
189 if ( ! gtk_recent_manager_add_item (manager, uri))
190 g_warning ("Could not add item %s to recent list\n",uri);
198 #if RECENT_LISTS_AVAILABLE
201 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
204 struct data_editor *de = user_data;
207 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
209 file = g_filename_from_uri (uri, NULL, NULL);
213 open_data_file (file, de);
219 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
223 struct syntax_editor *se ;
226 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
228 file = g_filename_from_uri (uri, NULL, NULL);
232 se = (struct syntax_editor *)
233 window_create (WINDOW_SYNTAX, file);
235 load_editor_from_file (se, file, NULL);
243 datum_entry_activate (GtkEntry *entry, gpointer data)
246 GtkSheet *data_sheet = GTK_SHEET (data);
247 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
249 const char *text = gtk_entry_get_text (entry);
251 gtk_sheet_get_active_cell (data_sheet, &row, &column);
253 if ( row == -1 || column == -1)
256 psppire_data_store_set_string (store, text, row, column);
260 /* Update the Edit->Paste menuitem
261 If PAGE is not -1 , then it should be set to the current page of
262 the data editors notebook widget.
263 If -1, then it'll be queried.
266 update_paste_menuitem (struct data_editor *de, gint page)
268 GtkWidget * edit_paste = get_widget_assert (de->xml, "edit_paste");
269 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
270 GtkSheet * data_sheet ;
274 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
277 if ( PAGE_VAR_SHEET == page )
279 /* We don't yet support pasting to the var sheet */
280 gtk_widget_set_sensitive (edit_paste, FALSE);
284 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
286 gtk_sheet_get_active_cell (data_sheet, &row, &column);
288 if ( row < 0 || column < 0 )
289 gtk_widget_set_sensitive (edit_paste, FALSE);
291 gtk_widget_set_sensitive (edit_paste, TRUE);
294 /* Update the Edit->Cut and Edit->Copy menuitems
295 If PAGE is not -1 , then it should be set to the current page of
296 the data editors notebook widget.
297 If -1, then it'll be queried.
300 update_cut_copy_menuitem (struct data_editor *de, gint page)
302 GtkWidget * edit_copy = get_widget_assert (de->xml, "edit_copy");
303 GtkWidget * edit_cut = get_widget_assert (de->xml, "edit_cut");
304 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
305 GtkSheet * data_sheet ;
309 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
312 if ( PAGE_VAR_SHEET == page )
314 /* We don't yet support copying from the var sheet */
315 gtk_widget_set_sensitive (edit_copy, FALSE);
316 gtk_widget_set_sensitive (edit_cut, FALSE);
320 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
322 gtk_sheet_get_active_cell (data_sheet, &row, &column);
324 if ( row < 0 || column < 0 )
326 gtk_widget_set_sensitive (edit_copy, FALSE);
327 gtk_widget_set_sensitive (edit_cut, FALSE);
331 gtk_widget_set_sensitive (edit_copy, TRUE);
332 gtk_widget_set_sensitive (edit_cut, TRUE);
336 /* Callback for when the datasheet's active cell becomes active/inactive */
338 on_data_sheet_activate_change (GtkSheet *sheet,
339 gint row, gint column, gpointer data)
341 struct data_editor *de = data;
343 update_paste_menuitem (de, -1);
344 update_cut_copy_menuitem (de, -1);
349 extern struct dataset *the_dataset;
352 Create a new data editor.
355 new_data_editor (void)
357 struct data_editor *de ;
358 struct editor_window *e;
359 GtkSheet *var_sheet ;
360 GtkSheet *data_sheet ;
362 GtkWidget *datum_entry;
364 de = g_malloc0 (sizeof (*de));
366 e = (struct editor_window *) de;
368 de->xml = XML_NEW ("data-editor.glade");
371 dataset_add_transform_change_callback (the_dataset,
372 transformation_change_callback,
375 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
376 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
379 g_signal_connect (G_OBJECT (data_sheet), "activate",
380 G_CALLBACK (on_data_sheet_activate_change), de);
382 g_signal_connect (G_OBJECT (data_sheet), "deactivate",
383 G_CALLBACK (on_data_sheet_activate_change), de);
386 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
388 g_assert(vs); /* Traps a possible bug in win32 build */
390 g_signal_connect (G_OBJECT (data_sheet), "activate",
391 G_CALLBACK (update_data_ref_entry),
394 datum_entry = get_widget_assert (de->xml, "datum_entry");
396 g_signal_connect (G_OBJECT (datum_entry), "activate",
397 G_CALLBACK (datum_entry_activate),
400 g_signal_connect (vs->dict, "weight-changed",
401 G_CALLBACK (on_weight_change),
404 g_signal_connect (vs->dict, "filter-changed",
405 G_CALLBACK (on_filter_change),
408 g_signal_connect (vs->dict, "split-changed",
409 G_CALLBACK (on_split_change),
412 connect_help (de->xml);
416 g_signal_connect (get_widget_assert (de->xml, "edit_copy"),
418 G_CALLBACK (on_edit_copy), de);
420 g_signal_connect (get_widget_assert (de->xml, "edit_cut"),
422 G_CALLBACK (on_edit_cut), de);
425 register_data_editor_actions (de);
427 de->toggle_value_labels =
428 gtk_toggle_action_new ("toggle-value-labels",
430 _("Show/hide value labels"),
431 "pspp-value-labels");
433 g_signal_connect (de->toggle_value_labels, "activate",
434 G_CALLBACK (toggle_value_labels), de);
437 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
438 get_widget_assert (de->xml,
439 "togglebutton-value-labels"));
442 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
443 get_widget_assert (de->xml,
444 "view_value-labels"));
447 gtk_action_new ("clear-cases",
449 _("Delete the cases at the selected position(s)"),
452 g_signal_connect (de->delete_cases, "activate",
453 G_CALLBACK (delete_cases), de);
455 gtk_action_connect_proxy (de->delete_cases,
456 get_widget_assert (de->xml, "edit_clear-cases"));
458 g_signal_connect (get_widget_assert (de->xml, "edit_paste"), "activate",
459 G_CALLBACK (on_edit_paste), de);
461 gtk_action_set_visible (de->delete_cases, FALSE);
463 de->delete_variables =
464 gtk_action_new ("clear-variables",
466 _("Delete the variables at the selected position(s)"),
467 "pspp-clear-variables");
469 g_signal_connect (de->delete_variables, "activate",
470 G_CALLBACK (delete_variables), de);
472 gtk_action_connect_proxy (de->delete_variables,
473 get_widget_assert (de->xml, "edit_clear-variables")
476 gtk_action_set_visible (de->delete_variables, FALSE);
478 de->insert_variable =
479 gtk_action_new ("insert-variable",
480 _("Insert Variable"),
481 _("Create a new variable at the current position"),
482 "pspp-insert-variable");
484 g_signal_connect (de->insert_variable, "activate",
485 G_CALLBACK (insert_variable), de);
488 gtk_action_connect_proxy (de->insert_variable,
489 get_widget_assert (de->xml, "button-insert-variable")
492 gtk_action_connect_proxy (de->insert_variable,
493 get_widget_assert (de->xml, "edit_insert-variable")
498 gtk_action_new ("insert-case",
500 _("Create a new case at the current position"),
503 g_signal_connect (de->insert_case, "activate",
504 G_CALLBACK (insert_case), de);
507 gtk_action_connect_proxy (de->insert_case,
508 get_widget_assert (de->xml, "button-insert-case")
512 gtk_action_connect_proxy (de->insert_case,
513 get_widget_assert (de->xml, "edit_insert-case")
518 de->invoke_goto_dialog =
519 gtk_action_new ("goto-case-dialog",
521 _("Jump to a Case in the Data Sheet"),
525 gtk_action_connect_proxy (de->invoke_goto_dialog,
526 get_widget_assert (de->xml, "button-goto-case")
529 gtk_action_connect_proxy (de->invoke_goto_dialog,
530 get_widget_assert (de->xml, "edit_goto-case")
534 g_signal_connect (de->invoke_goto_dialog, "activate",
535 G_CALLBACK (goto_case_dialog), de);
538 de->invoke_weight_cases_dialog =
539 gtk_action_new ("weight-cases-dialog",
541 _("Weight cases by variable"),
542 "pspp-weight-cases");
544 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
545 G_CALLBACK (weight_cases_dialog), de);
548 de->invoke_transpose_dialog =
549 gtk_action_new ("transpose-dialog",
551 _("Transpose the cases with the variables"),
555 g_signal_connect (de->invoke_transpose_dialog, "activate",
556 G_CALLBACK (transpose_dialog), de);
560 de->invoke_split_file_dialog =
561 gtk_action_new ("split-file-dialog",
563 _("Split the active file"),
566 g_signal_connect (de->invoke_split_file_dialog, "activate",
567 G_CALLBACK (split_file_dialog), de);
571 de->invoke_sort_cases_dialog =
572 gtk_action_new ("sort-cases-dialog",
574 _("Sort cases in the active file"),
577 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
578 G_CALLBACK (sort_cases_dialog), de);
580 de->invoke_select_cases_dialog =
581 gtk_action_new ("select-cases-dialog",
583 _("Select cases from the active file"),
584 "pspp-select-cases");
586 g_signal_connect (de->invoke_select_cases_dialog, "activate",
587 G_CALLBACK (select_cases_dialog), de);
590 de->invoke_compute_dialog =
591 gtk_action_new ("compute-dialog",
593 _("Compute new values for a variable"),
596 g_signal_connect (de->invoke_compute_dialog, "activate",
597 G_CALLBACK (compute_dialog), de);
599 de->invoke_oneway_anova_dialog =
600 gtk_action_new ("oneway-anova",
602 _("Perform one way analysis of variance"),
605 g_signal_connect (de->invoke_oneway_anova_dialog, "activate",
606 G_CALLBACK (oneway_anova_dialog), de);
608 de->invoke_t_test_independent_samples_dialog =
609 gtk_action_new ("t-test-independent-samples",
610 _("_Independent Samples T Test"),
611 _("Calculate T Test for samples from independent groups"),
614 g_signal_connect (de->invoke_t_test_independent_samples_dialog, "activate",
615 G_CALLBACK (t_test_independent_samples_dialog), de);
618 de->invoke_t_test_paired_samples_dialog =
619 gtk_action_new ("t-test-paired-samples",
620 _("_Paired Samples T Test"),
621 _("Calculate T Test for paired samples"),
624 g_signal_connect (de->invoke_t_test_paired_samples_dialog, "activate",
625 G_CALLBACK (t_test_paired_samples_dialog), de);
628 de->invoke_t_test_one_sample_dialog =
629 gtk_action_new ("t-test-one-sample",
630 _("One _Sample T Test"),
631 _("Calculate T Test for sample from a single distribution"),
634 g_signal_connect (de->invoke_t_test_one_sample_dialog, "activate",
635 G_CALLBACK (t_test_one_sample_dialog), de);
638 de->invoke_comments_dialog =
639 gtk_action_new ("commments-dialog",
640 _("Data File Comments"),
641 _("Commentary text for the data file"),
644 g_signal_connect (de->invoke_comments_dialog, "activate",
645 G_CALLBACK (comments_dialog), de);
647 de->invoke_find_dialog =
648 gtk_action_new ("find-dialog",
653 g_signal_connect (de->invoke_find_dialog, "activate",
654 G_CALLBACK (find_dialog), de);
657 de->invoke_rank_dialog =
658 gtk_action_new ("rank-dialog",
663 g_signal_connect (de->invoke_rank_dialog, "activate",
664 G_CALLBACK (rank_dialog), de);
667 de->invoke_recode_same_dialog =
668 gtk_action_new ("recode-same-dialog",
669 _("Recode into _Same Variables"),
670 _("Recode values into the same Variables"),
673 g_signal_connect (de->invoke_recode_same_dialog, "activate",
674 G_CALLBACK (recode_same_dialog), de);
677 de->invoke_recode_different_dialog =
678 gtk_action_new ("recode-different-dialog",
679 _("Recode into _Different Variables"),
680 _("Recode values into different Variables"),
681 "pspp-recode-different");
683 g_signal_connect (de->invoke_recode_different_dialog, "activate",
684 G_CALLBACK (recode_different_dialog), de);
687 de->invoke_variable_info_dialog =
688 gtk_action_new ("variable-info-dialog",
690 _("Jump to Variable"),
691 "pspp-goto-variable");
693 g_signal_connect (de->invoke_variable_info_dialog, "activate",
694 G_CALLBACK (variable_info_dialog), de);
696 de->invoke_descriptives_dialog =
697 gtk_action_new ("descriptives-dialog",
699 _("Calculate descriptive statistics (mean, variance, ...)"),
700 "pspp-descriptives");
702 g_signal_connect (de->invoke_descriptives_dialog, "activate",
703 G_CALLBACK (descriptives_dialog), de);
706 de->invoke_frequencies_dialog =
707 gtk_action_new ("frequencies-dialog",
709 _("Generate frequency statistics"),
712 g_signal_connect (de->invoke_frequencies_dialog, "activate",
713 G_CALLBACK (frequencies_dialog), de);
715 de->invoke_crosstabs_dialog =
716 gtk_action_new ("crosstabs-dialog",
718 _("Generate crosstabulations"),
721 g_signal_connect (de->invoke_crosstabs_dialog, "activate",
722 G_CALLBACK (crosstabs_dialog), de);
725 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
727 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
729 G_CALLBACK (gtk_action_activate),
730 de->action_data_new);
732 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
734 G_CALLBACK (gtk_action_activate),
735 de->action_data_open);
737 #if RECENT_LISTS_AVAILABLE
739 GtkRecentManager *rm = gtk_recent_manager_get_default ();
740 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
741 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
742 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
744 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
746 GtkRecentFilter *filter = gtk_recent_filter_new ();
748 gtk_widget_show (recent_data);
749 gtk_widget_show (recent_files);
750 gtk_widget_show (recent_separator);
752 gtk_recent_filter_add_pattern (filter, "*.sav");
753 gtk_recent_filter_add_pattern (filter, "*.SAV");
755 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
757 gtk_widget_set_sensitive (recent_data, TRUE);
758 g_signal_connect (menu, "selection-done",
759 G_CALLBACK (on_recent_data_select), de);
761 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
764 filter = gtk_recent_filter_new ();
765 menu = gtk_recent_chooser_menu_new_for_manager (rm);
767 gtk_recent_filter_add_pattern (filter, "*.sps");
768 gtk_recent_filter_add_pattern (filter, "*.SPS");
770 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
772 gtk_widget_set_sensitive (recent_files, TRUE);
773 g_signal_connect (menu, "selection-done",
774 G_CALLBACK (on_recent_files_select), de);
776 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
780 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
782 G_CALLBACK (new_syntax_window),
785 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
787 G_CALLBACK (open_syntax_window),
790 g_signal_connect_swapped (get_widget_assert (de->xml,"file_import-text"),
792 G_CALLBACK (gtk_action_activate),
793 de->invoke_text_import_assistant);
795 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
797 G_CALLBACK (gtk_action_activate),
798 de->action_data_save);
800 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
802 G_CALLBACK (gtk_action_activate),
803 de->action_data_save_as);
805 gtk_action_connect_proxy (de->invoke_find_dialog,
806 get_widget_assert (de->xml, "edit_find")
809 gtk_action_connect_proxy (de->invoke_find_dialog,
810 get_widget_assert (de->xml, "button-find")
813 gtk_action_connect_proxy (de->invoke_rank_dialog,
814 get_widget_assert (de->xml, "transform_rank")
817 gtk_action_connect_proxy (de->invoke_recode_same_dialog,
818 get_widget_assert (de->xml,
819 "transform_recode-same")
822 gtk_action_connect_proxy (de->invoke_recode_different_dialog,
823 get_widget_assert (de->xml,
824 "transform_recode-different")
827 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
828 get_widget_assert (de->xml, "data_weight-cases")
831 gtk_action_connect_proxy (de->invoke_transpose_dialog,
832 get_widget_assert (de->xml, "data_transpose")
835 gtk_action_connect_proxy (de->invoke_split_file_dialog,
836 get_widget_assert (de->xml, "data_split-file")
839 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
840 get_widget_assert (de->xml, "data_sort-cases")
843 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
844 get_widget_assert (de->xml, "data_select-cases")
847 gtk_action_connect_proxy (de->invoke_compute_dialog,
848 get_widget_assert (de->xml, "transform_compute")
851 gtk_action_connect_proxy (de->invoke_t_test_independent_samples_dialog,
852 get_widget_assert (de->xml,
857 gtk_action_connect_proxy (de->invoke_t_test_paired_samples_dialog,
858 get_widget_assert (de->xml,
863 gtk_action_connect_proxy (de->invoke_t_test_one_sample_dialog,
864 get_widget_assert (de->xml,
869 gtk_action_connect_proxy (de->invoke_oneway_anova_dialog,
870 get_widget_assert (de->xml,
875 gtk_action_connect_proxy (de->invoke_comments_dialog,
876 get_widget_assert (de->xml, "utilities_comments")
879 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
880 get_widget_assert (de->xml, "utilities_variables")
883 gtk_action_connect_proxy (de->invoke_descriptives_dialog,
884 get_widget_assert (de->xml, "analyze_descriptives")
887 gtk_action_connect_proxy (de->invoke_crosstabs_dialog,
888 get_widget_assert (de->xml, "crosstabs")
891 gtk_action_connect_proxy (de->invoke_frequencies_dialog,
892 get_widget_assert (de->xml, "analyze_frequencies")
895 g_signal_connect (get_widget_assert (de->xml,"help_about"),
897 G_CALLBACK (about_new),
901 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
903 G_CALLBACK (reference_manual),
906 g_signal_connect (data_sheet,
907 "double-click-column",
908 G_CALLBACK (click2column),
911 g_signal_connect (data_sheet,
913 G_CALLBACK (enable_delete_variables),
916 g_signal_connect (data_sheet,
918 G_CALLBACK (enable_delete_cases),
922 g_signal_connect (var_sheet,
924 GTK_SIGNAL_FUNC (click2row),
927 g_signal_connect_after (var_sheet,
929 G_CALLBACK (enable_delete_variables),
932 g_signal_connect (get_widget_assert (de->xml, "notebook"),
934 G_CALLBACK (on_switch_sheet), de);
937 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
939 G_CALLBACK (status_bar_activate), de);
942 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
944 G_CALLBACK (grid_lines_activate), de);
948 g_signal_connect (get_widget_assert (de->xml, "view_data"),
950 G_CALLBACK (data_sheet_activate), de);
952 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
954 G_CALLBACK (variable_sheet_activate), de);
958 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
960 G_CALLBACK (fonts_activate), de);
965 gtk_action_connect_proxy (de->action_data_open,
966 get_widget_assert (de->xml, "button-open")
969 gtk_action_connect_proxy (de->action_data_save,
970 get_widget_assert (de->xml, "button-save")
973 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
974 get_widget_assert (de->xml, "button-goto-variable")
977 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
978 get_widget_assert (de->xml, "button-weight-cases")
981 gtk_action_connect_proxy (de->invoke_split_file_dialog,
982 get_widget_assert (de->xml, "button-split-file")
985 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
986 get_widget_assert (de->xml, "button-select-cases")
990 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
992 G_CALLBACK (file_quit), de);
994 g_signal_connect (get_widget_assert (de->xml, "transform_run-pending"),
996 G_CALLBACK (execute), de);
999 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
1001 G_CALLBACK (minimise_all_windows), NULL);
1004 create_data_sheet_variable_popup_menu (de);
1005 create_data_sheet_cases_popup_menu (de);
1007 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
1008 G_CALLBACK (popup_variable_menu), de);
1010 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
1011 G_CALLBACK (popup_cases_menu), de);
1017 /* Callback which occurs when the var sheet's row title
1018 button is double clicked */
1020 click2row (GtkWidget *w, gint row, gpointer data)
1022 struct data_editor *de = data;
1023 GtkSheetRange visible_range;
1025 gint current_row, current_column;
1027 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
1029 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1031 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
1032 ¤t_row, ¤t_column);
1034 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
1036 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
1038 if ( row < visible_range.col0 || row > visible_range.coli)
1040 gtk_sheet_moveto (GTK_SHEET (data_sheet),
1041 current_row, row, 0, 0);
1048 /* Callback which occurs when the data sheet's column title
1049 is double clicked */
1051 click2column (GtkWidget *w, gint col, gpointer data)
1053 struct data_editor *de = data;
1055 gint current_row, current_column;
1057 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
1059 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1061 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
1062 ¤t_row, ¤t_column);
1064 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
1071 new_data_window (GtkMenuItem *menuitem, gpointer parent)
1073 window_create (WINDOW_DATA, NULL);
1076 /* Callback for when the datasheet/varsheet is selected */
1078 on_switch_sheet (GtkNotebook *notebook,
1079 GtkNotebookPage *page,
1083 struct data_editor *de = user_data;
1085 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
1086 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
1090 case PAGE_VAR_SHEET:
1091 gtk_widget_hide (view_variables);
1092 gtk_widget_show (view_data);
1093 gtk_action_set_sensitive (de->insert_variable, TRUE);
1094 gtk_action_set_sensitive (de->insert_case, FALSE);
1095 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
1097 case PAGE_DATA_SHEET:
1098 gtk_widget_show (view_variables);
1099 gtk_widget_show (view_data);
1100 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
1101 gtk_action_set_sensitive (de->insert_case, TRUE);
1104 g_assert_not_reached ();
1108 update_paste_menuitem (de, page_num);
1109 update_cut_copy_menuitem (de, page_num);
1114 data_editor_select_sheet (struct data_editor *de, gint page)
1116 gtk_notebook_set_current_page
1118 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
1125 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
1127 struct data_editor *de = data;
1128 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
1130 if ( gtk_check_menu_item_get_active (menuitem) )
1131 gtk_widget_show (statusbar);
1133 gtk_widget_hide (statusbar);
1138 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
1140 struct data_editor *de = data;
1141 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
1143 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
1147 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
1154 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1156 struct data_editor *de = data;
1158 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1163 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1165 struct data_editor *de = data;
1167 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1172 fonts_activate (GtkMenuItem *menuitem, gpointer data)
1174 struct data_editor *de = data;
1176 gtk_font_selection_dialog_new (_("Font Selection"));
1178 gtk_window_set_transient_for (GTK_WINDOW (dialog),
1179 GTK_WINDOW (get_widget_assert (de->xml,
1181 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
1183 GtkSheet *data_sheet =
1184 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1186 GtkSheet *var_sheet =
1187 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1189 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1190 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
1192 const gchar *font = gtk_font_selection_dialog_get_font_name
1193 (GTK_FONT_SELECTION_DIALOG (dialog));
1195 PangoFontDescription* font_desc =
1196 pango_font_description_from_string (font);
1198 psppire_var_store_set_font (vs, font_desc);
1199 psppire_data_store_set_font (ds, font_desc);
1202 gtk_widget_hide (dialog);
1207 /* Callback for the value labels action */
1209 toggle_value_labels (GtkToggleAction *ta, gpointer data)
1211 struct data_editor *de = data;
1213 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1215 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1218 psppire_data_store_show_labels (ds,
1219 gtk_toggle_action_get_active (ta));
1222 extern PsppireDataStore *the_data_store ;
1225 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
1227 /* FIXME: Need to be more intelligent here.
1228 Give the user the opportunity to save any unsaved data.
1230 g_object_unref (the_data_store);
1235 delete_cases (GtkAction *action, gpointer data)
1237 struct data_editor *de = data;
1238 GtkSheet *data_sheet =
1239 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1241 GtkSheetRange range;
1243 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
1244 (gtk_sheet_get_model (data_sheet) );
1247 /* This shouldn't be able to happen, because the action
1248 should be disabled */
1249 g_return_if_fail (gtk_sheet_get_state (data_sheet)
1250 == GTK_SHEET_ROW_SELECTED );
1252 gtk_sheet_get_selected_range (data_sheet, &range);
1254 gtk_sheet_unselect_range (data_sheet);
1256 psppire_data_store_delete_cases (data_store, range.row0,
1257 1 + range.rowi - range.row0);
1262 delete_variables (GtkAction *a, gpointer data)
1264 struct data_editor *de = data;
1265 GtkSheetRange range;
1267 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
1270 const gint page = gtk_notebook_get_current_page (notebook);
1272 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
1273 (page == PAGE_VAR_SHEET) ?
1278 gtk_sheet_get_selected_range (sheet, &range);
1282 case PAGE_VAR_SHEET:
1284 PsppireVarStore *vs =
1285 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
1287 psppire_dict_delete_variables (vs->dict,
1294 case PAGE_DATA_SHEET:
1296 PsppireDataStore *ds =
1297 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1299 psppire_dict_delete_variables (ds->dict,
1308 gtk_sheet_unselect_range (sheet);
1312 insert_case (GtkAction *action, gpointer data)
1315 struct data_editor *de = data;
1317 GtkSheet *data_sheet =
1318 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1320 PsppireDataStore *ds = PSPPIRE_DATA_STORE
1321 (gtk_sheet_get_model (data_sheet) );
1324 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
1326 if (current_row < 0) current_row = 0;
1328 psppire_data_store_insert_new_case (ds, current_row);
1331 /* Insert a new variable before the current row in the variable sheet,
1332 or before the current column in the data sheet, whichever is selected */
1334 insert_variable (GtkAction *action, gpointer data)
1336 struct data_editor *de = data;
1339 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
1341 GtkSheet *var_sheet =
1342 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1344 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1345 (gtk_sheet_get_model (var_sheet) );
1347 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
1349 case PAGE_VAR_SHEET:
1350 posn = var_sheet->active_cell.row;
1352 case PAGE_DATA_SHEET:
1354 GtkSheet *data_sheet =
1355 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1357 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
1358 posn = data_sheet->range.col0;
1360 posn = data_sheet->active_cell.col;
1364 g_assert_not_reached ();
1367 if ( posn == -1 ) posn = 0;
1369 psppire_dict_insert_variable (vs->dict, posn, NULL);
1372 /* Callback for when the dictionary changes its split variables */
1374 on_split_change (PsppireDict *dict, gpointer data)
1376 struct data_editor *de = data;
1378 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1380 GtkWidget *split_status_area =
1381 get_widget_assert (de->xml, "split-file-status-area");
1383 if ( n_split_vars == 0 )
1385 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1391 const struct variable *const * split_vars =
1392 dict_get_split_vars (dict->dict);
1394 text = g_string_new (_("Split by "));
1396 for (i = 0 ; i < n_split_vars - 1; ++i )
1398 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1400 g_string_append (text, var_get_name (split_vars[i]));
1402 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1404 g_string_free (text, TRUE);
1409 /* Callback for when the dictionary changes its filter variable */
1411 on_filter_change (GObject *o, gint filter_index, gpointer data)
1413 struct data_editor *de = data;
1414 GtkWidget *filter_status_area =
1415 get_widget_assert (de->xml, "filter-use-status-area");
1417 if ( filter_index == -1 )
1419 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1423 GtkSheet *var_sheet =
1424 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1426 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1427 (gtk_sheet_get_model (var_sheet) );
1429 struct variable *var = psppire_dict_get_variable (vs->dict,
1432 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1434 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1440 /* Callback for when the dictionary changes its weights */
1442 on_weight_change (GObject *o, gint weight_index, gpointer data)
1444 struct data_editor *de = data;
1445 GtkWidget *weight_status_area =
1446 get_widget_assert (de->xml, "weight-status-area");
1448 if ( weight_index == -1 )
1450 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1454 GtkSheet *var_sheet =
1455 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1457 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1458 (gtk_sheet_get_model (var_sheet) );
1460 struct variable *var = psppire_dict_get_variable (vs->dict,
1463 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1465 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1474 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1475 static void new_file (GtkAction *, struct editor_window *de);
1476 static void open_data_dialog (GtkAction *, struct data_editor *de);
1477 static void data_save (GtkAction *action, struct data_editor *e);
1480 /* Create the GtkActions and connect to their signals */
1482 register_data_editor_actions (struct data_editor *de)
1484 de->action_data_open =
1485 gtk_action_new ("data-open-dialog",
1487 _("Open a data file"),
1490 g_signal_connect (de->action_data_open, "activate",
1491 G_CALLBACK (open_data_dialog), de);
1494 de->action_data_save = gtk_action_new ("data-save",
1496 _("Save data to file"),
1499 g_signal_connect (de->action_data_save, "activate",
1500 G_CALLBACK (data_save), de);
1504 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1506 _("Save data to file"),
1509 g_signal_connect (de->action_data_save_as, "activate",
1510 G_CALLBACK (data_save_as_dialog), de);
1512 de->action_data_new =
1513 gtk_action_new ("data-new",
1518 g_signal_connect (de->action_data_new, "activate",
1519 G_CALLBACK (new_file), de);
1521 de->invoke_text_import_assistant =
1522 gtk_action_new ("file_import-text",
1523 _("_Import Text Data"),
1524 _("Import text data file"),
1527 g_signal_connect (de->invoke_text_import_assistant, "activate",
1528 G_CALLBACK (text_data_import_assistant), de);
1531 /* Returns true if NAME has a suffix which might denote a PSPP file */
1533 name_has_suffix (const gchar *name)
1535 if ( g_str_has_suffix (name, ".sav"))
1537 if ( g_str_has_suffix (name, ".SAV"))
1539 if ( g_str_has_suffix (name, ".por"))
1541 if ( g_str_has_suffix (name, ".POR"))
1547 /* Append SUFFIX to the filename of DE */
1549 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1551 if ( ! name_has_suffix (de->file_name))
1553 gchar *s = de->file_name;
1554 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1559 /* Save DE to file */
1561 save_file (struct data_editor *de)
1563 struct getl_interface *sss;
1564 struct string file_name ;
1566 g_assert (de->file_name);
1568 ds_init_cstr (&file_name, de->file_name);
1569 gen_quoted_string (&file_name);
1571 if ( de->save_as_portable )
1573 append_filename_suffix (de, ".por");
1574 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1575 ds_cstr (&file_name));
1579 append_filename_suffix (de, ".sav");
1580 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1581 ds_cstr (&file_name));
1584 ds_destroy (&file_name);
1586 execute_syntax (sss);
1590 /* Callback for data_save action.
1591 If there's an existing file name, then just save,
1592 otherwise prompt for a file name, then save */
1594 data_save (GtkAction *action, struct data_editor *de)
1599 data_save_as_dialog (action, de);
1603 /* Callback for data_save_as action. Prompt for a filename and save */
1605 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1607 struct editor_window *e = (struct editor_window *) de;
1609 GtkWidget *button_sys;
1611 gtk_file_chooser_dialog_new (_("Save"),
1612 GTK_WINDOW (e->window),
1613 GTK_FILE_CHOOSER_ACTION_SAVE,
1614 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1615 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1618 GtkFileFilter *filter = gtk_file_filter_new ();
1619 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1620 gtk_file_filter_add_pattern (filter, "*.sav");
1621 gtk_file_filter_add_pattern (filter, "*.SAV");
1622 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1624 filter = gtk_file_filter_new ();
1625 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1626 gtk_file_filter_add_pattern (filter, "*.por");
1627 gtk_file_filter_add_pattern (filter, "*.POR");
1628 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1630 filter = gtk_file_filter_new ();
1631 gtk_file_filter_set_name (filter, _("All Files"));
1632 gtk_file_filter_add_pattern (filter, "*");
1633 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1636 GtkWidget *button_por;
1637 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1639 gtk_radio_button_new_with_label (NULL, _("System File"));
1642 gtk_radio_button_new_with_label
1643 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1644 _("Portable File"));
1646 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1647 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1649 gtk_widget_show_all (vbox);
1651 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1654 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1656 case GTK_RESPONSE_ACCEPT:
1658 g_free (de->file_name);
1661 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1663 de->save_as_portable =
1664 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1668 window_set_name_from_filename (e, de->file_name);
1675 gtk_widget_destroy (dialog);
1679 /* Callback for data_new action.
1680 Performs the NEW FILE command */
1682 new_file (GtkAction *action, struct editor_window *e)
1684 struct data_editor *de = (struct data_editor *) e;
1686 struct getl_interface *sss =
1687 create_syntax_string_source ("NEW FILE.");
1689 execute_syntax (sss);
1691 g_free (de->file_name);
1692 de->file_name = NULL;
1694 default_window_name (e);
1699 open_data_file (const gchar *file_name, struct data_editor *de)
1701 struct getl_interface *sss;
1702 struct string filename;
1704 ds_init_cstr (&filename, file_name);
1706 gen_quoted_string (&filename);
1708 sss = create_syntax_string_source ("GET FILE=%s.",
1709 ds_cstr (&filename));
1710 ds_destroy (&filename);
1712 if (execute_syntax (sss) )
1714 window_set_name_from_filename ((struct editor_window *) de, file_name);
1715 add_most_recent (file_name);
1721 /* Callback for the data_open action.
1722 Prompts for a filename and opens it */
1724 open_data_dialog (GtkAction *action, struct data_editor *de)
1726 struct editor_window *e = (struct editor_window *) de;
1729 gtk_file_chooser_dialog_new (_("Open"),
1730 GTK_WINDOW (e->window),
1731 GTK_FILE_CHOOSER_ACTION_OPEN,
1732 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1733 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1736 GtkFileFilter *filter = gtk_file_filter_new ();
1737 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1738 gtk_file_filter_add_pattern (filter, "*.sav");
1739 gtk_file_filter_add_pattern (filter, "*.SAV");
1740 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1742 filter = gtk_file_filter_new ();
1743 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1744 gtk_file_filter_add_pattern (filter, "*.por");
1745 gtk_file_filter_add_pattern (filter, "*.POR");
1746 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1748 filter = gtk_file_filter_new ();
1749 gtk_file_filter_set_name (filter, _("All Files"));
1750 gtk_file_filter_add_pattern (filter, "*");
1751 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1756 gchar *dir_name = g_path_get_dirname (de->file_name);
1757 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1762 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1764 case GTK_RESPONSE_ACCEPT:
1766 g_free (de->file_name);
1768 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1770 open_data_file (de->file_name, de);
1777 gtk_widget_destroy (dialog);
1782 /* Update the data_ref_entry with the reference of the active cell */
1784 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1786 GladeXML *data_editor_xml = data;
1788 PsppireDataStore *data_store =
1789 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1791 g_return_val_if_fail (data_editor_xml, FALSE);
1795 const struct variable *var =
1796 psppire_dict_get_variable (data_store->dict, col);
1798 /* The entry where the reference to the current cell is displayed */
1799 GtkEntry *cell_ref_entry =
1800 GTK_ENTRY (get_widget_assert (data_editor_xml,
1802 GtkEntry *datum_entry =
1803 GTK_ENTRY (get_widget_assert (data_editor_xml,
1808 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1809 var_get_name (var));
1811 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1815 gtk_entry_set_text (cell_ref_entry, s);
1820 gtk_entry_set_text (cell_ref_entry, "");
1826 psppire_data_store_get_string (data_store, row,
1827 var_get_dict_index(var));
1830 gtk_entry_set_text (datum_entry, text);
1835 gtk_entry_set_text (datum_entry, "");
1846 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1848 GString *string = g_string_new ("SORT CASES BY ");
1850 const struct variable *v =
1851 psppire_dict_get_variable (ds->dict, var);
1853 g_string_append_printf (string, "%s", var_get_name (v));
1856 g_string_append (string, " (D)");
1858 g_string_append (string, ".");
1860 execute_syntax (create_syntax_string_source (string->str));
1862 g_string_free (string, TRUE);
1867 sort_up (GtkMenuItem *item, gpointer data)
1869 GtkSheet *sheet = data;
1870 GtkSheetRange range;
1871 gtk_sheet_get_selected_range (sheet, &range);
1873 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1879 sort_down (GtkMenuItem *item, gpointer data)
1881 GtkSheet *sheet = data;
1882 GtkSheetRange range;
1883 gtk_sheet_get_selected_range (sheet, &range);
1885 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1893 create_data_sheet_variable_popup_menu (struct data_editor *de)
1895 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1896 GtkWidget *menu = gtk_menu_new ();
1898 GtkWidget *sort_ascending =
1899 gtk_menu_item_new_with_label (_("Sort Ascending"));
1901 GtkWidget *sort_descending =
1902 gtk_menu_item_new_with_label (_("Sort Descending"));
1905 GtkWidget *insert_variable =
1906 gtk_menu_item_new_with_label (_("Insert Variable"));
1908 GtkWidget *clear_variable =
1909 gtk_menu_item_new_with_label (_("Clear"));
1912 gtk_action_connect_proxy (de->insert_variable,
1916 gtk_action_connect_proxy (de->delete_variables,
1920 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1923 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1924 gtk_separator_menu_item_new ());
1927 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1930 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1931 gtk_separator_menu_item_new ());
1934 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1935 G_CALLBACK (sort_up), sheet);
1937 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1940 g_signal_connect (G_OBJECT (sort_descending), "activate",
1941 G_CALLBACK (sort_down), sheet);
1944 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1946 gtk_widget_show_all (menu);
1949 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1954 create_data_sheet_cases_popup_menu (struct data_editor *de)
1956 GtkWidget *menu = gtk_menu_new ();
1958 GtkWidget *insert_case =
1959 gtk_menu_item_new_with_label (_("Insert Case"));
1961 GtkWidget *delete_case =
1962 gtk_menu_item_new_with_label (_("Clear"));
1965 gtk_action_connect_proxy (de->insert_case,
1969 gtk_action_connect_proxy (de->delete_cases,
1973 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
1976 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1977 gtk_separator_menu_item_new ());
1980 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
1983 gtk_widget_show_all (menu);
1986 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
1991 popup_variable_menu (GtkSheet *sheet, gint column,
1992 GdkEventButton *event, gpointer data)
1994 struct data_editor *de = data;
1996 PsppireDataStore *data_store =
1997 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1999 const struct variable *v =
2000 psppire_dict_get_variable (data_store->dict, column);
2002 if ( v && event->button == 3)
2005 gtk_sheet_select_column (sheet, column);
2007 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
2008 NULL, NULL, NULL, NULL,
2009 event->button, event->time);
2015 popup_cases_menu (GtkSheet *sheet, gint row,
2016 GdkEventButton *event, gpointer data)
2018 struct data_editor *de = data;
2020 PsppireDataStore *data_store =
2021 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
2023 if ( row <= psppire_data_store_get_case_count (data_store) &&
2026 gtk_sheet_select_row (sheet, row);
2028 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
2029 NULL, NULL, NULL, NULL,
2030 event->button, event->time);
2036 on_edit_paste (GtkAction *a, gpointer data)
2038 GtkClipboard *clipboard = gtk_clipboard_get (GDK_SELECTION_CLIPBOARD);
2040 gtk_clipboard_request_contents (clipboard,
2041 gdk_atom_intern ("UTF8_STRING", TRUE),
2042 data_sheet_contents_received_callback,
2048 on_edit_copy (GtkMenuItem *m, gpointer data)
2050 struct data_editor *de = data;
2052 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
2055 data_sheet_set_clip (data_sheet);
2061 on_edit_cut (GtkMenuItem *m, gpointer data)
2063 struct data_editor *de = data;
2064 gint max_rows, max_columns;
2066 GtkSheetRange range;
2067 PsppireDataStore *ds;
2068 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
2071 data_sheet_set_clip (data_sheet);
2074 /* Now blank all the cells */
2075 gtk_sheet_get_selected_range (data_sheet, &range);
2077 ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
2080 /* If nothing selected, then use active cell */
2081 if ( range.row0 < 0 || range.col0 < 0 )
2084 gtk_sheet_get_active_cell (data_sheet, &row, &col);
2086 range.row0 = range.rowi = row;
2087 range.col0 = range.coli = col;
2090 /* The sheet range can include cells that do not include data.
2091 Exclude them from the range. */
2092 max_rows = psppire_data_store_get_case_count (ds);
2093 if (range.rowi >= max_rows)
2097 range.rowi = max_rows - 1;
2100 max_columns = dict_get_var_cnt (ds->dict->dict);
2101 if (range.coli >= max_columns)
2103 if (max_columns == 0)
2105 range.coli = max_columns - 1;
2108 g_return_if_fail (range.rowi >= range.row0);
2109 g_return_if_fail (range.row0 >= 0);
2110 g_return_if_fail (range.coli >= range.col0);
2111 g_return_if_fail (range.col0 >= 0);
2114 for (r = range.row0; r <= range.rowi ; ++r )
2118 for (c = range.col0 ; c <= range.coli; ++c)
2120 psppire_data_store_set_string (ds, "", r, c);
2124 /* and remove the selection */
2125 gtk_sheet_unselect_range (data_sheet);