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 "examine-dialog.h"
48 #include "dict-display.h"
49 #include "regression-dialog.h"
50 #include "clipboard.h"
52 #include "oneway-anova-dialog.h"
53 #include "t-test-independent-samples-dialog.h"
54 #include "t-test-one-sample.h"
55 #include "t-test-paired-samples.h"
57 #define _(msgid) gettext (msgid)
58 #define N_(msgid) msgid
60 #include "data-editor.h"
61 #include "syntax-editor.h"
62 #include <language/syntax-string-source.h>
63 #include <language/command.h>
64 #include <libpspp/syntax-gen.h>
65 #include "window-manager.h"
67 #include "psppire-data-store.h"
68 #include "psppire-var-store.h"
70 static void on_edit_copy (GtkMenuItem *, gpointer);
71 static void on_edit_cut (GtkMenuItem *, gpointer);
72 static void on_edit_paste (GtkAction *a, gpointer data);
75 static void create_data_sheet_variable_popup_menu (struct data_editor *);
76 static void create_data_sheet_cases_popup_menu (struct data_editor *);
78 static void popup_variable_menu (GtkSheet *, gint,
79 GdkEventButton *, gpointer data);
81 static void popup_cases_menu (GtkSheet *, gint,
82 GdkEventButton *, gpointer data);
84 /* Update the data_ref_entry with the reference of the active cell */
85 static gint update_data_ref_entry (const GtkSheet *sheet,
86 gint row, gint col, gpointer data);
88 static void register_data_editor_actions (struct data_editor *de);
90 static void insert_variable (GtkAction *, gpointer data);
91 static void insert_case (GtkAction *a, gpointer data);
92 static void delete_cases (GtkAction *a, gpointer data);
93 static void delete_variables (GtkAction *a, gpointer data);
95 static void toggle_value_labels (GtkToggleAction *a, gpointer data);
97 /* Switch between the VAR SHEET and the DATA SHEET */
99 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
100 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
103 /* Callback for when the dictionary changes properties*/
104 static void on_weight_change (GObject *, gint, gpointer);
105 static void on_filter_change (GObject *, gint, gpointer);
106 static void on_split_change (PsppireDict *, gpointer);
108 static void on_switch_sheet (GtkNotebook *notebook,
109 GtkNotebookPage *page,
113 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
115 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
117 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
119 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
121 static void fonts_activate (GtkMenuItem *, gpointer);
123 static void file_quit (GtkCheckMenuItem *, gpointer );
126 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
128 struct data_editor *de = data;
130 gtk_action_set_visible (de->delete_cases, var != -1);
135 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
137 struct data_editor *de = data;
139 gtk_action_set_visible (de->delete_variables, var != -1);
144 /* Run the EXECUTE command. */
146 execute (GtkMenuItem *mi, gpointer data)
148 struct getl_interface *sss = create_syntax_string_source ("EXECUTE.");
150 execute_syntax (sss);
154 transformation_change_callback (bool transformations_pending,
157 struct data_editor *de = data;
158 GtkWidget *menuitem =
159 get_widget_assert (de->xml, "transform_run-pending");
160 GtkWidget *status_label =
161 get_widget_assert (de->xml, "case-counter-area");
163 gtk_widget_set_sensitive (menuitem, transformations_pending);
166 if ( transformations_pending)
167 gtk_label_set_text (GTK_LABEL (status_label),
168 _("Transformations Pending"));
170 gtk_label_set_text (GTK_LABEL (status_label), "");
174 static void open_data_file (const gchar *, struct data_editor *);
177 /* Puts FILE_NAME into the recent list.
178 If it's already in the list, it moves it to the top
181 add_most_recent (const char *file_name)
183 #if RECENT_LISTS_AVAILABLE
185 GtkRecentManager *manager = gtk_recent_manager_get_default();
186 gchar *uri = g_filename_to_uri (file_name, NULL, NULL);
188 gtk_recent_manager_remove_item (manager, uri, NULL);
190 if ( ! gtk_recent_manager_add_item (manager, uri))
191 g_warning ("Could not add item %s to recent list\n",uri);
199 #if RECENT_LISTS_AVAILABLE
202 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
205 struct data_editor *de = user_data;
208 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
210 file = g_filename_from_uri (uri, NULL, NULL);
214 open_data_file (file, de);
220 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
224 struct syntax_editor *se ;
227 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
229 file = g_filename_from_uri (uri, NULL, NULL);
233 se = (struct syntax_editor *)
234 window_create (WINDOW_SYNTAX, file);
236 load_editor_from_file (se, file, NULL);
244 datum_entry_activate (GtkEntry *entry, gpointer data)
247 GtkSheet *data_sheet = GTK_SHEET (data);
248 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
250 const char *text = gtk_entry_get_text (entry);
252 gtk_sheet_get_active_cell (data_sheet, &row, &column);
254 if ( row == -1 || column == -1)
257 psppire_data_store_set_string (store, text, row, column);
261 /* Update the Edit->Paste menuitem
262 If PAGE is not -1 , then it should be set to the current page of
263 the data editors notebook widget.
264 If -1, then it'll be queried.
267 update_paste_menuitem (struct data_editor *de, gint page)
269 GtkWidget * edit_paste = get_widget_assert (de->xml, "edit_paste");
270 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
271 GtkSheet * data_sheet ;
275 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
278 if ( PAGE_VAR_SHEET == page )
280 /* We don't yet support pasting to the var sheet */
281 gtk_widget_set_sensitive (edit_paste, FALSE);
285 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
287 gtk_sheet_get_active_cell (data_sheet, &row, &column);
289 if ( row < 0 || column < 0 )
290 gtk_widget_set_sensitive (edit_paste, FALSE);
292 gtk_widget_set_sensitive (edit_paste, TRUE);
295 /* Update the Edit->Cut and Edit->Copy menuitems
296 If PAGE is not -1 , then it should be set to the current page of
297 the data editors notebook widget.
298 If -1, then it'll be queried.
301 update_cut_copy_menuitem (struct data_editor *de, gint page)
303 GtkWidget * edit_copy = get_widget_assert (de->xml, "edit_copy");
304 GtkWidget * edit_cut = get_widget_assert (de->xml, "edit_cut");
305 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
306 GtkSheet * data_sheet ;
310 page = gtk_notebook_get_current_page (GTK_NOTEBOOK(notebook));
313 if ( PAGE_VAR_SHEET == page )
315 /* We don't yet support copying from the var sheet */
316 gtk_widget_set_sensitive (edit_copy, FALSE);
317 gtk_widget_set_sensitive (edit_cut, FALSE);
321 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
323 gtk_sheet_get_active_cell (data_sheet, &row, &column);
325 if ( row < 0 || column < 0 )
327 gtk_widget_set_sensitive (edit_copy, FALSE);
328 gtk_widget_set_sensitive (edit_cut, FALSE);
332 gtk_widget_set_sensitive (edit_copy, TRUE);
333 gtk_widget_set_sensitive (edit_cut, TRUE);
337 /* Callback for when the datasheet's active cell becomes active/inactive */
339 on_data_sheet_activate_change (GtkSheet *sheet,
340 gint row, gint column, gpointer data)
342 struct data_editor *de = data;
344 update_paste_menuitem (de, -1);
345 update_cut_copy_menuitem (de, -1);
350 extern struct dataset *the_dataset;
353 Create a new data editor.
356 new_data_editor (void)
358 struct data_editor *de ;
359 struct editor_window *e;
360 GtkSheet *var_sheet ;
361 GtkSheet *data_sheet ;
363 GtkWidget *datum_entry;
365 de = g_malloc0 (sizeof (*de));
367 e = (struct editor_window *) de;
369 de->xml = XML_NEW ("data-editor.glade");
372 dataset_add_transform_change_callback (the_dataset,
373 transformation_change_callback,
376 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
377 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
380 g_signal_connect (G_OBJECT (data_sheet), "activate",
381 G_CALLBACK (on_data_sheet_activate_change), de);
383 g_signal_connect (G_OBJECT (data_sheet), "deactivate",
384 G_CALLBACK (on_data_sheet_activate_change), de);
387 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
389 g_assert(vs); /* Traps a possible bug in win32 build */
391 g_signal_connect (G_OBJECT (data_sheet), "activate",
392 G_CALLBACK (update_data_ref_entry),
395 datum_entry = get_widget_assert (de->xml, "datum_entry");
397 g_signal_connect (G_OBJECT (datum_entry), "activate",
398 G_CALLBACK (datum_entry_activate),
401 g_signal_connect (vs->dict, "weight-changed",
402 G_CALLBACK (on_weight_change),
405 g_signal_connect (vs->dict, "filter-changed",
406 G_CALLBACK (on_filter_change),
409 g_signal_connect (vs->dict, "split-changed",
410 G_CALLBACK (on_split_change),
413 connect_help (de->xml);
417 g_signal_connect (get_widget_assert (de->xml, "edit_copy"),
419 G_CALLBACK (on_edit_copy), de);
421 g_signal_connect (get_widget_assert (de->xml, "edit_cut"),
423 G_CALLBACK (on_edit_cut), de);
426 register_data_editor_actions (de);
428 de->toggle_value_labels =
429 gtk_toggle_action_new ("toggle-value-labels",
431 _("Show/hide value labels"),
432 "pspp-value-labels");
434 g_signal_connect (de->toggle_value_labels, "activate",
435 G_CALLBACK (toggle_value_labels), de);
438 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
439 get_widget_assert (de->xml,
440 "togglebutton-value-labels"));
443 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
444 get_widget_assert (de->xml,
445 "view_value-labels"));
448 gtk_action_new ("clear-cases",
450 _("Delete the cases at the selected position(s)"),
453 g_signal_connect (de->delete_cases, "activate",
454 G_CALLBACK (delete_cases), de);
456 gtk_action_connect_proxy (de->delete_cases,
457 get_widget_assert (de->xml, "edit_clear-cases"));
459 g_signal_connect (get_widget_assert (de->xml, "edit_paste"), "activate",
460 G_CALLBACK (on_edit_paste), de);
462 gtk_action_set_visible (de->delete_cases, FALSE);
464 de->delete_variables =
465 gtk_action_new ("clear-variables",
467 _("Delete the variables at the selected position(s)"),
468 "pspp-clear-variables");
470 g_signal_connect (de->delete_variables, "activate",
471 G_CALLBACK (delete_variables), de);
473 gtk_action_connect_proxy (de->delete_variables,
474 get_widget_assert (de->xml, "edit_clear-variables")
477 gtk_action_set_visible (de->delete_variables, FALSE);
479 de->insert_variable =
480 gtk_action_new ("insert-variable",
481 _("Insert Variable"),
482 _("Create a new variable at the current position"),
483 "pspp-insert-variable");
485 g_signal_connect (de->insert_variable, "activate",
486 G_CALLBACK (insert_variable), de);
489 gtk_action_connect_proxy (de->insert_variable,
490 get_widget_assert (de->xml, "button-insert-variable")
493 gtk_action_connect_proxy (de->insert_variable,
494 get_widget_assert (de->xml, "edit_insert-variable")
499 gtk_action_new ("insert-case",
501 _("Create a new case at the current position"),
504 g_signal_connect (de->insert_case, "activate",
505 G_CALLBACK (insert_case), de);
508 gtk_action_connect_proxy (de->insert_case,
509 get_widget_assert (de->xml, "button-insert-case")
513 gtk_action_connect_proxy (de->insert_case,
514 get_widget_assert (de->xml, "edit_insert-case")
519 de->invoke_goto_dialog =
520 gtk_action_new ("goto-case-dialog",
522 _("Jump to a Case in the Data Sheet"),
526 gtk_action_connect_proxy (de->invoke_goto_dialog,
527 get_widget_assert (de->xml, "button-goto-case")
530 gtk_action_connect_proxy (de->invoke_goto_dialog,
531 get_widget_assert (de->xml, "edit_goto-case")
535 g_signal_connect (de->invoke_goto_dialog, "activate",
536 G_CALLBACK (goto_case_dialog), de);
539 de->invoke_weight_cases_dialog =
540 gtk_action_new ("weight-cases-dialog",
542 _("Weight cases by variable"),
543 "pspp-weight-cases");
545 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
546 G_CALLBACK (weight_cases_dialog), de);
549 de->invoke_transpose_dialog =
550 gtk_action_new ("transpose-dialog",
552 _("Transpose the cases with the variables"),
556 g_signal_connect (de->invoke_transpose_dialog, "activate",
557 G_CALLBACK (transpose_dialog), de);
561 de->invoke_split_file_dialog =
562 gtk_action_new ("split-file-dialog",
564 _("Split the active file"),
567 g_signal_connect (de->invoke_split_file_dialog, "activate",
568 G_CALLBACK (split_file_dialog), de);
572 de->invoke_sort_cases_dialog =
573 gtk_action_new ("sort-cases-dialog",
575 _("Sort cases in the active file"),
578 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
579 G_CALLBACK (sort_cases_dialog), de);
581 de->invoke_select_cases_dialog =
582 gtk_action_new ("select-cases-dialog",
584 _("Select cases from the active file"),
585 "pspp-select-cases");
587 g_signal_connect (de->invoke_select_cases_dialog, "activate",
588 G_CALLBACK (select_cases_dialog), de);
591 de->invoke_compute_dialog =
592 gtk_action_new ("compute-dialog",
594 _("Compute new values for a variable"),
597 g_signal_connect (de->invoke_compute_dialog, "activate",
598 G_CALLBACK (compute_dialog), de);
600 de->invoke_oneway_anova_dialog =
601 gtk_action_new ("oneway-anova",
603 _("Perform one way analysis of variance"),
606 g_signal_connect (de->invoke_oneway_anova_dialog, "activate",
607 G_CALLBACK (oneway_anova_dialog), de);
609 de->invoke_t_test_independent_samples_dialog =
610 gtk_action_new ("t-test-independent-samples",
611 _("_Independent Samples T Test"),
612 _("Calculate T Test for samples from independent groups"),
615 g_signal_connect (de->invoke_t_test_independent_samples_dialog, "activate",
616 G_CALLBACK (t_test_independent_samples_dialog), de);
619 de->invoke_t_test_paired_samples_dialog =
620 gtk_action_new ("t-test-paired-samples",
621 _("_Paired Samples T Test"),
622 _("Calculate T Test for paired samples"),
625 g_signal_connect (de->invoke_t_test_paired_samples_dialog, "activate",
626 G_CALLBACK (t_test_paired_samples_dialog), de);
629 de->invoke_t_test_one_sample_dialog =
630 gtk_action_new ("t-test-one-sample",
631 _("One _Sample T Test"),
632 _("Calculate T Test for sample from a single distribution"),
635 g_signal_connect (de->invoke_t_test_one_sample_dialog, "activate",
636 G_CALLBACK (t_test_one_sample_dialog), de);
639 de->invoke_comments_dialog =
640 gtk_action_new ("commments-dialog",
641 _("Data File Comments"),
642 _("Commentary text for the data file"),
645 g_signal_connect (de->invoke_comments_dialog, "activate",
646 G_CALLBACK (comments_dialog), de);
648 de->invoke_find_dialog =
649 gtk_action_new ("find-dialog",
654 g_signal_connect (de->invoke_find_dialog, "activate",
655 G_CALLBACK (find_dialog), de);
658 de->invoke_rank_dialog =
659 gtk_action_new ("rank-dialog",
664 g_signal_connect (de->invoke_rank_dialog, "activate",
665 G_CALLBACK (rank_dialog), de);
668 de->invoke_recode_same_dialog =
669 gtk_action_new ("recode-same-dialog",
670 _("Recode into _Same Variables"),
671 _("Recode values into the same Variables"),
674 g_signal_connect (de->invoke_recode_same_dialog, "activate",
675 G_CALLBACK (recode_same_dialog), de);
678 de->invoke_recode_different_dialog =
679 gtk_action_new ("recode-different-dialog",
680 _("Recode into _Different Variables"),
681 _("Recode values into different Variables"),
682 "pspp-recode-different");
684 g_signal_connect (de->invoke_recode_different_dialog, "activate",
685 G_CALLBACK (recode_different_dialog), de);
688 de->invoke_variable_info_dialog =
689 gtk_action_new ("variable-info-dialog",
691 _("Jump to Variable"),
692 "pspp-goto-variable");
694 g_signal_connect (de->invoke_variable_info_dialog, "activate",
695 G_CALLBACK (variable_info_dialog), de);
697 de->invoke_descriptives_dialog =
698 gtk_action_new ("descriptives-dialog",
700 _("Calculate descriptive statistics (mean, variance, ...)"),
701 "pspp-descriptives");
703 g_signal_connect (de->invoke_descriptives_dialog, "activate",
704 G_CALLBACK (descriptives_dialog), de);
707 de->invoke_frequencies_dialog =
708 gtk_action_new ("frequencies-dialog",
710 _("Generate frequency statistics"),
713 g_signal_connect (de->invoke_frequencies_dialog, "activate",
714 G_CALLBACK (frequencies_dialog), de);
716 de->invoke_crosstabs_dialog =
717 gtk_action_new ("crosstabs-dialog",
719 _("Generate crosstabulations"),
722 g_signal_connect (de->invoke_crosstabs_dialog, "activate",
723 G_CALLBACK (crosstabs_dialog), de);
726 de->invoke_examine_dialog =
727 gtk_action_new ("examine-dialog",
729 _("Examine Data by Factors"),
732 g_signal_connect (de->invoke_examine_dialog, "activate",
733 G_CALLBACK (examine_dialog), de);
736 de->invoke_regression_dialog =
737 gtk_action_new ("regression-dialog",
738 _("Linear _Regression"),
739 _("Estimate parameters of the linear model"),
742 g_signal_connect (de->invoke_regression_dialog, "activate",
743 G_CALLBACK (regression_dialog), de);
745 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
747 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
749 G_CALLBACK (gtk_action_activate),
750 de->action_data_new);
752 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
754 G_CALLBACK (gtk_action_activate),
755 de->action_data_open);
757 #if RECENT_LISTS_AVAILABLE
759 GtkRecentManager *rm = gtk_recent_manager_get_default ();
760 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
761 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
762 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
764 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
766 GtkRecentFilter *filter = gtk_recent_filter_new ();
768 gtk_widget_show (recent_data);
769 gtk_widget_show (recent_files);
770 gtk_widget_show (recent_separator);
772 gtk_recent_filter_add_pattern (filter, "*.sav");
773 gtk_recent_filter_add_pattern (filter, "*.SAV");
775 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
777 gtk_widget_set_sensitive (recent_data, TRUE);
778 g_signal_connect (menu, "selection-done",
779 G_CALLBACK (on_recent_data_select), de);
781 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
784 filter = gtk_recent_filter_new ();
785 menu = gtk_recent_chooser_menu_new_for_manager (rm);
787 gtk_recent_filter_add_pattern (filter, "*.sps");
788 gtk_recent_filter_add_pattern (filter, "*.SPS");
790 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
792 gtk_widget_set_sensitive (recent_files, TRUE);
793 g_signal_connect (menu, "selection-done",
794 G_CALLBACK (on_recent_files_select), de);
796 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
800 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
802 G_CALLBACK (new_syntax_window),
805 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
807 G_CALLBACK (open_syntax_window),
810 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
812 G_CALLBACK (gtk_action_activate),
813 de->action_data_save);
815 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
817 G_CALLBACK (gtk_action_activate),
818 de->action_data_save_as);
820 gtk_action_connect_proxy (de->invoke_find_dialog,
821 get_widget_assert (de->xml, "edit_find")
824 gtk_action_connect_proxy (de->invoke_find_dialog,
825 get_widget_assert (de->xml, "button-find")
828 gtk_action_connect_proxy (de->invoke_rank_dialog,
829 get_widget_assert (de->xml, "transform_rank")
832 gtk_action_connect_proxy (de->invoke_recode_same_dialog,
833 get_widget_assert (de->xml,
834 "transform_recode-same")
837 gtk_action_connect_proxy (de->invoke_recode_different_dialog,
838 get_widget_assert (de->xml,
839 "transform_recode-different")
842 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
843 get_widget_assert (de->xml, "data_weight-cases")
846 gtk_action_connect_proxy (de->invoke_transpose_dialog,
847 get_widget_assert (de->xml, "data_transpose")
850 gtk_action_connect_proxy (de->invoke_split_file_dialog,
851 get_widget_assert (de->xml, "data_split-file")
854 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
855 get_widget_assert (de->xml, "data_sort-cases")
858 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
859 get_widget_assert (de->xml, "data_select-cases")
862 gtk_action_connect_proxy (de->invoke_compute_dialog,
863 get_widget_assert (de->xml, "transform_compute")
866 gtk_action_connect_proxy (de->invoke_t_test_independent_samples_dialog,
867 get_widget_assert (de->xml,
872 gtk_action_connect_proxy (de->invoke_t_test_paired_samples_dialog,
873 get_widget_assert (de->xml,
878 gtk_action_connect_proxy (de->invoke_t_test_one_sample_dialog,
879 get_widget_assert (de->xml,
884 gtk_action_connect_proxy (de->invoke_oneway_anova_dialog,
885 get_widget_assert (de->xml,
890 gtk_action_connect_proxy (de->invoke_comments_dialog,
891 get_widget_assert (de->xml, "utilities_comments")
894 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
895 get_widget_assert (de->xml, "utilities_variables")
898 gtk_action_connect_proxy (de->invoke_descriptives_dialog,
899 get_widget_assert (de->xml, "analyze_descriptives")
902 gtk_action_connect_proxy (de->invoke_crosstabs_dialog,
903 get_widget_assert (de->xml, "crosstabs")
906 gtk_action_connect_proxy (de->invoke_frequencies_dialog,
907 get_widget_assert (de->xml, "analyze_frequencies")
911 gtk_action_connect_proxy (de->invoke_examine_dialog,
912 get_widget_assert (de->xml, "analyze_explore")
915 gtk_action_connect_proxy (de->invoke_regression_dialog,
916 get_widget_assert (de->xml, "linear-regression")
919 g_signal_connect (get_widget_assert (de->xml,"help_about"),
921 G_CALLBACK (about_new),
925 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
927 G_CALLBACK (reference_manual),
930 g_signal_connect (data_sheet,
931 "double-click-column",
932 G_CALLBACK (click2column),
935 g_signal_connect (data_sheet,
937 G_CALLBACK (enable_delete_variables),
940 g_signal_connect (data_sheet,
942 G_CALLBACK (enable_delete_cases),
946 g_signal_connect (var_sheet,
948 GTK_SIGNAL_FUNC (click2row),
951 g_signal_connect_after (var_sheet,
953 G_CALLBACK (enable_delete_variables),
956 g_signal_connect (get_widget_assert (de->xml, "notebook"),
958 G_CALLBACK (on_switch_sheet), de);
961 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
963 G_CALLBACK (status_bar_activate), de);
966 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
968 G_CALLBACK (grid_lines_activate), de);
972 g_signal_connect (get_widget_assert (de->xml, "view_data"),
974 G_CALLBACK (data_sheet_activate), de);
976 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
978 G_CALLBACK (variable_sheet_activate), de);
982 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
984 G_CALLBACK (fonts_activate), de);
989 gtk_action_connect_proxy (de->action_data_open,
990 get_widget_assert (de->xml, "button-open")
993 gtk_action_connect_proxy (de->action_data_save,
994 get_widget_assert (de->xml, "button-save")
997 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
998 get_widget_assert (de->xml, "button-goto-variable")
1001 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
1002 get_widget_assert (de->xml, "button-weight-cases")
1005 gtk_action_connect_proxy (de->invoke_split_file_dialog,
1006 get_widget_assert (de->xml, "button-split-file")
1009 gtk_action_connect_proxy (de->invoke_select_cases_dialog,
1010 get_widget_assert (de->xml, "button-select-cases")
1014 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
1016 G_CALLBACK (file_quit), de);
1018 g_signal_connect (get_widget_assert (de->xml, "transform_run-pending"),
1020 G_CALLBACK (execute), de);
1023 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
1025 G_CALLBACK (minimise_all_windows), NULL);
1028 create_data_sheet_variable_popup_menu (de);
1029 create_data_sheet_cases_popup_menu (de);
1031 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
1032 G_CALLBACK (popup_variable_menu), de);
1034 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
1035 G_CALLBACK (popup_cases_menu), de);
1041 /* Callback which occurs when the var sheet's row title
1042 button is double clicked */
1044 click2row (GtkWidget *w, gint row, gpointer data)
1046 struct data_editor *de = data;
1047 GtkSheetRange visible_range;
1049 gint current_row, current_column;
1051 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
1053 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1055 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
1056 ¤t_row, ¤t_column);
1058 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
1060 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
1062 if ( row < visible_range.col0 || row > visible_range.coli)
1064 gtk_sheet_moveto (GTK_SHEET (data_sheet),
1065 current_row, row, 0, 0);
1072 /* Callback which occurs when the data sheet's column title
1073 is double clicked */
1075 click2column (GtkWidget *w, gint col, gpointer data)
1077 struct data_editor *de = data;
1079 gint current_row, current_column;
1081 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
1083 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1085 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
1086 ¤t_row, ¤t_column);
1088 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
1095 new_data_window (GtkMenuItem *menuitem, gpointer parent)
1097 window_create (WINDOW_DATA, NULL);
1100 /* Callback for when the datasheet/varsheet is selected */
1102 on_switch_sheet (GtkNotebook *notebook,
1103 GtkNotebookPage *page,
1107 struct data_editor *de = user_data;
1109 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
1110 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
1114 case PAGE_VAR_SHEET:
1115 gtk_widget_hide (view_variables);
1116 gtk_widget_show (view_data);
1117 gtk_action_set_sensitive (de->insert_variable, TRUE);
1118 gtk_action_set_sensitive (de->insert_case, FALSE);
1119 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
1121 case PAGE_DATA_SHEET:
1122 gtk_widget_show (view_variables);
1123 gtk_widget_show (view_data);
1124 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
1125 gtk_action_set_sensitive (de->insert_case, TRUE);
1128 g_assert_not_reached ();
1132 update_paste_menuitem (de, page_num);
1133 update_cut_copy_menuitem (de, page_num);
1138 data_editor_select_sheet (struct data_editor *de, gint page)
1140 gtk_notebook_set_current_page
1142 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
1149 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
1151 struct data_editor *de = data;
1152 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
1154 if ( gtk_check_menu_item_get_active (menuitem) )
1155 gtk_widget_show (statusbar);
1157 gtk_widget_hide (statusbar);
1162 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
1164 struct data_editor *de = data;
1165 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
1167 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
1171 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
1178 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1180 struct data_editor *de = data;
1182 data_editor_select_sheet (de, PAGE_DATA_SHEET);
1187 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
1189 struct data_editor *de = data;
1191 data_editor_select_sheet (de, PAGE_VAR_SHEET);
1196 fonts_activate (GtkMenuItem *menuitem, gpointer data)
1198 struct data_editor *de = data;
1200 gtk_font_selection_dialog_new (_("Font Selection"));
1202 gtk_window_set_transient_for (GTK_WINDOW (dialog),
1203 GTK_WINDOW (get_widget_assert (de->xml,
1205 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
1207 GtkSheet *data_sheet =
1208 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1210 GtkSheet *var_sheet =
1211 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1213 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1214 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
1216 const gchar *font = gtk_font_selection_dialog_get_font_name
1217 (GTK_FONT_SELECTION_DIALOG (dialog));
1219 PangoFontDescription* font_desc =
1220 pango_font_description_from_string (font);
1222 psppire_var_store_set_font (vs, font_desc);
1223 psppire_data_store_set_font (ds, font_desc);
1226 gtk_widget_hide (dialog);
1231 /* Callback for the value labels action */
1233 toggle_value_labels (GtkToggleAction *ta, gpointer data)
1235 struct data_editor *de = data;
1237 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1239 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
1242 psppire_data_store_show_labels (ds,
1243 gtk_toggle_action_get_active (ta));
1246 extern PsppireDataStore *the_data_store ;
1249 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
1251 /* FIXME: Need to be more intelligent here.
1252 Give the user the opportunity to save any unsaved data.
1254 g_object_unref (the_data_store);
1259 delete_cases (GtkAction *action, gpointer data)
1261 struct data_editor *de = data;
1262 GtkSheet *data_sheet =
1263 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1265 GtkSheetRange range;
1267 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
1268 (gtk_sheet_get_model (data_sheet) );
1271 /* This shouldn't be able to happen, because the action
1272 should be disabled */
1273 g_return_if_fail (gtk_sheet_get_state (data_sheet)
1274 == GTK_SHEET_ROW_SELECTED );
1276 gtk_sheet_get_selected_range (data_sheet, &range);
1278 gtk_sheet_unselect_range (data_sheet);
1280 psppire_data_store_delete_cases (data_store, range.row0,
1281 1 + range.rowi - range.row0);
1286 delete_variables (GtkAction *a, gpointer data)
1288 struct data_editor *de = data;
1289 GtkSheetRange range;
1291 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
1294 const gint page = gtk_notebook_get_current_page (notebook);
1296 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
1297 (page == PAGE_VAR_SHEET) ?
1302 gtk_sheet_get_selected_range (sheet, &range);
1306 case PAGE_VAR_SHEET:
1308 PsppireVarStore *vs =
1309 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
1311 psppire_dict_delete_variables (vs->dict,
1318 case PAGE_DATA_SHEET:
1320 PsppireDataStore *ds =
1321 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1323 psppire_dict_delete_variables (ds->dict,
1332 gtk_sheet_unselect_range (sheet);
1336 insert_case (GtkAction *action, gpointer data)
1339 struct data_editor *de = data;
1341 GtkSheet *data_sheet =
1342 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1344 PsppireDataStore *ds = PSPPIRE_DATA_STORE
1345 (gtk_sheet_get_model (data_sheet) );
1348 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
1350 if (current_row < 0) current_row = 0;
1352 psppire_data_store_insert_new_case (ds, current_row);
1355 /* Insert a new variable before the current row in the variable sheet,
1356 or before the current column in the data sheet, whichever is selected */
1358 insert_variable (GtkAction *action, gpointer data)
1360 struct data_editor *de = data;
1363 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
1365 GtkSheet *var_sheet =
1366 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1368 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1369 (gtk_sheet_get_model (var_sheet) );
1371 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
1373 case PAGE_VAR_SHEET:
1374 posn = var_sheet->active_cell.row;
1376 case PAGE_DATA_SHEET:
1378 GtkSheet *data_sheet =
1379 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1381 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
1382 posn = data_sheet->range.col0;
1384 posn = data_sheet->active_cell.col;
1388 g_assert_not_reached ();
1391 if ( posn == -1 ) posn = 0;
1393 psppire_dict_insert_variable (vs->dict, posn, NULL);
1396 /* Callback for when the dictionary changes its split variables */
1398 on_split_change (PsppireDict *dict, gpointer data)
1400 struct data_editor *de = data;
1402 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1404 GtkWidget *split_status_area =
1405 get_widget_assert (de->xml, "split-file-status-area");
1407 if ( n_split_vars == 0 )
1409 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1415 const struct variable *const * split_vars =
1416 dict_get_split_vars (dict->dict);
1418 text = g_string_new (_("Split by "));
1420 for (i = 0 ; i < n_split_vars - 1; ++i )
1422 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1424 g_string_append (text, var_get_name (split_vars[i]));
1426 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1428 g_string_free (text, TRUE);
1433 /* Callback for when the dictionary changes its filter variable */
1435 on_filter_change (GObject *o, gint filter_index, gpointer data)
1437 struct data_editor *de = data;
1438 GtkWidget *filter_status_area =
1439 get_widget_assert (de->xml, "filter-use-status-area");
1441 if ( filter_index == -1 )
1443 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1447 GtkSheet *var_sheet =
1448 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1450 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1451 (gtk_sheet_get_model (var_sheet) );
1453 struct variable *var = psppire_dict_get_variable (vs->dict,
1456 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1458 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1464 /* Callback for when the dictionary changes its weights */
1466 on_weight_change (GObject *o, gint weight_index, gpointer data)
1468 struct data_editor *de = data;
1469 GtkWidget *weight_status_area =
1470 get_widget_assert (de->xml, "weight-status-area");
1472 if ( weight_index == -1 )
1474 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1478 GtkSheet *var_sheet =
1479 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1481 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1482 (gtk_sheet_get_model (var_sheet) );
1484 struct variable *var = psppire_dict_get_variable (vs->dict,
1487 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1489 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1498 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1499 static void new_file (GtkAction *, struct editor_window *de);
1500 static void open_data_dialog (GtkAction *, struct data_editor *de);
1501 static void data_save (GtkAction *action, struct data_editor *e);
1504 /* Create the GtkActions and connect to their signals */
1506 register_data_editor_actions (struct data_editor *de)
1508 de->action_data_open =
1509 gtk_action_new ("data-open-dialog",
1511 _("Open a data file"),
1514 g_signal_connect (de->action_data_open, "activate",
1515 G_CALLBACK (open_data_dialog), de);
1518 de->action_data_save = gtk_action_new ("data-save",
1520 _("Save data to file"),
1523 g_signal_connect (de->action_data_save, "activate",
1524 G_CALLBACK (data_save), de);
1528 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1530 _("Save data to file"),
1533 g_signal_connect (de->action_data_save_as, "activate",
1534 G_CALLBACK (data_save_as_dialog), de);
1536 de->action_data_new =
1537 gtk_action_new ("data-new",
1542 g_signal_connect (de->action_data_new, "activate",
1543 G_CALLBACK (new_file), de);
1546 /* Returns true if NAME has a suffix which might denote a PSPP file */
1548 name_has_suffix (const gchar *name)
1550 if ( g_str_has_suffix (name, ".sav"))
1552 if ( g_str_has_suffix (name, ".SAV"))
1554 if ( g_str_has_suffix (name, ".por"))
1556 if ( g_str_has_suffix (name, ".POR"))
1562 /* Append SUFFIX to the filename of DE */
1564 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1566 if ( ! name_has_suffix (de->file_name))
1568 gchar *s = de->file_name;
1569 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1574 /* Save DE to file */
1576 save_file (struct data_editor *de)
1578 struct getl_interface *sss;
1579 struct string file_name ;
1581 g_assert (de->file_name);
1583 ds_init_cstr (&file_name, de->file_name);
1584 gen_quoted_string (&file_name);
1586 if ( de->save_as_portable )
1588 append_filename_suffix (de, ".por");
1589 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1590 ds_cstr (&file_name));
1594 append_filename_suffix (de, ".sav");
1595 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1596 ds_cstr (&file_name));
1599 ds_destroy (&file_name);
1601 execute_syntax (sss);
1605 /* Callback for data_save action.
1606 If there's an existing file name, then just save,
1607 otherwise prompt for a file name, then save */
1609 data_save (GtkAction *action, struct data_editor *de)
1614 data_save_as_dialog (action, de);
1618 /* Callback for data_save_as action. Prompt for a filename and save */
1620 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1622 struct editor_window *e = (struct editor_window *) de;
1624 GtkWidget *button_sys;
1626 gtk_file_chooser_dialog_new (_("Save"),
1627 GTK_WINDOW (e->window),
1628 GTK_FILE_CHOOSER_ACTION_SAVE,
1629 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1630 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1633 GtkFileFilter *filter = gtk_file_filter_new ();
1634 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1635 gtk_file_filter_add_pattern (filter, "*.sav");
1636 gtk_file_filter_add_pattern (filter, "*.SAV");
1637 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1639 filter = gtk_file_filter_new ();
1640 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1641 gtk_file_filter_add_pattern (filter, "*.por");
1642 gtk_file_filter_add_pattern (filter, "*.POR");
1643 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1645 filter = gtk_file_filter_new ();
1646 gtk_file_filter_set_name (filter, _("All Files"));
1647 gtk_file_filter_add_pattern (filter, "*");
1648 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1651 GtkWidget *button_por;
1652 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1654 gtk_radio_button_new_with_label (NULL, _("System File"));
1657 gtk_radio_button_new_with_label
1658 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1659 _("Portable File"));
1661 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1662 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1664 gtk_widget_show_all (vbox);
1666 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1669 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1671 case GTK_RESPONSE_ACCEPT:
1673 g_free (de->file_name);
1676 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1678 de->save_as_portable =
1679 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1683 window_set_name_from_filename (e, de->file_name);
1690 gtk_widget_destroy (dialog);
1694 /* Callback for data_new action.
1695 Performs the NEW FILE command */
1697 new_file (GtkAction *action, struct editor_window *e)
1699 struct data_editor *de = (struct data_editor *) e;
1701 struct getl_interface *sss =
1702 create_syntax_string_source ("NEW FILE.");
1704 execute_syntax (sss);
1706 g_free (de->file_name);
1707 de->file_name = NULL;
1709 default_window_name (e);
1714 open_data_file (const gchar *file_name, struct data_editor *de)
1716 struct getl_interface *sss;
1717 struct string filename;
1719 ds_init_cstr (&filename, file_name);
1721 gen_quoted_string (&filename);
1723 sss = create_syntax_string_source ("GET FILE=%s.",
1724 ds_cstr (&filename));
1725 ds_destroy (&filename);
1727 if (execute_syntax (sss) )
1729 window_set_name_from_filename ((struct editor_window *) de, file_name);
1730 add_most_recent (file_name);
1736 /* Callback for the data_open action.
1737 Prompts for a filename and opens it */
1739 open_data_dialog (GtkAction *action, struct data_editor *de)
1741 struct editor_window *e = (struct editor_window *) de;
1744 gtk_file_chooser_dialog_new (_("Open"),
1745 GTK_WINDOW (e->window),
1746 GTK_FILE_CHOOSER_ACTION_OPEN,
1747 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1748 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1751 GtkFileFilter *filter = gtk_file_filter_new ();
1752 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1753 gtk_file_filter_add_pattern (filter, "*.sav");
1754 gtk_file_filter_add_pattern (filter, "*.SAV");
1755 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1757 filter = gtk_file_filter_new ();
1758 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1759 gtk_file_filter_add_pattern (filter, "*.por");
1760 gtk_file_filter_add_pattern (filter, "*.POR");
1761 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1763 filter = gtk_file_filter_new ();
1764 gtk_file_filter_set_name (filter, _("All Files"));
1765 gtk_file_filter_add_pattern (filter, "*");
1766 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1771 gchar *dir_name = g_path_get_dirname (de->file_name);
1772 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1777 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1779 case GTK_RESPONSE_ACCEPT:
1781 g_free (de->file_name);
1783 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1785 open_data_file (de->file_name, de);
1792 gtk_widget_destroy (dialog);
1797 /* Update the data_ref_entry with the reference of the active cell */
1799 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1801 GtkEntry *datum_entry;
1802 GladeXML *data_editor_xml = data;
1804 PsppireDataStore *data_store =
1805 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1807 g_return_val_if_fail (data_editor_xml, FALSE);
1811 GTK_ENTRY (get_widget_assert (data_editor_xml,
1816 const struct variable *var =
1817 psppire_dict_get_variable (data_store->dict, col);
1819 /* The entry where the reference to the current cell is displayed */
1820 GtkEntry *cell_ref_entry =
1821 GTK_ENTRY (get_widget_assert (data_editor_xml,
1825 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1826 var_get_name (var));
1828 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1832 gtk_entry_set_text (cell_ref_entry, s);
1842 psppire_data_store_get_string (data_store, row,
1843 var_get_dict_index(var));
1850 gtk_entry_set_text (datum_entry, text);
1862 gtk_entry_set_text (datum_entry, "");
1872 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1874 GString *string = g_string_new ("SORT CASES BY ");
1876 const struct variable *v =
1877 psppire_dict_get_variable (ds->dict, var);
1879 g_string_append_printf (string, "%s", var_get_name (v));
1882 g_string_append (string, " (D)");
1884 g_string_append (string, ".");
1886 execute_syntax (create_syntax_string_source (string->str));
1888 g_string_free (string, TRUE);
1893 sort_up (GtkMenuItem *item, gpointer data)
1895 GtkSheet *sheet = data;
1896 GtkSheetRange range;
1897 gtk_sheet_get_selected_range (sheet, &range);
1899 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1905 sort_down (GtkMenuItem *item, gpointer data)
1907 GtkSheet *sheet = data;
1908 GtkSheetRange range;
1909 gtk_sheet_get_selected_range (sheet, &range);
1911 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1919 create_data_sheet_variable_popup_menu (struct data_editor *de)
1921 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1922 GtkWidget *menu = gtk_menu_new ();
1924 GtkWidget *sort_ascending =
1925 gtk_menu_item_new_with_label (_("Sort Ascending"));
1927 GtkWidget *sort_descending =
1928 gtk_menu_item_new_with_label (_("Sort Descending"));
1931 GtkWidget *insert_variable =
1932 gtk_menu_item_new_with_label (_("Insert Variable"));
1934 GtkWidget *clear_variable =
1935 gtk_menu_item_new_with_label (_("Clear"));
1938 gtk_action_connect_proxy (de->insert_variable,
1942 gtk_action_connect_proxy (de->delete_variables,
1946 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1949 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1950 gtk_separator_menu_item_new ());
1953 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1956 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1957 gtk_separator_menu_item_new ());
1960 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1961 G_CALLBACK (sort_up), sheet);
1963 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1966 g_signal_connect (G_OBJECT (sort_descending), "activate",
1967 G_CALLBACK (sort_down), sheet);
1970 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1972 gtk_widget_show_all (menu);
1975 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1980 create_data_sheet_cases_popup_menu (struct data_editor *de)
1982 GtkWidget *menu = gtk_menu_new ();
1984 GtkWidget *insert_case =
1985 gtk_menu_item_new_with_label (_("Insert Case"));
1987 GtkWidget *delete_case =
1988 gtk_menu_item_new_with_label (_("Clear"));
1991 gtk_action_connect_proxy (de->insert_case,
1995 gtk_action_connect_proxy (de->delete_cases,
1999 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
2002 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
2003 gtk_separator_menu_item_new ());
2006 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
2009 gtk_widget_show_all (menu);
2012 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
2017 popup_variable_menu (GtkSheet *sheet, gint column,
2018 GdkEventButton *event, gpointer data)
2020 struct data_editor *de = data;
2022 PsppireDataStore *data_store =
2023 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
2025 const struct variable *v =
2026 psppire_dict_get_variable (data_store->dict, column);
2028 if ( v && event->button == 3)
2031 gtk_sheet_select_column (sheet, column);
2033 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
2034 NULL, NULL, NULL, NULL,
2035 event->button, event->time);
2041 popup_cases_menu (GtkSheet *sheet, gint row,
2042 GdkEventButton *event, gpointer data)
2044 struct data_editor *de = data;
2046 PsppireDataStore *data_store =
2047 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
2049 if ( row <= psppire_data_store_get_case_count (data_store) &&
2052 gtk_sheet_select_row (sheet, row);
2054 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
2055 NULL, NULL, NULL, NULL,
2056 event->button, event->time);
2062 on_edit_paste (GtkAction *a, gpointer data)
2064 GtkClipboard *clipboard = gtk_clipboard_get (GDK_SELECTION_CLIPBOARD);
2066 gtk_clipboard_request_contents (clipboard,
2067 gdk_atom_intern ("UTF8_STRING", TRUE),
2068 data_sheet_contents_received_callback,
2074 on_edit_copy (GtkMenuItem *m, gpointer data)
2076 struct data_editor *de = data;
2078 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
2081 data_sheet_set_clip (data_sheet);
2087 on_edit_cut (GtkMenuItem *m, gpointer data)
2089 struct data_editor *de = data;
2090 gint max_rows, max_columns;
2092 GtkSheetRange range;
2093 PsppireDataStore *ds;
2094 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml,
2097 data_sheet_set_clip (data_sheet);
2100 /* Now blank all the cells */
2101 gtk_sheet_get_selected_range (data_sheet, &range);
2103 ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
2106 /* If nothing selected, then use active cell */
2107 if ( range.row0 < 0 || range.col0 < 0 )
2110 gtk_sheet_get_active_cell (data_sheet, &row, &col);
2112 range.row0 = range.rowi = row;
2113 range.col0 = range.coli = col;
2116 /* The sheet range can include cells that do not include data.
2117 Exclude them from the range. */
2118 max_rows = psppire_data_store_get_case_count (ds);
2119 if (range.rowi >= max_rows)
2123 range.rowi = max_rows - 1;
2126 max_columns = dict_get_var_cnt (ds->dict->dict);
2127 if (range.coli >= max_columns)
2129 if (max_columns == 0)
2131 range.coli = max_columns - 1;
2134 g_return_if_fail (range.rowi >= range.row0);
2135 g_return_if_fail (range.row0 >= 0);
2136 g_return_if_fail (range.coli >= range.col0);
2137 g_return_if_fail (range.col0 >= 0);
2140 for (r = range.row0; r <= range.rowi ; ++r )
2144 for (c = range.col0 ; c <= range.coli; ++c)
2146 psppire_data_store_set_string (ds, "", r, c);
2150 /* and remove the selection */
2151 gtk_sheet_unselect_range (data_sheet);