5 #include "psppire-spreadsheet-model.h"
7 #include "data/gnumeric-reader.h"
8 #include "data/ods-reader.h"
9 #include "data/spreadsheet-reader.h"
10 #include "data/casereader.h"
11 #include "data/case.h"
23 GtkListStore * list_store = gtk_list_store_new (2, G_TYPE_INT, G_TYPE_STRING);
25 for (i = 0; i < N; ++i)
27 gtk_list_store_append (list_store, &iter);
28 gtk_list_store_set (list_store, &iter,
40 struct spreadsheet *sp;
47 on_clicked (GtkButton *button, struct xxx *stuff)
49 const struct caseproto *proto;
52 gint x = gtk_combo_box_get_active (GTK_COMBO_BOX (stuff->combo_box));
53 struct casereader *reader ;
54 struct spreadsheet_read_options opts;
56 g_print( "%s %d\n", __FUNCTION__, x);
58 opts.sheet_index = x + 1;
59 opts.cell_range = NULL;
60 opts.sheet_name = NULL;
61 opts.read_names = TRUE;
64 reader = ods_make_reader (stuff->sp, &opts);
65 proto = casereader_get_proto (reader);
67 nvals = caseproto_get_n_widths (proto);
70 (c = casereader_read (reader)) != NULL; case_unref (c))
74 for (i = 0; i < nvals ; ++i)
76 const double val = case_data_idx (c, i)->f;
85 main (int argc, char *argv[] )
96 gtk_init (&argc, &argv);
99 g_error ("Usage: prog file\n");
105 sp = gnumeric_probe (argv[1], false);
108 if (stuff.sp == NULL)
109 stuff.sp = ods_probe (argv[1], false);
111 if (stuff.sp == NULL)
113 g_error ("%s is neither a gnumeric nor a ods file\n", argv[1]);
117 tm = psppire_spreadsheet_model_new (stuff.sp);
118 window = gtk_window_new (GTK_WINDOW_TOPLEVEL);
119 hbox = gtk_hbox_new (FALSE, 5);
120 vbox = gtk_vbox_new (FALSE, 5);
122 button = gtk_button_new_with_label ("Test reader");
123 g_signal_connect (button, "clicked", G_CALLBACK (on_clicked), &stuff);
125 gtk_container_set_border_width (GTK_CONTAINER (window), 10);
127 stuff.combo_box = gtk_combo_box_new();
130 GtkCellRenderer *renderer = gtk_cell_renderer_text_new ();
131 gtk_cell_layout_pack_start (GTK_CELL_LAYOUT (stuff.combo_box), renderer, TRUE);
132 gtk_cell_layout_set_attributes (GTK_CELL_LAYOUT (stuff.combo_box), renderer,
137 gtk_combo_box_set_model (GTK_COMBO_BOX (stuff.combo_box), tm);
139 gtk_combo_box_set_active (GTK_COMBO_BOX (stuff.combo_box), 0);
141 treeview = gtk_tree_view_new_with_model (tm);
143 gtk_tree_view_insert_column_with_attributes (GTK_TREE_VIEW (treeview),
145 gtk_cell_renderer_text_new (),
150 gtk_tree_view_insert_column_with_attributes (GTK_TREE_VIEW (treeview),
152 gtk_cell_renderer_text_new (),
157 gtk_box_pack_start (GTK_BOX (hbox), treeview, TRUE, TRUE, 5);
159 gtk_box_pack_start (GTK_BOX (vbox), stuff.combo_box, FALSE, FALSE, 5);
160 gtk_box_pack_start (GTK_BOX (vbox), button, FALSE, FALSE, 5);
161 gtk_box_pack_start (GTK_BOX (hbox), vbox, TRUE, TRUE, 5);
163 gtk_container_add (GTK_CONTAINER (window), hbox);
165 g_signal_connect (window, "destroy", gtk_main_quit, 0);
167 gtk_widget_show_all (window);
171 // gnumeric_destroy (sp);