1 /* PSPP - a program for statistical analysis.
2 Copyright (C) 2007, 2009, 2010, 2011 Free Software Foundation, Inc.
4 This program is free software: you can redistribute it and/or modify
5 it under the terms of the GNU General Public License as published by
6 the Free Software Foundation, either version 3 of the License, or
7 (at your option) any later version.
9 This program is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU General Public License for more details.
14 You should have received a copy of the GNU General Public License
15 along with this program. If not, see <http://www.gnu.org/licenses/>. */
19 #include "spreadsheet-reader.h"
21 #include <libpspp/str.h>
27 spreadsheet_open (const char *filename)
29 struct spreadsheet *ss = NULL;
31 ss = gnumeric_probe (filename);
37 spreadsheet_close (struct spreadsheet *spreadsheet)
43 /* Convert a string, which is an integer encoded in base26
44 IE, A=0, B=1, ... Z=25 to the integer it represents.
45 ... except that in this scheme, digits with an exponent
46 greater than 1 are implicitly incremented by 1, so
47 AA = 0 + 1*26, AB = 1 + 1*26,
48 ABC = 2 + 2*26 + 1*26^2 ....
51 pseudo_base26 (const char *str)
56 int len = strlen (str);
58 for ( i = len - 1 ; i >= 0; --i)
60 int mantissa = (str[i] - 'A');
62 if ( mantissa < 0 || mantissa > 25 )
68 result += mantissa * multiplier;
77 create_cell_ref (int col0, int row0, int coli, int rowi)
79 return c_xasprintf ("%c%d:%c%ld",
81 coli + 'A', rowi + 1);
85 /* Convert a cell reference in the form "A1:B2", to
86 integers. A1 means column zero, row zero.
87 B1 means column 1 row 0. AA1 means column 26, row 0.
90 convert_cell_ref (const char *ref,
100 int n = sscanf (ref, "%4[a-zA-Z]%d:%4[a-zA-Z]%d",
106 str_uppercase (startcol);
107 *col0 = pseudo_base26 (startcol);
108 str_uppercase (stopcol);
109 *coli = pseudo_base26 (stopcol);
110 *row0 = startrow - 1;
111 *rowi = stoprow - 1 ;