xlchart.hxx

Go to the documentation of this file.

/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
 * This file is part of the LibreOffice project.
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   Licensed to the Apache Software Foundation (ASF) under one or more
 *   contributor license agreements. See the NOTICE file distributed
 *   with this work for additional information regarding copyright
 *   ownership. The ASF licenses this file to you under the Apache
 *   License, Version 2.0 (the "License"); you may not use this file
 *   except in compliance with the License. You may obtain a copy of
 *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
 */

#ifndef INCLUDED_SC_SOURCE_FILTER_INC_XLCHART_HXX
#define INCLUDED_SC_SOURCE_FILTER_INC_XLCHART_HXX

#include <tools/gen.hxx>
#include "fapihelper.hxx"
#include <map>
#include <memory>

namespace com::sun::star {
    namespace container { class XNameContainer; }
    namespace lang      { class XMultiServiceFactory; }
    namespace chart     { class XChartDocument; }
    namespace chart2    { class XChartDocument; }
    namespace drawing   { class XShape; }
}

class XclRoot;

// Property names =============================================================

// service names
#define SERVICE_DRAWING_BITMAPTABLE         "com.sun.star.drawing.BitmapTable"
#define SERVICE_DRAWING_DASHTABLE           "com.sun.star.drawing.DashTable"
#define SERVICE_DRAWING_GRADIENTTABLE       "com.sun.star.drawing.GradientTable"
#define SERVICE_DRAWING_HATCHTABLE          "com.sun.star.drawing.HatchTable"

#define SERVICE_CHART2_AXIS                 "com.sun.star.chart2.Axis"
#define SERVICE_CHART2_DATAPROVIDER         "com.sun.star.chart2.data.DataProvider"
#define SERVICE_CHART2_DATASERIES           "com.sun.star.chart2.DataSeries"
#define SERVICE_CHART2_DIAGRAM              "com.sun.star.chart2.Diagram"
#define SERVICE_CHART2_ERRORBAR             "com.sun.star.chart2.ErrorBar"
#define SERVICE_CHART2_LEGEND               "com.sun.star.chart2.Legend"
#define SERVICE_CHART2_TITLE                "com.sun.star.chart2.Title"

// property names
#define EXC_CHPROP_ADDITIONALSHAPES         "AdditionalShapes"
#define EXC_CHPROP_ANCHORPOSITION           "AnchorPosition"
#define EXC_CHPROP_ARRANGEORDER             "ArrangeOrder"
#define EXC_CHPROP_ATTAXISINDEX             "AttachedAxisIndex"
#define EXC_CHPROP_ATTRIBDATAPOINTS         "AttributedDataPoints"
#define EXC_CHPROP_BLACKDAY                 "BlackDay"
#define EXC_CHPROP_COLOR                    "Color"
#define EXC_CHPROP_CONNECTBARS              "ConnectBars"
#define EXC_CHPROP_CROSSOVERPOSITION        "CrossoverPosition"
#define EXC_CHPROP_CROSSOVERVALUE           "CrossoverValue"
#define EXC_CHPROP_CURVESTYLE               "CurveStyle"
#define EXC_CHPROP_CURVENAME                "CurveName"
#define EXC_CHPROP_D3DSCENEAMBIENTCOLOR     "D3DSceneAmbientColor"
#define EXC_CHPROP_D3DSCENELIGHTON1         "D3DSceneLightOn1"
#define EXC_CHPROP_D3DSCENELIGHTCOLOR2      "D3DSceneLightColor2"
#define EXC_CHPROP_D3DSCENELIGHTDIR2        "D3DSceneLightDirection2"
#define EXC_CHPROP_D3DSCENELIGHTON2         "D3DSceneLightOn2"
#define EXC_CHPROP_D3DSCENEPERSPECTIVE      "D3DScenePerspective"
#define EXC_CHPROP_D3DSCENESHADEMODE        "D3DSceneShadeMode"
#define EXC_CHPROP_DISPLAYLABELS            "DisplayLabels"
#define EXC_CHPROP_ERRORBARSTYLE            "ErrorBarStyle"
#define EXC_CHPROP_ERRORBARX                "ErrorBarX"
#define EXC_CHPROP_ERRORBARY                "ErrorBarY"
#define EXC_CHPROP_EXPANSION                "Expansion"
#define EXC_CHPROP_EXPTIMEINCREMENT         "ExplicitTimeIncrement"
#define EXC_CHPROP_EXTRAPOLATE_FORWARD      "ExtrapolateForward"
#define EXC_CHPROP_EXTRAPOLATE_BACKWARD     "ExtrapolateBackward"
#define EXC_CHPROP_FORCE_INTERCEPT          "ForceIntercept"
#define EXC_CHPROP_GAPWIDTHSEQ              "GapwidthSequence"
#define EXC_CHPROP_GEOMETRY3D               "Geometry3D"
#define EXC_CHPROP_INCLUDEHIDDENCELLS       "IncludeHiddenCells"
#define EXC_CHPROP_INTERCEPT_VALUE          "InterceptValue"
#define EXC_CHPROP_JAPANESE                 "Japanese"
#define EXC_CHPROP_LABEL                    "Label"
#define EXC_CHPROP_LABELPLACEMENT           "LabelPlacement"
#define EXC_CHPROP_LABELPOSITION            "LabelPosition"
#define EXC_CHPROP_LABELSEPARATOR           "LabelSeparator"
#define EXC_CHPROP_SHOWLEGENDENTRY          "ShowLegendEntry"
#define EXC_CHPROP_MAJORTICKS               "MajorTickmarks"
#define EXC_CHPROP_MARKPOSITION             "MarkPosition"
#define EXC_CHPROP_MINORTICKS               "MinorTickmarks"
#define EXC_CHPROP_MISSINGVALUETREATMENT    "MissingValueTreatment"
#define EXC_CHPROP_MOVING_AVERAGE_PERIOD    "MovingAveragePeriod"
#define EXC_CHPROP_NEGATIVEERROR            "NegativeError"
#define EXC_CHPROP_NUMBERFORMAT             "NumberFormat"
#define EXC_CHPROP_NUMBERFORMAT_LINKSRC     "LinkNumberFormatToSource"
#define EXC_CHPROP_OFFSET                   "Offset"
#define EXC_CHPROP_OVERLAPSEQ               "OverlapSequence"
#define EXC_CHPROP_PERCENTAGENUMFMT         "PercentageNumberFormat"
#define EXC_CHPROP_PERCENTDIAGONAL          "PercentDiagonal"
#define EXC_CHPROP_PERSPECTIVE              "Perspective"
#define EXC_CHPROP_POSITIVEERROR            "PositiveError"
#define EXC_CHPROP_POLYNOMIAL_DEGREE        "PolynomialDegree"
#define EXC_CHPROP_RELATIVEPOSITION         "RelativePosition"
#define EXC_CHPROP_RELATIVESIZE             "RelativeSize"
#define EXC_CHPROP_RIGHTANGLEDAXES          "RightAngledAxes"
#define EXC_CHPROP_ROLE                     "Role"
#define EXC_CHPROP_ROTATIONHORIZONTAL       "RotationHorizontal"
#define EXC_CHPROP_ROTATIONVERTICAL         "RotationVertical"
#define EXC_CHPROP_3DRELATIVEHEIGHT         "3DRelativeHeight"
#define EXC_CHPROP_SHOW                     "Show"
#define EXC_CHPROP_SHOWCORRELATION          "ShowCorrelationCoefficient"
#define EXC_CHPROP_SHOWEQUATION             "ShowEquation"
#define EXC_CHPROP_SHOWFIRST                "ShowFirst"
#define EXC_CHPROP_SHOWHIGHLOW              "ShowHighLow"
#define EXC_CHPROP_SHOWNEGATIVEERROR        "ShowNegativeError"
#define EXC_CHPROP_SHOWPOSITIVEERROR        "ShowPositiveError"
#define EXC_CHPROP_STACKCHARACTERS          "StackCharacters"
#define EXC_CHPROP_STACKINGDIR              "StackingDirection"
#define EXC_CHPROP_STARTINGANGLE            "StartingAngle"
#define EXC_CHPROP_SWAPXANDYAXIS            "SwapXAndYAxis"
#define EXC_CHPROP_SYMBOL                   "Symbol"
#define EXC_CHPROP_TEXTBREAK                "TextBreak"
#define EXC_CHPROP_TEXTOVERLAP              "TextOverlap"
#define EXC_CHPROP_TEXTROTATION             "TextRotation"
#define EXC_CHPROP_USERINGS                 "UseRings"
#define EXC_CHPROP_VARYCOLORSBY             "VaryColorsByPoint"
#define EXC_CHPROP_WEIGHT                   "Weight"
#define EXC_CHPROP_WHITEDAY                 "WhiteDay"

// data series roles
#define EXC_CHPROP_ROLE_CATEG               u"categories"
#define EXC_CHPROP_ROLE_ERRORBARS_NEGX      u"error-bars-x-negative"
#define EXC_CHPROP_ROLE_ERRORBARS_NEGY      u"error-bars-y-negative"
#define EXC_CHPROP_ROLE_ERRORBARS_POSX      u"error-bars-x-positive"
#define EXC_CHPROP_ROLE_ERRORBARS_POSY      u"error-bars-y-positive"
#define EXC_CHPROP_ROLE_LABEL               u"label"
#define EXC_CHPROP_ROLE_XVALUES             u"values-x"
#define EXC_CHPROP_ROLE_YVALUES             u"values-y"
#define EXC_CHPROP_ROLE_OPENVALUES          u"values-first"
#define EXC_CHPROP_ROLE_CLOSEVALUES         u"values-last"
#define EXC_CHPROP_ROLE_LOWVALUES           u"values-min"
#define EXC_CHPROP_ROLE_HIGHVALUES          u"values-max"
#define EXC_CHPROP_ROLE_SIZEVALUES          u"values-size"

// Constants and Enumerations =================================================

const std::size_t EXC_CHART_PROGRESS_SIZE       = 10;
const sal_uInt16 EXC_CHART_AUTOROTATION         = 0xFFFF;   

const sal_Int32 EXC_CHART_AXIS_NONE             = -1;       
const sal_Int32 EXC_CHART_AXIS_X                = 0;        
const sal_Int32 EXC_CHART_AXIS_Y                = 1;        
const sal_Int32 EXC_CHART_AXIS_Z                = 2;        
const sal_Int32 EXC_CHART_AXESSET_NONE          = -1;       
const sal_Int32 EXC_CHART_AXESSET_PRIMARY       = 0;        
const sal_Int32 EXC_CHART_AXESSET_SECONDARY     = 1;        

const sal_Int32 EXC_CHART_TOTALUNITS            = 4000;     
const sal_Int32 EXC_CHART_PLOTAREAUNITS         = 1000;     

// (0x0850) CHFRINFO ----------------------------------------------------------

const sal_uInt16 EXC_ID_CHFRINFO                = 0x0850;

const sal_uInt8 EXC_CHFRINFO_EXCEL2000          = 9;
const sal_uInt8 EXC_CHFRINFO_EXCELXP2003        = 10;
const sal_uInt8 EXC_CHFRINFO_EXCEL2007          = 11;

// (0x0852, 0x0853) CHFRBLOCKBEGIN, CHFRBLOCKEND ------------------------------

const sal_uInt16 EXC_ID_CHFRBLOCKBEGIN          = 0x0852;
const sal_uInt16 EXC_ID_CHFRBLOCKEND            = 0x0853;

const sal_uInt16 EXC_CHFRBLOCK_TYPE_AXESSET     = 0;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_TEXT        = 2;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_AXIS        = 4;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_TYPEGROUP   = 5;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_DATATABLE   = 6;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_FRAME       = 7;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_LEGEND      = 9;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_LEGENDEX    = 10;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_SERIES      = 12;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_CHART       = 13;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_DATAFORMAT  = 14;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_DROPBAR     = 15;
const sal_uInt16 EXC_CHFRBLOCK_TYPE_UNKNOWN     = 0xFFFF;   

const sal_uInt16 EXC_CHFRBLOCK_TEXT_TITLE       = 0;
const sal_uInt16 EXC_CHFRBLOCK_TEXT_DEFTEXT     = 2;
const sal_uInt16 EXC_CHFRBLOCK_TEXT_AXISTITLE   = 4;
const sal_uInt16 EXC_CHFRBLOCK_TEXT_DATALABEL   = 5;

const sal_uInt16 EXC_CHFRBLOCK_FRAME_STANDARD   = 0;
const sal_uInt16 EXC_CHFRBLOCK_FRAME_PLOTFRAME  = 1;
const sal_uInt16 EXC_CHFRBLOCK_FRAME_BACKGROUND = 2;

// (0x086B) CHFRLABELPROPS ----------------------------------------------------

const sal_uInt16 EXC_ID_CHFRLABELPROPS          = 0x086B;

const sal_uInt16 EXC_CHFRLABELPROPS_SHOWSERIES  = 0x0001;
const sal_uInt16 EXC_CHFRLABELPROPS_SHOWCATEG   = 0x0002;
const sal_uInt16 EXC_CHFRLABELPROPS_SHOWVALUE   = 0x0004;
const sal_uInt16 EXC_CHFRLABELPROPS_SHOWPERCENT = 0x0008;
const sal_uInt16 EXC_CHFRLABELPROPS_SHOWBUBBLE  = 0x0010;

// (0x1001) CHUNITS -----------------------------------------------------------

const sal_uInt16 EXC_ID_CHUNITS                 = 0x1001;

const sal_uInt16 EXC_CHUNITS_TWIPS              = 0;
const sal_uInt16 EXC_CHUNITS_PIXELS             = 1;

// (0x1002) CHCHART -----------------------------------------------------------

const sal_uInt16 EXC_ID_CHCHART                 = 0x1002;

// (0x1003) CHSERIES ----------------------------------------------------------

const sal_uInt16 EXC_ID_CHSERIES                = 0x1003;

const sal_uInt16 EXC_CHSERIES_DATE              = 0;
const sal_uInt16 EXC_CHSERIES_NUMERIC           = 1;
const sal_uInt16 EXC_CHSERIES_SEQUENCE          = 2;
const sal_uInt16 EXC_CHSERIES_TEXT              = 3;

const sal_uInt16 EXC_CHSERIES_MAXSERIES         = 255;      
const sal_uInt16 EXC_CHSERIES_INVALID           = 0xFFFF;   

// (0x1006) CHDATAFORMAT ------------------------------------------------------

const sal_uInt16 EXC_ID_CHDATAFORMAT            = 0x1006;

const sal_uInt16 EXC_CHDATAFORMAT_MAXPOINTCOUNT = 32000;    
const sal_uInt16 EXC_CHDATAFORMAT_DEFAULT       = 0xFFFD;   
const sal_uInt16 EXC_CHDATAFORMAT_UNKNOWN       = 0xFFFE;   
const sal_uInt16 EXC_CHDATAFORMAT_ALLPOINTS     = 0xFFFF;   

const sal_uInt16 EXC_CHDATAFORMAT_OLDCOLORS     = 0x0001;

// (0x1007) CHLINEFORMAT ------------------------------------------------------

const sal_uInt16 EXC_ID_CHLINEFORMAT            = 0x1007;

const sal_uInt16 EXC_CHLINEFORMAT_SOLID         = 0;
const sal_uInt16 EXC_CHLINEFORMAT_DASH          = 1;
const sal_uInt16 EXC_CHLINEFORMAT_DOT           = 2;
const sal_uInt16 EXC_CHLINEFORMAT_DASHDOT       = 3;
const sal_uInt16 EXC_CHLINEFORMAT_DASHDOTDOT    = 4;
const sal_uInt16 EXC_CHLINEFORMAT_NONE          = 5;
const sal_uInt16 EXC_CHLINEFORMAT_DARKTRANS     = 6;
const sal_uInt16 EXC_CHLINEFORMAT_MEDTRANS      = 7;
const sal_uInt16 EXC_CHLINEFORMAT_LIGHTTRANS    = 8;

const sal_Int16 EXC_CHLINEFORMAT_HAIR           = -1;
const sal_Int16 EXC_CHLINEFORMAT_SINGLE         = 0;
const sal_Int16 EXC_CHLINEFORMAT_DOUBLE         = 1;
const sal_Int16 EXC_CHLINEFORMAT_TRIPLE         = 2;

const sal_uInt16 EXC_CHLINEFORMAT_AUTO          = 0x0001;
const sal_uInt16 EXC_CHLINEFORMAT_SHOWAXIS      = 0x0004;

// (0x1009) CHMARKERFORMAT ----------------------------------------------------

const sal_uInt16 EXC_ID_CHMARKERFORMAT          = 0x1009;

const sal_uInt16 EXC_CHMARKERFORMAT_NOSYMBOL    = 0;
const sal_uInt16 EXC_CHMARKERFORMAT_SQUARE      = 1;
const sal_uInt16 EXC_CHMARKERFORMAT_DIAMOND     = 2;
const sal_uInt16 EXC_CHMARKERFORMAT_TRIANGLE    = 3;
const sal_uInt16 EXC_CHMARKERFORMAT_CROSS       = 4;
const sal_uInt16 EXC_CHMARKERFORMAT_STAR        = 5;
const sal_uInt16 EXC_CHMARKERFORMAT_DOWJ        = 6;
const sal_uInt16 EXC_CHMARKERFORMAT_STDDEV      = 7;
const sal_uInt16 EXC_CHMARKERFORMAT_CIRCLE      = 8;
const sal_uInt16 EXC_CHMARKERFORMAT_PLUS        = 9;

const sal_uInt32 EXC_CHMARKERFORMAT_HAIRSIZE    = 60;       
const sal_uInt32 EXC_CHMARKERFORMAT_SINGLESIZE  = 100;      
const sal_uInt32 EXC_CHMARKERFORMAT_DOUBLESIZE  = 140;      
const sal_uInt32 EXC_CHMARKERFORMAT_TRIPLESIZE  = 180;      

const sal_uInt16 EXC_CHMARKERFORMAT_AUTO        = 0x0001;
const sal_uInt16 EXC_CHMARKERFORMAT_NOFILL      = 0x0010;
const sal_uInt16 EXC_CHMARKERFORMAT_NOLINE      = 0x0020;

// (0x100A) CHAREAFORMAT ------------------------------------------------------

const sal_uInt16 EXC_ID_CHAREAFORMAT            = 0x100A;

const sal_uInt16 EXC_CHAREAFORMAT_AUTO          = 0x0001;
const sal_uInt16 EXC_CHAREAFORMAT_INVERTNEG     = 0x0002;

// (0x100B) CHPIEFORMAT -------------------------------------------------------

const sal_uInt16 EXC_ID_CHPIEFORMAT             = 0x100B;

// (0x100C) CHATTACHEDLABEL ---------------------------------------------------

const sal_uInt16 EXC_ID_CHATTACHEDLABEL         = 0x100C;

const sal_uInt16 EXC_CHATTLABEL_SHOWVALUE       = 0x0001;
const sal_uInt16 EXC_CHATTLABEL_SHOWPERCENT     = 0x0002;
const sal_uInt16 EXC_CHATTLABEL_SHOWCATEGPERC   = 0x0004;
const sal_uInt16 EXC_CHATTLABEL_SMOOTHED        = 0x0008;   
const sal_uInt16 EXC_CHATTLABEL_SHOWCATEG       = 0x0010;
const sal_uInt16 EXC_CHATTLABEL_SHOWBUBBLE      = 0x0020;

// (0x100D) CHSTRING ----------------------------------------------------------

const sal_uInt16 EXC_ID_CHSTRING                = 0x100D;

// (0x1014) CHTYPEGROUP -------------------------------------------------------

const sal_uInt16 EXC_ID_CHTYPEGROUP             = 0x1014;

const sal_uInt16 EXC_CHTYPEGROUP_VARIEDCOLORS   = 0x0001;   

// (0x1015) CHLEGEND ----------------------------------------------------------

const sal_uInt16 EXC_ID_CHLEGEND                = 0x1015;

const sal_uInt8 EXC_CHLEGEND_BOTTOM             = 0;
const sal_uInt8 EXC_CHLEGEND_CORNER             = 1;
const sal_uInt8 EXC_CHLEGEND_TOP                = 2;
const sal_uInt8 EXC_CHLEGEND_RIGHT              = 3;
const sal_uInt8 EXC_CHLEGEND_LEFT               = 4;
const sal_uInt8 EXC_CHLEGEND_NOTDOCKED          = 7;

const sal_uInt8 EXC_CHLEGEND_CLOSE              = 0;
const sal_uInt8 EXC_CHLEGEND_MEDIUM             = 1;
const sal_uInt8 EXC_CHLEGEND_OPEN               = 2;

const sal_uInt16 EXC_CHLEGEND_DOCKED            = 0x0001;
const sal_uInt16 EXC_CHLEGEND_AUTOSERIES        = 0x0002;
const sal_uInt16 EXC_CHLEGEND_AUTOPOSX          = 0x0004;
const sal_uInt16 EXC_CHLEGEND_AUTOPOSY          = 0x0008;
const sal_uInt16 EXC_CHLEGEND_STACKED           = 0x0010;
const sal_uInt16 EXC_CHLEGEND_DATATABLE         = 0x0020;

// (0x1017) CHBAR, CHCOLUMN ---------------------------------------------------

const sal_uInt16 EXC_ID_CHBAR                   = 0x1017;

const sal_uInt16 EXC_CHBAR_HORIZONTAL           = 0x0001;
const sal_uInt16 EXC_CHBAR_STACKED              = 0x0002;
const sal_uInt16 EXC_CHBAR_PERCENT              = 0x0004;
const sal_uInt16 EXC_CHBAR_SHADOW               = 0x0008;

// (0x1018, 0x101A) CHLINE, CHAREA --------------------------------------------

const sal_uInt16 EXC_ID_CHLINE                  = 0x1018;
const sal_uInt16 EXC_ID_CHAREA                  = 0x101A;

const sal_uInt16 EXC_CHLINE_STACKED             = 0x0001;
const sal_uInt16 EXC_CHLINE_PERCENT             = 0x0002;
const sal_uInt16 EXC_CHLINE_SHADOW              = 0x0004;

// (0x1019) CHPIE -------------------------------------------------------------

const sal_uInt16 EXC_ID_CHPIE                   = 0x1019;

const sal_uInt16 EXC_CHPIE_SHADOW               = 0x0001;
const sal_uInt16 EXC_CHPIE_LINES                = 0x0002;

// (0x101B) CHSCATTER ---------------------------------------------------------

const sal_uInt16 EXC_ID_CHSCATTER               = 0x101B;

const sal_uInt16 EXC_CHSCATTER_AREA             = 1;        
const sal_uInt16 EXC_CHSCATTER_WIDTH            = 2;        

const sal_uInt16 EXC_CHSCATTER_BUBBLES          = 0x0001;
const sal_uInt16 EXC_CHSCATTER_SHOWNEG          = 0x0002;
const sal_uInt16 EXC_CHSCATTER_SHADOW           = 0x0004;

// (0x001C) CHCHARTLINE -------------------------------------------------------

const sal_uInt16 EXC_ID_CHCHARTLINE             = 0x101C;

const sal_uInt16 EXC_CHCHARTLINE_DROP           = 0;        
const sal_uInt16 EXC_CHCHARTLINE_HILO           = 1;        
const sal_uInt16 EXC_CHCHARTLINE_CONNECT        = 2;        

// (0x101D) CHAXIS ------------------------------------------------------------

const sal_uInt16 EXC_ID_CHAXIS                  = 0x101D;

const sal_uInt16 EXC_CHAXIS_X                   = 0;
const sal_uInt16 EXC_CHAXIS_Y                   = 1;
const sal_uInt16 EXC_CHAXIS_Z                   = 2;
const sal_uInt16 EXC_CHAXIS_NONE                = 0xFFFF;   

// (0x101E) CHTICK ------------------------------------------------------------

const sal_uInt16 EXC_ID_CHTICK                  = 0x101E;

const sal_uInt8 EXC_CHTICK_INSIDE               = 0x01;
const sal_uInt8 EXC_CHTICK_OUTSIDE              = 0x02;

const sal_uInt8 EXC_CHTICK_NOLABEL              = 0;
const sal_uInt8 EXC_CHTICK_LOW                  = 1;        
const sal_uInt8 EXC_CHTICK_HIGH                 = 2;        
const sal_uInt8 EXC_CHTICK_NEXT                 = 3;        

const sal_uInt8 EXC_CHTICK_TRANSPARENT          = 1;
const sal_uInt8 EXC_CHTICK_OPAQUE               = 2;

const sal_uInt16 EXC_CHTICK_AUTOCOLOR           = 0x0001;
const sal_uInt16 EXC_CHTICK_AUTOFILL            = 0x0002;
const sal_uInt16 EXC_CHTICK_AUTOROT             = 0x0020;

// (0x101F) CHVALUERANGE ------------------------------------------------------

const sal_uInt16 EXC_ID_CHVALUERANGE            = 0x101F;

const sal_uInt16 EXC_CHVALUERANGE_AUTOMIN       = 0x0001;
const sal_uInt16 EXC_CHVALUERANGE_AUTOMAX       = 0x0002;
const sal_uInt16 EXC_CHVALUERANGE_AUTOMAJOR     = 0x0004;
const sal_uInt16 EXC_CHVALUERANGE_AUTOMINOR     = 0x0008;
const sal_uInt16 EXC_CHVALUERANGE_AUTOCROSS     = 0x0010;
const sal_uInt16 EXC_CHVALUERANGE_LOGSCALE      = 0x0020;
const sal_uInt16 EXC_CHVALUERANGE_REVERSE       = 0x0040;   
const sal_uInt16 EXC_CHVALUERANGE_MAXCROSS      = 0x0080;   
const sal_uInt16 EXC_CHVALUERANGE_BIT8          = 0x0100;   

// (0x1020) CHLABELRANGE -----------------------------------------------------

const sal_uInt16 EXC_ID_CHLABELRANGE            = 0x1020;

const sal_uInt16 EXC_CHLABELRANGE_BETWEEN       = 0x0001;   
const sal_uInt16 EXC_CHLABELRANGE_MAXCROSS      = 0x0002;   
const sal_uInt16 EXC_CHLABELRANGE_REVERSE       = 0x0004;   

// (0x1021) CHAXISLINE --------------------------------------------------------

const sal_uInt16 EXC_ID_CHAXISLINE              = 0x1021;

const sal_uInt16 EXC_CHAXISLINE_AXISLINE        = 0;        
const sal_uInt16 EXC_CHAXISLINE_MAJORGRID       = 1;        
const sal_uInt16 EXC_CHAXISLINE_MINORGRID       = 2;        
const sal_uInt16 EXC_CHAXISLINE_WALLS           = 3;        

// (0x1024) CHDEFAULTTEXT -----------------------------------------------------

const sal_uInt16 EXC_ID_CHDEFAULTTEXT           = 0x1024;

const sal_uInt16 EXC_CHDEFTEXT_TEXTLABEL        = 0;        
const sal_uInt16 EXC_CHDEFTEXT_NUMLABEL         = 1;        
const sal_uInt16 EXC_CHDEFTEXT_GLOBAL           = 2;        
const sal_uInt16 EXC_CHDEFTEXT_AXESSET          = 3;        
const sal_uInt16 EXC_CHDEFTEXT_NONE             = 0xFFFF;   

// (0x1025) CHTEXT ------------------------------------------------------------

const sal_uInt16 EXC_ID_CHTEXT                  = 0x1025;

const sal_uInt8 EXC_CHTEXT_ALIGN_TOPLEFT        = 1;        
const sal_uInt8 EXC_CHTEXT_ALIGN_CENTER         = 2;
const sal_uInt8 EXC_CHTEXT_ALIGN_BOTTOMRIGHT    = 3;        
const sal_uInt8 EXC_CHTEXT_ALIGN_JUSTIFY        = 4;
const sal_uInt8 EXC_CHTEXT_ALIGN_DISTRIBUTE     = 5;

const sal_uInt16 EXC_CHTEXT_TRANSPARENT         = 1;
const sal_uInt16 EXC_CHTEXT_OPAQUE              = 2;

const sal_uInt16 EXC_CHTEXT_AUTOCOLOR           = 0x0001;   
const sal_uInt16 EXC_CHTEXT_SHOWSYMBOL          = 0x0002;   
const sal_uInt16 EXC_CHTEXT_SHOWVALUE           = 0x0004;   
const sal_uInt16 EXC_CHTEXT_VERTICAL            = 0x0008;
const sal_uInt16 EXC_CHTEXT_AUTOTEXT            = 0x0010;   
const sal_uInt16 EXC_CHTEXT_AUTOGEN             = 0x0020;   
const sal_uInt16 EXC_CHTEXT_DELETED             = 0x0040;   
const sal_uInt16 EXC_CHTEXT_AUTOFILL            = 0x0080;   
const sal_uInt16 EXC_CHTEXT_SHOWCATEGPERC       = 0x0800;   
const sal_uInt16 EXC_CHTEXT_SHOWPERCENT         = 0x1000;   
const sal_uInt16 EXC_CHTEXT_SHOWBUBBLE          = 0x2000;   
const sal_uInt16 EXC_CHTEXT_SHOWCATEG           = 0x4000;   

const sal_uInt16 EXC_CHTEXT_POS_DEFAULT         = 0;
const sal_uInt16 EXC_CHTEXT_POS_OUTSIDE         = 1;
const sal_uInt16 EXC_CHTEXT_POS_INSIDE          = 2;
const sal_uInt16 EXC_CHTEXT_POS_CENTER          = 3;
const sal_uInt16 EXC_CHTEXT_POS_AXIS            = 4;
const sal_uInt16 EXC_CHTEXT_POS_ABOVE           = 5;
const sal_uInt16 EXC_CHTEXT_POS_BELOW           = 6;
const sal_uInt16 EXC_CHTEXT_POS_LEFT            = 7;
const sal_uInt16 EXC_CHTEXT_POS_RIGHT           = 8;
const sal_uInt16 EXC_CHTEXT_POS_AUTO            = 9;
const sal_uInt16 EXC_CHTEXT_POS_MOVED           = 10;

// (0x1026) CHFONT ------------------------------------------------------------

const sal_uInt16 EXC_ID_CHFONT                  = 0x1026;

// (0x1027) CHOBJECTLINK ------------------------------------------------------

const sal_uInt16 EXC_ID_CHOBJECTLINK            = 0x1027;

// link targets
const sal_uInt16 EXC_CHOBJLINK_NONE             = 0;        
const sal_uInt16 EXC_CHOBJLINK_TITLE            = 1;        
const sal_uInt16 EXC_CHOBJLINK_YAXIS            = 2;        
const sal_uInt16 EXC_CHOBJLINK_XAXIS            = 3;        
const sal_uInt16 EXC_CHOBJLINK_DATA             = 4;        
const sal_uInt16 EXC_CHOBJLINK_ZAXIS            = 7;        
const sal_uInt16 EXC_CHOBJLINK_AXISUNIT         = 12;       

// (0x1032) CHFRAME -----------------------------------------------------------

const sal_uInt16 EXC_ID_CHFRAME                 = 0x1032;

const sal_uInt16 EXC_CHFRAME_STANDARD           = 0;
const sal_uInt16 EXC_CHFRAME_SHADOW             = 4;

const sal_uInt16 EXC_CHFRAME_AUTOSIZE           = 0x0001;
const sal_uInt16 EXC_CHFRAME_AUTOPOS            = 0x0002;

// (0x1033, 0x1034) CHBEGIN, CHEND --------------------------------------------

const sal_uInt16 EXC_ID_CHBEGIN                 = 0x1033;
const sal_uInt16 EXC_ID_CHEND                   = 0x1034;

// (0x1035) CHPLOTFRAME -------------------------------------------------------

const sal_uInt16 EXC_ID_CHPLOTFRAME             = 0x1035;

// (0x103A) CHCHART3D ---------------------------------------------------------

const sal_uInt16 EXC_ID_CHCHART3D               = 0x103A;

const sal_uInt16 EXC_CHCHART3D_REAL3D           = 0x0001;   
const sal_uInt16 EXC_CHCHART3D_CLUSTER          = 0x0002;   
const sal_uInt16 EXC_CHCHART3D_AUTOHEIGHT       = 0x0004;   
const sal_uInt16 EXC_CHCHART3D_HASWALLS         = 0x0010;   
const sal_uInt16 EXC_CHCHART3D_2DWALLS          = 0x0020;   

// (0x103C) CHPICFORMAT -------------------------------------------------------

const sal_uInt16 EXC_ID_CHPICFORMAT             = 0x103C;

const sal_uInt16 EXC_CHPICFORMAT_NONE           = 0;        
const sal_uInt16 EXC_CHPICFORMAT_STRETCH        = 1;        
const sal_uInt16 EXC_CHPICFORMAT_STACK          = 2;        
const sal_uInt16 EXC_CHPICFORMAT_SCALE          = 3;        

const sal_uInt16 EXC_CHPICFORMAT_TOPBOTTOM      = 0x0200;
const sal_uInt16 EXC_CHPICFORMAT_FRONTBACK      = 0x0400;
const sal_uInt16 EXC_CHPICFORMAT_LEFTRIGHT      = 0x0800;

// (0x103D) CHDROPBAR ---------------------------------------------------------

const sal_uInt16 EXC_ID_CHDROPBAR               = 0x103D;

const sal_uInt16 EXC_CHDROPBAR_UP               = 0;
const sal_uInt16 EXC_CHDROPBAR_DOWN             = 1;
const sal_uInt16 EXC_CHDROPBAR_NONE             = 0xFFFF;

// (0x103E, 0x1040) CHRADARLINE, CHRADARAREA ----------------------------------

const sal_uInt16 EXC_ID_CHRADARLINE             = 0x103E;
const sal_uInt16 EXC_ID_CHRADARAREA             = 0x1040;

const sal_uInt16 EXC_CHRADAR_AXISLABELS         = 0x0001;
const sal_uInt16 EXC_CHRADAR_SHADOW             = 0x0002;

// (0x103F) CHSURFACE ---------------------------------------------------------

const sal_uInt16 EXC_ID_CHSURFACE               = 0x103F;

const sal_uInt16 EXC_CHSURFACE_FILLED           = 0x0001;
const sal_uInt16 EXC_CHSURFACE_SHADING          = 0x0002;

// (0x1041) CHAXESSET ---------------------------------------------------------

const sal_uInt16 EXC_ID_CHAXESSET               = 0x1041;

const sal_uInt16 EXC_CHAXESSET_PRIMARY          = 0;
const sal_uInt16 EXC_CHAXESSET_SECONDARY        = 1;
const sal_uInt16 EXC_CHAXESSET_NONE             = 0xFFFF;   

// (0x1043) LEGENDEXCEPTION

const sal_uInt16 EXC_ID_CHLEGENDEXCEPTION       = 0x1043;

const sal_uInt16 EXC_CHLEGENDEXCEPTION_DELETED  = 0x0001;
const sal_uInt16 EXC_CHLEGENDEXCEPTION_LABEL    = 0x0002;

// (0x1044) CHPROPERTIES ------------------------------------------------------

const sal_uInt16 EXC_ID_CHPROPERTIES            = 0x1044;

const sal_uInt16 EXC_CHPROPS_MANSERIES          = 0x0001;   
const sal_uInt16 EXC_CHPROPS_SHOWVISIBLEONLY    = 0x0002;   
const sal_uInt16 EXC_CHPROPS_NORESIZE           = 0x0004;   
const sal_uInt16 EXC_CHPROPS_MANPLOTAREA        = 0x0008;   
const sal_uInt16 EXC_CHPROPS_USEMANPLOTAREA     = 0x0010;   

const sal_uInt8 EXC_CHPROPS_EMPTY_SKIP          = 0;        
const sal_uInt8 EXC_CHPROPS_EMPTY_ZERO          = 1;        
const sal_uInt8 EXC_CHPROPS_EMPTY_INTERPOLATE   = 2;        

// (0x1045) CHSERGROUP --------------------------------------------------------

const sal_uInt16 EXC_ID_CHSERGROUP              = 0x1045;

const sal_uInt16 EXC_CHSERGROUP_NONE            = 0xFFFF;   

// (0x1048, 0x0858) CHPIVOTREF ------------------------------------------------

const sal_uInt16 EXC_ID5_CHPIVOTREF             = 0x1048;
const sal_uInt16 EXC_ID8_CHPIVOTREF             = 0x0858;

// (0x104A) CHSERPARENT -------------------------------------------------------

const sal_uInt16 EXC_ID_CHSERPARENT             = 0x104A;

// (0x104B) CHSERTRENDLINE ----------------------------------------------------

const sal_uInt16 EXC_ID_CHSERTRENDLINE          = 0x104B;

const sal_uInt8 EXC_CHSERTREND_POLYNOMIAL       = 0;    
const sal_uInt8 EXC_CHSERTREND_EXPONENTIAL      = 1;
const sal_uInt8 EXC_CHSERTREND_LOGARITHMIC      = 2;
const sal_uInt8 EXC_CHSERTREND_POWER            = 3;
const sal_uInt8 EXC_CHSERTREND_MOVING_AVG       = 4;

// (0x104E) CHFORMAT ----------------------------------------------------------

const sal_uInt16 EXC_ID_CHFORMAT                = 0x104E;

// (0x104F) CHFRAMEPOS --------------------------------------------------------

const sal_uInt16 EXC_ID_CHFRAMEPOS              = 0x104F;

const sal_uInt16 EXC_CHFRAMEPOS_POINTS          = 0;
const sal_uInt16 EXC_CHFRAMEPOS_ABSSIZE_POINTS  = 1;
const sal_uInt16 EXC_CHFRAMEPOS_PARENT          = 2;
const sal_uInt16 EXC_CHFRAMEPOS_DEFOFFSET_PLOT  = 3;
const sal_uInt16 EXC_CHFRAMEPOS_CHARTSIZE       = 5;

// (0x1050) CHFORMATRUNS ------------------------------------------------------

const sal_uInt16 EXC_ID_CHFORMATRUNS            = 0x1050;

// (0x1051) CHSOURCELINK ------------------------------------------------------

const sal_uInt16 EXC_ID_CHSOURCELINK            = 0x1051;

const sal_uInt8 EXC_CHSRCLINK_TITLE             = 0;
const sal_uInt8 EXC_CHSRCLINK_VALUES            = 1;
const sal_uInt8 EXC_CHSRCLINK_CATEGORY          = 2;
const sal_uInt8 EXC_CHSRCLINK_BUBBLES           = 3;

const sal_uInt8 EXC_CHSRCLINK_DEFAULT           = 0;
const sal_uInt8 EXC_CHSRCLINK_DIRECTLY          = 1;
const sal_uInt8 EXC_CHSRCLINK_WORKSHEET         = 2;

const sal_uInt16 EXC_CHSRCLINK_NUMFMT           = 0x0001;

// (0x105B) CHSERERRORBAR -----------------------------------------------------

const sal_uInt16 EXC_ID_CHSERERRORBAR           = 0x105B;

const sal_uInt8 EXC_CHSERERR_NONE               = 0;    
const sal_uInt8 EXC_CHSERERR_XPLUS              = 1;
const sal_uInt8 EXC_CHSERERR_XMINUS             = 2;
const sal_uInt8 EXC_CHSERERR_YPLUS              = 3;
const sal_uInt8 EXC_CHSERERR_YMINUS             = 4;

const sal_uInt8 EXC_CHSERERR_PERCENT            = 1;
const sal_uInt8 EXC_CHSERERR_FIXED              = 2;
const sal_uInt8 EXC_CHSERERR_STDDEV             = 3;
const sal_uInt8 EXC_CHSERERR_CUSTOM             = 4;
const sal_uInt8 EXC_CHSERERR_STDERR             = 5;

const sal_uInt8 EXC_CHSERERR_END_BLANK          = 0;    
const sal_uInt8 EXC_CHSERERR_END_TSHAPE         = 1;    

// (0x105D) CHSERIESFORMAT ----------------------------------------------------

const sal_uInt16 EXC_ID_CHSERIESFORMAT          = 0x105D;

const sal_uInt16 EXC_CHSERIESFORMAT_SMOOTHED    = 0x0001;
const sal_uInt16 EXC_CHSERIESFORMAT_BUBBLE3D    = 0x0002;
const sal_uInt16 EXC_CHSERIESFORMAT_SHADOW      = 0x0004;

// (0x105F) CH3DDATAFORMAT ----------------------------------------------------

const sal_uInt16 EXC_ID_CH3DDATAFORMAT          = 0x105F;

const sal_uInt8 EXC_CH3DDATAFORMAT_RECT         = 0;        
const sal_uInt8 EXC_CH3DDATAFORMAT_CIRC         = 1;        

const sal_uInt8 EXC_CH3DDATAFORMAT_STRAIGHT     = 0;        
const sal_uInt8 EXC_CH3DDATAFORMAT_SHARP        = 1;        
const sal_uInt8 EXC_CH3DDATAFORMAT_TRUNC        = 2;        

// (0x1061) CHPIEEXT ----------------------------------------------------------

const sal_uInt16 EXC_ID_CHPIEEXT                = 0x1061;

// (0x1062) CHDATERANGE -------------------------------------------------------

const sal_uInt16 EXC_ID_CHDATERANGE             = 0x1062;

const sal_uInt16 EXC_CHDATERANGE_AUTOMIN        = 0x0001;
const sal_uInt16 EXC_CHDATERANGE_AUTOMAX        = 0x0002;
const sal_uInt16 EXC_CHDATERANGE_AUTOMAJOR      = 0x0004;
const sal_uInt16 EXC_CHDATERANGE_AUTOMINOR      = 0x0008;
const sal_uInt16 EXC_CHDATERANGE_DATEAXIS       = 0x0010;
const sal_uInt16 EXC_CHDATERANGE_AUTOBASE       = 0x0020;
const sal_uInt16 EXC_CHDATERANGE_AUTOCROSS      = 0x0040;   
const sal_uInt16 EXC_CHDATERANGE_AUTODATE       = 0x0080;   

const sal_uInt16 EXC_CHDATERANGE_DAYS           = 0;
const sal_uInt16 EXC_CHDATERANGE_MONTHS         = 1;
const sal_uInt16 EXC_CHDATERANGE_YEARS          = 2;

// (0x1066) CHESCHERFORMAT ----------------------------------------------------

const sal_uInt16 EXC_ID_CHESCHERFORMAT          = 0x1066;

// Other record IDs -----------------------------------------------------------

const sal_uInt16 EXC_ID_CHWRAPPEDRECORD         = 0x0851;
const sal_uInt16 EXC_ID_CHUNITPROPERTIES        = 0x0857;
const sal_uInt16 EXC_ID_CHUSEDAXESSETS          = 0x1046;
const sal_uInt16 EXC_ID_CHLABELRANGE2           = 0x1062;
const sal_uInt16 EXC_ID_CHPLOTGROWTH            = 0x1064;
const sal_uInt16 EXC_ID_CHSERINDEX              = 0x1065;
const sal_uInt16 EXC_ID_CHUNKNOWN               = 0xFFFF;

// Structs and classes

// Common =====================================================================

struct XclChRectangle
{
    sal_Int32           mnX;                
    sal_Int32           mnY;                
    sal_Int32           mnWidth;            
    sal_Int32           mnHeight;           

    explicit            XclChRectangle();
};

struct XclChDataPointPos
{
    sal_uInt16          mnSeriesIdx;        
    sal_uInt16          mnPointIdx;         

    explicit            XclChDataPointPos(
                            sal_uInt16 nSeriesIdx = EXC_CHSERIES_INVALID,
                            sal_uInt16 nPointIdx = EXC_CHDATAFORMAT_ALLPOINTS );
};

bool operator<( const XclChDataPointPos& rL, const XclChDataPointPos& rR );

struct XclChFrBlock
{
    sal_uInt16          mnType;             
    sal_uInt16          mnContext;          
    sal_uInt16          mnValue1;           
    sal_uInt16          mnValue2;           

    explicit            XclChFrBlock( sal_uInt16 nType );
};

// Frame formatting ===========================================================

struct XclChFramePos
{
    XclChRectangle      maRect;             
    sal_uInt16          mnTLMode;           
    sal_uInt16          mnBRMode;           

    explicit            XclChFramePos();
};

struct XclChLineFormat
{
    Color               maColor;            
    sal_uInt16          mnPattern;          
    sal_Int16           mnWeight;           
    sal_uInt16          mnFlags;            

    explicit            XclChLineFormat();
};

struct XclChAreaFormat
{
    Color               maPattColor;        
    Color               maBackColor;        
    sal_uInt16          mnPattern;          
    sal_uInt16          mnFlags;            

    explicit            XclChAreaFormat();
};

class SfxItemSet;
class EscherPropertyContainer;

struct XclChEscherFormat
{
    typedef std::shared_ptr< SfxItemSet >                SfxItemSetRef;
    typedef std::shared_ptr< EscherPropertyContainer >   EscherPropSetRef;

    SfxItemSetRef       mxItemSet;          
    EscherPropSetRef    mxEscherSet;        

    explicit            XclChEscherFormat();
                        ~XclChEscherFormat();
};

struct XclChPicFormat
{
    sal_uInt16          mnBmpMode;          
    sal_uInt16          mnFlags;            
    double              mfScale;            

    explicit            XclChPicFormat();
};

struct XclChFrame
{
    sal_uInt16          mnFormat;           
    sal_uInt16          mnFlags;            

    explicit            XclChFrame();
};

// Source links ===============================================================

struct XclChSourceLink
{
    sal_uInt8           mnDestType;         
    sal_uInt8           mnLinkType;         
    sal_uInt16          mnFlags;            
    sal_uInt16          mnNumFmtIdx;        

    explicit            XclChSourceLink();
};

// Text =======================================================================

struct XclChObjectLink
{
    XclChDataPointPos   maPointPos;         
    sal_uInt16          mnTarget;           

    explicit            XclChObjectLink();
};

struct XclChFrLabelProps
{
    OUString       maSeparator;        
    sal_uInt16          mnFlags;            

    explicit            XclChFrLabelProps();
};

struct XclChText
{
    XclChRectangle      maRect;             
    Color               maTextColor;        
    sal_uInt8           mnHAlign;           
    sal_uInt8           mnVAlign;           
    sal_uInt16          mnBackMode;         
    sal_uInt16          mnFlags;            
    sal_uInt16          mnFlags2;           
    sal_uInt16          mnRotation;         

    explicit            XclChText();
};

// Data series ================================================================

struct XclChMarkerFormat
{
    Color               maLineColor;        
    Color               maFillColor;        
    sal_uInt32          mnMarkerSize;       
    sal_uInt16          mnMarkerType;       
    sal_uInt16          mnFlags;            

    explicit            XclChMarkerFormat();
};

struct XclCh3dDataFormat
{
    sal_uInt8           mnBase;             
    sal_uInt8           mnTop;              

    explicit            XclCh3dDataFormat();
};

struct XclChDataFormat
{
    XclChDataPointPos   maPointPos;         
    sal_uInt16          mnFormatIdx;        
    sal_uInt16          mnFlags;            

    explicit            XclChDataFormat();
};

struct XclChSerTrendLine
{
    double              mfIntercept;        
    double              mfForecastFor;      
    double              mfForecastBack;     
    sal_uInt8           mnLineType;         
    sal_uInt8           mnOrder;            
    sal_uInt8           mnShowEquation;     
    sal_uInt8           mnShowRSquared;     

    explicit            XclChSerTrendLine();
};

struct XclChSerErrorBar
{
    double              mfValue;            
    sal_uInt16          mnValueCount;       
    sal_uInt8           mnBarType;          
    sal_uInt8           mnSourceType;       
    sal_uInt8           mnLineEnd;          

    explicit            XclChSerErrorBar();
};

struct XclChSeries
{
    sal_uInt16          mnCategType;        
    sal_uInt16          mnValueType;        
    sal_uInt16          mnBubbleType;       
    sal_uInt16          mnCategCount;       
    sal_uInt16          mnValueCount;       
    sal_uInt16          mnBubbleCount;      

    explicit            XclChSeries();
};

// Chart type groups ==========================================================

struct XclChType
{
    sal_Int16           mnOverlap;          
    sal_Int16           mnGap;              
    sal_uInt16          mnRotation;         
    sal_uInt16          mnPieHole;          
    sal_uInt16          mnBubbleSize;       
    sal_uInt16          mnBubbleType;       
    sal_uInt16          mnFlags;            

    explicit            XclChType();
};

struct XclChChart3d
{
    sal_uInt16          mnRotation;         
    sal_Int16           mnElevation;        
    sal_uInt16          mnEyeDist;          
    sal_uInt16          mnRelHeight;        
    sal_uInt16          mnRelDepth;         
    sal_uInt16          mnDepthGap;         
    sal_uInt16          mnFlags;            

    explicit            XclChChart3d();
};

struct XclChLegend
{
    XclChRectangle      maRect;             
    sal_uInt8           mnDockMode;         
    sal_uInt8           mnSpacing;          
    sal_uInt16          mnFlags;            

    explicit            XclChLegend();
};

struct XclChTypeGroup
{
    sal_uInt16          mnFlags;            
    sal_uInt16          mnGroupIdx;         

    explicit            XclChTypeGroup();
};

struct XclChProperties
{
    sal_uInt16          mnFlags;            
    sal_uInt8           mnEmptyMode;        

    explicit            XclChProperties();
};

// Axes =======================================================================

struct XclChLabelRange
{
    sal_uInt16          mnCross;            
    sal_uInt16          mnLabelFreq;        
    sal_uInt16          mnTickFreq;         
    sal_uInt16          mnFlags;            

    explicit            XclChLabelRange();
};

struct XclChDateRange
{
    sal_uInt16          mnMinDate;          
    sal_uInt16          mnMaxDate;          
    sal_uInt16          mnMajorStep;        
    sal_uInt16          mnMajorUnit;        
    sal_uInt16          mnMinorStep;        
    sal_uInt16          mnMinorUnit;        
    sal_uInt16          mnBaseUnit;         
    sal_uInt16          mnCross;            
    sal_uInt16          mnFlags;            

    explicit            XclChDateRange();
};

struct XclChValueRange
{
    double              mfMin;              
    double              mfMax;              
    double              mfMajorStep;        
    double              mfMinorStep;        
    double              mfCross;            
    sal_uInt16          mnFlags;            

    explicit            XclChValueRange();
};

struct XclChTick
{
    Color               maTextColor;        
    sal_uInt8           mnMajor;            
    sal_uInt8           mnMinor;            
    sal_uInt8           mnLabelPos;         
    sal_uInt8           mnBackMode;         
    sal_uInt16          mnFlags;            
    sal_uInt16          mnRotation;         

    explicit            XclChTick();
};

struct XclChAxis
{
    sal_uInt16          mnType;             

    explicit            XclChAxis();

    sal_Int32           GetApiAxisDimension() const;
};

struct XclChAxesSet
{
    XclChRectangle      maRect;             
    sal_uInt16          mnAxesSetId;        

    explicit            XclChAxesSet();

    sal_Int32           GetApiAxesSetIndex() const;
};

// Property mode ==============================================================

enum XclChPropertyMode
{
    EXC_CHPROPMODE_COMMON,          
    EXC_CHPROPMODE_LINEARSERIES,    
    EXC_CHPROPMODE_FILLEDSERIES     
};

// Static helper functions ====================================================

class XclChartHelper
{
public:
    static sal_uInt16   GetSeriesLineAutoColorIdx( sal_uInt16 nFormatIdx );
    static sal_uInt16   GetSeriesFillAutoColorIdx( sal_uInt16 nFormatIdx );
    static sal_uInt8    GetSeriesFillAutoTransp( sal_uInt16 nFormatIdx );
    static sal_uInt16   GetAutoMarkerType( sal_uInt16 nFormatIdx );
    static bool         HasMarkerFillColor( sal_uInt16 nMarkerType );
    static OUString GetErrorBarValuesRole( sal_uInt8 nBarType );
};

// Chart formatting info provider =============================================

enum XclChObjectType
{
    EXC_CHOBJTYPE_BACKGROUND,       
    EXC_CHOBJTYPE_PLOTFRAME,        
    EXC_CHOBJTYPE_WALL3D,           
    EXC_CHOBJTYPE_FLOOR3D,          
    EXC_CHOBJTYPE_TEXT,             
    EXC_CHOBJTYPE_LEGEND,           
    EXC_CHOBJTYPE_LINEARSERIES,     
    EXC_CHOBJTYPE_FILLEDSERIES,     
    EXC_CHOBJTYPE_AXISLINE,         
    EXC_CHOBJTYPE_GRIDLINE,         
    EXC_CHOBJTYPE_TRENDLINE,        
    EXC_CHOBJTYPE_ERRORBAR,         
    EXC_CHOBJTYPE_CONNECTLINE,      
    EXC_CHOBJTYPE_HILOLINE,         
    EXC_CHOBJTYPE_WHITEDROPBAR,     
    EXC_CHOBJTYPE_BLACKDROPBAR      
};

enum XclChFrameType
{
     EXC_CHFRAMETYPE_AUTO,          
     EXC_CHFRAMETYPE_INVISIBLE      
};

struct XclChFormatInfo
{
    XclChObjectType     meObjType;          
    XclChPropertyMode   mePropMode;         
    sal_uInt16          mnAutoLineColorIdx; 
    sal_Int16           mnAutoLineWeight;   
    sal_uInt16          mnAutoPattColorIdx; 
    XclChFrameType      meDefFrameType;     
    bool                mbCreateDefFrame;   
    bool                mbDeleteDefFrame;   
    bool                mbIsFrame;          
};

class XclChFormatInfoProvider
{
public:
    explicit            XclChFormatInfoProvider();

    const XclChFormatInfo& GetFormatInfo( XclChObjectType eObjType ) const;

private:
    typedef ::std::map< XclChObjectType, const XclChFormatInfo* > XclFmtInfoMap;
    XclFmtInfoMap       maInfoMap;          
};

// Chart type info provider ===================================================

enum XclChTypeId
{
    EXC_CHTYPEID_BAR,               
    EXC_CHTYPEID_HORBAR,            
    EXC_CHTYPEID_LINE,              
    EXC_CHTYPEID_AREA,              
    EXC_CHTYPEID_STOCK,             
    EXC_CHTYPEID_RADARLINE,         
    EXC_CHTYPEID_RADARAREA,         
    EXC_CHTYPEID_PIE,               
    EXC_CHTYPEID_DONUT,             
    EXC_CHTYPEID_PIEEXT,            
    EXC_CHTYPEID_SCATTER,           
    EXC_CHTYPEID_BUBBLES,           
    EXC_CHTYPEID_SURFACE,           
    EXC_CHTYPEID_UNKNOWN            
};

enum XclChTypeCateg
{
    EXC_CHTYPECATEG_BAR,            
    EXC_CHTYPECATEG_LINE,           
    EXC_CHTYPECATEG_RADAR,          
    EXC_CHTYPECATEG_PIE,            
    EXC_CHTYPECATEG_SCATTER,        
    EXC_CHTYPECATEG_SURFACE         
};

enum XclChVarPointMode
{
    EXC_CHVARPOINT_NONE,            
    EXC_CHVARPOINT_SINGLE,          
    EXC_CHVARPOINT_MULTI            
};

struct XclChTypeInfo
{
    XclChTypeId         meTypeId;               
    XclChTypeCateg      meTypeCateg;            
    sal_uInt16          mnRecId;                
    const char*         mpcServiceName;         
    XclChVarPointMode   meVarPointMode;         
    sal_Int32           mnDefaultLabelPos;      
    bool                mbCombinable2d;         
    bool                mbSupports3d;           
    bool                mbPolarCoordSystem;     
    bool                mbSeriesIsFrame2d;      
    bool                mbSeriesIsFrame3d;      
    bool                mbSingleSeriesVis;      
    bool                mbCategoryAxis;         
    bool                mbSwappedAxesSet;       
    bool                mbSupportsStacking;     
    bool                mbReverseSeries;        
    bool                mbTicksBetweenCateg;    
};

struct XclChExtTypeInfo : public XclChTypeInfo
{
    bool                mb3dChart;              
    bool                mbSpline;               

    explicit            XclChExtTypeInfo( const XclChTypeInfo& rTypeInfo );

    void                Set( const XclChTypeInfo& rTypeInfo, bool b3dChart, bool bSpline );

    bool         IsSeriesFrameFormat() const
                            { return mb3dChart ? mbSeriesIsFrame3d : mbSeriesIsFrame2d; }
    XclChObjectType GetSeriesObjectType() const
                            { return IsSeriesFrameFormat() ? EXC_CHOBJTYPE_FILLEDSERIES : EXC_CHOBJTYPE_LINEARSERIES; }
};

class XclChTypeInfoProvider
{
public:
    explicit            XclChTypeInfoProvider();

    const XclChTypeInfo& GetTypeInfo( XclChTypeId eType ) const;
    const XclChTypeInfo& GetTypeInfoFromRecId( sal_uInt16 nRecId ) const;
    const XclChTypeInfo& GetTypeInfoFromService( const OUString& rServiceName ) const;

private:
    typedef ::std::map< XclChTypeId, const XclChTypeInfo* > XclChTypeInfoMap;
    XclChTypeInfoMap    maInfoMap;          
};

// Chart text and title object helpers ========================================

enum XclChTextType
{
    EXC_CHTEXTTYPE_TITLE,           
    EXC_CHTEXTTYPE_LEGEND,          
    EXC_CHTEXTTYPE_AXISTITLE,       
    EXC_CHTEXTTYPE_AXISLABEL,       
    EXC_CHTEXTTYPE_DATALABEL        
};

struct XclChTextKey : public ::std::pair< XclChTextType, ::std::pair< sal_uInt16, sal_uInt16 > >
{
    explicit     XclChTextKey( XclChTextType eTextType, sal_uInt16 nMainIdx = 0, sal_uInt16 nSubIdx = 0 )
                            { first = eTextType; second.first = nMainIdx; second.second = nSubIdx; }
};

typedef css::uno::Reference< css::drawing::XShape >
    (*XclChGetShapeFunc)( const css::uno::Reference< css::chart::XChartDocument >& );

// Property helpers ===========================================================

class XclChObjectTable
{
public:
    explicit            XclChObjectTable( css::uno::Reference< css::lang::XMultiServiceFactory > const & xFactory,
                            const OUString& rServiceName, const OUString& rObjNameBase );

    css::uno::Any GetObject( const OUString& rObjName );
    OUString      InsertObject( const css::uno::Any& rObj );

private:
    css::uno::Reference< css::lang::XMultiServiceFactory > mxFactory;              
    css::uno::Reference< css::container::XNameContainer >  mxContainer;            
    OUString            maServiceName;          
    OUString            maObjNameBase;          
    sal_Int32           mnIndex;                
};

class XclChPropSetHelper
{
public:
    explicit            XclChPropSetHelper();

    void                ReadLineProperties(
                            XclChLineFormat& rLineFmt,
                            XclChObjectTable& rDashTable,
                            const ScfPropertySet& rPropSet,
                            XclChPropertyMode ePropMode );
    bool                ReadAreaProperties(
                            XclChAreaFormat& rAreaFmt,
                            const ScfPropertySet& rPropSet,
                            XclChPropertyMode ePropMode );
    void                ReadEscherProperties(
                            XclChEscherFormat& rEscherFmt,
                            XclChPicFormat& rPicFmt,
                            XclChObjectTable& rGradientTable,
                            XclChObjectTable& rHatchTable,
                            XclChObjectTable& rBitmapTable,
                            const ScfPropertySet& rPropSet,
                            XclChPropertyMode ePropMode );
    static void         ReadMarkerProperties(
                            XclChMarkerFormat& rMarkerFmt,
                            const ScfPropertySet& rPropSet,
                            sal_uInt16 nFormatIdx );
    static sal_uInt16   ReadRotationProperties(
                            const ScfPropertySet& rPropSet,
                            bool bSupportsStacked );

    void                WriteLineProperties(
                            ScfPropertySet& rPropSet,
                            XclChObjectTable& rDashTable,
                            const XclChLineFormat& rLineFmt,
                            XclChPropertyMode ePropMode );
    void                WriteAreaProperties(
                            ScfPropertySet& rPropSet,
                            const XclChAreaFormat& rAreaFmt,
                            XclChPropertyMode ePropMode );
    void                WriteEscherProperties(
                            ScfPropertySet& rPropSet,
                            XclChObjectTable& rGradientTable,
                            XclChObjectTable& rBitmapTable,
                            const XclChEscherFormat& rEscherFmt,
                            const XclChPicFormat* pPicFmt,
                            sal_uInt32 nDffFillType,
                            XclChPropertyMode ePropMode );
    static void         WriteMarkerProperties(
                            ScfPropertySet& rPropSet,
                            const XclChMarkerFormat& rMarkerFmt );
    static void         WriteRotationProperties(
                            ScfPropertySet& rPropSet,
                            sal_uInt16 nRotation,
                            bool bSupportsStacked );

private:
    ScfPropSetHelper&   GetLineHelper( XclChPropertyMode ePropMode );
    ScfPropSetHelper&   GetAreaHelper( XclChPropertyMode ePropMode );
    ScfPropSetHelper&   GetGradientHelper( XclChPropertyMode ePropMode );
    ScfPropSetHelper&   GetHatchHelper( XclChPropertyMode ePropMode );

private:
    ScfPropSetHelper    maLineHlpCommon;    
    ScfPropSetHelper    maLineHlpLinear;    
    ScfPropSetHelper    maLineHlpFilled;    
    ScfPropSetHelper    maAreaHlpCommon;    
    ScfPropSetHelper    maAreaHlpFilled;    
    ScfPropSetHelper    maGradHlpCommon;    
    ScfPropSetHelper    maGradHlpFilled;    
    ScfPropSetHelper    maHatchHlpCommon;   
    ScfPropSetHelper    maHatchHlpFilled;   
    ScfPropSetHelper    maBitmapHlp;        
};

struct XclChRootData
{
    typedef std::shared_ptr< XclChTypeInfoProvider >      XclChTypeProvRef;
    typedef std::shared_ptr< XclChFormatInfoProvider >    XclChFmtInfoProvRef;
    typedef std::shared_ptr< XclChObjectTable >           XclChObjectTableRef;
    typedef std::map< XclChTextKey, XclChGetShapeFunc >   XclChGetShapeFuncMap;

    css::uno::Reference< css::chart2::XChartDocument >
                        mxChartDoc;             
    tools::Rectangle           maChartRect;            
    XclChTypeProvRef    mxTypeInfoProv;         
    XclChFmtInfoProvRef mxFmtInfoProv;          
    XclChObjectTableRef mxLineDashTable;        
    XclChObjectTableRef mxGradientTable;        
    XclChObjectTableRef mxHatchTable;           
    XclChObjectTableRef mxBitmapTable;          
    XclChGetShapeFuncMap maGetShapeFuncs;       
    sal_Int32           mnBorderGapX;           
    sal_Int32           mnBorderGapY;           
    double              mfUnitSizeX;            
    double              mfUnitSizeY;            

    explicit            XclChRootData();
    virtual             ~XclChRootData();

    void                InitConversion(
                            const XclRoot& rRoot,
                            const css::uno::Reference< css::chart2::XChartDocument >& rxChartDoc,
                            const tools::Rectangle& rChartRect );
    void                FinishConversion();

    css::uno::Reference< css::drawing::XShape >
                        GetTitleShape( const XclChTextKey& rTitleKey ) const;
};

#endif

/* vim:set shiftwidth=4 softtabstop=4 expandtab: */