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 "psppire-dialog.h"
30 #include "psppire-selector.h"
31 #include "weight-cases-dialog.h"
32 #include "split-file-dialog.h"
33 #include "transpose-dialog.h"
34 #include "sort-cases-dialog.h"
35 #include "compute-dialog.h"
36 #include "goto-case-dialog.h"
37 #include "comments-dialog.h"
38 #include "variable-info-dialog.h"
39 #include "dict-display.h"
41 #define _(msgid) gettext (msgid)
42 #define N_(msgid) msgid
44 #include "data-editor.h"
45 #include "syntax-editor.h"
46 #include <language/syntax-string-source.h>
47 #include <libpspp/syntax-gen.h>
48 #include "window-manager.h"
50 #include "psppire-data-store.h"
51 #include "psppire-var-store.h"
54 static void create_data_sheet_variable_popup_menu (struct data_editor *);
55 static void create_data_sheet_cases_popup_menu (struct data_editor *);
57 static void popup_variable_menu (GtkSheet *, gint,
58 GdkEventButton *, gpointer data);
60 static void popup_cases_menu (GtkSheet *, gint,
61 GdkEventButton *, gpointer data);
63 /* Update the data_ref_entry with the reference of the active cell */
64 static gint update_data_ref_entry (const GtkSheet *sheet,
65 gint row, gint col, gpointer data);
67 static void register_data_editor_actions (struct data_editor *de);
69 static void insert_variable (GtkAction *, gpointer data);
70 static void insert_case (GtkAction *a, gpointer data);
71 static void delete_cases (GtkAction *a, gpointer data);
72 static void delete_variables (GtkAction *a, gpointer data);
74 static void toggle_value_labels (GtkToggleAction *a, gpointer data);
76 /* Switch between the VAR SHEET and the DATA SHEET */
78 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
79 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
82 /* Callback for when the dictionary changes properties*/
83 static void on_weight_change (GObject *, gint, gpointer);
84 static void on_filter_change (GObject *, gint, gpointer);
85 static void on_split_change (PsppireDict *, gpointer);
87 static void data_var_select (GtkNotebook *notebook,
88 GtkNotebookPage *page,
92 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
94 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
96 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
98 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
100 static void fonts_activate (GtkMenuItem *, gpointer);
102 static void file_quit (GtkCheckMenuItem *, gpointer );
105 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
107 struct data_editor *de = data;
109 gtk_action_set_visible (de->delete_cases, var != -1);
114 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
116 struct data_editor *de = data;
118 gtk_action_set_visible (de->delete_variables, var != -1);
122 static void open_data_file (const gchar *, struct data_editor *);
126 #if RECENT_LISTS_AVAILABLE
129 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
132 struct data_editor *de = user_data;
135 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
137 file = g_filename_from_uri (uri, NULL, NULL);
141 open_data_file (file, de);
147 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
151 struct syntax_editor *se ;
154 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
156 file = g_filename_from_uri (uri, NULL, NULL);
160 se = (struct syntax_editor *)
161 window_create (WINDOW_SYNTAX, file);
163 load_editor_from_file (se, file, NULL);
171 datum_entry_activate (GtkEntry *entry, gpointer data)
174 GtkSheet *data_sheet = GTK_SHEET (data);
175 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
177 const char *text = gtk_entry_get_text (entry);
179 gtk_sheet_get_active_cell (data_sheet, &row, &column);
181 if ( row == -1 || column == -1)
184 psppire_data_store_set_string (store, text, row, column);
188 Create a new data editor.
191 new_data_editor (void)
193 struct data_editor *de ;
194 struct editor_window *e;
195 GtkSheet *var_sheet ;
196 GtkSheet *data_sheet ;
198 GtkWidget *datum_entry;
200 de = g_malloc0 (sizeof (*de));
202 e = (struct editor_window *) de;
204 de->xml = XML_NEW ("data-editor.glade");
206 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
207 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
209 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
211 g_assert(vs); /* Traps a possible bug in win32 build */
213 g_signal_connect (G_OBJECT (data_sheet), "activate",
214 G_CALLBACK (update_data_ref_entry),
217 datum_entry = get_widget_assert (de->xml, "datum_entry");
219 g_signal_connect (G_OBJECT (datum_entry), "activate",
220 G_CALLBACK (datum_entry_activate),
223 g_signal_connect (vs->dict, "weight-changed",
224 G_CALLBACK (on_weight_change),
227 g_signal_connect (vs->dict, "filter-changed",
228 G_CALLBACK (on_filter_change),
231 g_signal_connect (vs->dict, "split-changed",
232 G_CALLBACK (on_split_change),
235 connect_help (de->xml);
238 register_data_editor_actions (de);
240 de->toggle_value_labels =
241 gtk_toggle_action_new ("toggle-value-labels",
243 _("Show (hide) value labels"),
244 "pspp-value-labels");
246 g_signal_connect (de->toggle_value_labels, "activate",
247 G_CALLBACK (toggle_value_labels), de);
250 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
251 get_widget_assert (de->xml,
252 "togglebutton-value-labels"));
255 gtk_action_connect_proxy (GTK_ACTION (de->toggle_value_labels),
256 get_widget_assert (de->xml,
257 "view_value-labels"));
260 gtk_action_new ("clear-cases",
262 _("Delete the cases at the selected position(s)"),
265 g_signal_connect (de->delete_cases, "activate",
266 G_CALLBACK (delete_cases), de);
268 gtk_action_connect_proxy (de->delete_cases,
269 get_widget_assert (de->xml, "edit_clear-cases"));
272 gtk_action_set_visible (de->delete_cases, FALSE);
274 de->delete_variables =
275 gtk_action_new ("clear-variables",
277 _("Delete the variables at the selected position(s)"),
278 "pspp-clear-variables");
280 g_signal_connect (de->delete_variables, "activate",
281 G_CALLBACK (delete_variables), de);
283 gtk_action_connect_proxy (de->delete_variables,
284 get_widget_assert (de->xml, "edit_clear-variables")
287 gtk_action_set_visible (de->delete_variables, FALSE);
289 de->insert_variable =
290 gtk_action_new ("insert-variable",
291 _("Insert Variable"),
292 _("Create a new variable at the current position"),
293 "pspp-insert-variable");
295 g_signal_connect (de->insert_variable, "activate",
296 G_CALLBACK (insert_variable), de);
299 gtk_action_connect_proxy (de->insert_variable,
300 get_widget_assert (de->xml, "button-insert-variable")
303 gtk_action_connect_proxy (de->insert_variable,
304 get_widget_assert (de->xml, "data_insert-variable")
309 gtk_action_new ("insert-case",
311 _("Create a new case at the current position"),
314 g_signal_connect (de->insert_case, "activate",
315 G_CALLBACK (insert_case), de);
318 gtk_action_connect_proxy (de->insert_case,
319 get_widget_assert (de->xml, "button-insert-case")
323 gtk_action_connect_proxy (de->insert_case,
324 get_widget_assert (de->xml, "data_insert-case")
329 de->invoke_goto_dialog =
330 gtk_action_new ("goto-case-dialog",
332 _("Jump to a Case in the Data Sheet"),
336 gtk_action_connect_proxy (de->invoke_goto_dialog,
337 get_widget_assert (de->xml, "button-goto-case")
340 gtk_action_connect_proxy (de->invoke_goto_dialog,
341 get_widget_assert (de->xml, "data_goto-case")
345 g_signal_connect (de->invoke_goto_dialog, "activate",
346 G_CALLBACK (goto_case_dialog), de);
349 de->invoke_weight_cases_dialog =
350 gtk_action_new ("weight-cases-dialog",
352 _("Weight cases by variable"),
353 "pspp-weight-cases");
355 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
356 G_CALLBACK (weight_cases_dialog), de);
359 de->invoke_transpose_dialog =
360 gtk_action_new ("transpose-dialog",
362 _("Transpose the cases with the variables"),
366 g_signal_connect (de->invoke_transpose_dialog, "activate",
367 G_CALLBACK (transpose_dialog), de);
371 de->invoke_split_file_dialog =
372 gtk_action_new ("split-file-dialog",
374 _("Split the active file"),
377 g_signal_connect (de->invoke_split_file_dialog, "activate",
378 G_CALLBACK (split_file_dialog), de);
382 de->invoke_sort_cases_dialog =
383 gtk_action_new ("sort-cases-dialog",
385 _("Sort cases in the active file"),
388 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
389 G_CALLBACK (sort_cases_dialog), de);
392 de->invoke_compute_dialog =
393 gtk_action_new ("compute-dialog",
395 _("Compute new values for a variable"),
398 g_signal_connect (de->invoke_compute_dialog, "activate",
399 G_CALLBACK (compute_dialog), de);
401 de->invoke_comments_dialog =
402 gtk_action_new ("commments-dialog",
403 _("Data File Comments"),
404 _("Commentary text for the data file"),
407 g_signal_connect (de->invoke_comments_dialog, "activate",
408 G_CALLBACK (comments_dialog), de);
410 de->invoke_variable_info_dialog =
411 gtk_action_new ("variable-info-dialog",
413 _("Jump to Variable"),
414 "pspp-goto-variable");
416 g_signal_connect (de->invoke_variable_info_dialog, "activate",
417 G_CALLBACK (variable_info_dialog), de);
419 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
421 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
423 G_CALLBACK (gtk_action_activate),
424 de->action_data_new);
426 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
428 G_CALLBACK (gtk_action_activate),
429 de->action_data_open);
432 #if RECENT_LISTS_AVAILABLE
434 GtkRecentManager *rm = gtk_recent_manager_get_default ();
435 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
436 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
437 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
439 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
441 GtkRecentFilter *filter = gtk_recent_filter_new ();
443 gtk_widget_show (recent_data);
444 gtk_widget_show (recent_files);
445 gtk_widget_show (recent_separator);
447 gtk_recent_filter_add_pattern (filter, "*.sav");
448 gtk_recent_filter_add_pattern (filter, "*.SAV");
450 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
452 gtk_widget_set_sensitive (recent_data, TRUE);
453 g_signal_connect (menu, "selection-done",
454 G_CALLBACK (on_recent_data_select), de);
456 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
459 filter = gtk_recent_filter_new ();
460 menu = gtk_recent_chooser_menu_new_for_manager (rm);
462 gtk_recent_filter_add_pattern (filter, "*.sps");
463 gtk_recent_filter_add_pattern (filter, "*.SPS");
465 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
467 gtk_widget_set_sensitive (recent_files, TRUE);
468 g_signal_connect (menu, "selection-done",
469 G_CALLBACK (on_recent_files_select), de);
471 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
475 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
477 G_CALLBACK (new_syntax_window),
480 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
482 G_CALLBACK (open_syntax_window),
485 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
487 G_CALLBACK (gtk_action_activate),
488 de->action_data_save);
490 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
492 G_CALLBACK (gtk_action_activate),
493 de->action_data_save_as);
495 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
496 get_widget_assert (de->xml, "data_weight-cases")
499 gtk_action_connect_proxy (de->invoke_transpose_dialog,
500 get_widget_assert (de->xml, "data_transpose")
503 gtk_action_connect_proxy (de->invoke_split_file_dialog,
504 get_widget_assert (de->xml, "data_split-file")
507 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
508 get_widget_assert (de->xml, "data_sort-cases")
511 gtk_action_connect_proxy (de->invoke_compute_dialog,
512 get_widget_assert (de->xml, "transform_compute")
515 gtk_action_connect_proxy (de->invoke_comments_dialog,
516 get_widget_assert (de->xml, "utilities_comments")
519 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
520 get_widget_assert (de->xml, "utilities_variables")
523 g_signal_connect (get_widget_assert (de->xml,"help_about"),
525 G_CALLBACK (about_new),
529 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
531 G_CALLBACK (reference_manual),
534 g_signal_connect (data_sheet,
535 "double-click-column",
536 G_CALLBACK (click2column),
539 g_signal_connect (data_sheet,
541 G_CALLBACK (enable_delete_variables),
544 g_signal_connect (data_sheet,
546 G_CALLBACK (enable_delete_cases),
550 g_signal_connect (var_sheet,
552 GTK_SIGNAL_FUNC (click2row),
555 g_signal_connect_after (var_sheet,
557 G_CALLBACK (enable_delete_variables),
560 g_signal_connect (get_widget_assert (de->xml, "notebook"),
562 G_CALLBACK (data_var_select), de);
565 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
567 G_CALLBACK (status_bar_activate), de);
570 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
572 G_CALLBACK (grid_lines_activate), de);
576 g_signal_connect (get_widget_assert (de->xml, "view_data"),
578 G_CALLBACK (data_sheet_activate), de);
580 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
582 G_CALLBACK (variable_sheet_activate), de);
586 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
588 G_CALLBACK (fonts_activate), de);
593 gtk_action_connect_proxy (de->action_data_open,
594 get_widget_assert (de->xml, "button-open")
597 gtk_action_connect_proxy (de->action_data_save,
598 get_widget_assert (de->xml, "button-save")
601 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
602 get_widget_assert (de->xml, "button-goto-variable")
605 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
606 get_widget_assert (de->xml, "button-weight-cases")
609 gtk_action_connect_proxy (de->invoke_split_file_dialog,
610 get_widget_assert (de->xml, "button-split-file")
613 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
615 G_CALLBACK (file_quit), de);
618 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
620 G_CALLBACK (minimise_all_windows), NULL);
623 create_data_sheet_variable_popup_menu (de);
624 create_data_sheet_cases_popup_menu (de);
626 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
627 G_CALLBACK (popup_variable_menu), de);
629 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
630 G_CALLBACK (popup_cases_menu), de);
632 /* The "switch-page" signal does get emitted unless the page actually
633 changes. But the state is indeterminate at startup. Therefore we
634 must explicitly change it to one state, then the other */
635 data_editor_select_sheet (de, PAGE_VAR_SHEET);
636 data_editor_select_sheet (de, PAGE_DATA_SHEET);
642 /* Callback which occurs when the var sheet's row title
643 button is double clicked */
645 click2row (GtkWidget *w, gint row, gpointer data)
647 struct data_editor *de = data;
648 GtkSheetRange visible_range;
650 gint current_row, current_column;
652 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
654 data_editor_select_sheet (de, PAGE_DATA_SHEET);
656 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
657 ¤t_row, ¤t_column);
659 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
661 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
663 if ( row < visible_range.col0 || row > visible_range.coli)
665 gtk_sheet_moveto (GTK_SHEET (data_sheet),
666 current_row, row, 0, 0);
673 /* Callback which occurs when the data sheet's column title
676 click2column (GtkWidget *w, gint col, gpointer data)
678 struct data_editor *de = data;
680 gint current_row, current_column;
682 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
684 data_editor_select_sheet (de, PAGE_VAR_SHEET);
686 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
687 ¤t_row, ¤t_column);
689 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
696 new_data_window (GtkMenuItem *menuitem, gpointer parent)
698 window_create (WINDOW_DATA, NULL);
703 data_var_select (GtkNotebook *notebook,
704 GtkNotebookPage *page,
708 struct data_editor *de = user_data;
710 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
711 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
716 gtk_widget_hide (view_variables);
717 gtk_widget_show (view_data);
718 gtk_action_set_sensitive (de->insert_variable, TRUE);
719 gtk_action_set_sensitive (de->insert_case, FALSE);
720 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
722 case PAGE_DATA_SHEET:
723 gtk_widget_show (view_variables);
724 gtk_widget_hide (view_data);
725 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
726 gtk_action_set_sensitive (de->insert_case, TRUE);
729 g_assert_not_reached ();
736 data_editor_select_sheet (struct data_editor *de, gint page)
738 gtk_notebook_set_current_page
740 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
747 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
749 struct data_editor *de = data;
750 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
752 if ( gtk_check_menu_item_get_active (menuitem) )
753 gtk_widget_show (statusbar);
755 gtk_widget_hide (statusbar);
760 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
762 struct data_editor *de = data;
763 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
765 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
769 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
776 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
778 struct data_editor *de = data;
780 data_editor_select_sheet (de, PAGE_DATA_SHEET);
785 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
787 struct data_editor *de = data;
789 data_editor_select_sheet (de, PAGE_VAR_SHEET);
794 fonts_activate (GtkMenuItem *menuitem, gpointer data)
796 struct data_editor *de = data;
798 gtk_font_selection_dialog_new (_("Font Selection"));
800 gtk_window_set_transient_for (GTK_WINDOW (dialog),
801 GTK_WINDOW (get_widget_assert (de->xml,
803 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
805 GtkSheet *data_sheet =
806 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
808 GtkSheet *var_sheet =
809 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
811 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
812 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
814 const gchar *font = gtk_font_selection_dialog_get_font_name
815 (GTK_FONT_SELECTION_DIALOG (dialog));
817 PangoFontDescription* font_desc =
818 pango_font_description_from_string (font);
820 psppire_var_store_set_font (vs, font_desc);
821 psppire_data_store_set_font (ds, font_desc);
824 gtk_widget_hide (dialog);
829 /* Callback for the value labels action */
831 toggle_value_labels (GtkToggleAction *ta, gpointer data)
833 struct data_editor *de = data;
835 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
837 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
840 psppire_data_store_show_labels (ds,
841 gtk_toggle_action_get_active (ta));
846 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
848 /* FIXME: Need to be more intelligent here.
849 Give the user the opportunity to save any unsaved data.
855 delete_cases (GtkAction *action, gpointer data)
857 struct data_editor *de = data;
858 GtkSheet *data_sheet =
859 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
863 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
864 (gtk_sheet_get_model (data_sheet) );
867 /* This shouldn't be able to happen, because the action
868 should be disabled */
869 g_return_if_fail (gtk_sheet_get_state (data_sheet)
870 == GTK_SHEET_ROW_SELECTED );
872 gtk_sheet_get_selected_range (data_sheet, &range);
874 gtk_sheet_unselect_range (data_sheet);
876 psppire_data_store_delete_cases (data_store, range.row0,
877 1 + range.rowi - range.row0);
882 delete_variables (GtkAction *a, gpointer data)
884 struct data_editor *de = data;
887 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
890 const gint page = gtk_notebook_get_current_page (notebook);
892 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
893 (page == PAGE_VAR_SHEET) ?
898 gtk_sheet_get_selected_range (sheet, &range);
904 PsppireVarStore *vs =
905 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
907 psppire_dict_delete_variables (vs->dict,
914 case PAGE_DATA_SHEET:
916 PsppireDataStore *ds =
917 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
919 psppire_dict_delete_variables (ds->dict,
928 gtk_sheet_unselect_range (sheet);
932 insert_case (GtkAction *action, gpointer data)
935 struct data_editor *de = data;
937 GtkSheet *data_sheet =
938 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
940 PsppireDataStore *ds = PSPPIRE_DATA_STORE
941 (gtk_sheet_get_model (data_sheet) );
944 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
946 if (current_row < 0) current_row = 0;
948 psppire_data_store_insert_new_case (ds, current_row);
951 /* Insert a new variable before the current row in the variable sheet,
952 or before the current column in the data sheet, whichever is selected */
954 insert_variable (GtkAction *action, gpointer data)
956 struct data_editor *de = data;
959 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
961 GtkSheet *var_sheet =
962 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
964 PsppireVarStore *vs = PSPPIRE_VAR_STORE
965 (gtk_sheet_get_model (var_sheet) );
967 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
970 posn = var_sheet->active_cell.row;
972 case PAGE_DATA_SHEET:
974 GtkSheet *data_sheet =
975 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
977 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
978 posn = data_sheet->range.col0;
980 posn = data_sheet->active_cell.col;
984 g_assert_not_reached ();
987 if ( posn == -1 ) posn = 0;
989 psppire_dict_insert_variable (vs->dict, posn, NULL);
992 /* Callback for when the dictionary changes its split variables */
994 on_split_change (PsppireDict *dict, gpointer data)
996 struct data_editor *de = data;
998 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1000 GtkWidget *split_status_area =
1001 get_widget_assert (de->xml, "split-file-status-area");
1003 if ( n_split_vars == 0 )
1005 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1011 const struct variable *const * split_vars =
1012 dict_get_split_vars (dict->dict);
1014 text = g_string_new (_("Split by "));
1016 for (i = 0 ; i < n_split_vars - 1; ++i )
1018 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1020 g_string_append (text, var_get_name (split_vars[i]));
1022 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1024 g_string_free (text, TRUE);
1029 /* Callback for when the dictionary changes its filter variable */
1031 on_filter_change (GObject *o, gint filter_index, gpointer data)
1033 struct data_editor *de = data;
1034 GtkWidget *filter_status_area =
1035 get_widget_assert (de->xml, "filter-use-status-area");
1037 if ( filter_index == -1 )
1039 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1043 GtkSheet *var_sheet =
1044 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1046 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1047 (gtk_sheet_get_model (var_sheet) );
1049 struct variable *var = psppire_dict_get_variable (vs->dict,
1052 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1054 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1060 /* Callback for when the dictionary changes its weights */
1062 on_weight_change (GObject *o, gint weight_index, gpointer data)
1064 struct data_editor *de = data;
1065 GtkWidget *weight_status_area =
1066 get_widget_assert (de->xml, "weight-status-area");
1068 if ( weight_index == -1 )
1070 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1074 GtkSheet *var_sheet =
1075 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1077 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1078 (gtk_sheet_get_model (var_sheet) );
1080 struct variable *var = psppire_dict_get_variable (vs->dict,
1083 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1085 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1094 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1095 static void new_file (GtkAction *, struct editor_window *de);
1096 static void open_data_dialog (GtkAction *, struct data_editor *de);
1097 static void data_save (GtkAction *action, struct data_editor *e);
1100 /* Create the GtkActions and connect to their signals */
1102 register_data_editor_actions (struct data_editor *de)
1104 de->action_data_open =
1105 gtk_action_new ("data-open-dialog",
1107 _("Open a data file"),
1110 g_signal_connect (de->action_data_open, "activate",
1111 G_CALLBACK (open_data_dialog), de);
1114 de->action_data_save = gtk_action_new ("data-save",
1116 _("Save data to file"),
1119 g_signal_connect (de->action_data_save, "activate",
1120 G_CALLBACK (data_save), de);
1124 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1126 _("Save data to file"),
1129 g_signal_connect (de->action_data_save_as, "activate",
1130 G_CALLBACK (data_save_as_dialog), de);
1132 de->action_data_new =
1133 gtk_action_new ("data-new",
1138 g_signal_connect (de->action_data_new, "activate",
1139 G_CALLBACK (new_file), de);
1142 /* Returns true if NAME has a suffix which might denote a PSPP file */
1144 name_has_suffix (const gchar *name)
1146 if ( g_str_has_suffix (name, ".sav"))
1148 if ( g_str_has_suffix (name, ".SAV"))
1150 if ( g_str_has_suffix (name, ".por"))
1152 if ( g_str_has_suffix (name, ".POR"))
1158 /* Append SUFFIX to the filename of DE */
1160 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1162 if ( ! name_has_suffix (de->file_name))
1164 gchar *s = de->file_name;
1165 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1170 /* Save DE to file */
1172 save_file (struct data_editor *de)
1174 struct getl_interface *sss;
1175 struct string file_name ;
1177 g_assert (de->file_name);
1179 ds_init_cstr (&file_name, de->file_name);
1180 gen_quoted_string (&file_name);
1182 if ( de->save_as_portable )
1184 append_filename_suffix (de, ".por");
1185 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1186 ds_cstr (&file_name));
1190 append_filename_suffix (de, ".sav");
1191 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1192 ds_cstr (&file_name));
1195 ds_destroy (&file_name);
1197 execute_syntax (sss);
1201 /* Callback for data_save action.
1202 If there's an existing file name, then just save,
1203 otherwise prompt for a file name, then save */
1205 data_save (GtkAction *action, struct data_editor *de)
1210 data_save_as_dialog (action, de);
1214 /* Callback for data_save_as action. Prompt for a filename and save */
1216 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1218 struct editor_window *e = (struct editor_window *) de;
1220 GtkWidget *button_sys;
1222 gtk_file_chooser_dialog_new (_("Save"),
1223 GTK_WINDOW (e->window),
1224 GTK_FILE_CHOOSER_ACTION_SAVE,
1225 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1226 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1229 GtkFileFilter *filter = gtk_file_filter_new ();
1230 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1231 gtk_file_filter_add_pattern (filter, "*.sav");
1232 gtk_file_filter_add_pattern (filter, "*.SAV");
1233 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1235 filter = gtk_file_filter_new ();
1236 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1237 gtk_file_filter_add_pattern (filter, "*.por");
1238 gtk_file_filter_add_pattern (filter, "*.POR");
1239 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1241 filter = gtk_file_filter_new ();
1242 gtk_file_filter_set_name (filter, _("All Files"));
1243 gtk_file_filter_add_pattern (filter, "*");
1244 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1247 GtkWidget *button_por;
1248 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1250 gtk_radio_button_new_with_label (NULL, _("System File"));
1253 gtk_radio_button_new_with_label
1254 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1255 _("Portable File"));
1257 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1258 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1260 gtk_widget_show_all (vbox);
1262 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1265 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1267 case GTK_RESPONSE_ACCEPT:
1269 g_free (de->file_name);
1272 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1274 de->save_as_portable =
1275 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1279 window_set_name_from_filename (e, de->file_name);
1286 gtk_widget_destroy (dialog);
1290 /* Callback for data_new action.
1291 Performs the NEW FILE command */
1293 new_file (GtkAction *action, struct editor_window *e)
1295 struct data_editor *de = (struct data_editor *) e;
1297 struct getl_interface *sss =
1298 create_syntax_string_source ("NEW FILE.");
1300 execute_syntax (sss);
1302 g_free (de->file_name);
1303 de->file_name = NULL;
1305 default_window_name (e);
1310 open_data_file (const gchar *file_name, struct data_editor *de)
1312 struct getl_interface *sss;
1313 struct string filename;
1315 ds_init_cstr (&filename, file_name);
1317 gen_quoted_string (&filename);
1319 sss = create_syntax_string_source ("GET FILE=%s.",
1320 ds_cstr (&filename));
1322 execute_syntax (sss);
1323 ds_destroy (&filename);
1325 window_set_name_from_filename ((struct editor_window *) de, file_name);
1329 /* Callback for the data_open action.
1330 Prompts for a filename and opens it */
1332 open_data_dialog (GtkAction *action, struct data_editor *de)
1334 struct editor_window *e = (struct editor_window *) de;
1337 gtk_file_chooser_dialog_new (_("Open"),
1338 GTK_WINDOW (e->window),
1339 GTK_FILE_CHOOSER_ACTION_OPEN,
1340 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1341 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1344 GtkFileFilter *filter = gtk_file_filter_new ();
1345 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1346 gtk_file_filter_add_pattern (filter, "*.sav");
1347 gtk_file_filter_add_pattern (filter, "*.SAV");
1348 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1350 filter = gtk_file_filter_new ();
1351 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1352 gtk_file_filter_add_pattern (filter, "*.por");
1353 gtk_file_filter_add_pattern (filter, "*.POR");
1354 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1356 filter = gtk_file_filter_new ();
1357 gtk_file_filter_set_name (filter, _("All Files"));
1358 gtk_file_filter_add_pattern (filter, "*");
1359 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1364 gchar *dir_name = g_path_get_dirname (de->file_name);
1365 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1370 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1372 case GTK_RESPONSE_ACCEPT:
1374 g_free (de->file_name);
1376 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1378 open_data_file (de->file_name, de);
1380 #if RECENT_LISTS_AVAILABLE
1382 GtkRecentManager *manager = gtk_recent_manager_get_default();
1383 gchar *uri = g_filename_to_uri (de->file_name, NULL, NULL);
1385 if ( ! gtk_recent_manager_add_item (manager, uri))
1386 g_warning ("Could not add item %s to recent list\n",uri);
1398 gtk_widget_destroy (dialog);
1403 /* Update the data_ref_entry with the reference of the active cell */
1405 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1407 GladeXML *data_editor_xml = data;
1409 PsppireDataStore *data_store =
1410 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1412 g_return_val_if_fail (data_editor_xml, FALSE);
1416 const struct variable *var =
1417 psppire_dict_get_variable (data_store->dict, col);
1419 /* The entry where the reference to the current cell is displayed */
1420 GtkEntry *cell_ref_entry =
1421 GTK_ENTRY (get_widget_assert (data_editor_xml,
1423 GtkEntry *datum_entry =
1424 GTK_ENTRY (get_widget_assert (data_editor_xml,
1429 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1430 var_get_name (var));
1432 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1436 gtk_entry_set_text (cell_ref_entry, s);
1441 gtk_entry_set_text (cell_ref_entry, "");
1447 psppire_data_store_get_string (data_store, row,
1448 var_get_dict_index(var));
1451 gtk_entry_set_text (datum_entry, text);
1456 gtk_entry_set_text (datum_entry, "");
1467 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1469 GString *string = g_string_new ("SORT CASES BY ");
1471 const struct variable *v =
1472 psppire_dict_get_variable (ds->dict, var);
1474 g_string_append_printf (string, "%s", var_get_name (v));
1477 g_string_append (string, " (D)");
1479 g_string_append (string, ".");
1481 execute_syntax (create_syntax_string_source (string->str));
1483 g_string_free (string, TRUE);
1488 sort_up (GtkMenuItem *item, gpointer data)
1490 GtkSheet *sheet = data;
1491 GtkSheetRange range;
1492 gtk_sheet_get_selected_range (sheet, &range);
1494 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1500 sort_down (GtkMenuItem *item, gpointer data)
1502 GtkSheet *sheet = data;
1503 GtkSheetRange range;
1504 gtk_sheet_get_selected_range (sheet, &range);
1506 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1514 create_data_sheet_variable_popup_menu (struct data_editor *de)
1516 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1517 GtkWidget *menu = gtk_menu_new ();
1519 GtkWidget *sort_ascending =
1520 gtk_menu_item_new_with_label (_("Sort Ascending"));
1522 GtkWidget *sort_descending =
1523 gtk_menu_item_new_with_label (_("Sort Descending"));
1526 GtkWidget *insert_variable =
1527 gtk_menu_item_new_with_label (_("Insert Variable"));
1529 GtkWidget *clear_variable =
1530 gtk_menu_item_new_with_label (_("Clear"));
1533 gtk_action_connect_proxy (de->insert_variable,
1537 gtk_action_connect_proxy (de->delete_variables,
1541 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1544 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1545 gtk_separator_menu_item_new ());
1548 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1551 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1552 gtk_separator_menu_item_new ());
1555 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1556 G_CALLBACK (sort_up), sheet);
1558 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1561 g_signal_connect (G_OBJECT (sort_descending), "activate",
1562 G_CALLBACK (sort_down), sheet);
1565 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1567 gtk_widget_show_all (menu);
1570 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1575 create_data_sheet_cases_popup_menu (struct data_editor *de)
1577 GtkWidget *menu = gtk_menu_new ();
1579 GtkWidget *insert_case =
1580 gtk_menu_item_new_with_label (_("Insert Case"));
1582 GtkWidget *delete_case =
1583 gtk_menu_item_new_with_label (_("Clear"));
1586 gtk_action_connect_proxy (de->insert_case,
1590 gtk_action_connect_proxy (de->delete_cases,
1594 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
1597 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1598 gtk_separator_menu_item_new ());
1601 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
1604 gtk_widget_show_all (menu);
1607 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
1612 popup_variable_menu (GtkSheet *sheet, gint column,
1613 GdkEventButton *event, gpointer data)
1615 struct data_editor *de = data;
1617 PsppireDataStore *data_store =
1618 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1620 const struct variable *v =
1621 psppire_dict_get_variable (data_store->dict, column);
1623 if ( v && event->button == 3)
1626 gtk_sheet_select_column (sheet, column);
1628 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
1629 NULL, NULL, NULL, NULL,
1630 event->button, event->time);
1636 popup_cases_menu (GtkSheet *sheet, gint row,
1637 GdkEventButton *event, gpointer data)
1639 struct data_editor *de = data;
1641 PsppireDataStore *data_store =
1642 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1644 if ( row <= psppire_data_store_get_case_count (data_store) &&
1647 gtk_sheet_select_row (sheet, row);
1649 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
1650 NULL, NULL, NULL, NULL,
1651 event->button, event->time);