diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:54:39 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:54:39 +0000 |
| commit | 267c6f2ac71f92999e969232431ba04678e7437e (patch) | |
| tree | 358c9467650e1d0a1d7227a21dac2e3d08b622b2 /sc/qa/unit/uicalc | |
| parent | Initial commit. (diff) | |
| download | libreoffice-267c6f2ac71f92999e969232431ba04678e7437e.tar.xz libreoffice-267c6f2ac71f92999e969232431ba04678e7437e.zip | |
Adding upstream version 4:24.2.0.upstream/4%24.2.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sc/qa/unit/uicalc')
62 files changed, 3756 insertions, 0 deletions
diff --git a/sc/qa/unit/uicalc/data/autosum.ods b/sc/qa/unit/uicalc/data/autosum.ods Binary files differnew file mode 100644 index 0000000000..05fa934b75 --- /dev/null +++ b/sc/qa/unit/uicalc/data/autosum.ods diff --git a/sc/qa/unit/uicalc/data/simpleTable.xlsx b/sc/qa/unit/uicalc/data/simpleTable.xlsx Binary files differnew file mode 100644 index 0000000000..fd4e394732 --- /dev/null +++ b/sc/qa/unit/uicalc/data/simpleTable.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf100582.xls b/sc/qa/unit/uicalc/data/tdf100582.xls Binary files differnew file mode 100644 index 0000000000..24886a2fe6 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf100582.xls diff --git a/sc/qa/unit/uicalc/data/tdf108292.ods b/sc/qa/unit/uicalc/data/tdf108292.ods Binary files differnew file mode 100644 index 0000000000..6f698fb712 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf108292.ods diff --git a/sc/qa/unit/uicalc/data/tdf108654.ods b/sc/qa/unit/uicalc/data/tdf108654.ods Binary files differnew file mode 100644 index 0000000000..761e8cf2a3 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf108654.ods diff --git a/sc/qa/unit/uicalc/data/tdf112735.ods b/sc/qa/unit/uicalc/data/tdf112735.ods Binary files differnew file mode 100644 index 0000000000..2bb75fc5a5 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf112735.ods diff --git a/sc/qa/unit/uicalc/data/tdf112884.ods b/sc/qa/unit/uicalc/data/tdf112884.ods Binary files differnew file mode 100644 index 0000000000..a39a1789ef --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf112884.ods diff --git a/sc/qa/unit/uicalc/data/tdf118189.xlsx b/sc/qa/unit/uicalc/data/tdf118189.xlsx Binary files differnew file mode 100644 index 0000000000..5208b9de9b --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf118189.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf118983.ods b/sc/qa/unit/uicalc/data/tdf118983.ods Binary files differnew file mode 100644 index 0000000000..3c10a7fd16 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf118983.ods diff --git a/sc/qa/unit/uicalc/data/tdf119155.xlsx b/sc/qa/unit/uicalc/data/tdf119155.xlsx Binary files differnew file mode 100644 index 0000000000..8deb480f79 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf119155.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf119793.ods b/sc/qa/unit/uicalc/data/tdf119793.ods Binary files differnew file mode 100644 index 0000000000..e303bed018 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf119793.ods diff --git a/sc/qa/unit/uicalc/data/tdf120660.ods b/sc/qa/unit/uicalc/data/tdf120660.ods Binary files differnew file mode 100644 index 0000000000..fd9c3defd3 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf120660.ods diff --git a/sc/qa/unit/uicalc/data/tdf122232.ods b/sc/qa/unit/uicalc/data/tdf122232.ods Binary files differnew file mode 100644 index 0000000000..23dc98f613 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf122232.ods diff --git a/sc/qa/unit/uicalc/data/tdf123052.ods b/sc/qa/unit/uicalc/data/tdf123052.ods Binary files differnew file mode 100644 index 0000000000..b87c73d880 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf123052.ods diff --git a/sc/qa/unit/uicalc/data/tdf124815.ods b/sc/qa/unit/uicalc/data/tdf124815.ods Binary files differnew file mode 100644 index 0000000000..06dd840ef9 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf124815.ods diff --git a/sc/qa/unit/uicalc/data/tdf124816.xlsx b/sc/qa/unit/uicalc/data/tdf124816.xlsx Binary files differnew file mode 100644 index 0000000000..890c9de8e0 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf124816.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf124818.xls b/sc/qa/unit/uicalc/data/tdf124818.xls Binary files differnew file mode 100644 index 0000000000..2e5656978a --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf124818.xls diff --git a/sc/qa/unit/uicalc/data/tdf124820.xlsx b/sc/qa/unit/uicalc/data/tdf124820.xlsx Binary files differnew file mode 100644 index 0000000000..60d5027167 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf124820.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf124822.xls b/sc/qa/unit/uicalc/data/tdf124822.xls Binary files differnew file mode 100644 index 0000000000..2e5656978a --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf124822.xls diff --git a/sc/qa/unit/uicalc/data/tdf126541_GridOff.xlsx b/sc/qa/unit/uicalc/data/tdf126541_GridOff.xlsx Binary files differnew file mode 100644 index 0000000000..e27089b016 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf126541_GridOff.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf126541_GridOffGlobally.ods b/sc/qa/unit/uicalc/data/tdf126541_GridOffGlobally.ods Binary files differnew file mode 100644 index 0000000000..389fe347d4 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf126541_GridOffGlobally.ods diff --git a/sc/qa/unit/uicalc/data/tdf126685.ods b/sc/qa/unit/uicalc/data/tdf126685.ods Binary files differnew file mode 100644 index 0000000000..bb08e47635 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf126685.ods diff --git a/sc/qa/unit/uicalc/data/tdf128914.ods b/sc/qa/unit/uicalc/data/tdf128914.ods Binary files differnew file mode 100644 index 0000000000..7e9bdfd3de --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf128914.ods diff --git a/sc/qa/unit/uicalc/data/tdf130614.ods b/sc/qa/unit/uicalc/data/tdf130614.ods Binary files differnew file mode 100644 index 0000000000..7f66dff55b --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf130614.ods diff --git a/sc/qa/unit/uicalc/data/tdf131455-fixed.ods b/sc/qa/unit/uicalc/data/tdf131455-fixed.ods Binary files differnew file mode 100644 index 0000000000..08e02804bf --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf131455-fixed.ods diff --git a/sc/qa/unit/uicalc/data/tdf132026.ods b/sc/qa/unit/uicalc/data/tdf132026.ods Binary files differnew file mode 100644 index 0000000000..03c6c654fd --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf132026.ods diff --git a/sc/qa/unit/uicalc/data/tdf132057.ods b/sc/qa/unit/uicalc/data/tdf132057.ods Binary files differnew file mode 100644 index 0000000000..cc6b319c9f --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf132057.ods diff --git a/sc/qa/unit/uicalc/data/tdf132431.ods b/sc/qa/unit/uicalc/data/tdf132431.ods Binary files differnew file mode 100644 index 0000000000..2022a9db4f --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf132431.ods diff --git a/sc/qa/unit/uicalc/data/tdf133326.ods b/sc/qa/unit/uicalc/data/tdf133326.ods Binary files differnew file mode 100644 index 0000000000..102f169bd5 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf133326.ods diff --git a/sc/qa/unit/uicalc/data/tdf133342.ods b/sc/qa/unit/uicalc/data/tdf133342.ods Binary files differnew file mode 100644 index 0000000000..3632784f78 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf133342.ods diff --git a/sc/qa/unit/uicalc/data/tdf136113.xlsx b/sc/qa/unit/uicalc/data/tdf136113.xlsx Binary files differnew file mode 100644 index 0000000000..a811e91b93 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf136113.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf138432.ods b/sc/qa/unit/uicalc/data/tdf138432.ods Binary files differnew file mode 100644 index 0000000000..31b2e2309d --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf138432.ods diff --git a/sc/qa/unit/uicalc/data/tdf138710.ods b/sc/qa/unit/uicalc/data/tdf138710.ods Binary files differnew file mode 100644 index 0000000000..2a815a7cc3 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf138710.ods diff --git a/sc/qa/unit/uicalc/data/tdf140151.ods b/sc/qa/unit/uicalc/data/tdf140151.ods Binary files differnew file mode 100644 index 0000000000..6c908b7596 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf140151.ods diff --git a/sc/qa/unit/uicalc/data/tdf142010.xls b/sc/qa/unit/uicalc/data/tdf142010.xls Binary files differnew file mode 100644 index 0000000000..c58bc0169f --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf142010.xls diff --git a/sc/qa/unit/uicalc/data/tdf144022.ods b/sc/qa/unit/uicalc/data/tdf144022.ods Binary files differnew file mode 100644 index 0000000000..0ebc22d62f --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf144022.ods diff --git a/sc/qa/unit/uicalc/data/tdf144244.ods b/sc/qa/unit/uicalc/data/tdf144244.ods Binary files differnew file mode 100644 index 0000000000..0d4487955e --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf144244.ods diff --git a/sc/qa/unit/uicalc/data/tdf145640.ods b/sc/qa/unit/uicalc/data/tdf145640.ods Binary files differnew file mode 100644 index 0000000000..34b5017927 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf145640.ods diff --git a/sc/qa/unit/uicalc/data/tdf146795.ods b/sc/qa/unit/uicalc/data/tdf146795.ods Binary files differnew file mode 100644 index 0000000000..9c402b0583 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf146795.ods diff --git a/sc/qa/unit/uicalc/data/tdf147744.ods b/sc/qa/unit/uicalc/data/tdf147744.ods Binary files differnew file mode 100644 index 0000000000..cd8904c657 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf147744.ods diff --git a/sc/qa/unit/uicalc/data/tdf148669.xlsx b/sc/qa/unit/uicalc/data/tdf148669.xlsx Binary files differnew file mode 100644 index 0000000000..ac26349139 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf148669.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf149502_HangOnDeletingSheet1.ods b/sc/qa/unit/uicalc/data/tdf149502_HangOnDeletingSheet1.ods Binary files differnew file mode 100644 index 0000000000..e34a75c323 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf149502_HangOnDeletingSheet1.ods diff --git a/sc/qa/unit/uicalc/data/tdf149503.xls b/sc/qa/unit/uicalc/data/tdf149503.xls Binary files differnew file mode 100644 index 0000000000..88e4fb4ad6 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf149503.xls diff --git a/sc/qa/unit/uicalc/data/tdf150499.xls b/sc/qa/unit/uicalc/data/tdf150499.xls Binary files differnew file mode 100644 index 0000000000..1b7289a6ee --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf150499.xls diff --git a/sc/qa/unit/uicalc/data/tdf150766.ods b/sc/qa/unit/uicalc/data/tdf150766.ods Binary files differnew file mode 100644 index 0000000000..64088d19d0 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf150766.ods diff --git a/sc/qa/unit/uicalc/data/tdf152037.xlsx b/sc/qa/unit/uicalc/data/tdf152037.xlsx Binary files differnew file mode 100644 index 0000000000..b6d482e99b --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf152037.xlsx diff --git a/sc/qa/unit/uicalc/data/tdf153669.ods b/sc/qa/unit/uicalc/data/tdf153669.ods Binary files differnew file mode 100644 index 0000000000..ccd211abcb --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf153669.ods diff --git a/sc/qa/unit/uicalc/data/tdf154991.ods b/sc/qa/unit/uicalc/data/tdf154991.ods Binary files differnew file mode 100644 index 0000000000..bcbd42a170 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf154991.ods diff --git a/sc/qa/unit/uicalc/data/tdf156286.ods b/sc/qa/unit/uicalc/data/tdf156286.ods Binary files differnew file mode 100644 index 0000000000..9049e8170d --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf156286.ods diff --git a/sc/qa/unit/uicalc/data/tdf156462.ods b/sc/qa/unit/uicalc/data/tdf156462.ods Binary files differnew file mode 100644 index 0000000000..3f77ac3be0 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf156462.ods diff --git a/sc/qa/unit/uicalc/data/tdf157897_linked.ods b/sc/qa/unit/uicalc/data/tdf157897_linked.ods Binary files differnew file mode 100644 index 0000000000..bb75c31d82 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf157897_linked.ods diff --git a/sc/qa/unit/uicalc/data/tdf157897_main.ods b/sc/qa/unit/uicalc/data/tdf157897_main.ods Binary files differnew file mode 100644 index 0000000000..1e1af57514 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf157897_main.ods diff --git a/sc/qa/unit/uicalc/data/tdf68290.ods b/sc/qa/unit/uicalc/data/tdf68290.ods Binary files differnew file mode 100644 index 0000000000..e8047a372b --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf68290.ods diff --git a/sc/qa/unit/uicalc/data/tdf81351.ods b/sc/qa/unit/uicalc/data/tdf81351.ods Binary files differnew file mode 100644 index 0000000000..7888ce008d --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf81351.ods diff --git a/sc/qa/unit/uicalc/data/tdf86166.ods b/sc/qa/unit/uicalc/data/tdf86166.ods Binary files differnew file mode 100644 index 0000000000..21fb067639 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf86166.ods diff --git a/sc/qa/unit/uicalc/data/tdf86305.ods b/sc/qa/unit/uicalc/data/tdf86305.ods Binary files differnew file mode 100644 index 0000000000..fac69aa230 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf86305.ods diff --git a/sc/qa/unit/uicalc/data/tdf90694.ods b/sc/qa/unit/uicalc/data/tdf90694.ods Binary files differnew file mode 100644 index 0000000000..dfb427102d --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf90694.ods diff --git a/sc/qa/unit/uicalc/data/tdf92963.ods b/sc/qa/unit/uicalc/data/tdf92963.ods Binary files differnew file mode 100644 index 0000000000..a407653448 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf92963.ods diff --git a/sc/qa/unit/uicalc/data/tdf97215.ods b/sc/qa/unit/uicalc/data/tdf97215.ods Binary files differnew file mode 100644 index 0000000000..e6b01a67b3 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf97215.ods diff --git a/sc/qa/unit/uicalc/data/tdf99913.xlsx b/sc/qa/unit/uicalc/data/tdf99913.xlsx Binary files differnew file mode 100644 index 0000000000..3fd18a1298 --- /dev/null +++ b/sc/qa/unit/uicalc/data/tdf99913.xlsx diff --git a/sc/qa/unit/uicalc/uicalc.cxx b/sc/qa/unit/uicalc/uicalc.cxx new file mode 100644 index 0000000000..15795bacea --- /dev/null +++ b/sc/qa/unit/uicalc/uicalc.cxx @@ -0,0 +1,2157 @@ +/* -*- 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 "../helper/qahelper.hxx" +#include <LibreOfficeKit/LibreOfficeKitEnums.h> +#include <unotools/syslocaleoptions.hxx> +#include <vcl/keycodes.hxx> +#include <vcl/scheduler.hxx> + +#include <comphelper/processfactory.hxx> +#include <comphelper/propertysequence.hxx> +#include <comphelper/scopeguard.hxx> +#include <comphelper/servicehelper.hxx> +#include <com/sun/star/awt/Key.hpp> +#include <com/sun/star/sheet/GlobalSheetSettings.hpp> +#include <conditio.hxx> +#include <document.hxx> +#include <docsh.hxx> +#include <dpobject.hxx> +#include <formulaopt.hxx> +#include <inputopt.hxx> +#include <postit.hxx> +#include <rangeutl.hxx> +#include <scmod.hxx> +#include <tabvwsh.hxx> +#include <viewdata.hxx> + +using namespace ::com::sun::star; + +class ScUiCalcTest : public ScModelTestBase +{ +public: + ScUiCalcTest(); +}; + +ScUiCalcTest::ScUiCalcTest() + : ScModelTestBase("sc/qa/unit/uicalc/data") +{ +} + +static void lcl_AssertCurrentCursorPosition(ScDocShell& rDocSh, std::u16string_view rStr) +{ + ScAddress aAddr; + sal_Int32 nOffset = 0; + ScRangeStringConverter::GetAddressFromString(aAddr, rStr, rDocSh.GetDocument(), + formula::FormulaGrammar::CONV_OOO, nOffset); + ScTabViewShell* pViewShell = rDocSh.GetBestViewShell(false); + CPPUNIT_ASSERT_EQUAL_MESSAGE( + OUString(OUString::Concat("Incorrect Column in position ") + rStr).toUtf8().getStr(), + aAddr.Col(), pViewShell->GetViewData().GetCurX()); + CPPUNIT_ASSERT_EQUAL_MESSAGE( + OUString(OUString::Concat("Incorrect Row in position ") + rStr).toUtf8().getStr(), + aAddr.Row(), pViewShell->GetViewData().GetCurY()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf142854_GridVisibilityImportXlsxInHeadlessMode) +{ + // Tests are running in Headless mode + // Import an ods file with 'Hide' global grid visibility setting. + createScDoc("tdf126541_GridOffGlobally.ods"); + ScDocument* pDoc = getScDoc(); + CPPUNIT_ASSERT(!pDoc->GetViewOptions().GetOption(VOPT_GRID)); + + // To avoid regression, in headless mode leave the bug tdf126541 + // It means Sheet based grid line visibility setting will overwrite the global setting. + // If there is only 1 sheet in the document, it will not result visible problems. + createScDoc("tdf126541_GridOff.xlsx"); + pDoc = getScDoc(); + CPPUNIT_ASSERT(!pDoc->GetViewOptions().GetOption(VOPT_GRID)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testExternalReferences) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"2015"); + insertStringToCell("A2", u"2015"); + insertStringToCell("A3", u"2015"); + + insertStringToCell("B1", u"1"); + insertStringToCell("B2", u"1"); + insertStringToCell("B3", u"2"); + + insertStringToCell("C1", u"10"); + insertStringToCell("C2", u"20"); + insertStringToCell("C3", u"5"); + + insertStringToCell("D1", u"BIG FISH"); + insertStringToCell("D2", u"FISHFISH"); + insertStringToCell("D3", u"FISHY"); + + // Save the document + save("calc8"); + + // Open a new document + createScDoc(); + pDoc = getScDoc(); + + // Insert the references to the external document + { + // tdf#115162 + OUString aFormula = "=SUMIFS('" + maTempFile.GetURL() + "'#$Sheet1.C1:C3,'" + + maTempFile.GetURL() + "'#$Sheet1.B1:B3,1,'" + maTempFile.GetURL() + + "'#$Sheet1.A1:A3,2015)"; + insertStringToCell("A1", aFormula); + + // tdf#115162: Without the fix in place, this test would have failed with + // - Expected: 30 + // - Actual : Err:504 + CPPUNIT_ASSERT_EQUAL(OUString("30"), pDoc->GetString(ScAddress(0, 0, 0))); + } + + { + // tdf#114820 + OUString aFormula = "=VLOOKUP('" + maTempFile.GetURL() + "'#$Sheet1.A1;'" + + maTempFile.GetURL() + "'#$Sheet1.A1:B3,2,0)"; + insertStringToCell("A1", aFormula); + + // Without the fix in place, this test would have failed with + // - Expected: 1 + // - Actual : Err:504 + CPPUNIT_ASSERT_EQUAL(OUString("1"), pDoc->GetString(ScAddress(0, 0, 0))); + } + + { + // tdf#116149 + OUString aFormula = "=VAR('" + maTempFile.GetURL() + "'#$Sheet1.C1;'" + maTempFile.GetURL() + + "'#$Sheet1.C2)"; + insertStringToCell("A1", aFormula); + + // Without the fix in place, this test would have failed with + // - Expected: 50 + // - Actual : Err:504 + CPPUNIT_ASSERT_EQUAL(OUString("50"), pDoc->GetString(ScAddress(0, 0, 0))); + } + + { + // tdf#100847 + // Use an empty cell + OUString aFormula = "=+'" + maTempFile.GetURL() + "'#$Sheet1.A1000"; + insertStringToCell("A1", aFormula); + + aFormula = "=+'" + maTempFile.GetURL() + "'#$Sheet1.A1000*1"; + insertStringToCell("B1", aFormula); + + aFormula = "=+N('" + maTempFile.GetURL() + "'#$Sheet1.A1000)*1"; + insertStringToCell("C1", aFormula); + + CPPUNIT_ASSERT_EQUAL(OUString("0"), pDoc->GetString(ScAddress(0, 0, 0))); + + // Without the fix in place, this test would have failed with + // - Expected: 0 + // - Actual : #VALUE! + CPPUNIT_ASSERT_EQUAL(OUString("0"), pDoc->GetString(ScAddress(1, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("0"), pDoc->GetString(ScAddress(2, 0, 0))); + } + + { + //tdf#36387 + OUString aAndFormula = "=AND('" + maTempFile.GetURL() + "'#$Sheet1.A1:C1)"; + insertStringToCell("A1", aAndFormula); + + OUString aOrFormula = "=OR('" + maTempFile.GetURL() + "'#$Sheet1.A1:C1)"; + insertStringToCell("B1", aOrFormula); + + // Without the fix in place, this test would have failed with + // - Expected: TRUE + // - Actual : Err:504 + CPPUNIT_ASSERT_EQUAL(OUString("TRUE"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("TRUE"), pDoc->GetString(ScAddress(1, 0, 0))); + } + + { + //tdf#113898 + OUString aAndFormula = "=SUMPRODUCT(NOT(ISERROR(FIND(\"FISH\";'" + maTempFile.GetURL() + + "'#$Sheet1.D1:D3))))"; + insertStringToCell("A1", aAndFormula); + + // Without the fix in place, this test would have failed with + // - Expected: 3 + // - Actual : 1 + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(0, 0, 0))); + } +} + +#if !defined(MACOSX) && !defined(_WIN32) //FIXME +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf151886) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + // Set the system locale to German + SvtSysLocaleOptions aOptions; + OUString sLocaleConfigString = aOptions.GetLanguageTag().getBcp47(); + aOptions.SetLocaleConfigString("de-DE"); + aOptions.Commit(); + comphelper::ScopeGuard g([&aOptions, &sLocaleConfigString] { + aOptions.SetLocaleConfigString(sLocaleConfigString); + aOptions.Commit(); + }); + + insertStringToCell("A1", u"=1,1"); + + insertStringToCell("A2", u"=1.1"); + + CPPUNIT_ASSERT_EQUAL(OUString("1,1"), pDoc->GetString(0, 0, 0)); + CPPUNIT_ASSERT_EQUAL(OUString("#NAME?"), pDoc->GetString(0, 1, 0)); + + // change UseEnglishFuncName to true + ScDocShell* pDocSh = getScDocShell(); + ScFormulaOptions aFormulaOptions = SC_MOD()->GetFormulaOptions(); + bool bOldStatus = aFormulaOptions.GetUseEnglishFuncName(); + aFormulaOptions.SetUseEnglishFuncName(true); + pDocSh->SetFormulaOptions(aFormulaOptions); + + insertStringToCell("A1", u"=1,1"); + + insertStringToCell("A2", u"=1.1"); + + // Without the fix in place, this test would have failed with + // - Expected: 1,1 + // - Actual : #NAME? + CPPUNIT_ASSERT_EQUAL(OUString("1,1"), pDoc->GetString(0, 0, 0)); + CPPUNIT_ASSERT_EQUAL(OUString("#NAME?"), pDoc->GetString(0, 1, 0)); + + aFormulaOptions.SetUseEnglishFuncName(bOldStatus); + pDocSh->SetFormulaOptions(aFormulaOptions); +} +#endif + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf103994) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"1"); + insertStringToCell("B1", u"2"); + + // Save the document + save("calc8"); + + // Open a new document + createScDoc(); + pDoc = getScDoc(); + + // Insert the reference to the external document + OUString aFormula = "='" + maTempFile.GetURL() + "'#$Sheet1.A1"; + insertStringToCell("A1", aFormula); + + CPPUNIT_ASSERT_EQUAL(aFormula, pDoc->GetFormula(0, 0, 0)); + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(0, 0, 0))); + + goToCell("A1"); + + dispatchCommand(mxComponent, ".uno:Cut", {}); + + goToCell("B1"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + // Without the fix in place, this test would have failed with + // - Expected: ='file:///tmp/lu124171irlmb.tmp'#$Sheet1.A1 + // - Actual : ='file:///tmp/lu124171irlmb.tmp'#$Sheet1.B1 + CPPUNIT_ASSERT_EQUAL(aFormula, pDoc->GetFormula(1, 0, 0)); + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(1, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf113541) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"50"); + + // Save the document + save("calc8"); + + // Open a new document + createScDoc(); + pDoc = getScDoc(); + + // Change grammar to Excel A1 + FormulaGrammarSwitch aFGSwitch(pDoc, formula::FormulaGrammar::GRAM_ENGLISH_XL_A1); + + // Insert the reference to the external document + OUString aFormula = "=['" + maTempFile.GetURL() + "']Sheet1!A1"; + insertStringToCell("A1", aFormula); + + // Without the fix in place, this test would have failed with + // - Expected: 50 + // - Actual : Err:507 + CPPUNIT_ASSERT_EQUAL(OUString("50"), pDoc->GetString(ScAddress(0, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf126577) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + goToCell("A1:A20"); + + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "FillDir", uno::Any(OUString("B")) }, + { "FillCmd", uno::Any(OUString("L")) }, + { "FillStep", uno::Any(OUString("1")) }, + { "FillDateCmd", uno::Any(OUString("D")) }, + { "FillStart", uno::Any(OUString("1")) }, + { "FillMax", uno::Any(OUString("10")) } })); + dispatchCommand(mxComponent, ".uno:FillSeries", aArgs); + + for (size_t i = 0; i < 10; ++i) + { + CPPUNIT_ASSERT_EQUAL(OUString(OUString::number(i + 1)), + pDoc->GetString(ScAddress(0, i, 0))); + } + + for (size_t i = 10; i < 20; ++i) + { + // Without the fix in place, this test would have failed with + // - Expected: + // - Actual : #NUM! + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, i, 0))); + } +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf107869) +{ + // Without the fix in place, this test would have crashed + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"A"); + insertStringToCell("A2", u"B"); + + // Add a new comment to A1 and A2 + uno::Sequence<beans::PropertyValue> aArgs + = comphelper::InitPropertySequence({ { "Text", uno::Any(OUString("Comment")) } }); + + goToCell("A1"); + dispatchCommand(mxComponent, ".uno:InsertAnnotation", aArgs); + + goToCell("A2"); + dispatchCommand(mxComponent, ".uno:InsertAnnotation", aArgs); + + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be a note on A2", pDoc->HasNote(ScAddress(0, 1, 0))); + + goToCell("A1"); + + dispatchCommand(mxComponent, ".uno:SelectRow", {}); + + dispatchCommand(mxComponent, ".uno:DeleteRows", {}); + + for (size_t i = 0; i < 10; ++i) + { + CPPUNIT_ASSERT_EQUAL(OUString("B"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be no note on A2", !pDoc->HasNote(ScAddress(0, 1, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("A"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("B"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be a note on A2", pDoc->HasNote(ScAddress(0, 1, 0))); + + dispatchCommand(mxComponent, ".uno:Redo", {}); + } + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + goToCell("A1:A2"); + + dispatchCommand(mxComponent, ".uno:SelectRow", {}); + + dispatchCommand(mxComponent, ".uno:DeleteRows", {}); + + for (size_t i = 0; i < 10; ++i) + { + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be no note on A1", !pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be no note on A2", !pDoc->HasNote(ScAddress(0, 1, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("A"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("B"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be a note on A2", pDoc->HasNote(ScAddress(0, 1, 0))); + + dispatchCommand(mxComponent, ".uno:Redo", {}); + } +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf63805) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"2012-10-31"); + + goToCell("A1:A20"); + + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "FillDir", uno::Any(OUString("B")) }, + { "FillCmd", uno::Any(OUString("D")) }, + { "FillStep", uno::Any(OUString("1")) }, + { "FillDateCmd", uno::Any(OUString("M")) }, + { "FillStart", uno::Any(OUString("41213")) } })); + dispatchCommand(mxComponent, ".uno:FillSeries", aArgs); + + CPPUNIT_ASSERT_EQUAL(OUString("2012-10-31"), pDoc->GetString(ScAddress(0, 0, 0))); + + // Without the fix in place, this test would have failed with + // - Expected: 2012-11-30 + // - Actual : 2012-12-01 + CPPUNIT_ASSERT_EQUAL(OUString("2012-11-30"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2012-12-31"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-01-31"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-02-28"), pDoc->GetString(ScAddress(0, 4, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-03-31"), pDoc->GetString(ScAddress(0, 5, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-04-30"), pDoc->GetString(ScAddress(0, 6, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-05-31"), pDoc->GetString(ScAddress(0, 7, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-06-30"), pDoc->GetString(ScAddress(0, 8, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-07-31"), pDoc->GetString(ScAddress(0, 9, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-08-31"), pDoc->GetString(ScAddress(0, 10, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-09-30"), pDoc->GetString(ScAddress(0, 11, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-10-31"), pDoc->GetString(ScAddress(0, 12, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-11-30"), pDoc->GetString(ScAddress(0, 13, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2013-12-31"), pDoc->GetString(ScAddress(0, 14, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2014-01-31"), pDoc->GetString(ScAddress(0, 15, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2014-02-28"), pDoc->GetString(ScAddress(0, 16, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2014-03-31"), pDoc->GetString(ScAddress(0, 17, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2014-04-30"), pDoc->GetString(ScAddress(0, 18, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2014-05-31"), pDoc->GetString(ScAddress(0, 19, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("2012-10-31"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf147894) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + //Select the first row + goToCell("1:1"); + + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "FillDir", uno::Any(OUString("R")) }, + { "FillCmd", uno::Any(OUString("L")) }, + { "FillStep", uno::Any(OUString("1")) }, + { "FillDateCmd", uno::Any(OUString("D")) }, + { "FillStart", uno::Any(OUString("1")) } })); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:FillSeries", aArgs); + + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(16384.0, pDoc->GetValue(ScAddress(16383, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf94208) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"=COUNTA(B:B)"); + insertStringToCell("A3", u"Range"); + insertStringToCell("A4", u"Range"); + insertStringToCell("A5", u"Range"); + insertStringToCell("A6", u"Range"); + insertStringToCell("A7", u"Range"); + insertStringToCell("A8", u"Range"); + insertStringToCell("B6", u"Test"); + + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(0, 0, 0))); + + goToCell("A3:A8"); + + dispatchCommand(mxComponent, ".uno:SelectRow", {}); + + //type Control-D/Fill Down + dispatchCommand(mxComponent, ".uno:FillDown", {}); + + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(0, 0, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + // Without the fix in place, this test would have failed with + // - Expected: 1 + // - Actual : 0 + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(0, 0, 0))); + + for (SCROW i = 2; i < 8; ++i) + { + CPPUNIT_ASSERT_EQUAL(OUString("Range"), pDoc->GetString(ScAddress(0, i, 0))); + } + + CPPUNIT_ASSERT_EQUAL(OUString("Test"), pDoc->GetString(ScAddress(1, 5, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf37623) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + goToCell("A3:A4"); + + dispatchCommand(mxComponent, ".uno:HideRow", {}); + + insertStringToCell("A2", u"1"); + + goToCell("A2:A6"); + + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "FillDir", uno::Any(OUString("B")) }, + { "FillCmd", uno::Any(OUString("A")) }, + { "FillStep", uno::Any(OUString("1")) }, + { "FillDateCmd", uno::Any(OUString("M")) } })); + dispatchCommand(mxComponent, ".uno:FillSeries", aArgs); + + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(0, 4, 0))); + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(0, 5, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf144308) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + css::uno::Reference<css::sheet::XGlobalSheetSettings> xGlobalSheetSettings + = css::sheet::GlobalSheetSettings::create(::comphelper::getProcessComponentContext()); + bool bOldValue = xGlobalSheetSettings->getDoAutoComplete(); + + xGlobalSheetSettings->setDoAutoComplete(true); + + insertStringToCell("A1", u"ABC"); + + insertStringToCell("A2", u"A"); + + CPPUNIT_ASSERT_EQUAL(OUString("ABC"), pDoc->GetString(ScAddress(0, 1, 0))); + + xGlobalSheetSettings->setDoAutoComplete(false); + + insertStringToCell("A3", u"A"); + + // Without the fix in place, this test would have failed with + // - Expected: A + // - Actual : ABC + CPPUNIT_ASSERT_EQUAL(OUString("A"), pDoc->GetString(ScAddress(0, 2, 0))); + + // Restore the previous value + xGlobalSheetSettings->setDoAutoComplete(bOldValue); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf56036) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + goToCell("A1"); + + typeString(u"=SUM( 1 + 2 "); + + // Insert Newline + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_MOD1 | awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_MOD1 | awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + typeString(u"+ 3)"); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, this test would have failed with + // - Expected: 6 + // - Actual : Err:501 + CPPUNIT_ASSERT_EQUAL(OUString("6"), pDoc->GetString(ScAddress(0, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf154174_repeat_empty) +{ + createScDoc(); + + insertStringToCell("A1", u"aaaa"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_MOD1 | KEY_SHIFT | awt::Key::Y); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_MOD1 | KEY_SHIFT | awt::Key::Y); + Scheduler::ProcessEventsToIdle(); + + ScDocument* pDoc = getScDoc(); + CPPUNIT_ASSERT_EQUAL(OUString("aaaa"), pDoc->GetString(ScAddress(0, 1, 0))); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::F2); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::F2); + Scheduler::ProcessEventsToIdle(); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DELETE); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DELETE); + Scheduler::ProcessEventsToIdle(); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, this test would have failed with + // - Expected: aaaa + // - Actual : + CPPUNIT_ASSERT_EQUAL(OUString("aaaa"), pDoc->GetString(ScAddress(0, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf119162) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + goToCell("A1"); + + typeString(u"Test"); + + // Insert Newline + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_MOD1 | awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_MOD1 | awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + CPPUNIT_ASSERT_EQUAL(OUString(u"Test" + OUStringChar(u'\xA')), + pDoc->GetString(ScAddress(0, 0, 0))); + + goToCell("A1"); + + // Without the fix in place, this test would have hung here + dispatchCommand(mxComponent, ".uno:ChangeCaseRotateCase", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(u"Test" + OUStringChar(u'\xA')), + pDoc->GetString(ScAddress(0, 0, 0))); + + dispatchCommand(mxComponent, ".uno:ChangeCaseToLower", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(u"test" + OUStringChar(u'\xA')), + pDoc->GetString(ScAddress(0, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf90579) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"2300"); + insertStringToCell("A2", u"Libre"); + insertStringToCell("B1", u"10"); + insertStringToCell("B2", u"Office"); + insertStringToCell("C1", u"=SUM(A1:B1)"); + insertStringToCell("C2", u"=A2&B2"); + + CPPUNIT_ASSERT_EQUAL(OUString("2310"), pDoc->GetString(ScAddress(2, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("LibreOffice"), pDoc->GetString(ScAddress(2, 1, 0))); + + goToCell("C1:C2"); + + dispatchCommand(mxComponent, ".uno:ConvertFormulaToValue", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("2310"), pDoc->GetString(ScAddress(2, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("LibreOffice"), pDoc->GetString(ScAddress(2, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetFormula(2, 0, 0)); + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetFormula(2, 1, 0)); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("2310"), pDoc->GetString(ScAddress(2, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("LibreOffice"), pDoc->GetString(ScAddress(2, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A1:B1)"), pDoc->GetFormula(2, 0, 0)); + CPPUNIT_ASSERT_EQUAL(OUString("=A2&B2"), pDoc->GetFormula(2, 1, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf124820) +{ + createScDoc("tdf124820.xlsx"); + ScDocument* pDoc = getScDoc(); + + goToCell("B2"); + + dispatchCommand(mxComponent, ".uno:Strikeout", {}); + + saveAndReload("Calc Office Open XML"); + pDoc = getScDoc(); + + vcl::Font aFont; + const ScPatternAttr* pPattern = pDoc->GetPattern(1, 1, 0); + pPattern->fillFontOnly(aFont); + + // Without the fix in place, this test would have failed here + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should be striked out", STRIKEOUT_SINGLE, + aFont.GetStrikeout()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf132026) +{ + createScDoc("tdf132026.ods"); + ScDocument* pDoc = getScDoc(); + std::vector<std::u16string_view> aChars{ u"=", u"+", u"-" }; + std::vector<sal_uInt16> aDirections{ KEY_UP, KEY_DOWN, KEY_LEFT, KEY_RIGHT }; + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + for (auto aChar = aChars.begin(); aChar != aChars.end(); ++aChar) + { + for (size_t i = 0; i < aDirections.size(); ++i) + { + goToCell("B2"); + typeString(*aChar); + + sal_uInt16 nDir = aDirections[i]; + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, nDir); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, nDir); + Scheduler::ProcessEventsToIdle(); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + sal_Int16 nSign = (*aChar == u"-") ? -1 : 1; + sal_Int16 nExpected = nSign * (i + 1); + OUString sExpectedResult = OUString::number(nExpected); + CPPUNIT_ASSERT_EQUAL(sExpectedResult, pDoc->GetString(ScAddress(1, 1, 0))); + + goToCell("E2"); + typeString(*aChar); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, nDir); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, nDir); + Scheduler::ProcessEventsToIdle(); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, this test would have failed with + // - Expected: = + // - Actual : =E1 + CPPUNIT_ASSERT_EQUAL(OUString(*aChar), pDoc->GetString(ScAddress(4, 1, 0))); + } + } +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf152037) +{ + createScDoc("tdf152037.xlsx"); + + insertStringToCell("C2", u"abcdefghi"); + + ScDocument* pDoc = getScDoc(); + + // Without the fix in place, this test would have failed with + // - Expected: abcdefghi + // - Actual : + CPPUNIT_ASSERT_EQUAL(OUString("abcdefghi"), pDoc->GetString(ScAddress(2, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf119155) +{ + createScDoc("tdf119155.xlsx"); + ScDocument* pDoc = getScDoc(); + + goToCell("C2:C14"); + + // Without the fix in place, this test would have hung here + dispatchCommand(mxComponent, ".uno:ChangeCaseToTitleCase", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("Collagene Expert Targeted Wrinkle Corrector Unboxed 10 Ml"), + pDoc->GetString(ScAddress(2, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("Vitamina Suractivee Hand Cream 400 Ml"), + pDoc->GetString(ScAddress(2, 13, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf146795) +{ + createScDoc("tdf146795.ods"); + ScDocument* pDoc = getScDoc(); + + // Disable replace cell warning + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetReplaceCellsWarn(); + aInputOption.SetReplaceCellsWarn(false); + pMod->SetInputOptions(aInputOption); + + goToCell("B2"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Move to B3 + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN); + Scheduler::ProcessEventsToIdle(); + + // Select the three following cells + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_SHIFT | KEY_DOWN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_SHIFT | KEY_DOWN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_SHIFT | KEY_DOWN); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("a"), pDoc->GetString(ScAddress(1, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("a"), pDoc->GetString(ScAddress(1, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("a"), pDoc->GetString(ScAddress(1, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("44"), pDoc->GetString(ScAddress(1, 4, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("44"), pDoc->GetString(ScAddress(1, 5, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("a"), pDoc->GetString(ScAddress(1, 6, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("a"), pDoc->GetString(ScAddress(1, 7, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("44"), pDoc->GetString(ScAddress(1, 8, 0))); + + // Restore previous status + aInputOption.SetReplaceCellsWarn(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf147744) +{ + createScDoc("tdf147744.ods"); + ScDocument* pDoc = getScDoc(); + + // Disable replace cell warning + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetReplaceCellsWarn(); + aInputOption.SetReplaceCellsWarn(false); + pMod->SetInputOptions(aInputOption); + + goToCell("A2"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Move to A3 + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN); + Scheduler::ProcessEventsToIdle(); + + // Select the following cell + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_SHIFT | KEY_DOWN); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(0, 4, 0))); + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(0, 5, 0))); + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(0, 6, 0))); + + // Restore previous status + aInputOption.SetReplaceCellsWarn(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf138432) +{ + createScDoc("tdf138432.ods"); + ScDocument* pDoc = getScDoc(); + + // Set the system locale to Hungarian + SvtSysLocaleOptions aOptions; + OUString sLocaleConfigString = aOptions.GetLanguageTag().getBcp47(); + aOptions.SetLocaleConfigString("hu-HU"); + aOptions.Commit(); + comphelper::ScopeGuard g([&aOptions, &sLocaleConfigString] { + aOptions.SetLocaleConfigString(sLocaleConfigString); + aOptions.Commit(); + }); + + OUString sExpectedA1 = "12" + OUStringChar(u'\xa0') + "345,67"; + CPPUNIT_ASSERT_EQUAL(sExpectedA1, pDoc->GetString(ScAddress(0, 0, 0))); + + goToCell("A1"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("A2"); + + typeString(u"="); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, this test would have failed with + // - Expected: 12345,67 + // - Actual : Err:509 + CPPUNIT_ASSERT_EQUAL(OUString("12345,67"), pDoc->GetString(ScAddress(0, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf143896) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A2000", u"Test"); + + CPPUNIT_ASSERT_EQUAL(OUString("Test"), pDoc->GetString(ScAddress(0, 1999, 0))); + + saveAndReload("Calc Office Open XML"); + pDoc = getScDoc(); + + // Without the fix in place, this test would have failed with + // - Expected: Test + // - Actual : + CPPUNIT_ASSERT_EQUAL(OUString("Test"), pDoc->GetString(ScAddress(0, 1999, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf145085) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertArrayToCell("A1", u"=HYPERLINK(\"a\";\"b\")"); + + CPPUNIT_ASSERT_EQUAL(OUString("b"), pDoc->GetString(ScAddress(0, 0, 0))); + + // Without the fix in place, this test would have failed with + // - Expected: + // - Actual : a + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf154125) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertArrayToCell("A1", u"=INDEX({11;21},0,1)"); + + CPPUNIT_ASSERT_EQUAL(OUString("11"), pDoc->GetString(ScAddress(0, 0, 0))); + + // Without the fix in place, this test would have failed with + // - Expected: 21 + // - Actual : + CPPUNIT_ASSERT_EQUAL(OUString("21"), pDoc->GetString(ScAddress(0, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf148863) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertArrayToCell("A1", u"=TRANSPOSE(IF({0|0|0}=0;RANDBETWEEN.NV(1;1000000)))"); + + double nA1 = pDoc->GetValue(ScAddress(0, 0, 0)); + double nB1 = pDoc->GetValue(ScAddress(1, 0, 0)); + double nC1 = pDoc->GetValue(ScAddress(2, 0, 0)); + + // Without the fix in place, this test would have failed here + CPPUNIT_ASSERT(nA1 != nB1); + CPPUNIT_ASSERT(nA1 != nC1); + CPPUNIT_ASSERT(nB1 != nC1); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf144244) +{ + createScDoc("tdf144244.ods"); + ScDocument* pDoc = getScDoc(); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + uno::Reference<drawing::XDrawPage> xPage(pModelObj->getDrawPages()->getByIndex(0), + uno::UNO_QUERY_THROW); + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(2), xPage->getCount()); + + // Select column A and B + goToCell("A:B"); + + dispatchCommand(mxComponent, ".uno:DeleteColumns", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("x"), pDoc->GetString(ScAddress(0, 0, 0))); + + // Without the fix in place, this test would have crashed + saveAndReload("calc8"); + pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(OUString("x"), pDoc->GetString(ScAddress(0, 0, 0))); + + xPage.set(pModelObj->getDrawPages()->getByIndex(0), uno::UNO_QUERY_THROW); + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(2), xPage->getCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf153669) +{ + createScDoc("tdf153669.ods"); + ScDocument* pDoc = getScDoc(); + + // Disable replace cell warning + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetReplaceCellsWarn(); + aInputOption.SetReplaceCellsWarn(false); + pMod->SetInputOptions(aInputOption); + + insertStringToCell("E2", u"100"); + + CPPUNIT_ASSERT_EQUAL(OUString("110.00"), pDoc->GetString(ScAddress(5, 1, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("15.00"), pDoc->GetString(ScAddress(5, 1, 0))); + + goToCell("E7"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("F7"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("text"), pDoc->GetString(ScAddress(5, 6, 0))); + + insertStringToCell("E2", u"100"); + + // Without the fix in place, this test would have failed with + // - Expected: 110.00 + // - Actual : 15.00 + CPPUNIT_ASSERT_EQUAL(OUString("110.00"), pDoc->GetString(ScAddress(5, 1, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("15.00"), pDoc->GetString(ScAddress(5, 1, 0))); + + // Restore previous status + aInputOption.SetReplaceCellsWarn(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf100582) +{ + createScDoc("tdf100582.xls"); + ScDocument* pDoc = getScDoc(); + + // Disable replace cell warning + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetReplaceCellsWarn(); + aInputOption.SetReplaceCellsWarn(false); + pMod->SetInputOptions(aInputOption); + + goToCell("C10"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("C10:H14"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + saveAndReload("MS Excel 97"); + pDoc = getScDoc(); + + OUString aFormula = pDoc->GetFormula(3, 10, 0); + + // Without the fix in place, this test would have failed with + // - Expected: {=SUM(($B$3:$B$7=$B11)*(D$3:D$7))} + //- Actual : + CPPUNIT_ASSERT_EQUAL(OUString("{=SUM(($B$3:$B$7=$B11)*(D$3:D$7))}"), aFormula); + aFormula = pDoc->GetFormula(4, 10, 0); + CPPUNIT_ASSERT_EQUAL(OUString("{=SUM(($B$3:$B$7=$B11)*(E$3:E$7))}"), aFormula); + aFormula = pDoc->GetFormula(5, 10, 0); + CPPUNIT_ASSERT_EQUAL(OUString("{=SUM(($B$3:$B$7=$B11)*(F$3:F$7))}"), aFormula); + aFormula = pDoc->GetFormula(6, 10, 0); + CPPUNIT_ASSERT_EQUAL(OUString("{=SUM(($B$3:$B$7=$B11)*(G$3:G$7))}"), aFormula); + aFormula = pDoc->GetFormula(7, 10, 0); + CPPUNIT_ASSERT_EQUAL(OUString("{=SUM(($B$3:$B$7=$B11)*(H$3:H$7))}"), aFormula); + + // Restore previous status + aInputOption.SetReplaceCellsWarn(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf145640) +{ + createScDoc("tdf145640.ods"); + ScDocument* pDoc = getScDoc(); + + // Enable sorting with update reference + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetSortRefUpdate(); + aInputOption.SetSortRefUpdate(true); + pMod->SetInputOptions(aInputOption); + + goToCell("A2:F17"); + + dispatchCommand(mxComponent, ".uno:SortDescending", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A15:B15:C15:D15:E15:F15)"), pDoc->GetFormula(6, 3, 0)); + + // Without the fix in place, this test would have failed with + // - Expected: 10 + // - Actual : 0 + CPPUNIT_ASSERT_EQUAL(10.0, pDoc->GetValue(ScAddress(6, 3, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A4:B4:C4:D4:E4:F4)"), pDoc->GetFormula(6, 3, 0)); + CPPUNIT_ASSERT_EQUAL(10.0, pDoc->GetValue(ScAddress(6, 3, 0))); + + // Restore previous status + aInputOption.SetSortRefUpdate(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf97215) +{ + createScDoc("tdf97215.ods"); + ScDocument* pDoc = getScDoc(); + + // Enable sorting with update reference + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetSortRefUpdate(); + aInputOption.SetSortRefUpdate(true); + pMod->SetInputOptions(aInputOption); + + CPPUNIT_ASSERT_EQUAL(OUString("Inserted at bottom"), pDoc->GetString(ScAddress(0, 23, 0))); + + goToCell("A1:M24"); + + // Without the fix in place, this test would have hung here + dispatchCommand(mxComponent, ".uno:SortAscending", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("Inserted at bottom"), pDoc->GetString(ScAddress(0, 0, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("Inserted at bottom"), pDoc->GetString(ScAddress(0, 23, 0))); + + // Restore previous status + aInputOption.SetSortRefUpdate(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf92963) +{ + createScDoc("tdf92963.ods"); + ScDocument* pDoc = getScDoc(); + + // Disable replace cell warning + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetReplaceCellsWarn(); + aInputOption.SetReplaceCellsWarn(false); + pMod->SetInputOptions(aInputOption); + + ScConditionalFormatList* pList = pDoc->GetCondFormList(0); + CPPUNIT_ASSERT_EQUAL(size_t(3), pList->size()); + + goToCell("A3:C4"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("A1:C1"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(size_t(2), pList->size()); + + // Restore previous status + aInputOption.SetReplaceCellsWarn(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +#if !defined(MACOSX) && !defined(_WIN32) //FIXME +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf140151) +{ + createScDoc("tdf140151.ods"); + ScDocShell* pDocSh = getScDocShell(); + + // Focus is already on the button + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, the current cursor position wouldn't have changed + lcl_AssertCurrentCursorPosition(*pDocSh, u"B111"); +} +#endif + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf68290) +{ + createScDoc("tdf68290.ods"); + ScDocShell* pDocSh = getScDocShell(); + + const std::vector<OUString> aExpectedAddresses{ "L3", "L6", "L9", "L10", "L11", "L13", "L15" }; + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + for (const auto& rAddress : aExpectedAddresses) + { + lcl_AssertCurrentCursorPosition(*pDocSh, rAddress); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + } + + lcl_AssertCurrentCursorPosition(*pDocSh, u"M3"); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf156462) +{ + createScDoc("tdf156462.ods"); + ScDocShell* pDocSh = getScDocShell(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"G2"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_MOD1 | KEY_LEFT); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, the cursor would have jumped to cell C2 + lcl_AssertCurrentCursorPosition(*pDocSh, u"D2"); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf132057) +{ + createScDoc("tdf132057.ods"); + ScDocShell* pDocSh = getScDocShell(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"AU43"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_RETURN); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, the cursor would have jumped to cell BM1 + lcl_AssertCurrentCursorPosition(*pDocSh, u"G39"); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf122232) +{ + createScDoc("tdf122232.ods"); + ScDocShell* pDocSh = getScDocShell(); + + //Start with from C6. Press tabulator to reach G6. + lcl_AssertCurrentCursorPosition(*pDocSh, u"C6"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_TAB); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_TAB); + Scheduler::ProcessEventsToIdle(); + lcl_AssertCurrentCursorPosition(*pDocSh, u"G6"); + + //without the fix, cursor would jump to C29 instead of C7. + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + lcl_AssertCurrentCursorPosition(*pDocSh, u"C7"); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf123052) +{ + createScDoc("tdf123052.ods"); + ScDocShell* pDocSh = getScDocShell(); + + std::vector<OUString> aExpectedAddresses{ "F3", "D5", "E5", "F6", "A8", "E9" }; + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + for (const auto& rAddress : aExpectedAddresses) + { + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::TAB); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::TAB); + Scheduler::ProcessEventsToIdle(); + + lcl_AssertCurrentCursorPosition(*pDocSh, rAddress); + } + + aExpectedAddresses.pop_back(); + + for (std::vector<OUString>::reverse_iterator it = aExpectedAddresses.rbegin(); + it != aExpectedAddresses.rend(); ++it) + { + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_SHIFT | awt::Key::TAB); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_SHIFT | awt::Key::TAB); + Scheduler::ProcessEventsToIdle(); + + // Without the fix in place, this test would have failed here + lcl_AssertCurrentCursorPosition(*pDocSh, *it); + } +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf120660) +{ + createScDoc("tdf120660.ods"); + ScDocument* pDoc = getScDoc(); + + // Disable replace cell warning + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetReplaceCellsWarn(); + aInputOption.SetReplaceCellsWarn(false); + pMod->SetInputOptions(aInputOption); + + goToCell("A8:E8"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("A4:E4"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(1200.0, pDoc->GetValue(ScAddress(4, 3, 0))); + CPPUNIT_ASSERT_EQUAL(-100.0, pDoc->GetValue(ScAddress(4, 7, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(2200.0, pDoc->GetValue(ScAddress(4, 3, 0))); + CPPUNIT_ASSERT_EQUAL(900.0, pDoc->GetValue(ScAddress(4, 7, 0))); + + goToCell("A8:D8"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("A4:D4"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(1200.0, pDoc->GetValue(ScAddress(4, 3, 0))); + + // Without the fix in place, this test would have failed with + // - Expected: -100 + // - Actual : 900 + CPPUNIT_ASSERT_EQUAL(-100.0, pDoc->GetValue(ScAddress(4, 7, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(2200.0, pDoc->GetValue(ScAddress(4, 3, 0))); + CPPUNIT_ASSERT_EQUAL(900.0, pDoc->GetValue(ScAddress(4, 7, 0))); + + // Restore previous status + aInputOption.SetReplaceCellsWarn(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf146994) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + + goToCell("B3"); + lcl_AssertCurrentCursorPosition(*pDocSh, u"B3"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_RIGHT); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_RIGHT); + Scheduler::ProcessEventsToIdle(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"D3"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_SHIFT | KEY_DOWN); + Scheduler::ProcessEventsToIdle(); + + ScRangeList aMarkedArea = getViewShell()->GetViewData().GetMarkData().GetMarkedRanges(); + OUString aMarkedAreaString; + ScDocument* pDoc = getScDoc(); + ScRangeStringConverter::GetStringFromRangeList(aMarkedAreaString, &aMarkedArea, pDoc, + formula::FormulaGrammar::CONV_OOO); + + // Without the fix in place, this test would have failed with + // - Expected: Sheet1.D3:Sheet1.D4 + // - Actual : Sheet1.A2:Sheet1.D3 + CPPUNIT_ASSERT_EQUAL(OUString("Sheet1.D3:Sheet1.D4"), aMarkedAreaString); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf157897_duplicated_print_ranges) +{ + createScDoc("tdf157897_main.ods"); + ScDocument* pDoc = getScDoc(); + + const sal_uInt16 nPos = 0; + const SCTAB nFirstTab = 0; + // Ensure that there exists a print range in the first documents tab + CPPUNIT_ASSERT_EQUAL(static_cast<sal_uInt16>(1), pDoc->GetPrintRangeCount(nFirstTab)); + + // Reload all links and check if the print range was not duplicated + const auto initialPrintRange = pDoc->GetPrintRange(nFirstTab, nPos); + pDoc->GetDocumentShell()->ReloadAllLinks(); + + // Without the fix in place, the print range in the linked tab will be duplicated + CPPUNIT_ASSERT_EQUAL(initialPrintRange, pDoc->GetPrintRange(nFirstTab, nPos)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf154991) +{ + createScDoc("tdf154991.ods"); + ScDocument* pDoc = getScDoc(); + + goToCell("A1"); + dispatchCommand(mxComponent, ".uno:SelectColumn", {}); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:HideColumn", {}); + CPPUNIT_ASSERT(pDoc->ColHidden(0, 0)); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + CPPUNIT_ASSERT(!pDoc->ColHidden(0, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf95306) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + // Use Adding Selection + dispatchCommand(mxComponent, ".uno:StatusSelectionModeExp", {}); + + goToCell("B1"); + dispatchCommand(mxComponent, ".uno:SelectColumn", {}); + + dispatchCommand(mxComponent, ".uno:GoRight", {}); + dispatchCommand(mxComponent, ".uno:GoRight", {}); + + dispatchCommand(mxComponent, ".uno:SelectColumn", {}); + + dispatchCommand(mxComponent, ".uno:HideColumn", {}); + + CPPUNIT_ASSERT(!pDoc->ColHidden(0, 0)); + CPPUNIT_ASSERT(pDoc->ColHidden(1, 0)); + CPPUNIT_ASSERT(!pDoc->ColHidden(2, 0)); + CPPUNIT_ASSERT(pDoc->ColHidden(3, 0)); + CPPUNIT_ASSERT(!pDoc->ColHidden(4, 0)); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT(!pDoc->ColHidden(0, 0)); + CPPUNIT_ASSERT(!pDoc->ColHidden(1, 0)); + CPPUNIT_ASSERT(!pDoc->ColHidden(2, 0)); + CPPUNIT_ASSERT(!pDoc->ColHidden(3, 0)); + CPPUNIT_ASSERT(!pDoc->ColHidden(4, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf102525) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"1"); + insertStringToCell("A2", u"2"); + insertStringToCell("A3", u"3"); + insertStringToCell("A4", u"4"); + + insertArrayToCell("B1", u"=IF(A1:A4>2,1,2)"); + goToCell("B1:B4"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_F4); + Scheduler::ProcessEventsToIdle(); + + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(1, 0, 0)); + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(1, 1, 0)); + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(1, 2, 0)); + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(1, 3, 0)); + + CPPUNIT_ASSERT_EQUAL(OUString("{=IF($A$1:$A$4>2,1,2)}"), pDoc->GetFormula(1, 0, 0)); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(1, 0, 0)); + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(1, 1, 0)); + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(1, 2, 0)); + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(1, 3, 0)); + + CPPUNIT_ASSERT_EQUAL(OUString("{=IF(A1:A4>2,1,2)}"), pDoc->GetFormula(1, 0, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf39650) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + FormulaGrammarSwitch aFGSwitch(pDoc, formula::FormulaGrammar::GRAM_ENGLISH_XL_R1C1); + + insertStringToCell("R3C3", u"xxx"); + insertStringToCell("R2C2", u"=R[1]C[1]"); + + CPPUNIT_ASSERT_EQUAL(OUString("=R[1]C[1]"), pDoc->GetFormula(1, 1, 0)); + CPPUNIT_ASSERT_EQUAL(OUString("xxx"), pDoc->GetString(1, 1, 0)); + + goToCell("B2"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_F4); + Scheduler::ProcessEventsToIdle(); + + CPPUNIT_ASSERT_EQUAL(OUString("=R3C3"), pDoc->GetFormula(1, 1, 0)); + CPPUNIT_ASSERT_EQUAL(OUString("xxx"), pDoc->GetString(1, 1, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf45020) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + goToCell("A2:A3"); + + dispatchCommand(mxComponent, ".uno:HideRow", {}); + + goToCell("A1"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_SHIFT | KEY_DOWN); + Scheduler::ProcessEventsToIdle(); + + ScRangeList aMarkedArea = getViewShell()->GetViewData().GetMarkData().GetMarkedRanges(); + OUString aMarkedAreaString; + ScRangeStringConverter::GetStringFromRangeList(aMarkedAreaString, &aMarkedArea, pDoc, + formula::FormulaGrammar::CONV_OOO); + + // Without the fix in place, this test would have failed with + // - Expected: Sheet1.A1:Sheet1.A4 + // - Actual : Sheet1.A1:Sheet1.A2 + CPPUNIT_ASSERT_EQUAL(OUString("Sheet1.A1:Sheet1.A4"), aMarkedAreaString); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf117706) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + + insertStringToCell("A1", u"A1"); + insertStringToCell("A3", u"A3"); + + // Use Adding Selection + dispatchCommand(mxComponent, ".uno:StatusSelectionModeExp", {}); + + goToCell("A1"); + dispatchCommand(mxComponent, ".uno:SelectRow", {}); + + dispatchCommand(mxComponent, ".uno:GoDown", {}); + dispatchCommand(mxComponent, ".uno:GoDown", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"A3"); + + dispatchCommand(mxComponent, ".uno:SelectRow", {}); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Open a new document + createScDoc(); + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + // Without the fix in place, this test would have failed with + // - Expected: A1 + // - Actual : A3 + CPPUNIT_ASSERT_EQUAL(OUString("A1"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("A3"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 2, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf86166) +{ + createScDoc("tdf86166.ods"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(2), pDoc->GetTableCount()); + + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "Index", uno::Any(sal_uInt16(0)) } })); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Remove", aArgs); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(1), pDoc->GetTableCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf149502_HangOnDeletingSheet1) +{ + createScDoc("tdf149502_HangOnDeletingSheet1.ods"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(4), pDoc->GetTableCount()); + + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "Index", uno::Any(sal_uInt16(0)) } })); + + // Before the fix in place, this test frozen here + dispatchCommand(mxComponent, ".uno:Remove", aArgs); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(3), pDoc->GetTableCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf149503) +{ + createScDoc("tdf149503.xls"); + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); + + dispatchCommand(mxComponent, ".uno:Cut", {}); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Paste", {}); + + ScDPCollection* pDPs = pDoc->GetDPCollection(); + CPPUNIT_ASSERT_EQUAL(size_t(1), pDPs->GetCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf108292) +{ + createScDoc("tdf108292.ods"); + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Open a new document + createScDoc(); + pDoc = getScDoc(); + + // Without the fix in place, this test would have crashed + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("2D"), pDoc->GetString(ScAddress(26, 0, 0))); +} + +// Inspired from testTdf117706, test columns instead of rows +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testMultiRangeCol) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + + insertStringToCell("A1", u"A1"); + insertStringToCell("C1", u"C1"); + + // Use Adding Selection + dispatchCommand(mxComponent, ".uno:StatusSelectionModeExp", {}); + + goToCell("A1"); + dispatchCommand(mxComponent, ".uno:SelectColumn", {}); + + dispatchCommand(mxComponent, ".uno:GoRight", {}); + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"C1"); + + dispatchCommand(mxComponent, ".uno:SelectColumn", {}); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Open a new document + createScDoc(); + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("A1"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("C1"), pDoc->GetString(ScAddress(1, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(2, 0, 0))); +} + +// Test the call of .uno:PasteTransposed (tdf#102255) +// Note: the transpose functionality is tested in ucalc +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testPasteTransposed) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"1"); + insertStringToCell("A2", u"a"); + insertStringToCell("A3", u"=A1"); + + // Add a note to A1 + goToCell("A1"); + uno::Sequence<beans::PropertyValue> aArgs + = comphelper::InitPropertySequence({ { "Text", uno::Any(OUString("Note in A1")) } }); + dispatchCommand(mxComponent, ".uno:InsertAnnotation", aArgs); + + // Set A2 bold + goToCell("A2"); + dispatchCommand(mxComponent, ".uno:Bold", {}); + + // Check preconditions + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + const ScPatternAttr* pPattern = pDoc->GetPattern(0, 1, 0); + vcl::Font aFont; + pPattern->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should be bold", WEIGHT_BOLD, aFont.GetWeight()); + + goToCell("A1:A3"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Open a new document + createScDoc(); + pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:PasteTransposed", {}); + + OUString aFormula; + CPPUNIT_ASSERT_EQUAL(OUString("1"), pDoc->GetString(0, 0, 0)); // A1 + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(0, 0, 0)); // A1 + CPPUNIT_ASSERT_EQUAL(OUString("a"), pDoc->GetString(1, 0, 0)); // B1 + aFormula = pDoc->GetFormula(2, 0, 0); // C1 + CPPUNIT_ASSERT_EQUAL(OUString("=A1"), aFormula); // C1 + CPPUNIT_ASSERT_EQUAL(OUString("1"), pDoc->GetString(2, 0, 0)); // C1 + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(2, 0, 0)); // C1 + + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("Note in A1"), pDoc->GetNote(ScAddress(0, 0, 0))->GetText()); + + pPattern = pDoc->GetPattern(1, 0, 0); + pPattern->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should be bold", WEIGHT_BOLD, aFont.GetWeight()); +} + +// Test the call of .uno:PasteAsLink (tdf#90101) +// Note: the paste as link functionality is tested in ucalc +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testPasteAsLink) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"1"); + insertStringToCell("A2", u"a"); + insertStringToCell("A3", u"=A1"); + + // Add a note to A1 + goToCell("A1"); + uno::Sequence<beans::PropertyValue> aArgs + = comphelper::InitPropertySequence({ { "Text", uno::Any(OUString("Note in A1")) } }); + dispatchCommand(mxComponent, ".uno:InsertAnnotation", aArgs); + + // Set A2 bold + goToCell("A2"); + dispatchCommand(mxComponent, ".uno:Bold", {}); + + // Check preconditions + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + const ScPatternAttr* pPattern = pDoc->GetPattern(0, 1, 0); + vcl::Font aFont; + pPattern->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should be bold", WEIGHT_BOLD, aFont.GetWeight()); + + goToCell("A1:A3"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("C1"); + + dispatchCommand(mxComponent, ".uno:PasteAsLink", {}); + + OUString aFormula = pDoc->GetFormula(2, 0, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=$Sheet1.$A$1"), aFormula); // C1 + aFormula = pDoc->GetFormula(2, 1, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=$Sheet1.$A$2"), aFormula); // C2 + aFormula = pDoc->GetFormula(2, 2, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=$Sheet1.$A$3"), aFormula); // C3 + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(2, 0, 0)); // C1 + CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(2, 2, 0)); // C3 + + CPPUNIT_ASSERT_MESSAGE("There should be no note on C1", !pDoc->HasNote(ScAddress(2, 0, 0))); + + pPattern = pDoc->GetPattern(2, 1, 0); + pPattern->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should be normal (cell attributes should not be copied)", + WEIGHT_NORMAL, aFont.GetWeight()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf119659) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertArrayToCell("A1:C1", u"={1,2,3}"); + + insertStringToCell("A2", u"=LOOKUP(3; A1:C1; {1,2})"); + + // Without the fix in place, this test would have crashed here + CPPUNIT_ASSERT_EQUAL(OUString("#N/A"), pDoc->GetString(ScAddress(0, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf131442) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertArrayToCell("A1:A5", u"={6;4;2;5;3}"); + + CPPUNIT_ASSERT_EQUAL(OUString("6"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("4"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("5"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("3"), pDoc->GetString(ScAddress(0, 4, 0))); + + dispatchCommand(mxComponent, ".uno:SortAscending", {}); + + // Without the fix in place, this test would have failed with + // - Expected: 6 + // - Actual : #REF! + CPPUNIT_ASSERT_EQUAL(OUString("6"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("4"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("5"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("3"), pDoc->GetString(ScAddress(0, 4, 0))); + + dispatchCommand(mxComponent, ".uno:SortDescending", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("6"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("4"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("5"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("3"), pDoc->GetString(ScAddress(0, 4, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf117458) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + sal_uInt16 bOldStatus = aInputOption.GetMoveDir(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"A1"); + + aInputOption.SetMoveDir(DIR_BOTTOM); + pMod->SetInputOptions(aInputOption); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"A2"); + + aInputOption.SetMoveDir(DIR_TOP); + pMod->SetInputOptions(aInputOption); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"A1"); + + aInputOption.SetMoveDir(DIR_RIGHT); + pMod->SetInputOptions(aInputOption); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"B1"); + + aInputOption.SetMoveDir(DIR_LEFT); + pMod->SetInputOptions(aInputOption); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); + Scheduler::ProcessEventsToIdle(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"A1"); + + // Restore previous status + aInputOption.SetMoveDir(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf90694) +{ + createScDoc("tdf90694.ods"); + ScDocument* pDoc = getScDoc(); + + // Select row 30 to 60 + goToCell("30:60"); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:DeleteRows", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 29, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 59, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("#REF!"), pDoc->GetString(ScAddress(0, 29, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("#REF!"), pDoc->GetString(ScAddress(0, 59, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf138710) +{ + createScDoc("tdf138710.ods"); + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:DeleteRows", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 0, 1))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("Total"), pDoc->GetString(ScAddress(0, 0, 1))); + + dispatchCommand(mxComponent, ".uno:DeleteRows", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 0, 1))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("Total"), pDoc->GetString(ScAddress(0, 0, 1))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf128914) +{ + createScDoc("tdf128914.ods"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(6.0, pDoc->GetValue(ScAddress(3, 1, 0))); + + goToCell("D2"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("D3:D6"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + // Without the fix in place, this test would have failed with + // - Expected: 24 + // - Actual : 6 + CPPUNIT_ASSERT_EQUAL(24.0, pDoc->GetValue(ScAddress(3, 2, 0))); + CPPUNIT_ASSERT_EQUAL(60.0, pDoc->GetValue(ScAddress(3, 3, 0))); + CPPUNIT_ASSERT_EQUAL(120.0, pDoc->GetValue(ScAddress(3, 4, 0))); + CPPUNIT_ASSERT_EQUAL(210.0, pDoc->GetValue(ScAddress(3, 5, 0))); + + CPPUNIT_ASSERT_EQUAL(6.0, pDoc->GetValue(ScAddress(1, 14, 0))); + + goToCell("B15"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("C15:F15"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(24.0, pDoc->GetValue(ScAddress(2, 14, 0))); + CPPUNIT_ASSERT_EQUAL(60.0, pDoc->GetValue(ScAddress(3, 14, 0))); + CPPUNIT_ASSERT_EQUAL(120.0, pDoc->GetValue(ScAddress(4, 14, 0))); + CPPUNIT_ASSERT_EQUAL(210.0, pDoc->GetValue(ScAddress(5, 14, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf108654) +{ + createScDoc("tdf108654.ods"); + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + insertNewSheet(*pDoc); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + OUString aFormula = pDoc->GetFormula(3, 126, 1); + CPPUNIT_ASSERT_EQUAL(OUString("=VLOOKUP(C127,#REF!,D$1,0)"), aFormula); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + aFormula = pDoc->GetFormula(3, 126, 1); + CPPUNIT_ASSERT_EQUAL(OUString(""), aFormula); + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(2), pDoc->GetTableCount()); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(1), pDoc->GetTableCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf150219) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertNewSheet(*pDoc); + + insertStringToCell("A1", u"=$Sheet1.A1"); + goToCell("A1"); + + CPPUNIT_ASSERT_EQUAL(OUString("0"), pDoc->GetString(ScAddress(0, 0, 1))); + + dispatchCommand(mxComponent, ".uno:ShowPrecedents", {}); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Cut", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 0, 1))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf153790) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"=SUM($Sheet1.B1:C1)"); + + CPPUNIT_ASSERT_EQUAL(OUString("0"), pDoc->GetString(ScAddress(0, 0, 0))); + + goToCell("A1"); + dispatchCommand(mxComponent, ".uno:Copy", {}); + goToCell("A2"); + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("=SUM($Sheet1.B2:C2)"), pDoc->GetFormula(0, 1, 0)); + + goToCell("A1"); + dispatchCommand(mxComponent, ".uno:Cut", {}); + goToCell("A3"); + dispatchCommand(mxComponent, ".uno:Paste", {}); + + // Without the fix in place, this test would have failed with + // - Expected: =SUM($Sheet1.B1:C1) + // - Actual : =SUM($Sheet1.B1:$Sheet1.C1) + CPPUNIT_ASSERT_EQUAL(OUString("=SUM($Sheet1.B1:C1)"), pDoc->GetFormula(0, 2, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testTdf141440) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + // Insert a note to cell A1 + goToCell("A1"); + uno::Sequence<beans::PropertyValue> aArgs + = comphelper::InitPropertySequence({ { "Text", uno::Any(OUString("Note in A1")) } }); + dispatchCommand(mxComponent, ".uno:InsertAnnotation", aArgs); + + // Insert a formula to cell A2 + insertStringToCell("A2", u"=1+1"); + CPPUNIT_ASSERT_EQUAL(OUString("2"), pDoc->GetString(ScAddress(0, 1, 0))); + + // Copy content of A2 to A1 using paste special command as a formula (Flags F) + goToCell("A2"); + dispatchCommand(mxComponent, ".uno:Copy", {}); + goToCell("A1"); + aArgs = comphelper::InitPropertySequence( + { { "Flags", uno::Any(OUString("F")) }, + { "FormulaCommand", uno::Any(sal_uInt16(ScPasteFunc::ADD)) }, + { "SkipEmptyCells", uno::Any(false) }, + { "Transpose", uno::Any(false) }, + { "AsLink", uno::Any(false) }, + { "MoveMode", uno::Any(sal_uInt16(InsCellCmd::INS_NONE)) } }); + dispatchCommand(mxComponent, ".uno:InsertContents", aArgs); + + // Check if string in cell A2 was copied to cell A1 + CPPUNIT_ASSERT_EQUAL(OUString("2"), pDoc->GetString(ScAddress(0, 0, 0))); + // Without the fix in place, there would be no note in cell A1 after using paste special + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("Note in A1"), pDoc->GetNote(ScAddress(0, 0, 0))->GetText()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testKeyboardMergeRef) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + ScTabViewShell* pViewShell = pDocSh->GetBestViewShell(false); + CPPUNIT_ASSERT(pViewShell); + + goToCell("A1:A5"); + dispatchCommand(mxComponent, ".uno:ToggleMergeCells", {}); + goToCell("A6:A10"); + dispatchCommand(mxComponent, ".uno:ToggleMergeCells", {}); + + goToCell("B1"); + typeString(u"="); + + goToCell("A1"); + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN | KEY_SHIFT); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN | KEY_SHIFT); + Scheduler::ProcessEventsToIdle(); + CPPUNIT_ASSERT(pViewShell->IsRefInputMode()); + { + const OUString* pInput = pViewShell->GetEditString(); + CPPUNIT_ASSERT(pInput); + CPPUNIT_ASSERT_EQUAL(OUString("=A1:A10"), *pInput); + } + + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_UP | KEY_SHIFT); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_UP | KEY_SHIFT); + Scheduler::ProcessEventsToIdle(); + CPPUNIT_ASSERT(pViewShell->IsRefInputMode()); + { + const OUString* pInput = pViewShell->GetEditString(); + CPPUNIT_ASSERT(pInput); + CPPUNIT_ASSERT_EQUAL(OUString("=A1:A5"), *pInput); + } +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest, testMouseMergeRef) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + ScTabViewShell* pViewShell = pDocSh->GetBestViewShell(false); + CPPUNIT_ASSERT(pViewShell); + + goToCell("A1:A5"); + dispatchCommand(mxComponent, ".uno:ToggleMergeCells", {}); + goToCell("A6:A10"); + dispatchCommand(mxComponent, ".uno:ToggleMergeCells", {}); + + goToCell("B1"); + typeString(u"="); + + Point aA1 = pViewShell->GetViewData().GetPrintTwipsPos(0, 0); + Point aA6 = pViewShell->GetViewData().GetPrintTwipsPos(0, 5); + Point aA7 = pViewShell->GetViewData().GetPrintTwipsPos(0, 6); + + pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, aA1.X() + 5, aA1.Y() + 5, 1, + MOUSE_LEFT, 0); + pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEMOVE, aA6.X() + 5, aA6.Y() + 5, 1, MOUSE_LEFT, 0); + pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, aA7.X() + 5, aA7.Y() + 5, 1, MOUSE_LEFT, + 0); + Scheduler::ProcessEventsToIdle(); + + CPPUNIT_ASSERT(pViewShell->IsRefInputMode()); + { + const OUString* pInput = pViewShell->GetEditString(); + CPPUNIT_ASSERT(pInput); + CPPUNIT_ASSERT_EQUAL(OUString("=A1:A10"), *pInput); + } +} + +CPPUNIT_PLUGIN_IMPLEMENT(); + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/sc/qa/unit/uicalc/uicalc2.cxx b/sc/qa/unit/uicalc/uicalc2.cxx new file mode 100644 index 0000000000..a488749e98 --- /dev/null +++ b/sc/qa/unit/uicalc/uicalc2.cxx @@ -0,0 +1,1599 @@ +/* -*- 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 "../helper/qahelper.hxx" +#include <editeng/brushitem.hxx> +#include <LibreOfficeKit/LibreOfficeKitEnums.h> +#include <svx/svdpage.hxx> +#include <vcl/keycodes.hxx> +#include <vcl/scheduler.hxx> +#include <stlsheet.hxx> + +#include <comphelper/processfactory.hxx> +#include <comphelper/propertysequence.hxx> +#include <comphelper/servicehelper.hxx> +#include <com/sun/star/awt/Key.hpp> +#include <com/sun/star/sheet/GlobalSheetSettings.hpp> +#include <com/sun/star/text/XTextRange.hpp> +#include <dbdata.hxx> +#include <document.hxx> +#include <docsh.hxx> +#include <drwlayer.hxx> +#include <inputopt.hxx> +#include <postit.hxx> +#include <rangeutl.hxx> +#include <scitems.hxx> +#include <scmod.hxx> +#include <tabvwsh.hxx> +#include <undomanager.hxx> +#include <viewdata.hxx> + +using namespace ::com::sun::star; + +class ScUiCalcTest2 : public ScModelTestBase +{ +public: + ScUiCalcTest2(); +}; + +ScUiCalcTest2::ScUiCalcTest2() + : ScModelTestBase("sc/qa/unit/uicalc/data") +{ +} + +static void lcl_AssertCurrentCursorPosition(ScDocShell& rDocSh, std::u16string_view rStr) +{ + ScAddress aAddr; + sal_Int32 nOffset = 0; + ScRangeStringConverter::GetAddressFromString(aAddr, rStr, rDocSh.GetDocument(), + formula::FormulaGrammar::CONV_OOO, nOffset); + ScTabViewShell* pViewShell = rDocSh.GetBestViewShell(false); + CPPUNIT_ASSERT_EQUAL_MESSAGE( + OUString(OUString::Concat("Incorrect Column in position ") + rStr).toUtf8().getStr(), + aAddr.Col(), pViewShell->GetViewData().GetCurX()); + CPPUNIT_ASSERT_EQUAL_MESSAGE( + OUString(OUString::Concat("Incorrect Row in position ") + rStr).toUtf8().getStr(), + aAddr.Row(), pViewShell->GetViewData().GetCurY()); +} + +static void lcl_SelectObjectByName(ScTabViewShell& rViewShell, std::u16string_view rObjName) +{ + bool bFound = rViewShell.SelectObject(rObjName); + CPPUNIT_ASSERT_MESSAGE( + OString(OUStringToOString(rObjName, RTL_TEXTENCODING_UTF8) + " not found.").getStr(), + bFound); + + CPPUNIT_ASSERT(rViewShell.GetViewData().GetScDrawView()->AreObjectsMarked()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf150499) +{ + createScDoc("tdf150499.xls"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(2), pDoc->GetTableCount()); + + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "Index", uno::Any(sal_uInt16(0)) } })); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Remove", aArgs); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(1), pDoc->GetTableCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf158254) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + goToCell("A:G"); + dispatchCommand(mxComponent, + ".uno:StyleApply?Style:string=Accent%201&FamilyName:string=CellStyles", {}); + + const ScPatternAttr* pPattern = pDoc->GetPattern(5, 0, 0); + ScStyleSheet* pStyleSheet = const_cast<ScStyleSheet*>(pPattern->GetStyleSheet()); + + // Without the fix in place, this test would have failed with + // - Expected: Accent 1 + // - Actual : Default + CPPUNIT_ASSERT_EQUAL(OUString("Accent 1"), pStyleSheet->GetName()); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + pPattern = pDoc->GetPattern(5, 0, 0); + pStyleSheet = const_cast<ScStyleSheet*>(pPattern->GetStyleSheet()); + CPPUNIT_ASSERT_EQUAL(OUString("Default"), pStyleSheet->GetName()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf133326) +{ + createScDoc("tdf133326.ods"); + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + insertNewSheet(*pDoc); + + OUString aFormula = pDoc->GetFormula(0, 0, 1); + CPPUNIT_ASSERT_EQUAL(OUString(""), aFormula); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + aFormula = pDoc->GetFormula(0, 0, 1); + CPPUNIT_ASSERT_EQUAL(OUString("=RAND()*1000000"), aFormula); + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(2), pDoc->GetTableCount()); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + aFormula = pDoc->GetFormula(0, 0, 1); + CPPUNIT_ASSERT_EQUAL(OUString(""), aFormula); + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(2), pDoc->GetTableCount()); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(1), pDoc->GetTableCount()); + + dispatchCommand(mxComponent, ".uno:Redo", {}); + + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(2), pDoc->GetTableCount()); + aFormula = pDoc->GetFormula(0, 0, 1); + CPPUNIT_ASSERT_EQUAL(OUString(""), aFormula); + + // Without the fix in place, it would have crashed here + dispatchCommand(mxComponent, ".uno:Redo", {}); + + aFormula = pDoc->GetFormula(0, 0, 1); + CPPUNIT_ASSERT_EQUAL(OUString("=RAND()*1000000"), aFormula); + CPPUNIT_ASSERT_EQUAL(static_cast<SCTAB>(2), pDoc->GetTableCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf126685) +{ + createScDoc("tdf126685.ods"); + + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); // test should crash here without the fix + + CPPUNIT_ASSERT_EQUAL( + OUString("Control Height will change from 0.65 to 0.61 cm with 120dpi ..."), + pDoc->GetString(ScAddress(3, 1, 1))); + dispatchCommand(mxComponent, ".uno:Cut", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(3, 1, 1))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf119793) +{ + createScDoc("tdf119793.ods"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + uno::Reference<drawing::XDrawPage> xPage(pModelObj->getDrawPages()->getByIndex(0), + uno::UNO_QUERY_THROW); + uno::Reference<drawing::XShape> xShape(xPage->getByIndex(0), uno::UNO_QUERY_THROW); + + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(4984), xShape->getPosition().X); + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(1381), xShape->getPosition().Y); + + // Move the shape to the right + lcl_SelectObjectByName(*getViewShell(), u"Shape 1"); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_RIGHT); + Scheduler::ProcessEventsToIdle(); + + //position has changed + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(5084), xShape->getPosition().X); + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(1381), xShape->getPosition().Y); + + // Type into the shape + typeString(u"x"); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_ESCAPE); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_ESCAPE); + Scheduler::ProcessEventsToIdle(); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(5084), xShape->getPosition().X); + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(1381), xShape->getPosition().Y); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + // Without the fix in place, this test would have failed with + // - Expected: 4984 + // - Actual : 5084 + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(4984), xShape->getPosition().X); + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(1381), xShape->getPosition().Y); + + // tdf#141816: Without the fix in place, this test would have failed with + // - Expected: + // - Actual : x + uno::Reference<text::XText> xText + = uno::Reference<text::XTextRange>(xShape, uno::UNO_QUERY_THROW)->getText(); + CPPUNIT_ASSERT_EQUAL(OUString(""), xText->getString()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf131455) +{ + // Note that tdf#131455 and tdf#126904 were actually incorrect, + // but keep the test with a fixed version of the document. + createScDoc("tdf131455-fixed.ods"); + ScDocShell* pDocSh = getScDocShell(); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"A5"); + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"B5"); + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"E5"); + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"F5"); + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"I5"); + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"J5"); + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"M5"); + + //Cursor can't move forward to the right + for (size_t i = 0; i < 5; ++i) + { + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"N5"); + } + + CPPUNIT_ASSERT_EQUAL(sal_Int16(0), getViewShell()->GetViewData().GetTabNo()); + + dispatchCommand(mxComponent, ".uno:JumpToNextTable", {}); + + CPPUNIT_ASSERT_EQUAL(sal_Int16(1), getViewShell()->GetViewData().GetTabNo()); + lcl_AssertCurrentCursorPosition(*pDocSh, u"A4"); + + // Go to row 9 + for (size_t i = 0; i < 6; ++i) + { + dispatchCommand(mxComponent, ".uno:GoDown", {}); + } + + lcl_AssertCurrentCursorPosition(*pDocSh, u"A10"); + + dispatchCommand(mxComponent, ".uno:SelectRow", {}); + dispatchCommand(mxComponent, ".uno:DeleteRows", {}); + + dispatchCommand(mxComponent, ".uno:JumpToPrevTable", {}); + + CPPUNIT_ASSERT_EQUAL(sal_Int16(0), getViewShell()->GetViewData().GetTabNo()); + lcl_AssertCurrentCursorPosition(*pDocSh, u"N5"); + + //Cursor can't move forward to the right + for (size_t i = 0; i < 5; ++i) + { + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"N5"); + } +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf124818) +{ + createScDoc("tdf124818.xls"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(sal_Int16(2), getViewShell()->GetViewData().GetTabNo()); + + dispatchCommand(mxComponent, ".uno:JumpToPrevTable", {}); + + CPPUNIT_ASSERT_EQUAL(sal_Int16(1), getViewShell()->GetViewData().GetTabNo()); + + ScDrawLayer* pDrawLayer = pDoc->GetDrawLayer(); + SdrPage* pPage = pDrawLayer->GetPage(1); + CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), pPage->GetObjCount()); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); + + dispatchCommand(mxComponent, ".uno:Cut", {}); + + CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(0), pPage->GetObjCount()); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), pPage->GetObjCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf124816) +{ + createScDoc("tdf124816.xlsx"); + ScDocShell* pDocSh = getScDocShell(); + ScDocument* pDoc = getScDoc(); + + // The actual result is completely unrelated to this test and behaviour of + // OFFSET() was changed as of tdf#85551 and here result of that test + // document is now Err:502 instead of 0. + constexpr OUString aExpectedResult(u"Err:502"_ustr); + lcl_AssertCurrentCursorPosition(*pDocSh, u"D10"); + CPPUNIT_ASSERT_EQUAL(aExpectedResult, pDoc->GetString(ScAddress(3, 9, 0))); + + //Without the fix, it would crash + dispatchCommand(mxComponent, ".uno:InsertRowsBefore", {}); + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(3, 9, 0))); + dispatchCommand(mxComponent, ".uno:Undo", {}); + CPPUNIT_ASSERT_EQUAL(aExpectedResult, pDoc->GetString(ScAddress(3, 9, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf124815) +{ + createScDoc("tdf124815.ods"); + + ScDocument* pDoc = getScDoc(); + CPPUNIT_ASSERT_EQUAL(OUString("Rakennukset"), pDoc->GetString(ScAddress(2, 0, 0))); + + //Without the fix, it would crash + dispatchCommand(mxComponent, ".uno:InsertColumnsBefore", {}); + CPPUNIT_ASSERT_EQUAL(OUString("Rakennukset"), pDoc->GetString(ScAddress(3, 0, 0))); + dispatchCommand(mxComponent, ".uno:Undo", {}); + CPPUNIT_ASSERT_EQUAL(OUString("Rakennukset"), pDoc->GetString(ScAddress(2, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf142010) +{ + createScDoc("tdf142010.xls"); + ScDocument* pDoc = getScDoc(); + + goToCell("A1"); + + OUString aFormula = pDoc->GetFormula(5, 71, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=MOD(F$71+$C72,9)"), aFormula); + CPPUNIT_ASSERT_EQUAL(5.0, pDoc->GetValue(ScAddress(5, 71, 0))); + + dispatchCommand(mxComponent, ".uno:InsertColumnsBefore", {}); + + aFormula = pDoc->GetFormula(6, 71, 0); + + // Without the fix in place, this test would have failed with + // - Expected: =MOD(G$71+$D72,9) + // - Actual : =MOD(G$71+$K72,9) + CPPUNIT_ASSERT_EQUAL(OUString("=MOD(G$71+$D72,9)"), aFormula); + CPPUNIT_ASSERT_EQUAL(5.0, pDoc->GetValue(ScAddress(6, 71, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + aFormula = pDoc->GetFormula(5, 71, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=MOD(F$71+$C72,9)"), aFormula); + CPPUNIT_ASSERT_EQUAL(5.0, pDoc->GetValue(ScAddress(5, 71, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf154061) +{ + createScDoc("simpleTable.xlsx"); + ScDocument* pDoc = getScDoc(); + CPPUNIT_ASSERT_EQUAL(OUString("Column2"), pDoc->GetString(ScAddress(1, 0, 0))); + + goToCell("B1"); + + // Without the fix in place, it would crash here due to an out of bounds array access + dispatchCommand(mxComponent, ".uno:InsertColumnsBefore", {}); + CPPUNIT_ASSERT_EQUAL(OUString("Column2"), pDoc->GetString(ScAddress(2, 0, 0))); + dispatchCommand(mxComponent, ".uno:Undo", {}); + CPPUNIT_ASSERT_EQUAL(OUString("Column2"), pDoc->GetString(ScAddress(1, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf132431) +{ + createScDoc("tdf132431.ods"); + ScDocument* pDoc = getScDoc(); + + OUString aFormula = pDoc->GetFormula(7, 219, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=SUMIFS($H$2:$H$198,B$2:B$198,G220)"), aFormula); + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(7, 219, 0))); + + // Without the fix in place, it would crash here with + // uncaught exception of type std::exception (or derived). + // - vector::_M_fill_insert + insertStringToCell("H220", u"=SUMIFS($H$2:$DB$198,B$2:B$198,G220)"); + + aFormula = pDoc->GetFormula(7, 219, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=SUMIFS($H$2:$DB$198,B$2:B$198,G220)"), aFormula); + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(7, 219, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("Err:502"), pDoc->GetString(ScAddress(7, 219, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf131073) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + for (SCCOLROW nColRow = 0; nColRow < 3; nColRow++) + { + pDoc->SetString(ScAddress(0, nColRow, 0), "Hello World"); + pDoc->SetRowHeight(0, nColRow, 1000 * (nColRow + 1)); + pDoc->SetString(ScAddress(nColRow, 0, 0), "Hello World"); + pDoc->SetColWidth(nColRow, 0, 1000 * (nColRow + 1)); + } + + // Check rows + pDoc->SetRowHidden(1, 1, 0, true); + goToCell("A1:A3"); + dispatchCommand( + mxComponent, ".uno:SetOptimalRowHeight", + comphelper::InitPropertySequence({ { "aExtraHeight", uno::Any(sal_uInt16(0)) } })); + + CPPUNIT_ASSERT(!pDoc->RowHidden(0, 0)); + // tdf#131073: Without the fix in place, the second row would not be hidden + CPPUNIT_ASSERT(pDoc->RowHidden(1, 0)); + CPPUNIT_ASSERT(!pDoc->RowHidden(2, 0)); + const sal_uInt16 nStdRowHeight = pDoc->GetRowHeight(4, 0); + CPPUNIT_ASSERT_EQUAL(nStdRowHeight, pDoc->GetRowHeight(0, 0)); + CPPUNIT_ASSERT_EQUAL(nStdRowHeight, pDoc->GetRowHeight(1, SCTAB(0), false)); + CPPUNIT_ASSERT_EQUAL(nStdRowHeight, pDoc->GetRowHeight(2, 0)); + + // Check columns + pDoc->SetColHidden(1, 1, 0, true); + goToCell("A1:C1"); + dispatchCommand( + mxComponent, ".uno:SetOptimalColumnWidth", + comphelper::InitPropertySequence({ { "aExtraWidth", uno::Any(sal_uInt16(0)) } })); + + CPPUNIT_ASSERT(!pDoc->ColHidden(0, 0)); + // tdf#131073: Without the fix in place, the second column would not be hidden + CPPUNIT_ASSERT(pDoc->ColHidden(1, 0)); + CPPUNIT_ASSERT(!pDoc->ColHidden(2, 0)); + const sal_uInt16 nStdColWidth = pDoc->GetColWidth(0, 0); + CPPUNIT_ASSERT_EQUAL(nStdColWidth, pDoc->GetColWidth(0, 0)); + CPPUNIT_ASSERT_EQUAL(nStdColWidth, pDoc->GetColWidth(1, SCTAB(0), false)); + CPPUNIT_ASSERT_EQUAL(nStdColWidth, pDoc->GetColWidth(2, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf83901) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + + insertStringToCell("A2", u"=ROW(A3)"); + ScDocument* pDoc = getScDoc(); + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(0, 1, 0))); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"A3"); + dispatchCommand(mxComponent, ".uno:SelectRow", {}); + dispatchCommand(mxComponent, ".uno:InsertRowsBefore", {}); + + //Without the fix, it would be 3.0 + CPPUNIT_ASSERT_EQUAL(4.0, pDoc->GetValue(ScAddress(0, 1, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(0, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf124822) +{ + createScDoc("tdf124822.xls"); + + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(OUString("X"), pDoc->GetString(ScAddress(0, 0, 2))); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); + + dispatchCommand(mxComponent, ".uno:Cut", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(0, 0, 2))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("X"), pDoc->GetString(ScAddress(0, 0, 2))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf118189) +{ + createScDoc("tdf118189.xlsx"); + + ScDocument* pDoc = getScDoc(); + + // Select column A + goToCell("A:A"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Open a new document + createScDoc(); + pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + OUString aFormula = pDoc->GetFormula(0, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=FALSE()"), aFormula); + + dispatchCommand(mxComponent, ".uno:Cut", {}); + + aFormula = pDoc->GetFormula(0, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString(""), aFormula); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Undo", {}); + + aFormula = pDoc->GetFormula(0, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=FALSE()"), aFormula); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf118207) +{ + createScDoc("tdf118189.xlsx"); + + ScDocument* pDoc = getScDoc(); + + // Disable replace cell warning + ScModule* pMod = SC_MOD(); + ScInputOptions aInputOption = pMod->GetInputOptions(); + bool bOldStatus = aInputOption.GetReplaceCellsWarn(); + aInputOption.SetReplaceCellsWarn(false); + pMod->SetInputOptions(aInputOption); + + // Select column A + goToCell("A:A"); + + OUString aFormula = pDoc->GetFormula(0, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=FALSE()"), aFormula); + + dispatchCommand(mxComponent, ".uno:Cut", {}); + + aFormula = pDoc->GetFormula(0, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString(""), aFormula); + + // Select column B + goToCell("B:B"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + aFormula = pDoc->GetFormula(1, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=FALSE()"), aFormula); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + aFormula = pDoc->GetFormula(1, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=FALSE()"), aFormula); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + aFormula = pDoc->GetFormula(1, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=FALSE()"), aFormula); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + aFormula = pDoc->GetFormula(1, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString(""), aFormula); + aFormula = pDoc->GetFormula(0, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString(""), aFormula); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + aFormula = pDoc->GetFormula(0, 77, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=FALSE()"), aFormula); + + // Restore previous status + aInputOption.SetReplaceCellsWarn(bOldStatus); + pMod->SetInputOptions(aInputOption); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf148669) +{ + // Without the fix in place, this test would have failed with an assert + createScDoc("tdf148669.xlsx"); + + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_MESSAGE("There should be a note", pDoc->HasNote(ScAddress(701, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf124778) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + // Add a new comment + uno::Sequence<beans::PropertyValue> aArgs + = comphelper::InitPropertySequence({ { "Text", uno::Any(OUString("Comment")) } }); + dispatchCommand(mxComponent, ".uno:InsertAnnotation", aArgs); + + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + + // Without the fix in place, this test would have crashed + dispatchCommand(mxComponent, ".uno:ShowAnnotations", {}); + + ScPostIt* pNote = pDoc->GetNote(ScAddress(0, 0, 0)); + CPPUNIT_ASSERT(pNote); + CPPUNIT_ASSERT_EQUAL(true, pNote->IsCaptionShown()); + + dispatchCommand(mxComponent, ".uno:ShowAnnotations", {}); + + CPPUNIT_ASSERT_EQUAL(false, pNote->IsCaptionShown()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf138428) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + + // Add a new comment + uno::Sequence<beans::PropertyValue> aArgs + = comphelper::InitPropertySequence({ { "Text", uno::Any(OUString("Comment")) } }); + dispatchCommand(mxComponent, ".uno:InsertAnnotation", aArgs); + + ScDocument* pDoc = getScDoc(); + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There shouldn't be a note on B1", !pDoc->HasNote(ScAddress(1, 0, 0))); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + dispatchCommand(mxComponent, ".uno:GoRight", {}); + lcl_AssertCurrentCursorPosition(*pDocSh, u"B1"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be a note on B1", pDoc->HasNote(ScAddress(1, 0, 0))); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There shouldn't be a note on B1", !pDoc->HasNote(ScAddress(1, 0, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_MESSAGE("There shouldn't be a note on A1", !pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There shouldn't be a note on B1", !pDoc->HasNote(ScAddress(1, 0, 0))); + + dispatchCommand(mxComponent, ".uno:Redo", {}); + + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There shouldn't be a note on B1", !pDoc->HasNote(ScAddress(1, 0, 0))); + + dispatchCommand(mxComponent, ".uno:Redo", {}); + + CPPUNIT_ASSERT_MESSAGE("There should be a note on A1", pDoc->HasNote(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_MESSAGE("There should be a note on B1", pDoc->HasNote(ScAddress(1, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf136113) +{ + createScDoc("tdf136113.xlsx"); + ScDocument* pDoc = getScDoc(); + + ScDrawLayer* pDrawLayer = pDoc->GetDrawLayer(); + SdrPage* pPage = pDrawLayer->GetPage(0); + SdrObject* pObj = pPage->GetObj(0); + + CPPUNIT_ASSERT_EQUAL(tools::Long(18142), pObj->GetSnapRect().Left()); + CPPUNIT_ASSERT_EQUAL(tools::Long(1709), pObj->GetSnapRect().Top()); + + lcl_SelectObjectByName(*getViewShell(), u"Arrow"); + + // Move the shape up + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::UP); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::UP); + Scheduler::ProcessEventsToIdle(); + + CPPUNIT_ASSERT_EQUAL(tools::Long(18142), pObj->GetSnapRect().Left()); + CPPUNIT_ASSERT_EQUAL(tools::Long(1609), pObj->GetSnapRect().Top()); + + // Without the fix in place, this test would have failed here + ScDocShell* pDocSh = getScDocShell(); + CPPUNIT_ASSERT(pDocSh->IsModified()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf130614) +{ + createScDoc("tdf130614.ods"); + ScDocument* pDoc = getScDoc(); + + lcl_SelectObjectByName(*getViewShell(), u"Object 1"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Open a new document + createScDoc(); + pDoc = getScDoc(); + + // Without the fix in place, this test would have crashed here + dispatchCommand(mxComponent, ".uno:Paste", {}); + + ScDrawLayer* pDrawLayer = pDoc->GetDrawLayer(); + SdrPage* pPage = pDrawLayer->GetPage(0); + CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), pPage->GetObjCount()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf112735) +{ + createScDoc("tdf112735.ods"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(OUString("(empty)"), pDoc->GetString(ScAddress(1, 0, 0))); + + goToCell("B3"); + + dispatchCommand(mxComponent, ".uno:RecalcPivotTable", {}); + + // Without the fix in place, this test would have failed with + // - Expected: (empty) + // - Actual : + CPPUNIT_ASSERT_EQUAL(OUString("(empty)"), pDoc->GetString(ScAddress(1, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf112884) +{ + createScDoc("tdf112884.ods"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(OUString("0.5"), pDoc->GetString(ScAddress(6, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("0.666666666666667"), pDoc->GetString(ScAddress(6, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("0.833333333333333"), pDoc->GetString(ScAddress(6, 4, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("#DIV/0!"), pDoc->GetString(ScAddress(6, 5, 0))); + + goToCell("G3"); + + dispatchCommand(mxComponent, ".uno:RecalcPivotTable", {}); + + // Without the fix in place, this test would have failed with + // - Expected: #DIV/0! + // - Actual : 0.5 + CPPUNIT_ASSERT_EQUAL(OUString("#DIV/0!"), pDoc->GetString(ScAddress(6, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("0.5"), pDoc->GetString(ScAddress(6, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("0.666666666666667"), pDoc->GetString(ScAddress(6, 4, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("0.833333333333333"), pDoc->GetString(ScAddress(6, 5, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf133342) +{ + createScDoc("tdf133342.ods"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(OUString("12,35 %"), pDoc->GetString(ScAddress(0, 0, 0))); + //Add decimals + dispatchCommand(mxComponent, ".uno:NumberFormatIncDecimals", {}); + //Space should preserved before percent sign + CPPUNIT_ASSERT_EQUAL(OUString("12,346 %"), pDoc->GetString(ScAddress(0, 0, 0))); + + //Delete decimals + dispatchCommand(mxComponent, ".uno:NumberFormatDecDecimals", {}); + dispatchCommand(mxComponent, ".uno:NumberFormatDecDecimals", {}); + dispatchCommand(mxComponent, ".uno:NumberFormatDecDecimals", {}); + //Space should preserved before percent sign + CPPUNIT_ASSERT_EQUAL(OUString("12 %"), pDoc->GetString(ScAddress(0, 0, 0))); + + dispatchCommand(mxComponent, ".uno:NumberFormatDecDecimals", {}); + //Space should preserved before percent sign + CPPUNIT_ASSERT_EQUAL(OUString("12 %"), pDoc->GetString(ScAddress(0, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf71339) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A2", u"1"); + insertStringToCell("A3", u"1"); + + goToCell("A1:A3"); + + executeAutoSum(); + + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(0, 3, 0))); + + OUString aFormula = pDoc->GetFormula(0, 3, 0); + + // Without the fix in place, this test would have failed with + // - Expected: =SUM(A1:A3) + // - Actual : =SUM(A2:A3) + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A1:A3)"), aFormula); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf116421) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"1"); + insertStringToCell("A2", u"1"); + insertStringToCell("A3", u"1"); + + goToCell("A4"); + + executeAutoSum(); + + // Without the fix in place, this test would have failed with + // - Expected: 3 + // - Actual : 0 + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(0, 3, 0))); + + OUString aFormula = pDoc->GetFormula(0, 3, 0); + + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A1:A3)"), aFormula); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf86305) +{ + createScDoc("tdf86305.ods"); + ScDocument* pDoc = getScDoc(); + + OUString aFormula = pDoc->GetFormula(1, 6, 0); + CPPUNIT_ASSERT_EQUAL(OUString("{=IF(SUM(B2:B4) > 0, SUM(B2:B4*D2:D4/C2:C4), 0)}"), aFormula); + CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(ScAddress(1, 6, 0))); + + insertStringToCell("B3", u"50"); + CPPUNIT_ASSERT_EQUAL(50.0, pDoc->GetValue(ScAddress(1, 2, 0))); + + aFormula = pDoc->GetFormula(1, 6, 0); + + // Without the fix in place, this test would have failed with + // - Expected: {=IF(SUM(B2:B4) > 0, SUM(B2:B4*D2:D4/C2:C4), 0)} + // - Actual : {=IF(SUM(B2:B4) > 0, SUM(B2:B4*D2:D4/C2:C4), 0.175)} + CPPUNIT_ASSERT_EQUAL(OUString("{=IF(SUM(B2:B4) > 0, SUM(B2:B4*D2:D4/C2:C4), 0)}"), aFormula); + CPPUNIT_ASSERT_EQUAL(0.175, pDoc->GetValue(ScAddress(1, 6, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf81351) +{ + createScDoc("tdf81351.ods"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Paste"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Bold"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Save"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Undo"), pDoc->GetString(ScAddress(0, 4, 0))); + + goToCell("A1:F5"); + + dispatchCommand(mxComponent, ".uno:SortAscending", {}); + dispatchCommand(mxComponent, ".uno:GoDown", {}); + + // Without the fix in place, this test would have crashed + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Bold"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Paste"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Save"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Undo"), pDoc->GetString(ScAddress(0, 4, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Paste"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Bold"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Save"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Undo"), pDoc->GetString(ScAddress(0, 4, 0))); + + dispatchCommand(mxComponent, ".uno:Redo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Bold"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Paste"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Save"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Undo"), pDoc->GetString(ScAddress(0, 4, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Paste"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Bold"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Save"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Undo"), pDoc->GetString(ScAddress(0, 4, 0))); + + goToCell("A1:F5"); + + dispatchCommand(mxComponent, ".uno:SortDescending", {}); + dispatchCommand(mxComponent, ".uno:GoDown", {}); + + // Without the fix in place, this test would have crashed + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Undo"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Save"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Paste"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Bold"), pDoc->GetString(ScAddress(0, 4, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Paste"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Bold"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Save"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Undo"), pDoc->GetString(ScAddress(0, 4, 0))); + + dispatchCommand(mxComponent, ".uno:Redo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Undo"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Save"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Paste"), pDoc->GetString(ScAddress(0, 3, 0))); + CPPUNIT_ASSERT_EQUAL(OUString(".uno:Bold"), pDoc->GetString(ScAddress(0, 4, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf123202) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell(u"A1"_ustr, u"1"); + insertStringToCell(u"A2"_ustr, u"2"); + insertStringToCell(u"A3"_ustr, u"3"); + insertStringToCell(u"A4"_ustr, u"4"); + + goToCell("A3"); + + dispatchCommand(mxComponent, ".uno:HideRow", {}); + + goToCell("A1:A4"); + + dispatchCommand(mxComponent, ".uno:SortDescending", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("4"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("3"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("1"), pDoc->GetString(ScAddress(0, 3, 0))); + + // This failed, if the "3" is visible. + CPPUNIT_ASSERT(pDoc->RowHidden(1, 0)); + CPPUNIT_ASSERT(!pDoc->RowHidden(2, 0)); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("1"), pDoc->GetString(ScAddress(0, 0, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("2"), pDoc->GetString(ScAddress(0, 1, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("3"), pDoc->GetString(ScAddress(0, 2, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("4"), pDoc->GetString(ScAddress(0, 3, 0))); + + CPPUNIT_ASSERT(!pDoc->RowHidden(1, 0)); + CPPUNIT_ASSERT(pDoc->RowHidden(2, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf134675) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + insertStringToCell("A1", u"A"); + + // Select column A + goToCell("A:A"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Select column B to Z + goToCell("B:Z"); + + dispatchCommand(mxComponent, ".uno:Paste", {}); + + for (size_t i = 1; i < 24; ++i) + { + // Without the fix in place, this test would have failed here with + // - Expected: A + // - Actual : + CPPUNIT_ASSERT_EQUAL(OUString("A"), pDoc->GetString(ScAddress(i, 0, 0))); + } +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf116215) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + insertStringToCell("A1", u"1"); + insertStringToCell("A2", u"1"); + insertStringToCell("B1", u"1"); + insertStringToCell("B2", u"1"); + goToCell("A1:C3"); + + executeAutoSum(); + + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(0, 2, 0))); + OUString aFormula = pDoc->GetFormula(0, 2, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A1:A2)"), aFormula); + + // Without the fix in place, this test would have failed with + // - Expected: 2 + // - Actual : 4 + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(1, 2, 0))); + aFormula = pDoc->GetFormula(1, 2, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B1:B2)"), aFormula); + + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(2, 0, 0))); + aFormula = pDoc->GetFormula(2, 0, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A1:B1)"), aFormula); + + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(2, 1, 0))); + aFormula = pDoc->GetFormula(2, 1, 0); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(A2:B2)"), aFormula); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf99913) +{ + createScDoc("tdf99913.xlsx"); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT(pDoc->RowFiltered(2, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf126540_GridToggleModifiesTheDocument) +{ + createScDoc("tdf99913.xlsx"); + + // Toggling the grid of a sheet, must set the document modified state + ScDocShell* pDocSh = getScDocShell(); + CPPUNIT_ASSERT(!pDocSh->IsModified()); + dispatchCommand(mxComponent, ".uno:ToggleSheetGrid", {}); + CPPUNIT_ASSERT(pDocSh->IsModified()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf118983) +{ + createScDoc("tdf118983.ods"); + ScDocument* pDoc = getScDoc(); + + css::uno::Reference<css::sheet::XGlobalSheetSettings> xGlobalSheetSettings + = css::sheet::GlobalSheetSettings::create(::comphelper::getProcessComponentContext()); + bool bOldValue = xGlobalSheetSettings->getExpandReferences(); + + xGlobalSheetSettings->setExpandReferences(true); + + const ScRangeData* pRD = pDoc->GetRangeName()->findByUpperName("TEST"); + CPPUNIT_ASSERT(pRD); + CPPUNIT_ASSERT_EQUAL(OUString("$Test.$A$3:$D$7"), pRD->GetSymbol()); + + //Select columns E to G + goToCell("E:G"); + + dispatchCommand(mxComponent, ".uno:InsertColumnsBefore", {}); + + // Without the fix in place, this test would have failed with + // - Expected: $Test.$A$3:$D$7 + // - Actual : $Test.$A$3:$G$7 + CPPUNIT_ASSERT_EQUAL(OUString("$Test.$A$3:$D$7"), pRD->GetSymbol()); + + xGlobalSheetSettings->setExpandReferences(bOldValue); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf107952) +{ + createScDoc(); + ScDocShell* pDocSh = getScDocShell(); + + insertStringToCell("B1", u"=SUM(A1:A2)"); + + goToCell("D10"); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + // Without the fix in place, this test would have failed with + // - Expected: 1 + // - Actual : 3 + // - Incorrect Column in position B1 + lcl_AssertCurrentCursorPosition(*pDocSh, u"B1"); + + goToCell("D10"); + + dispatchCommand(mxComponent, ".uno:Redo", {}); + + lcl_AssertCurrentCursorPosition(*pDocSh, u"B1"); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf150766) +{ + createScDoc("tdf150766.ods"); + ScDocument* pDoc = getScDoc(); + + goToCell("A3:C6"); + + dispatchCommand(mxComponent, ".uno:SortDescending", {}); + + insertStringToCell("B3", u"10"); + + CPPUNIT_ASSERT_EQUAL(12.0, pDoc->GetValue(ScAddress(2, 2, 0))); + CPPUNIT_ASSERT_EQUAL(13.0, pDoc->GetValue(ScAddress(2, 3, 0))); + CPPUNIT_ASSERT_EQUAL(14.0, pDoc->GetValue(ScAddress(2, 4, 0))); + CPPUNIT_ASSERT_EQUAL(15.0, pDoc->GetValue(ScAddress(2, 5, 0))); + + // Without the fix in place, this test would have failed with + // - Expected: 16 + // - Actual : 7 + CPPUNIT_ASSERT_EQUAL(16.0, pDoc->GetValue(ScAddress(2, 6, 0))); + CPPUNIT_ASSERT_EQUAL(17.0, pDoc->GetValue(ScAddress(2, 7, 0))); + CPPUNIT_ASSERT_EQUAL(18.0, pDoc->GetValue(ScAddress(2, 8, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf144022) +{ + createScDoc("tdf144022.ods"); + ScDocument* pDoc = getScDoc(); + + goToCell("A5:B79"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + goToCell("D5"); + + //Without the fix in place, this test would have crashed + dispatchCommand(mxComponent, ".uno:PasteTransposed", {}); + + for (size_t i = 3; i < 76; ++i) + { + OUString sExpected = "A" + OUString::number(i + 2); + CPPUNIT_ASSERT_EQUAL(sExpected, pDoc->GetString(ScAddress(i, 4, 0))); + } +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf99386) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("B1", u"This"); + insertStringToCell("B2", u"=B1"); + + goToCell("A1:B1"); + + dispatchCommand(mxComponent, ".uno:ToggleMergeCells", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("0"), pDoc->GetString(ScAddress(1, 1, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("This"), pDoc->GetString(ScAddress(1, 0, 0))); + + // Without the fix in place, this test would have failed with + // - Expected: This + // - Actual : 0 + CPPUNIT_ASSERT_EQUAL(OUString("This"), pDoc->GetString(ScAddress(1, 1, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf149378) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"=MINVERSE(A1:C3)"); + + // Without the fix in place, this test would have failed with + // - Expected: {=MINVERSE(A1:C3)} + // - Actual : =MINVERSE(A1:C3) + CPPUNIT_ASSERT_EQUAL(OUString("{=MINVERSE(A1:C3)}"), pDoc->GetFormula(0, 0, 0)); + + insertStringToCell("B1", u"={1;2}"); + CPPUNIT_ASSERT_EQUAL(OUString("{={1;2}}"), pDoc->GetFormula(1, 0, 0)); + + insertStringToCell("C1", u"={1;2}+3"); + CPPUNIT_ASSERT_EQUAL(OUString("{={1;2}+3}"), pDoc->GetFormula(2, 0, 0)); + + insertStringToCell("D1", u"={1;2}+{3;4}"); + CPPUNIT_ASSERT_EQUAL(OUString("{={1;2}+{3;4}}"), pDoc->GetFormula(3, 0, 0)); + + insertStringToCell("E1", u"={1;2}+A1"); + CPPUNIT_ASSERT_EQUAL(OUString("{={1;2}+A1}"), pDoc->GetFormula(4, 0, 0)); + + insertStringToCell("F1", u"={1;2}+A1:A2"); + CPPUNIT_ASSERT_EQUAL(OUString("={1;2}+A1:A2"), pDoc->GetFormula(5, 0, 0)); + + insertStringToCell("G1", u"=SUM(MUNIT(3))"); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(MUNIT(3))"), pDoc->GetFormula(6, 0, 0)); + + insertStringToCell("H1", u"=SUM({1;2})"); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM({1;2})"), pDoc->GetFormula(7, 0, 0)); + + insertStringToCell("I1", u"=ABS({-1;-2})"); + CPPUNIT_ASSERT_EQUAL(OUString("{=ABS({-1;-2})}"), pDoc->GetFormula(8, 0, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf152014) +{ + createScDoc(); + + insertStringToCell("A1", u"=MATCH(1,A2,0)"); + insertStringToCell("A2", u"1"); + + ScDocument* pDoc = getScDoc(); + CPPUNIT_ASSERT_EQUAL(OUString("1"), pDoc->GetString(ScAddress(0, 0, 0))); + + goToCell("A1"); + + dispatchCommand(mxComponent, ".uno:Copy", {}); + + // Create a second document + mxComponent2 = loadFromDesktop("private:factory/scalc"); + + uno::Reference<frame::XFrames> xFrames = mxDesktop->getFrames(); + CPPUNIT_ASSERT_EQUAL(static_cast<sal_Int32>(2), xFrames->getCount()); + + dispatchCommand(mxComponent2, ".uno:Paste", {}); + + ScModelObj* pModelObj2 = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent2); + CPPUNIT_ASSERT(pModelObj2); + ScDocument* pDoc2 = pModelObj2->GetDocument(); + + // Without the fix in place, this test would have failed with + // - Expected: #N/A + // - Actual : 1 + CPPUNIT_ASSERT_EQUAL(OUString("#N/A"), pDoc2->GetString(ScAddress(0, 0, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf156286) +{ + createScDoc("tdf156286.ods"); + ScDocument* pDoc = getScDoc(); + + dispatchCommand(mxComponent, ".uno:SelectAll", {}); + + // Without the fix in place, this test would have crash here + dispatchCommand(mxComponent, ".uno:DeleteColumns", {}); + + CPPUNIT_ASSERT_EQUAL(OUString(""), pDoc->GetString(ScAddress(12, 2, 0))); + + dispatchCommand(mxComponent, ".uno:Undo", {}); + + CPPUNIT_ASSERT_EQUAL(OUString("xxxxxxxxxxxx"), pDoc->GetString(ScAddress(12, 2, 0))); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf126926) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"1"); + insertStringToCell("A2", u"2"); + insertStringToCell("B1", u"3"); + insertStringToCell("B2", u"4"); + + ScDBData* pDBData = new ScDBData("testDB", 0, 0, 0, 1, 1); + bool bInserted + = pDoc->GetDBCollection()->getNamedDBs().insert(std::unique_ptr<ScDBData>(pDBData)); + CPPUNIT_ASSERT(bInserted); + + goToCell("A1:B1"); + + dispatchCommand(mxComponent, ".uno:DeleteColumns", {}); + + ScDBCollection* pDBs = pDoc->GetDBCollection(); + CPPUNIT_ASSERT(pDBs->empty()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testUnallocatedColumnsAttributes) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(INITIALCOLCOUNT, pDoc->GetAllocatedColumnsCount(0)); + + // Except for first 1 cell make the entire first row bold. + assert(INITIALCOLCOUNT >= 1); + goToCell("B1:" + pDoc->MaxColAsString() + "1"); + dispatchCommand(mxComponent, ".uno:Bold", {}); + + // That shouldn't need allocating more columns, just changing the default attribute. + CPPUNIT_ASSERT_EQUAL(INITIALCOLCOUNT, pDoc->GetAllocatedColumnsCount(0)); + vcl::Font aFont; + pDoc->GetPattern(pDoc->MaxCol(), 0, 0)->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should be bold", WEIGHT_BOLD, aFont.GetWeight()); + + goToCell("A2:CV2"); // first 100 cells in row 2 + dispatchCommand(mxComponent, ".uno:Bold", {}); + // These need to be explicitly allocated. + CPPUNIT_ASSERT_EQUAL(SCCOL(100), pDoc->GetAllocatedColumnsCount(0)); + pDoc->GetPattern(99, 1, 0)->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should be bold", WEIGHT_BOLD, aFont.GetWeight()); + pDoc->GetPattern(100, 1, 0)->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should not be bold", WEIGHT_NORMAL, aFont.GetWeight()); + + goToCell("CW3:" + pDoc->MaxColAsString() + "3"); // All but first 100 cells in row 3. + dispatchCommand(mxComponent, ".uno:Bold", {}); + // First 100 columns need to be allocated to not be bold, the rest should be handled + // by the default attribute. + CPPUNIT_ASSERT_EQUAL(SCCOL(100), pDoc->GetAllocatedColumnsCount(0)); + pDoc->GetPattern(99, 2, 0)->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should not be bold", WEIGHT_NORMAL, aFont.GetWeight()); + pDoc->GetPattern(100, 2, 0)->fillFontOnly(aFont); + CPPUNIT_ASSERT_EQUAL_MESSAGE("font should be bold", WEIGHT_BOLD, aFont.GetWeight()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testAutoSum) +{ + createScDoc("autosum.ods"); + ScDocument* pDoc = getScDoc(); + + //Sum on range and Sum on Sum's + goToCell("B10"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(1, 9, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B8:B9)"), pDoc->GetFormula(1, 9, 0)); + + goToCell("B13"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(ScAddress(1, 12, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B11:B12)"), pDoc->GetFormula(1, 12, 0)); + + goToCell("B14"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(4.0, pDoc->GetValue(ScAddress(1, 13, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B13:B13,B10:B10)"), pDoc->GetFormula(1, 13, 0)); + + goToCell("F8:F14"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(4.0, pDoc->GetValue(ScAddress(5, 13, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(F13:F13,F10:F10)"), pDoc->GetFormula(5, 13, 0)); + + //Sum on Row and Column + goToCell("E25"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(4, 24, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(E22:E24)"), pDoc->GetFormula(4, 24, 0)); + + goToCell("E26"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(4, 25, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B26:D26)"), pDoc->GetFormula(4, 25, 0)); + + goToCell("E27"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(4, 26, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B27:D27)"), pDoc->GetFormula(4, 26, 0)); + + goToCell("E28"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(ScAddress(4, 27, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B28:D28)"), pDoc->GetFormula(4, 27, 0)); + + goToCell("E29"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(9.0, pDoc->GetValue(ScAddress(4, 28, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(E26:E28)"), pDoc->GetFormula(4, 28, 0)); + + goToCell("E30"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(12.0, pDoc->GetValue(ScAddress(4, 29, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(E29:E29,E25:E25)"), pDoc->GetFormula(4, 29, 0)); + + //Subtotals on Autosum + goToCell("C49"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(20.0, pDoc->GetValue(ScAddress(2, 48, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUBTOTAL(9,C38:C48)"), pDoc->GetFormula(2, 48, 0)); + + //Autosum on column with selected empty cell for result + goToCell("B59:B64"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(1, 63, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B59:B63)"), pDoc->GetFormula(1, 63, 0)); + + //Autosum on rows with selected empty cell for result + goToCell("B76:E80"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(30.0, pDoc->GetValue(ScAddress(4, 75, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B76:D76)"), pDoc->GetFormula(4, 75, 0)); + CPPUNIT_ASSERT_EQUAL(60.0, pDoc->GetValue(ScAddress(4, 76, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B77:D77)"), pDoc->GetFormula(4, 76, 0)); + CPPUNIT_ASSERT_EQUAL(90.0, pDoc->GetValue(ScAddress(4, 77, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B78:D78)"), pDoc->GetFormula(4, 77, 0)); + CPPUNIT_ASSERT_EQUAL(120.0, pDoc->GetValue(ScAddress(4, 78, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B79:D79)"), pDoc->GetFormula(4, 78, 0)); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(4, 79, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B80:D80)"), pDoc->GetFormula(4, 79, 0)); + + //Subtotal on column with selected empty cell for result + goToCell("C92:C101"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(19.0, pDoc->GetValue(ScAddress(2, 100, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUBTOTAL(9,C92:C100)"), pDoc->GetFormula(2, 100, 0)); + + //Autosum on column without selected empty cell for result + goToCell("B109:B113"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(1, 113, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B109:B113)"), pDoc->GetFormula(1, 113, 0)); + + //Subtotal on column without selected empty cell for result + goToCell("C142:C149"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(19.0, pDoc->GetValue(ScAddress(2, 150, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUBTOTAL(9,C142:C149)"), pDoc->GetFormula(2, 150, 0)); + + //Autosum on multiselected columns without selected empty cell for result + goToCell("B160:D164"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(1, 164, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B160:B164)"), pDoc->GetFormula(1, 164, 0)); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(2, 164, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(C160:C164)"), pDoc->GetFormula(2, 164, 0)); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(3, 164, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(D160:D164)"), pDoc->GetFormula(3, 164, 0)); + + //Autosum on columns with formula results without selected empty cell for result + goToCell("B173:D177"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(2.54, std::floor(pDoc->GetValue(ScAddress(1, 177, 0)) * 100.0) / 100.0); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B173:B177)"), pDoc->GetFormula(1, 177, 0)); + CPPUNIT_ASSERT_EQUAL(-4.91, std::floor(pDoc->GetValue(ScAddress(2, 177, 0)) * 100.0) / 100.0); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(C173:C177)"), pDoc->GetFormula(2, 177, 0)); + CPPUNIT_ASSERT_EQUAL(5500.0, pDoc->GetValue(ScAddress(3, 177, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(D173:D177)"), pDoc->GetFormula(3, 177, 0)); + + //Autosum on column with filled cell under selected area + goToCell("B186:D190"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(1, 191, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B186:B190)"), pDoc->GetFormula(1, 191, 0)); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(2, 191, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(C186:C190)"), pDoc->GetFormula(2, 191, 0)); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(3, 191, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(D186:D190)"), pDoc->GetFormula(3, 191, 0)); + + //Autosum on column and rows with empty cells selected for row and column + goToCell("B203:E208"); + executeAutoSum(); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(1, 207, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B203:B207)"), pDoc->GetFormula(1, 207, 0)); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(2, 207, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(C203:C207)"), pDoc->GetFormula(2, 207, 0)); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(3, 207, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(D203:D207)"), pDoc->GetFormula(3, 207, 0)); + CPPUNIT_ASSERT_EQUAL(450.0, pDoc->GetValue(ScAddress(4, 207, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B208:D208)"), pDoc->GetFormula(4, 207, 0)); + CPPUNIT_ASSERT_EQUAL(30.0, pDoc->GetValue(ScAddress(4, 202, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B203:D203)"), pDoc->GetFormula(4, 202, 0)); + CPPUNIT_ASSERT_EQUAL(60.0, pDoc->GetValue(ScAddress(4, 203, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B204:D204)"), pDoc->GetFormula(4, 203, 0)); + CPPUNIT_ASSERT_EQUAL(90.0, pDoc->GetValue(ScAddress(4, 204, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B205:D205)"), pDoc->GetFormula(4, 204, 0)); + CPPUNIT_ASSERT_EQUAL(120.0, pDoc->GetValue(ScAddress(4, 205, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B206:D206)"), pDoc->GetFormula(4, 205, 0)); + CPPUNIT_ASSERT_EQUAL(150.0, pDoc->GetValue(ScAddress(4, 206, 0))); + CPPUNIT_ASSERT_EQUAL(OUString("=SUM(B207:D207)"), pDoc->GetFormula(4, 206, 0)); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf152577) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertStringToCell("A1", u"1"); + insertStringToCell("A2", u"2"); + insertStringToCell("B1", u"3"); + insertStringToCell("B2", u"4"); + + ScDBData* pDBData = new ScDBData("testDB", 0, 0, 0, 1, 1); + bool bInserted + = pDoc->GetDBCollection()->getNamedDBs().insert(std::unique_ptr<ScDBData>(pDBData)); + CPPUNIT_ASSERT(bInserted); + + insertNewSheet(*pDoc); + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "Index", uno::Any(sal_uInt16(2)) } })); + dispatchCommand(mxComponent, ".uno:Remove", aArgs); + + ScDBCollection* pDBs = pDoc->GetDBCollection(); + CPPUNIT_ASSERT(!pDBs->empty()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf155796) +{ + createScDoc(); + + goToCell("A1:A3"); + dispatchCommand(mxComponent, ".uno:ToggleMergeCells", {}); + goToCell("A4:A6"); + dispatchCommand(mxComponent, ".uno:ToggleMergeCells", {}); + + goToCell("A1:A6"); + + ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); + pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_SHIFT | KEY_UP); + Scheduler::ProcessEventsToIdle(); + + ScRangeList aMarkedArea = getViewShell()->GetViewData().GetMarkData().GetMarkedRanges(); + ScDocument* pDoc = getScDoc(); + OUString aMarkedAreaString; + ScRangeStringConverter::GetStringFromRangeList(aMarkedAreaString, &aMarkedArea, pDoc, + formula::FormulaGrammar::CONV_OOO); + + // Without the fix in place, this test would have failed with + // - Expected: Sheet1.A1:Sheet1.A3 + // - Actual : Sheet1.A1:Sheet1.A5 + CPPUNIT_ASSERT_EQUAL(OUString("Sheet1.A1:Sheet1.A3"), aMarkedAreaString); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf156174) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + insertNewSheet(*pDoc); + + insertStringToCell("A1", u"1"); + insertStringToCell("A2", u"2"); + insertStringToCell("B1", u"3"); + insertStringToCell("B2", u"4"); + + ScDBData* pDBData = new ScDBData("testDB", 1, 0, 0, 1, 1); + bool bInserted + = pDoc->GetDBCollection()->getNamedDBs().insert(std::unique_ptr<ScDBData>(pDBData)); + CPPUNIT_ASSERT(bInserted); + + insertNewSheet(*pDoc); + uno::Sequence<beans::PropertyValue> aArgs( + comphelper::InitPropertySequence({ { "Index", uno::Any(sal_uInt16(3)) } })); + dispatchCommand(mxComponent, ".uno:Remove", aArgs); + + ScDBCollection* pDBs = pDoc->GetDBCollection(); + CPPUNIT_ASSERT(!pDBs->empty()); +} + +CPPUNIT_TEST_FIXTURE(ScUiCalcTest2, testTdf154044) +{ + createScDoc(); + ScDocument* pDoc = getScDoc(); + + auto getBackColor = [pDoc](SCCOL c) { + const ScPatternAttr* pattern = pDoc->GetPattern(c, 0, 0); + const SvxBrushItem& brush = pattern->GetItemSet().Get(ATTR_BACKGROUND); + return brush.GetColor(); + }; + + CPPUNIT_ASSERT_EQUAL(INITIALCOLCOUNT, pDoc->GetAllocatedColumnsCount(0)); + for (SCCOL i = 0; i <= pDoc->MaxCol(); ++i) + { + OString msg = "i=" + OString::number(i); + CPPUNIT_ASSERT_EQUAL_MESSAGE(msg.getStr(), COL_AUTO, getBackColor(i)); + } + + // Set the background color of A1:CV1 + auto aColorArg( + comphelper::InitPropertySequence({ { "BackgroundColor", uno::Any(COL_LIGHTBLUE) } })); + goToCell("A1:CV1"); + dispatchCommand(mxComponent, ".uno:BackgroundColor", aColorArg); + + // Partial row range allocates necessary columns + CPPUNIT_ASSERT_EQUAL(SCCOL(100), pDoc->GetAllocatedColumnsCount(0)); + + // Check that settings are applied + for (SCCOL i = 0; i < 100; ++i) + { + OString msg = "i=" + OString::number(i); + CPPUNIT_ASSERT_EQUAL_MESSAGE(msg.getStr(), COL_LIGHTBLUE, getBackColor(i)); + } + + // Undo + SfxUndoManager* pUndoMgr = pDoc->GetUndoManager(); + CPPUNIT_ASSERT(pUndoMgr); + pUndoMgr->Undo(); + + // Check that all the cells have restored the setting + for (SCCOL i = 0; i < 100; ++i) + { + OString msg = "i=" + OString::number(i); + // Without the fix in place, this would fail with + // - Expected: rgba[ffffff00] + // - Actual : rgba[0000ffff] + // - i=1 + CPPUNIT_ASSERT_EQUAL_MESSAGE(msg.getStr(), COL_AUTO, getBackColor(i)); + } + + // Also check the whole row selection case - it is handled specially: columns are not allocated. + // See commit 3db91487e57277f75d64d95d06d4ddcc29f1c4e0 (set properly attributes for cells in + // unallocated Calc columns, 2022-03-04). + goToCell("A1:" + pDoc->MaxColAsString() + "1"); + dispatchCommand(mxComponent, ".uno:BackgroundColor", aColorArg); + + // Check that settings are applied + for (SCCOL i = 0; i <= pDoc->MaxCol(); ++i) + { + OString msg = "i=" + OString::number(i); + CPPUNIT_ASSERT_EQUAL_MESSAGE(msg.getStr(), COL_LIGHTBLUE, getBackColor(i)); + } + + // Undo + pUndoMgr->Undo(); + + // No additional columns have been allocated for whole-row range + CPPUNIT_ASSERT_EQUAL(SCCOL(100), pDoc->GetAllocatedColumnsCount(0)); + + // Check that all the cells have restored the setting + for (SCCOL i = 0; i <= pDoc->MaxCol(); ++i) + { + OString msg = "i=" + OString::number(i); + CPPUNIT_ASSERT_EQUAL_MESSAGE(msg.getStr(), COL_AUTO, getBackColor(i)); + } +} + +CPPUNIT_PLUGIN_IMPLEMENT(); + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |