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