1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
/**
* ms-excel-write.h: MS Excel export
*
* Author:
* Michael Meeks (michael@ximian.com)
* Jody Goldberg (jody@gnome.org)
*
* (C) 1998-2004 Jody Goldberg, Michael Meeks
**/
#ifndef GNUMERIC_MS_EXCEL_WRITE_H
#define GNUMERIC_MS_EXCEL_WRITE_H
#include "ms-biff.h"
#include "ms-excel-biff.h"
#include "ms-excel-util.h"
#include "style.h"
typedef struct {
Sheet const *a, *b;
int idx_a, idx_b;
} ExcelSheetPair;
typedef struct {
/* Don't use GnmFont. In the case where a font does not exist on the
* display system it does the wrong thing. GnmStyle can contain an
* invalid font. GnmFont gets remapped to the default
*/
guint32 color;
char const *font_name;
char *font_name_copy; /* some times we need to keep a local copy */
double size_pts;
gboolean is_bold;
gboolean is_italic;
gboolean is_auto;
StyleUnderlineType underline;
gboolean strikethrough;
} ExcelFont;
typedef struct {
ExcelWriteState *ewb;
Sheet *gnum_sheet;
unsigned streamPos;
guint32 boundsheetPos;
gint32 max_col, max_row;
guint16 col_xf [SHEET_MAX_COLS];
GnmStyle *col_style [SHEET_MAX_COLS];
GnmStyleList *validations;
GSList *blips, *textboxes;
unsigned cur_obj, num_objs, num_blips;
} ExcelWriteSheet;
struct _ExcelWriteState {
BiffPut *bp;
IOContext *io_context;
Workbook const *gnum_wb;
WorkbookView const *gnum_wb_view;
GPtrArray *sheets;
struct {
TwoWayTable *two_way_table;
GnmStyle *default_style;
int default_style_index;
GHashTable *value_fmt_styles;
} xf;
struct {
TwoWayTable *two_way_table;
guint8 entry_in_use[EXCEL_DEF_PAL_LEN];
} pal;
struct {
TwoWayTable *two_way_table;
} fonts;
struct {
TwoWayTable *two_way_table;
} formats;
GHashTable *function_map;
GHashTable *sheet_pairs;
GHashTable *cell_markup;
/* we use the ewb as a closure for things, this is useful */
int tmp_counter;
int supbook_idx;
gboolean double_stream_file;
GPtrArray *externnames;
GHashTable *names;
unsigned streamPos;
/* no need to use a full fledged two table, we already know that the
* Strings are unique. */
struct {
GHashTable *strings;
GPtrArray *indicies;
} sst;
unsigned num_obj_groups, cur_obj_group, cur_blip;
gboolean export_macros;
};
#define XF_RESERVED 21
#define XF_MAGIC 0
#define FONTS_MINIMUM 5
#define FONT_SKIP 4
#define FONT_MAGIC 0
#define FORMAT_MAGIC 0
#define PALETTE_BLACK 8
#define PALETTE_WHITE 9
#define PALETTE_AUTO_PATTERN 64
#define PALETTE_AUTO_BACK 65
#define PALETTE_AUTO_FONT 0x7fff
#define FILL_NONE 0
#define FILL_SOLID 1
#define FILL_MAGIC FILL_NONE
#define BORDER_MAGIC STYLE_BORDER_NONE
typedef enum {
STR_NO_LENGTH = 0,
STR_ONE_BYTE_LENGTH = 1,
STR_TWO_BYTE_LENGTH = 2,
STR_LENGTH_MASK = 3,
/* biff7 will always be LEN_IN_BYTES,
* biff8 will respect the flag and default to length in characters */
STR_LEN_IN_BYTES = 4,
STR_SUPPRESS_HEADER = 8
} WriteStringFlags;
unsigned excel_write_string_len (guint8 const *txt, size_t *bytes);
unsigned excel_write_string (BiffPut *bp, WriteStringFlags flags,
guint8 const *txt);
unsigned excel_write_BOF (BiffPut *bp, MsBiffFileType type);
void excel_write_SETUP (BiffPut *bp, ExcelWriteSheet *esheet);
void excel_write_SCL (BiffPut *bp, double zoom, gboolean force);
gint palette_get_index (ExcelWriteState *ewb, guint c);
int excel_write_get_externsheet_idx (ExcelWriteState *wb,
Sheet *gnum_sheeta,
Sheet *gnum_sheetb);
int excel_write_map_errcode (GnmValue const *v);
#endif
|
