diff options
Diffstat (limited to 'sc/source/filter/inc/xlconst.hxx')
| -rw-r--r-- | sc/source/filter/inc/xlconst.hxx | 277 |
1 files changed, 277 insertions, 0 deletions
diff --git a/sc/source/filter/inc/xlconst.hxx b/sc/source/filter/inc/xlconst.hxx new file mode 100644 index 000000000000..42160aae7529 --- /dev/null +++ b/sc/source/filter/inc/xlconst.hxx @@ -0,0 +1,277 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +#ifndef SC_XLCONST_HXX +#define SC_XLCONST_HXX + +#include "address.hxx" + +// Common ===================================================================== + +// BIFF versions -------------------------------------------------------------- + +/** An enumeration for all Excel file format types (BIFF types). */ +enum XclBiff +{ + EXC_BIFF2 = 0, /// MS Excel 2.1 + EXC_BIFF3, /// MS Excel 3.0 + EXC_BIFF4, /// MS Excel 4.0 + EXC_BIFF5, /// MS Excel 5.0, MS Excel 7.0 (95) + EXC_BIFF8, /// MS Excel 8.0 (97), 9.0 (2000), 10.0 (XP), 11.0 (2003) + EXC_BIFF_UNKNOWN /// Unknown BIFF version. +}; + +/** An enumeration for all Excel output format types. */ +enum XclOutput +{ + EXC_OUTPUT_BINARY, /// MS Excel binary .xls + EXC_OUTPUT_XML_2007, /// MS Excel 2007 .xlsx +}; + +// Excel sheet dimensions ----------------------------------------------------- + +const SCCOL EXC_MAXCOL2 = 255; +const SCROW EXC_MAXROW2 = 16383; +const SCTAB EXC_MAXTAB2 = 0; + +const SCCOL EXC_MAXCOL3 = EXC_MAXCOL2; +const SCROW EXC_MAXROW3 = EXC_MAXROW2; +const SCTAB EXC_MAXTAB3 = EXC_MAXTAB2; + +const SCCOL EXC_MAXCOL4 = EXC_MAXCOL3; +const SCROW EXC_MAXROW4 = EXC_MAXROW3; +const SCTAB EXC_MAXTAB4 = 32767; + +const SCCOL EXC_MAXCOL5 = EXC_MAXCOL4; +const SCROW EXC_MAXROW5 = EXC_MAXROW4; +const SCTAB EXC_MAXTAB5 = EXC_MAXTAB4; + +const SCCOL EXC_MAXCOL8 = EXC_MAXCOL5; +const SCROW EXC_MAXROW8 = 65535; +const SCTAB EXC_MAXTAB8 = EXC_MAXTAB5; + +const sal_uInt16 EXC_NOTAB = SAL_MAX_UINT16; /// An invalid Excel sheet index, for common use. +const SCTAB SCTAB_INVALID = SCTAB_MAX; /// An invalid Calc sheet index, for common use. +const SCTAB SCTAB_GLOBAL = SCTAB_MAX; /// A Calc sheet index for the workbook globals. + +// Storage/stream names ------------------------------------------------------- + +#define EXC_STORAGE_OLE_LINKED CREATE_STRING( "LNK" ) +#define EXC_STORAGE_OLE_EMBEDDED CREATE_STRING( "MBD" ) +#define EXC_STORAGE_VBA_PROJECT CREATE_STRING( "_VBA_PROJECT_CUR" ) +#define EXC_STORAGE_VBA CREATE_STRING( "VBA" ) + +#define EXC_STREAM_BOOK CREATE_STRING( "Book" ) +#define EXC_STREAM_WORKBOOK CREATE_STRING( "Workbook" ) +#define EXC_STREAM_CTLS CREATE_STRING( "Ctls" ) + +// Encoded URLs --------------------------------------------------------------- + +const sal_Unicode EXC_URLSTART_ENCODED = '\x01'; /// Encoded URL. +const sal_Unicode EXC_URLSTART_SELF = '\x02'; /// Reference to own workbook. +const sal_Unicode EXC_URLSTART_SELFENCODED = '\x03'; /// Encoded self reference. +const sal_Unicode EXC_URLSTART_OWNDOC = '\x04'; /// Reference to own workbook (BIFF5/BIFF7). + +const sal_Unicode EXC_URL_DOSDRIVE = '\x01'; /// DOS drive letter or UNC server name. +const sal_Unicode EXC_URL_DRIVEROOT = '\x02'; /// Root directory of current drive. +const sal_Unicode EXC_URL_SUBDIR = '\x03'; /// Directory name delimiter. +const sal_Unicode EXC_URL_PARENTDIR = '\x04'; /// Parent directory. +const sal_Unicode EXC_URL_RAW = '\x05'; /// Unencoded URL. +const sal_Unicode EXC_URL_SHEETNAME = '\x09'; /// Sheet name starts here (BIFF4). + +const sal_Unicode EXC_DDE_DELIM = '\x03'; /// DDE application-topic delimiter + +// Error codes ---------------------------------------------------------------- + +const sal_uInt8 EXC_ERR_NULL = 0x00; +const sal_uInt8 EXC_ERR_DIV0 = 0x07; +const sal_uInt8 EXC_ERR_VALUE = 0x0F; +const sal_uInt8 EXC_ERR_REF = 0x17; +const sal_uInt8 EXC_ERR_NAME = 0x1D; +const sal_uInt8 EXC_ERR_NUM = 0x24; +const sal_uInt8 EXC_ERR_NA = 0x2A; + +// Cached values list (EXTERNNAME, ptgArray, ...) ----------------------------- + +const sal_uInt8 EXC_CACHEDVAL_EMPTY = 0x00; +const sal_uInt8 EXC_CACHEDVAL_DOUBLE = 0x01; +const sal_uInt8 EXC_CACHEDVAL_STRING = 0x02; +const sal_uInt8 EXC_CACHEDVAL_BOOL = 0x04; +const sal_uInt8 EXC_CACHEDVAL_ERROR = 0x10; + +// RK values ------------------------------------------------------------------ + +const sal_Int32 EXC_RK_100FLAG = 0x00000001; +const sal_Int32 EXC_RK_INTFLAG = 0x00000002; +const sal_Int32 EXC_RK_VALUEMASK = 0xFFFFFFFC; + +const sal_Int32 EXC_RK_DBL = 0x00000000; +const sal_Int32 EXC_RK_DBL100 = EXC_RK_100FLAG; +const sal_Int32 EXC_RK_INT = EXC_RK_INTFLAG; +const sal_Int32 EXC_RK_INT100 = EXC_RK_100FLAG | EXC_RK_INTFLAG; + +// Measures ------------------------------------------------------------------- + +const sal_Int32 EXC_POINTS_PER_INCH = 72; +const sal_Int32 EXC_TWIPS_PER_INCH = EXC_POINTS_PER_INCH * 20; + +const sal_uInt8 EXC_ORIENT_NONE = 0; /// Text orientation: not rotated. +const sal_uInt8 EXC_ORIENT_STACKED = 1; /// Text orientation: vertically stacked. +const sal_uInt8 EXC_ORIENT_90CCW = 2; /// Text orientation: 90 deg counterclockwise. +const sal_uInt8 EXC_ORIENT_90CW = 3; /// Text orientation: 90 deg clockwise. + +const sal_uInt8 EXC_ROT_NONE = 0; /// Text rotation: not rotated. +const sal_uInt8 EXC_ROT_90CCW = 90; /// Text rotation: 90 deg counterclockwise. +const sal_uInt8 EXC_ROT_90CW = 180; /// Text rotation: 90 deg clockwise. +const sal_uInt8 EXC_ROT_STACKED = 255; /// Text rotation: vertically stacked. + +// Records (ordered by lowest record ID) ====================================== + +// (0x0009, 0x0209, 0x0409, 0x0809) BOF --------------------------------------- + +const sal_uInt16 EXC_ID2_BOF = 0x0009; +const sal_uInt16 EXC_ID3_BOF = 0x0209; +const sal_uInt16 EXC_ID4_BOF = 0x0409; +const sal_uInt16 EXC_ID5_BOF = 0x0809; + +const sal_uInt16 EXC_BOF_BIFF2 = 0x0200; +const sal_uInt16 EXC_BOF_BIFF3 = 0x0300; +const sal_uInt16 EXC_BOF_BIFF4 = 0x0400; +const sal_uInt16 EXC_BOF_BIFF5 = 0x0500; +const sal_uInt16 EXC_BOF_BIFF8 = 0x0600; + +const sal_uInt16 EXC_BOF_GLOBALS = 0x0005; /// BIFF5-BIFF8 workbook globals. +const sal_uInt16 EXC_BOF_VBMODULE = 0x0006; /// BIFF5-BIFF8 Visual BASIC module. +const sal_uInt16 EXC_BOF_SHEET = 0x0010; /// Regular worksheet. +const sal_uInt16 EXC_BOF_CHART = 0x0020; /// Chart sheet. +const sal_uInt16 EXC_BOF_MACROSHEET = 0x0040; /// Macro sheet. +const sal_uInt16 EXC_BOF_WORKSPACE = 0x0100; /// Workspace. +const sal_uInt16 EXC_BOF_UNKNOWN = 0xFFFF; /// Internal use only. + +// (0x000A) EOF --------------------------------------------------------------- + +const sal_uInt16 EXC_ID_EOF = 0x000A; + +// (0x0012) PROTECT ----------------------------------------------------------- + +const sal_uInt16 EXC_ID_PROTECT = 0x0012; + +// (0x0013) PASSWORD ---------------------------------------------------------- + +const sal_uInt16 EXC_ID_PASSWORD = 0x0013; + +// (0x0019) WINDOWPROTECT ----------------------------------------------------- + +const sal_uInt16 EXC_ID_WINDOWPROTECT = 0x0019; + +// (0x0042) CODEPAGE ---------------------------------------------------------- + +const sal_uInt16 EXC_ID_CODEPAGE = 0x0042; + +// (0x0081) WSBOOL ------------------------------------------------------------ + +const sal_uInt16 EXC_ID_WSBOOL = 0x0081; + +const sal_uInt16 EXC_WSBOOL_ROWBELOW = 0x0040; +const sal_uInt16 EXC_WSBOOL_COLBELOW = 0x0080; +const sal_uInt16 EXC_WSBOOL_FITTOPAGE = 0x0100; + +const sal_uInt16 EXC_WSBOOL_DEFAULTFLAGS = 0x04C1; + +// (0x0086) WRITEPROT --------------------------------------------------------- + +const sal_uInt16 EXC_ID_WRITEPROT = 0x0086; + +// (0x008C) COUNTRY ----------------------------------------------------------- + +const sal_uInt16 EXC_ID_COUNTRY = 0x008C; + +// (0x009B) FILTERMODE -------------------------------------------------------- + +const sal_uInt16 EXC_ID_FILTERMODE = 0x009B; + +// (0x009C) FNGROUPCOUNT ------------------------------------------------------ + +const sal_uInt16 EXC_ID_FNGROUPCOUNT = 0x009C; + +// (0x009D) AUTOFILTERINFO ---------------------------------------------------- + +const sal_uInt16 EXC_ID_AUTOFILTERINFO = 0x009D; + +// (0x009E) AUTOFILTER -------------------------------------------------------- + +const sal_uInt16 EXC_ID_AUTOFILTER = 0x009E; + +// (0x00BF, 0x00C0, 0x00C1) TOOLBARHDR, TOOLBAREND, MMS ----------------------- + +const sal_uInt16 EXC_ID_TOOLBARHDR = 0x00BF; +const sal_uInt16 EXC_ID_TOOLBAREND = 0x00C0; +const sal_uInt16 EXC_ID_MMS = 0x00C1; + +// (0x00E1, 0x00E2) INTERFACEHDR, INTERFACEEND -------------------------------- + +const sal_uInt16 EXC_ID_INTERFACEHDR = 0x00E1; +const sal_uInt16 EXC_ID_INTERFACEEND = 0x00E2; + +// (0x0160) USESELFS ---------------------------------------------------------- + +const sal_uInt16 EXC_ID_USESELFS = 0x0160; + +// (0x0161) DSF --------------------------------------------------------------- + +const sal_uInt16 EXC_ID_DSF = 0x0161; + +// (0x01AA,0x01AB) USERSVIEWBEGIN, USERSVIEWEND ------------------------------- + +const sal_uInt16 EXC_ID_USERSVIEWBEGIN = 0x01AA; +const sal_uInt16 EXC_ID_USERSVIEWEND = 0x01AB; + +// (0x01BA) CODENAME ---------------------------------------------------------- + +const sal_uInt16 EXC_ID_CODENAME = 0x01BA; + +// (0x01C0) XL9FILE ----------------------------------------------------------- + +const sal_uInt16 EXC_ID_XL9FILE = 0x01C0; + +// (0x8xx) Future records ----------------------------------------------------- + +/** Enumerates different header types of future records. */ +enum XclFutureRecType +{ + EXC_FUTUREREC_SIMPLE, /// Record identifier and empty flags field. + EXC_FUTUREREC_UNUSEDREF /// Record identifier, empty flags field, unused range address. +}; + +const sal_uInt16 EXC_FUTUREREC_EMPTYFLAGS = 0x0000; +const sal_uInt16 EXC_FUTUREREC_HASREF = 0x0001; +const sal_uInt16 EXC_FUTUREREC_ALERT = 0x0002; + +// ============================================================================ + +#endif + |