sheet.h 5.95 KB
Newer Older
Arturo Espinosa's avatar
Arturo Espinosa committed
1 2
#ifndef SHEET_H
#define SHEET_H
3

4 5 6
#define SHEET_MAX_ROWS (16 * 1024)
#define SHEET_MAX_COLS 256

7 8 9 10 11
typedef GList ColStyleList;

struct Workbook;

typedef struct {
Arturo Espinosa's avatar
Arturo Espinosa committed
12 13
	GtkWidget  *toplevel;
	GtkWidget  *notebook;
14 15 16 17 18 19
	GtkWidget  *table;

	/* Edit area */
	GtkWidget  *ea_status;
	GtkWidget  *ea_button_box;
	GtkWidget  *ea_input;
Arturo Espinosa's avatar
Arturo Espinosa committed
20 21 22 23

	/* The auto-expression */
	ExprTree   *auto_expr;
	GnomeCanvasItem  *auto_expr_label;
Arturo Espinosa's avatar
Arturo Espinosa committed
24
	
Arturo Espinosa's avatar
Arturo Espinosa committed
25
	/* Styles */
Arturo Espinosa's avatar
Arturo Espinosa committed
26 27
	Style      style;
	GHashTable *sheets;	/* keeps a list of the Sheets on this workbook */
28 29 30 31 32

	/* A list with all of the formulas */
	GList      *formula_cell_list;

	int        max_iterations;
Arturo Espinosa's avatar
Arturo Espinosa committed
33 34
} Workbook;

35 36 37 38 39 40
typedef struct {
	int        base_col, base_row;
	int        start_col, start_row;
	int        end_col, end_row;
} SheetSelection;

Arturo Espinosa's avatar
Arturo Espinosa committed
41
typedef struct {
42 43
	int        signature;
	
Arturo Espinosa's avatar
Arturo Espinosa committed
44
	Workbook   *parent_workbook;
45
	GtkWidget  *toplevel, *col_canvas, *row_canvas;
Arturo Espinosa's avatar
Arturo Espinosa committed
46
	GtkWidget  *sheet_view;
47 48 49
	GnomeCanvasItem *col_item, *row_item;
	
	double     last_zoom_factor_used;
50 51 52
	char       *name;
		   
	Style      style;
53

54
	ColRowInfo default_col_style;
55
	GList      *cols_info;
56

57
	ColRowInfo default_row_style;
58
	GList      *rows_info;
Arturo Espinosa's avatar
Arturo Espinosa committed
59

60
	GHashTable *cell_hash;	/* The cells in hashed format */
61 62 63 64 65 66 67 68 69

	GList      *selections;

	/* Scrolling information */
	GtkWidget  *vs, *hs;	/* The scrollbars */
	GtkObject  *va, *ha;    /* The adjustments */
	
	int        max_col_used;
	int        max_row_used;
70 71 72

	/* The list of formulas */
	GList      *formula_cell_list;
73 74
} Sheet;

75 76 77
#define SHEET_SIGNATURE 0x12349876
#define IS_SHEET(x) (((Sheet *) x)->signature == SHEET_SIGNATURE)

Arturo Espinosa's avatar
Arturo Espinosa committed
78 79 80
typedef  void (*sheet_col_row_callback)(Sheet *sheet, ColRowInfo *ci,
					void *user_data);

Arturo Espinosa's avatar
Arturo Espinosa committed
81 82
typedef  int (*sheet_cell_foreach_callback)(Sheet *sheet, int col, int row,
					    Cell *cell, void *user_data);
83

84 85 86 87 88 89 90 91
Sheet      *sheet_new                 (Workbook *wb, char *name);
void        sheet_destroy             (Sheet *sheet);
void        sheet_foreach_col         (Sheet *sheet, sheet_col_row_callback, void *user_data);
void        sheet_foreach_row         (Sheet *sheet, sheet_col_row_callback, void *user_data);
void        sheet_set_zoom_factor     (Sheet *sheet, double factor);
void        sheet_get_cell_bounds     (Sheet *sheet, ColType col, RowType row, int *x, int *y, int *w, int *h);

/* Selection management */
92
void        sheet_select_all             (Sheet *sheet);
93 94 95 96 97 98 99 100
void        sheet_selection_append       (Sheet *sheet, int col, int row);
void        sheet_selection_extend_to    (Sheet *sheet, int col, int row);
void        sheet_selection_clear        (Sheet *sheet);
void        sheet_selection_clear_only   (Sheet *sheet);
int         sheet_selection_equal        (SheetSelection *a, SheetSelection *b);
void        sheet_selection_append_range (Sheet *sheet, int base_col,  int base_row,
					  int start_col, int start_row,
					  int end_col,   int end_row);
101

102 103 104
void        sheet_selection_extend_horizontal (Sheet *sheet, int count);
void        sheet_selection_extend_vertical   (Sheet *sheet, int count);
int         sheet_selection_is_cell_selected  (Sheet *sheet, int col, int row);
Arturo Espinosa's avatar
Arturo Espinosa committed
105

Arturo Espinosa's avatar
Arturo Espinosa committed
106 107
/* Computation */
void        sheet_compute_cell        (Sheet *sheet, Cell *cell);
108

Arturo Espinosa's avatar
Arturo Espinosa committed
109 110
/* Cell management */
Cell       *sheet_cell_new            (Sheet *sheet, int col, int row);
Arturo Espinosa's avatar
Arturo Espinosa committed
111
int         sheet_cell_foreach_range  (Sheet *sheet, int only_existing,
Arturo Espinosa's avatar
Arturo Espinosa committed
112 113 114 115 116 117 118 119
				       int start_col, int start_row,
				       int end_col, int end_row,
				       sheet_cell_foreach_callback callback,
				       void *closure);
Cell       *sheet_cell_get            (Sheet *sheet, int col, int row);
void        cell_set_text             (Sheet *sheet, Cell *cell, char *text);
void        cell_set_formula          (Sheet *sheet, Cell *cell, char *text);

Arturo Espinosa's avatar
Arturo Espinosa committed
120
/* Create new ColRowInfos from the default sheet style */
121 122
ColRowInfo *sheet_col_new             (Sheet *sheet);
ColRowInfo *sheet_row_new             (Sheet *sheet);
123 124
int         sheet_row_check_bound     (int row, int diff);
int         sheet_col_check_bound     (int col, int diff);
Arturo Espinosa's avatar
Arturo Espinosa committed
125 126

/* Duplicates the information of a col/row */
127
ColRowInfo *sheet_duplicate_colrow    (ColRowInfo *original);
Arturo Espinosa's avatar
Arturo Espinosa committed
128 129

/* Retrieve information from a col/row */
130 131
ColRowInfo *sheet_col_get_info        (Sheet *sheet, int col);
ColRowInfo *sheet_row_get_info        (Sheet *sheet, int row);
Arturo Espinosa's avatar
Arturo Espinosa committed
132

Arturo Espinosa's avatar
Arturo Espinosa committed
133 134 135 136
/* Returns a pointer to a ColRowInfo: existed or freshly created */
ColRowInfo *sheet_row_get             (Sheet *sheet, int pos);
ColRowInfo *sheet_col_get             (Sheet *sheet, int pos);

Arturo Espinosa's avatar
Arturo Espinosa committed
137
/* Add a ColRowInfo to the Sheet */
138 139
void        sheet_col_add             (Sheet *sheet, ColRowInfo *cp);
void        sheet_row_add             (Sheet *sheet, ColRowInfo *cp);
Arturo Espinosa's avatar
Arturo Espinosa committed
140 141

/* Measure distances in pixels from one col/row to another */
142 143
int         sheet_col_get_distance    (Sheet *sheet, int from_col, int to_col);
int         sheet_row_get_distance    (Sheet *sheet, int from_row, int to_row);
Arturo Espinosa's avatar
Arturo Espinosa committed
144 145

/* Sets the width/height of a column row in terms of pixels */
146 147
void        sheet_col_set_width       (Sheet *sheet, int col, int width);
void        sheet_row_set_height      (Sheet *sheet, int row, int width);
148 149
void        sheet_col_set_selection   (Sheet *sheet, ColRowInfo *ci, int value);
void        sheet_row_set_selection   (Sheet *sheet, ColRowInfo *ri, int value);
Arturo Espinosa's avatar
Arturo Espinosa committed
150

Arturo Espinosa's avatar
Arturo Espinosa committed
151 152
Style      *sheet_style_compute       (Sheet *sheet, int col, int row);

153 154 155 156
/* Redraw */
void        sheet_redraw_cell_region  (Sheet *sheet, int start_col, int start_row,
				       int end_col, int end_row);
void        sheet_redraw_selection    (Sheet *sheet, SheetSelection *ss);
Arturo Espinosa's avatar
Arturo Espinosa committed
157
void        sheet_redraw_all          (Sheet *sheet);
Arturo Espinosa's avatar
Arturo Espinosa committed
158

159 160 161 162
Workbook   *workbook_new                 (void);
Workbook   *workbook_new_with_sheets     (int sheet_count);
void        workbook_attach_sheet        (Workbook *, Sheet *);
Sheet      *workbook_focus_current_sheet (Workbook *wb);
Arturo Espinosa's avatar
Arturo Espinosa committed
163
Sheet      *workbook_get_current_sheet   (Workbook *wb);
Arturo Espinosa's avatar
Arturo Espinosa committed
164

165 166 167 168
/*
 * Callback routine: invoked when the first view ItemGrid
 * is realized to allocate the default styles
 */
169
void     workbook_realized            (Workbook *, GdkWindow *);
170

171
extern   Workbook *current_workbook;
172
#endif