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);
75 /* Switch between the VAR SHEET and the DATA SHEET */
77 static gboolean click2column (GtkWidget *w, gint col, gpointer data);
79 static gboolean click2row (GtkWidget *w, gint row, gpointer data);
82 static void select_sheet (struct data_editor *de, guint page_num);
85 /* Callback for when the dictionary changes properties*/
86 static void on_weight_change (GObject *, gint, gpointer);
87 static void on_filter_change (GObject *, gint, gpointer);
88 static void on_split_change (PsppireDict *, gpointer);
90 static void data_var_select (GtkNotebook *notebook,
91 GtkNotebookPage *page,
95 static void status_bar_activate (GtkCheckMenuItem *, gpointer);
97 static void grid_lines_activate (GtkCheckMenuItem *, gpointer);
99 static void data_sheet_activate (GtkCheckMenuItem *, gpointer);
101 static void variable_sheet_activate (GtkCheckMenuItem *, gpointer );
103 static void fonts_activate (GtkMenuItem *, gpointer);
105 static void value_labels_activate (GtkCheckMenuItem *, gpointer);
106 static void value_labels_toggled (GtkToggleToolButton *, gpointer);
109 static void file_quit (GtkCheckMenuItem *, gpointer );
112 enable_delete_cases (GtkWidget *w, gint var, gpointer data)
114 struct data_editor *de = data;
116 gtk_action_set_visible (de->delete_cases, var != -1);
121 enable_delete_variables (GtkWidget *w, gint var, gpointer data)
123 struct data_editor *de = data;
125 gtk_action_set_visible (de->delete_variables, var != -1);
129 static void open_data_file (const gchar *, struct data_editor *);
133 #if RECENT_LISTS_AVAILABLE
136 on_recent_data_select (GtkMenuShell *menushell, gpointer user_data)
139 struct data_editor *de = user_data;
142 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
144 file = g_filename_from_uri (uri, NULL, NULL);
148 open_data_file (file, de);
154 on_recent_files_select (GtkMenuShell *menushell, gpointer user_data)
158 struct syntax_editor *se ;
161 gtk_recent_chooser_get_current_uri (GTK_RECENT_CHOOSER (menushell));
163 file = g_filename_from_uri (uri, NULL, NULL);
167 se = (struct syntax_editor *)
168 window_create (WINDOW_SYNTAX, file);
170 load_editor_from_file (se, file, NULL);
178 datum_entry_activate (GtkEntry *entry, gpointer data)
181 GtkSheet *data_sheet = GTK_SHEET (data);
182 PsppireDataStore *store = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
184 const char *text = gtk_entry_get_text (entry);
186 gtk_sheet_get_active_cell (data_sheet, &row, &column);
188 if ( row == -1 || column == -1)
191 psppire_data_store_set_string (store, text, row, column);
195 Create a new data editor.
198 new_data_editor (void)
200 struct data_editor *de ;
201 struct editor_window *e;
202 GtkSheet *var_sheet ;
203 GtkSheet *data_sheet ;
205 GtkWidget *datum_entry;
207 de = g_malloc0 (sizeof (*de));
209 e = (struct editor_window *) de;
211 de->xml = XML_NEW ("data-editor.glade");
213 var_sheet = GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
214 data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
216 vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
218 g_assert(vs); /* Traps a possible bug in win32 build */
220 g_signal_connect (G_OBJECT (data_sheet), "activate",
221 G_CALLBACK (update_data_ref_entry),
224 datum_entry = get_widget_assert (de->xml, "datum_entry");
226 g_signal_connect (G_OBJECT (datum_entry), "activate",
227 G_CALLBACK (datum_entry_activate),
230 g_signal_connect (vs->dict, "weight-changed",
231 G_CALLBACK (on_weight_change),
234 g_signal_connect (vs->dict, "filter-changed",
235 G_CALLBACK (on_filter_change),
238 g_signal_connect (vs->dict, "split-changed",
239 G_CALLBACK (on_split_change),
242 connect_help (de->xml);
245 register_data_editor_actions (de);
249 gtk_action_new ("clear-cases",
251 _("Delete the cases at the selected position(s)"),
254 g_signal_connect (de->delete_cases, "activate",
255 G_CALLBACK (delete_cases), de);
257 gtk_action_connect_proxy (de->delete_cases,
258 get_widget_assert (de->xml, "edit_clear-cases"));
261 gtk_action_set_visible (de->delete_cases, FALSE);
263 de->delete_variables =
264 gtk_action_new ("clear-variables",
266 _("Delete the variables at the selected position(s)"),
267 "pspp-clear-variables");
269 g_signal_connect (de->delete_variables, "activate",
270 G_CALLBACK (delete_variables), de);
272 gtk_action_connect_proxy (de->delete_variables,
273 get_widget_assert (de->xml, "edit_clear-variables")
276 gtk_action_set_visible (de->delete_variables, FALSE);
278 de->insert_variable =
279 gtk_action_new ("insert-variable",
280 _("Insert Variable"),
281 _("Create a new variable at the current position"),
282 "pspp-insert-variable");
284 g_signal_connect (de->insert_variable, "activate",
285 G_CALLBACK (insert_variable), de);
288 gtk_action_connect_proxy (de->insert_variable,
289 get_widget_assert (de->xml, "button-insert-variable")
292 gtk_action_connect_proxy (de->insert_variable,
293 get_widget_assert (de->xml, "data_insert-variable")
298 gtk_action_new ("insert-case",
300 _("Create a new case at the current position"),
303 g_signal_connect (de->insert_case, "activate",
304 G_CALLBACK (insert_case), de);
307 gtk_action_connect_proxy (de->insert_case,
308 get_widget_assert (de->xml, "button-insert-case")
312 gtk_action_connect_proxy (de->insert_case,
313 get_widget_assert (de->xml, "data_insert-case")
318 de->invoke_goto_dialog =
319 gtk_action_new ("goto-case-dialog",
321 _("Jump to a Case in the Data Sheet"),
325 gtk_action_connect_proxy (de->invoke_goto_dialog,
326 get_widget_assert (de->xml, "button-goto-case")
329 gtk_action_connect_proxy (de->invoke_goto_dialog,
330 get_widget_assert (de->xml, "data_goto-case")
334 g_signal_connect (de->invoke_goto_dialog, "activate",
335 G_CALLBACK (goto_case_dialog), de);
338 de->invoke_weight_cases_dialog =
339 gtk_action_new ("weight-cases-dialog",
341 _("Weight cases by variable"),
342 "pspp-weight-cases");
344 g_signal_connect (de->invoke_weight_cases_dialog, "activate",
345 G_CALLBACK (weight_cases_dialog), de);
348 de->invoke_transpose_dialog =
349 gtk_action_new ("transpose-dialog",
351 _("Transpose the cases with the variables"),
355 g_signal_connect (de->invoke_transpose_dialog, "activate",
356 G_CALLBACK (transpose_dialog), de);
360 de->invoke_split_file_dialog =
361 gtk_action_new ("split-file-dialog",
363 _("Split the active file"),
366 g_signal_connect (de->invoke_split_file_dialog, "activate",
367 G_CALLBACK (split_file_dialog), de);
371 de->invoke_sort_cases_dialog =
372 gtk_action_new ("sort-cases-dialog",
374 _("Sort cases in the active file"),
377 g_signal_connect (de->invoke_sort_cases_dialog, "activate",
378 G_CALLBACK (sort_cases_dialog), de);
381 de->invoke_compute_dialog =
382 gtk_action_new ("compute-dialog",
384 _("Compute new values for a variable"),
387 g_signal_connect (de->invoke_compute_dialog, "activate",
388 G_CALLBACK (compute_dialog), de);
390 de->invoke_comments_dialog =
391 gtk_action_new ("commments-dialog",
392 _("Data File Comments"),
393 _("Commentary text for the data file"),
396 g_signal_connect (de->invoke_comments_dialog, "activate",
397 G_CALLBACK (comments_dialog), de);
399 de->invoke_variable_info_dialog =
400 gtk_action_new ("variable-info-dialog",
402 _("Jump to Variable"),
403 "pspp-goto-variable");
405 g_signal_connect (de->invoke_variable_info_dialog, "activate",
406 G_CALLBACK (variable_info_dialog), de);
408 e->window = GTK_WINDOW (get_widget_assert (de->xml, "data_editor"));
410 g_signal_connect_swapped (get_widget_assert (de->xml,"file_new_data"),
412 G_CALLBACK (gtk_action_activate),
413 de->action_data_new);
415 g_signal_connect_swapped (get_widget_assert (de->xml,"file_open_data"),
417 G_CALLBACK (gtk_action_activate),
418 de->action_data_open);
421 #if RECENT_LISTS_AVAILABLE
423 GtkRecentManager *rm = gtk_recent_manager_get_default ();
424 GtkWidget *recent_data = get_widget_assert (de->xml, "file_recent-data");
425 GtkWidget *recent_files = get_widget_assert (de->xml, "file_recent-files");
426 GtkWidget *recent_separator = get_widget_assert (de->xml, "file_separator1");
428 GtkWidget *menu = gtk_recent_chooser_menu_new_for_manager (rm);
430 GtkRecentFilter *filter = gtk_recent_filter_new ();
432 gtk_widget_show (recent_data);
433 gtk_widget_show (recent_files);
434 gtk_widget_show (recent_separator);
436 gtk_recent_filter_add_pattern (filter, "*.sav");
437 gtk_recent_filter_add_pattern (filter, "*.SAV");
439 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
441 gtk_widget_set_sensitive (recent_data, TRUE);
442 g_signal_connect (menu, "selection-done",
443 G_CALLBACK (on_recent_data_select), de);
445 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_data), menu);
448 filter = gtk_recent_filter_new ();
449 menu = gtk_recent_chooser_menu_new_for_manager (rm);
451 gtk_recent_filter_add_pattern (filter, "*.sps");
452 gtk_recent_filter_add_pattern (filter, "*.SPS");
454 gtk_recent_chooser_add_filter (GTK_RECENT_CHOOSER (menu), filter);
456 gtk_widget_set_sensitive (recent_files, TRUE);
457 g_signal_connect (menu, "selection-done",
458 G_CALLBACK (on_recent_files_select), de);
460 gtk_menu_item_set_submenu (GTK_MENU_ITEM (recent_files), menu);
464 g_signal_connect (get_widget_assert (de->xml,"file_new_syntax"),
466 G_CALLBACK (new_syntax_window),
469 g_signal_connect (get_widget_assert (de->xml,"file_open_syntax"),
471 G_CALLBACK (open_syntax_window),
474 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save"),
476 G_CALLBACK (gtk_action_activate),
477 de->action_data_save);
479 g_signal_connect_swapped (get_widget_assert (de->xml,"file_save_as"),
481 G_CALLBACK (gtk_action_activate),
482 de->action_data_save_as);
484 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
485 get_widget_assert (de->xml, "data_weight-cases")
488 gtk_action_connect_proxy (de->invoke_transpose_dialog,
489 get_widget_assert (de->xml, "data_transpose")
492 gtk_action_connect_proxy (de->invoke_split_file_dialog,
493 get_widget_assert (de->xml, "data_split-file")
496 gtk_action_connect_proxy (de->invoke_sort_cases_dialog,
497 get_widget_assert (de->xml, "data_sort-cases")
500 gtk_action_connect_proxy (de->invoke_compute_dialog,
501 get_widget_assert (de->xml, "transform_compute")
504 gtk_action_connect_proxy (de->invoke_comments_dialog,
505 get_widget_assert (de->xml, "utilities_comments")
508 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
509 get_widget_assert (de->xml, "utilities_variables")
512 g_signal_connect (get_widget_assert (de->xml,"help_about"),
514 G_CALLBACK (about_new),
518 g_signal_connect (get_widget_assert (de->xml,"help_reference"),
520 G_CALLBACK (reference_manual),
523 g_signal_connect (data_sheet,
524 "double-click-column",
525 G_CALLBACK (click2column),
528 g_signal_connect (data_sheet,
530 G_CALLBACK (enable_delete_variables),
533 g_signal_connect (data_sheet,
535 G_CALLBACK (enable_delete_cases),
539 g_signal_connect (var_sheet,
541 GTK_SIGNAL_FUNC (click2row),
544 g_signal_connect_after (var_sheet,
546 G_CALLBACK (enable_delete_variables),
549 g_signal_connect (get_widget_assert (de->xml, "notebook"),
551 G_CALLBACK (data_var_select), de);
555 g_signal_connect (get_widget_assert (de->xml, "view_statusbar"),
557 G_CALLBACK (status_bar_activate), de);
560 g_signal_connect (get_widget_assert (de->xml, "view_gridlines"),
562 G_CALLBACK (grid_lines_activate), de);
566 g_signal_connect (get_widget_assert (de->xml, "view_data"),
568 G_CALLBACK (data_sheet_activate), de);
570 g_signal_connect (get_widget_assert (de->xml, "view_variables"),
572 G_CALLBACK (variable_sheet_activate), de);
576 g_signal_connect (get_widget_assert (de->xml, "view_fonts"),
578 G_CALLBACK (fonts_activate), de);
582 g_signal_connect (get_widget_assert (de->xml, "view_valuelabels"),
584 G_CALLBACK (value_labels_activate), de);
587 g_signal_connect (get_widget_assert (de->xml, "togglebutton-value-labels"),
589 G_CALLBACK (value_labels_toggled), de);
591 gtk_action_connect_proxy (de->action_data_open,
592 get_widget_assert (de->xml, "button-open")
595 gtk_action_connect_proxy (de->action_data_save,
596 get_widget_assert (de->xml, "button-save")
599 gtk_action_connect_proxy (de->invoke_variable_info_dialog,
600 get_widget_assert (de->xml, "button-goto-variable")
603 gtk_action_connect_proxy (de->invoke_weight_cases_dialog,
604 get_widget_assert (de->xml, "button-weight-cases")
607 gtk_action_connect_proxy (de->invoke_split_file_dialog,
608 get_widget_assert (de->xml, "button-split-file")
611 g_signal_connect (get_widget_assert (de->xml, "file_quit"),
613 G_CALLBACK (file_quit), de);
616 g_signal_connect (get_widget_assert (de->xml, "windows_minimise_all"),
618 G_CALLBACK (minimise_all_windows), NULL);
621 create_data_sheet_variable_popup_menu (de);
622 create_data_sheet_cases_popup_menu (de);
624 g_signal_connect (G_OBJECT (data_sheet), "button-event-column",
625 G_CALLBACK (popup_variable_menu), de);
627 g_signal_connect (G_OBJECT (data_sheet), "button-event-row",
628 G_CALLBACK (popup_cases_menu), de);
631 select_sheet (de, PAGE_DATA_SHEET);
637 /* Callback which occurs when the var sheet's row title
638 button is double clicked */
640 click2row (GtkWidget *w, gint row, gpointer data)
642 struct data_editor *de = data;
643 GtkSheetRange visible_range;
645 gint current_row, current_column;
647 GtkWidget *data_sheet = get_widget_assert (de->xml, "data_sheet");
649 data_editor_select_sheet (de, PAGE_DATA_SHEET);
651 gtk_sheet_get_active_cell (GTK_SHEET (data_sheet),
652 ¤t_row, ¤t_column);
654 gtk_sheet_set_active_cell (GTK_SHEET (data_sheet), current_row, row);
656 gtk_sheet_get_visible_range (GTK_SHEET (data_sheet), &visible_range);
658 if ( row < visible_range.col0 || row > visible_range.coli)
660 gtk_sheet_moveto (GTK_SHEET (data_sheet),
661 current_row, row, 0, 0);
668 /* Callback which occurs when the data sheet's column title
671 click2column (GtkWidget *w, gint col, gpointer data)
673 struct data_editor *de = data;
675 gint current_row, current_column;
677 GtkWidget *var_sheet = get_widget_assert (de->xml, "variable_sheet");
679 data_editor_select_sheet (de, PAGE_VAR_SHEET);
681 gtk_sheet_get_active_cell (GTK_SHEET (var_sheet),
682 ¤t_row, ¤t_column);
684 gtk_sheet_set_active_cell (GTK_SHEET (var_sheet), col, current_column);
691 new_data_window (GtkMenuItem *menuitem, gpointer parent)
693 window_create (WINDOW_DATA, NULL);
698 select_sheet (struct data_editor *de, guint page_num)
700 GtkWidget *view_data = get_widget_assert (de->xml, "view_data");
701 GtkWidget *view_variables = get_widget_assert (de->xml, "view_variables");
706 gtk_widget_hide (view_variables);
707 gtk_widget_show (view_data);
708 gtk_action_set_sensitive (de->insert_variable, TRUE);
709 gtk_action_set_sensitive (de->insert_case, FALSE);
710 gtk_action_set_sensitive (de->invoke_goto_dialog, FALSE);
712 case PAGE_DATA_SHEET:
713 gtk_widget_show (view_variables);
714 gtk_widget_hide (view_data);
715 gtk_action_set_sensitive (de->invoke_goto_dialog, TRUE);
716 gtk_action_set_sensitive (de->insert_case, TRUE);
719 g_assert_not_reached ();
726 data_var_select (GtkNotebook *notebook,
727 GtkNotebookPage *page,
731 struct data_editor *de = user_data;
733 select_sheet (de, page_num);
740 data_editor_select_sheet (struct data_editor *de, gint page)
742 gtk_notebook_set_current_page
744 GTK_NOTEBOOK (get_widget_assert (de->xml,"notebook")), page
750 status_bar_activate (GtkCheckMenuItem *menuitem, gpointer data)
752 struct data_editor *de = data;
753 GtkWidget *statusbar = get_widget_assert (de->xml, "status-bar");
755 if ( gtk_check_menu_item_get_active (menuitem) )
756 gtk_widget_show (statusbar);
758 gtk_widget_hide (statusbar);
763 grid_lines_activate (GtkCheckMenuItem *menuitem, gpointer data)
765 struct data_editor *de = data;
766 const bool grid_visible = gtk_check_menu_item_get_active (menuitem);
768 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml,
772 gtk_sheet_show_grid (GTK_SHEET (get_widget_assert (de->xml, "data_sheet")),
779 data_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
781 struct data_editor *de = data;
783 data_editor_select_sheet (de, PAGE_DATA_SHEET);
788 variable_sheet_activate (GtkCheckMenuItem *menuitem, gpointer data)
790 struct data_editor *de = data;
792 data_editor_select_sheet (de, PAGE_VAR_SHEET);
797 fonts_activate (GtkMenuItem *menuitem, gpointer data)
799 struct data_editor *de = data;
801 gtk_font_selection_dialog_new (_("Font Selection"));
803 gtk_window_set_transient_for (GTK_WINDOW (dialog),
804 GTK_WINDOW (get_widget_assert (de->xml,
806 if ( GTK_RESPONSE_OK == gtk_dialog_run (GTK_DIALOG (dialog)) )
808 GtkSheet *data_sheet =
809 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
811 GtkSheet *var_sheet =
812 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
814 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
815 PsppireVarStore *vs = PSPPIRE_VAR_STORE (gtk_sheet_get_model (var_sheet));
817 const gchar *font = gtk_font_selection_dialog_get_font_name
818 (GTK_FONT_SELECTION_DIALOG (dialog));
820 PangoFontDescription* font_desc =
821 pango_font_description_from_string (font);
823 psppire_var_store_set_font (vs, font_desc);
824 psppire_data_store_set_font (ds, font_desc);
827 gtk_widget_hide (dialog);
831 /* The next two callbacks are mutually co-operative */
833 /* Callback for the value labels menu item */
835 value_labels_activate (GtkCheckMenuItem *menuitem, gpointer data)
837 struct data_editor *de = data;
839 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
841 GtkToggleToolButton *tb =
842 GTK_TOGGLE_TOOL_BUTTON (get_widget_assert (de->xml,
843 "togglebutton-value-labels"));
845 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
847 gboolean show_value_labels = gtk_check_menu_item_get_active (menuitem);
849 gtk_toggle_tool_button_set_active (tb, show_value_labels);
851 psppire_data_store_show_labels (ds, show_value_labels);
855 /* Callback for the value labels tooglebutton */
857 value_labels_toggled (GtkToggleToolButton *toggle_tool_button,
860 struct data_editor *de = data;
862 GtkSheet *data_sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
864 GtkCheckMenuItem *item =
865 GTK_CHECK_MENU_ITEM (get_widget_assert (de->xml, "view_valuelabels"));
867 PsppireDataStore *ds = PSPPIRE_DATA_STORE (gtk_sheet_get_model (data_sheet));
869 gboolean show_value_labels =
870 gtk_toggle_tool_button_get_active (toggle_tool_button);
872 gtk_check_menu_item_set_active (item, show_value_labels);
874 psppire_data_store_show_labels (ds, show_value_labels);
879 file_quit (GtkCheckMenuItem *menuitem, gpointer data)
881 /* FIXME: Need to be more intelligent here.
882 Give the user the opportunity to save any unsaved data.
888 delete_cases (GtkAction *action, gpointer data)
890 struct data_editor *de = data;
891 GtkSheet *data_sheet =
892 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
896 PsppireDataStore *data_store = PSPPIRE_DATA_STORE
897 (gtk_sheet_get_model (data_sheet) );
900 /* This shouldn't be able to happen, because the action
901 should be disabled */
902 g_return_if_fail (gtk_sheet_get_state (data_sheet)
903 == GTK_SHEET_ROW_SELECTED );
905 gtk_sheet_get_selected_range (data_sheet, &range);
907 gtk_sheet_unselect_range (data_sheet);
909 psppire_data_store_delete_cases (data_store, range.row0,
910 1 + range.rowi - range.row0);
915 delete_variables (GtkAction *a, gpointer data)
917 struct data_editor *de = data;
920 GtkNotebook *notebook = GTK_NOTEBOOK (get_widget_assert (de->xml,
923 const gint page = gtk_notebook_get_current_page (notebook);
925 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml,
926 (page == PAGE_VAR_SHEET) ?
931 gtk_sheet_get_selected_range (sheet, &range);
937 PsppireVarStore *vs =
938 PSPPIRE_VAR_STORE (gtk_sheet_get_model (sheet));
940 psppire_dict_delete_variables (vs->dict,
947 case PAGE_DATA_SHEET:
949 PsppireDataStore *ds =
950 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
952 psppire_dict_delete_variables (ds->dict,
961 gtk_sheet_unselect_range (sheet);
965 insert_case (GtkAction *action, gpointer data)
968 struct data_editor *de = data;
970 GtkSheet *data_sheet =
971 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
973 PsppireDataStore *ds = PSPPIRE_DATA_STORE
974 (gtk_sheet_get_model (data_sheet) );
977 gtk_sheet_get_active_cell (data_sheet, ¤t_row, NULL);
979 if (current_row < 0) current_row = 0;
981 psppire_data_store_insert_new_case (ds, current_row);
984 /* Insert a new variable before the current row in the variable sheet,
985 or before the current column in the data sheet, whichever is selected */
987 insert_variable (GtkAction *action, gpointer data)
989 struct data_editor *de = data;
992 GtkWidget *notebook = get_widget_assert (de->xml, "notebook");
994 GtkSheet *var_sheet =
995 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
997 PsppireVarStore *vs = PSPPIRE_VAR_STORE
998 (gtk_sheet_get_model (var_sheet) );
1000 switch ( gtk_notebook_get_current_page ( GTK_NOTEBOOK (notebook)) )
1002 case PAGE_VAR_SHEET:
1003 posn = var_sheet->active_cell.row;
1005 case PAGE_DATA_SHEET:
1007 GtkSheet *data_sheet =
1008 GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1010 if ( data_sheet->state == GTK_SHEET_COLUMN_SELECTED )
1011 posn = data_sheet->range.col0;
1013 posn = data_sheet->active_cell.col;
1017 g_assert_not_reached ();
1020 if ( posn == -1 ) posn = 0;
1022 psppire_dict_insert_variable (vs->dict, posn, NULL);
1025 /* Callback for when the dictionary changes its split variables */
1027 on_split_change (PsppireDict *dict, gpointer data)
1029 struct data_editor *de = data;
1031 size_t n_split_vars = dict_get_split_cnt (dict->dict);
1033 GtkWidget *split_status_area =
1034 get_widget_assert (de->xml, "split-file-status-area");
1036 if ( n_split_vars == 0 )
1038 gtk_label_set_text (GTK_LABEL (split_status_area), _("No Split"));
1044 const struct variable *const * split_vars =
1045 dict_get_split_vars (dict->dict);
1047 text = g_string_new (_("Split by "));
1049 for (i = 0 ; i < n_split_vars - 1; ++i )
1051 g_string_append_printf (text, "%s, ", var_get_name (split_vars[i]));
1053 g_string_append (text, var_get_name (split_vars[i]));
1055 gtk_label_set_text (GTK_LABEL (split_status_area), text->str);
1057 g_string_free (text, TRUE);
1062 /* Callback for when the dictionary changes its filter variable */
1064 on_filter_change (GObject *o, gint filter_index, gpointer data)
1066 struct data_editor *de = data;
1067 GtkWidget *filter_status_area =
1068 get_widget_assert (de->xml, "filter-use-status-area");
1070 if ( filter_index == -1 )
1072 gtk_label_set_text (GTK_LABEL (filter_status_area), _("Filter off"));
1076 GtkSheet *var_sheet =
1077 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1079 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1080 (gtk_sheet_get_model (var_sheet) );
1082 struct variable *var = psppire_dict_get_variable (vs->dict,
1085 gchar *text = g_strdup_printf (_("Filter by %s"), var_get_name (var));
1087 gtk_label_set_text (GTK_LABEL (filter_status_area), text);
1093 /* Callback for when the dictionary changes its weights */
1095 on_weight_change (GObject *o, gint weight_index, gpointer data)
1097 struct data_editor *de = data;
1098 GtkWidget *weight_status_area =
1099 get_widget_assert (de->xml, "weight-status-area");
1101 if ( weight_index == -1 )
1103 gtk_label_set_text (GTK_LABEL (weight_status_area), _("Weights off"));
1107 GtkSheet *var_sheet =
1108 GTK_SHEET (get_widget_assert (de->xml, "variable_sheet"));
1110 PsppireVarStore *vs = PSPPIRE_VAR_STORE
1111 (gtk_sheet_get_model (var_sheet) );
1113 struct variable *var = psppire_dict_get_variable (vs->dict,
1116 gchar *text = g_strdup_printf (_("Weight by %s"), var_get_name (var));
1118 gtk_label_set_text (GTK_LABEL (weight_status_area), text);
1127 static void data_save_as_dialog (GtkAction *, struct data_editor *de);
1128 static void new_file (GtkAction *, struct editor_window *de);
1129 static void open_data_dialog (GtkAction *, struct data_editor *de);
1130 static void data_save (GtkAction *action, struct data_editor *e);
1133 /* Create the GtkActions and connect to their signals */
1135 register_data_editor_actions (struct data_editor *de)
1137 de->action_data_open =
1138 gtk_action_new ("data-open-dialog",
1140 _("Open a data file"),
1143 g_signal_connect (de->action_data_open, "activate",
1144 G_CALLBACK (open_data_dialog), de);
1147 de->action_data_save = gtk_action_new ("data-save",
1149 _("Save data to file"),
1152 g_signal_connect (de->action_data_save, "activate",
1153 G_CALLBACK (data_save), de);
1157 de->action_data_save_as = gtk_action_new ("data-save-as-dialog",
1159 _("Save data to file"),
1162 g_signal_connect (de->action_data_save_as, "activate",
1163 G_CALLBACK (data_save_as_dialog), de);
1165 de->action_data_new =
1166 gtk_action_new ("data-new",
1171 g_signal_connect (de->action_data_new, "activate",
1172 G_CALLBACK (new_file), de);
1175 /* Returns true if NAME has a suffix which might denote a PSPP file */
1177 name_has_suffix (const gchar *name)
1179 if ( g_str_has_suffix (name, ".sav"))
1181 if ( g_str_has_suffix (name, ".SAV"))
1183 if ( g_str_has_suffix (name, ".por"))
1185 if ( g_str_has_suffix (name, ".POR"))
1191 /* Append SUFFIX to the filename of DE */
1193 append_filename_suffix (struct data_editor *de, const gchar *suffix)
1195 if ( ! name_has_suffix (de->file_name))
1197 gchar *s = de->file_name;
1198 de->file_name = g_strconcat (de->file_name, suffix, NULL);
1203 /* Save DE to file */
1205 save_file (struct data_editor *de)
1207 struct getl_interface *sss;
1208 struct string file_name ;
1210 g_assert (de->file_name);
1212 ds_init_cstr (&file_name, de->file_name);
1213 gen_quoted_string (&file_name);
1215 if ( de->save_as_portable )
1217 append_filename_suffix (de, ".por");
1218 sss = create_syntax_string_source ("EXPORT OUTFILE=%s.",
1219 ds_cstr (&file_name));
1223 append_filename_suffix (de, ".sav");
1224 sss = create_syntax_string_source ("SAVE OUTFILE=%s.",
1225 ds_cstr (&file_name));
1228 ds_destroy (&file_name);
1230 execute_syntax (sss);
1234 /* Callback for data_save action.
1235 If there's an existing file name, then just save,
1236 otherwise prompt for a file name, then save */
1238 data_save (GtkAction *action, struct data_editor *de)
1243 data_save_as_dialog (action, de);
1247 /* Callback for data_save_as action. Prompt for a filename and save */
1249 data_save_as_dialog (GtkAction *action, struct data_editor *de)
1251 struct editor_window *e = (struct editor_window *) de;
1253 GtkWidget *button_sys;
1255 gtk_file_chooser_dialog_new (_("Save"),
1256 GTK_WINDOW (e->window),
1257 GTK_FILE_CHOOSER_ACTION_SAVE,
1258 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1259 GTK_STOCK_SAVE, GTK_RESPONSE_ACCEPT,
1262 GtkFileFilter *filter = gtk_file_filter_new ();
1263 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1264 gtk_file_filter_add_pattern (filter, "*.sav");
1265 gtk_file_filter_add_pattern (filter, "*.SAV");
1266 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1268 filter = gtk_file_filter_new ();
1269 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1270 gtk_file_filter_add_pattern (filter, "*.por");
1271 gtk_file_filter_add_pattern (filter, "*.POR");
1272 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1274 filter = gtk_file_filter_new ();
1275 gtk_file_filter_set_name (filter, _("All Files"));
1276 gtk_file_filter_add_pattern (filter, "*");
1277 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1280 GtkWidget *button_por;
1281 GtkWidget *vbox = gtk_vbox_new (TRUE, 5);
1283 gtk_radio_button_new_with_label (NULL, _("System File"));
1286 gtk_radio_button_new_with_label
1287 (gtk_radio_button_get_group (GTK_RADIO_BUTTON(button_sys)),
1288 _("Portable File"));
1290 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_sys);
1291 gtk_box_pack_start_defaults (GTK_BOX (vbox), button_por);
1293 gtk_widget_show_all (vbox);
1295 gtk_file_chooser_set_extra_widget (GTK_FILE_CHOOSER(dialog), vbox);
1298 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1300 case GTK_RESPONSE_ACCEPT:
1302 g_free (de->file_name);
1305 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1307 de->save_as_portable =
1308 ! gtk_toggle_button_get_active (GTK_TOGGLE_BUTTON (button_sys));
1312 window_set_name_from_filename (e, de->file_name);
1319 gtk_widget_destroy (dialog);
1323 /* Callback for data_new action.
1324 Performs the NEW FILE command */
1326 new_file (GtkAction *action, struct editor_window *e)
1328 struct data_editor *de = (struct data_editor *) e;
1330 struct getl_interface *sss =
1331 create_syntax_string_source ("NEW FILE.");
1333 execute_syntax (sss);
1335 g_free (de->file_name);
1336 de->file_name = NULL;
1338 default_window_name (e);
1343 open_data_file (const gchar *file_name, struct data_editor *de)
1345 struct getl_interface *sss;
1346 struct string filename;
1348 ds_init_cstr (&filename, file_name);
1350 gen_quoted_string (&filename);
1352 sss = create_syntax_string_source ("GET FILE=%s.",
1353 ds_cstr (&filename));
1355 execute_syntax (sss);
1356 ds_destroy (&filename);
1358 window_set_name_from_filename ((struct editor_window *) de, file_name);
1362 /* Callback for the data_open action.
1363 Prompts for a filename and opens it */
1365 open_data_dialog (GtkAction *action, struct data_editor *de)
1367 struct editor_window *e = (struct editor_window *) de;
1370 gtk_file_chooser_dialog_new (_("Open"),
1371 GTK_WINDOW (e->window),
1372 GTK_FILE_CHOOSER_ACTION_OPEN,
1373 GTK_STOCK_CANCEL, GTK_RESPONSE_CANCEL,
1374 GTK_STOCK_OPEN, GTK_RESPONSE_ACCEPT,
1377 GtkFileFilter *filter = gtk_file_filter_new ();
1378 gtk_file_filter_set_name (filter, _("System Files (*.sav)"));
1379 gtk_file_filter_add_pattern (filter, "*.sav");
1380 gtk_file_filter_add_pattern (filter, "*.SAV");
1381 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1383 filter = gtk_file_filter_new ();
1384 gtk_file_filter_set_name (filter, _("Portable Files (*.por) "));
1385 gtk_file_filter_add_pattern (filter, "*.por");
1386 gtk_file_filter_add_pattern (filter, "*.POR");
1387 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1389 filter = gtk_file_filter_new ();
1390 gtk_file_filter_set_name (filter, _("All Files"));
1391 gtk_file_filter_add_pattern (filter, "*");
1392 gtk_file_chooser_add_filter (GTK_FILE_CHOOSER (dialog), filter);
1397 gchar *dir_name = g_path_get_dirname (de->file_name);
1398 gtk_file_chooser_set_current_folder (GTK_FILE_CHOOSER (dialog),
1403 switch (gtk_dialog_run (GTK_DIALOG (dialog)))
1405 case GTK_RESPONSE_ACCEPT:
1407 g_free (de->file_name);
1409 gtk_file_chooser_get_filename (GTK_FILE_CHOOSER (dialog));
1411 open_data_file (de->file_name, de);
1413 #if RECENT_LISTS_AVAILABLE
1415 GtkRecentManager *manager = gtk_recent_manager_get_default();
1416 gchar *uri = g_filename_to_uri (de->file_name, NULL, NULL);
1418 if ( ! gtk_recent_manager_add_item (manager, uri))
1419 g_warning ("Could not add item %s to recent list\n",uri);
1431 gtk_widget_destroy (dialog);
1436 /* Update the data_ref_entry with the reference of the active cell */
1438 update_data_ref_entry (const GtkSheet *sheet, gint row, gint col, gpointer data)
1440 GladeXML *data_editor_xml = data;
1442 PsppireDataStore *data_store =
1443 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1445 g_return_val_if_fail (data_editor_xml, FALSE);
1449 const struct variable *var =
1450 psppire_dict_get_variable (data_store->dict, col);
1452 /* The entry where the reference to the current cell is displayed */
1453 GtkEntry *cell_ref_entry =
1454 GTK_ENTRY (get_widget_assert (data_editor_xml,
1456 GtkEntry *datum_entry =
1457 GTK_ENTRY (get_widget_assert (data_editor_xml,
1462 gchar *text = g_strdup_printf ("%d: %s", row + FIRST_CASE_NUMBER,
1463 var_get_name (var));
1465 gchar *s = pspp_locale_to_utf8 (text, -1, 0);
1469 gtk_entry_set_text (cell_ref_entry, s);
1474 gtk_entry_set_text (cell_ref_entry, "");
1480 psppire_data_store_get_string (data_store, row,
1481 var_get_dict_index(var));
1484 gtk_entry_set_text (datum_entry, text);
1489 gtk_entry_set_text (datum_entry, "");
1500 do_sort (PsppireDataStore *ds, int var, gboolean descend)
1502 GString *string = g_string_new ("SORT CASES BY ");
1504 const struct variable *v =
1505 psppire_dict_get_variable (ds->dict, var);
1507 g_string_append_printf (string, "%s", var_get_name (v));
1510 g_string_append (string, " (D)");
1512 g_string_append (string, ".");
1514 execute_syntax (create_syntax_string_source (string->str));
1516 g_string_free (string, TRUE);
1521 sort_up (GtkMenuItem *item, gpointer data)
1523 GtkSheet *sheet = data;
1524 GtkSheetRange range;
1525 gtk_sheet_get_selected_range (sheet, &range);
1527 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1533 sort_down (GtkMenuItem *item, gpointer data)
1535 GtkSheet *sheet = data;
1536 GtkSheetRange range;
1537 gtk_sheet_get_selected_range (sheet, &range);
1539 do_sort (PSPPIRE_DATA_STORE (gtk_sheet_get_model(sheet)),
1547 create_data_sheet_variable_popup_menu (struct data_editor *de)
1549 GtkSheet *sheet = GTK_SHEET (get_widget_assert (de->xml, "data_sheet"));
1550 GtkWidget *menu = gtk_menu_new ();
1552 GtkWidget *sort_ascending =
1553 gtk_menu_item_new_with_label (_("Sort Ascending"));
1555 GtkWidget *sort_descending =
1556 gtk_menu_item_new_with_label (_("Sort Descending"));
1559 GtkWidget *insert_variable =
1560 gtk_menu_item_new_with_label (_("Insert Variable"));
1562 GtkWidget *clear_variable =
1563 gtk_menu_item_new_with_label (_("Clear"));
1566 gtk_action_connect_proxy (de->insert_variable,
1570 gtk_action_connect_proxy (de->delete_variables,
1574 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_variable);
1577 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1578 gtk_separator_menu_item_new ());
1581 gtk_menu_shell_append (GTK_MENU_SHELL (menu), clear_variable);
1584 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1585 gtk_separator_menu_item_new ());
1588 g_signal_connect (G_OBJECT (sort_ascending), "activate",
1589 G_CALLBACK (sort_up), sheet);
1591 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_ascending);
1594 g_signal_connect (G_OBJECT (sort_descending), "activate",
1595 G_CALLBACK (sort_down), sheet);
1598 gtk_menu_shell_append (GTK_MENU_SHELL (menu), sort_descending);
1600 gtk_widget_show_all (menu);
1603 de->data_sheet_variable_popup_menu = GTK_MENU(menu);
1608 create_data_sheet_cases_popup_menu (struct data_editor *de)
1610 GtkWidget *menu = gtk_menu_new ();
1612 GtkWidget *insert_case =
1613 gtk_menu_item_new_with_label (_("Insert Case"));
1615 GtkWidget *delete_case =
1616 gtk_menu_item_new_with_label (_("Clear"));
1619 gtk_action_connect_proxy (de->insert_case,
1623 gtk_action_connect_proxy (de->delete_cases,
1627 gtk_menu_shell_append (GTK_MENU_SHELL (menu), insert_case);
1630 gtk_menu_shell_append (GTK_MENU_SHELL (menu),
1631 gtk_separator_menu_item_new ());
1634 gtk_menu_shell_append (GTK_MENU_SHELL (menu), delete_case);
1637 gtk_widget_show_all (menu);
1640 de->data_sheet_cases_popup_menu = GTK_MENU (menu);
1645 popup_variable_menu (GtkSheet *sheet, gint column,
1646 GdkEventButton *event, gpointer data)
1648 struct data_editor *de = data;
1650 PsppireDataStore *data_store =
1651 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1653 const struct variable *v =
1654 psppire_dict_get_variable (data_store->dict, column);
1656 if ( v && event->button == 3)
1659 gtk_sheet_select_column (sheet, column);
1661 gtk_menu_popup (GTK_MENU (de->data_sheet_variable_popup_menu),
1662 NULL, NULL, NULL, NULL,
1663 event->button, event->time);
1669 popup_cases_menu (GtkSheet *sheet, gint row,
1670 GdkEventButton *event, gpointer data)
1672 struct data_editor *de = data;
1674 PsppireDataStore *data_store =
1675 PSPPIRE_DATA_STORE (gtk_sheet_get_model (sheet));
1677 if ( row <= psppire_data_store_get_case_count (data_store) &&
1680 gtk_sheet_select_row (sheet, row);
1682 gtk_menu_popup (GTK_MENU (de->data_sheet_cases_popup_menu),
1683 NULL, NULL, NULL, NULL,
1684 event->button, event->time);