chart2/qa/extras/uichart.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 <comphelper/propertyvalue.hxx>
  13 #include <vcl/scheduler.hxx>
  14
  15 using namespace ::com::sun::star;
  16
  17 class Chart2UiChartTest : public ChartTest
  18 {
  19 public:
  20     Chart2UiChartTest()
  21         : ChartTest("/chart2/qa/extras/data/")
  22     {
  23     }
  24
  25     void testCopyPasteToNewSheet(uno::Reference<chart::XChartDocument> xChartDoc,
  26                                  OUString aObjectName, sal_Int32 nColumns, sal_Int32 nRows);
  27 };
  28
  29 void Chart2UiChartTest::testCopyPasteToNewSheet(uno::Reference<chart::XChartDocument> xChartDoc,
  30                                                 OUString aObjectName, sal_Int32 nColumns,
  31                                                 sal_Int32 nRows)
  32 {
  33     CPPUNIT_ASSERT(xChartDoc.is());
  34     uno::Reference<chart::XChartDataArray> xChartData(xChartDoc->getData(), uno::UNO_QUERY_THROW);
  35
  36     uno::Sequence<OUString> aExpectedColumnDescriptions = xChartData->getColumnDescriptions();
  37     CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of columns in origin file", nColumns,
  38                                  aExpectedColumnDescriptions.getLength());
  39
  40     uno::Sequence<OUString> aExpectedRowDescriptions = xChartData->getRowDescriptions();
  41     CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of rows in origin file", nRows,
  42                                  aExpectedRowDescriptions.getLength());
  43
  44     Sequence<Sequence<double>> aExpectedData = xChartData->getData();
  45
  46     uno::Sequence<beans::PropertyValue> aPropertyValues = {
  47         comphelper::makePropertyValue("ToObject", aObjectName),
  48     };
  49     dispatchCommand(mxComponent, ".uno:GoToObject", aPropertyValues);
  50
  51     dispatchCommand(mxComponent, ".uno:Copy", {});
  52
  53     // create a new document
  54     load("private:factory/scalc");
  55
  56     dispatchCommand(mxComponent, ".uno:Paste", {});
  57
  58     uno::Reference<chart2::XChartDocument> xChartDoc2 = getChartDocFromSheet(0, mxComponent);
  59     CPPUNIT_ASSERT(xChartDoc2.is());
  60
  61     uno::Reference<chart::XChartDataArray> xDataArray(xChartDoc2->getDataProvider(),
  62                                                       UNO_QUERY_THROW);
  63
  64     Sequence<OUString> aColumnDesc = xDataArray->getColumnDescriptions();
  65     CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of columns in destination file", nColumns,
  66                                  aColumnDesc.getLength());
  67     for (sal_Int32 i = 0; i < nColumns; ++i)
  68     {
  69         OString sMessage("Incorrect description in column: " + OString::number(i));
  70         CPPUNIT_ASSERT_EQUAL_MESSAGE(sMessage.getStr(), aExpectedColumnDescriptions[i],
  71                                      aColumnDesc[i]);
  72     }
  73
  74     Sequence<OUString> aRowDesc = xDataArray->getRowDescriptions();
  75     CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of rows in destination file", nRows,
  76                                  aRowDesc.getLength());
  77     for (sal_Int32 i = 0; i < nRows; ++i)
  78     {
  79         OString sMessage("Incorrect description in row: " + OString::number(i));
  80         CPPUNIT_ASSERT_EQUAL_MESSAGE(sMessage.getStr(), aExpectedRowDescriptions[i], aRowDesc[i]);
  81     }
  82
  83     Sequence<Sequence<double>> aData = xDataArray->getData();
  84
  85     for (sal_Int32 nRowIdx = 0; nRowIdx < nRows; ++nRowIdx)
  86     {
  87         for (sal_Int32 nColIdx = 0; nColIdx < nColumns; ++nColIdx)
  88         {
  89             double nValue = aData[nRowIdx][nColIdx];
  90             double nExpected = aExpectedData[nRowIdx][nColIdx];
  91             OString sMessage("Incorrect value in Col: " + OString::number(nColIdx)
  92                              + " Row: " + OString::number(nRowIdx));
  93
  94             if (std::isnan(nValue))
  95             {
  96                 // On paste, 0 becomes NaN, check whether it's expected
  97                 CPPUNIT_ASSERT_DOUBLES_EQUAL_MESSAGE(sMessage.getStr(), 0.0, nExpected, 1e-1);
  98             }
  99             else
 100             {
 101                 CPPUNIT_ASSERT_DOUBLES_EQUAL_MESSAGE(sMessage.getStr(), nExpected, nValue, 1e-1);
 102             }
 103         }
 104     }
 105 }
 106
 107 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf120348)
 108 {
 109     loadFromFile(u"ods/tdf120348.ods");
 110     uno::Reference<chart::XChartDocument> xChartDoc(getChartCompFromSheet(0, 0, mxComponent),
 111                                                     uno::UNO_QUERY_THROW);
 112
 113     // Without the fix in place, this test would have failed with
 114     // - Expected: 0
 115     // - Actual  : 3.33625955201419
 116     // - Incorrect value in Col: 2 Row: 51
 117     testCopyPasteToNewSheet(xChartDoc, "Object 2", 4, 158);
 118 }
 119
 120 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf151091)
 121 {
 122     std::vector<OUString> aExpected
 123         = { u"Ωφέλιμο"_ustr, u"Επικίνδυνο"_ustr, u"Απόσταση"_ustr, u"Μάσκα"_ustr, u"Εμβόλιο"_ustr };
 124
 125     loadFromFile(u"ods/tdf151091.ods");
 126     uno::Reference<chart::XChartDocument> xChartDoc(getChartCompFromSheet(0, 0, mxComponent),
 127                                                     uno::UNO_QUERY_THROW);
 128     CPPUNIT_ASSERT(xChartDoc.is());
 129     uno::Reference<chart::XChartDataArray> xChartData(xChartDoc->getData(), uno::UNO_QUERY_THROW);
 130     uno::Sequence<OUString> aSeriesList = xChartData->getColumnDescriptions();
 131     CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(5), aSeriesList.getLength());
 132
 133     for (size_t i = 0; i < 5; ++i)
 134         CPPUNIT_ASSERT_EQUAL(aExpected[i], aSeriesList[i]);
 135
 136     uno::Sequence<beans::PropertyValue> aPropertyValues = {
 137         comphelper::makePropertyValue("ToObject", OUString("Object 1")),
 138     };
 139     dispatchCommand(mxComponent, ".uno:GoToObject", aPropertyValues);
 140
 141     dispatchCommand(mxComponent, ".uno:Copy", {});
 142
 143     // create a new writer document
 144     load("private:factory/swriter");
 145
 146     dispatchCommand(mxComponent, ".uno:Paste", {});
 147
 148     aSeriesList = getWriterChartColumnDescriptions(mxComponent);
 149
 150     // Without the fix in place, this test would have failed with
 151     // - Expected: 5
 152     // - Actual  : 1
 153     CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(5), aSeriesList.getLength());
 154
 155     for (size_t i = 0; i < 5; ++i)
 156         CPPUNIT_ASSERT_EQUAL(aExpected[i], aSeriesList[i]);
 157 }
 158
 159 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf107097)
 160 {
 161     loadFromFile(u"ods/tdf107097.ods");
 162     uno::Reference<chart::XChartDocument> xChartDoc(getPivotChartDocFromSheet(1, mxComponent),
 163                                                     uno::UNO_QUERY_THROW);
 164     testCopyPasteToNewSheet(xChartDoc, "Object 1", 4, 12);
 165 }
 166
 167 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf136011)
 168 {
 169     loadFromFile(u"ods/tdf136011.ods");
 170     uno::Reference<chart::XChartDocument> xChartDoc(getChartCompFromSheet(0, 0, mxComponent),
 171                                                     uno::UNO_QUERY_THROW);
 172     testCopyPasteToNewSheet(xChartDoc, "Object 1", 3, 9);
 173
 174     loadFromFile(u"ods/tdf136011.ods");
 175     uno::Reference<chart::XChartDocument> xChartDoc2(getChartCompFromSheet(0, 1, mxComponent),
 176                                                      uno::UNO_QUERY_THROW);
 177
 178     // Without the fix in place, this test would have failed with
 179     // - Expected: Test 1 1
 180     // - Actual  : Test 1
 181     // - Incorrect description in row: 0
 182     testCopyPasteToNewSheet(xChartDoc2, "Object 2", 3, 9);
 183 }
 184
 185 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf62057)
 186 {
 187     loadFromFile(u"ods/tdf62057.ods");
 188     uno::Reference<chart::XChartDocument> xChartDoc(getChartCompFromSheet(0, 0, mxComponent),
 189                                                     uno::UNO_QUERY_THROW);
 190
 191     // Without the fix in place, this test would have failed with
 192     // - Expected: 2
 193     // - Actual  : 7
 194     // - Incorrect number of columns in destination file
 195     testCopyPasteToNewSheet(xChartDoc, "Object 1", 2, 6);
 196 }
 197
 198 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf98690)
 199 {
 200     loadFromFile(u"xlsx/tdf98690.xlsx");
 201     uno::Reference<chart::XChartDocument> xChartDoc(getChartCompFromSheet(0, 0, mxComponent),
 202                                                     uno::UNO_QUERY_THROW);
 203
 204     CPPUNIT_ASSERT(xChartDoc.is());
 205     uno::Reference<chart::XChartDataArray> xChartData(xChartDoc->getData(), uno::UNO_QUERY_THROW);
 206     uno::Sequence<OUString> aSeriesList = xChartData->getColumnDescriptions();
 207     CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(6), aSeriesList.getLength());
 208
 209     uno::Sequence<beans::PropertyValue> aPropertyValues = {
 210         comphelper::makePropertyValue("ToObject", OUString("Chart 2")),
 211     };
 212     dispatchCommand(mxComponent, ".uno:GoToObject", aPropertyValues);
 213
 214     dispatchCommand(mxComponent, ".uno:Copy", {});
 215
 216     // create a new document
 217     load("private:factory/scalc");
 218
 219     dispatchCommand(mxComponent, ".uno:Paste", {});
 220
 221     uno::Reference<chart::XChartDocument> xChartDoc2(getChartCompFromSheet(0, 0, mxComponent),
 222                                                      uno::UNO_QUERY_THROW);
 223     CPPUNIT_ASSERT(xChartDoc2.is());
 224     uno::Reference<chart::XChartDataArray> xChartData2(xChartDoc2->getData(), uno::UNO_QUERY_THROW);
 225     uno::Sequence<OUString> aSeriesList2 = xChartData2->getColumnDescriptions();
 226
 227     // Without the fix in place, this test would have failed with
 228     // - Expected: 12
 229     // - Actual  : 0
 230     CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(12), aSeriesList2.getLength());
 231 }
 232
 233 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf101894)
 234 {
 235     loadFromFile(u"ods/tdf101894.ods");
 236     uno::Reference<chart::XChartDocument> xChartDoc(getChartCompFromSheet(0, 0, mxComponent),
 237                                                     uno::UNO_QUERY_THROW);
 238
 239     CPPUNIT_ASSERT(xChartDoc.is());
 240     uno::Reference<chart::XChartDataArray> xChartData(xChartDoc->getData(), uno::UNO_QUERY_THROW);
 241
 242     uno::Sequence<OUString> aExpectedColumnDescriptions = xChartData->getColumnDescriptions();
 243     CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of columns in origin file",
 244                                  static_cast<sal_Int32>(12),
 245                                  aExpectedColumnDescriptions.getLength());
 246
 247     uno::Sequence<OUString> aExpectedRowDescriptions = xChartData->getRowDescriptions();
 248     CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of rows in origin file",
 249                                  static_cast<sal_Int32>(8), aExpectedRowDescriptions.getLength());
 250
 251     Sequence<Sequence<double>> aExpectedData = xChartData->getData();
 252
 253     // Create a copy of the sheet and move to the end
 254     uno::Sequence<beans::PropertyValue> aArgs(
 255         comphelper::InitPropertySequence({ { "DocName", uno::Any(OUString("tdf101894")) },
 256                                            { "Index", uno::Any(sal_uInt16(32767)) },
 257                                            { "Copy", uno::Any(true) } }));
 258     dispatchCommand(mxComponent, ".uno:Move", aArgs);
 259
 260     uno::Reference<sheet::XSpreadsheetDocument> xDoc(mxComponent, UNO_QUERY_THROW);
 261     uno::Reference<container::XIndexAccess> xIA(xDoc->getSheets(), UNO_QUERY_THROW);
 262     CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(2), xIA->getCount());
 263
 264     for (sal_Int32 sheetIndex = 0; sheetIndex < 2; ++sheetIndex)
 265     {
 266         uno::Reference<chart::XChartDocument> xChartDoc2(
 267             getChartCompFromSheet(sheetIndex, 0, mxComponent), uno::UNO_QUERY_THROW);
 268         CPPUNIT_ASSERT(xChartDoc2.is());
 269         uno::Reference<chart::XChartDataArray> xChartData2(xChartDoc2->getData(),
 270                                                            uno::UNO_QUERY_THROW);
 271
 272         uno::Sequence<OUString> aColumnDescriptions = xChartData2->getColumnDescriptions();
 273         CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of columns in origin file",
 274                                      static_cast<sal_Int32>(12), aColumnDescriptions.getLength());
 275         for (sal_Int32 i = 0; i < 12; ++i)
 276         {
 277             OString sMessage("Incorrect description in column: " + OString::number(i));
 278             CPPUNIT_ASSERT_EQUAL_MESSAGE(sMessage.getStr(), aExpectedColumnDescriptions[i],
 279                                          aColumnDescriptions[i]);
 280         }
 281
 282         uno::Sequence<OUString> aRowDescriptions = xChartData2->getRowDescriptions();
 283         CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of rows in origin file",
 284                                      static_cast<sal_Int32>(8), aRowDescriptions.getLength());
 285         for (sal_Int32 i = 0; i < 8; ++i)
 286         {
 287             OString sMessage("Incorrect description in row: " + OString::number(i));
 288             CPPUNIT_ASSERT_EQUAL_MESSAGE(sMessage.getStr(), aExpectedRowDescriptions[i],
 289                                          aRowDescriptions[i]);
 290         }
 291
 292         Sequence<Sequence<double>> aData = xChartData2->getData();
 293
 294         for (sal_Int32 nRowIdx = 0; nRowIdx < 8; ++nRowIdx)
 295         {
 296             for (sal_Int32 nColIdx = 0; nColIdx < 12; ++nColIdx)
 297             {
 298                 double nValue = aData[nRowIdx][nColIdx];
 299                 double nExpected = aExpectedData[nRowIdx][nColIdx];
 300                 OString sMessage("Incorrect value in Col: " + OString::number(nColIdx)
 301                                  + " Row: " + OString::number(nRowIdx));
 302
 303                 // Without the fix in place, this test would have failed with
 304                 // - Expected: 1
 305                 // - Actual  : 2.2250738585072e-308
 306                 // - Incorrect value in Col: 0 Row: 0
 307                 CPPUNIT_ASSERT_DOUBLES_EQUAL_MESSAGE(sMessage.getStr(), nExpected, nValue, 1e-1);
 308             }
 309         }
 310     }
 311 }
 312
 313 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testCopyPasteChartWithDotInSheetName)
 314 {
 315     loadFromFile(u"ods/chartWithDotInSheetName.ods");
 316     uno::Reference<chart::XChartDocument> xChartDoc(getChartCompFromSheet(0, 0, mxComponent),
 317                                                     uno::UNO_QUERY_THROW);
 318
 319     CPPUNIT_ASSERT(xChartDoc.is());
 320     uno::Reference<chart::XChartDataArray> xChartData(xChartDoc->getData(), uno::UNO_QUERY_THROW);
 321
 322     uno::Sequence<OUString> aExpectedColumnDescriptions = xChartData->getColumnDescriptions();
 323     CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of columns in origin file",
 324                                  static_cast<sal_Int32>(4),
 325                                  aExpectedColumnDescriptions.getLength());
 326
 327     uno::Sequence<OUString> aExpectedRowDescriptions = xChartData->getRowDescriptions();
 328     CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of rows in origin file",
 329                                  static_cast<sal_Int32>(7), aExpectedRowDescriptions.getLength());
 330
 331     Sequence<Sequence<double>> aExpectedData = xChartData->getData();
 332
 333     dispatchCommand(mxComponent, ".uno:SelectAll", {});
 334     dispatchCommand(mxComponent, ".uno:Copy", {});
 335
 336     uno::Sequence<beans::PropertyValue> aArgs(comphelper::InitPropertySequence(
 337         { { "Name", uno::Any(OUString("NewTab")) }, { "Index", uno::Any(sal_uInt16(2)) } }));
 338     dispatchCommand(mxComponent, ".uno:Insert", aArgs);
 339
 340     uno::Reference<sheet::XSpreadsheetDocument> xDoc(mxComponent, UNO_QUERY_THROW);
 341     uno::Reference<container::XIndexAccess> xIA(xDoc->getSheets(), UNO_QUERY_THROW);
 342     CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(2), xIA->getCount());
 343
 344     dispatchCommand(mxComponent, ".uno:Paste", {});
 345
 346     for (sal_Int32 sheetIndex = 0; sheetIndex < 2; ++sheetIndex)
 347     {
 348         uno::Reference<chart::XChartDocument> xChartDoc2(
 349             getChartCompFromSheet(sheetIndex, 0, mxComponent), uno::UNO_QUERY_THROW);
 350         CPPUNIT_ASSERT(xChartDoc2.is());
 351         uno::Reference<chart::XChartDataArray> xChartData2(xChartDoc2->getData(),
 352                                                            uno::UNO_QUERY_THROW);
 353
 354         uno::Sequence<OUString> aColumnDescriptions = xChartData2->getColumnDescriptions();
 355         CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of columns in origin file",
 356                                      static_cast<sal_Int32>(4), aColumnDescriptions.getLength());
 357         for (sal_Int32 i = 0; i < 4; ++i)
 358         {
 359             OString sMessage("Incorrect description in column: " + OString::number(i));
 360             CPPUNIT_ASSERT_EQUAL_MESSAGE(sMessage.getStr(), aExpectedColumnDescriptions[i],
 361                                          aColumnDescriptions[i]);
 362         }
 363
 364         uno::Sequence<OUString> aRowDescriptions = xChartData2->getRowDescriptions();
 365         CPPUNIT_ASSERT_EQUAL_MESSAGE("Incorrect number of rows in origin file",
 366                                      static_cast<sal_Int32>(7), aRowDescriptions.getLength());
 367         for (sal_Int32 i = 0; i < 7; ++i)
 368         {
 369             OString sMessage("Incorrect description in row: " + OString::number(i));
 370             CPPUNIT_ASSERT_EQUAL_MESSAGE(sMessage.getStr(), aExpectedRowDescriptions[i],
 371                                          aRowDescriptions[i]);
 372         }
 373
 374         Sequence<Sequence<double>> aData = xChartData2->getData();
 375
 376         for (sal_Int32 nRowIdx = 0; nRowIdx < 7; ++nRowIdx)
 377         {
 378             for (sal_Int32 nColIdx = 0; nColIdx < 4; ++nColIdx)
 379             {
 380                 double nValue = aData[nRowIdx][nColIdx];
 381                 double nExpected = aExpectedData[nRowIdx][nColIdx];
 382                 OString sMessage("Incorrect value in Col: " + OString::number(nColIdx)
 383                                  + " Row: " + OString::number(nRowIdx));
 384
 385                 CPPUNIT_ASSERT_DOUBLES_EQUAL_MESSAGE(sMessage.getStr(), nExpected, nValue, 1e-1);
 386             }
 387         }
 388     }
 389 }
 390
 391 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf158223)
 392 {
 393     loadFromFile(u"ods/tdf158223.ods");
 394
 395     uno::Reference<sheet::XSpreadsheetDocument> xDoc(mxComponent, UNO_QUERY_THROW);
 396     uno::Reference<container::XIndexAccess> xIA(xDoc->getSheets(), UNO_QUERY_THROW);
 397     CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(3), xIA->getCount());
 398
 399     for (sal_Int32 sheetIndex = 0; sheetIndex < 2; ++sheetIndex)
 400     {
 401         OUString sExpectedValuesX("$Tabelle" + OUString::number(sheetIndex + 1) + ".$A$2:$A$11");
 402         OUString sExpectedValuesY("$Tabelle" + OUString::number(sheetIndex + 1) + ".$B$2:$B$11");
 403         uno::Reference<chart2::XChartDocument> xChartDoc
 404             = getChartDocFromSheet(sheetIndex, mxComponent);
 405         Reference<chart2::data::XDataSequence> xValuesX
 406             = getDataSequenceFromDocByRole(xChartDoc, u"values-x");
 407         CPPUNIT_ASSERT_EQUAL(sExpectedValuesX, xValuesX->getSourceRangeRepresentation());
 408         Reference<chart2::data::XDataSequence> xValuesY
 409             = getDataSequenceFromDocByRole(xChartDoc, u"values-y");
 410         CPPUNIT_ASSERT_EQUAL(sExpectedValuesY, xValuesY->getSourceRangeRepresentation());
 411     }
 412
 413     // Remove last sheet
 414     uno::Sequence<beans::PropertyValue> aArgs(
 415         comphelper::InitPropertySequence({ { "Index", uno::Any(sal_uInt16(3)) } }));
 416     dispatchCommand(mxComponent, ".uno:Remove", aArgs);
 417
 418     CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(2), xIA->getCount());
 419
 420     for (sal_Int32 sheetIndex = 0; sheetIndex < 2; ++sheetIndex)
 421     {
 422         OUString sExpectedValuesX("$Tabelle" + OUString::number(sheetIndex + 1) + ".$A$2:$A$11");
 423         OUString sExpectedValuesY("$Tabelle" + OUString::number(sheetIndex + 1) + ".$B$2:$B$11");
 424         uno::Reference<chart2::XChartDocument> xChartDoc
 425             = getChartDocFromSheet(sheetIndex, mxComponent);
 426         Reference<chart2::data::XDataSequence> xValuesX
 427             = getDataSequenceFromDocByRole(xChartDoc, u"values-x");
 428
 429         // Without the fix in place, this test would have failed with
 430         // - Expected: $Tabelle2.$A$2:$A$11
 431         // - Actual  : $Tabelle2.$A$2:$Tabelle1.$A$11
 432         CPPUNIT_ASSERT_EQUAL(sExpectedValuesX, xValuesX->getSourceRangeRepresentation());
 433         Reference<chart2::data::XDataSequence> xValuesY
 434             = getDataSequenceFromDocByRole(xChartDoc, u"values-y");
 435         CPPUNIT_ASSERT_EQUAL(sExpectedValuesY, xValuesY->getSourceRangeRepresentation());
 436     }
 437 }
 438
 439 CPPUNIT_TEST_FIXTURE(Chart2UiChartTest, testTdf153706)
 440 {
 441     // Load a spreadsheet with a to-page XY scatter chart with the sheet as data source
 442     loadFromFile(u"ods/tdf153706_XY_scatter_chart.ods");
 443
 444     // Select the cell range around the chart, and copy the range to clipboard, including the chart
 445     dispatchCommand(mxComponent, u".uno:GoToCell"_ustr,
 446                     { comphelper::makePropertyValue(u"ToPoint"_ustr, u"D1:K23"_ustr) });
 447     dispatchCommand(mxComponent, u".uno:Copy"_ustr, {});
 448
 449     // create a new document
 450     load(u"private:factory/scalc"_ustr);
 451
 452     // Paste; this must create a chart with own data source having a proper copy of the data
 453     dispatchCommand(mxComponent, u".uno:Paste"_ustr, {});
 454
 455     css::uno::Reference xChartDoc(getChartDocFromSheet(0, mxComponent), css::uno::UNO_SET_THROW);
 456     auto xDataArray(xChartDoc->getDataProvider().queryThrow<chart::XChartDataArray>());
 457
 458     css::uno::Sequence<Sequence<double>> aData = xDataArray->getData();
 459     CPPUNIT_ASSERT_EQUAL(sal_Int32(3), aData.getLength());
 460     CPPUNIT_ASSERT_EQUAL(sal_Int32(2), aData[0].getLength());
 461     CPPUNIT_ASSERT_EQUAL(sal_Int32(2), aData[1].getLength());
 462     CPPUNIT_ASSERT_EQUAL(sal_Int32(2), aData[2].getLength());
 463     CPPUNIT_ASSERT_EQUAL(2.0, aData[0][0]);
 464     CPPUNIT_ASSERT_EQUAL(3.0, aData[0][1]);
 465     CPPUNIT_ASSERT_EQUAL(3.0, aData[1][0]);
 466     CPPUNIT_ASSERT_EQUAL(2.0, aData[1][1]);
 467     CPPUNIT_ASSERT_EQUAL(4.0, aData[2][0]);
 468     CPPUNIT_ASSERT_EQUAL(1.0, aData[2][1]);
 469
 470     // Without the fix, this would fail with
 471     // - Expected: 1
 472     // - Actual  : 2
 473     // i.e., the X values were treated as another Y series
 474     CPPUNIT_ASSERT_EQUAL(sal_Int32(1), getNumberOfDataSeries(xChartDoc));
 475
 476     auto xSeries(getDataSeriesFromDoc(xChartDoc, 0).queryThrow<chart2::data::XDataSource>());
 477     auto sequences = xSeries->getDataSequences();
 478     // Without the fix, this would fail with
 479     // - Expected: 2
 480     // - Actual  : 1
 481     CPPUNIT_ASSERT_EQUAL(sal_Int32(2), sequences.getLength());
 482
 483     auto propX(sequences[0]->getValues().queryThrow<beans::XPropertySet>());
 484     // Without the fix, this would fail with
 485     // - Expected: values-x
 486     // - Actual  : values-y
 487     CPPUNIT_ASSERT_EQUAL(u"values-x"_ustr, propX->getPropertyValue("Role").get<OUString>());
 488
 489     auto propY(sequences[1]->getValues().queryThrow<beans::XPropertySet>());
 490     CPPUNIT_ASSERT_EQUAL(u"values-y"_ustr, propY->getPropertyValue("Role").get<OUString>());
 491 }
 492
 493 CPPUNIT_PLUGIN_IMPLEMENT();
 494
 495 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */