sc/source/filter/inc/excrecds.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 <rtl/string.hxx>
  23 #include <rtl/ustring.hxx>
  24 #include <tools/color.hxx>
  25
  26 #include "xerecord.hxx"
  27 #include "xeroot.hxx"
  28 #include "excdefs.hxx"
  29
  30 //------------------------------------------------------------------ Forwards -
  31
  32 class ScDBData;
  33 struct ScQueryEntry;
  34
  35 //----------------------------------------------------------- class ExcRecord -
  36
  37 class ExcRecord : public XclExpRecord
  38 {
  39 public:
  40     virtual void            Save( XclExpStream& rStrm ) override;
  41     virtual void            SaveXml( XclExpXmlStream& rStrm ) override;
  42
  43     virtual sal_uInt16          GetNum() const = 0;
  44     virtual std::size_t     GetLen() const = 0;
  45
  46 protected:
  47     virtual void            SaveCont( XclExpStream& rStrm );
  48
  49 private:
  50     /** Writes the body of the record. */
  51     virtual void            WriteBody( XclExpStream& rStrm ) override;
  52 };
  53
  54 //--------------------------------------------------------- class ExcEmptyRec -
  55
  56 class ExcEmptyRec : public ExcRecord
  57 {
  58 private:
  59 protected:
  60 public:
  61     virtual void            Save( XclExpStream& rStrm ) override;
  62     virtual sal_uInt16          GetNum() const override;
  63     virtual std::size_t     GetLen() const override;
  64 };
  65
  66 //--------------------------------------------------------- class ExcDummyRec -
  67
  68 class ExcDummyRec : public ExcRecord
  69 {
  70 protected:
  71 public:
  72     virtual void            Save( XclExpStream& rStrm ) override;
  73     virtual sal_uInt16          GetNum() const override;
  74     virtual const sal_uInt8*        GetData() const = 0;    // byte data must contain header and body
  75 };
  76
  77 //------------------------------------------------------- class ExcBoolRecord -
  78 // stores bool as 16bit val ( 0x0000 | 0x0001 )
  79
  80 class ExcBoolRecord : public ExcRecord
  81 {
  82 private:
  83     virtual void            SaveCont( XclExpStream& rStrm ) override;
  84
  85 protected:
  86     bool                    bVal;
  87
  88     ExcBoolRecord() : bVal( false ) {}
  89
  90 public:
  91     virtual std::size_t     GetLen() const override;
  92 };
  93
  94 //--------------------------------------------------------- class ExcBof_Base -
  95
  96 class ExcBof_Base : public ExcRecord
  97 {
  98 private:
  99 protected:
 100     sal_uInt16                  nDocType;
 101     sal_uInt16                  nVers;
 102     sal_uInt16                  nRupBuild;
 103     sal_uInt16                  nRupYear;
 104 public:
 105                             ExcBof_Base();
 106 };
 107
 108 //-------------------------------------------------------------- class ExcBof -
 109 // Header Record for WORKSHEETS
 110
 111 class ExcBof : public ExcBof_Base
 112 {
 113 private:
 114     virtual void            SaveCont( XclExpStream& rStrm ) override;
 115 public:
 116                             ExcBof();
 117
 118     virtual sal_uInt16          GetNum() const override;
 119     virtual std::size_t     GetLen() const override;
 120 };
 121
 122 //------------------------------------------------------------- class ExcBofW -
 123 // Header Record for WORKBOOKS
 124
 125 class ExcBofW : public ExcBof_Base
 126 {
 127 private:
 128     virtual void            SaveCont( XclExpStream& rStrm ) override;
 129 public:
 130                             ExcBofW();
 131
 132     virtual sal_uInt16          GetNum() const override;
 133     virtual std::size_t     GetLen() const override;
 134 };
 135
 136 //-------------------------------------------------------------- class ExcEof -
 137
 138 class ExcEof : public ExcRecord
 139 {
 140 private:
 141 public:
 142     virtual sal_uInt16          GetNum() const override;
 143     virtual std::size_t     GetLen() const override;
 144 };
 145
 146 //--------------------------------------------------------- class ExcDummy_00 -
 147 // INTERFACEHDR to FNGROUPCOUNT (see excrecds.cxx)
 148
 149 class ExcDummy_00 : public ExcDummyRec
 150 {
 151 private:
 152     static const sal_uInt8      pMyData[];
 153     static const std::size_t   nMyLen;
 154 public:
 155     virtual std::size_t        GetLen() const override;
 156     virtual const sal_uInt8*        GetData() const override;
 157 };
 158
 159 // EXC_ID_WINDOWPROTECTION
 160 class XclExpWindowProtection : public   XclExpBoolRecord
 161 {
 162     public:
 163         XclExpWindowProtection(bool bValue);
 164
 165     virtual void            SaveXml( XclExpXmlStream& rStrm ) override;
 166 };
 167
 168 // EXC_ID_PROTECT  Document Protection
 169 class XclExpProtection : public XclExpBoolRecord
 170 {
 171     public:
 172         XclExpProtection(bool bValue);
 173 };
 174
 175 class XclExpSheetProtection : public XclExpProtection
 176 {
 177     SCTAB                   mnTab;
 178     public:
 179         XclExpSheetProtection(bool bValue, SCTAB nTab);
 180     virtual void            SaveXml( XclExpXmlStream& rStrm ) override;
 181 };
 182
 183 class XclExpPassHash : public XclExpRecord
 184 {
 185 public:
 186     XclExpPassHash(const css::uno::Sequence<sal_Int8>& aHash);
 187     virtual ~XclExpPassHash() override;
 188
 189 private:
 190     virtual void    WriteBody(XclExpStream& rStrm) override;
 191
 192 private:
 193     sal_uInt16  mnHash;
 194 };
 195
 196 //-------------------------------------------------------- class ExcDummy_04x -
 197 // PASSWORD to BOOKBOOL (see excrecds.cxx), no 1904
 198
 199 class ExcDummy_040 : public ExcDummyRec
 200 {
 201 private:
 202     static const sal_uInt8      pMyData[];
 203     static const std::size_t   nMyLen;
 204 public:
 205     virtual std::size_t        GetLen() const override;
 206     virtual const sal_uInt8*        GetData() const override;
 207 };
 208
 209 class ExcDummy_041 : public ExcDummyRec
 210 {
 211 private:
 212     static const sal_uInt8     pMyData[];
 213     static const std::size_t   nMyLen;
 214 public:
 215     virtual std::size_t        GetLen() const override;
 216     virtual const sal_uInt8*   GetData() const override;
 217 };
 218
 219 //------------------------------------------------------------- class Exc1904 -
 220
 221 class Exc1904 : public ExcBoolRecord
 222 {
 223 public:
 224                             Exc1904( const ScDocument& rDoc );
 225     virtual sal_uInt16      GetNum() const override;
 226
 227     virtual void            SaveXml( XclExpXmlStream& rStrm ) override;
 228 private:
 229     bool                    bDateCompatibility;
 230 };
 231
 232 //------------------------------------------------------ class ExcBundlesheet -
 233
 234 class ExcBundlesheetBase : public ExcRecord
 235 {
 236 protected:
 237     sal_uInt64              m_nStrPos;
 238     sal_uInt64              m_nOwnPos;    // Position after # and Len
 239     sal_uInt16              nGrbit;
 240     SCTAB                   nTab;
 241
 242                             ExcBundlesheetBase();
 243
 244 public:
 245                             ExcBundlesheetBase( const RootData& rRootData, SCTAB nTab );
 246
 247     void                    SetStreamPos(sal_uInt64 const nStrPos) { m_nStrPos = nStrPos; }
 248     void                    UpdateStreamPos( XclExpStream& rStrm );
 249
 250     virtual sal_uInt16          GetNum() const override;
 251 };
 252
 253 class ExcBundlesheet : public ExcBundlesheetBase
 254 {
 255 private:
 256     OString            aName;
 257
 258     virtual void            SaveCont( XclExpStream& rStrm ) override;
 259
 260 public:
 261                             ExcBundlesheet( const RootData& rRootData, SCTAB nTab );
 262     virtual std::size_t     GetLen() const override;
 263 };
 264
 265 //--------------------------------------------------------- class ExcDummy_02 -
 266 // sheet dummies: CALCMODE to SETUP
 267
 268 class ExcDummy_02a : public ExcDummyRec
 269 {
 270 private:
 271     static const sal_uInt8      pMyData[];
 272     static const std::size_t   nMyLen;
 273 public:
 274     virtual std::size_t        GetLen() const override;
 275     virtual const sal_uInt8*        GetData() const override;
 276 };
 277
 278 /** This record contains the Windows country IDs for the UI and document language. */
 279 class XclExpCountry : public XclExpRecord
 280 {
 281 public:
 282     explicit                    XclExpCountry( const XclExpRoot& rRoot );
 283
 284 private:
 285     sal_uInt16                  mnUICountry;        /// The UI country ID.
 286     sal_uInt16                  mnDocCountry;       /// The document country ID.
 287
 288     /** Writes the body of the COUNTRY record. */
 289     virtual void                WriteBody( XclExpStream& rStrm ) override;
 290 };
 291
 292 // XclExpWsbool ===============================================================
 293
 294 class XclExpWsbool : public XclExpUInt16Record
 295 {
 296 public:
 297     explicit XclExpWsbool( bool bFitToPages );
 298 };
 299
 300 /**
 301  * Save sheetPr element and its children for xlsx export.
 302  */
 303 class XclExpXmlSheetPr : public XclExpRecordBase
 304 {
 305 public:
 306     explicit XclExpXmlSheetPr(
 307         bool bFitToPages, SCTAB nScTab, const Color& rTabColor, XclExpFilterManager* pManager );
 308
 309     virtual void SaveXml( XclExpXmlStream& rStrm ) override;
 310
 311 private:
 312     SCTAB mnScTab;
 313     XclExpFilterManager* mpManager;
 314     bool mbFitToPage;
 315     Color maTabColor;
 316 };
 317
 318 class XclExpFiltermode : public XclExpEmptyRecord
 319 {
 320 public:
 321     explicit            XclExpFiltermode();
 322 };
 323
 324 class XclExpAutofilterinfo : public XclExpUInt16Record
 325 {
 326 public:
 327     explicit            XclExpAutofilterinfo( const ScAddress& rStartPos, SCCOL nScCol );
 328
 329     const ScAddress& GetStartPos() const { return maStartPos; }
 330     SCCOL        GetColCount() const { return static_cast< SCCOL >( GetValue() ); }
 331
 332 private:
 333     ScAddress           maStartPos;
 334 };
 335
 336 class ExcFilterCondition
 337 {
 338 private:
 339     sal_uInt8               nType;
 340     sal_uInt8               nOper;
 341     std::unique_ptr<XclExpString>
 342                             pText;
 343
 344 protected:
 345 public:
 346                             ExcFilterCondition();
 347                             ~ExcFilterCondition();
 348
 349     bool             IsEmpty() const     { return (nType == EXC_AFTYPE_NOTUSED); }
 350     std::size_t             GetTextBytes() const;
 351
 352     void                    SetCondition( sal_uInt8 nTp, sal_uInt8 nOp, const OUString* pT );
 353
 354     void                    Save( XclExpStream& rStrm );
 355     void                    SaveXml( XclExpXmlStream& rStrm );
 356     void                    SaveText( XclExpStream& rStrm );
 357 };
 358
 359 class XclExpAutofilter : public XclExpRecord, protected XclExpRoot
 360 {
 361 private:
 362     enum FilterType
 363     {
 364         Empty,
 365         FilterCondition,
 366         MultiValue,
 367         BlankValue,
 368         ColorValue
 369     };
 370     FilterType              meType;
 371     sal_uInt16              nCol;
 372     bool                    bIsButtonHidden;
 373     sal_uInt16              nFlags;
 374     bool                    bHasBlankValue;
 375     ExcFilterCondition      aCond[ 2 ];
 376     std::vector<std::pair<OUString, bool>> maMultiValues; // first->values, second->bDateFormat
 377     std::vector<std::pair<::Color, bool>> maColorValues; // first->Color, second->bIsBackgroundColor (vs. TextColor)
 378
 379     bool                    AddCondition( ScQueryConnect eConn, sal_uInt8 nType,
 380                                 sal_uInt8 nOp, const OUString* pText, bool bSimple = false );
 381
 382     virtual void            WriteBody( XclExpStream& rStrm ) override;
 383
 384 public:
 385                             XclExpAutofilter( const XclExpRoot& rRoot, sal_uInt16 nC, bool bIsEmpty = false );
 386
 387     sal_uInt16       GetCol() const          { return nCol; }
 388     bool             HasTop10() const        { return ::get_flag( nFlags, EXC_AFFLAG_TOP10 ); }
 389
 390     bool                    HasCondition() const;
 391     bool                    AddEntry( const ScQueryEntry& rEntry );
 392     void                    AddMultiValueEntry( const ScQueryEntry& rEntry );
 393     void                    SetButtonHidden(bool bValue) { bIsButtonHidden = bValue; }
 394     void AddColorEntry( const ScQueryEntry& rEntry );
 395
 396     virtual void            SaveXml( XclExpXmlStream& rStrm ) override;
 397 };
 398
 399 class ExcAutoFilterRecs : public XclExpRecordBase, protected XclExpRoot
 400 {
 401 public:
 402     /** @param  pDefinedData
 403                 If nullptr, obtain anonymous ScDBData from sheet nTab.
 404                 Else, use defined database range; used with XclExpTables.
 405      */
 406     explicit            ExcAutoFilterRecs( const XclExpRoot& rRoot, SCTAB nTab, const ScDBData* pDefinedData );
 407     virtual             ~ExcAutoFilterRecs() override;
 408
 409     void                AddObjRecs();
 410
 411     virtual void        Save( XclExpStream& rStrm ) override;
 412     virtual void        SaveXml( XclExpXmlStream& rStrm ) override;
 413
 414     bool                HasFilterMode() const;
 415
 416 private:
 417     XclExpAutofilter*   GetByCol( SCCOL nCol ); // always 0-based
 418     bool                IsFiltered( SCCOL nCol );
 419
 420 private:
 421     typedef XclExpRecordList< XclExpAutofilter >    XclExpAutofilterList;
 422     typedef XclExpAutofilterList::RecordRefType     XclExpAutofilterRef;
 423
 424     XclExpAutofilterList maFilterList;
 425     rtl::Reference<XclExpFiltermode> m_pFilterMode;
 426     rtl::Reference<XclExpAutofilterinfo> m_pFilterInfo;
 427     ScRange                 maRef;
 428     bool mbAutoFilter;
 429
 430     ScRange maSortRef; // sort area without headers
 431     std::vector< std::tuple<ScRange, OUString, bool> > maSortCustomList; // sorted column with list of sorted items
 432 };
 433
 434 /** Sheet filter manager. Contains auto filters or advanced filters from all sheets. */
 435 class XclExpFilterManager : protected XclExpRoot
 436 {
 437 public:
 438     explicit            XclExpFilterManager( const XclExpRoot& rRoot );
 439
 440     /** Creates the filter records for the specified sheet.
 441         @descr  Creates and inserts related built-in NAME records. Therefore this
 442             function is called from the name buffer itself. */
 443     void                InitTabFilter( SCTAB nScTab );
 444
 445     /** Returns a record object containing all filter records for the specified sheet. */
 446     XclExpRecordRef     CreateRecord( SCTAB nScTab );
 447
 448     /** Returns whether or not FilterMode is present */
 449     bool                HasFilterMode( SCTAB nScTab );
 450
 451 private:
 452     using               XclExpRoot::CreateRecord;
 453
 454     typedef rtl::Reference< ExcAutoFilterRecs >  XclExpTabFilterRef;
 455     typedef ::std::map< SCTAB, XclExpTabFilterRef > XclExpTabFilterMap;
 456
 457     XclExpTabFilterMap  maFilterMap;
 458 };
 459
 460 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */