1 /*************************************************************************
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
5 * Copyright 2008 by Sun Microsystems, Inc.
7 * OpenOffice.org - a multi-platform office productivity suite
9 * $RCSfile: xlcontent.hxx,v $
12 * This file is part of OpenOffice.org.
14 * OpenOffice.org is free software: you can redistribute it and/or modify
15 * it under the terms of the GNU Lesser General Public License version 3
16 * only, as published by the Free Software Foundation.
18 * OpenOffice.org is distributed in the hope that it will be useful,
19 * but WITHOUT ANY WARRANTY; without even the implied warranty of
20 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
21 * GNU Lesser General Public License version 3 for more details
22 * (a copy is included in the LICENSE file that accompanied this code).
24 * You should have received a copy of the GNU Lesser General Public License
25 * version 3 along with OpenOffice.org. If not, see
26 * <http://www.openoffice.org/license.html>
27 * for a copy of the LGPLv3 License.
29 ************************************************************************/
31 #ifndef SC_XLCONTENT_HXX
32 #define SC_XLCONTENT_HXX
34 #include <sal/types.h>
36 // Constants ==================================================================
38 // (0x005B) FILESHARING -------------------------------------------------------
40 const sal_uInt16 EXC_ID_FILESHARING
= 0x005B;
42 // (0x00E5) MERGEDCELLS -------------------------------------------------------
44 const sal_uInt16 EXC_ID_MERGEDCELLS
= 0x00E5;
45 const sal_uInt16 EXC_MERGEDCELLS_MAXCOUNT
= 1027;
47 // (0x002F) FILEPASS ----------------------------------------------------------
49 const sal_uInt16 EXC_ID_FILEPASS
= 0x002F;
51 const sal_uInt16 EXC_FILEPASS_BIFF5
= 0x0000;
52 const sal_uInt16 EXC_FILEPASS_BIFF8
= 0x0001;
53 const sal_uInt16 EXC_FILEPASS_BIFF8_STD
= 0x0001;
54 const sal_uInt16 EXC_FILEPASS_BIFF8_STRONG
= 0x0002;
56 // (0x00FC, 0x00FF) SST, EXTSST -----------------------------------------------
58 const sal_uInt16 EXC_ID_SST
= 0x00FC;
59 const sal_uInt16 EXC_ID_EXTSST
= 0x00FF;
61 // (0x015F) LABELRANGES -------------------------------------------------------
63 const sal_uInt16 EXC_ID_LABELRANGES
= 0x015F;
65 // (0x01B0) CONDFMT, (0x01B1) CF ----------------------------------------------
67 const sal_uInt16 EXC_ID_CONDFMT
= 0x01B0;
68 const sal_uInt16 EXC_ID_CF
= 0x01B1;
70 const sal_uInt8 EXC_CF_TYPE_NONE
= 0x00;
71 const sal_uInt8 EXC_CF_TYPE_CELL
= 0x01;
72 const sal_uInt8 EXC_CF_TYPE_FMLA
= 0x02;
74 const sal_uInt8 EXC_CF_CMP_NONE
= 0x00;
75 const sal_uInt8 EXC_CF_CMP_BETWEEN
= 0x01;
76 const sal_uInt8 EXC_CF_CMP_NOT_BETWEEN
= 0x02;
77 const sal_uInt8 EXC_CF_CMP_EQUAL
= 0x03;
78 const sal_uInt8 EXC_CF_CMP_NOT_EQUAL
= 0x04;
79 const sal_uInt8 EXC_CF_CMP_GREATER
= 0x05;
80 const sal_uInt8 EXC_CF_CMP_LESS
= 0x06;
81 const sal_uInt8 EXC_CF_CMP_GREATER_EQUAL
= 0x07;
82 const sal_uInt8 EXC_CF_CMP_LESS_EQUAL
= 0x08;
84 const sal_uInt32 EXC_CF_BORDER_LEFT
= 0x00000400; /// Left border line modified?
85 const sal_uInt32 EXC_CF_BORDER_RIGHT
= 0x00000800; /// Right border line modified?
86 const sal_uInt32 EXC_CF_BORDER_TOP
= 0x00001000; /// Top border line modified?
87 const sal_uInt32 EXC_CF_BORDER_BOTTOM
= 0x00002000; /// Bottom border line modified?
88 const sal_uInt32 EXC_CF_BORDER_ALL
= 0x00003C00; /// Any border line modified?
89 const sal_uInt32 EXC_CF_AREA_PATTERN
= 0x00010000; /// Pattern modified?
90 const sal_uInt32 EXC_CF_AREA_FGCOLOR
= 0x00020000; /// Foreground color modified?
91 const sal_uInt32 EXC_CF_AREA_BGCOLOR
= 0x00040000; /// Background color modified?
92 const sal_uInt32 EXC_CF_AREA_ALL
= 0x00070000; /// Any area attribute modified?
93 const sal_uInt32 EXC_CF_ALLDEFAULT
= 0x003FFFFF; /// Default flags.
94 const sal_uInt32 EXC_CF_BLOCK_FONT
= 0x04000000; /// Font block present?
95 const sal_uInt32 EXC_CF_BLOCK_BORDER
= 0x10000000; /// Border block present?
96 const sal_uInt32 EXC_CF_BLOCK_AREA
= 0x20000000; /// Pattern block present?
98 const sal_uInt32 EXC_CF_FONT_STYLE
= 0x00000002; /// Font posture or weight modified?
99 const sal_uInt32 EXC_CF_FONT_STRIKEOUT
= 0x00000080; /// Font cancellation modified?
100 const sal_uInt32 EXC_CF_FONT_ALLDEFAULT
= 0x0000009A; /// Default flags.
102 const sal_uInt32 EXC_CF_FONT_UNDERL
= 0x00000001; /// Font underline type modified?
103 const sal_uInt32 EXC_CF_FONT_ESCAPEM
= 0x00000001; /// Font escapement type modified?
105 // (0x01B2) DVAL --------------------------------------------------------------
107 const sal_uInt16 EXC_ID_DVAL
= 0x01B2;
108 const sal_uInt32 EXC_DVAL_NOOBJ
= 0xFFFFFFFF;
110 // (0x01BE) DV ----------------------------------------------------------------
112 const sal_uInt16 EXC_ID_DV
= 0x01BE;
114 // data validation flags
115 const sal_uInt32 EXC_DV_STRINGLIST
= 0x00000080;
116 const sal_uInt32 EXC_DV_IGNOREBLANK
= 0x00000100;
117 const sal_uInt32 EXC_DV_SUPPRESSDROPDOWN
= 0x00000200;
118 const sal_uInt32 EXC_DV_SHOWPROMPT
= 0x00040000;
119 const sal_uInt32 EXC_DV_SHOWERROR
= 0x00080000;
121 // data validation data mode
122 const sal_uInt32 EXC_DV_MODE_MASK
= 0x0000000F;
123 const sal_uInt32 EXC_DV_MODE_ANY
= 0x00000000;
124 const sal_uInt32 EXC_DV_MODE_WHOLE
= 0x00000001;
125 const sal_uInt32 EXC_DV_MODE_DECIMAL
= 0x00000002;
126 const sal_uInt32 EXC_DV_MODE_LIST
= 0x00000003;
127 const sal_uInt32 EXC_DV_MODE_DATE
= 0x00000004;
128 const sal_uInt32 EXC_DV_MODE_TIME
= 0x00000005;
129 const sal_uInt32 EXC_DV_MODE_TEXTLEN
= 0x00000006;
130 const sal_uInt32 EXC_DV_MODE_CUSTOM
= 0x00000007;
132 // data validation conditions
133 const sal_uInt32 EXC_DV_COND_MASK
= 0x00F00000;
134 const sal_uInt32 EXC_DV_COND_BETWEEN
= 0x00000000;
135 const sal_uInt32 EXC_DV_COND_NOTBETWEEN
= 0x00100000;
136 const sal_uInt32 EXC_DV_COND_EQUAL
= 0x00200000;
137 const sal_uInt32 EXC_DV_COND_NOTEQUAL
= 0x00300000;
138 const sal_uInt32 EXC_DV_COND_GREATER
= 0x00400000;
139 const sal_uInt32 EXC_DV_COND_LESS
= 0x00500000;
140 const sal_uInt32 EXC_DV_COND_EQGREATER
= 0x00600000;
141 const sal_uInt32 EXC_DV_COND_EQLESS
= 0x00700000;
143 // data validation error style
144 const sal_uInt32 EXC_DV_ERROR_MASK
= 0x00000070;
145 const sal_uInt32 EXC_DV_ERROR_STOP
= 0x00000000;
146 const sal_uInt32 EXC_DV_ERROR_WARNING
= 0x00000010;
147 const sal_uInt32 EXC_DV_ERROR_INFO
= 0x00000020;
149 // (0x01B8) HLINK -------------------------------------------------------------
151 const sal_uInt16 EXC_ID_HLINK
= 0x01B8;
153 const sal_uInt32 EXC_HLINK_BODY
= 0x00000001; /// Contains file link or URL.
154 const sal_uInt32 EXC_HLINK_ABS
= 0x00000002; /// Absolute path.
155 const sal_uInt32 EXC_HLINK_DESCR
= 0x00000014; /// Description.
156 const sal_uInt32 EXC_HLINK_MARK
= 0x00000008; /// Text mark.
157 const sal_uInt32 EXC_HLINK_FRAME
= 0x00000080; /// Target frame.
158 const sal_uInt32 EXC_HLINK_UNC
= 0x00000100; /// UNC path.
160 // web queries ================================================================
162 #define EXC_WEBQRY_FILTER "calc_HTML_WebQuery"
165 const sal_uInt16 EXC_ID_WQSTRING
= 0x00CD;
168 const sal_uInt16 EXC_ID_PQRY
= 0x00DC;
169 const sal_uInt16 EXC_PQRYTYPE_ODBC
= 1; /// Source type: ODBC.
170 const sal_uInt16 EXC_PQRYTYPE_WEBQUERY
= 4; /// Source type: webquery.
171 const sal_uInt16 EXC_PQRY_ODBC
= 0x0008; /// ODBC connection.
172 const sal_uInt16 EXC_PQRY_WEBQUERY
= 0x0040; /// Web query.
173 const sal_uInt16 EXC_PQRY_TABLES
= 0x0100; /// All tables.
176 const sal_uInt16 EXC_ID_QSI
= 0x01AD;
177 const sal_uInt16 EXC_QSI_DEFAULTFLAGS
= 0x0349; /// Flags for export.
179 // (0x0802) unknown record
180 const sal_uInt16 EXC_ID_0802
= 0x0802;
182 // (0x0803) WEBQRYSETTINGS
183 const sal_uInt16 EXC_ID_WQSETT
= 0x0803;
184 const sal_uInt16 EXC_WQSETT_ALL
= 0x0000; /// All tables or entire document.
185 const sal_uInt16 EXC_WQSETT_SPECTABLES
= 0x0002; /// Specific tables.
186 const sal_uInt16 EXC_WQSETT_DEFAULTFLAGS
= 0x0023; /// Flags for export.
187 const sal_uInt16 EXC_WQSETT_NOFORMAT
= 0x0001;
188 const sal_uInt16 EXC_WQSETT_FORMATRTF
= 0x0002;
189 const sal_uInt16 EXC_WQSETT_FORMATFULL
= 0x0003;
191 // (0x0804) WEBQRYTABLES
192 const sal_uInt16 EXC_ID_WQTABLES
= 0x0804;
194 // ============================================================================