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