test/source/sheet/spreadsheetviewsettings.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4; fill-column: 100 -*- */
   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 <test/sheet/spreadsheetviewsettings.hxx>
  11
  12 #include <com/sun/star/beans/XPropertySet.hpp>
  13 #include <com/sun/star/util/Color.hpp>
  14 #include <com/sun/star/uno/Any.hxx>
  15 #include <com/sun/star/uno/Reference.hxx>
  16
  17 #include <cppunit/TestAssert.h>
  18
  19 using namespace com::sun::star;
  20 using namespace com::sun::star::uno;
  21
  22 namespace apitest
  23 {
  24 void SpreadsheetViewSettings::testSpreadsheetViewSettingsProperties()
  25 {
  26     uno::Reference<beans::XPropertySet> xSpreadsheetViewSettings(init(), UNO_QUERY_THROW);
  27     OUString propName;
  28     uno::Any aNewValue;
  29
  30     propName = "ShowFormulas";
  31     bool aShowFormulas = true;
  32     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowFormulas);
  33     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue ShowFormulas", !aShowFormulas);
  34
  35     aNewValue <<= true;
  36     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
  37     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowFormulas);
  38     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue ShowFormulas", aShowFormulas);
  39
  40     propName = "ShowZeroValues";
  41     bool aShowZeroValues = false;
  42     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowZeroValues);
  43     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue ShowZeroValues", aShowZeroValues);
  44
  45     aNewValue <<= false;
  46     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
  47     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowZeroValues);
  48     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue ShowZeroValues", !aShowZeroValues);
  49
  50     propName = "IsValueHighlightingEnabled";
  51     bool aIsValueHighlightingEnabled = true;
  52     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName)
  53                    >>= aIsValueHighlightingEnabled);
  54     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue IsValueHighlightingEnabled",
  55                            !aIsValueHighlightingEnabled);
  56
  57     aNewValue <<= true;
  58     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
  59     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName)
  60                    >>= aIsValueHighlightingEnabled);
  61     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue IsValueHighlightingEnabled",
  62                            aIsValueHighlightingEnabled);
  63
  64     propName = "ShowNotes";
  65     bool aShowNotes = false;
  66     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowNotes);
  67     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue ShowNotes", aShowNotes);
  68
  69     aNewValue <<= false;
  70     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
  71     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowNotes);
  72     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue ShowNotes", !aShowNotes);
  73
  74     propName = "HasVerticalScrollBar";
  75     bool aHasVerticalScrollBar = false;
  76     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aHasVerticalScrollBar);
  77     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue HasVerticalScrollBar",
  78                            aHasVerticalScrollBar);
  79
  80     aNewValue <<= false;
  81     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
  82     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aHasVerticalScrollBar);
  83     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue HasVerticalScrollBar",
  84                            !aHasVerticalScrollBar);
  85
  86     propName = "HasHorizontalScrollBar";
  87     bool aHasHorizontalScrollBar = false;
  88     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName)
  89                    >>= aHasHorizontalScrollBar);
  90     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue HasHorizontalScrollBar",
  91                            aHasHorizontalScrollBar);
  92
  93     aNewValue <<= false;
  94     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
  95     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName)
  96                    >>= aHasHorizontalScrollBar);
  97     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue HasHorizontalScrollBar",
  98                            !aHasHorizontalScrollBar);
  99
 100     propName = "HasSheetTabs";
 101     bool aHasSheetTabs = false;
 102     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aHasSheetTabs);
 103     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue HasSheetTabs", aHasSheetTabs);
 104
 105     aNewValue <<= false;
 106     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 107     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aHasSheetTabs);
 108     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue HasSheetTabs", !aHasSheetTabs);
 109
 110     propName = "IsOutlineSymbolsSet";
 111     bool aIsOutlineSymbolsSet = false;
 112     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aIsOutlineSymbolsSet);
 113     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue IsOutlineSymbolsSet", aIsOutlineSymbolsSet);
 114
 115     aNewValue <<= false;
 116     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 117     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aIsOutlineSymbolsSet);
 118     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue IsOutlineSymbolsSet",
 119                            !aIsOutlineSymbolsSet);
 120
 121     propName = "HasColumnRowHeaders";
 122     bool aHasColumnRowHeaders = false;
 123     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aHasColumnRowHeaders);
 124     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue HasColumnRowHeaders", aHasColumnRowHeaders);
 125
 126     aNewValue <<= false;
 127     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 128     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aHasColumnRowHeaders);
 129     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue HasColumnRowHeaders",
 130                            !aHasColumnRowHeaders);
 131
 132     propName = "ShowGrid";
 133     bool aShowGrid = false;
 134     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowGrid);
 135     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue ShowGrid", aShowGrid);
 136
 137     aNewValue <<= false;
 138     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 139     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowGrid);
 140     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue ShowGrid", !aShowGrid);
 141
 142     propName = "GridColor";
 143     util::Color aGridColor;
 144     xSpreadsheetViewSettings->getPropertyValue(propName) >>= aGridColor;
 145     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to get PropertyValue GridColor", sal_Int32(12632256),
 146                                  aGridColor);
 147
 148     aNewValue <<= sal_Int32(42);
 149     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 150     xSpreadsheetViewSettings->getPropertyValue(propName) >>= aGridColor;
 151     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set PropertyValue GridColor", sal_Int32(42),
 152                                  aGridColor);
 153
 154     propName = "ShowHelpLines";
 155     bool aShowHelpLines = true;
 156     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowHelpLines);
 157     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue ShowHelpLines", !aShowHelpLines);
 158
 159     aNewValue <<= true;
 160     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 161     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowHelpLines);
 162     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue ShowHelpLines", aShowHelpLines);
 163
 164     propName = "ShowAnchor";
 165     bool aShowAnchor = false;
 166     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowAnchor);
 167     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue ShowAnchor", aShowAnchor);
 168
 169     aNewValue <<= false;
 170     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 171     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowAnchor);
 172     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue ShowAnchor", !aShowAnchor);
 173
 174     propName = "ShowPageBreaks";
 175     bool aShowPageBreaks = false;
 176     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowPageBreaks);
 177     CPPUNIT_ASSERT_MESSAGE("Unable to get PropertyValue ShowPageBreaks", aShowPageBreaks);
 178
 179     aNewValue <<= false;
 180     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 181     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowPageBreaks);
 182     CPPUNIT_ASSERT_MESSAGE("Unable to set PropertyValue ShowPageBreaks", !aShowPageBreaks);
 183
 184     propName = "ShowObjects";
 185     sal_Int16 aShowObjects = 42;
 186     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowObjects);
 187     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to get PropertyValue ShowObjects", sal_Int16(0),
 188                                  aShowObjects);
 189
 190     aNewValue <<= sal_Int16(1);
 191     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 192     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowObjects);
 193     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set PropertyValue ShowObjects", sal_Int16(1),
 194                                  aShowObjects);
 195
 196     propName = "ShowCharts";
 197     sal_Int16 aShowCharts = 42;
 198     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowCharts);
 199     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to get PropertyValue ShowCharts", sal_Int16(0),
 200                                  aShowCharts);
 201
 202     aNewValue <<= sal_Int16(1);
 203     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 204     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowCharts);
 205     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set PropertyValue ShowCharts", sal_Int16(1),
 206                                  aShowCharts);
 207
 208     propName = "ShowDrawing";
 209     sal_Int16 aShowDrawing = 42;
 210     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowDrawing);
 211     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to get PropertyValue ShowDrawing", sal_Int16(0),
 212                                  aShowDrawing);
 213
 214     aNewValue <<= sal_Int16(1);
 215     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 216     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aShowDrawing);
 217     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set PropertyValue ShowDrawing", sal_Int16(1),
 218                                  aShowDrawing);
 219
 220     propName = "ZoomType";
 221     sal_Int16 aZoomType = 42;
 222     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aZoomType);
 223     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to get PropertyValue ZoomType", sal_Int16(3), aZoomType);
 224
 225     aNewValue <<= sal_Int16(1);
 226     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 227     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aZoomType);
 228     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set PropertyValue ZoomType", sal_Int16(1), aZoomType);
 229
 230     propName = "ZoomValue";
 231     sal_Int16 aZoomValue = 42;
 232     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aZoomValue);
 233
 234     aNewValue <<= sal_Int16(1);
 235     xSpreadsheetViewSettings->setPropertyValue(propName, aNewValue);
 236     CPPUNIT_ASSERT(xSpreadsheetViewSettings->getPropertyValue(propName) >>= aZoomValue);
 237     CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set PropertyValue ZoomValue", sal_Int16(1), aZoomValue);
 238 }
 239 }
 240
 241 /* vim:set shiftwidth=4 softtabstop=4 expandtab cinoptions=b1,g0,N-s cinkeys+=0=break: */