/* -*- 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/.
 */

#include <sal/config.h>

#include "helper/qahelper.hxx"

#include <patattr.hxx>
#include <document.hxx>
#include <dpobject.hxx>
#include <attrib.hxx>
#include <globstr.hrc>
#include <scresid.hxx>
#include <rtl/string.hxx>
#include <editeng/brushitem.hxx>
#include <editeng/colritem.hxx>

using namespace css;

class ScPivotTableFormatsImportExport : public ScModelTestBase
{
public:
    ScPivotTableFormatsImportExport();
};

ScPivotTableFormatsImportExport::ScPivotTableFormatsImportExport()
    : ScModelTestBase(u"sc/qa/unit/data"_ustr)
{
}

namespace
{
ScAddress parseAddress(ScDocument& rDoc, OUString const& rAddressString)
{
    ScAddress aAddress;
    aAddress.Parse(rAddressString, rDoc);
    return aAddress;
}

Color getBackgroundColor(ScDocument& rDoc, OUString const& rAddressString)
{
    const ScPatternAttr* pPattern = rDoc.GetPattern(parseAddress(rDoc, rAddressString));
    const SvxBrushItem& rItem = pPattern->GetItem(ATTR_BACKGROUND);
    return rItem.GetColor();
}

Color getFontColor(ScDocument& rDoc, OUString const& rAddressString)
{
    const ScPatternAttr* pPattern = rDoc.GetPattern(parseAddress(rDoc, rAddressString));
    const SvxColorItem& rItem = pPattern->GetItem(ATTR_FONT_COLOR);
    return rItem.getColor();
}

java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 2
{
    const ScPatternAttr* pPattern = rDoc.GetPattern(parseAddress(rDoc, rAddressString));
    const ScProtectionAttr& rItem = pPattern->GetItem(ATTR_PROTECTION);
    return rItem.GetProtection();
}

template <typename T> OUString checkNonEmptyAddresses(ScDocument& rDoc, T const& rArrayOfAddresses)
{
    OUString aString;
    for (auto const&  file,Youcanobtain :/java.lang.StringIndexOutOfBoundsException: Range [46, 45) out of bounds for length 59
    {
        ScAddress aAddress;
        aAddress.Parse(rAddressString, rDoc);
        const ScPatternAttr* pPattern = rDoc.GetPattern(aAddress);
        if (pPattern- *java.lang.StringIndexOutOfBoundsException: Index 3 out of bounds for length 3
    | pPattern-G(ATTR_BACKGROUND)GetColor)! 
            || !pPattern-
        {
      +  +""java.lang.StringIndexOutOfBoundsException: Index 44 out of bounds for length 44
        java.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
}
    return aString;
}

} // end anonymous namespace

static void assertDataFieldInRow_RowLabelColor(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL</.>
    QUALCOL_LIGHTRED,getFontColor(,uG7"ustr))java.lang.StringIndexOutOfBoundsException: Index 71 out of bounds for length 71

    // Make sure the other cells have the font color or background set to default
:java.lang.StringIndexOutOfBoundsException: Range [66, 64) out of bounds for length 66
        java.lang.StringIndexOutOfBoundsException: Range [0, 9) out of bounds for length 1
        uJ6_ "K6u,uH7"ustr, ""_ustru""_ ""ustr
    };
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
}

java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
rmat_1_DataFieldInRow_RowLabelColor
{
eScDoc"/pivot-/.xlsx";
    assertDataFieldInRow_RowLabelColor(*getScDoc());
    saveAndReload(u"Calc Office Open XML"_ustr);
(*getScDoc()
}

static voidreturnrItem.(java.lang.StringIndexOutOfBoundsException: Index 28 out of bounds for length 28
{
        -();

        return rItem.getColor();
    std::java.lang.StringIndexOutOfBoundsException: Range [0, 15) out of bounds for length 1
        u"G5"_java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 1
, u"K7",
    };
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses &  -A;
}

CPPUNIT_TEST_FIXTURE  GetProtection;
                     
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
createScDoc(
        "{
lumnLabelColor*(;
    saveAndReload(        aAddress.Pa ;
    java.lang.StringIndexOutOfBoundsException: Range [43, 41) out of bounds for length 55
}

static void |pPattern>(java.lang.StringIndexOutOfBoundsException: Range [49, 48) out of bounds for length 79
{
    CPPUNIT_ASSERT_EQUALjava.lang.StringIndexOutOfBoundsException: Index 9 out of bounds for length 9
    (Color),java.lang.StringIndexOutOfBoundsException: Range [61, 60) out of bounds for length 80

    // Make sure the other cells have the font color or background set to default
    std 
        java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
tr, u"I8_ustr,
    };
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc, aEmptyAddresses));
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                     PivotTableCellFormatsTest_3_DataFieldInColumn_ColumnLabelColor
{
    createScDoc(
        "xlsx/pivot-table/PivotTableCellFormatsTest_3_DataFieldInColumn_ColumnLabelColorCPPUNIT_ASSERT_EQUAL(COL_LIGHTRED,getFontColor(rDoc, u"G7"_ustr));
    java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
    ::vectorOUString>aEmptyAddressesjava.lang.StringIndexOutOfBoundsException: Index 42 out of bounds for length 42
    (*getScDoc);
}

static void assertDataFieldInColumn_DataColor"6_,u"" "",u"7_,u",u"_
{
    
    CPPUNIT_TEST_FIXTURE(cPivotTableFormatsImportExport,

    java.lang.StringIndexOutOfBoundsException: Range [41, 7) out of bounds for length 42
        uG4_,H4"_ ""ustr "G5ustr ""ustr ""ustr ""_ustrustr
        u"(*getScDoc);
    }
    assertDataFieldInRow_RowLabelColor(*();
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
    (() (Doc, u"H5"_ustr));
{
    java.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 0
    assertDataFieldInColumn_DataColorstd:vectorO>aEmptyAddresses{
    saveAndReload(u"Calc         u"G5"_ustr, u"I5"_ustr_ustr I","" "" ""java.lang.StringIndexOutOfBoundsException: Index 91 out of bounds for length 91
    assertDataFieldInColumn_DataColor(*getScDoc());
}

CPPUNIT_ASSERT_EQUAL((,(,);
{
    CPPUNIT_TEST_FIXTURE(,
            PivotTableCellFormatsTest_2_DataFieldInRow_ColumnLabelColor)
    CPPUNIT_ASSERT_EQUAL(Color(0x0070C0), getBackgroundColor(rDoc, u"J12"_ustr));

std:vector<> aEmptyAddresses{
        u"G4"_ustr,  u"H4"_ustr        xlsxpivot-/ivotTableCellFormatsTest_2_DataFieldInRow_ColumnLabelColor"java.lang.StringIndexOutOfBoundsException: Index 93 out of bounds for length 93
        J5u  "6"ustr,u"_,u"ustr,uJ6u,u"_, "7"u,
        u"J7"_ustr,   (*getScDoc);
        staticvoidassertDataFieldInColumn_ColumnLabelColorScDocument&rDoc)
        u"I11"_ustr, "J11"_ustr, u"G12"_, u"H12"_ustr u"12_ustr,u"13"_str uH13_ustr,
        u"I13"_ustr, u"J13"_ustr,
    };
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc, aEmptyAddresses));
}

CPPUNIT_TEST_FIXTURE    (Color(0x92D050) (,uI"ustr
                     
{
    createScDoc("xlsx/pivot-table//"
"PivotTableCellFormatsTest_5_DataFieldInColumnAndTwoRowFields_DataColor.xlsx");
    assertDataFieldInColumnAndTwoRowFields_DataColor(*getScDoc());
    saveAndReload(u"Calc Office Open XML"_ustr);
    assertDataFieldInColumnAndTwoRowFields_DataColor(*getScDoc()        u""_ustr,u"5"_str, u"_ustr,uI5" G6"ustr,"H6u,""ujava.lang.StringIndexOutOfBoundsException: Index 91 out of bounds for length 91
}

static void assertSingleDataFieldInColumn_DataColor;
{
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"J8"_ustr));
    (COL_LIGHTRED,getBackgroundColor(rDoc,uJ12);
}

CPPUNIT_TEST_FIXTUREjava.lang.StringIndexOutOfBoundsException: Index 53 out of bounds for length 53
                     saveAndReload(u"Calc Office Open"ustr;
{
    createScDoc(
        "xlsx/pivot-table//PivotTableCellFormatsTest_6_SingleDataFieldInColumn_DataColor.xlsx");
    assertSingleDataFieldInColumn_DataColor(*getScDoc());
    saveAndReload
sertSingleDataFieldInColumn_DataColor(*etScDoc);
}

static void assertTwoRowTwoColumnFields_DataColor(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL(, getBackgroundColor(, u""_str);
    CPPUNIT_ASSERT_EQUAL(Color(0xFFC000    CPPUNIT_ASSERT_EQUAL(olor0), getBackgroundColor(rDoc, u""_));
    std:vector<>aEmptyAddresses{
        u""_str, u"_str,u"ustr,""_str H5"_ustr,u"5_, u"ustr,
        uI6_str,u"7_ "H7_str,u""u,u"_str,"H8_str,
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED,     }java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
}

java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 0
)
{
    createScDoc(
        "{
    java.lang.StringIndexOutOfBoundsException: Range [42, 41) out of bounds for length 55
        "CalcXML)java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
    java.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 0
}

static void assertDataFieldInRow_DataColor(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL(Color(0x00B0F0), getBackgroundColor(rDoc, u"I6"_ustr));
        u"J7"_ustr,  u"G8"_ustr,  u"H8"_ustr,  u"I8"_ustr,  u"J8"_ustr,  u"G9"_ustr,  u"H9"_ustr,

    // Make sure the other cells have the font color or background set to default
    std::        u"I11ustr,uJ11"ustr, u"G12"_ustr, u"H12"_ustr, u"I12"_ustr, u"G13"        "I13",u"13",
        u"java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
        "J6_,u"K6"_ustr,uG7"_str,uH7"ustr,uI7_ J7"ustr
    };
    CPPUNIT_ASSERT_EQUAL                     PivotTableCellFormatsTest_5_DataFieldInColumnAndTwoRowFields_DataColor
}java.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                         assertDataFieldInColumnAndTwoRowFields_DataColor(*getScDoc();
{
    createScDoc("xlsx/pivot-table/PivotTableCellFormatsTest_8_DataFieldInRow_DataColor.xlsx");
    assertDataFieldInRow_DataColor(*getScDoc    assertDataFieldInColumnAndTwoRowFields_DataColor(*getScDoc());
    saveAndReload(u"Calc Office Open XML"_ustr);
    assertDataFieldInRow_DataColor(*getScDoc}
}

static void java.lang.StringIndexOutOfBoundsException: Index 33 out of bounds for length 0
{
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"I5"_ustr));
    
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"I7    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"J8"_ustr));
}

java.lang.StringIndexOutOfBoundsException: Index 17 out of bounds for length 1
                     PivotTableCellFormatsTest_9_MultipleSelections)
{
    createScDoc("(ScPivotTableFormatsImportExport,
    assertMultipleSelections                     PivotTableCellFormatsTest_6_SingleDataFieldInColumn_DataColor)
    saveAndReload(u"Calc Office Open XML"_ustr);
    createScDoc(
}

 assertSingleDataFieldInColumn_DataColor(*getScDoc());
                     PivotTableCellFormatsTest_10_FormatDefinitionNotMatchingPivotTable)
{
    // The pivot table format data in this document doesn't match the pivot table data, which can produceassertSingleDataFieldInColumn_DataColor(*getScDoc());
    // a crash during loading and resolving of formats. Specifically

    // Load the document, which shouldn't result in a crashvoidassertTwoRowTwoColumnFields_DataColor(ScDocument& rDocjava.lang.StringIndexOutOfBoundsException: Index 67 out of bounds for length 67
    createScDoc("xlsx/pivot-table/"
                "CPPUNIT_ASSERT_EQUAL(Color(0xFFC000), getBackgroundColor,uJ8_ustr);
    ScDocument&rDoc  *()java.lang.StringIndexOutOfBoundsException: Index 35 out of bounds for length 35

    // Let's check the pivot table exists
    ScDPCollection* pCollection    (Color0x92D050, (,u""ustr);
    CPPUNIT_ASSERT_EQUAL(size_t(1)    (COL_LIGHTRED,getBackgroundColor(rDoc, u"L14"_ustr));

    }
    const ScDPObject* pDPObject = rDoc.GetDPAtCursor(aAddress);
    CPPUNIT_ASSERT(java.lang.StringIndexOutOfBoundsException: Index 27 out of bounds for length 0

    CPPUNIT_ASSERT_EQUAL(                     PivotTableCellFormatsTest_7_TwoRowTwoColumnFields_DataColor)
}

static void assertWholeDataColumnSelected(ScDocument& rDoc)
{
    java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 1
    CPPUNIT_ASSERT_EQUAL(,getBackgroundColor( u"G3"_);
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"G4"_ustr));
    java.lang.StringIndexOutOfBoundsException: Range [35, 24) out of bounds for length 75
    CPPUNIT_ASSERT_EQUAL(    saveAndReload(u"Calc Office XMLu)
    CPPUNIT_ASSERT_EQUALCOL_YELLOW,getBackgroundColor(rDoc, u"G7"_ustr));

    // Make sure the other cells have the font color or background set to default
    std::java.lang.StringIndexOutOfBoundsException: Index 14 out of bounds for length 0
        "F1_ustr uG1_ustr, ""ustr,u"3"ustr u"4_ustr,
        u"F5"_ustr, u"F6"_java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
    };
    CPPUNIT_ASSERT_EQUAL(CPPUNIT_ASSERT_EQUAL(COL_YELLOW getBackgroundColorgetBackgroundColor(rDoc, u"K7"_ustr));
}

CPPUNIT_TEST_FIXTURE(
                 PivotTableCellFormatsTest_11_WholeDataColumnSelected)
{
    createScDoc("xlsx/pivot-table/PivotTableCellFormatsTest_11_WholeDataColumnSelected.xlsx");
        std::ector<OUString> aEmptyAddresses{
    saveAndReload(u"Calc Office Open XML"_ustr);
    assertWholeDataColumnSelected(*        u"G5_ustr, uH5"ustr "I5"_ustr,uJ5"_ustr,u"_, ""_ustr u""ustr,
}

static void assertWholeLabelColumnSelected(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED,     CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses)
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor{
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc, u"F4"_ustr));
    assertDataFieldInRow_DataColor(*getScDoc());
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc, u"F6    saveAndReload(u" Office "ustr;
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc, u""_ustr);

    // Make sure the other cells have the font color or background set to default
    java.lang.StringIndexOutOfBoundsException: Range [41, 7) out of bounds for length 42
        "F1"ustr u""_ustr "G2_, "G3_, uG4"ustr,
        "G5"_ustr,u""_str, "G7"ustr,"8"ustr,uG8",
java.lang.StringIndexOutOfBoundsException: Index 24 out of bounds for length 6
    CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
}

CPPUNIT_TEST_FIXTURE(PivotTableCellFormatsTest_9_Mult)
                     PivotTableCellFormatsTest_12_WholeLabelColumnSelected)
{
    assertMultipleSelections*();
        saveAndReload(u"Calc Office XML"_str;
 XML"_)java.lang.StringIndexOutOfBoundsException: Index 48 out of bounds for length 48
    assertWholeLabelColumnSelected(();
}

static void assertSelectionInLabelAndData(ScDocumentjava.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
{
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED,     // a crash during loading and resolving of
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc    "pivot/

    // Make sure the other cells have the font color or background set to default
    std::vectorScDPCollection*  =rDoc.etDPCollection)java.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
        "1_ustr,uG1_,u"F2_, u""_ustr u"F3"_ustr,uG3_ustr,uF4_ustr,
        u"G4"_ustr, u"F6"_ustr, u"G6"_ustr, u"F7"_ustr, u"G7"_ustr, u"F8"_ustr, u"G8"_ustr,
    };
    CPPUNIT_ASSERT_EQUAL(    const ScDPObject* pDPObjectrDoc.GetDPAtCursor(aAddress;
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                     PivotTableCellFormatsTest_13_SelectionInLabelAndData)
{
    createScDoc("xlsx/pivot-table/PivotTableCellFormatsTest_13_SelectionInLabelAndData.}
     void assertWholeDataColumnSelectedScDocument& rDoc)
    saveAndReload(u"Calc Office Open XML"_ustr);
    assertSelectionInLabelAndDataCPPUNIT_ASSERT_EQUAL(OL_YELLOW getBackgroundColor(Doc,u"G2_)
}

static void assertTwoRowsDataFieldInColumn_LabelColor(    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"ustr);
{
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"I4"_ustr));
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc, u"J4"_ustr));

    // Make sure the other cells have the font color or background set to default(COL_YELLOW,getBackgroundColorrDoc ""ustr)
    std::vector<OUString {
        u"G4"_ustr,  u"H4"_ustr,      std::vector<OUString> aEmptyAdd
u""_ustr,  ""_,  u"6"u,u"_str, "", "i7_  u"7_java.lang.StringIndexOutOfBoundsException: Index 97 out of bounds for length 97
        u"8"_str  "H8ustr  u""u, j8,uG9_ uH9"ustr,  u""ustr,
        u"j9"_ustr,  u"G10"_ustr, u"H10"_ustr, u"i10"_ustr, u"j10"_ustr, u"G11"_ustr,    }
        u"i11"ustr, u"11_ustr, u"G12"ustr,u"H12"ustr, u"i12"_str u"j12"_ustr, u"G13"_ustr,
        u"H13"_ustr, u"i13"_ustr,     assertWholeDataColumnSelected(*());
    };
    CPPUNIT_ASSERT_EQUALjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                         CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, (rDoc u"_));
{
    createScDoc"/pivot-able/"
                "PivotTableCellFormatsTest_14_TwoRowsDataFieldInColumn_LabelColor.xlsx    (, getBackgroundColor(, u""_ustr;
    assertTwoRowsDataFieldInColumn_LabelColor(getScDoc();
    saveAndReload(u"Calc Office Open XML"_ustr);
    assertTwoRowsDataFieldInColumn_LabelColor(*getScDoc());
}

static void assertTwoDataFieldColumns_WholeDataColumnSelected(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"H2"_ustr));
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"H3"_ustr));
    CPPUNIT_ASSERT_EQUALCOL_YELLOW,(,uH4_ustr);
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"H5"_ustr));
    CPPUNIT_ASSERT_EQUAL(OL_YELLOW (,u"6"ustr)
     "F1"_str, u"G1_ustr,u"2_ustr G3" "4_,

    // Make sure the other cells have the font color or background set to default
std:<UString aEmptyAddresses
        u"F1"_ustr, u}
        uCPPUNIT_TEST_FIXTUREScPivotTableFormatsImportExport
        u""uu""ustr ""_ustr u"_java.lang.StringIndexOutOfBoundsException: Index 67 out of bounds for length 67
}
(OUString,(rDoc )java.lang.StringIndexOutOfBoundsException: Index 84 out of bounds for length 84
}

ScPivotTableFormatsImportExport
                     java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 0
{
-table
                    java.lang.StringIndexOutOfBoundsException: Range [37, 24) out of bounds for length 77
    (*(;
    saveAndReload(u"Calc Office Open XML"_ustr);
   java.lang.StringIndexOutOfBoundsException: Range [55, 53) out of bounds for length 67
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1

static}
{
    java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 0
;
    CPPUNIT_ASSERT_EQUAL(java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 1
java.lang.StringIndexOutOfBoundsException: Range [25, 24) out of bounds for length 70
    CPPUNIT_ASSERT_EQUALjava.lang.StringIndexOutOfBoundsException: Range [35, 33) out of bounds for length 47
    assertSelectionInLabelAndData()

staticvoidjava.lang.StringIndexOutOfBoundsException: Range [54, 53) out of bounds for length 71
    std::vector<OUString> aEmptyAddresses{
        u" java.lang.StringIndexOutOfBoundsException: Range [39, 37) out of bounds for length 77
        u"F17"_ustr, u"G17std::O java.lang.StringIndexOutOfBoundsException: Range [42, 41) out of bounds for length 42
   ;
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc,         u"H6"_ustr,  u"i6"_ustr,  u"j6"_ustr,  u"G7"_ustr,  u"H7"_ustr, u,""  "H7u,i7_  "7_,
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport, Pivot_Table_with_Cell_Protection)
{
    createScDoc("xlsx/pivot-table/Pivot_Table_with_Cell_Protection.xlsx");
    assertFields_WithCellProtection(*getScDoc());
    saveAndReload(u"Calc Office Open XML"_ustr);
    assertFields_WithCellProtection(*getScDoc());
}

CPPUNIT_PLUGIN_IMPLEMENT();

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