sc/source/filter/inc/xlcontent.hxx

   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 <sal/types.h>
  23
  24 // Constants ==================================================================
  25
  26 // (0x005B) FILESHARING -------------------------------------------------------
  27
  28 const sal_uInt16 EXC_ID_FILESHARING         = 0x005B;
  29
  30 // (0x00E5) MERGEDCELLS -------------------------------------------------------
  31
  32 const sal_uInt16 EXC_ID_MERGEDCELLS         = 0x00E5;
  33 const sal_uInt16 EXC_MERGEDCELLS_MAXCOUNT   = 1027;
  34
  35 // (0x002F) FILEPASS ----------------------------------------------------------
  36
  37 const sal_uInt16 EXC_ID_FILEPASS            = 0x002F;
  38
  39 const sal_uInt16 EXC_FILEPASS_BIFF5         = 0x0000;
  40 const sal_uInt16 EXC_FILEPASS_BIFF8         = 0x0001;
  41
  42 // (0x00FC, 0x00FF) SST, EXTSST -----------------------------------------------
  43
  44 const sal_uInt16 EXC_ID_SST                 = 0x00FC;
  45 const sal_uInt16 EXC_ID_EXTSST              = 0x00FF;
  46
  47 // (0x015F) LABELRANGES -------------------------------------------------------
  48
  49 const sal_uInt16 EXC_ID_LABELRANGES         = 0x015F;
  50
  51 // (0x01B0) CONDFMT, (0x01B1) CF ----------------------------------------------
  52
  53 const sal_uInt16 EXC_ID_CONDFMT             = 0x01B0;
  54 const sal_uInt16 EXC_ID_CF                  = 0x01B1;
  55
  56 const sal_uInt8 EXC_CF_TYPE_NONE            = 0x00;
  57 const sal_uInt8 EXC_CF_TYPE_CELL            = 0x01;
  58 const sal_uInt8 EXC_CF_TYPE_FMLA            = 0x02;
  59
  60 const sal_uInt8 EXC_CF_CMP_NONE             = 0x00;
  61 const sal_uInt8 EXC_CF_CMP_BETWEEN          = 0x01;
  62 const sal_uInt8 EXC_CF_CMP_NOT_BETWEEN      = 0x02;
  63 const sal_uInt8 EXC_CF_CMP_EQUAL            = 0x03;
  64 const sal_uInt8 EXC_CF_CMP_NOT_EQUAL        = 0x04;
  65 const sal_uInt8 EXC_CF_CMP_GREATER          = 0x05;
  66 const sal_uInt8 EXC_CF_CMP_LESS             = 0x06;
  67 const sal_uInt8 EXC_CF_CMP_GREATER_EQUAL    = 0x07;
  68 const sal_uInt8 EXC_CF_CMP_LESS_EQUAL       = 0x08;
  69
  70 const sal_uInt32 EXC_CF_BORDER_LEFT         = 0x00000400;   /// Left border line modified?
  71 const sal_uInt32 EXC_CF_BORDER_RIGHT        = 0x00000800;   /// Right border line modified?
  72 const sal_uInt32 EXC_CF_BORDER_TOP          = 0x00001000;   /// Top border line modified?
  73 const sal_uInt32 EXC_CF_BORDER_BOTTOM       = 0x00002000;   /// Bottom border line modified?
  74 const sal_uInt32 EXC_CF_BORDER_ALL          = 0x00003C00;   /// Any border line modified?
  75 const sal_uInt32 EXC_CF_AREA_PATTERN        = 0x00010000;   /// Pattern modified?
  76 const sal_uInt32 EXC_CF_AREA_FGCOLOR        = 0x00020000;   /// Foreground color modified?
  77 const sal_uInt32 EXC_CF_AREA_BGCOLOR        = 0x00040000;   /// Background color modified?
  78 const sal_uInt32 EXC_CF_AREA_ALL            = 0x00070000;   /// Any area attribute modified?
  79 const sal_uInt32 EXC_CF_ALLDEFAULT          = 0x003FFFFF;   /// Default flags.
  80 const sal_uInt32 EXC_CF_BLOCK_NUMFMT        = 0x02000000;   /// Font block present?
  81 const sal_uInt32 EXC_CF_BLOCK_FONT          = 0x04000000;   /// Font block present?
  82 const sal_uInt32 EXC_CF_BLOCK_ALIGNMENT     = 0x08000000;   /// Alignment block present?
  83 const sal_uInt32 EXC_CF_BLOCK_BORDER        = 0x10000000;   /// Border block present?
  84 const sal_uInt32 EXC_CF_BLOCK_AREA          = 0x20000000;   /// Pattern block present?
  85 const sal_uInt32 EXC_CF_BLOCK_PROTECTION    = 0x40000000;   /// Protection block present?
  86 const sal_uInt32 EXC_CF_IFMT_USER           = 0x1;          /// NumberFormat String or Id?
  87
  88 const sal_uInt32 EXC_CF_FONT_STYLE          = 0x00000002;   /// Font posture or weight modified?
  89 const sal_uInt32 EXC_CF_FONT_STRIKEOUT      = 0x00000080;   /// Font cancellation modified?
  90 const sal_uInt32 EXC_CF_FONT_ALLDEFAULT     = 0x0000009A;   /// Default flags.
  91
  92 const sal_uInt32 EXC_CF_FONT_UNDERL         = 0x00000001;   /// Font underline type modified?
  93 const sal_uInt32 EXC_CF_FONT_ESCAPEM        = 0x00000001;   /// Font escapement type modified?
  94
  95 // (0x01B2) DVAL --------------------------------------------------------------
  96
  97 const sal_uInt16 EXC_ID_DVAL                = 0x01B2;
  98 const sal_uInt32 EXC_DVAL_NOOBJ             = 0xFFFFFFFF;
  99
 100 // (0x01BE) DV ----------------------------------------------------------------
 101
 102 const sal_uInt16 EXC_ID_DV                  = 0x01BE;
 103
 104 // data validation flags
 105 const sal_uInt32 EXC_DV_STRINGLIST          = 0x00000080;
 106 const sal_uInt32 EXC_DV_IGNOREBLANK         = 0x00000100;
 107 const sal_uInt32 EXC_DV_SUPPRESSDROPDOWN    = 0x00000200;
 108 const sal_uInt32 EXC_DV_SHOWPROMPT          = 0x00040000;
 109 const sal_uInt32 EXC_DV_SHOWERROR           = 0x00080000;
 110
 111 // data validation data mode
 112 const sal_uInt32 EXC_DV_MODE_MASK           = 0x0000000F;
 113 const sal_uInt32 EXC_DV_MODE_ANY            = 0x00000000;
 114 const sal_uInt32 EXC_DV_MODE_WHOLE          = 0x00000001;
 115 const sal_uInt32 EXC_DV_MODE_DECIMAL        = 0x00000002;
 116 const sal_uInt32 EXC_DV_MODE_LIST           = 0x00000003;
 117 const sal_uInt32 EXC_DV_MODE_DATE           = 0x00000004;
 118 const sal_uInt32 EXC_DV_MODE_TIME           = 0x00000005;
 119 const sal_uInt32 EXC_DV_MODE_TEXTLEN        = 0x00000006;
 120 const sal_uInt32 EXC_DV_MODE_CUSTOM         = 0x00000007;
 121
 122 // data validation conditions
 123 const sal_uInt32 EXC_DV_COND_MASK           = 0x00F00000;
 124 const sal_uInt32 EXC_DV_COND_BETWEEN        = 0x00000000;
 125 const sal_uInt32 EXC_DV_COND_NOTBETWEEN     = 0x00100000;
 126 const sal_uInt32 EXC_DV_COND_EQUAL          = 0x00200000;
 127 const sal_uInt32 EXC_DV_COND_NOTEQUAL       = 0x00300000;
 128 const sal_uInt32 EXC_DV_COND_GREATER        = 0x00400000;
 129 const sal_uInt32 EXC_DV_COND_LESS           = 0x00500000;
 130 const sal_uInt32 EXC_DV_COND_EQGREATER      = 0x00600000;
 131 const sal_uInt32 EXC_DV_COND_EQLESS         = 0x00700000;
 132
 133 // data validation error style
 134 const sal_uInt32 EXC_DV_ERROR_MASK          = 0x00000070;
 135 const sal_uInt32 EXC_DV_ERROR_STOP          = 0x00000000;
 136 const sal_uInt32 EXC_DV_ERROR_WARNING       = 0x00000010;
 137 const sal_uInt32 EXC_DV_ERROR_INFO          = 0x00000020;
 138
 139 // (0x01B8) HLINK -------------------------------------------------------------
 140
 141 const sal_uInt16 EXC_ID_HLINK               = 0x01B8;
 142
 143 const sal_uInt32 EXC_HLINK_BODY             = 0x00000001;   /// Contains file link or URL.
 144 const sal_uInt32 EXC_HLINK_ABS              = 0x00000002;   /// Absolute path.
 145 const sal_uInt32 EXC_HLINK_DESCR            = 0x00000014;   /// Description.
 146 const sal_uInt32 EXC_HLINK_MARK             = 0x00000008;   /// Text mark.
 147 const sal_uInt32 EXC_HLINK_FRAME            = 0x00000080;   /// Target frame.
 148 const sal_uInt32 EXC_HLINK_UNC              = 0x00000100;   /// UNC path.
 149
 150 // web queries ================================================================
 151
 152 #define EXC_WEBQRY_FILTER                   "calc_HTML_WebQuery"
 153
 154 // (0x00CD) WQSTRING
 155 const sal_uInt16 EXC_ID_WQSTRING            = 0x00CD;
 156
 157 // (0x00DC) PARAMQRY
 158 const sal_uInt16 EXC_ID_PQRY                = 0x00DC;
 159 const sal_uInt16 EXC_PQRYTYPE_ODBC          = 1;            /// Source type: ODBC.
 160 const sal_uInt16 EXC_PQRYTYPE_WEBQUERY      = 4;            /// Source type: webquery.
 161 const sal_uInt16 EXC_PQRY_ODBC              = 0x0008;       /// ODBC connection.
 162 const sal_uInt16 EXC_PQRY_WEBQUERY          = 0x0040;       /// Web query.
 163 const sal_uInt16 EXC_PQRY_TABLES            = 0x0100;       /// All tables.
 164
 165 // (0x01AD) QSI
 166 const sal_uInt16 EXC_ID_QSI                 = 0x01AD;
 167 const sal_uInt16 EXC_QSI_DEFAULTFLAGS       = 0x0349;       /// Flags for export.
 168
 169 // (0x0802) unknown record
 170 const sal_uInt16 EXC_ID_0802                = 0x0802;
 171
 172 // (0x0803) WEBQRYSETTINGS
 173 const sal_uInt16 EXC_ID_WQSETT              = 0x0803;
 174 const sal_uInt16 EXC_WQSETT_ALL             = 0x0000;       /// All tables or entire document.
 175 const sal_uInt16 EXC_WQSETT_SPECTABLES      = 0x0002;       /// Specific tables.
 176 const sal_uInt16 EXC_WQSETT_DEFAULTFLAGS    = 0x0023;       /// Flags for export.
 177 const sal_uInt16 EXC_WQSETT_NOFORMAT        = 0x0001;
 178 const sal_uInt16 EXC_WQSETT_FORMATRTF       = 0x0002;
 179 const sal_uInt16 EXC_WQSETT_FORMATFULL      = 0x0003;
 180
 181 // (0x0804) WEBQRYTABLES
 182 const sal_uInt16 EXC_ID_WQTABLES            = 0x0804;
 183
 184 const sal_uInt16 EXC_ID_EXTLST              = 0x9988;       /// it is just a random number
 185
 186 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */