chart2/qa/extras/chart2export3.cxx

   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
  10 #include "charttest.hxx"
  11
  12 #include <com/sun/star/chart/ErrorBarStyle.hpp>
  13 #include <com/sun/star/chart2/XRegressionCurveContainer.hpp>
  14 #include <com/sun/star/chart2/MovingAverageType.hpp>
  15 #include <com/sun/star/lang/XServiceName.hpp>
  16 #include <com/sun/star/text/XTextDocument.hpp>
  17 #include <com/sun/star/drawing/LineStyle.hpp>
  18 #include <com/sun/star/drawing/FillStyle.hpp>
  19 #include <com/sun/star/chart2/DataPointLabel.hpp>
  20 #include <com/sun/star/chart/DataLabelPlacement.hpp>
  21
  22 using uno::Reference;
  23 using beans::XPropertySet;
  24
  25 class Chart2ExportTest3 : public ChartTest
  26 {
  27 public:
  28     Chart2ExportTest3() : ChartTest("/chart2/qa/extras/data/") {}
  29 };
  30
  31 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTdf108107)
  32 {
  33     loadFromURL(u"xlsx/tdf108107.xlsx");
  34
  35     // FIXME: validation error in OOXML export: Errors: 1
  36     skipValidation();
  37
  38     save("Calc Office Open XML");
  39     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
  40     CPPUNIT_ASSERT(pXmlDoc);
  41     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart/c:ser/c:dLbls/c:dLbl[1]/c:idx", "val", "1");
  42     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart/c:ser/c:dLbls/c:dLbl[1]/c:txPr/a:p/a:pPr/a:defRPr", "b", "1");
  43     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart/c:ser/c:dLbls/c:dLbl[1]/c:txPr/a:p/a:pPr/a:defRPr", "sz", "2000");
  44 }
  45
  46 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTdf114139)
  47 {
  48     loadFromURL(u"xlsx/tdf114139.xlsx");
  49     save("Calc Office Open XML");
  50     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
  51     CPPUNIT_ASSERT(pXmlDoc);
  52
  53     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:pie3DChart", 1);
  54     //no fill
  55     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:spPr", 0);
  56     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:spPr/a:solidFill", 0);
  57 }
  58
  59 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTdf64224)
  60 {
  61     loadFromURL(u"ods/tdf64224.ods");
  62     save("Calc Office Open XML");
  63     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
  64     CPPUNIT_ASSERT(pXmlDoc);
  65
  66     //no fill
  67     assertXPath(pXmlDoc, "/c:chartSpace/c:spPr/a:noFill", 1);
  68     assertXPath(pXmlDoc, "/c:chartSpace/c:spPr/a:solidFill", 0);
  69 }
  70
  71 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testChartTitlePropertiesColorFillDOCX)
  72 {
  73     loadFromURL(u"docx/testChartTitlePropertiesColorFill.docx");
  74     save("Office Open XML Text");
  75     xmlDocUniquePtr pXmlDoc = parseExport("word/charts/chart1.xml");
  76     CPPUNIT_ASSERT(pXmlDoc);
  77     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:solidFill/a:srgbClr", "val", "ff0000");
  78     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:ln/a:noFill", 1);
  79 }
  80
  81 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testChartTitlePropertiesGradientFillDOCX)
  82 {
  83     loadFromURL(u"docx/testChartTitlePropertiesGradientFill.docx");
  84     save("Office Open XML Text");
  85     xmlDocUniquePtr pXmlDoc = parseExport("word/charts/chart1.xml");
  86     CPPUNIT_ASSERT(pXmlDoc);
  87     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:gradFill/a:gsLst/a:gs[1]/a:srgbClr", "val", "cccccc");
  88     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:gradFill/a:gsLst/a:gs[2]/a:srgbClr", "val", "666666");
  89     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:ln/a:noFill", 1);
  90 }
  91
  92 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testChartTitlePropertiesBitmapFillDOCX)
  93 {
  94     loadFromURL(u"docx/testChartTitlePropertiesBitmapFill.docx");
  95     save("Office Open XML Text");
  96     xmlDocUniquePtr pXmlDoc = parseExport("word/charts/chart1.xml");
  97     CPPUNIT_ASSERT(pXmlDoc);
  98     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:blipFill/a:blip", "embed", "rId1");
  99     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:ln/a:noFill", 1);
 100 }
 101
 102
 103 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testColorGradientWithTransparencyDOCX)
 104 {
 105     // Test color gradient (two color) with gradient transparency
 106     loadFromURL(u"docx/testColorGradientWithTransparency.docx");
 107     save("Office Open XML Text");
 108     xmlDocUniquePtr pXmlDoc = parseExport("word/charts/chart1.xml");
 109     CPPUNIT_ASSERT(pXmlDoc);
 110     // Test the transparency of the first color
 111     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:spPr/a:gradFill/a:gsLst/a:gs[1]/a:srgbClr/a:alpha", "val", "60000");
 112     // Test the transparency of the second color
 113     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:spPr/a:gradFill/a:gsLst/a:gs[2]/a:srgbClr/a:alpha", "val", "90000");
 114 }
 115
 116 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testColorGradientWithTransparencyODS)
 117 {
 118     // Test color gradient (two color) with simple transparency
 119     loadFromURL(u"ods/testColorGradientWithTransparency.ods");
 120     save("Calc Office Open XML");
 121     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 122     CPPUNIT_ASSERT(pXmlDoc);
 123     // Test the transparency of the first color
 124     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:spPr/a:gradFill/a:gsLst/a:gs[1]/a:srgbClr/a:alpha", "val", "60000");
 125     // Test the transparency of the second color
 126     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:spPr/a:gradFill/a:gsLst/a:gs[2]/a:srgbClr/a:alpha", "val", "60000");
 127 }
 128
 129 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testColorGradientStopXLSX)
 130 {
 131     // Test color gradient (two color) stop of the first color
 132     loadFromURL(u"xlsx/tdf128619.xlsx");
 133     save("Calc Office Open XML");
 134     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 135     CPPUNIT_ASSERT(pXmlDoc);
 136     // Test the position of the first color
 137     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:spPr/a:gradFill/a:gsLst/a:gs[1]", "pos", "45000");
 138     // Test the position of the second color
 139     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:spPr/a:gradFill/a:gsLst/a:gs[2]", "pos", "100000");
 140 }
 141
 142 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testRadialColorGradientDOCX)
 143 {
 144     loadFromURL(u"docx/tdf128794.docx");
 145     save("Office Open XML Text");
 146     xmlDocUniquePtr pXmlDoc = parseExport("word/charts/chart1.xml");
 147     CPPUNIT_ASSERT(pXmlDoc);
 148     // Test the gradient style (if there is no 'a:path' attribute, it is a linear gradient)
 149     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:spPr/a:gradFill/a:path", 0);
 150     // Test the linear gradient angle
 151     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:spPr/a:gradFill/a:lin", "ang", "13500000");
 152 }
 153
 154 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testBarChartDataPointPropDOCX)
 155 {
 156     loadFromURL(u"docx/testBarChartDataPointPropDOCX.docx");
 157     save("Office Open XML Text");
 158     xmlDocUniquePtr pXmlDoc = parseExport("word/charts/chart1.xml");
 159     CPPUNIT_ASSERT(pXmlDoc);
 160
 161     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:varyColors", "val", "0");
 162
 163     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[1]/c:idx", "val", "1");
 164     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[1]/c:spPr/a:gradFill/a:gsLst/a:gs[1]/a:srgbClr", "val", "f6f8fc");
 165     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[1]/c:spPr/a:gradFill/a:gsLst/a:gs[2]/a:srgbClr", "val", "c7d5ed");
 166     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[1]/c:spPr/a:ln/a:solidFill/a:srgbClr", "val", "70ad47");
 167
 168     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[2]/c:idx", "val", "2");
 169     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[2]/c:spPr/a:solidFill/a:srgbClr", "val", "ff0000");
 170     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[2]/c:spPr/a:ln/a:solidFill/a:srgbClr", "val", "000000");
 171 }
 172
 173 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testFdo83058dlblPos)
 174 {
 175     loadFromURL(u"docx/fdo83058_dlblPos.docx");
 176
 177     // FIXME: validation error in OOXML export: Errors: 1
 178     skipValidation();
 179
 180     save("Office Open XML Text");
 181     xmlDocUniquePtr pXmlDoc = parseExport("word/charts/chart1.xml");
 182     CPPUNIT_ASSERT(pXmlDoc);
 183     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser[1]/c:dLbls[1]/c:dLbl[2]/c:dLblPos", "val", "outEnd");
 184     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser[1]/c:dLbls[1]/c:dLbl[3]/c:dLblPos", "val", "outEnd");
 185     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser[1]/c:dLbls[1]/c:dLbl[4]/c:dLblPos", "val", "outEnd");
 186     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser[1]/c:dLbls[1]/c:dLbl[5]/c:dLblPos", "val", "outEnd");
 187 }
 188
 189 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testAutoTitleDelXLSX)
 190 {
 191     loadFromURL(u"xlsx/autotitledel_2007.xlsx");
 192     save("Calc Office Open XML");
 193     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 194     CPPUNIT_ASSERT(pXmlDoc);
 195     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:autoTitleDeleted", "val", "0");
 196 }
 197
 198 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testDispBlanksAsXLSX)
 199 {
 200     loadFromURL(u"xlsx/dispBlanksAs_2007.xlsx");
 201     save("Calc Office Open XML");
 202     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 203     CPPUNIT_ASSERT(pXmlDoc);
 204     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:dispBlanksAs", "val", "gap");
 205 }
 206
 207 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testMarkerColorXLSX)
 208 {
 209     loadFromURL(u"xlsx/markerColor.xlsx");
 210     save("Calc Office Open XML");
 211     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 212     CPPUNIT_ASSERT(pXmlDoc);
 213     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:scatterChart/c:ser/c:marker/c:spPr/a:solidFill/a:srgbClr", "val", "92d050");
 214 }
 215
 216 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testRoundedCornersXLSX)
 217 {
 218     loadFromURL(u"xlsx/markerColor.xlsx");
 219     save("Calc Office Open XML");
 220     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 221     CPPUNIT_ASSERT(pXmlDoc);
 222     assertXPath(pXmlDoc, "/c:chartSpace/c:roundedCorners", "val", "0");
 223 }
 224
 225 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testAxisNumberFormatXLSX)
 226 {
 227     loadFromURL(u"ods/axis_number_format.ods");
 228     save("Calc Office Open XML");
 229     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 230     CPPUNIT_ASSERT(pXmlDoc);
 231     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx", 2);
 232     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx[1]/c:numFmt", "formatCode", "0.00E+000");
 233     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx[1]/c:numFmt", "sourceLinked", "0");
 234
 235     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx[2]/c:numFmt", "formatCode", "[$$-409]#,##0;\\-[$$-409]#,##0");
 236     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx[2]/c:numFmt", "sourceLinked", "1");
 237 }
 238
 239 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testDataPointLabelNumberFormatXLSX)
 240 {
 241     // FIXME: validation error in OOXML export: Errors: 1
 242     skipValidation();
 243
 244     loadFromURL(u"ods/tdf123774.ods");
 245     {
 246         save("Calc Office Open XML");
 247         xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 248         CPPUNIT_ASSERT(pXmlDoc);
 249         assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:pieChart/c:ser/c:dLbls/c:numFmt", "formatCode", "[$-40E]0.00%");
 250         assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:pieChart/c:ser/c:dLbls/c:numFmt", "sourceLinked", "0");
 251
 252         assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:pieChart/c:ser/c:dLbls/c:dLbl[1]/c:numFmt", "formatCode", "[$-40E]0.00%");
 253         assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:pieChart/c:ser/c:dLbls/c:dLbl[1]/c:numFmt", "sourceLinked", "0");
 254     }
 255
 256     loadFromURL(u"xlsx/tdf130986.xlsx");
 257     {
 258         save("Calc Office Open XML");
 259         xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 260         CPPUNIT_ASSERT(pXmlDoc);
 261         assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dLbls/c:dLbl/c:idx", "val", "1");
 262         assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dLbls/c:dLbl/c:numFmt", "formatCode", "0.00E+00");
 263         assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dLbls/c:dLbl/c:numFmt", "sourceLinked", "0");
 264     }
 265 }
 266
 267 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testDataLabelDefaultValuesXLSX)
 268 {
 269     loadFromURL(u"xlsx/data_label.xlsx");
 270     Reference< chart2::XChartDocument> xDoc = getChartDocFromSheet(0, mxComponent);
 271     Reference<chart2::XDataSeries> xSeries = getDataSeriesFromDoc(xDoc, 0);
 272     Reference<beans::XPropertySet> xPropSet(xSeries, uno::UNO_QUERY_THROW);
 273     uno::Any aAny = xPropSet->getPropertyValue("Label");
 274     chart2::DataPointLabel aLabel;
 275     CPPUNIT_ASSERT(aAny >>= aLabel);
 276     CPPUNIT_ASSERT(aLabel.ShowNumber);
 277
 278     save("Calc Office Open XML");
 279     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 280     CPPUNIT_ASSERT(pXmlDoc);
 281     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dLbls/c:showVal", "val", "1");
 282     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dLbls/c:dLblPos", "val", "outEnd");
 283 }
 284
 285 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testDataLabelFillColor)
 286 {
 287     loadFromURL(u"xlsx/data_labels_fill_color.xlsx");
 288     Reference< chart2::XChartDocument> xDoc = getChartDocFromSheet(0, mxComponent);
 289     Reference<chart2::XDataSeries> xSeries = getDataSeriesFromDoc(xDoc, 0);
 290     Reference<beans::XPropertySet> xPropSet(xSeries, uno::UNO_QUERY_THROW);
 291     uno::Any aAny = xPropSet->getPropertyValue("LabelFillColor");
 292     sal_Int32 nLabelFillColor;
 293     CPPUNIT_ASSERT(aAny >>= nLabelFillColor);
 294
 295     save("Calc Office Open XML");
 296     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 297     CPPUNIT_ASSERT(pXmlDoc);
 298     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dLbls/c:spPr/a:solidFill/a:srgbClr", "val", "F79646");
 299 }
 300
 301 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTitleOverlayXLSX)
 302 {
 303     loadFromURL(u"xlsx/chart_title.xlsx");
 304     save("Calc Office Open XML");
 305     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 306     CPPUNIT_ASSERT(pXmlDoc);
 307     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:overlay", "val", "0");
 308 }
 309
 310 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testInvertIfNegativeXLSX)
 311 {
 312     loadFromURL(u"xlsx/bar_chart_simple.xlsx");
 313     save("Calc Office Open XML");
 314     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 315     CPPUNIT_ASSERT(pXmlDoc);
 316     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:invertIfNegative", "val", "0");
 317 }
 318
 319 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testBubble3DXLSX)
 320 {
 321     loadFromURL(u"xlsx/bubble_chart_simple.xlsx");
 322     save("Calc Office Open XML");
 323     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 324     CPPUNIT_ASSERT(pXmlDoc);
 325     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:bubbleChart/c:ser[1]/c:bubble3D", "val", "0");
 326     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:bubbleChart/c:ser[2]/c:bubble3D", "val", "0");
 327     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:bubbleChart/c:ser[3]/c:bubble3D", "val", "0");
 328 }
 329
 330 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testNoMarkerXLSX)
 331 {
 332     loadFromURL(u"xlsx/no_marker.xlsx");
 333     save("Calc Office Open XML");
 334     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 335     CPPUNIT_ASSERT(pXmlDoc);
 336     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart/c:ser[1]/c:marker/c:symbol", "val", "none");
 337     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart/c:ser[2]/c:marker/c:symbol", "val", "none");
 338     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart/c:marker", "val", "0");
 339 }
 340
 341 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTitleManualLayoutXLSX)
 342 {
 343     loadFromURL(u"xlsx/title_manual_layout.xlsx");
 344     save("Calc Office Open XML");
 345     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 346     CPPUNIT_ASSERT(pXmlDoc);
 347     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:layout/c:manualLayout/c:layoutTarget", 0);
 348     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:layout/c:manualLayout/c:xMode", "val", "edge");
 349     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:layout/c:manualLayout/c:yMode", "val", "edge");
 350
 351     OUString aXVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:layout/c:manualLayout/c:x", "val");
 352     double nX = aXVal.toDouble();
 353     CPPUNIT_ASSERT(nX > 0);
 354     CPPUNIT_ASSERT(nX < 1);
 355
 356     OUString aYVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:layout/c:manualLayout/c:y", "val");
 357     double nY = aYVal.toDouble();
 358     CPPUNIT_ASSERT(nY > 0);
 359     CPPUNIT_ASSERT(nY < 1);
 360     CPPUNIT_ASSERT(nX != nY);
 361
 362     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:bodyPr", "rot", "1200000");
 363 }
 364
 365 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testPlotAreaManualLayoutXLSX)
 366 {
 367     loadFromURL(u"xlsx/plot_area_manual_layout.xlsx");
 368     save("Calc Office Open XML");
 369     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 370     CPPUNIT_ASSERT(pXmlDoc);
 371
 372     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:layout/c:manualLayout/c:layoutTarget", "val", "inner");
 373     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:layout/c:manualLayout/c:xMode", "val", "edge");
 374     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:layout/c:manualLayout/c:yMode", "val", "edge");
 375
 376     OUString aXVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:layout/c:manualLayout/c:x", "val");
 377     double nX = aXVal.toDouble();
 378     CPPUNIT_ASSERT(nX > 0);
 379     CPPUNIT_ASSERT(nX < 1);
 380
 381     OUString aYVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:layout/c:manualLayout/c:y", "val");
 382     double nY = aYVal.toDouble();
 383     CPPUNIT_ASSERT(nY > 0);
 384     CPPUNIT_ASSERT(nY < 1);
 385     CPPUNIT_ASSERT(nX != nY);
 386
 387     OUString aWVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:layout/c:manualLayout/c:w", "val");
 388     double nW = aWVal.toDouble();
 389     CPPUNIT_ASSERT(nW > 0);
 390     CPPUNIT_ASSERT(nW < 1);
 391
 392     OUString aHVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:layout/c:manualLayout/c:h", "val");
 393     double nH = aHVal.toDouble();
 394     CPPUNIT_ASSERT(nH > 0);
 395     CPPUNIT_ASSERT(nH < 1);
 396     CPPUNIT_ASSERT(nH != nW);
 397 }
 398
 399 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testLegendManualLayoutXLSX)
 400 {
 401     loadFromURL(u"xlsx/legend_manual_layout.xlsx");
 402     save("Calc Office Open XML");
 403     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 404     CPPUNIT_ASSERT(pXmlDoc);
 405
 406     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:layout/c:manualLayout/c:layoutTarget", 0);
 407     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:legend/c:layout/c:manualLayout/c:xMode", "val", "edge");
 408     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:legend/c:layout/c:manualLayout/c:yMode", "val", "edge");
 409
 410     OUString aXVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:legend/c:layout/c:manualLayout/c:x", "val");
 411     double nX = aXVal.toDouble();
 412     CPPUNIT_ASSERT(nX > 0);
 413     CPPUNIT_ASSERT(nX < 1);
 414
 415     OUString aYVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:legend/c:layout/c:manualLayout/c:y", "val");
 416     double nY = aYVal.toDouble();
 417     CPPUNIT_ASSERT(nY > 0);
 418     CPPUNIT_ASSERT(nY < 1);
 419     CPPUNIT_ASSERT(nX != nY);
 420
 421     OUString aWVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:legend/c:layout/c:manualLayout/c:w", "val");
 422     double nW = aWVal.toDouble();
 423     CPPUNIT_ASSERT(nW > 0);
 424     CPPUNIT_ASSERT(nW < 1);
 425
 426     OUString aHVal = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:legend/c:layout/c:manualLayout/c:h", "val");
 427     double nH = aHVal.toDouble();
 428     CPPUNIT_ASSERT(nH > 0);
 429     CPPUNIT_ASSERT(nH < 1);
 430     CPPUNIT_ASSERT(nH != nW);
 431
 432     // Make sure that default text font size is preserved after export
 433     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:legend/c:txPr/a:p/a:pPr/a:defRPr", "sz", "900");
 434 }
 435
 436 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testChartSubTitle)
 437 {
 438     loadFromURL(u"ods/testChartSubTitle.ods");
 439     save("Calc Office Open XML");
 440     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 441     CPPUNIT_ASSERT(pXmlDoc);
 442     // test properties of subtitle
 443     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr", "sz", "1100");
 444     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr", "b", "1");
 445     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr/a:solidFill/a:srgbClr", "val", "00a933");
 446     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:r/a:rPr/a:latin", "typeface", "Times New Roman");
 447     assertXPathContent(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:r/a:t", "It is a Subtitle");
 448     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:solidFill/a:srgbClr", "val", "b2b2b2");
 449 }
 450
 451 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testChartMainWithSubTitle)
 452 {
 453     loadFromURL(u"ods/testChartMainWithSubTitle.ods");
 454     save("Calc Office Open XML");
 455     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 456     CPPUNIT_ASSERT(pXmlDoc);
 457     // test properties of title
 458     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr", "sz", "1300");
 459     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr", "b", "0");
 460     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr", "i", "1");
 461     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr/a:solidFill/a:srgbClr", "val", "f10d0c");
 462     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:r/a:rPr/a:latin", "typeface", "Arial");
 463     assertXPathContent(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:r/a:t", "It is a Maintitle\nIt is a Subtitle");
 464     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:solidFill/a:srgbClr", "val", "81d41a");
 465 }
 466
 467 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testAutoTitleDeleted)
 468 {
 469     loadFromURL(u"xlsx/testAutoTitleDeleted.xlsx");
 470     save("Calc Office Open XML");
 471     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 472     CPPUNIT_ASSERT(pXmlDoc);
 473     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:autoTitleDeleted", "val", "1");
 474 }
 475
 476 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testChartTitlePropertiesColorFillXLSX)
 477 {
 478     loadFromURL(u"xlsx/testChartTitlePropertiesColorFill.xlsx");
 479     save("Calc Office Open XML");
 480     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 481     CPPUNIT_ASSERT(pXmlDoc);
 482     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:solidFill/a:srgbClr", "val", "ff0000");
 483     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:ln/a:noFill", 1);
 484 }
 485
 486 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testChartTitlePropertiesGradientFillXLSX)
 487 {
 488     loadFromURL(u"xlsx/testChartTitlePropertiesGradientFill.xlsx");
 489     save("Calc Office Open XML");
 490     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 491     CPPUNIT_ASSERT(pXmlDoc);
 492     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:gradFill/a:gsLst/a:gs[1]/a:srgbClr", "val", "cccccc");
 493     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:gradFill/a:gsLst/a:gs[2]/a:srgbClr", "val", "666666");
 494     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:ln/a:noFill", 1);
 495 }
 496
 497 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testChartTitlePropertiesBitmapFillXLSX)
 498 {
 499     loadFromURL(u"xlsx/testChartTitlePropertiesBitmapFill.xlsx");
 500     save("Calc Office Open XML");
 501     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 502     CPPUNIT_ASSERT(pXmlDoc);
 503     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:blipFill/a:blip", "embed", "rId1");
 504     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:spPr/a:ln/a:noFill", 1);
 505 }
 506
 507 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testBarChartDataPointPropXLSX)
 508 {
 509     loadFromURL(u"xlsx/testBarChartDataPointPropXLSX.xlsx");
 510     save("Calc Office Open XML");
 511     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 512     CPPUNIT_ASSERT(pXmlDoc);
 513
 514     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:varyColors", "val", "0");
 515
 516     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[1]/c:idx", "val", "1");
 517     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[1]/c:spPr/a:solidFill/a:srgbClr", "val", "ff0000");
 518     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[1]/c:spPr/a:ln/a:solidFill/a:srgbClr", "val", "000000");
 519
 520     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[2]/c:idx", "val", "2");
 521     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[2]/c:spPr/a:gradFill/a:gsLst/a:gs[1]/a:srgbClr", "val", "f6f8fc");
 522     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[2]/c:spPr/a:gradFill/a:gsLst/a:gs[2]/a:srgbClr", "val", "c7d5ed");
 523     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:ser/c:dPt[2]/c:spPr/a:ln/a:solidFill/a:srgbClr", "val", "70ad47");
 524 }
 525
 526 namespace {
 527
 528 void checkGapWidth(Reference<beans::XPropertySet> const & xPropSet, sal_Int32 nValue)
 529 {
 530     uno::Any aAny = xPropSet->getPropertyValue("GapwidthSequence");
 531     CPPUNIT_ASSERT(aAny.hasValue());
 532     uno::Sequence< sal_Int32 > aSequence;
 533     aAny >>= aSequence;
 534     CPPUNIT_ASSERT(aSequence.hasElements());
 535     CPPUNIT_ASSERT_EQUAL(nValue, aSequence[0]);
 536 }
 537
 538 void checkOverlap(Reference<beans::XPropertySet> const & xPropSet, sal_Int32 nValue)
 539 {
 540     uno::Any aAny = xPropSet->getPropertyValue("OverlapSequence");
 541     CPPUNIT_ASSERT(aAny.hasValue());
 542     uno::Sequence< sal_Int32 > aSequence;
 543     aAny >>= aSequence;
 544     CPPUNIT_ASSERT(aSequence.hasElements());
 545     CPPUNIT_ASSERT_EQUAL(nValue, aSequence[0]);
 546 }
 547
 548 void checkSheetForGapWidthAndOverlap(uno::Reference< chart2::XChartDocument > const & xChartDoc,
 549         sal_Int32 nExpectedGapWidth, sal_Int32 nExpectedOverlap)
 550 {
 551     CPPUNIT_ASSERT(xChartDoc.is());
 552
 553     Reference< chart2::XChartType > xChartType = getChartTypeFromDoc( xChartDoc, 0 );
 554     CPPUNIT_ASSERT(xChartType.is());
 555
 556     Reference< beans::XPropertySet > xPropSet( xChartType, uno::UNO_QUERY_THROW );
 557     checkGapWidth(xPropSet, nExpectedGapWidth);
 558     checkOverlap(xPropSet, nExpectedOverlap);
 559
 560 }
 561
 562 }
 563
 564 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testDataseriesOverlapStackedChartXLSX)
 565 {
 566     loadFromURL(u"xlsx/testDataseriesOverlapStackedChart.xlsx");
 567
 568     // test the overlap value of a simple Stacked Column Chart
 569     uno::Reference< chart2::XChartDocument > xChartDoc = getChartDocFromSheet( 0, mxComponent );
 570     checkSheetForGapWidthAndOverlap(xChartDoc, 100, 0);
 571
 572     // test the overlap value of a Percent Stacked Bar Chart
 573     xChartDoc = getChartDocFromSheet( 1, mxComponent );
 574     checkSheetForGapWidthAndOverlap(xChartDoc, 100, 35);
 575
 576     saveAndReload("Calc Office Open XML");
 577
 578     xChartDoc = getChartDocFromSheet( 0, mxComponent );
 579     checkSheetForGapWidthAndOverlap(xChartDoc, 100, 100);
 580
 581     xChartDoc = getChartDocFromSheet( 1, mxComponent );
 582     checkSheetForGapWidthAndOverlap(xChartDoc, 100, 100);
 583 }
 584
 585 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testAxisCharacterPropertiesXLSX)
 586 {
 587     loadFromURL(u"xlsx/axis_character_properties.xlsx");
 588     save("Calc Office Open XML");
 589     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 590     CPPUNIT_ASSERT(pXmlDoc);
 591
 592     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:catAx/c:txPr/a:p/a:pPr/a:defRPr", "sz", "1000");
 593     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:catAx/c:txPr/a:p/a:pPr/a:defRPr", "b", "1");
 594     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:catAx/c:txPr/a:p/a:pPr/a:defRPr", "i", "1");
 595     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:catAx/c:txPr/a:p/a:pPr/a:defRPr", "u", "sng");
 596
 597     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx/c:txPr/a:p/a:pPr/a:defRPr", "sz", "900");
 598     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx/c:txPr/a:p/a:pPr/a:defRPr", "b", "1");
 599     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx/c:txPr/a:p/a:pPr/a:defRPr", "strike", "sngStrike");
 600     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx/c:txPr/a:p/a:pPr/a:defRPr/a:solidFill/a:srgbClr", "val", "ff0000");
 601 }
 602
 603 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTitleCharacterPropertiesXLSX)
 604 {
 605     loadFromURL(u"xlsx/title_character_properties.xlsx");
 606     save("Calc Office Open XML");
 607     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 608     CPPUNIT_ASSERT(pXmlDoc);
 609
 610     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr", "sz", "2400");
 611     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:pPr/a:defRPr", "b", "1");
 612
 613     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:r/a:rPr", "sz", "2400");
 614     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:title/c:tx/c:rich/a:p/a:r/a:rPr", "b", "1");
 615 }
 616
 617 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testPlotVisOnlyXLSX)
 618 {
 619     loadFromURL(u"xlsx/hidden_cells.xlsx");
 620     save("Calc Office Open XML");
 621     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 622     CPPUNIT_ASSERT(pXmlDoc);
 623
 624     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotVisOnly", "val", "0");
 625 }
 626
 627 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testBarChartVaryColorsXLSX)
 628 {
 629     loadFromURL(u"xlsx/tdf90876.xlsx");
 630     save("Calc Office Open XML");
 631     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 632     CPPUNIT_ASSERT(pXmlDoc);
 633
 634     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart/c:varyColors", "val", "0");
 635 }
 636
 637 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTdf96161)
 638 {
 639     loadFromURL(u"ods/tdf96161.ods");
 640     save("Calc Office Open XML");
 641     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 642     CPPUNIT_ASSERT(pXmlDoc);
 643
 644     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart/c:varyColors", "val", "0");
 645 }
 646
 647 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTableOnPage3)
 648 {
 649     loadFromURL(u"docx/TableOnPage3.docx");
 650
 651     // FIXME: validation error in OOXML export: Errors: 2
 652     skipValidation();
 653
 654     saveAndReload("Office Open XML Text");
 655
 656     Reference<chart2::XChartDocument> xChartDoc(getChartDocFromWriter(0), uno::UNO_QUERY);
 657     CPPUNIT_ASSERT(xChartDoc.is());
 658     uno::Reference< chart::XChartDataArray > xDataArray(xChartDoc->getDataProvider(), UNO_QUERY_THROW);
 659     Sequence<OUString> aColumnDesc = xDataArray->getColumnDescriptions();
 660     CPPUNIT_ASSERT_EQUAL_MESSAGE("There must be 4 columns and descriptions", static_cast<sal_Int32>(4), aColumnDesc.getLength());
 661     CPPUNIT_ASSERT_EQUAL(OUString("If oversubscription relative to allowance increases at the same average rate B15-B17"), aColumnDesc[0]);
 662     CPPUNIT_ASSERT_EQUAL(OUString("Known requirements"), aColumnDesc[1]);
 663     CPPUNIT_ASSERT_EQUAL(OUString("Allowance"), aColumnDesc[2]);
 664     CPPUNIT_ASSERT_EQUAL(OUString("If oversubscription relative to allowance holds steady at average oversubscription level B15-B17"), aColumnDesc[3]);
 665 }
 666
 667 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testMultipleAxisXLSX)
 668 {
 669     loadFromURL(u"ods/multiple_axis.ods");
 670     save("Calc Office Open XML");
 671     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 672     CPPUNIT_ASSERT(pXmlDoc);
 673
 674     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:scatterChart", 2);
 675     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:scatterChart[1]/c:ser", 1);
 676     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:scatterChart[2]/c:ser", 1);
 677     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx", 4);
 678     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx/c:delete[@val='1']", 1);
 679     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx/c:axPos[@val='l']", 1);
 680     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx/c:axPos[@val='r']", 1);
 681 }
 682
 683 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testSecondaryAxisXLSX)
 684 {
 685     loadFromURL(u"ods/secondary_axis.ods");
 686     save("Calc Office Open XML");
 687     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 688     CPPUNIT_ASSERT(pXmlDoc);
 689
 690     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart", 2);
 691     // test there is just those series in the first <lineChart> tag which are attached to the primary axis
 692     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart[1]/c:ser", 2);
 693     assertXPathContent(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart[1]/c:ser[1]/c:tx/c:strRef/c:strCache/c:pt/c:v", "b");
 694     assertXPathContent(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart[1]/c:ser[2]/c:tx/c:strRef/c:strCache/c:pt/c:v", "c");
 695     // test there is just those series in the second <lineChart> tag which are attached to the secondary axis
 696     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart[2]/c:ser", 1);
 697     assertXPathContent(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:lineChart[2]/c:ser[1]/c:tx/c:strRef/c:strCache/c:pt/c:v", "a");
 698 }
 699
 700 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testBarChartSecondaryAxisXLSX)
 701 {
 702     loadFromURL(u"xlsx/testSecondaryAxis.xlsx");
 703     save("Calc Office Open XML");
 704     xmlDocUniquePtr pXmlDoc = parseExport("xl/charts/chart1.xml");
 705     CPPUNIT_ASSERT(pXmlDoc);
 706     // Collect barchart axID on primary Axis
 707     OUString XValueIdOf1Barchart = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart[1]/c:axId[1]", "val");
 708     OUString YValueIdOf1Barchart = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart[1]/c:axId[2]", "val");
 709     // Collect barchart axID on secondary Axis
 710     OUString XValueIdOf2Barchart = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart[2]/c:axId[1]", "val");
 711     OUString YValueIdOf2Barchart = getXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:barChart[2]/c:axId[2]", "val");
 712     // Check which c:catAx and c:valAx contain the AxisId of barcharts
 713     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:catAx[1]/c:axId", "val", XValueIdOf1Barchart);
 714     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx[1]/c:axId", "val", YValueIdOf1Barchart);
 715     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:catAx[2]/c:axId", "val", XValueIdOf2Barchart);
 716     assertXPath(pXmlDoc, "/c:chartSpace/c:chart/c:plotArea/c:valAx[2]/c:axId", "val", YValueIdOf2Barchart);
 717 }
 718
 719 CPPUNIT_TEST_FIXTURE(Chart2ExportTest3, testTdf148142)
 720 {
 721     // The document contains a line chart with "Between tick marks" X axis position.
 722     loadFromURL(u"ods/tdf148142.ods");
 723     Reference<chart2::XChartDocument> xChartDoc = getChartDocFromSheet(0, mxComponent);
 724     CPPUNIT_ASSERT(xChartDoc.is());
 725     Reference<chart2::XAxis> xAxis = getAxisFromDoc(xChartDoc, 0, 0, 0);
 726     CPPUNIT_ASSERT(xAxis.is());
 727     chart2::ScaleData aScaleData = xAxis->getScaleData();
 728     CPPUNIT_ASSERT(aScaleData.ShiftedCategoryPosition);
 729
 730     // Set the X axis position to "On tick marks".
 731     aScaleData.ShiftedCategoryPosition = false;
 732     xAxis->setScaleData(aScaleData);
 733
 734     // Check the X axis position after export.
 735     saveAndReload("calc8");
 736     Reference<chart2::XChartDocument> xChartDoc2 = getChartDocFromSheet(0, mxComponent);
 737     CPPUNIT_ASSERT(xChartDoc2.is());
 738     Reference<chart2::XAxis> xAxis2 = getAxisFromDoc(xChartDoc2, 0, 0, 0);
 739     CPPUNIT_ASSERT(xAxis2.is());
 740     chart2::ScaleData aScaleData2 = xAxis2->getScaleData();
 741     CPPUNIT_ASSERT(!aScaleData2.ShiftedCategoryPosition);
 742 }
 743
 744 CPPUNIT_PLUGIN_IMPLEMENT();
 745
 746 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */