sc/source/filter/inc/xlcontent.hxx

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