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;
82 casereader_destroy (reader);
87 main (int argc, char *argv[] )
98 gtk_init (&argc, &argv);
101 g_error ("Usage: prog file\n");
107 sp = gnumeric_probe (argv[1], false);
110 if (stuff.sp == NULL)
111 stuff.sp = ods_probe (argv[1], false);
113 if (stuff.sp == NULL)
115 g_error ("%s is neither a gnumeric nor a ods file\n", argv[1]);
119 tm = psppire_spreadsheet_model_new (stuff.sp);
120 window = gtk_window_new (GTK_WINDOW_TOPLEVEL);
121 hbox = gtk_hbox_new (FALSE, 5);
122 vbox = gtk_vbox_new (FALSE, 5);
124 button = gtk_button_new_with_label ("Test reader");
125 g_signal_connect (button, "clicked", G_CALLBACK (on_clicked), &stuff);
127 gtk_container_set_border_width (GTK_CONTAINER (window), 10);
129 stuff.combo_box = gtk_combo_box_new();
132 GtkCellRenderer *renderer = gtk_cell_renderer_text_new ();
133 gtk_cell_layout_pack_start (GTK_CELL_LAYOUT (stuff.combo_box), renderer, TRUE);
134 gtk_cell_layout_set_attributes (GTK_CELL_LAYOUT (stuff.combo_box), renderer,
139 gtk_combo_box_set_model (GTK_COMBO_BOX (stuff.combo_box), tm);
141 gtk_combo_box_set_active (GTK_COMBO_BOX (stuff.combo_box), 0);
143 treeview = gtk_tree_view_new_with_model (tm);
145 gtk_tree_view_insert_column_with_attributes (GTK_TREE_VIEW (treeview),
147 gtk_cell_renderer_text_new (),
152 gtk_tree_view_insert_column_with_attributes (GTK_TREE_VIEW (treeview),
154 gtk_cell_renderer_text_new (),
159 gtk_box_pack_start (GTK_BOX (hbox), treeview, TRUE, TRUE, 5);
161 gtk_box_pack_start (GTK_BOX (vbox), stuff.combo_box, FALSE, FALSE, 5);
162 gtk_box_pack_start (GTK_BOX (vbox), button, FALSE, FALSE, 5);
163 gtk_box_pack_start (GTK_BOX (hbox), vbox, TRUE, TRUE, 5);
165 gtk_container_add (GTK_CONTAINER (window), hbox);
167 g_signal_connect (window, "destroy", gtk_main_quit, 0);
169 gtk_widget_show_all (window);
173 // gnumeric_destroy (sp);