xref: /aoo42x/main/sc/source/filter/inc/xlcontent.hxx (revision 38d50f7b)
1 /**************************************************************
2  *
3  * Licensed to the Apache Software Foundation (ASF) under one
4  * or more contributor license agreements.  See the NOTICE file
5  * distributed with this work for additional information
6  * regarding copyright ownership.  The ASF licenses this file
7  * to you under the Apache License, Version 2.0 (the
8  * "License"); you may not use this file except in compliance
9  * with the License.  You may obtain a copy of the License at
10  *
11  *   http://www.apache.org/licenses/LICENSE-2.0
12  *
13  * Unless required by applicable law or agreed to in writing,
14  * software distributed under the License is distributed on an
15  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16  * KIND, either express or implied.  See the License for the
17  * specific language governing permissions and limitations
18  * under the License.
19  *
20  *************************************************************/
21 
22 
23 
24 #ifndef SC_XLCONTENT_HXX
25 #define SC_XLCONTENT_HXX
26 
27 #include <sal/types.h>
28 
29 // Constants ==================================================================
30 
31 // (0x005B) FILESHARING -------------------------------------------------------
32 
33 const sal_uInt16 EXC_ID_FILESHARING         = 0x005B;
34 
35 // (0x00E5) MERGEDCELLS -------------------------------------------------------
36 
37 const sal_uInt16 EXC_ID_MERGEDCELLS         = 0x00E5;
38 const sal_uInt16 EXC_MERGEDCELLS_MAXCOUNT   = 1027;
39 
40 // (0x002F) FILEPASS ----------------------------------------------------------
41 
42 const sal_uInt16 EXC_ID_FILEPASS            = 0x002F;
43 
44 const sal_uInt16 EXC_FILEPASS_BIFF5         = 0x0000;
45 const sal_uInt16 EXC_FILEPASS_BIFF8         = 0x0001;
46 const sal_uInt16 EXC_FILEPASS_BIFF8_STD     = 0x0001;
47 const sal_uInt16 EXC_FILEPASS_BIFF8_STRONG  = 0x0002;
48 
49 // (0x00FC, 0x00FF) SST, EXTSST -----------------------------------------------
50 
51 const sal_uInt16 EXC_ID_SST                 = 0x00FC;
52 const sal_uInt16 EXC_ID_EXTSST              = 0x00FF;
53 
54 // (0x015F) LABELRANGES -------------------------------------------------------
55 
56 const sal_uInt16 EXC_ID_LABELRANGES         = 0x015F;
57 
58 // (0x01B0) CONDFMT, (0x01B1) CF ----------------------------------------------
59 
60 const sal_uInt16 EXC_ID_CONDFMT             = 0x01B0;
61 const sal_uInt16 EXC_ID_CF                  = 0x01B1;
62 
63 const sal_uInt8 EXC_CF_TYPE_NONE            = 0x00;
64 const sal_uInt8 EXC_CF_TYPE_CELL            = 0x01;
65 const sal_uInt8 EXC_CF_TYPE_FMLA            = 0x02;
66 
67 const sal_uInt8 EXC_CF_CMP_NONE             = 0x00;
68 const sal_uInt8 EXC_CF_CMP_BETWEEN          = 0x01;
69 const sal_uInt8 EXC_CF_CMP_NOT_BETWEEN      = 0x02;
70 const sal_uInt8 EXC_CF_CMP_EQUAL            = 0x03;
71 const sal_uInt8 EXC_CF_CMP_NOT_EQUAL        = 0x04;
72 const sal_uInt8 EXC_CF_CMP_GREATER          = 0x05;
73 const sal_uInt8 EXC_CF_CMP_LESS             = 0x06;
74 const sal_uInt8 EXC_CF_CMP_GREATER_EQUAL    = 0x07;
75 const sal_uInt8 EXC_CF_CMP_LESS_EQUAL       = 0x08;
76 
77 const sal_uInt32 EXC_CF_BORDER_LEFT         = 0x00000400;   /// Left border line modified?
78 const sal_uInt32 EXC_CF_BORDER_RIGHT        = 0x00000800;   /// Right border line modified?
79 const sal_uInt32 EXC_CF_BORDER_TOP          = 0x00001000;   /// Top border line modified?
80 const sal_uInt32 EXC_CF_BORDER_BOTTOM       = 0x00002000;   /// Bottom border line modified?
81 const sal_uInt32 EXC_CF_BORDER_ALL          = 0x00003C00;   /// Any border line modified?
82 const sal_uInt32 EXC_CF_AREA_PATTERN        = 0x00010000;   /// Pattern modified?
83 const sal_uInt32 EXC_CF_AREA_FGCOLOR        = 0x00020000;   /// Foreground color modified?
84 const sal_uInt32 EXC_CF_AREA_BGCOLOR        = 0x00040000;   /// Background color modified?
85 const sal_uInt32 EXC_CF_AREA_ALL            = 0x00070000;   /// Any area attribute modified?
86 const sal_uInt32 EXC_CF_ALLDEFAULT          = 0x003FFFFF;   /// Default flags.
87 const sal_uInt32 EXC_CF_BLOCK_FONT          = 0x04000000;   /// Font block present?
88 const sal_uInt32 EXC_CF_BLOCK_BORDER        = 0x10000000;   /// Border block present?
89 const sal_uInt32 EXC_CF_BLOCK_AREA          = 0x20000000;   /// Pattern block present?
90 
91 const sal_uInt32 EXC_CF_FONT_STYLE          = 0x00000002;   /// Font posture or weight modified?
92 const sal_uInt32 EXC_CF_FONT_STRIKEOUT      = 0x00000080;   /// Font cancellation modified?
93 const sal_uInt32 EXC_CF_FONT_ALLDEFAULT     = 0x0000009A;   /// Default flags.
94 
95 const sal_uInt32 EXC_CF_FONT_UNDERL         = 0x00000001;   /// Font underline type modified?
96 const sal_uInt32 EXC_CF_FONT_ESCAPEM        = 0x00000001;   /// Font escapement type modified?
97 
98 // (0x01B2) DVAL --------------------------------------------------------------
99 
100 const sal_uInt16 EXC_ID_DVAL                = 0x01B2;
101 const sal_uInt32 EXC_DVAL_NOOBJ             = 0xFFFFFFFF;
102 
103 // (0x01BE) DV ----------------------------------------------------------------
104 
105 const sal_uInt16 EXC_ID_DV                  = 0x01BE;
106 
107 // data validation flags
108 const sal_uInt32 EXC_DV_STRINGLIST          = 0x00000080;
109 const sal_uInt32 EXC_DV_IGNOREBLANK         = 0x00000100;
110 const sal_uInt32 EXC_DV_SUPPRESSDROPDOWN    = 0x00000200;
111 const sal_uInt32 EXC_DV_SHOWPROMPT          = 0x00040000;
112 const sal_uInt32 EXC_DV_SHOWERROR           = 0x00080000;
113 
114 // data validation data mode
115 const sal_uInt32 EXC_DV_MODE_MASK           = 0x0000000F;
116 const sal_uInt32 EXC_DV_MODE_ANY            = 0x00000000;
117 const sal_uInt32 EXC_DV_MODE_WHOLE          = 0x00000001;
118 const sal_uInt32 EXC_DV_MODE_DECIMAL        = 0x00000002;
119 const sal_uInt32 EXC_DV_MODE_LIST           = 0x00000003;
120 const sal_uInt32 EXC_DV_MODE_DATE           = 0x00000004;
121 const sal_uInt32 EXC_DV_MODE_TIME           = 0x00000005;
122 const sal_uInt32 EXC_DV_MODE_TEXTLEN        = 0x00000006;
123 const sal_uInt32 EXC_DV_MODE_CUSTOM         = 0x00000007;
124 
125 // data validation conditions
126 const sal_uInt32 EXC_DV_COND_MASK           = 0x00F00000;
127 const sal_uInt32 EXC_DV_COND_BETWEEN        = 0x00000000;
128 const sal_uInt32 EXC_DV_COND_NOTBETWEEN     = 0x00100000;
129 const sal_uInt32 EXC_DV_COND_EQUAL          = 0x00200000;
130 const sal_uInt32 EXC_DV_COND_NOTEQUAL       = 0x00300000;
131 const sal_uInt32 EXC_DV_COND_GREATER        = 0x00400000;
132 const sal_uInt32 EXC_DV_COND_LESS           = 0x00500000;
133 const sal_uInt32 EXC_DV_COND_EQGREATER      = 0x00600000;
134 const sal_uInt32 EXC_DV_COND_EQLESS         = 0x00700000;
135 
136 // data validation error style
137 const sal_uInt32 EXC_DV_ERROR_MASK          = 0x00000070;
138 const sal_uInt32 EXC_DV_ERROR_STOP          = 0x00000000;
139 const sal_uInt32 EXC_DV_ERROR_WARNING       = 0x00000010;
140 const sal_uInt32 EXC_DV_ERROR_INFO          = 0x00000020;
141 
142 // (0x01B8) HLINK -------------------------------------------------------------
143 
144 const sal_uInt16 EXC_ID_HLINK               = 0x01B8;
145 
146 const sal_uInt32 EXC_HLINK_BODY             = 0x00000001;   /// Contains file link or URL.
147 const sal_uInt32 EXC_HLINK_ABS              = 0x00000002;   /// Absolute path.
148 const sal_uInt32 EXC_HLINK_DESCR            = 0x00000014;   /// Description.
149 const sal_uInt32 EXC_HLINK_MARK             = 0x00000008;   /// Text mark.
150 const sal_uInt32 EXC_HLINK_FRAME            = 0x00000080;   /// Target frame.
151 const sal_uInt32 EXC_HLINK_UNC              = 0x00000100;   /// UNC path.
152 
153 // web queries ================================================================
154 
155 #define EXC_WEBQRY_FILTER                   "calc_HTML_WebQuery"
156 
157 // (0x00CD) WQSTRING
158 const sal_uInt16 EXC_ID_WQSTRING            = 0x00CD;
159 
160 // (0x00DC) PARAMQRY
161 const sal_uInt16 EXC_ID_PQRY                = 0x00DC;
162 const sal_uInt16 EXC_PQRYTYPE_ODBC          = 1;            /// Source type: ODBC.
163 const sal_uInt16 EXC_PQRYTYPE_WEBQUERY      = 4;            /// Source type: webquery.
164 const sal_uInt16 EXC_PQRY_ODBC              = 0x0008;       /// ODBC connection.
165 const sal_uInt16 EXC_PQRY_WEBQUERY          = 0x0040;       /// Web query.
166 const sal_uInt16 EXC_PQRY_TABLES            = 0x0100;       /// All tables.
167 
168 // (0x01AD) QSI
169 const sal_uInt16 EXC_ID_QSI                 = 0x01AD;
170 const sal_uInt16 EXC_QSI_DEFAULTFLAGS       = 0x0349;       /// Flags for export.
171 
172 // (0x0802) unknown record
173 const sal_uInt16 EXC_ID_0802                = 0x0802;
174 
175 // (0x0803) WEBQRYSETTINGS
176 const sal_uInt16 EXC_ID_WQSETT              = 0x0803;
177 const sal_uInt16 EXC_WQSETT_ALL             = 0x0000;       /// All tables or entire document.
178 const sal_uInt16 EXC_WQSETT_SPECTABLES      = 0x0002;       /// Specific tables.
179 const sal_uInt16 EXC_WQSETT_DEFAULTFLAGS    = 0x0023;       /// Flags for export.
180 const sal_uInt16 EXC_WQSETT_NOFORMAT        = 0x0001;
181 const sal_uInt16 EXC_WQSETT_FORMATRTF       = 0x0002;
182 const sal_uInt16 EXC_WQSETT_FORMATFULL      = 0x0003;
183 
184 // (0x0804) WEBQRYTABLES
185 const sal_uInt16 EXC_ID_WQTABLES            = 0x0804;
186 
187 // ============================================================================
188 
189 #endif
190 
191