LibreOffice Module sc (master)  1
xlconst.hxx
Go to the documentation of this file.
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3  * This file is part of the LibreOffice project.
4  *
5  * This Source Code Form is subject to the terms of the Mozilla Public
6  * License, v. 2.0. If a copy of the MPL was not distributed with this
7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8  *
9  * This file incorporates work covered by the following license notice:
10  *
11  * Licensed to the Apache Software Foundation (ASF) under one or more
12  * contributor license agreements. See the NOTICE file distributed
13  * with this work for additional information regarding copyright
14  * ownership. The ASF licenses this file to you under the Apache
15  * License, Version 2.0 (the "License"); you may not use this file
16  * except in compliance with the License. You may obtain a copy of
17  * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18  */
19 
20 #ifndef INCLUDED_SC_SOURCE_FILTER_INC_XLCONST_HXX
21 #define INCLUDED_SC_SOURCE_FILTER_INC_XLCONST_HXX
22 
23 #include <address.hxx>
24 
25 // Common =====================================================================
26 
27 // BIFF versions --------------------------------------------------------------
28 
30 enum XclBiff
31 {
32  EXC_BIFF2 = 0,
38 };
39 
42 {
45 };
46 
47 // Excel sheet dimensions -----------------------------------------------------
48 
49 const SCCOL EXC_MAXCOL2 = 255;
50 const SCROW EXC_MAXROW2 = 16383;
51 const SCTAB EXC_MAXTAB2 = 0;
52 
56 
59 const SCTAB EXC_MAXTAB4 = 32767;
60 
64 
66 const SCROW EXC_MAXROW8 = 65535;
68 
69 const SCCOL EXC_MAXCOL_XML_2007 = 16383;
70 const SCROW EXC_MAXROW_XML_2007 = 1048575;
72 
73 const sal_uInt16 EXC_NOTAB = SAL_MAX_UINT16;
76 
77 // Storage/stream names -------------------------------------------------------
78 
79 #define EXC_STORAGE_OLE_LINKED "LNK"
80 #define EXC_STORAGE_OLE_EMBEDDED "MBD"
81 #define EXC_STORAGE_VBA_PROJECT "_VBA_PROJECT_CUR"
82 
83 #define EXC_STREAM_BOOK "Book"
84 #define EXC_STREAM_WORKBOOK "Workbook"
85 #define EXC_STREAM_CTLS "Ctls"
86 
87 // Encoded URLs ---------------------------------------------------------------
88 
93 
94 const sal_Unicode EXC_URL_DOSDRIVE = '\x01';
96 const sal_Unicode EXC_URL_SUBDIR = '\x03';
98 const sal_Unicode EXC_URL_RAW = '\x05';
100 
101 const sal_Unicode EXC_DDE_DELIM = '\x03';
102 
103 // Error codes ----------------------------------------------------------------
104 
105 const sal_uInt8 EXC_ERR_NULL = 0x00;
106 const sal_uInt8 EXC_ERR_DIV0 = 0x07;
108 const sal_uInt8 EXC_ERR_REF = 0x17;
109 const sal_uInt8 EXC_ERR_NAME = 0x1D;
110 const sal_uInt8 EXC_ERR_NUM = 0x24;
111 const sal_uInt8 EXC_ERR_NA = 0x2A;
112 
113 // Cached values list (EXTERNNAME, ptgArray, ...) -----------------------------
114 
120 
121 // RK values ------------------------------------------------------------------
122 
123 const sal_Int32 EXC_RK_100FLAG = 0x00000001;
124 const sal_Int32 EXC_RK_INTFLAG = 0x00000002;
125 const sal_Int32 EXC_RK_VALUEMASK = 0xFFFFFFFC;
126 
127 const sal_Int32 EXC_RK_DBL = 0x00000000;
128 const sal_Int32 EXC_RK_DBL100 = EXC_RK_100FLAG;
129 const sal_Int32 EXC_RK_INT = EXC_RK_INTFLAG;
131 
132 // Measures -------------------------------------------------------------------
133 
134 const sal_Int32 EXC_POINTS_PER_INCH = 72;
136 
137 const double EXC_POINTS_PER_HMM = static_cast< double >( EXC_POINTS_PER_INCH ) / 2540.0;
138 
143 
146 const sal_uInt8 EXC_ROT_90CW = 180;
148 
149 // Records (ordered by lowest record ID) ======================================
150 
151 // (0x0009, 0x0209, 0x0409, 0x0809) BOF ---------------------------------------
152 
153 const sal_uInt16 EXC_ID2_BOF = 0x0009;
154 const sal_uInt16 EXC_ID3_BOF = 0x0209;
155 const sal_uInt16 EXC_ID4_BOF = 0x0409;
156 const sal_uInt16 EXC_ID5_BOF = 0x0809;
157 
158 const sal_uInt16 EXC_BOF_BIFF2 = 0x0200;
159 const sal_uInt16 EXC_BOF_BIFF3 = 0x0300;
160 const sal_uInt16 EXC_BOF_BIFF4 = 0x0400;
161 const sal_uInt16 EXC_BOF_BIFF5 = 0x0500;
162 const sal_uInt16 EXC_BOF_BIFF8 = 0x0600;
163 
164 const sal_uInt16 EXC_BOF_GLOBALS = 0x0005;
165 const sal_uInt16 EXC_BOF_VBMODULE = 0x0006;
166 const sal_uInt16 EXC_BOF_SHEET = 0x0010;
167 const sal_uInt16 EXC_BOF_CHART = 0x0020;
168 const sal_uInt16 EXC_BOF_MACROSHEET = 0x0040;
169 const sal_uInt16 EXC_BOF_WORKSPACE = 0x0100;
170 const sal_uInt16 EXC_BOF_UNKNOWN = 0xFFFF;
171 
172 // (0x000A) EOF ---------------------------------------------------------------
173 const sal_uInt16 EXC_ID_EOF = 0x000A;
174 
175 // (0x0012) PROTECT -----------------------------------------------------------
176 const sal_uInt16 EXC_ID_PROTECT = 0x0012;
177 
178 // (0x0013) PASSWORD ----------------------------------------------------------
179 const sal_uInt16 EXC_ID_PASSWORD = 0x0013;
180 
181 // (0x0019) WINDOWPROTECT -----------------------------------------------------
182 const sal_uInt16 EXC_ID_WINDOWPROTECT = 0x0019;
183 
184 // (0x0042) CODEPAGE ----------------------------------------------------------
185 const sal_uInt16 EXC_ID_CODEPAGE = 0x0042;
186 
187 // (0x0081) WSBOOL ------------------------------------------------------------
188 const sal_uInt16 EXC_ID_WSBOOL = 0x0081;
189 
190 const sal_uInt16 EXC_WSBOOL_ROWBELOW = 0x0040;
191 const sal_uInt16 EXC_WSBOOL_COLBELOW = 0x0080;
192 const sal_uInt16 EXC_WSBOOL_FITTOPAGE = 0x0100;
193 
194 const sal_uInt16 EXC_WSBOOL_DEFAULTFLAGS = 0x04C1;
195 
196 // (0x0086) WRITEPROT ---------------------------------------------------------
197 const sal_uInt16 EXC_ID_WRITEPROT = 0x0086;
198 
199 // (0x008C) COUNTRY -----------------------------------------------------------
200 const sal_uInt16 EXC_ID_COUNTRY = 0x008C;
201 
202 // (0x009B) FILTERMODE --------------------------------------------------------
203 const sal_uInt16 EXC_ID_FILTERMODE = 0x009B;
204 
205 // (0x009C) FNGROUPCOUNT ------------------------------------------------------
206 const sal_uInt16 EXC_ID_FNGROUPCOUNT = 0x009C;
207 
208 // (0x009D) AUTOFILTERINFO ----------------------------------------------------
209 const sal_uInt16 EXC_ID_AUTOFILTERINFO = 0x009D;
210 
211 // (0x009E) AUTOFILTER --------------------------------------------------------
212 const sal_uInt16 EXC_ID_AUTOFILTER = 0x009E;
213 
214 // (0x00BF, 0x00C0, 0x00C1) TOOLBARHDR, TOOLBAREND, MMS -----------------------
215 const sal_uInt16 EXC_ID_TOOLBARHDR = 0x00BF;
216 const sal_uInt16 EXC_ID_TOOLBAREND = 0x00C0;
217 const sal_uInt16 EXC_ID_MMS = 0x00C1;
218 
219 // (0x00E1, 0x00E2) INTERFACEHDR, INTERFACEEND --------------------------------
220 const sal_uInt16 EXC_ID_INTERFACEHDR = 0x00E1;
221 const sal_uInt16 EXC_ID_INTERFACEEND = 0x00E2;
222 
223 // (0x0160) USESELFS ----------------------------------------------------------
224 const sal_uInt16 EXC_ID_USESELFS = 0x0160;
225 
226 // (0x0161) DSF ---------------------------------------------------------------
227 const sal_uInt16 EXC_ID_DSF = 0x0161;
228 
229 // (0x01AA,0x01AB) USERSVIEWBEGIN, USERSVIEWEND -------------------------------
230 const sal_uInt16 EXC_ID_USERSVIEWBEGIN = 0x01AA;
231 const sal_uInt16 EXC_ID_USERSVIEWEND = 0x01AB;
232 
233 // (0x01BA) CODENAME ----------------------------------------------------------
234 const sal_uInt16 EXC_ID_CODENAME = 0x01BA;
235 
236 // (0x01C0) XL9FILE -----------------------------------------------------------
237 const sal_uInt16 EXC_ID_XL9FILE = 0x01C0;
238 
239 // (0x8xx) Future records -----------------------------------------------------
240 
243 {
246 };
247 
248 const sal_uInt16 EXC_FUTUREREC_EMPTYFLAGS = 0x0000;
249 const sal_uInt16 EXC_FUTUREREC_HASREF = 0x0001;
250 const sal_uInt16 EXC_FUTUREREC_ALERT = 0x0002;
251 
252 // Border import/export
253 
254 const sal_uInt16 EXC_BORDER_THICK = 50;
255 const sal_uInt16 EXC_BORDER_MEDIUM = 35;
256 const sal_uInt16 EXC_BORDER_THIN = 15;
257 const sal_uInt16 EXC_BORDER_HAIR = 1;
258 
259 // SharedFeatureType enumeration
260 const sal_uInt16 EXC_ISFPROTECTION = 0x0002;
261 const sal_uInt16 EXC_ISFFEC2 = 0x0003;
262 const sal_uInt16 EXC_ISFFACTOID = 0x0004;
263 const sal_uInt16 EXC_ISFLIST = 0x0005;
264 
265 #endif
266 
267 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
const sal_Unicode EXC_URLSTART_SELF
Encoded URL.
Definition: xlconst.hxx:90
const sal_uInt16 EXC_ID_FNGROUPCOUNT
Definition: xlconst.hxx:206
const SCTAB EXC_MAXTAB3
Definition: xlconst.hxx:55
const sal_uInt8 EXC_ORIENT_NONE
Definition: xlconst.hxx:139
const sal_uInt8 EXC_ERR_NULL
DDE application-topic delimiter.
Definition: xlconst.hxx:105
const sal_Unicode EXC_URL_SHEETNAME
Unencoded URL.
Definition: xlconst.hxx:99
const sal_Unicode EXC_URL_PARENTDIR
Directory name delimiter.
Definition: xlconst.hxx:97
XclBiff
An enumeration for all Excel file format types (BIFF types).
Definition: xlconst.hxx:30
const sal_uInt16 EXC_BORDER_HAIR
Definition: xlconst.hxx:257
const sal_uInt16 EXC_ID_INTERFACEHDR
Definition: xlconst.hxx:220
const sal_uInt8 EXC_ERR_NA
Definition: xlconst.hxx:111
MS Excel binary .xls.
Definition: xlconst.hxx:44
const sal_uInt16 EXC_FUTUREREC_ALERT
Definition: xlconst.hxx:250
const sal_uInt16 EXC_ID_COUNTRY
Definition: xlconst.hxx:200
const sal_uInt16 EXC_ID_DSF
Definition: xlconst.hxx:227
const SCCOL EXC_MAXCOL4
Definition: xlconst.hxx:57
Record identifier and empty flags field.
Definition: xlconst.hxx:245
const sal_uInt8 EXC_ROT_STACKED
Text rotation: 90 deg clockwise.
Definition: xlconst.hxx:147
const SCCOL EXC_MAXCOL2
Definition: xlconst.hxx:49
const sal_uInt16 EXC_BOF_WORKSPACE
Macro sheet.
Definition: xlconst.hxx:169
const sal_uInt16 EXC_BORDER_THICK
Definition: xlconst.hxx:254
const SCCOL EXC_MAXCOL5
Definition: xlconst.hxx:61
const sal_uInt16 EXC_ID_FILTERMODE
Definition: xlconst.hxx:203
const sal_Int32 EXC_RK_INTFLAG
Definition: xlconst.hxx:124
const sal_Int32 EXC_POINTS_PER_INCH
Definition: xlconst.hxx:134
const sal_uInt16 EXC_ID_USERSVIEWEND
Definition: xlconst.hxx:231
const sal_uInt8 EXC_CACHEDVAL_ERROR
Definition: xlconst.hxx:119
const sal_Unicode EXC_URLSTART_ENCODED
Definition: xlconst.hxx:89
const sal_uInt16 EXC_ID5_BOF
Definition: xlconst.hxx:156
const SCTAB EXC_MAXTAB8
Definition: xlconst.hxx:67
const sal_uInt16 EXC_BOF_BIFF5
Definition: xlconst.hxx:161
const sal_uInt16 EXC_ID_CODENAME
Definition: xlconst.hxx:234
const sal_uInt16 EXC_ISFFEC2
Definition: xlconst.hxx:261
XclFutureRecType
Enumerates different header types of future records.
Definition: xlconst.hxx:242
const SCTAB EXC_MAXTAB4
Definition: xlconst.hxx:59
const sal_uInt16 EXC_ID_TOOLBAREND
Definition: xlconst.hxx:216
const SCCOL EXC_MAXCOL_XML_2007
Definition: xlconst.hxx:69
const sal_uInt8 EXC_ORIENT_STACKED
Text orientation: not rotated.
Definition: xlconst.hxx:140
const sal_Unicode EXC_DDE_DELIM
Sheet name starts here (BIFF4).
Definition: xlconst.hxx:101
sal_uInt16 sal_Unicode
const SCROW EXC_MAXROW2
Definition: xlconst.hxx:50
const SCROW EXC_MAXROW_XML_2007
Definition: xlconst.hxx:70
const sal_uInt8 EXC_ERR_NUM
Definition: xlconst.hxx:110
MS Excel 4.0.
Definition: xlconst.hxx:35
#define SAL_MAX_UINT16
MS Excel 8.0 (97), 9.0 (2000), 10.0 (XP), 11.0 (2003)
Definition: xlconst.hxx:37
const sal_uInt16 EXC_BOF_BIFF4
Definition: xlconst.hxx:160
const SCTAB SCTAB_INVALID
An invalid Excel sheet index, for common use.
Definition: xlconst.hxx:74
const sal_uInt16 EXC_ID_WRITEPROT
Definition: xlconst.hxx:197
const sal_uInt16 EXC_BOF_GLOBALS
Definition: xlconst.hxx:164
const SCTAB SCTAB_GLOBAL
An invalid Calc sheet index, for common use.
Definition: xlconst.hxx:75
const sal_uInt8 EXC_ERR_REF
Definition: xlconst.hxx:108
const sal_uInt16 EXC_ISFPROTECTION
Definition: xlconst.hxx:260
const sal_Unicode EXC_URLSTART_SELFENCODED
Reference to own workbook.
Definition: xlconst.hxx:91
const SCTAB EXC_MAXTAB5
Definition: xlconst.hxx:63
const SCTAB EXC_MAXTAB2
Definition: xlconst.hxx:51
const sal_uInt16 EXC_ID_AUTOFILTERINFO
Definition: xlconst.hxx:209
const sal_Int32 EXC_RK_DBL100
Definition: xlconst.hxx:128
const sal_Int32 EXC_TWIPS_PER_INCH
Definition: xlconst.hxx:135
MS Excel 5.0, MS Excel 7.0 (95)
Definition: xlconst.hxx:36
const sal_Int32 EXC_RK_VALUEMASK
Definition: xlconst.hxx:125
const sal_Int32 EXC_RK_100FLAG
Definition: xlconst.hxx:123
const sal_uInt16 EXC_ID_PROTECT
Definition: xlconst.hxx:176
const sal_uInt16 EXC_ID4_BOF
Definition: xlconst.hxx:155
const sal_uInt8 EXC_ERR_VALUE
Definition: xlconst.hxx:107
sal_Int16 SCCOL
Definition: types.hxx:22
const SCCOL EXC_MAXCOL3
Definition: xlconst.hxx:53
const sal_Unicode EXC_URLSTART_OWNDOC
Encoded self reference.
Definition: xlconst.hxx:92
const sal_Unicode EXC_URL_DOSDRIVE
Reference to own workbook (BIFF5/BIFF7).
Definition: xlconst.hxx:94
const sal_uInt16 EXC_ISFLIST
Definition: xlconst.hxx:263
const sal_uInt16 EXC_BOF_BIFF3
Definition: xlconst.hxx:159
const sal_uInt16 EXC_ID_USESELFS
Definition: xlconst.hxx:224
const SCROW EXC_MAXROW8
Definition: xlconst.hxx:66
const SCTAB EXC_MAXTAB_XML_2007
Definition: xlconst.hxx:71
const SCROW EXC_MAXROW4
Definition: xlconst.hxx:58
const sal_uInt8 EXC_CACHEDVAL_BOOL
Definition: xlconst.hxx:118
MS Excel 3.0.
Definition: xlconst.hxx:34
const sal_Unicode EXC_URL_SUBDIR
Root directory of current drive.
Definition: xlconst.hxx:96
const sal_Int32 EXC_RK_INT100
Definition: xlconst.hxx:130
const sal_uInt16 EXC_BORDER_THIN
Definition: xlconst.hxx:256
const double EXC_POINTS_PER_HMM
Definition: xlconst.hxx:137
const sal_uInt8 EXC_CACHEDVAL_EMPTY
Definition: xlconst.hxx:115
const sal_uInt16 EXC_ID_WINDOWPROTECT
Definition: xlconst.hxx:182
const sal_uInt16 EXC_BOF_MACROSHEET
Chart sheet.
Definition: xlconst.hxx:168
const sal_uInt16 EXC_ID_MMS
Definition: xlconst.hxx:217
const sal_uInt8 EXC_CACHEDVAL_DOUBLE
Definition: xlconst.hxx:116
const sal_uInt16 EXC_ID_WSBOOL
Definition: xlconst.hxx:188
sal_Int32 SCROW
Definition: types.hxx:18
const sal_uInt16 EXC_ID_USERSVIEWBEGIN
Definition: xlconst.hxx:230
const sal_Unicode EXC_URL_RAW
Parent directory.
Definition: xlconst.hxx:98
const sal_uInt16 EXC_WSBOOL_ROWBELOW
Definition: xlconst.hxx:190
const sal_uInt16 EXC_WSBOOL_DEFAULTFLAGS
Definition: xlconst.hxx:194
const sal_uInt16 EXC_BOF_UNKNOWN
Workspace.
Definition: xlconst.hxx:170
XclOutput
An enumeration for all Excel output format types.
Definition: xlconst.hxx:41
const sal_uInt8 EXC_CACHEDVAL_STRING
Definition: xlconst.hxx:117
const sal_uInt16 EXC_BOF_SHEET
BIFF5-BIFF8 Visual BASIC module.
Definition: xlconst.hxx:166
unsigned char sal_uInt8
const sal_uInt8 EXC_ERR_NAME
Definition: xlconst.hxx:109
const SCROW EXC_MAXROW5
Definition: xlconst.hxx:62
const sal_uInt16 EXC_BOF_BIFF2
Definition: xlconst.hxx:158
const sal_Int32 EXC_RK_INT
Definition: xlconst.hxx:129
const sal_uInt8 EXC_ERR_DIV0
Definition: xlconst.hxx:106
const sal_uInt16 EXC_ID_TOOLBARHDR
Definition: xlconst.hxx:215
const sal_uInt16 EXC_ID_INTERFACEEND
Definition: xlconst.hxx:221
const sal_uInt16 EXC_NOTAB
Definition: xlconst.hxx:73
const sal_uInt8 EXC_ROT_90CW
Text rotation: 90 deg counterclockwise.
Definition: xlconst.hxx:146
const sal_uInt16 EXC_BOF_BIFF8
Definition: xlconst.hxx:162
const sal_Unicode EXC_URL_DRIVEROOT
DOS drive letter or UNC server name.
Definition: xlconst.hxx:95
const sal_Int32 EXC_RK_DBL
Definition: xlconst.hxx:127
const sal_uInt8 EXC_ROT_90CCW
Text rotation: not rotated.
Definition: xlconst.hxx:145
const SCROW EXC_MAXROW3
Definition: xlconst.hxx:54
const sal_uInt16 EXC_ID_AUTOFILTER
Definition: xlconst.hxx:212
const sal_uInt8 EXC_ROT_NONE
Text orientation: 90 deg clockwise.
Definition: xlconst.hxx:144
const sal_uInt16 EXC_BOF_VBMODULE
BIFF5-BIFF8 workbook globals.
Definition: xlconst.hxx:165
const sal_uInt16 EXC_FUTUREREC_HASREF
Definition: xlconst.hxx:249
const sal_uInt16 EXC_ID3_BOF
Definition: xlconst.hxx:154
const sal_uInt8 EXC_ORIENT_90CCW
Text orientation: vertically stacked.
Definition: xlconst.hxx:141
const SCCOL EXC_MAXCOL8
Definition: xlconst.hxx:65
const sal_uInt16 EXC_ID_CODEPAGE
Definition: xlconst.hxx:185
MS Excel 2.1.
Definition: xlconst.hxx:33
const sal_uInt16 EXC_WSBOOL_COLBELOW
Definition: xlconst.hxx:191
const SCTAB SCTAB_MAX
Definition: address.hxx:58
const sal_uInt16 EXC_WSBOOL_FITTOPAGE
Definition: xlconst.hxx:192
const sal_uInt16 EXC_ISFFACTOID
Definition: xlconst.hxx:262
const sal_uInt16 EXC_ID_PASSWORD
Definition: xlconst.hxx:179
const sal_uInt16 EXC_FUTUREREC_EMPTYFLAGS
Definition: xlconst.hxx:248
const sal_uInt16 EXC_ID2_BOF
Text rotation: vertically stacked.
Definition: xlconst.hxx:153
const sal_uInt16 EXC_ID_XL9FILE
Definition: xlconst.hxx:237
const sal_uInt16 EXC_BOF_CHART
Regular worksheet.
Definition: xlconst.hxx:167
sal_Int16 SCTAB
Definition: types.hxx:23
const sal_uInt8 EXC_ORIENT_90CW
Text orientation: 90 deg counterclockwise.
Definition: xlconst.hxx:142
const sal_uInt16 EXC_ID_EOF
Internal use only.
Definition: xlconst.hxx:173
const sal_uInt16 EXC_BORDER_MEDIUM
Definition: xlconst.hxx:255