1 |
/* |
2 |
parse_formula.c - Part of psiconv, a PSION 5 file formats converter |
3 |
Copyright (c) 2001 Frodo Looijaard <frodol@dds.nl> |
4 |
|
5 |
This program is free software; you can redistribute it and/or modify |
6 |
it under the terms of the GNU General Public License as published by |
7 |
the Free Software Foundation; either version 2 of the License, or |
8 |
(at your option) any later version. |
9 |
|
10 |
This program is distributed in the hope that it will be useful, |
11 |
but WITHOUT ANY WARRANTY; without even the implied warranty of |
12 |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
13 |
GNU General Public License for more details. |
14 |
|
15 |
You should have received a copy of the GNU General Public License |
16 |
along with this program; if not, write to the Free Software |
17 |
Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. |
18 |
*/ |
19 |
|
20 |
#include "config.h" |
21 |
#include "compat.h" |
22 |
|
23 |
#include <stdlib.h> |
24 |
|
25 |
#include "parse_routines.h" |
26 |
#include "error.h" |
27 |
|
28 |
struct formula_element |
29 |
{ |
30 |
psiconv_formula_type_t formula_type; |
31 |
int number_of_args; |
32 |
const char* name; |
33 |
}; |
34 |
|
35 |
static struct formula_element formula_elements[256] = |
36 |
{ |
37 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* 0 */ |
38 |
{psiconv_formula_op_lt,2,"<"}, |
39 |
{psiconv_formula_op_le,2,"<="}, |
40 |
{psiconv_formula_op_gt,2,">"}, |
41 |
{psiconv_formula_op_ge,2,">="}, |
42 |
{psiconv_formula_op_ne,2,"<>"}, |
43 |
{psiconv_formula_op_eq,2,"="}, |
44 |
{psiconv_formula_op_add,2,"+"}, |
45 |
{psiconv_formula_op_sub,2,"-"}, |
46 |
{psiconv_formula_op_mul,2,"*"}, |
47 |
{psiconv_formula_op_div,2,"/"}, |
48 |
{psiconv_formula_op_pow,2,"^"}, |
49 |
{psiconv_formula_op_pos,1,"+"}, |
50 |
{psiconv_formula_op_neg,1,"-"}, |
51 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
52 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
53 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* 10 */ |
54 |
{psiconv_formula_op_con,2,"&"}, |
55 |
{psiconv_formula_op_bra,1,"{}"}, |
56 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
57 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
58 |
{psiconv_formula_mark_eof,0,"End of formula"}, |
59 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
60 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
61 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
62 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
63 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
64 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
65 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
66 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
67 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
68 |
{psiconv_formula_dat_float,0,"Floating point number"}, |
69 |
{psiconv_formula_dat_int,0,"Signed integer number"}, /* 20 */ |
70 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
71 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
72 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
73 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
74 |
{psiconv_formula_dat_var,0,"Named variable"}, |
75 |
{psiconv_formula_dat_string,0,"String"}, |
76 |
{psiconv_formula_dat_cellref,0,"Cell reference"}, |
77 |
{psiconv_formula_dat_cellblock,0,"Cell block"}, |
78 |
{psiconv_formula_dat_vcellblock,0,"Cell block {varargs}"}, |
79 |
{psiconv_formula_mark_opsep,0,"Operand separator"}, |
80 |
{psiconv_formula_mark_opend,0,"Operand list end"}, |
81 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
82 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
83 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
84 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
85 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* 30 */ |
86 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
87 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
88 |
{psiconv_formula_fun_false,0,"FALSE"}, |
89 |
{psiconv_formula_fun_if,3,"IF"}, |
90 |
{psiconv_formula_fun_true,0,"TRUE"}, |
91 |
{psiconv_formula_fun_cell,2,"CELL"}, |
92 |
{psiconv_formula_fun_errortype,0,"ERRORTYPE"}, |
93 |
{psiconv_formula_fun_isblank,1,"ISBLANK"}, |
94 |
{psiconv_formula_fun_iserr,1,"ISERR"}, |
95 |
{psiconv_formula_fun_iserror,1,"ISERROR"}, |
96 |
{psiconv_formula_fun_islogical,1,"ISLOGICAL"}, |
97 |
{psiconv_formula_fun_isna,1,"ISNA"}, |
98 |
{psiconv_formula_fun_isnontext,1,"ISNONTEXT"}, |
99 |
{psiconv_formula_fun_isnumber,1,"ISNUMBER"}, |
100 |
{psiconv_formula_fun_istext,1,"ISTEXT"}, |
101 |
{psiconv_formula_fun_n,1,"N"}, /* 40 */ |
102 |
{psiconv_formula_fun_type,1,"TYPE"}, |
103 |
{psiconv_formula_fun_address,2,"ADDRESS"}, |
104 |
{psiconv_formula_fun_column,1,"COLUMN"}, |
105 |
{psiconv_formula_fun_columns,1,"COLUMNS"}, |
106 |
{psiconv_formula_fun_hlookup,3,"HLOOKUP"}, |
107 |
{psiconv_formula_fun_index,3,"INDEX"}, |
108 |
{psiconv_formula_fun_indirect,1,"INDIRECT"}, |
109 |
{psiconv_formula_fun_lookup,3,"LOOKUP"}, |
110 |
{psiconv_formula_fun_offset,3,"OFFSET"}, |
111 |
{psiconv_formula_fun_row,1,"ROW"}, |
112 |
{psiconv_formula_fun_rows,1,"ROWS"}, |
113 |
{psiconv_formula_fun_vlookup,3,"VLOOKUP"}, |
114 |
{psiconv_formula_fun_char,1,"CHAR"}, |
115 |
{psiconv_formula_fun_code,1,"CODE"}, |
116 |
{psiconv_formula_fun_exact,2,"EXACT"}, |
117 |
{psiconv_formula_fun_find,3,"FIND"}, /* 50 */ |
118 |
{psiconv_formula_fun_left,2,"LEFT"}, |
119 |
{psiconv_formula_fun_len,1,"LEN"}, |
120 |
{psiconv_formula_fun_lower,1,"LOWER"}, |
121 |
{psiconv_formula_fun_mid,3,"MID"}, |
122 |
{psiconv_formula_fun_proper,1,"PROPER"}, |
123 |
{psiconv_formula_fun_replace,4,"REPLACE"}, |
124 |
{psiconv_formula_fun_rept,2,"REPT"}, |
125 |
{psiconv_formula_fun_right,2,"RIGHT"}, |
126 |
{psiconv_formula_fun_string,2,"STRING"}, |
127 |
{psiconv_formula_fun_t,1,"T"}, |
128 |
{psiconv_formula_fun_trim,1,"TRIM"}, |
129 |
{psiconv_formula_fun_upper,1,"UPPER"}, |
130 |
{psiconv_formula_fun_value,1,"VALUE"}, |
131 |
{psiconv_formula_fun_date,3,"DATE"}, |
132 |
{psiconv_formula_fun_datevalue,1,"DATEVALUE"}, |
133 |
{psiconv_formula_fun_day,1,"DAY"}, /* 60 */ |
134 |
{psiconv_formula_fun_hour,1,"HOUR"}, |
135 |
{psiconv_formula_fun_minute,1,"MINUTE"}, |
136 |
{psiconv_formula_fun_month,1,"MONTH"}, |
137 |
{psiconv_formula_fun_now,0,"NOW"}, |
138 |
{psiconv_formula_fun_second,1,"SECOND"}, |
139 |
{psiconv_formula_fun_today,0,"TODAY"}, |
140 |
{psiconv_formula_fun_time,3,"TIME"}, |
141 |
{psiconv_formula_fun_timevalue,1,"TIMEVALUE"}, |
142 |
{psiconv_formula_fun_year,1,"YEAR"}, |
143 |
{psiconv_formula_fun_abs,1,"ABS"}, |
144 |
{psiconv_formula_fun_acos,1,"ACOS"}, |
145 |
{psiconv_formula_fun_asin,1,"ASIN"}, |
146 |
{psiconv_formula_fun_atan,1,"ATAN"}, |
147 |
{psiconv_formula_fun_atan2,2,"ATAN2"}, |
148 |
{psiconv_formula_fun_cos,1,"COS"}, |
149 |
{psiconv_formula_fun_degrees,0,"DEGREES"}, /* 70 */ |
150 |
{psiconv_formula_fun_exp,1,"EXP"}, |
151 |
{psiconv_formula_fun_fact,1,"FACT"}, |
152 |
{psiconv_formula_fun_int,1,"INT"}, |
153 |
{psiconv_formula_fun_ln,1,"LN"}, |
154 |
{psiconv_formula_fun_log10,1,"LOG10"}, |
155 |
{psiconv_formula_fun_mod,2,"MOD"}, |
156 |
{psiconv_formula_fun_pi,0,"PI"}, |
157 |
{psiconv_formula_fun_radians,1,"RADIANS"}, |
158 |
{psiconv_formula_fun_rand,0,"RAND"}, |
159 |
{psiconv_formula_fun_round,2,"ROUND"}, |
160 |
{psiconv_formula_fun_sign,1,"SIGN"}, |
161 |
{psiconv_formula_fun_sin,1,"SIN"}, |
162 |
{psiconv_formula_fun_sqrt,1,"SQRT"}, |
163 |
{psiconv_formula_fun_sumproduct,2,"SUMPRODUCT"}, |
164 |
{psiconv_formula_fun_tan,1,"TAN"}, |
165 |
{psiconv_formula_fun_trunc,1,"TRUNC"}, /* 80 */ |
166 |
{psiconv_formula_fun_cterm,3,"CTERM"}, |
167 |
{psiconv_formula_fun_ddb,4,"DDB"}, |
168 |
{psiconv_formula_fun_fv,3,"FV"}, |
169 |
{psiconv_formula_fun_irr,2,"IRR"}, |
170 |
{psiconv_formula_fun_npv,2,"NPV"}, |
171 |
{psiconv_formula_fun_pmt,3,"PMT"}, |
172 |
{psiconv_formula_fun_pv,3,"PV"}, |
173 |
{psiconv_formula_fun_rate,3,"RATE"}, |
174 |
{psiconv_formula_fun_sln,3,"SLN"}, |
175 |
{psiconv_formula_fun_syd,4,"SYD"}, |
176 |
{psiconv_formula_fun_term,3,"TERM"}, |
177 |
{psiconv_formula_fun_combin,2,"COMBIN"}, |
178 |
{psiconv_formula_fun_permut,2,"PERMUT"}, |
179 |
{psiconv_formula_vfn_average,-1,"AVERAGE"}, |
180 |
{psiconv_formula_vfn_choose,-1,"CHOOSE"}, |
181 |
{psiconv_formula_vfn_count,-1,"COUNT"}, /* 90 */ |
182 |
{psiconv_formula_vfn_counta,-1,"COUNTA"}, |
183 |
{psiconv_formula_vfn_countblank,-1,"COUNTBLANK"}, |
184 |
{psiconv_formula_vfn_max,-1,"MAX"}, |
185 |
{psiconv_formula_vfn_min,-1,"MIN"}, |
186 |
{psiconv_formula_vfn_product,-1,"PRODUCT"}, |
187 |
{psiconv_formula_vfn_stdevp,-1,"STDEVP"}, |
188 |
{psiconv_formula_vfn_stdev,-1,"STDEV"}, |
189 |
{psiconv_formula_vfn_sum,-1,"SUM"}, |
190 |
{psiconv_formula_vfn_sumsq,-1,"SUMSQ"}, |
191 |
{psiconv_formula_vfn_varp,-1,"VARP"}, |
192 |
{psiconv_formula_vfn_var,-1,"VAR"}, |
193 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
194 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
195 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
196 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
197 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* A0 */ |
198 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
199 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
200 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
201 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
202 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
203 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
204 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
205 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
206 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
207 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
208 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
209 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
210 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
211 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
212 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
213 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* B0 */ |
214 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
215 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
216 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
217 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
218 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
219 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
220 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
221 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
222 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
223 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
224 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
225 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
226 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
227 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
228 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
229 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* C0 */ |
230 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
231 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
232 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
233 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
234 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
235 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
236 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
237 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
238 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
239 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
240 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
241 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
242 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
243 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
244 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
245 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* D0 */ |
246 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
247 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
248 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
249 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
250 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
251 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
252 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
253 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
254 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
255 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
256 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
257 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
258 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
259 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
260 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
261 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* E0 */ |
262 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
263 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
264 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
265 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
266 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
267 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
268 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
269 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
270 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
271 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
272 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
273 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
274 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
275 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
276 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
277 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, /* F0 */ |
278 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
279 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
280 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
281 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
282 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
283 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
284 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
285 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
286 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
287 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
288 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
289 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
290 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
291 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}, |
292 |
{psiconv_formula_unknown,0,"*UNKNOWN*"}}; |
293 |
|
294 |
|
295 |
static int psiconv_parse_sheet_ref(const psiconv_buffer buf,int lev, |
296 |
psiconv_u32 off, int *length, |
297 |
psiconv_sheet_ref_t *result) |
298 |
{ |
299 |
int res; |
300 |
psiconv_u16 temp; |
301 |
|
302 |
psiconv_progress(lev+1,off,"Going to read a sheet ref"); |
303 |
psiconv_progress(lev+2,off,"Going to read the offset encoding"); |
304 |
temp = psiconv_read_u16(buf,lev+2,off,&res); |
305 |
if (res) { |
306 |
if (length) |
307 |
*length = 0; |
308 |
return res; |
309 |
} |
310 |
psiconv_debug(lev+2,off,"Encoded word: %04x",temp); |
311 |
result->absolute = (temp & 0x4000)?psiconv_bool_true:psiconv_bool_false; |
312 |
result->offset = (temp & 0x3fff) * ((temp & 0x8000)?-1:1); |
313 |
psiconv_debug(lev+2,off,"Reference: %s offset %d", |
314 |
result->absolute?"absolute":"relative",result->offset); |
315 |
if (length) |
316 |
*length = 2; |
317 |
return 0; |
318 |
} |
319 |
|
320 |
static int psiconv_parse_sheet_cell_reference(const psiconv_buffer buf,int lev, |
321 |
psiconv_u32 off, int *length, |
322 |
psiconv_sheet_cell_reference_t *result) |
323 |
{ |
324 |
int len = 0; |
325 |
int leng,res; |
326 |
psiconv_u8 temp; |
327 |
|
328 |
psiconv_progress(lev+1,off+len,"Going to read a sheet cell reference"); |
329 |
psiconv_progress(lev+2,off+len,"Going to read the row reference"); |
330 |
if ((res = psiconv_parse_sheet_ref(buf,lev+2,off+len,&leng,&result->row))) |
331 |
goto ERROR; |
332 |
len += leng; |
333 |
psiconv_progress(lev+2,off+len,"Going to read the column reference"); |
334 |
if ((res = psiconv_parse_sheet_ref(buf,lev+2,off+len,&leng,&result->column))) |
335 |
goto ERROR; |
336 |
len += leng; |
337 |
|
338 |
psiconv_progress(lev+2,off+len, |
339 |
"Going to read the trailing byte (%02x expected)",0); |
340 |
temp = psiconv_read_u8(buf,lev+2,off+len,&res); |
341 |
if (res) |
342 |
goto ERROR; |
343 |
if (temp != 0) { |
344 |
psiconv_warn(lev+2,off+len,"Unknown byte in cell reference (ignored"); |
345 |
psiconv_debug(lev+2,off+len,"Trailing byte: %02x",temp); |
346 |
} |
347 |
len ++; |
348 |
psiconv_progress(lev,off+len-1, |
349 |
"End of cell reference (total length: %08x)", len); |
350 |
if (length) |
351 |
*length = len; |
352 |
return 0; |
353 |
ERROR: |
354 |
if (length) |
355 |
*length = 0; |
356 |
return res; |
357 |
} |
358 |
|
359 |
static int psiconv_parse_sheet_cell_block(const psiconv_buffer buf,int lev, |
360 |
psiconv_u32 off, int *length, |
361 |
psiconv_sheet_cell_block_t *result) |
362 |
{ |
363 |
int len = 0; |
364 |
int leng,res; |
365 |
|
366 |
psiconv_progress(lev+1,off+len,"Going to read a sheet cell block"); |
367 |
psiconv_progress(lev+2,off+len,"Going to read the first cell"); |
368 |
if ((res = psiconv_parse_sheet_cell_reference(buf,lev+2,off+len,&leng, |
369 |
&result->first))) |
370 |
goto ERROR; |
371 |
len += leng; |
372 |
psiconv_progress(lev+2,off+len,"Going to read the last cell"); |
373 |
if ((res = psiconv_parse_sheet_cell_reference(buf,lev+2,off+len,&leng, |
374 |
&result->last))) |
375 |
goto ERROR; |
376 |
len += leng; |
377 |
psiconv_progress(lev,off+len-1, |
378 |
"End of cell block (total length: %08x)", len); |
379 |
if (length) |
380 |
*length = len; |
381 |
return 0; |
382 |
ERROR: |
383 |
if (length) |
384 |
*length = 0; |
385 |
return res; |
386 |
} |
387 |
|
388 |
int psiconv_parse_formula(const psiconv_buffer buf, int lev, |
389 |
psiconv_u32 off, int *length, |
390 |
psiconv_formula *result) |
391 |
{ |
392 |
int res=0; |
393 |
int len=0; |
394 |
int leng; |
395 |
int eof = 0; |
396 |
psiconv_u8 marker; |
397 |
psiconv_u32 bytelen; |
398 |
psiconv_formula_list formula_stack; |
399 |
psiconv_formula formula,subformula1,subformula2,subformula3,subformula4; |
400 |
|
401 |
psiconv_progress(lev+1,off,"Going to read a formula"); |
402 |
if (!(*result = malloc(sizeof(**result)))) |
403 |
goto ERROR1; |
404 |
if (!(formula_stack = psiconv_list_new(sizeof(struct psiconv_formula_s)))) |
405 |
goto ERROR2; |
406 |
if (!(formula = malloc(sizeof(*formula)))) |
407 |
goto ERROR3; |
408 |
/* By setting the type to unknown, we can safely call psiconv_free_formula */ |
409 |
formula->type = psiconv_formula_unknown; |
410 |
if (!(subformula1 = malloc(sizeof(*subformula1)))) |
411 |
goto ERROR4; |
412 |
subformula1->type = psiconv_formula_unknown; |
413 |
if (!(subformula2 = malloc(sizeof(*subformula2)))) |
414 |
goto ERROR5; |
415 |
subformula2->type = psiconv_formula_unknown; |
416 |
if (!(subformula3 = malloc(sizeof(*subformula3)))) |
417 |
goto ERROR6; |
418 |
subformula3->type = psiconv_formula_unknown; |
419 |
if (!(subformula4 = malloc(sizeof(*subformula4)))) |
420 |
goto ERROR7; |
421 |
subformula4->type = psiconv_formula_unknown; |
422 |
|
423 |
psiconv_progress(lev+2,off+len, |
424 |
"Going to read the formula byte length"); |
425 |
bytelen = psiconv_read_S(buf,lev+2,off+len,&leng,&res); |
426 |
if (res) |
427 |
goto ERROR8; |
428 |
psiconv_debug(lev+2,off+len,"Formula byte length: %d",bytelen); |
429 |
len += leng; |
430 |
bytelen += len; |
431 |
|
432 |
psiconv_progress(lev+2,off+len,"Going to read the formula items"); |
433 |
while (!eof && len < bytelen) { |
434 |
psiconv_progress(lev+3,off+len,"Going to read a formula item marker"); |
435 |
marker = psiconv_read_u8(buf,lev+2,off+len,&res); |
436 |
if (res) |
437 |
goto ERROR8; |
438 |
psiconv_debug(lev+3,off+len,"Marker: %02x (%s)",marker, |
439 |
formula_elements[marker].name); |
440 |
len ++; |
441 |
|
442 |
if (formula_elements[marker].formula_type == psiconv_formula_unknown) { |
443 |
psiconv_warn(lev+3,off+len,"Unknown formula marker found!"); |
444 |
goto ERROR8; |
445 |
} else if (formula_elements[marker].formula_type == |
446 |
psiconv_formula_mark_eof) { |
447 |
psiconv_progress(lev+3,off+len,"End of formula"); |
448 |
eof = 1; |
449 |
} else if (formula_elements[marker].formula_type == |
450 |
psiconv_formula_dat_int) { |
451 |
psiconv_progress(lev+3,off+len,"Next item: an integer"); |
452 |
formula->data.dat_int = psiconv_read_u32(buf,lev+2,off+len,&res); |
453 |
if (res) |
454 |
goto ERROR8; |
455 |
formula->type = formula_elements[marker].formula_type; |
456 |
psiconv_debug(lev+3,off+len,"Value: %08x",formula->data.dat_int); |
457 |
len += 4; |
458 |
if ((res = psiconv_list_add(formula_stack,formula))) |
459 |
goto ERROR8; |
460 |
formula->type = psiconv_formula_unknown; |
461 |
} else if (formula_elements[marker].formula_type == |
462 |
psiconv_formula_dat_float) { |
463 |
psiconv_progress(lev+3,off+len,"Next item: a float"); |
464 |
formula->data.dat_float = psiconv_read_float(buf,lev+2,off+len,&leng, |
465 |
&res); |
466 |
if (res) |
467 |
goto ERROR8; |
468 |
formula->type = formula_elements[marker].formula_type; |
469 |
psiconv_debug(lev+3,off+len,"Value: %f",formula->data.dat_float); |
470 |
len += leng; |
471 |
if ((res = psiconv_list_add(formula_stack,formula))) |
472 |
goto ERROR8; |
473 |
formula->type = psiconv_formula_unknown; |
474 |
} else if (formula_elements[marker].formula_type == |
475 |
psiconv_formula_dat_cellref) { |
476 |
psiconv_progress(lev+3,off+len,"Next item: a cell reference"); |
477 |
if ((res = psiconv_parse_sheet_cell_reference(buf,lev+2,off+len,&leng, |
478 |
&formula->data.dat_cellref))) |
479 |
goto ERROR8; |
480 |
formula->type = formula_elements[marker].formula_type; |
481 |
len += leng; |
482 |
if ((res = psiconv_list_add(formula_stack,formula))) |
483 |
goto ERROR8; |
484 |
formula->type = psiconv_formula_unknown; |
485 |
} else if (formula_elements[marker].formula_type == |
486 |
psiconv_formula_dat_cellblock) { |
487 |
psiconv_progress(lev+3,off+len,"Next item: a cell block"); |
488 |
if ((res = psiconv_parse_sheet_cell_block(buf,lev+2,off+len,&leng, |
489 |
&formula->data.dat_cellblock))) |
490 |
goto ERROR8; |
491 |
formula->type = formula_elements[marker].formula_type; |
492 |
len += leng; |
493 |
if ((res = psiconv_list_add(formula_stack,formula))) |
494 |
goto ERROR8; |
495 |
formula->type = psiconv_formula_unknown; |
496 |
} else if ((formula_elements[marker].formula_type == |
497 |
psiconv_formula_dat_var) || |
498 |
(formula_elements[marker].formula_type == |
499 |
psiconv_formula_dat_string) || |
500 |
(formula_elements[marker].formula_type == |
501 |
psiconv_formula_dat_vcellblock) || |
502 |
(formula_elements[marker].formula_type == |
503 |
psiconv_formula_mark_opsep) || |
504 |
(formula_elements[marker].formula_type == |
505 |
psiconv_formula_mark_opend)) { |
506 |
psiconv_warn(lev+3,off+len,"Not yet supported formula mark!"); |
507 |
goto ERROR8; |
508 |
} else if (formula_elements[marker].number_of_args == -1) { |
509 |
psiconv_warn(lev+3,off+len,"Vararg functions not yet supported!"); |
510 |
goto ERROR8; |
511 |
} else { |
512 |
if (formula_elements[marker].number_of_args > 0) |
513 |
if ((res = psiconv_list_pop(formula_stack,subformula1))) |
514 |
goto ERROR8; |
515 |
if (formula_elements[marker].number_of_args > 1) |
516 |
if ((res = psiconv_list_pop(formula_stack,subformula2))) |
517 |
goto ERROR8; |
518 |
if (formula_elements[marker].number_of_args > 2) |
519 |
if ((res = psiconv_list_pop(formula_stack,subformula3))) |
520 |
goto ERROR8; |
521 |
if (formula_elements[marker].number_of_args > 3) |
522 |
if ((res = psiconv_list_pop(formula_stack,subformula4))) |
523 |
goto ERROR8; |
524 |
if (!(formula->data.fun_operands = |
525 |
psiconv_list_new(sizeof(*formula)))) |
526 |
goto ERROR8; |
527 |
formula->type = formula_elements[marker].formula_type; |
528 |
if (formula_elements[marker].number_of_args > 3) |
529 |
if ((res = psiconv_list_add(formula->data.fun_operands,subformula4))) |
530 |
goto ERROR8; |
531 |
if (formula_elements[marker].number_of_args > 2) |
532 |
if ((res = psiconv_list_add(formula->data.fun_operands,subformula3))) |
533 |
goto ERROR8; |
534 |
if (formula_elements[marker].number_of_args > 1) |
535 |
if ((res = psiconv_list_add(formula->data.fun_operands,subformula2))) |
536 |
goto ERROR8; |
537 |
if (formula_elements[marker].number_of_args > 0) |
538 |
if ((res = psiconv_list_add(formula->data.fun_operands,subformula1))) |
539 |
goto ERROR8; |
540 |
if ((res = psiconv_list_add(formula_stack,formula))) |
541 |
goto ERROR8; |
542 |
subformula4->type = subformula3->type = subformula2->type = |
543 |
subformula1->type = formula->type = psiconv_formula_unknown; |
544 |
} |
545 |
} |
546 |
if ((len != bytelen) || !eof) { |
547 |
psiconv_warn(lev+2,off+len,"Formula corrupted!"); |
548 |
psiconv_debug(lev+2,off+len,"Expected end: %04x, found end: %04x", |
549 |
bytelen,len); |
550 |
goto ERROR8; |
551 |
} |
552 |
if ((psiconv_list_length(formula_stack)) != 1) { |
553 |
psiconv_warn(lev+2,off+len,"Formula corrupted!"); |
554 |
psiconv_debug(lev+2,off+len,"More than one item left on the stack (%d)", |
555 |
psiconv_list_length(formula_stack)); |
556 |
goto ERROR8; |
557 |
} |
558 |
if ((res = psiconv_list_pop(formula_stack,*result))) |
559 |
goto ERROR8; |
560 |
psiconv_list_free(formula_stack); |
561 |
free(formula); |
562 |
|
563 |
if (length) |
564 |
*length = len; |
565 |
|
566 |
psiconv_progress(lev,off+len-1, |
567 |
"End of formula (total length: %08x)", len); |
568 |
return 0; |
569 |
|
570 |
ERROR8: |
571 |
psiconv_free_formula(subformula4); |
572 |
ERROR7: |
573 |
psiconv_free_formula(subformula3); |
574 |
ERROR6: |
575 |
psiconv_free_formula(subformula2); |
576 |
ERROR5: |
577 |
psiconv_free_formula(subformula1); |
578 |
ERROR4: |
579 |
psiconv_free_formula(formula); |
580 |
ERROR3: |
581 |
psiconv_free_formula_list(formula_stack); |
582 |
ERROR2: |
583 |
free (*result); |
584 |
ERROR1: |
585 |
psiconv_warn(lev+1,off,"Reading of formula failed"); |
586 |
if (length) |
587 |
*length = 0; |
588 |
if (!res) |
589 |
return -PSICONV_E_NOMEM; |
590 |
else |
591 |
return res; |
592 |
} |
593 |
|