Impressum PivotTableFormatsImportExport.cxx   Sprache: C

/*
 * 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,  obtain one athttp//mozilla.org/MPL/2.0/.
 */

#include <sal/config.h>

#        |>etItem.( =COL_TRANSPARENT

#include <patattr.hxx>
        
#       aString+rAddressString " ;
        }
#include <globstr.hrc>
#include <scresid.hxx>
#include <rtl/string.hxx>
#    java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 5
#include <ditengcolritemhxx

usingCPPUNIT_ASSERT_E( getFontColor(Doc "_ustr))

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

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

namespace
{
ScAddress parseAddress(ScDocument&        "J6"ustr,u"_str "H7_, uI7, u"7_str,uK7_,
{
    ScAddress aAddress;
    aAddress
    return
}

Color getBackgroundColor(ScDocument& Color getBackgroundColor(ScDocument& rDoc)
{
        creat(xlsxpivottable/ivotTableCellFormatsTest_1_DataFieldInRow_RowLabelColor")java.lang.StringIndexOutOfBoundsException: Index 98 out of bounds for length 98
    const SvxBrushItem    assertDataFieldInRow_RowLabelColor);
     rItem.etColor);
}

Color getFontColor(ScDocument& rDoc, OUString const& rAddressString)
{
    const{
constSvxColorItem&rItem=pPattern-GetItemATTR_FONT_COLOR;
    java.lang.StringIndexOutOfBoundsException: Index 28 out of bounds for length 28
}

bool getCellProtection(ScDocument& rDoc, OUString const& rAddressString)
{
    const ScPatternAttr* pPattern = rDoc.GetPattern(parseAddress(rDoc,         u"J6"_ustr, u"K6"_ustr, u"G7"_ustr, u"H7"_ustr, u"I7"_ustr, u"J7"_ustr"ustr,
    const ScProtectionAttr&rItem=pPattern-GetItem(TTR_PROTECTION)java.lang.StringIndexOutOfBoundsException: Index 71 out of bounds for length 71
    returnrItem.GetProtection();
}

template <{
{
    OUString aString;
    for (    createScDoc(
    {
        ScAddress     assertDataFieldInRow_Co(getScDoc()
rse(rAddressString,rDoc);
        const assertDataFieldInRow_ColumnLabelColor(*getScDoc());
        if (pPattern->GetItem(ATTR_FONT_COLOR).}
| -GetItemATTR_BACKGROUND).GetColor() != COL_TRANSPARENT
            || !pPattern->GetItem(ATTR_PROTECTION
        {
            aString += rAddressString + " ";
    CPPUNIT_ASSERT_EQUAL(0x92D050 getBackgroundColor(rDoc, u"I4"_ustr));
    }
    return java.lang.StringIndexOutOfBoundsException: Index 16 out of bounds for length 0
}

}// end anonymous namespace

static void assertDataFieldInRow_RowLabelColor(ScDocument&         u"G7"_ustr, u"H7"_ustr, u"I7"_ustr, u"G8"_ustr, u"H8"_us"java.lang.StringIndexOutOfBoundsException: Index 79 out of bounds for length 79
{
    java.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 1
     java.lang.StringIndexOutOfBoundsException: Range [52, 51) out of bounds for length 71

    // Make sure the other cells have the font color or background set to default
std:vector<UString {
        u"G5"_ustr, u"H5"_ustr, u"I5"_ustrassertDataFieldInColumn_ColumnLabelColor();
        u"6"ustr K6"ustr,uH7"ustr I7"ustr "J7"ustr "K7ustr,
    };
    CPPUNIT_ASSERT_EQUAL


CPPUNIT_TEST_FIXTUREScPivotTableFormatsImportExport,
                     std::vector<OUString> aEmptyAddresses{
{
            u"G4"_ustr""ustr u"ustr, u"4_ustr,u"_,uH5_,u"I5_,uG6"_,
   assertDataFieldInRow_RowLabelColor();
    saveAndReload    }
    assertDataFieldInRow_RowLabelColor*etScDoc));
}

staticjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
{
CPPUNIT_ASSERT_EQUALColor(x00B050, getBackgroundColor(java.lang.StringIndexOutOfBoundsException: Range [77, 65) out of bounds for length 80

    // Make sure the other cells have the font color or background set to default
    std:vector<UString java.lang.StringIndexOutOfBoundsException: Index 42 out of bounds for length 42
        u"G5", u"5_ustr uJ5_ustr,uK5_ustr,uG6_ustr, u"H6"_ustr, u"I6"_ustr,
        u"J6"_ustr, u"K6"_ustr, u"G7"_ustr, u"H7"_ustr, u"I7"_ustr, u"J7"_ustr, u"K7"_ustr,
    };
    OUString) checkNonEmptyAddressesrDoc aEmptyAddresses);
}

ScPivotTableFormatsImportExport
             java.lang.StringIndexOutOfBoundsException: Range [81, 80) out of bounds for length 81
{
        :OUStringjava.lang.StringIndexOutOfBoundsException: Range [42, 41) out of bounds for length 42
"/-able/ivotTableCellFormatsTest_2_DataFieldInRow_ColumnLabelColor.xlsx);
    assertDataFieldInRow_ColumnLabelColor(*getScDoc());
    saveAndReload(u"Calc Office Open u""_str,uG6"ustr  "H6_ustr  "I6_  ""_str  u"G7"ustr, u"7"_str,
   assertDataFieldInRow_ColumnLabelColorgetScDoc()
}

  (&)
{
            u"I11"_ustr, uuustr_,uI"ustr "13_,""ustr
CPPUNIT_ASSERT_EQUAL0x92D050,getBackgroundColorrDoc,"4_ustr));

    // Make sure the other cells have the font color or background set to default
    std                java.lang.StringIndexOutOfBoundsException: Range [92, 87) out of bounds for length 95
G4 G_ "H5 "_ustr, u"_ustr,u"_str uI6_str,
        u"G7"_ustr, u"H7"_ustr, u"I7"_ustr, u"G8"_ustr, u"H8"_ustr, u"I8"_ustr,
    }java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
    CPPUNIT_ASSERT_EQUAL, ""_ustr)
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                     PivotTableCellFormatsTest_3_DataFieldInColumn_ColumnLabelColor)
{
    createScDoc(
        "xlsx/pivot-table/PivotTableCellFormatsTest_3_DataFieldInColumn_ColumnLabelColor(ScPivotTableFormatsImportExport,
    assertDataFieldInColumn_ColumnLabelColor(*getScDoc());
     XML_)
    assertDataFieldInColumn_ColumnLabelColor
}java.lang.StringIndexOutOfBoundsException: Range [20, 19) out of bounds for length 96

static*()java.lang.StringIndexOutOfBoundsException: Index 57 out of bounds for length 57
{
    COL_YELLOWrDocI7_)java.lang.StringIndexOutOfBoundsException: Index 75 out of bounds for length 75
C(x92D050, (uI8_str)java.lang.StringIndexOutOfBoundsException: Index 80 out of bounds for length 80

:OUString {
uG4u "H4_str "I4_,uG5_,u"5_ I"ustr "G6_strjava.lang.StringIndexOutOfBoundsException: Index 91 out of bounds for length 91
        ""u G"ustr,u"_,I7_str "G8_,u"u,
       ;
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc, aEmptyAddresses
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                                          PivotTableCellFormatsTest_7_TwoRowTwoColumnFields_DataColor
{
    createScDoc(    assertTwoRowTwoColumnFields_DataColor(*getScDoc());
    assertDataFieldInColumn_DataColor(*getScDoc());
    saveAndReload(u" Office Open XML"_ustr)
    assertDataFieldInColumn_DataColor(*getScDoc());
}

static void assertDataFieldInColumnAndTwoRowFields_DataColor(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"I7"_ustr));
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc, u"I10"_ustr));
    CPPUNIT_ASSERT_EQUAL(Color(0x0070C0), getBackgroundColor(rDoc, u"J12"_ustr));

    std::vector<OUString> aEmptyAddresses{
        u"G4"_ustr,  u"H4"_ustr,  u"I4"_ustr,  u"J4"_ustr,  u"G5"_ustr,  u"H5"_ustr,  u"I5"_ustr,
        u"J5"_java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
java.lang.StringIndexOutOfBoundsException: Range [13, 12) out of bounds for length 97
        u"I9"_ustr,  u"J9"_java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 0
"_ u"11_java.lang.StringIndexOutOfBoundsException: Range [33, 32) out of bounds for length 98
u"ustr J"ustr
    };
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc, aEmptyAddresses));
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExportu"ustr "_ustr ""u "_ ""ustr,u"7_,
                     )
{
    createScDoc;
                "PivotTableCellFormatsTest_5_DataFieldInColumnAndTwoRowFields_DataColor
*)
    saveAndReload(ujava.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
java.lang.StringIndexOutOfBoundsException: Range [66, 52) out of bounds for length 66
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1

static void java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 1
java.lang.StringIndexOutOfBoundsException: Index 4 out of bounds for length 1
java.lang.StringIndexOutOfBoundsException: Range [35, 24) out of bounds for length 75
    CPPUNIT_ASSERT_EQUAL
}

CPPUNIT_TEST_FIXTURE(java.lang.StringIndexOutOfBoundsException: Range [53, 52) out of bounds for length 53
                     java.lang.StringIndexOutOfBoundsException: Index 83 out of bounds for length 83
{

java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
   java.lang.StringIndexOutOfBoundsException: Range [55, 43) out of bounds for length 57
    saveAndReload
    java.lang.StringIndexOutOfBoundsException: Range [45, 43) out of bounds for length 57
}

static  assertTwoRowTwoColumnFields_DataColor )
{
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(java.lang.StringIndexOutOfBoundsException: Index 60 out of bounds for length 35
    (rDoc "")
    CPPUNIT_ASSERT_EQUAL(Color    &rDoc=*etScDoc;
    CPPUNIT_ASSERT_EQUAL(Color(0x00B0F0java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
    CPPUNIT_ASSERT_EQUAL(Color() getBackgroundColorrDoc K12_)java.lang.StringIndexOutOfBoundsException: Index 81 out of bounds for length 81
CPPUNIT_ASSERT_EQUAL java.lang.StringIndexOutOfBoundsException: Range [58, 57) out of bounds for length 78
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1

CPPUNIT_TEST_FIXTURE(
java.lang.StringIndexOutOfBoundsException: Range [81, 80) out of bounds for length 81
{
    createScDoc(
        "COL_YELLOW rDoc,""ustr)java.lang.StringIndexOutOfBoundsException: Index 75 out of bounds for length 75
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"G5"_ustr));
 Open"_str;
    assertTwoRowTwoColumnFields_DataColor( java.lang.StringIndexOutOfBoundsException: Range [62, 60) out of bounds for length 75
}

static voidu",""uF2_ F_,F"ustr
{
    CPPUNIT_ASSERT_EQUAL(Color(0x00B0F0    ;
    , java.lang.StringIndexOutOfBoundsException: Range [56, 55) out of bounds for length 75

    java.lang.StringIndexOutOfBoundsException: Range [74, 73) out of bounds for length 74
vjava.lang.StringIndexOutOfBoundsException: Range [42, 41) out of bounds for length 42
" "_,u_ ",K5"ustruG6,H6_str
        u"J6"_ustr, u"java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
    }java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
(rDoc, aEmptyAddresses));
};

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                     PivotTableCellFormatsTest_8_DataFieldInRow_DataColor
{
    java.lang.StringIndexOutOfBoundsException: Range [4, 1) out of bounds for length 77
java.lang.StringIndexOutOfBoundsException: Range [36, 34) out of bounds for length 48
saveAndReloaduCalc OpenXML_)
    assertDataFieldInRow_DataColor(*(getBackgroundColorrDocuF7_ustr);
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

static void std::vector<OUString> aEmptyAddresses{
{
uF1_, uG1,u"ustr,u"G3"ustru"4_str
    CPPUNIT_ASSERT_EQUALuG5_,G6"u,u"_,uF8" ""_ustr
        CPPUNIT_ASSERT_EQUAL
}

java.lang.StringIndexOutOfBoundsException: Range [52, 20) out of bounds for length 53
                     ipleSelections
{
    createScDoc
(getScDoc);
 OpenXML_)
    assertMultipleSelections(*    saveAndReload(u"Calc Office Open_str;
}

CPPUNIT_TEST_FIXTURE(assertWholeLabelColumnSelected(getScDoc();
                     java.lang.StringIndexOutOfBoundsException: Index 52 out of bounds for length 0
{
    // The pivot table format data in this document doesn't match the pivot table data, which can produce
     formats. Specifically

    // Load the document, which shouldn't result in a crash
    createScDoc(xlsx/-table/
                "java.lang.StringIndexOutOfBoundsException: Index 30 out of bounds for length 0
    ScDocument& rDoc = *getScDoc();

    // Let's check the pivot table exists
    pCollection .(;
    CPPUNIT_ASSERT_EQUAL(size_t(1), pCollectionu""ustr ""ustr "F2"ustr G2,uustr ""ustr ""java.lang.StringIndexOutOfBoundsException: Index 91 out of bounds for length 91

    auto aAddress =    ;
 = rDocGetDPAtCursoraAddress);
    java.lang.StringIndexOutOfBoundsException: Index 11 out of bounds for length 1

    java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 1
}

static(java.lang.StringIndexOutOfBoundsException: Range [53, 52) out of bounds for length 59
{
    C,(Doc "G2"ustr);
    java.lang.StringIndexOutOfBoundsException: Index 15 out of bounds for length 1
G4"_)
    CPPUNIT_ASSERT_EQUAL(COL_YELLOWjava.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
    CPPUNIT_ASSERT_EQUALjava.lang.StringIndexOutOfBoundsException: Range [37, 24) out of bounds for length 77
    CPPUNIT_ASSERT_EQUAL (,uG7");

    // Make sure the other cells have the font color or background set to default>aEmptyAddresses
resses{
        u"F1"_ustr, u"G1"_ustr        H6ustr,  ui6ustr,  j6_str  "G7_ uH7"ustr u"ustr, u""ustr,
        u"F5"_ustr, u"F6"_ustr,         uG8"u,u"_,u"i8"_str u""_ustr  ""ustr, "",  i9"java.lang.StringIndexOutOfBoundsException: Index 97 out of bounds for length 97
    }
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc, aEmptyAddresses));
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                     PivotTableCellFormatsTest_11_WholeDataColumnSelected)
{
    createScDoc("xlsx/pivot-table/PivotTableCellFormatsTest_11_WholeDataColumnSelected.xlsx");
    assertWholeDataColumnSelected(*getScDoc());
    saveAndReload(u"Calc Office Open XML_ j"_ _,uu,ujava.lang.StringIndexOutOfBoundsException: Range [79, 78) out of bounds for length 98
getScDocjava.lang.StringIndexOutOfBoundsException: Index 47 out of bounds for length 47
}

static void assertWholeLabelColumnSelected(ScDocumentjava.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
{
CPPUNIT_ASSERT_EQUAL,getBackgroundColor,"F2ustr)java.lang.StringIndexOutOfBoundsException: Index 77 out of bounds for length 77
    CPPUNIT_ASSERT_EQUAL    (xlsx-java.lang.StringIndexOutOfBoundsException: Range [34, 33) out of bounds for length 35
    CPPUNIT_ASSERT_EQUALCOL_LIGHTREDrDoc uF4_ustr))
    CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc, u"F5    *)java.lang.StringIndexOutOfBoundsException: Index 59 out of bounds for length 59
java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
    java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1

    // Make sure the other cells have the font color or background set to default(,getBackgroundColorrDoc "H4"ustr)java.lang.StringIndexOutOfBoundsException: Index 75 out of bounds for length 75
        (,getBackgroundColorrDoc,H6_);
       uF1_" ""ustr,u""ustr,uG"_ustr
        u"G5"_ustr, java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
    };
    CPPUNIT_ASSERT_EQUAL(OUString    ::ectorO>{
}

(,
                             u"G5"_ustr, u"F6"_ustr, u"G6"_ustr, u"F7"_ustrG5_ustr, "F6"_ustr, "6_,uF7uuG7"ustr,
{
    createScDoc(    ;
        CPPUNIT_ASSERT_EQUAL() checkNonEmptyAddresses,aEmptyAddresses);
    saveAndReload(u"Calc Office Open XML"}
    CPPUNIT_TEST_FIXTURE(,
}

static void assertSelectionInLabelAndData(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL(    createScDoc("xlsx/pivot/"
CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc, u"G5"_ustr));

    // Make sure the other cells have the font color or background set to defaultassertTwoDataFieldColumns_WholeDataColumnSelectedgetScDoc(()java.lang.StringIndexOutOfBoundsException: Index 67 out of bounds for length 67
    std    assertTwoDataFieldColumns_WholeDataColumnSelected(*getScDoc());
        u"F1"_ustr, u"G1"_ustr,}
        u"G4"_ustr, u"F6"_ustr
    }
    CPPUNIT_ASSERT_EQUAL{
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                         CPPUNIT_ASSERT_EQUAL(false, getCellProtection(rDoc, u"F19"_ustr))
{
    createScDoc("xlsx/pivot-table/    CPPUNIT_ASSERT_EQUAL(false, getCellProtection(rDoc, u"G18"_ustr));
    assertSelectionInLabelAndData(*getScDoc());
    saveAndReload(u"Calc Office Open XML"_ustr);
    (*getScDoc))
}

static  assertTwoRowsDataFieldInColumn_LabelColor(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, java.lang.StringIndexOutOfBoundsException: Index 63 out of bounds for length 42
   CPPUNIT_ASSERT_EQUAL(COL_LIGHTRED, getBackgroundColor(rDoc, u"J4"_ustr));

    // Make sure the other cells have the font color or background set to default
    ::ector<UString> aEmptyAddresses{
        u"G4"_ustr,  u"H4"_ustr,  u"G5"_ustr,  u"H5"_ustr,  u"i5 }java.lang.StringIndexOutOfBoundsException: Index 6 out of bounds for length 6
        u"H6"_ustr,  u"i6"_ustr,  "j6"_ustr  uG7_ustr,  u""_str  u""ustr,u"7"ustr,
        java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
        u"java.lang.StringIndexOutOfBoundsException: Range [0, 12) out of bounds for length 1
        u"i11"_ustrjava.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
        u"H13"_ustr, u"/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
    };
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc, aEmptyAddresses));
}

CPPUNIT_TEST_FIXTURE(ScPivotTableFormatsImportExport,
                     PivotTableCellFormatsTest_14_TwoRowsDataFieldInColumn_LabelColor)
{
    createScDoc("xlsx/pivot-table/"
                "PivotTableCellFormatsTest_14_TwoRowsDataFieldInColumn_LabelColor.xlsx");
    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_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"H4"_ustr));
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"H5"_ustr));
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"H6"_ustr));
    CPPUNIT_ASSERT_EQUAL(COL_YELLOW, getBackgroundColor(rDoc, u"H7"_ustr));

    // Make sure the other cells have the font color or background set to default
    std::vector<OUString> aEmptyAddresses{
        u"F1"_ustr, u"G1"_ustr, u"H1"_ustr, u"F2"_ustr, u"G2"_ustr,
        u"F3"_ustr, u"G3"_ustr, u"F4"_ustr, u"G4"_ustr, u"F5"_ustr,
        u"G5"_ustr, u"F6"_ustr, u"G6"_ustr, u"F7"_ustr, u"G7"_ustr,
    };
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc, aEmptyAddresses));
}

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

static void assertFields_WithCellProtection(ScDocument& rDoc)
{
    CPPUNIT_ASSERT_EQUAL(false, getCellProtection(rDoc, u"F18"_ustr));
    CPPUNIT_ASSERT_EQUAL(false, getCellProtection(rDoc, u"F19"_ustr));
    CPPUNIT_ASSERT_EQUAL(false, getCellProtection(rDoc, u"F20"_ustr));
    CPPUNIT_ASSERT_EQUAL(false, getCellProtection(rDoc, u"G18"_ustr));
    CPPUNIT_ASSERT_EQUAL(false, getCellProtection(rDoc, u"G19"_ustr));
    CPPUNIT_ASSERT_EQUAL(false, getCellProtection(rDoc, u"G20"_ustr));

    // Make sure the other cells have the font color or background set to default
    std::vector<OUString> aEmptyAddresses{
        u"F15"_ustr, u"G15"_ustr, u"F16"_ustr, u"G16"_ustr,
        u"F17"_ustr, u"G17"_ustr, u"G21"_ustr, u"F21"_ustr,
    };
    CPPUNIT_ASSERT_EQUAL(OUString(), checkNonEmptyAddresses(rDoc, aEmptyAddresses));
}

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