| Quellcodebibliothek Statistik Leitseite products/Sources/formale Sprachen/C/LibreOffice/sc/qa/unit/tiledrendering/ (Office von Apache Version 25.8.3.2©) Datei vom 5.10.2025 mit Größe 143 kB |
|
Quelle tiledrendering.cxxSprache: C |
|||||||||||||||
|
/* -*- 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 <sctiledrenderingtest.hxx> #include <boost/property_tree/json_parser.hpp> #include <com/sun/star/datatransfer/clipboard/LokClipboard.hpp> #include <com/sun/star/util/URLTransformer.hpp> #include <test/helper/transferable.hxx> #include <comphelper/processfactory.hxx> #include <comphelper/propertysequence.hxx> #include <comphelper/servicehelper.hxx> #include <sfx2/dispatch.hxx> #include <sfx2/viewfrm.hxx> #include <svl/stritem.hxx> #include <svl/numformat.hxx> #include <svl/zformat.hxx> #include <LibreOfficeKit/LibreOfficeKitEnums.h> #include <vcl/scheduler.hxx> #include <comphelper/lok.hxx> #include <comphelper/propertyvalue.hxx> #include <comphelper/dispatchcommand.hxx> #include <sfx2/msgpool.hxx> #include <sfx2/childwin.hxx> #include <sfx2/lokhelper.hxx> #include <svx/svdpage.hxx> #include <vcl/vclevent.hxx> #include <vcl/virdev.hxx> #include <tools/json_writer.hxx> #include <unotools/syslocaleoptions.hxx> #include <sc.hrc> #include <postit.hxx> #include <attrib.hxx> #include <scitems.hxx> #include <document.hxx> #include <docuno.hxx> #include <drwlayer.hxx> #include <editutil.hxx> #include <undomanager.hxx> #include <docsh.hxx> #include <tabvwsh.hxx> #include <sctestviewcallback.hxx> using namespace com::sun::star; static std::ostream& operator<<(std::ostream& os, ViewShellId const & id) { os << static_cast<sal_Int32>(id); return os; } namespace { // for passing data to testInvalidateOnTextEditWithDifferentZoomLevels struct ColRowZoom { SCCOL col; SCROW row; int zoom; }; } CPPUNIT_NS_BEGIN namespace StringHelper { // used by CPPUNIT_TEST_PARAMETERIZED for testInvalidateOnTextEditWithDifferentZoomLe template<> inline std::string toString(const ColRowZoom& item) { std::ostringstream ss; ss << "zoom level: " << item.zoom << ", " "col: " << item.col << ", " "row: " << item.row; return ss.str(); } } CPPUNIT_NS_END CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testRowColumnSelections) { ScModelObj* pModelObj = createDoc("select-row-cols.ods"); // Select the 5th row with no modifier uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "Row", uno::Any(sal_Int32(5 - 1)) }, { "Modifier", uno::Any(sal_uInt16(0)) } })); dispatchCommand(mxComponent, u".uno:SelectRow"_ustr, aArgs); // Check if it is selected OString aResult = apitest::helper::transferable::getTextSelection(pModelObj->getSele OString aExpected("1\t2\t3\t4\t5\t6\t7\t8\t9\t10\t11\t12\t13\t14\t15\t16\t17\t18\ CPPUNIT_ASSERT_EQUAL(aExpected, aResult); // Select the 10th row with shift modifier aArgs = comphelper::InitPropertySequence({ { "Row", uno::Any(static_cast<sal_Int32>(10 - { "Modifier", uno::Any(KEY_SHIFT) } }); dispatchCommand(mxComponent, u".uno:SelectRow"_ustr, aArgs); // Check if all the rows from 5th to 10th get selected aResult = apitest::helper::transferable::getTextSelection(pModelObj->getSelection() aExpected = "1\t2\t3\t4\t5\t6\t7\t8\t9\t10\t11\t12\t13\t14\t15\t16\t17\t18\t19\t20 CPPUNIT_ASSERT_EQUAL(aExpected, aResult); // Select the 10th row with ctrl modifier aArgs = comphelper::InitPropertySequence({ { "Row", uno::Any(static_cast<sal_Int32>(13 - { "Modifier", uno::Any(KEY_MOD1) } }); dispatchCommand(mxComponent, u".uno:SelectRow"_ustr, aArgs); // When we copy this, we don't get anything useful, but we must not crash // (used to happen) aResult = apitest::helper::transferable::getTextSelection(pModelObj->getSelection() CPPUNIT_ASSERT_EQUAL("9"_ostr, aResult); // TODO check that we really selected what we wanted here // Select Column 5 with ctrl modifier aArgs = comphelper::InitPropertySequence({ { "Col", uno::Any(static_cast<sal_Int32>(5 - 1 { "Modifier", uno::Any(KEY_MOD1) } }); dispatchCommand(mxComponent, u".uno:SelectColumn"_ustr, aArgs); // When we copy this, we don't get anything useful, but we must not crash // (used to happen) aResult = apitest::helper::transferable::getTextSelection(pModelObj->getSelection() CPPUNIT_ASSERT_EQUAL("1"_ostr, aResult); // TODO check that we really selected what we wanted here // Test for deselection of already selected rows // First Deselect Row 13 because copy doesn't work for multiple selections aArgs = comphelper::InitPropertySequence({ { "Row", uno::Any(static_cast<sal_Int32>(13 - { "Modifier", uno::Any(KEY_MOD1) } }); dispatchCommand(mxComponent, u".uno:SelectRow"_ustr, aArgs); // Deselect row 10 aArgs = comphelper::InitPropertySequence({ { "Row", uno::Any(static_cast<sal_Int32>(10 - { "Modifier", uno::Any(KEY_MOD1) } }); dispatchCommand(mxComponent, u".uno:SelectRow"_ustr, aArgs); // Click at row 6 holding shift aArgs = comphelper::InitPropertySequence({ { "Row", uno::Any(static_cast<sal_Int32>(6 - 1 { "Modifier", uno::Any(KEY_SHIFT) } }); dispatchCommand(mxComponent, u".uno:SelectRow"_ustr, aArgs); // only row 5 should remain selected aResult = apitest::helper::transferable::getTextSelection(pModelObj->getSelection() aExpected = "1\t2\t3\t4\t5\t6\t7\t8\t9\t10\t11\t12\t13\t14\t15\t16\t17\t18\t19\t20 CPPUNIT_ASSERT_EQUAL(aExpected, aResult); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testPartHash) { ScModelObj* pModelObj = createDoc("sort-range.ods"); int nParts = pModelObj->getParts(); for (int it = 0; it < nParts; it++) { CPPUNIT_ASSERT(!pModelObj->getPartHash(it).isEmpty()); } // check part that it does not exists CPPUNIT_ASSERT(pModelObj->getPartHash(100).isEmpty()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testDocumentSize) { ScModelObj* pModelObj = createDoc("sort-range.ods"); ScDocShell* pDocSh = dynamic_cast< ScDocShell* >( pModelObj->GetEmbeddedObject() ); CPPUNIT_ASSERT(pDocSh); ScTabViewShell* pViewShell = pDocSh->GetBestViewShell(false); CPPUNIT_ASSERT(pViewShell); setupLibreOfficeKitViewCallback(pViewShell); // check initial document size Size aDocSize = pModelObj->getDocumentSize(); CPPUNIT_ASSERT(aDocSize.Width() > 0); CPPUNIT_ASSERT(aDocSize.Height() > 0); // Set cursor column pViewShell->SetCursor(100, 0); // 2 seconds osl::Condition::Result aResult = m_aDocSizeCondition.wait(std::chrono::seconds(2)); CPPUNIT_ASSERT_EQUAL(osl::Condition::result_ok, aResult); // Set cursor row pViewShell->SetCursor(0, 100); // 2 seconds aResult = m_aDocSizeCondition.wait(std::chrono::seconds(2)); CPPUNIT_ASSERT_EQUAL(osl::Condition::result_ok, aResult); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testEmptyColumnSelection) { ScModelObj* pModelObj = createDoc("select-row-cols.ods"); // Select empty column, 1000 uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "Col", uno::Any(sal_Int32(1000 - 1)) }, { "Modifier", uno::Any(sal_uInt16(0)) } })); dispatchCommand(mxComponent, u".uno:SelectColumn"_ustr, aArgs); // should be an empty string CPPUNIT_ASSERT_EQUAL(OString(), apitest::helper::transferable::getTextSelection(p } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testViewCursors) { ScModelObj* pModelObj = createDoc("select-row-cols.ods"); ScTestViewCallback aView1; SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2(/*bDeleteListenerOnDestruct*/false); // This was false, the new view did not get the view (cell) cursor of the old view. CPPUNIT_ASSERT(aView2.m_bViewCursorInvalidated); CPPUNIT_ASSERT(aView2.m_bOwnCursorInvalidated); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DOWN); Scheduler::ProcessEventsToIdle(); SfxLokHelper::destroyView(SfxLokHelper::getView()); CPPUNIT_ASSERT(aView1.m_bViewCursorInvalidated); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testSpellOnlineRenderParameter) { ScModelObj* pModelObj = createDoc("empty.ods"); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); bool bSet = pView->IsAutoSpell(); uno::Sequence<beans::PropertyValue> aPropertyValues = { comphelper::makePropertyValue(u".uno:SpellOnline"_ustr, uno::Any(!bSet)), }; pModelObj->initializeForTiledRendering(aPropertyValues); CPPUNIT_ASSERT_EQUAL(!bSet, pView->IsAutoSpell()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testTextViewSelection) { // Create two views, and leave the second one current. ScModelObj* pModelObj = createDoc("select-row-cols.ods"); ScTestViewCallback aView1; SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // Create a selection on two cells in the second view, that's a text selection in LOK terms. aView1.m_bTextViewSelectionInvalidated = false; dispatchCommand(mxComponent, u".uno:GoRightSel"_ustr, {}); // Make sure the first view got its notification. CPPUNIT_ASSERT(aView1.m_bTextViewSelectionInvalidated); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testDocumentSizeChanged) { // Load a document that doesn't have much content. createDoc("small.ods"); setupLibreOfficeKitViewCallback(SfxViewShell::Current()); // Go to the A30 cell -- that will extend the document size. uno::Sequence<beans::PropertyValue> aPropertyValues = { comphelper::makePropertyValue(u"ToPoint"_ustr, u"$A$30"_ustr), }; dispatchCommand(mxComponent, u".uno:GoToCell"_ustr, aPropertyValues); // Assert that the size in the payload is not 0. CPPUNIT_ASSERT(m_aDocumentSize.getWidth() > 0); CPPUNIT_ASSERT(m_aDocumentSize.getHeight() > 0); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testViewLock) { // Load a document that has a shape and create two views. ScModelObj* pModelObj = createDoc("shape.ods"); ScTestViewCallback aView1; SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // Begin text edit in the second view and assert that the first gets a lock // notification. const ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); ScTabViewShell* pViewShell = pViewData->GetViewShell(); CPPUNIT_ASSERT(pViewShell); SdrModel* pDrawModel = pViewData->GetDocument().GetDrawLayer(); SdrPage* pDrawPage = pDrawModel->GetPage(0); SdrObject* pObject = pDrawPage->GetObj(0); SdrView* pView = pViewShell->GetScDrawView(); aView1.m_bViewLock = false; pView->SdrBeginTextEdit(pObject); CPPUNIT_ASSERT(aView1.m_bViewLock); // End text edit in the second view, and assert that the lock is removed in // the first view. pView->SdrEndTextEdit(); CPPUNIT_ASSERT(!aView1.m_bViewLock); } namespace { void lcl_extractHandleParameters(std::string_view selection, sal_uInt32& id, sal_ { OString extraInfo( selection.substr(selection.find("{")) ); std::stringstream aStream((std::string(extraInfo))); boost::property_tree::ptree aTree; boost::property_tree::read_json(aStream, aTree); boost::property_tree::ptree handle0 = aTree .get_child("handles") .get_child("kinds") .get_child("rectangle") .get_child("1") .begin()->second; id = handle0.get_child("id").get_value<int>(); x = handle0.get_child("point").get_child("x").get_value<int>(); y = handle0.get_child("point").get_child("y").get_value<int>(); } } //namespace CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testMoveShapeHandle) { ScModelObj* pModelObj = createDoc("shape.ods"); ScTestViewCallback aView1; pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, /*x=*/ 1,/*y=*/ 1,/*count= pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, /*x=*/ 1, /*y=*/ 1, /*count=*/ Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView1.m_ShapeSelection.isEmpty()); { sal_uInt32 id, x, y; lcl_extractHandleParameters(aView1.m_ShapeSelection, id, x ,y); sal_uInt32 oldX = x; sal_uInt32 oldY = y; uno::Sequence<beans::PropertyValue> aPropertyValues(comphelper::InitPropertySequenc { {"HandleNum", uno::Any(id)}, {"NewPosX", uno::Any(x+1)}, {"NewPosY", uno::Any(y+1)} })); dispatchCommand(mxComponent, u".uno:MoveShapeHandle"_ustr, aPropertyValues); CPPUNIT_ASSERT(!aView1.m_ShapeSelection.isEmpty()); lcl_extractHandleParameters(aView1.m_ShapeSelection, id, x ,y); CPPUNIT_ASSERT_EQUAL(x-1, oldX); CPPUNIT_ASSERT_EQUAL(y-1, oldY); } } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testColRowResize) { ScModelObj* pModelObj = createDoc("sort-range.ods"); ScDocShell* pDocSh = dynamic_cast< ScDocShell* >( pModelObj->GetEmbeddedObject() ); CPPUNIT_ASSERT(pDocSh); ScTabViewShell* pViewShell = pDocSh->GetBestViewShell(false); CPPUNIT_ASSERT(pViewShell); setupLibreOfficeKitViewCallback(pViewShell); ScDocument& rDoc = pDocSh->GetDocument(); // Col 3, Tab 0 uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "ColumnWidth", uno::Any(sal_uInt16(4000)) }, // 4cm { "Column", uno::Any(sal_Int16(3)) } })); dispatchCommand(mxComponent, u".uno:ColumnWidth"_ustr, aArgs); sal_uInt16 nWidth = o3tl::convert(rDoc.GetColWidth(static_cast<SCCOL>(2), static_cast<S CPPUNIT_ASSERT_EQUAL(static_cast<sal_uInt16>(4001), nWidth); // Row 5, Tab 0 uno::Sequence<beans::PropertyValue> aArgs2( comphelper::InitPropertySequence({ { "RowHeight", uno::Any(sal_uInt16(2000)) }, { "Row", uno::Any(sal_Int16(5)) }, })); dispatchCommand(mxComponent, u".uno:RowHeight"_ustr, aArgs2); sal_uInt16 nHeight = o3tl::convert(rDoc.GetRowHeight(static_cast<SCROW>(4), static_cas CPPUNIT_ASSERT_EQUAL(static_cast<sal_uInt16>(2000), nHeight); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testUndoShells) { ScModelObj* pModelObj = createDoc("small.ods"); // Clear the currently selected cell. dispatchCommand(mxComponent, u".uno:ClearContents"_ustr, {}); auto pDocShell = dynamic_cast<ScDocShell*>(pModelObj->GetEmbeddedObject()); CPPUNIT_ASSERT(pDocShell); ScDocument& rDoc = pDocShell->GetDocument(); ScUndoManager* pUndoManager = rDoc.GetUndoManager(); CPPUNIT_ASSERT(pUndoManager); CPPUNIT_ASSERT_EQUAL(static_cast<size_t>(1), pUndoManager->GetUndoActionCount()); sal_Int32 nView1 = SfxLokHelper::getView(); // This was -1: ScSimpleUndo did not remember what view shell created it. CPPUNIT_ASSERT_EQUAL(ViewShellId(nView1), pUndoManager->GetUndoAction()->GetViewShe } namespace { bool lcl_hasEditView(const ScViewData& rViewData) { bool bResult = false; for (unsigned int i=0; i<4; i++) { bResult = rViewData.HasEditView( static_cast<ScSplitPos>(i) ); if (bResult) break; } return bResult; } } // namespace CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testTextEditViews) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); // view #1 ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); // text edit a cell in view #1 pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(lcl_hasEditView(*pViewData)); // view #2 SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // move cell cursor i view #2 pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DOWN); Scheduler::ProcessEventsToIdle(); // check that text edit view in view #1 has not be killed CPPUNIT_ASSERT(lcl_hasEditView(*pViewData)); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testTextEditViewInvalidations) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); // view #1 int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); // view #2 SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // text edit a cell in view #1 SfxLokHelper::setView(nView1); aView2.m_bInvalidateTiles = false; pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(lcl_hasEditView(*pViewData)); CPPUNIT_ASSERT(aView2.m_bInvalidateTiles); // text edit a cell in view #1 until // we can be sure we are out of the initial tile for (int i = 0; i < 40; ++i) { pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); } Scheduler::ProcessEventsToIdle(); // text edit a cell in view #1 inside the new tile and // check that view #2 receive a tile invalidate message aView2.m_bInvalidateTiles = false; pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView2.m_bInvalidateTiles); // view #3 SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView3; // text edit a cell in view #1 SfxLokHelper::setView(nView1); aView3.m_bInvalidateTiles = false; pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'y', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'y', 0); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView3.m_bInvalidateTiles); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testCreateViewGraphicSelection) { // Load a document that has a shape and create two views. ScModelObj* pModelObj = createDoc("shape.ods"); ScTestViewCallback aView1; // Mark the graphic in the first view. const ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); ScTabViewShell* pViewShell = pViewData->GetViewShell(); CPPUNIT_ASSERT(pViewShell); SdrModel* pDrawModel = pViewData->GetDocument().GetDrawLayer(); SdrPage* pDrawPage = pDrawModel->GetPage(0); SdrObject* pObject = pDrawPage->GetObj(0); SdrView* pView = pViewShell->GetScDrawView(); aView1.m_bGraphicSelection = false; aView1.m_bGraphicViewSelection = false; pView->MarkObj(pObject, pView->GetSdrPageView()); CPPUNIT_ASSERT(aView1.m_bGraphicSelection); // Create a second view. int nView1 = SfxLokHelper::getView(); SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; CPPUNIT_ASSERT(aView2.m_bGraphicViewSelection); CPPUNIT_ASSERT(aView1.m_bGraphicViewSelection); SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testGraphicInvalidate) { // Load a document that has a shape and create two views. ScModelObj* pModelObj = createDoc("shape.ods"); ScTestViewCallback aView; // Click to select graphic aView.m_bGraphicSelection = false; pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, /*x=*/ 1,/*y=*/ 1,/*count= pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, /*x=*/ 1, /*y=*/ 1, /*count=*/ Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView.m_bGraphicSelection); // Drag Drop graphic aView.m_bGraphicSelection = false; pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, /*x=*/ 1,/*y=*/ 1,/*count= pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEMOVE, /*x=*/ 1,/*y=*/ 10,/*count=*/ 1, / pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, /*x=*/ 1, /*y=*/ 10, /*count=* Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView.m_bFullInvalidateTiles); // Check again Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView.m_bFullInvalidateTiles); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testAutoSum) { createDoc("small.ods"); ScTestViewCallback aView; uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:AutoSum"_ustr, aArgs); CPPUNIT_ASSERT(aView.m_sCellFormula.startsWith("=SUM(")); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testHideColRow) { createDoc("small.ods"); { uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "Col", uno::Any(sal_Int32(2 - 1)) }, { "Modifier", uno::Any(KEY_SHIFT) } })); dispatchCommand(mxComponent, u".uno:SelectColumn"_ustr, aArgs); uno::Sequence<beans::PropertyValue> aArgs2( comphelper::InitPropertySequence({ { "Col", uno::Any(sal_Int32(3 - 1)) }, { "Modifier", uno::Any(sal_uInt16(0)) } })); dispatchCommand(mxComponent, u".uno:SelectColumn"_ustr, aArgs2); } ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); SCCOL nOldCurX = pViewData->GetCurX(); SCROW nOldCurY = pViewData->GetCurY(); { uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:HideColumn"_ustr, aArgs); } SCCOL nNewCurX = pViewData->GetCurX(); SCROW nNewCurY = pViewData->GetCurY(); CPPUNIT_ASSERT(nNewCurX > nOldCurX); CPPUNIT_ASSERT_EQUAL(nOldCurY, nNewCurY); { uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "Row", uno::Any(sal_Int32(6 - 1)) }, { "Modifier", uno::Any(KEY_SHIFT) } })); dispatchCommand(mxComponent, u".uno:SelectRow"_ustr, aArgs); uno::Sequence<beans::PropertyValue> aArgs2( comphelper::InitPropertySequence({ { "Row", uno::Any(sal_Int32(7 - 1)) }, { "Modifier", uno::Any(sal_uInt16(0)) } })); dispatchCommand(mxComponent, u".uno:SelectRow"_ustr, aArgs2); } nOldCurX = pViewData->GetCurX(); nOldCurY = pViewData->GetCurY(); { uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:HideRow"_ustr, aArgs); } nNewCurX = pViewData->GetCurX(); nNewCurY = pViewData->GetCurY(); CPPUNIT_ASSERT(nNewCurY > nOldCurY); CPPUNIT_ASSERT_EQUAL(nOldCurX, nNewCurX); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testInvalidateOnCopyPasteCells) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); // view ScTestViewCallback aView; uno::Sequence<beans::PropertyValue> aArgs; // select and copy cells pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_HOME | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_HOME | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_RIGHT | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_RIGHT | KEY_SHIFT); Scheduler::ProcessEventsToIdle(); dispatchCommand(mxComponent, u".uno:Copy"_ustr, aArgs); // move to destination cell pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_UP); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_UP); Scheduler::ProcessEventsToIdle(); // paste cells aView.m_bInvalidateTiles = false; dispatchCommand(mxComponent, u".uno:Paste"_ustr, aArgs); CPPUNIT_ASSERT(aView.m_bInvalidateTiles); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testInvalidateOnInserRowCol) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); // view ScTestViewCallback aView; uno::Sequence<beans::PropertyValue> aArgs; // move downward for (int i = 0; i < 200; ++i) { pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN); } Scheduler::ProcessEventsToIdle(); // insert row aView.m_bInvalidateTiles = false; aView.m_aInvalidations.clear(); dispatchCommand(mxComponent, u".uno:InsertRows"_ustr, aArgs); CPPUNIT_ASSERT(aView.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(1), aView.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(-75, 51240, 32212230, 63990), aView.m_aInvalid // move on the right for (int i = 0; i < 200; ++i) { pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_RIGHT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_RIGHT); } Scheduler::ProcessEventsToIdle(); // insert column aView.m_bInvalidateTiles = false; aView.m_aInvalidations.clear(); dispatchCommand(mxComponent, u".uno:InsertColumns"_ustr, aArgs); CPPUNIT_ASSERT(aView.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(1), aView.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(254925, -15, 32212230, 63990), aView.m_aInvali } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testCommentCallback) { // Comments callback are emitted only if tiled annotations are off comphelper::LibreOfficeKit::setTiledAnnotations(false); // FIXME: Hack because previous tests do not destroy ScDocument(with annotations) on exit (?) ScPostIt::mnLastPostItId = 1; { ScModelObj* pModelObj = createDoc("small.ods"); ScTestViewCallback aView1; int nView1 = SfxLokHelper::getView(); // Create a 2nd view SfxLokHelper::createView(); pModelObj->initializeForTiledRendering({}); ScTestViewCallback aView2; SfxLokHelper::setView(nView1); ScTabViewShell* pTabViewShell = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current() if (pTabViewShell) pTabViewShell->SetCursor(4, 4); // Add a new comment uno::Sequence<beans::PropertyValue> aArgs(comphelper::InitPropertySequence( { {"Text", uno::Any(u"Comment"_ustr)}, {"Author", uno::Any(u"LOK User1"_ustr)}, })); dispatchCommand(mxComponent, u".uno:InsertAnnotation"_ustr, aArgs); // We received a LOK_CALLBACK_COMMENT callback with comment 'Add' action CPPUNIT_ASSERT_EQUAL(std::string("Add"), aView1.m_aCommentCallbackResult.get<std:: CPPUNIT_ASSERT_EQUAL(std::string("Add"), aView2.m_aCommentCallbackResult.get<std:: CPPUNIT_ASSERT_EQUAL(std::string("1"), aView1.m_aCommentCallbackResult.get<std::st CPPUNIT_ASSERT_EQUAL(std::string("1"), aView2.m_aCommentCallbackResult.get<std::st CPPUNIT_ASSERT_EQUAL(std::string("0"), aView1.m_aCommentCallbackResult.get<std::st CPPUNIT_ASSERT_EQUAL(std::string("0"), aView2.m_aCommentCallbackResult.get<std::st CPPUNIT_ASSERT_EQUAL(std::string("LOK User1"), aView1.m_aCommentCallbackResult.get< CPPUNIT_ASSERT_EQUAL(std::string("LOK User1"), aView2.m_aCommentCallbackResult.get< CPPUNIT_ASSERT_EQUAL(std::string("Comment"), aView1.m_aCommentCallbackResult.get<s CPPUNIT_ASSERT_EQUAL(std::string("Comment"), aView2.m_aCommentCallbackResult.get<s CPPUNIT_ASSERT_EQUAL(std::string("4 4 4 4"), aView1.m_aCommentCallbackResult.get<std: CPPUNIT_ASSERT_EQUAL(std::string("4 4 4 4"), aView2.m_aCommentCallbackResult.get<std: // Ensure deleting rows updates comments if (pTabViewShell) pTabViewShell->SetCursor(2, 2); dispatchCommand(mxComponent, u".uno:DeleteRows"_ustr, {}); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(std::string("4 3 4 3"), aView1.m_aCommentCallbackResult.get<std: CPPUNIT_ASSERT_EQUAL(std::string("4 3 4 3"), aView2.m_aCommentCallbackResult.get<std: // Ensure deleting columns updates comments if (pTabViewShell) pTabViewShell->SetCursor(2, 2); dispatchCommand(mxComponent, u".uno:DeleteColumns"_ustr, {}); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(std::string("3 3 3 3"), aView1.m_aCommentCallbackResult.get<std: CPPUNIT_ASSERT_EQUAL(std::string("3 3 3 3"), aView2.m_aCommentCallbackResult.get<std: std::string aCommentId = aView1.m_aCommentCallbackResult.get<std::string>("id"); // Edit a comment // Select some random cell, we should be able to edit the cell note without // selecting the cell if (pTabViewShell) pTabViewShell->SetCursor(3, 100); aArgs = comphelper::InitPropertySequence( { {"Id", uno::Any(OUString::createFromAscii(aCommentId))}, {"Text", uno::Any(u"Edited comment"_ustr)}, {"Author", uno::Any(u"LOK User2"_ustr)}, }); dispatchCommand(mxComponent, u".uno:EditAnnotation"_ustr, aArgs); // We received a LOK_CALLBACK_COMMENT callback with comment 'Modify' action CPPUNIT_ASSERT_EQUAL(std::string("Modify"), aView1.m_aCommentCallbackResult.get<st CPPUNIT_ASSERT_EQUAL(std::string("Modify"), aView2.m_aCommentCallbackResult.get<st CPPUNIT_ASSERT_EQUAL(aCommentId, aView1.m_aCommentCallbackResult.get<std::string>(" CPPUNIT_ASSERT_EQUAL(aCommentId, aView2.m_aCommentCallbackResult.get<std::string>(" CPPUNIT_ASSERT_EQUAL(std::string("LOK User2"), aView1.m_aCommentCallbackResult.get< CPPUNIT_ASSERT_EQUAL(std::string("LOK User2"), aView2.m_aCommentCallbackResult.get< CPPUNIT_ASSERT_EQUAL(std::string("Edited comment"), aView1.m_aCommentCallbackResul CPPUNIT_ASSERT_EQUAL(std::string("Edited comment"), aView2.m_aCommentCallbackResul CPPUNIT_ASSERT_EQUAL(std::string("3 3 3 3"), aView1.m_aCommentCallbackResult.get<std: CPPUNIT_ASSERT_EQUAL(std::string("3 3 3 3"), aView2.m_aCommentCallbackResult.get<std: // Delete the comment if (pTabViewShell) pTabViewShell->SetCursor(4, 43); aArgs = comphelper::InitPropertySequence( { {"Id", uno::Any(OUString::createFromAscii(aCommentId))} }); dispatchCommand(mxComponent, u".uno:DeleteNote"_ustr, aArgs); // We received a LOK_CALLBACK_COMMENT callback with comment 'Remove' action CPPUNIT_ASSERT_EQUAL(std::string("Remove"), aView1.m_aCommentCallbackResult.get<st CPPUNIT_ASSERT_EQUAL(std::string("Remove"), aView2.m_aCommentCallbackResult.get<st CPPUNIT_ASSERT_EQUAL(aCommentId, aView1.m_aCommentCallbackResult.get<std::string>(" CPPUNIT_ASSERT_EQUAL(aCommentId, aView2.m_aCommentCallbackResult.get<std::string>(" } comphelper::LibreOfficeKit::setTiledAnnotations(true); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testUndoLimiting) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); ScDocument* pDoc = pModelObj->GetDocument(); CPPUNIT_ASSERT(pDoc); ScUndoManager* pUndoManager = pDoc->GetUndoManager(); CPPUNIT_ASSERT(pUndoManager); // view #1 int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; // view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // text edit a cell in view #1 SfxLokHelper::setView(nView1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); // check that undo action count in not 0 CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); // try to execute undo in view #2 SfxLokHelper::setView(nView2); dispatchCommand(mxComponent, u".uno:Undo"_ustr, {}); // check that undo has not been executed on view #2 CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); // try to execute undo in view #1 SfxLokHelper::setView(nView1); dispatchCommand(mxComponent, u".uno:Undo"_ustr, {}); // check that undo has been executed on view #1 CPPUNIT_ASSERT_EQUAL(std::size_t(0), pUndoManager->GetUndoActionCount()); // check that redo action count in not 0 CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetRedoActionCount()); // try to execute redo in view #2 SfxLokHelper::setView(nView2); dispatchCommand(mxComponent, u".uno:Redo"_ustr, {}); // check that redo has not been executed on view #2 CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetRedoActionCount()); // try to execute redo in view #1 SfxLokHelper::setView(nView1); dispatchCommand(mxComponent, u".uno:Redo"_ustr, {}); // check that redo has been executed on view #1 CPPUNIT_ASSERT_EQUAL(std::size_t(0), pUndoManager->GetRedoActionCount()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testUndoRepairDispatch) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); ScDocument* pDoc = pModelObj->GetDocument(); CPPUNIT_ASSERT(pDoc); ScUndoManager* pUndoManager = pDoc->GetUndoManager(); CPPUNIT_ASSERT(pUndoManager); // view #1 int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; // view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // text edit a cell in view #1 SfxLokHelper::setView(nView1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); // check that undo action count in not 0 CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); // try to execute undo in view #2 SfxLokHelper::setView(nView2); dispatchCommand(mxComponent, u".uno:Undo"_ustr, {}); // check that undo has not been executed on view #2 CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); // try to execute undo in view #2 in repair mode SfxLokHelper::setView(nView2); uno::Sequence<beans::PropertyValue> aPropertyValues(comphelper::InitPropertySequenc { {"Repair", uno::Any(true)} })); dispatchCommand(mxComponent, u".uno:Undo"_ustr, aPropertyValues); // check that undo has been executed on view #2 in repair mode CPPUNIT_ASSERT_EQUAL(std::size_t(0), pUndoManager->GetUndoActionCount()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testInsertGraphicInvalidations) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); // view ScTestViewCallback aView; // we need to paint a tile in the view for triggering the tile invalidation solution int nCanvasWidth = 256; int nCanvasHeight = 256; std::vector<unsigned char> aBuffer(nCanvasWidth * nCanvasHeight * 4); ScopedVclPtrInstance<VirtualDevice> pDevice(DeviceFormat::WITHOUT_ALPHA); pDevice->SetOutputSizePixelScaleOffsetAndLOKBuffer(Size(nCanvasWidth, nCanvasHeigh pModelObj->paintTile(*pDevice, nCanvasWidth, nCanvasHeight, /*nTilePosX=*/0, /*nTileP Scheduler::ProcessEventsToIdle(); // insert an image in view and see if both views are invalidated aView.m_bInvalidateTiles = false; uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "FileName", uno::Any(createFileURL(u"smile.png")) } })); dispatchCommand(mxComponent, u".uno:InsertGraphic"_ustr, aArgs); CPPUNIT_ASSERT(aView.m_bInvalidateTiles); // undo image insertion in view and see if both views are invalidated aView.m_bInvalidateTiles = false; uno::Sequence<beans::PropertyValue> aArgs2; dispatchCommand(mxComponent, u".uno:Undo"_ustr, aArgs2); CPPUNIT_ASSERT(aView.m_bInvalidateTiles); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testDocumentSizeWithTwoViews) { // Open a document that has the cursor far away & paint a tile ScModelObj* pModelObj = createDoc("cursor-away.ods"); // Set the visible area, and press page down pModelObj->setClientVisibleArea(tools::Rectangle(750, 1861, 20583, 6997)); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEDOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEDOWN); Scheduler::ProcessEventsToIdle(); int nCanvasWidth = 256; int nCanvasHeight = 256; std::vector<unsigned char> aBuffer1(nCanvasWidth * nCanvasHeight * 4); ScopedVclPtrInstance<VirtualDevice> pDevice1(DeviceFormat::WITHOUT_ALPHA); pDevice1->SetOutputSizePixelScaleOffsetAndLOKBuffer(Size(nCanvasWidth, nCanvasHeig pModelObj->paintTile(*pDevice1, nCanvasWidth, nCanvasHeight, /*nTilePosX=*/0, /*nTile Scheduler::ProcessEventsToIdle(); // Create a new view int nView1 = SfxLokHelper::getView(); SfxLokHelper::createView(); std::vector<unsigned char> aBuffer2(nCanvasWidth * nCanvasHeight * 4); ScopedVclPtrInstance<VirtualDevice> pDevice2(DeviceFormat::WITHOUT_ALPHA); pDevice2->SetOutputSizePixelScaleOffsetAndLOKBuffer(Size(nCanvasWidth, nCanvasHeig pModelObj->paintTile(*pDevice2, nCanvasWidth, nCanvasHeight, /*nTilePosX=*/0, /*nTile Scheduler::ProcessEventsToIdle(); // Check that the tiles actually have the same content for (size_t i = 0; i < aBuffer1.size(); ++i) CPPUNIT_ASSERT_EQUAL(aBuffer1[i], aBuffer2[i]); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testDisableUndoRepair) { ScModelObj* pModelObj = createDoc("cursor-away.ods"); CPPUNIT_ASSERT(pModelObj); // view #1 int nView1 = SfxLokHelper::getView(); SfxViewShell* pView1 = SfxViewShell::Current(); // view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); SfxViewShell* pView2 = SfxViewShell::Current(); CPPUNIT_ASSERT(pView1 != pView2); // both views have UNDO disabled { SfxItemSet aSet1(pView1->GetPool(), svl::Items<SID_UNDO, SID_UNDO>); SfxItemSet aSet2(pView2->GetPool(), svl::Items<SID_UNDO, SID_UNDO>); pView1->GetSlotState(SID_UNDO, nullptr, &aSet1); pView2->GetSlotState(SID_UNDO, nullptr, &aSet2); CPPUNIT_ASSERT_EQUAL(SfxItemState::DISABLED, aSet1.GetItemState(SID_UNDO)); CPPUNIT_ASSERT_EQUAL(SfxItemState::DISABLED, aSet2.GetItemState(SID_UNDO)); } // text edit a cell in view #1 SfxLokHelper::setView(nView1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'h', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'h', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); // view1 has UNDO enabled, view2 is in UNDO-repair { SfxItemSet aSet1(pView1->GetPool(), svl::Items<SID_UNDO, SID_UNDO>); SfxItemSet aSet2(pView2->GetPool(), svl::Items<SID_UNDO, SID_UNDO>); pView1->GetSlotState(SID_UNDO, nullptr, &aSet1); pView2->GetSlotState(SID_UNDO, nullptr, &aSet2); CPPUNIT_ASSERT_EQUAL(SfxItemState::SET, aSet1.GetItemState(SID_UNDO)); CPPUNIT_ASSERT(dynamic_cast< const SfxStringItem* >(aSet1.GetItem(SID_UNDO))); CPPUNIT_ASSERT_EQUAL(SfxItemState::SET, aSet2.GetItemState(SID_UNDO)); CPPUNIT_ASSERT(dynamic_cast< const SfxUInt32Item* >(aSet2.GetItem(SID_UNDO))); const SfxUInt32Item* pUInt32Item = dynamic_cast<const SfxUInt32Item*>(aSet2.GetItem(SID CPPUNIT_ASSERT(pUInt32Item); CPPUNIT_ASSERT_EQUAL(static_cast< sal_uInt32 >(SID_REPAIRPACKAGE), pUInt32Item->GetVal } // text edit a cell in view #2 SfxLokHelper::setView(nView2); pModelObj->setPart(1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'c', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'c', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); // both views have UNDO enabled Scheduler::ProcessEventsToIdle(); { SfxItemSet aSet1(pView1->GetPool(), svl::Items<SID_UNDO, SID_UNDO>); SfxItemSet aSet2(pView2->GetPool(), svl::Items<SID_UNDO, SID_UNDO>); pView1->GetSlotState(SID_UNDO, nullptr, &aSet1); pView2->GetSlotState(SID_UNDO, nullptr, &aSet2); CPPUNIT_ASSERT_EQUAL(SfxItemState::SET, aSet1.GetItemState(SID_UNDO)); CPPUNIT_ASSERT(dynamic_cast< const SfxStringItem* >(aSet1.GetItem(SID_UNDO))); CPPUNIT_ASSERT_EQUAL(SfxItemState::SET, aSet2.GetItemState(SID_UNDO)); CPPUNIT_ASSERT(dynamic_cast< const SfxStringItem* >(aSet2.GetItem(SID_UNDO))); } SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testDocumentRepair) { // Create two views. ScModelObj* pModelObj = createDoc("cursor-away.ods"); CPPUNIT_ASSERT(pModelObj); // view #1 SfxViewShell* pView1 = SfxViewShell::Current(); // view #2 int nView1 = SfxLokHelper::getView(); SfxLokHelper::createView(); SfxViewShell* pView2 = SfxViewShell::Current(); int nView2 = SfxLokHelper::getView(); CPPUNIT_ASSERT(pView1 != pView2); { std::unique_ptr<SfxBoolItem> pItem1; std::unique_ptr<SfxBoolItem> pItem2; pView1->GetViewFrame().GetBindings().QueryState(SID_DOC_REPAIR, pItem1); pView2->GetViewFrame().GetBindings().QueryState(SID_DOC_REPAIR, pItem2); CPPUNIT_ASSERT(pItem1); CPPUNIT_ASSERT(pItem2); CPPUNIT_ASSERT_EQUAL(false, pItem1->GetValue()); CPPUNIT_ASSERT_EQUAL(false, pItem2->GetValue()); } // Insert a character in the second view. SfxLokHelper::setView(nView2); pModelObj->setPart(1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'c', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'c', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); { std::unique_ptr<SfxBoolItem> pItem1; std::unique_ptr<SfxBoolItem> pItem2; pView1->GetViewFrame().GetBindings().QueryState(SID_DOC_REPAIR, pItem1); pView2->GetViewFrame().GetBindings().QueryState(SID_DOC_REPAIR, pItem2); CPPUNIT_ASSERT(pItem1); CPPUNIT_ASSERT(pItem2); CPPUNIT_ASSERT_EQUAL(true, pItem1->GetValue()); CPPUNIT_ASSERT_EQUAL(true, pItem2->GetValue()); } SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testLanguageStatus) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); ScDocShell* pDocSh = dynamic_cast< ScDocShell* >( pModelObj->GetEmbeddedObject() ); CPPUNIT_ASSERT(pDocSh); // view #1 SfxViewShell* pView1 = SfxViewShell::Current(); // view #2 int nView1 = SfxLokHelper::getView(); SfxLokHelper::createView(); SfxViewShell* pView2 = SfxViewShell::Current(); CPPUNIT_ASSERT(pView1 != pView2); { std::unique_ptr<SfxPoolItem> xItem1; std::unique_ptr<SfxPoolItem> xItem2; pView1->GetViewFrame().GetBindings().QueryState(SID_LANGUAGE_STATUS, xItem1); pView2->GetViewFrame().GetBindings().QueryState(SID_LANGUAGE_STATUS, xItem2); const SfxStringItem* pItem1 = dynamic_cast<const SfxStringItem*>(xItem1.get()); const SfxStringItem* pItem2 = dynamic_cast<const SfxStringItem*>(xItem2.get()); CPPUNIT_ASSERT(pItem1); CPPUNIT_ASSERT(pItem2); CPPUNIT_ASSERT(!pItem1->GetValue().isEmpty()); CPPUNIT_ASSERT(!pItem2->GetValue().isEmpty()); } { SfxStringItem aLangString(SID_LANGUAGE_STATUS, u"Default_Spanish (Bolivia)"_ustr); pView1->GetViewFrame().GetDispatcher()->ExecuteList(SID_LANGUAGE_STATUS, SfxCallMode::SYNCHRON, { &aLangString }); } { std::unique_ptr<SfxPoolItem> xItem1; std::unique_ptr<SfxPoolItem> xItem2; pView1->GetViewFrame().GetBindings().QueryState(SID_LANGUAGE_STATUS, xItem1); pView2->GetViewFrame().GetBindings().QueryState(SID_LANGUAGE_STATUS, xItem2); const SfxStringItem* pItem1 = dynamic_cast<const SfxStringItem*>(xItem1.get()); const SfxStringItem* pItem2 = dynamic_cast<const SfxStringItem*>(xItem2.get()); CPPUNIT_ASSERT(pItem1); CPPUNIT_ASSERT(pItem2); static constexpr OUString aLangBolivia(u"Spanish (Bolivia);es-BO"_ustr); CPPUNIT_ASSERT_EQUAL(aLangBolivia, pItem1->GetValue()); CPPUNIT_ASSERT_EQUAL(aLangBolivia, pItem2->GetValue()); } SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testMultiViewCopyPaste) { ScModelObj* pModelObj = createDoc("empty.ods"); ScDocument* pDoc = pModelObj->GetDocument(); CPPUNIT_ASSERT(pDoc); pDoc->SetString(ScAddress(0, 0, 0), u"TestCopy1"_ustr); pDoc->SetString(ScAddress(1, 0, 0), u"TestCopy2"_ustr); // view #1 ScTabViewShell* pView1 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView1); // emulate clipboard pView1->GetViewData().GetActiveWin()->SetClipboard(css::datatransfer::clipboard::L // view #2 int nView1 = SfxLokHelper::getView(); SfxLokHelper::createView(); ScTabViewShell* pView2 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); // emulate clipboard pView2->GetViewData().GetActiveWin()->SetClipboard(css::datatransfer::clipboard::L CPPUNIT_ASSERT(pView2); CPPUNIT_ASSERT(pView1 != pView2); CPPUNIT_ASSERT(pView1->GetViewData().GetActiveWin()->GetClipboard() != pView2->GetVie // copy text view 1 pView1->SetCursor(0, 0); pView1->GetViewFrame().GetBindings().Execute(SID_COPY); // copy text view 2 pView2->SetCursor(1, 0); pView2->GetViewFrame().GetBindings().Execute(SID_COPY); // paste text view 1 pView1->SetCursor(0, 1); pView1->GetViewFrame().GetBindings().Execute(SID_PASTE); // paste text view 2 pView2->SetCursor(1, 1); pView2->GetViewFrame().GetBindings().Execute(SID_PASTE); CPPUNIT_ASSERT_EQUAL(u"TestCopy1"_ustr, pDoc->GetString(ScAddress(0, 1, 0))); CPPUNIT_ASSERT_EQUAL(u"TestCopy2"_ustr, pDoc->GetString(ScAddress(1, 1, 0))); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testIMESupport) { ScModelObj* pModelObj = createDoc("empty.ods"); VclPtr<vcl::Window> pDocWindow = pModelObj->getDocWindow(); ScDocument* pDoc = pModelObj->GetDocument(); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); pView->SetCursor(0, 0); // sequence of chinese IME compositions when 'nihao' is typed in an IME const std::vector<OString> aUtf8Inputs{ "年"_ostr, "你"_ostr, "你好"_ostr, "你哈"_ostr, "你好"_ostr, "你好"_os std::vector<OUString> aInputs; std::transform(aUtf8Inputs.begin(), aUtf8Inputs.end(), std::back_inserter(aInputs), [](OString aInput) { return OUString::fromUtf8(aInput); }); for (const auto& aInput: aInputs) { pDocWindow->PostExtTextInputEvent(VclEventId::ExtTextInput, aInput); } pDocWindow->PostExtTextInputEvent(VclEventId::EndExtTextInput, u""_ustr); // commit the string to the cell pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(aInputs[aInputs.size() - 1], pDoc->GetString(ScAddress(0, 0, 0))) } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testFilterDlg) { createDoc("empty.ods"); // view #1 SfxViewShell* pView1 = SfxViewShell::Current(); int nView1 = SfxLokHelper::getView(); // view #2 SfxLokHelper::createView(); SfxViewShell* pView2 = SfxViewShell::Current(); CPPUNIT_ASSERT(pView1 != pView2); { pView2->GetViewFrame().GetDispatcher()->Execute(SID_FILTER, SfxCallMode::SLOT|SfxCallMode::RECORD); } Scheduler::ProcessEventsToIdle(); SfxChildWindow* pRefWindow = pView2->GetViewFrame().GetChildWindow(SID_FILTER); CPPUNIT_ASSERT(pRefWindow); // switch to view 1 SfxLokHelper::setView(nView1); CPPUNIT_ASSERT_EQUAL(true, pView2->GetViewFrame().GetDispatcher()->IsLocked()); CPPUNIT_ASSERT_EQUAL(false, pView1->GetViewFrame().GetDispatcher()->IsLocked()); pRefWindow->GetController()->response(RET_CANCEL); CPPUNIT_ASSERT_EQUAL(false, pView2->GetViewFrame().GetDispatcher()->IsLocked()); CPPUNIT_ASSERT_EQUAL(false, pView1->GetViewFrame().GetDispatcher()->IsLocked()); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testFunctionDlg) { createDoc("empty.ods"); // view #1 SfxViewShell* pView1 = SfxViewShell::Current(); int nView1 = SfxLokHelper::getView(); { pView1->GetViewFrame().GetDispatcher()->Execute(SID_OPENDLG_FUNCTION, SfxCallMode::SLOT|SfxCallMode::RECORD); } Scheduler::ProcessEventsToIdle(); SfxChildWindow* pRefWindow = pView1->GetViewFrame().GetChildWindow(SID_OPENDLG_FUNCT CPPUNIT_ASSERT(pRefWindow); // view #2 int nView2 = SfxLokHelper::createView(); SfxViewShell* pView2 = SfxViewShell::Current(); CPPUNIT_ASSERT(pView1 != pView2); // check locking CPPUNIT_ASSERT_EQUAL(true, pView1->GetViewFrame().GetDispatcher()->IsLocked()); CPPUNIT_ASSERT_EQUAL(false, pView2->GetViewFrame().GetDispatcher()->IsLocked()); SfxLokHelper::setView(nView1); pRefWindow->GetController()->response(RET_CANCEL); CPPUNIT_ASSERT_EQUAL(false, pView1->GetViewFrame().GetDispatcher()->IsLocked()); CPPUNIT_ASSERT_EQUAL(false, pView2->GetViewFrame().GetDispatcher()->IsLocked()); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView2); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testSpellOnlineParameter) { createDoc("empty.ods"); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); bool bSet = pView->IsAutoSpell(); uno::Sequence<beans::PropertyValue> params = { comphelper::makePropertyValue(u"Enable"_ustr, uno::Any(!bSet)), }; dispatchCommand(mxComponent, u".uno:SpellOnline"_ustr, params); CPPUNIT_ASSERT_EQUAL(!bSet, pView->IsAutoSpell()); // set the same state as now and we don't expect any change (no-toggle) params = { comphelper::makePropertyValue(u"Enable"_ustr, uno::Any(!bSet)), }; dispatchCommand(mxComponent, u".uno:SpellOnline"_ustr, params); CPPUNIT_ASSERT_EQUAL(!bSet, pView->IsAutoSpell()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testVbaRangeCopyPaste) { ScModelObj* pModelObj = createDoc("RangeCopyPaste.ods"); ScDocShell* pDocShell = dynamic_cast< ScDocShell* >( pModelObj->GetEmbeddedObject() ); CPPUNIT_ASSERT(pDocShell); uno::Any aRet; uno::Sequence< uno::Any > aOutParam; uno::Sequence< uno::Any > aParams; uno::Sequence< sal_Int16 > aOutParamIndex; SfxObjectShell::CallXScript( mxComponent, u"vnd.sun.Star.script:Standard.Module1.Test_RangeCopyPaste?language=Basic&location=document"_ aParams, aRet, aOutParamIndex, aOutParam); CPPUNIT_ASSERT(!pDocShell->GetClipData().is()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testInvalidationLoop) { // Load the document with a form control. createDoc("invalidation-loop.fods"); // Without the accompanying fix in place, this test would have never returned due to an infinite // invalidation loop between ScGridWindow::Paint() and vcl::Window::ImplPosSizeWindow( Scheduler::ProcessEventsToIdle(); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testPageDownInvalidation) { ScModelObj* pModelObj = createDoc("empty.ods"); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); SfxLokHelper::setView(nView1); aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, awt::Key::PAGEDOWN, 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, awt::Key::PAGEDOWN, 0); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(3), aView1.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(15, 15, 1230, 225), aView1.m_aInvalidations[0] } static Bitmap getTile(ScModelObj* pModelObj, int nTilePosX, int nTilePosY, tools::Long nT { size_t nCanvasSize = 1024; size_t nTileSize = 256; std::vector<unsigned char> aPixmap(nCanvasSize * nCanvasSize * 4, 0); ScopedVclPtrInstance<VirtualDevice> xDevice(DeviceFormat::WITHOUT_ALPHA); xDevice->SetBackground(Wallpaper(COL_TRANSPARENT)); xDevice->SetOutputSizePixelScaleOffsetAndLOKBuffer(Size(nCanvasSize, nCanvasSize), Fraction(1.0), Point(), aPixmap.data()); pModelObj->paintTile(*xDevice, nCanvasSize, nCanvasSize, nTilePosX, nTilePosY, nTileWi xDevice->EnableMapMode(false); return xDevice->GetBitmap(Point(0, 0), Size(nTileSize, nTileSize)); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testSheetChangeNoInvalidation) { const bool oldPartInInvalidation = comphelper::LibreOfficeKit::isPartInInvalidation( comphelper::LibreOfficeKit::setPartInInvalidation(true); ScModelObj* pModelObj = createDoc("two_sheets.ods"); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); // Set View to initial 100% pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 28050, 10605)); pModelObj->setClientZoom(256, 256, 1920, 1920); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); SfxLokHelper::setView(nView1); aView1.ClearAllInvalids(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEDOWN | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEDOWN | KEY_MOD1); Scheduler::ProcessEventsToIdle(); // switching sheets should trigger no unnecessary invalidations CPPUNIT_ASSERT(!aView1.m_bInvalidateTiles); // Get the known columns/rows of this sheet 2 now we have switched to it so // it knows what range to broadcast invalidations for if it knows cells need // to be redrawn. tools::JsonWriter aJsonWriter1; pModelObj->getRowColumnHeaders(tools::Rectangle(0, 15, 19650, 5400), aJsonWriter1); aJsonWriter1.finishAndGetAsOString(); Scheduler::ProcessEventsToIdle(); aView1.ClearAllInvalids(); // switching back should also trigger no unnecessary invalidations pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEUP | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEUP | KEY_MOD1); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView1.m_bInvalidateTiles); // The 2nd sheet has formulas that depend on B1 in the first sheet. So if // we change B1 there should be an invalidation in the second sheet for the // range that depends on it. Because this is a single user document with no // active view on the 2nd sheet this will happen on switching back to sheet 2 typeCharsInCell("101", 1, 0, pView, pModelObj); // Type '101' in B1 aView1.ClearAllInvalids(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEDOWN | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEDOWN | KEY_MOD1); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); aView1.ClearAllInvalids(); // Paint it to make it valid again getTile(pModelObj, 0, 0, 3840, 3840); // switching back to sheet 1 should trigger no unnecessary invalidations pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEUP | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEUP | KEY_MOD1); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView1.m_bInvalidateTiles); // switching to sheet 2 should trigger no unnecessary invalidations this time pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEDOWN | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEDOWN | KEY_MOD1); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView1.m_bInvalidateTiles); comphelper::LibreOfficeKit::setPartInInvalidation(oldPartInInvalidation); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testInsertDeletePageInvalidation) { ScModelObj* pModelObj = createDoc("insert_delete_sheet.ods"); // the document has 1 sheet CPPUNIT_ASSERT_EQUAL(1, pModelObj->getParts()); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); SfxLokHelper::setView(nView1); aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "Name", uno::Any(u""_ustr) }, { "Index", uno::Any(sal_Int32(1)) } })); dispatchCommand(mxComponent, u".uno:Insert"_ustr, aArgs); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(2), aView1.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(0, 0, 1000000000, 1000000000), aView1.m_aInval CPPUNIT_ASSERT_EQUAL(2, pModelObj->getParts()); // Delete sheet aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); uno::Sequence<beans::PropertyValue> aArgs2( comphelper::InitPropertySequence({ { "Index", uno::Any(sal_Int32(1)) } })); dispatchCommand(mxComponent, u".uno:Remove"_ustr, aArgs2); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(1), aView1.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(0, 0, 1000000000, 1000000000), aView1.m_aInval CPPUNIT_ASSERT_EQUAL(1, pModelObj->getParts()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testGetRowColumnHeadersInvalidation) { // NOTE NOTE NOTE // If you run this test in isolation using CPPUNIT_TEST_NAME=, it will fail because the invalid // will be different. ScModelObj* pModelObj = createDoc("empty.ods"); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); SfxLokHelper::setView(nView1); aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); tools::JsonWriter aJsonWriter1; pModelObj->getRowColumnHeaders(tools::Rectangle(0, 15, 19650, 5400), aJsonWriter1); aJsonWriter1.finishAndGetAsOString(); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(1), aView1.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(Point(26775, 0), Size(22950, 13005)), aView1.m // Extend area top-to-bottom aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); tools::JsonWriter aJsonWriter2; pModelObj->getRowColumnHeaders(tools::Rectangle(0, 5400, 19650, 9800), aJsonWriter2); aJsonWriter2.finishAndGetAsOString(); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(1), aView1.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(Point(0, 13005), Size(49725, 6375)), aView1.m_ // Extend area left-to-right aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); tools::JsonWriter aJsonWriter3; pModelObj->getRowColumnHeaders(tools::Rectangle(5400, 5400, 25050, 9800), aJsonWriter aJsonWriter3.finishAndGetAsOString(); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(1), aView1.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(Point(49725, 0), Size(25500, 19380)), aView1.m } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testJumpHorizontallyInvalidation) { ScModelObj* pModelObj = createDoc("empty.ods"); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); SfxLokHelper::setView(nView1); aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEDOWN | KEY_MOD2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEDOWN | KEY_MOD2); Scheduler::ProcessEventsToIdle(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEDOWN | KEY_MOD2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEDOWN | KEY_MOD2); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(1), aView1.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(tools::Rectangle(26775, 0, 39525, 13005), aView1.m_aInvalidatio } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testJumpToLastRowInvalidation) { ScModelObj* pModelObj = createDoc("empty.ods"); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); SfxLokHelper::setView(nView1); aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DOWN | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DOWN | KEY_MOD1); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT_EQUAL(size_t(1), aView1.m_aInvalidations.size()); // 261375 because we limit how far we jump into empty space in online, 267386880 if we don't limit CPPUNIT_ASSERT_EQUAL(tools::Rectangle(0, 13005, 26775, 261375), aView1.m_aInvalidati } // We need to ensure that views are not perterbed by rendering (!?) hmm ... CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testRowColumnHeaders) { ScModelObj* pModelObj = createDoc("empty.ods"); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); // view #1 ScTestViewCallback aView1; int nView1 = SfxLokHelper::getView(); CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); // view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); ScTestViewCallback aView2; pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); // ViewRowColumnHeaders test SfxLokHelper::setView(nView1); tools::JsonWriter aJsonWriter1; pModelObj->getRowColumnHeaders(tools::Rectangle(65,723,10410,4695), aJsonWriter1); OString aHeaders1 = aJsonWriter1.finishAndGetAsOString(); SfxLokHelper::setView(nView2); // 50% zoom pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 22474, 47333)); pModelObj->setClientZoom(256, 256, 6636, 6636); tools::JsonWriter aJsonWriter2; pModelObj->getRowColumnHeaders(tools::Rectangle(65,723,10410,4695), aJsonWriter2); OString aHeaders2 = aJsonWriter2.finishAndGetAsOString(); // Check vs. view #1 SfxLokHelper::setView(nView1); tools::JsonWriter aJsonWriter3; pModelObj->getRowColumnHeaders(tools::Rectangle(65,723,10410,4695), aJsonWriter3); OString aHeaders1_2 = aJsonWriter3.finishAndGetAsOString(); CPPUNIT_ASSERT_EQUAL(aHeaders1, aHeaders1_2); // Check vs. view #2 SfxLokHelper::setView(nView2); tools::JsonWriter aJsonWriter4; pModelObj->getRowColumnHeaders(tools::Rectangle(65,723,10410,4695), aJsonWriter4); OString aHeaders2_2 = aJsonWriter4.finishAndGetAsOString(); CPPUNIT_ASSERT_EQUAL(aHeaders2, aHeaders2_2); SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView2); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } namespace { // Helper structs for setup and testing of ScModelObj::getSheetGeometryData() struct SpanEntry { size_t nVal; SCCOLROW nEnd; }; struct SheetDimData { typedef std::vector<SpanEntry> SpanList; SpanList aSizes; SpanList aHidden; SpanList aFiltered; // TODO: Add group info too to test. void setDataToDoc(ScDocument* pDoc, bool bCol) const { SCCOLROW nStart = 0; // sizes for (const auto& rSpan : aSizes) { if (bCol) { for (SCCOLROW nIdx = nStart; nIdx <= rSpan.nEnd; ++nIdx) pDoc->SetColWidthOnly(nIdx, 0, rSpan.nVal); } else pDoc->SetRowHeightOnly(nStart, rSpan.nEnd, 0, rSpan.nVal); nStart = rSpan.nEnd + 1; } nStart = 0; // hidden for (const auto& rSpan : aHidden) { if (bCol) pDoc->SetColHidden(nStart, rSpan.nEnd, 0, !!rSpan.nVal); else pDoc->SetRowHidden(nStart, rSpan.nEnd, 0, !!rSpan.nVal); nStart = rSpan.nEnd + 1; } // There is no ScDocument interface to set ScTable::mpFilteredCols // It seems ScTable::mpFilteredCols is not really used !? if (bCol) return; nStart = 0; // filtered for (const auto& rSpan : aFiltered) { pDoc->SetRowFiltered(nStart, rSpan.nEnd, 0, !!rSpan.nVal); nStart = rSpan.nEnd + 1; } } void testPropertyTree(const boost::property_tree::ptree& rTree, bool bCol) const { struct SpanListWithKey { OString aKey; const SpanList& rSpanList; }; const SpanListWithKey aPairList[] = { { "sizes"_ostr, aSizes }, { "hidden"_ostr, aHidden }, { "filtered"_ostr, aFiltered } }; for (const auto& rEntry : aPairList) { // There is no ScDocument interface to set ScTable::mpFilteredCols // It seems ScTable::mpFilteredCols is not really used !? if (bCol && rEntry.aKey == "filtered") continue; bool bBooleanValue = rEntry.aKey != "sizes"; OString aExpectedEncoding; bool bFirst = true; for (const auto& rSpan : rEntry.rSpanList) { size_t nVal = rSpan.nVal; if (bBooleanValue && bFirst) nVal = static_cast<size_t>(!!nVal); if (!bBooleanValue || bFirst) aExpectedEncoding += OString::number(nVal) + ":"; aExpectedEncoding += OString::number(rSpan.nEnd) + " "; bFirst = false; } // Get the tree's value for the property key ("sizes"/"hidden"/"filtered"). OString aTreeValue(rTree.get<std::string>(rEntry.aKey.getStr())); CPPUNIT_ASSERT_EQUAL(aExpectedEncoding, aTreeValue); } } }; class SheetGeometryData { SheetDimData aCols; SheetDimData aRows; public: SheetGeometryData(const SheetDimData& rCols, const SheetDimData& rRows) : aCols(rCols), aRows(rRows) {} void setDataToDoc(ScDocument* pDoc) const { aCols.setDataToDoc(pDoc, true); aRows.setDataToDoc(pDoc, false); } void parseTest(const OString& rJSON) const { // Assumes all flags passed to getSheetGeometryData() are true. boost::property_tree::ptree aTree; std::stringstream aStream((std::string(rJSON))); boost::property_tree::read_json(aStream, aTree); CPPUNIT_ASSERT_EQUAL(".uno:SheetGeometryData"_ostr, OString(aTree.get<std::string>( aCols.testPropertyTree(aTree.get_child("columns"), true); aRows.testPropertyTree(aTree.get_child("rows"), false); } }; } //namespace // getSheetGeometryData() should return the exact same message // irrespective of client zoom and view-area. Switching views // should also not alter it. CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testSheetGeometryDataInvariance) { ScModelObj* pModelObj = createDoc("empty.ods"); ScDocument* pDoc = pModelObj->GetDocument(); const SheetGeometryData aSGData( // cols { // width spans { { STD_COL_WIDTH, 20 }, { 2*STD_COL_WIDTH, 26 }, { STD_COL_WIDTH, pDoc->MaxCol() } }, // hidden spans { { 0, 5 }, { 1, 12 }, { 0, pDoc->MaxCol() } }, // filtered spans { { 0, 50 }, { 1, 59 }, { 0, pDoc->MaxCol() } } }, // rows { // height spans { { 300, 50 }, { 600, 65 }, { 300, pDoc->MaxRow() } }, // hidden spans { { 1, 100 }, { 0, 500 }, { 1, 578 }, { 0, pDoc->MaxRow() } }, // filtered spans { { 0, 150 }, { 1, 159 }, { 0, pDoc->MaxRow() } } } ); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); // view #1 ScTestViewCallback aView1; int nView1 = SfxLokHelper::getView(); // view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); ScTestViewCallback aView2; pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); // Try with the default empty document once (nIdx = 0) and then with sheet geometry settings (nId for (size_t nIdx = 0; nIdx < 2; ++nIdx) { if (nIdx) aSGData.setDataToDoc(pDoc); SfxLokHelper::setView(nView1); OString aGeomStr1 = pModelObj->getSheetGeometryData(/*bColumns*/ true, /*bRows*/ true, / /*bHidden*/ true, /*bFiltered*/ true, /*bGroups*/ true); SfxLokHelper::setView(nView2); pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 22474, 47333)); pModelObj->setClientZoom(256, 256, 6636, 6636); OString aGeomStr2 = pModelObj->getSheetGeometryData(/*bColumns*/ true, /*bRows*/ true, / /*bHidden*/ true, /*bFiltered*/ true, /*bGroups*/ true); // Check vs. view #1 SfxLokHelper::setView(nView1); OString aGeomStr1_2 = pModelObj->getSheetGeometryData(/*bColumns*/ true, /*bRows*/ true /*bHidden*/ true, /*bFiltered*/ true, /*bGroups*/ true); CPPUNIT_ASSERT_EQUAL(aGeomStr1, aGeomStr1_2); // Check vs. view #2 SfxLokHelper::setView(nView2); OString aGeomStr2_2 = pModelObj->getSheetGeometryData(/*bColumns*/ true, /*bRows*/ true /*bHidden*/ true, /*bFiltered*/ true, /*bGroups*/ true); CPPUNIT_ASSERT_EQUAL(aGeomStr2, aGeomStr2_2); } SfxLokHelper::setView(nView1); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); SfxLokHelper::setView(nView2); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testSheetGeometryDataCorrectness) { ScModelObj* pModelObj = createDoc("empty.ods"); ScDocument* pDoc = pModelObj->GetDocument(); const SheetGeometryData aDefaultSGData( // cols { // width spans { { STD_COL_WIDTH, pDoc->MaxCol() } }, // hidden spans { { 0, pDoc->MaxCol() } }, // filtered spans { { 0, pDoc->MaxCol() } } }, // rows { // height spans { { ScGlobal::nStdRowHeight, pDoc->MaxRow() } }, // hidden spans { { 0, pDoc->MaxRow() } }, // filtered spans { { 0, pDoc->MaxRow() } } } ); const SheetGeometryData aSGData( // cols { // width spans { { STD_COL_WIDTH, 20 }, { 2*STD_COL_WIDTH, 26 }, { STD_COL_WIDTH, pDoc->MaxCol() } }, // hidden spans { { 0, 5 }, { 1, 12 }, { 0, pDoc->MaxCol() } }, // filtered spans { { 0, 50 }, { 1, 59 }, { 0, pDoc->MaxCol() } } }, // rows { // height spans { { 300, 50 }, { 600, 65 }, { 300, pDoc->MaxRow() } }, // hidden spans { { 1, 100 }, { 0, 500 }, { 1, 578 }, { 0, pDoc->MaxRow() } }, // filtered spans { { 0, 150 }, { 1, 159 }, { 0, pDoc->MaxRow() } } } ); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); // view #1 ScTestViewCallback aView1; // with the default empty sheet and test the JSON encoding. OString aGeomDefaultStr = pModelObj->getSheetGeometryData(/*bColumns*/ true, /*bRows*/ /*bHidden*/ true, /*bFiltered*/ true, /*bGroups*/ true); aDefaultSGData.parseTest(aGeomDefaultStr); // Apply geometry settings to the sheet and then test the resulting JSON encoding. aSGData.setDataToDoc(pDoc); OString aGeomStr = pModelObj->getSheetGeometryData(/*bColumns*/ true, /*bRows*/ true, /* /*bHidden*/ true, /*bFiltered*/ true, /*bGroups*/ true); aSGData.parseTest(aGeomStr); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testDeleteCellMultilineContent) { ScModelObj* pModelObj = createDoc("multiline.ods"); CPPUNIT_ASSERT(pModelObj); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); ScDocShell* pDocSh = dynamic_cast< ScDocShell* >( pModelObj->GetEmbeddedObject() ); CPPUNIT_ASSERT(pDocSh); // view #1 ScTestViewCallback aView1; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); aView1.m_sInvalidateHeader = ""_ostr; ScDocument& rDoc = pDocSh->GetDocument(); sal_uInt16 nRow1Height = rDoc.GetRowHeight(static_cast<SCROW>(0), static_cast<SCTAB>(0), // delete multiline cell content in view #1 pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DELETE); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DELETE); Scheduler::ProcessEventsToIdle(); // check if the row header has been invalidated and if the involved row is of the expected height CPPUNIT_ASSERT_EQUAL("row"_ostr, aView1.m_sInvalidateHeader); sal_uInt16 nRow2Height = rDoc.GetRowHeight(static_cast<SCROW>(0), static_cast<SCTAB>(0), CPPUNIT_ASSERT_EQUAL(nRow1Height, nRow2Height); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testPasteIntoWrapTextCell) { comphelper::LibreOfficeKit::setCompatFlag( comphelper::LibreOfficeKit::Compat::scPrintTwipsMsgs); ScModelObj* pModelObj = createDoc("empty.ods"); CPPUNIT_ASSERT(pModelObj); ScDocument* pDoc = pModelObj->GetDocument(); // Set Wrap text in A3 pDoc->ApplyAttr(0, 2, 0, ScLineBreakCell(true)); const ScLineBreakCell* pItem = pDoc->GetAttr(0, 2, 0, ATTR_LINEBREAK); CPPUNIT_ASSERT(pItem->GetValue()); ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); ScTestViewCallback aView; CPPUNIT_ASSERT(!lcl_hasEditView(*pViewData)); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); // create source text in A1 OUString sCopyContent(u"Very long text to copy"_ustr); pDoc->SetString(0, 0, 0, sCopyContent); // copy A1 pView->SetCursor(0, 0); Scheduler::ProcessEventsToIdle(); pView->GetViewFrame().GetBindings().Execute(SID_COPY); Scheduler::ProcessEventsToIdle(); // verify clipboard uno::Reference<datatransfer::clipboard::XClipboard> xClipboard1 = pView->GetViewData() uno::Reference< datatransfer::XTransferable > xDataObj = xClipboard1->getContents(); datatransfer::DataFlavor aFlavor; SotExchange::GetFormatDataFlavor(SotClipboardFormatId::STRING, aFlavor); uno::Any aData = xDataObj->getTransferData(aFlavor); OUString aTmpText; aData >>= aTmpText; CPPUNIT_ASSERT_EQUAL(sCopyContent, aTmpText.trim()); // Go to A2 and paste. pView->SetCursor(0, 1); Scheduler::ProcessEventsToIdle(); aView.m_sInvalidateSheetGeometry = ""_ostr; pView->GetViewFrame().GetBindings().Execute(SID_PASTE); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(sCopyContent, pDoc->GetString(0, 1, 0)); CPPUNIT_ASSERT_EQUAL("rows sizes"_ostr, aView.m_sInvalidateSheetGeometry); // create new source text in A2 OUString sCopyContent2(u"Very long text to copy 2"_ustr); pDoc->SetString(0, 1, 0, sCopyContent2); Scheduler::ProcessEventsToIdle(); // cut from A2 pView->GetViewFrame().GetBindings().Execute(SID_CUT); Scheduler::ProcessEventsToIdle(); // verify clipboard uno::Reference<datatransfer::clipboard::XClipboard> xClipboard2 = pView->GetViewData().GetActiveWin()->GetClipboard(); xDataObj = xClipboard2->getContents(); SotExchange::GetFormatDataFlavor(SotClipboardFormatId::STRING, aFlavor); aData = xDataObj->getTransferData(aFlavor); aData >>= aTmpText; CPPUNIT_ASSERT_EQUAL(xClipboard1, xClipboard2); CPPUNIT_ASSERT_EQUAL(sCopyContent2, aTmpText.trim()); // Go to A3 and paste. pView->SetCursor(0, 2); Scheduler::ProcessEventsToIdle(); aView.m_sInvalidateSheetGeometry = ""_ostr; pView->GetViewFrame().GetBindings().Execute(SID_PASTE); Scheduler::ProcessEventsToIdle(); // SG invalidations for all CPPUNIT_ASSERT_EQUAL(sCopyContent2, pDoc->GetString(0, 1, 0)); CPPUNIT_ASSERT_EQUAL("all"_ostr, aView.m_sInvalidateSheetGeometry); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testSortAscendingDescending) { comphelper::LibreOfficeKit::setCompatFlag( comphelper::LibreOfficeKit::Compat::scPrintTwipsMsgs); ScModelObj* pModelObj = createDoc("sort-range.ods"); ScDocument* pDoc = pModelObj->GetDocument(); ScTestViewCallback aView; // select the values in the first column pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, 551, 129, 1, MOUSE_LEFT, 0); pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEMOVE, 820, 1336, 1, MOUSE_LEFT, 0); pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, 820, 1359, 1, MOUSE_LEFT, 0); Scheduler::ProcessEventsToIdle(); aView.m_sInvalidateSheetGeometry = ""_ostr; // sort ascending uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:SortAscending"_ustr, aArgs); // check it's sorted for (SCROW r = 0; r < 6; ++r) { CPPUNIT_ASSERT_EQUAL(double(r + 1), pDoc->GetValue(ScAddress(0, r, 0))); } Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL("rows"_ostr, aView.m_sInvalidateSheetGeometry); aView.m_sInvalidateSheetGeometry = ""_ostr; // sort descending dispatchCommand(mxComponent, u".uno:SortDescending"_ustr, aArgs); // check it's sorted for (SCROW r = 0; r < 6; ++r) { CPPUNIT_ASSERT_EQUAL(double(6 - r), pDoc->GetValue(ScAddress(0, r, 0))); } // nothing else was sorted CPPUNIT_ASSERT_EQUAL(double(1), pDoc->GetValue(ScAddress(1, 0, 0))); CPPUNIT_ASSERT_EQUAL(double(3), pDoc->GetValue(ScAddress(1, 1, 0))); CPPUNIT_ASSERT_EQUAL(double(2), pDoc->GetValue(ScAddress(1, 2, 0))); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL("rows"_ostr, aView.m_sInvalidateSheetGeometry); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testAutoInputStringBlock) { ScModelObj* pModelObj = createDoc("empty.ods"); CPPUNIT_ASSERT(pModelObj); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); ScDocument* pDoc = pModelObj->GetDocument(); pDoc->SetString(ScAddress(0, 3, 0), u"ABC"_ustr); // A4 pDoc->SetString(ScAddress(0, 4, 0), u"BAC"_ustr); // A5 ScFieldEditEngine& rEE = pDoc->GetEditEngine(); rEE.SetText(u"XYZ"_ustr); pDoc->SetEditText(ScAddress(0, 5, 0), rEE.CreateTextObject()); // A6 pDoc->SetValue(ScAddress(0, 6, 0), 123); pDoc->SetString(ScAddress(0, 7, 0), u"ZZZ"_ustr); // A8 ScAddress aA1(0, 0, 0); typeCharsInCell("X", aA1.Col(), aA1.Row(), pView, pModelObj); // Type 'X' in A1 CPPUNIT_ASSERT_EQUAL_MESSAGE("A1 should autocomplete", u"XYZ"_ustr, pDoc->GetString(a ScAddress aA3(0, 2, 0); // Adjacent to the string "superblock" A4:A8 typeCharsInCell("X", aA3.Col(), aA3.Row(), pView, pModelObj); // Type 'X' in A3 CPPUNIT_ASSERT_EQUAL_MESSAGE("A3 should autocomplete", u"XYZ"_ustr, pDoc->GetString(a ScAddress aA9(0, 8, 0); // Adjacent to the string "superblock" A4:A8 typeCharsInCell("X", aA9.Col(), aA9.Row(), pView, pModelObj); // Type 'X' in A9 CPPUNIT_ASSERT_EQUAL_MESSAGE("A9 should autocomplete", u"XYZ"_ustr, pDoc->GetString(a ScAddress aA11(0, 10, 0); typeCharsInCell("X", aA11.Col(), aA11.Row(), pView, pModelObj); // Type 'X' in A11 CPPUNIT_ASSERT_EQUAL_MESSAGE("A11 should autocomplete", u"XYZ"_ustr, pDoc->GetString( } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testAutoInputExactMatch) { ScModelObj* pModelObj = createDoc("empty.ods"); CPPUNIT_ASSERT(pModelObj); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); ScDocument* pDoc = pModelObj->GetDocument(); pDoc->SetString(ScAddress(0, 1, 0), u"Simple"_ustr); // A2 pDoc->SetString(ScAddress(0, 2, 0), u"Simple"_ustr); // A3 pDoc->SetString(ScAddress(0, 3, 0), u"Sing"_ustr); // A4 ScFieldEditEngine& rEE = pDoc->GetEditEngine(); rEE.SetText(u"Case"_ustr); pDoc->SetEditText(ScAddress(0, 4, 0), rEE.CreateTextObject()); // A5 pDoc->SetString(ScAddress(0, 5, 0), u"Time"_ustr); // A6 pDoc->SetString(ScAddress(0, 6, 0), u"Castle"_ustr); // A7 ScAddress aA8(0, 7, 0); typeCharsInCell("S", aA8.Col(), aA8.Row(), pView, pModelObj); // Type "S" in A8 // Should show the partial completion "i". CPPUNIT_ASSERT_EQUAL_MESSAGE("1: A8 should have partial completion Si", u"Si"_ustr, pDoc typeCharsInCell("Si", aA8.Col(), aA8.Row(), pView, pModelObj); // Type "Si" in A8 // Should not show any suggestions. CPPUNIT_ASSERT_EQUAL_MESSAGE("2: A8 should not show suggestions", u"Si"_ustr, pDoc->GetS typeCharsInCell("Sim", aA8.Col(), aA8.Row(), pView, pModelObj); // Type "Sim" in A8 // Should autocomplete to "Simple" which is the only match. CPPUNIT_ASSERT_EQUAL_MESSAGE("3: A8 should autocomplete", u"Simple"_ustr, pDoc->GetStr typeCharsInCell("Sin", aA8.Col(), aA8.Row(), pView, pModelObj); // Type "Sin" in A8 // Should autocomplete to "Sing" which is the only match. CPPUNIT_ASSERT_EQUAL_MESSAGE("4: A8 should autocomplete", u"Sing"_ustr, pDoc->GetStrin typeCharsInCell("C", aA8.Col(), aA8.Row(), pView, pModelObj); // Type "C" in A8 // Should show the partial completion "as". CPPUNIT_ASSERT_EQUAL_MESSAGE("5: A8 should have partial completion Cas", u"Cas"_ustr, pD typeCharsInCell("Cast", aA8.Col(), aA8.Row(), pView, pModelObj); // Type "Cast" in A8 // Should autocomplete to "Castle" which is the only match. CPPUNIT_ASSERT_EQUAL_MESSAGE("6: A8 should autocomplete", u"Castle"_ustr, pDoc->GetStr typeCharsInCell("T", aA8.Col(), aA8.Row(), pView, pModelObj); // Type "T" in A8 // Should autocomplete to "Time" which is the only match. CPPUNIT_ASSERT_EQUAL_MESSAGE("7: A8 should autocomplete", u"Time"_ustr, pDoc->GetStrin } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testEditCursorBounds) { comphelper::LibreOfficeKit::setCompatFlag( comphelper::LibreOfficeKit::Compat::scPrintTwipsMsgs); ScModelObj* pModelObj = createDoc("empty.ods"); ScDocument* pDoc = pModelObj->GetDocument(); ScTestViewCallback aView; ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); comphelper::LibreOfficeKit::setViewIdForVisCursorInvalidation(true); // ~170% zoom. pModelObj->setClientZoom(256, 256, 2222, 2222); pModelObj->setClientVisibleArea(tools::Rectangle(7725, 379832, 16240, 6449)); Scheduler::ProcessEventsToIdle(); constexpr SCCOL nCol = 5; constexpr SCROW nRow = 2048; pDoc->SetValue(ScAddress(nCol, nRow, 0), 123); aView.m_bOwnCursorInvalidated = false; // Obtain the cell bounds via cursor. pView->SetCursor(nCol, nRow); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView.m_bOwnCursorInvalidated); CPPUNIT_ASSERT(!aView.m_aCellCursorBounds.IsEmpty()); tools::Rectangle aCellBounds(aView.m_aCellCursorBounds); aView.m_aInvalidateCursorResult.clear(); // Enter edit mode in the same cell. pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::F2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::F2); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView.m_aInvalidateCursorResult.empty()); CPPUNIT_ASSERT_MESSAGE("Edit cursor must be in cell bounds!", aCellBounds.Contains(aView.m_aInvalidateCursorResult.getBounds())); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testTextSelectionBounds) { comphelper::LibreOfficeKit::setCompatFlag( comphelper::LibreOfficeKit::Compat::scPrintTwipsMsgs); ScModelObj* pModelObj = createDoc("empty.ods"); ScDocument* pDoc = pModelObj->GetDocument(); ScTestViewCallback aView; ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); comphelper::LibreOfficeKit::setViewIdForVisCursorInvalidation(true); // ~170% zoom. pModelObj->setClientZoom(256, 256, 2222, 2222); pModelObj->setClientVisibleArea(tools::Rectangle(7725, 379832, 16240, 6449)); Scheduler::ProcessEventsToIdle(); constexpr SCCOL nCol = 5; constexpr SCROW nRow = 2048; pDoc->SetValue(ScAddress(nCol, nRow, 0), 123); aView.m_bOwnCursorInvalidated = false; // Obtain the cell bounds via cursor. pView->SetCursor(nCol, nRow); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView.m_bOwnCursorInvalidated); CPPUNIT_ASSERT(!aView.m_aCellCursorBounds.IsEmpty()); tools::Rectangle aCellBounds(aView.m_aCellCursorBounds); aView.m_aTextSelectionResult.clear(); // Enter edit mode in the same cell and select all text. pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::F2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::F2); Scheduler::ProcessEventsToIdle(); // CTRL + A pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_MOD1 | awt::Key::A); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_MOD1 | awt::Key::A); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView.m_aTextSelectionResult.empty()); CPPUNIT_ASSERT_MESSAGE("Text selections must be in cell bounds!", !aCellBounds.Intersection(aView.m_aTextSelectionResult.getBounds(0)).IsEmpty()); SfxViewShell::Current()->setLibreOfficeKitViewCallback(nullptr); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testSheetViewDataCrash) { ScModelObj* pModelObj = createDoc("empty.ods"); // view #1 int nView1 = SfxLokHelper::getView(); SfxLokHelper::setView(nView1); // Imitate online while creating a new sheet on empty.ods. uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "Name", uno::Any(u"NewSheet"_ustr) }, { "Index", uno::Any(sal_Int32(2)) } })); dispatchCommand(mxComponent, u".uno:Insert"_ustr, aArgs); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEDOWN | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEDOWN | KEY_MOD1); Scheduler::ProcessEventsToIdle(); ScTabViewShell* pView1 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView1); // view #2 SfxLokHelper::createView(); ScTabViewShell* pView2 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView2); Scheduler::ProcessEventsToIdle(); SfxLokHelper::setView(nView1); // Delete a range. pView1->SetCursor(1, 1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DOWN | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DOWN | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DELETE); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DELETE); // It will crash at this point without the fix. Scheduler::ProcessEventsToIdle(); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testTextBoxInsert) { createDoc("empty.ods"); ScTestViewCallback aView1; // insert textbox uno::Sequence<beans::PropertyValue> aArgs( comphelper::InitPropertySequence({ { "CreateDirectly", uno::Any(true) } })); dispatchCommand(mxComponent, u".uno:DrawText"_ustr, aArgs); // check if we have textbox selected CPPUNIT_ASSERT(!aView1.m_ShapeSelection.isEmpty()); CPPUNIT_ASSERT(aView1.m_ShapeSelection != "EMPTY"); Scheduler::ProcessEventsToIdle(); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testCommentCellCopyPaste) { // Comments callback are emitted only if tiled annotations are off comphelper::LibreOfficeKit::setTiledAnnotations(false); // FIXME: Hack because previous tests do not destroy ScDocument(with annotations) on exit (?) ScPostIt::mnLastPostItId = 1; { ScModelObj* pModelObj = createDoc("empty.ods"); ScTestViewCallback aView; int nView = SfxLokHelper::getView(); SfxLokHelper::setView(nView); ScTabViewShell* pTabViewShell = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current() CPPUNIT_ASSERT(pTabViewShell); typeCharsInCell("ABC", 0, 0, pTabViewShell, pModelObj); // Type "ABC" in A1 pTabViewShell->SetCursor(1, 1); // Add a new comment uno::Sequence<beans::PropertyValue> aArgs(comphelper::InitPropertySequence( { {"Text", uno::Any(u"LOK Comment Cell B2"_ustr)}, {"Author", uno::Any(u"LOK Client"_ustr)}, })); dispatchCommand(mxComponent, u".uno:InsertAnnotation"_ustr, aArgs); // We received a LOK_CALLBACK_COMMENT callback with comment 'Add' action CPPUNIT_ASSERT_EQUAL(std::string("Add"), aView.m_aCommentCallbackResult.get<std::s CPPUNIT_ASSERT_EQUAL(std::string("1"), aView.m_aCommentCallbackResult.get<std::str CPPUNIT_ASSERT_EQUAL(std::string("0"), aView.m_aCommentCallbackResult.get<std::str CPPUNIT_ASSERT_EQUAL(std::string("LOK Client"), aView.m_aCommentCallbackResult.get< CPPUNIT_ASSERT_EQUAL(std::string("LOK Comment Cell B2"), aView.m_aCommentCallbackRes uno::Sequence<beans::PropertyValue> aCopyPasteArgs; // We need separate tests for single cell copy-paste and cell-range copy-paste // since they hit different code paths in ScColumn methods. // Single cell(with comment) copy paste test { dispatchCommand(mxComponent, u".uno:Copy"_ustr, aCopyPasteArgs); pTabViewShell->SetCursor(1, 49); Scheduler::ProcessEventsToIdle(); dispatchCommand(mxComponent, u".uno:Paste"_ustr, aCopyPasteArgs); // Paste to cell B50 // We received a LOK_CALLBACK_COMMENT callback with comment 'Add' action CPPUNIT_ASSERT_EQUAL(std::string("Add"), aView.m_aCommentCallbackResult.get<std::s // Without the fix the id will be "1". CPPUNIT_ASSERT_EQUAL(std::string("2"), aView.m_aCommentCallbackResult.get<std::str CPPUNIT_ASSERT_EQUAL(std::string("0"), aView.m_aCommentCallbackResult.get<std::str CPPUNIT_ASSERT_EQUAL(std::string("LOK Client"), aView.m_aCommentCallbackResult.get< CPPUNIT_ASSERT_EQUAL(std::string("LOK Comment Cell B2"), aView.m_aCommentCallbackRes } // Cell range (with a comment) copy paste test { // Select range A1:C3 pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_HOME | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_HOME | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_RIGHT | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_RIGHT | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_RIGHT | KEY_SHIFT); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_RIGHT | KEY_SHIFT); Scheduler::ProcessEventsToIdle(); dispatchCommand(mxComponent, u".uno:Copy"_ustr, aCopyPasteArgs); pTabViewShell->SetCursor(3, 49); Scheduler::ProcessEventsToIdle(); dispatchCommand(mxComponent, u".uno:Paste"_ustr, aCopyPasteArgs); // Paste to cell D50 // We received a LOK_CALLBACK_COMMENT callback with comment 'Add' action CPPUNIT_ASSERT_EQUAL(std::string("Add"), aView.m_aCommentCallbackResult.get<std::s // Without the fix the id will be "1". CPPUNIT_ASSERT_EQUAL(std::string("3"), aView.m_aCommentCallbackResult.get<std::str CPPUNIT_ASSERT_EQUAL(std::string("0"), aView.m_aCommentCallbackResult.get<std::str CPPUNIT_ASSERT_EQUAL(std::string("LOK Client"), aView.m_aCommentCallbackResult.get< CPPUNIT_ASSERT_EQUAL(std::string("LOK Comment Cell B2"), aView.m_aCommentCallbackRes } } comphelper::LibreOfficeKit::setTiledAnnotations(true); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testInvalidEntrySave) { loadFromFile(u"validity.xlsx"); // .uno:Save modifies the original file, make a copy first saveAndReload(u"Calc Office Open XML"_ustr); ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); CPPUNIT_ASSERT(pModelObj); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); const ScDocument* pDoc = pModelObj->GetDocument(); ScTestViewCallback aView; int nView = SfxLokHelper::getView(); SfxLokHelper::setView(nView); ScDocShell* pDocSh = dynamic_cast< ScDocShell* >( pModelObj->GetEmbeddedObject() ); ScTabViewShell* pTabViewShell = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current() CPPUNIT_ASSERT(pTabViewShell); // Type partial date "7/8" of "7/8/2013" that // the validation cell at A8 can accept typeCharsInCell("7/8", 0, 7, pTabViewShell, pModelObj, false /* bInEdit */, false /* bCommit */); // Type "7/8" in A8 uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:Save"_ustr, aArgs); CPPUNIT_ASSERT_MESSAGE("Should not be marked modified after save", !pDocSh->IsModified() // Complete the date in A8 by appending "/2013" and commit. typeCharsInCell("/2013", 0, 7, pTabViewShell, pModelObj, true /* bInEdit */, true /* bCommit */); // This would hang if the date entered "7/8/2013" is not acceptable. Scheduler::ProcessEventsToIdle(); // Ensure that the correct date is recorded in the document. CPPUNIT_ASSERT_EQUAL(double(41463), pDoc->GetValue(ScAddress(0, 7, 0))); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testUndoReordering) { ScModelObj* pModelObj = createDoc("small.ods"); CPPUNIT_ASSERT(pModelObj); ScDocument* pDoc = pModelObj->GetDocument(); CPPUNIT_ASSERT(pDoc); ScUndoManager* pUndoManager = pDoc->GetUndoManager(); CPPUNIT_ASSERT(pUndoManager); // view #1 int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; // view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // text edit a cell in view #1 SfxLokHelper::setView(nView1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); // check that undo action count is not 0 CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); // text edit a different cell in view #2 SfxLokHelper::setView(nView2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN); Scheduler::ProcessEventsToIdle(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_DOWN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); // check that undo action count is not 1 CPPUNIT_ASSERT_EQUAL(std::size_t(2), pUndoManager->GetUndoActionCount()); // try to execute undo in view #1 SfxLokHelper::setView(nView1); dispatchCommand(mxComponent, u".uno:Undo"_ustr, {}); // check that undo has been executed on view #1 CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); // try to execute undo in view #2 SfxLokHelper::setView(nView2); dispatchCommand(mxComponent, u".uno:Undo"_ustr, {}); // check that undo has been executed on view #2 CPPUNIT_ASSERT_EQUAL(std::size_t(0), pUndoManager->GetUndoActionCount()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testUndoReorderingRedo) { ScModelObj* pModelObj = createDoc("empty.ods"); CPPUNIT_ASSERT(pModelObj); ScDocument* pDoc = pModelObj->GetDocument(); CPPUNIT_ASSERT(pDoc); ScUndoManager* pUndoManager = pDoc->GetUndoManager(); CPPUNIT_ASSERT(pUndoManager); CPPUNIT_ASSERT_EQUAL(std::size_t(0), pUndoManager->GetUndoActionCount()); // view #1 int nView1 = SfxLokHelper::getView(); SfxViewShell* pView1 = SfxViewShell::Current(); ScTestViewCallback aView1; // view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); SfxViewShell* pView2 = SfxViewShell::Current(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // text edit a cell in view #1 SfxLokHelper::setView(nView1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); // text edit another cell in view #1 SfxLokHelper::setView(nView1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'y', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'y', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'y', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'y', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(std::size_t(2), pUndoManager->GetUndoActionCount()); CPPUNIT_ASSERT_EQUAL(u"xx"_ustr, pDoc->GetString(ScAddress(0, 0, 0))); CPPUNIT_ASSERT_EQUAL(u"yy"_ustr, pDoc->GetString(ScAddress(0, 1, 0))); // text edit a different cell in view #2 SfxLokHelper::setView(nView2); ScTabViewShell* pViewShell2 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); pViewShell2->SetCursor(0, 2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'C', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'C', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'C', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'C', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(std::size_t(3), pUndoManager->GetUndoActionCount()); CPPUNIT_ASSERT_EQUAL(u"xx"_ustr, pDoc->GetString(ScAddress(0, 0, 0))); CPPUNIT_ASSERT_EQUAL(u"yy"_ustr, pDoc->GetString(ScAddress(0, 1, 0))); CPPUNIT_ASSERT_EQUAL(u"CC"_ustr, pDoc->GetString(ScAddress(0, 2, 0))); // View 1 presses undo, and the second cell is erased SfxLokHelper::setView(nView1); dispatchCommand(mxComponent, u".uno:Undo"_ustr, {}); CPPUNIT_ASSERT_EQUAL(std::size_t(2), pUndoManager->GetUndoActionCount()); CPPUNIT_ASSERT_EQUAL(u"xx"_ustr, pDoc->GetString(ScAddress(0, 0, 0))); CPPUNIT_ASSERT_EQUAL(u""_ustr, pDoc->GetString(ScAddress(0, 1, 0))); CPPUNIT_ASSERT_EQUAL(u"CC"_ustr, pDoc->GetString(ScAddress(0, 2, 0))); // Verify that the UNDO buttons/actions are still enabled { SfxItemSet aSet1(pView1->GetPool(), svl::Items<SID_UNDO, SID_UNDO>); SfxItemSet aSet2(pView2->GetPool(), svl::Items<SID_UNDO, SID_UNDO>); pView1->GetSlotState(SID_UNDO, nullptr, &aSet1); pView2->GetSlotState(SID_UNDO, nullptr, &aSet2); CPPUNIT_ASSERT_EQUAL(SfxItemState::SET, aSet1.GetItemState(SID_UNDO)); CPPUNIT_ASSERT(dynamic_cast< const SfxStringItem* >(aSet1.GetItem(SID_UNDO))); CPPUNIT_ASSERT_EQUAL(SfxItemState::SET, aSet2.GetItemState(SID_UNDO)); CPPUNIT_ASSERT(dynamic_cast< const SfxStringItem* >(aSet2.GetItem(SID_UNDO))); } // View 1 presses undo again, and the first cell is erased dispatchCommand(mxComponent, u".uno:Undo"_ustr, {}); CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); CPPUNIT_ASSERT_EQUAL(u""_ustr, pDoc->GetString(ScAddress(0, 0, 0))); CPPUNIT_ASSERT_EQUAL(u""_ustr, pDoc->GetString(ScAddress(0, 1, 0))); CPPUNIT_ASSERT_EQUAL(u"CC"_ustr, pDoc->GetString(ScAddress(0, 2, 0))); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testUndoReorderingMulti) { ScModelObj* pModelObj = createDoc("empty.ods"); CPPUNIT_ASSERT(pModelObj); ScDocument* pDoc = pModelObj->GetDocument(); CPPUNIT_ASSERT(pDoc); ScUndoManager* pUndoManager = pDoc->GetUndoManager(); CPPUNIT_ASSERT(pUndoManager); CPPUNIT_ASSERT_EQUAL(std::size_t(0), pUndoManager->GetUndoActionCount()); // view #1 int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; // view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; // text edit a cell in view #1 SfxLokHelper::setView(nView1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(std::size_t(1), pUndoManager->GetUndoActionCount()); // text edit a different cell in view #2 SfxLokHelper::setView(nView2); ScTabViewShell* pView2 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); pView2->SetCursor(0, 2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'C', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'C', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'C', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'C', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(std::size_t(2), pUndoManager->GetUndoActionCount()); CPPUNIT_ASSERT_EQUAL(u"xx"_ustr, pDoc->GetString(ScAddress(0, 0, 0))); CPPUNIT_ASSERT_EQUAL(u"CC"_ustr, pDoc->GetString(ScAddress(0, 2, 0))); // and another cell in view #2 pView2->SetCursor(0, 3); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'D', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'D', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'D', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'D', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::RETURN); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::RETURN); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT_EQUAL(std::size_t(3), pUndoManager->GetUndoActionCount()); CPPUNIT_ASSERT_EQUAL(u"xx"_ustr, pDoc->GetString(ScAddress(0, 0, 0))); CPPUNIT_ASSERT_EQUAL(u"CC"_ustr, pDoc->GetString(ScAddress(0, 2, 0))); CPPUNIT_ASSERT_EQUAL(u"DD"_ustr, pDoc->GetString(ScAddress(0, 3, 0))); // View 1 presses undo SfxLokHelper::setView(nView1); dispatchCommand(mxComponent, u".uno:Undo"_ustr, {}); CPPUNIT_ASSERT_EQUAL(std::size_t(2), pUndoManager->GetUndoActionCount()); CPPUNIT_ASSERT_EQUAL(u""_ustr, pDoc->GetString(ScAddress(0, 0, 0))); CPPUNIT_ASSERT_EQUAL(u"CC"_ustr, pDoc->GetString(ScAddress(0, 2, 0))); CPPUNIT_ASSERT_EQUAL(u"DD"_ustr, pDoc->GetString(ScAddress(0, 3, 0))); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testGetViewRenderState) { // Add a pair of schemes, last added is the default svtools::EditableColorConfig aColorConfig; aColorConfig.AddScheme(u"Dark"_ustr); aColorConfig.AddScheme(u"Light"_ustr); ScModelObj* pModelObj = createDoc("empty.ods"); int nFirstViewId = SfxLokHelper::getView(); ScTestViewCallback aView1; CPPUNIT_ASSERT_EQUAL("S;Default"_ostr, pModelObj->getViewRenderState()); // Create a second view SfxLokHelper::createView(); ScTestViewCallback aView2; CPPUNIT_ASSERT_EQUAL("S;Default"_ostr, pModelObj->getViewRenderState()); // Set second view to dark scheme { uno::Sequence<beans::PropertyValue> aPropertyValues = comphelper::InitPropertySequenc { { "NewTheme", uno::Any(u"Dark"_ustr) }, } ); dispatchCommand(mxComponent, u".uno:ChangeTheme"_ustr, aPropertyValues); } CPPUNIT_ASSERT_EQUAL("S;Dark"_ostr, pModelObj->getViewRenderState()); // Switch back to first view and make sure it's the same SfxLokHelper::setView(nFirstViewId); CPPUNIT_ASSERT_EQUAL("S;Default"_ostr, pModelObj->getViewRenderState()); } /* * testInvalidateOnTextEditWithDifferentZoomLevels * steps: * set view 1 zoom to the passed zoom level * in view 1 type a char at the passed cell address * store invalidation rectangle * exit from in place editing (press esc) * create view 2 (keep 100% zoom) * go to the same cell address used in view 1 * type a char into the cell * get invalidation rectangle for view 1 * check if the invalidation rectangle is equal to the one stored previously */ class testInvalidateOnTextEditWithDifferentZoomLevels : public ScTiledRenderingTest { public: void TestBody(const ColRowZoom& rData); CPPUNIT_TEST_SUITE(testInvalidateOnTextEditWithDifferentZoomLevels); CPPUNIT_TEST_PARAMETERIZED(TestBody, std::initializer_list<ColRowZoom> { // zoom level 120% {0, 999, 1}, {99, 0, 1}, // zoom level 40% {0, 999, -5}, {99, 0, -5} }); CPPUNIT_TEST_SUITE_END(); }; CPPUNIT_TEST_SUITE_REGISTRATION(testInvalidateOnTextEditWithDifferentZoomLevels) void testInvalidateOnTextEditWithDifferentZoomLevels::TestBody(const ColRowZoom&&nbs { ScModelObj* pModelObj = createDoc("empty.ods"); CPPUNIT_ASSERT(pModelObj); ScDocument* pDoc = pModelObj->GetDocument(); CPPUNIT_ASSERT(pDoc); OUString sZoomUnoCmd = u".uno:ZoomPlus"_ustr; int nZoomLevel = rData.zoom; if (nZoomLevel < 0) { nZoomLevel = -nZoomLevel; sZoomUnoCmd = ".uno:ZoomMinus"; } // view #1 ScTestViewCallback aView1; // set zoom level for (int i = 0; i < nZoomLevel; ++i) dispatchCommand(mxComponent, sZoomUnoCmd, {}); Scheduler::ProcessEventsToIdle(); auto* pTabViewShell1 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pTabViewShell1); // enable in place editing in view 1 auto& rInvalidations = aView1.m_aInvalidations; pTabViewShell1->SetCursor(rData.col, rData.row); Scheduler::ProcessEventsToIdle(); aView1.m_bInvalidateTiles = false; rInvalidations.clear(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT(!rInvalidations.empty()); tools::Rectangle aInvRect1 = rInvalidations[0]; // end editing pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::ESCAPE); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::ESCAPE); Scheduler::ProcessEventsToIdle(); // view #2 SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTestViewCallback aView2; Scheduler::ProcessEventsToIdle(); auto* pTabViewShell2 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pTabViewShell2); pTabViewShell2->SetCursor(rData.col, rData.row); Scheduler::ProcessEventsToIdle(); // text edit in view #2 aView1.m_bInvalidateTiles = false; rInvalidations.clear(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'x', 0); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'x', 0); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(aView1.m_bInvalidateTiles); CPPUNIT_ASSERT(!rInvalidations.empty()); tools::Rectangle aInvRect2 = rInvalidations[0]; CPPUNIT_ASSERT_EQUAL_MESSAGE("Invalidation rectangle is wrong.", aInvRect1, aInvRect2 } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testOpenURL) { // Given a document that has 2 views: createDoc("empty.ods"); int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; SfxLokHelper::createView(); ScTestViewCallback aView2; // When clicking on a link in view 2, but switching to view 1 before processing async events: ScGlobal::OpenURL(/*aUrl=*/u"http://www.example.com/"_ustr, /*aTarget=*/u""_ustr, /*bIgnoreSettings=*/true); SfxLokHelper::setView(nView1); Scheduler::ProcessEventsToIdle(); // Then make sure view 2 gets the callback, not view 1: // Without the accompanying fix in place, this test would have failed, view 1 got the hyperlink // callback. CPPUNIT_ASSERT(aView1.m_aHyperlinkClicked.isEmpty()); CPPUNIT_ASSERT(!aView2.m_aHyperlinkClicked.isEmpty()); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testInvalidateForSplitPanes) { comphelper::LibreOfficeKit::setCompatFlag( comphelper::LibreOfficeKit::Compat::scPrintTwipsMsgs); ScModelObj* pModelObj = createDoc("split.ods"); CPPUNIT_ASSERT(pModelObj); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); // view ScTestViewCallback aView; // move way over to the right where BP:20 exists, enough so that rows A and B // would scroll off the page and not be visible, if they were not frozen pModelObj->setClientVisibleArea(tools::Rectangle(73050, 0, 94019, 7034)); Scheduler::ProcessEventsToIdle(); ScAddress aBP20(67, 19, 0); // BP:20 pView->SetCursor(aBP20.Col(), aBP20.Row()); Scheduler::ProcessEventsToIdle(); aView.m_bInvalidateTiles = false; aView.m_aInvalidations.clear(); typeCharsInCell("X", aBP20.Col(), aBP20.Row(), pView, pModelObj); // Type 'X' in A1 CPPUNIT_ASSERT(aView.m_bInvalidateTiles); // missing before fix tools::Rectangle aTopLeftPane(0, 500, 3817, 742); bool bFoundTopLeftPane = std::find(aView.m_aInvalidations.begin(), aView.m_aInvalidations.end(), aTopLeftPa CPPUNIT_ASSERT_MESSAGE("The cell visible in the top left pane should be redrawn", bFoundTop // missing before fix tools::Rectangle aBottomLeftPane(0, 500, 3817, 3242); bool bFoundBottomLeftPane = std::find(aView.m_aInvalidations.begin(), aView.m_aInvalidations.end(), aBottomLef CPPUNIT_ASSERT_MESSAGE("The cell visible in the bottom left pane should be redrawn", bFound } // Saving shouldn't trigger an invalidation CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testNoInvalidateOnSave) { comphelper::LibreOfficeKit::setCompatFlag( comphelper::LibreOfficeKit::Compat::scPrintTwipsMsgs); loadFromFile(u"invalidate-on-save.ods"); // .uno:Save modifies the original file, make a copy first saveAndReload(u"calc8"_ustr); ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); CPPUNIT_ASSERT(pModelObj); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); Scheduler::ProcessEventsToIdle(); // track invalidations ScTestViewCallback aView; uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:Save"_ustr, aArgs); Scheduler::ProcessEventsToIdle(); CPPUNIT_ASSERT(!aView.m_bInvalidateTiles); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testCellMinimalInvalidations) { ScAddress aA8(0, 7, 0); ScAddress aD4(3, 7, 0); ScAddress aD13(3, 12, 0); ScAddress aD17(3, 16, 0); ScModelObj* pModelObj = createDoc("cell-invalidations.ods"); CPPUNIT_ASSERT(pModelObj); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); // Changed: Minimized invalidations (bFullRow: false) // Common case, LTR, default cell formatting cellInvalidationHelper(pModelObj, pView, aA8, true, false); cellInvalidationHelper(pModelObj, pView, aD4, true, false); // Left-aligned merged cells cellInvalidationHelper(pModelObj, pView, aD17, true, false); // Delete single cell text case cellInvalidationHelper(pModelObj, pView, aA8, false, false); // Paste into a single cell { pView->SetCursor(aD4.Col(), aD4.Row()); uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:Copy"_ustr, aArgs); pView->SetCursor(aA8.Col(), aA8.Row()); Scheduler::ProcessEventsToIdle(); ScTestViewCallback aView; dispatchCommand(mxComponent, u".uno:Paste"_ustr, aArgs); Scheduler::ProcessEventsToIdle(); checkSampleInvalidation(aView, false); } // Unchanged: Non-minimized invalidations (bFullRow: true) // Centered merged cells; cellInvalidationHelper(pModelObj, pView, aD13, true, true); // switch to RTL sheet pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::PAGEDOWN | KEY_MOD1); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::PAGEDOWN | KEY_MOD1); Scheduler::ProcessEventsToIdle(); cellInvalidationHelper(pModelObj, pView, aA8, true, true); cellInvalidationHelper(pModelObj, pView, aD4, true, true); // Delete Text cellInvalidationHelper(pModelObj, pView, aA8, false, true); } // That we don't end up with two views on different zooms that invalidate different // rectangles, each should invalidate the same rectangle CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testCellInvalidationDocWithExistingZoo { ScAddress aB7(1, 6, 0); ScopedVclPtrInstance<VirtualDevice> xDevice(DeviceFormat::WITHOUT_ALPHA); ScModelObj* pModelObj = createDoc("cell-invalidations-200zoom-settings.ods"); CPPUNIT_ASSERT(pModelObj); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); // Set View #1 to initial 100% and generate a paint pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 19845, 6405)); pModelObj->setClientZoom(256, 256, 1536, 1536); pModelObj->paintTile(*xDevice, 3328, 512, 0, 0, 19968, 3072); Scheduler::ProcessEventsToIdle(); int nView1 = SfxLokHelper::getView(); // register to track View #1 invalidations ScTestViewCallback aView1; // Create a View #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); // register to track View #1 invalidations ScTestViewCallback aView2; // Set View #2 to initial 100% and generate a paint pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 19845, 6405)); pModelObj->setClientZoom(256, 256, 1536, 1536); pModelObj->paintTile(*xDevice, 3328, 512, 0, 0, 19968, 3072); // Set View #1 to 50% zoom and generate a paint SfxLokHelper::setView(nView1); pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 41150, 13250)); pModelObj->setClientZoom(256, 256, 3185, 3185); pModelObj->paintTile(*xDevice, 3328, 512, 0, 0, 41405, 6370); Scheduler::ProcessEventsToIdle(); // Set View #2 to 200% zoom and generate a paint SfxLokHelper::setView(nView2); pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 9574, 3090)); pModelObj->setClientZoom(256, 256, 741, 741); pModelObj->paintTile(*xDevice, 3328, 512, 0, 0, 19968, 3072); Scheduler::ProcessEventsToIdle(); aView1.m_bInvalidateTiles = false; aView1.m_aInvalidations.clear(); aView2.m_bInvalidateTiles = false; aView2.m_aInvalidations.clear(); ScTabViewShell* pView2 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView2); pView2->SetCursor(aB7.Col(), aB7.Row()); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::DELETE); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::DELETE); Scheduler::ProcessEventsToIdle(); // The problem tested for here is with two views at different zooms then a // single cell invalidation resulted in the same rectangle reported as two // different invalidations rectangles of different scales. While we should // get the same invalidation rectangle reported. // // (B7 is a good choice to use in the real world to see the effect, to both // avoid getting the two rects combined into one bigger one, or to have the // two separated by so much space the 2nd is off-screen and not seen CPPUNIT_ASSERT_EQUAL(size_t(1), aView1.m_aInvalidations.size()); CPPUNIT_ASSERT_EQUAL(size_t(1), aView2.m_aInvalidations.size()); // That they don't exactly match doesn't matter, we're not checking rounding issues, // what matters is that they are not utterly different rectangles // Without fix result is originally: // Comparing invalidation rectangles Width expected 6214742 actual 26716502 Tolerance 50 CPPUNIT_ASSERT_RECTANGLE_EQUAL_WITH_TOLERANCE(aView2.m_aInvalidations[0], aView1.m_aInvalidations[0], 50); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testInputHandlerSyncedZoom) { ScModelObj* pModelObj = createDoc("cell-edit-300zoom-settings.ods"); // Set View #1 to initial 150% pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 17933, 4853)); // Before the fix, this zoom would leave the EditEngine reference device // at the zoom level stored in the document, so normal rendering and // editing rendering happened with different MapModes pModelObj->setClientZoom(256, 256, 1333, 1333); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); pView->SetCursor(0, 4); // A5 Scheduler::ProcessEventsToIdle(); // Activate edit mode in that A5 cell pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::F2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::F2); Scheduler::ProcessEventsToIdle(); const ScViewData* pViewData1 = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData1); // Get that active EditView EditView* pEditView1 = pViewData1->GetEditView(SC_SPLIT_BOTTOMLEFT); CPPUNIT_ASSERT(pEditView1); EditEngine& rEditEngine1 = pEditView1->getEditEngine(); // These must match, if they don't then text will have a different width in edit and view modes CPPUNIT_ASSERT_EQUAL_MESSAGE("EditEngine Ref Dev Zoom and ViewData Zoom should match", pViewData1->GetZoomX(), rEditEngine1.GetRefMapMode().GetScaleX()); CPPUNIT_ASSERT_EQUAL_MESSAGE("EditEngine Ref Dev Zoom and ViewData Zoom should match", pViewData1->GetZoomY(), rEditEngine1.GetRefMapMode().GetScaleY()); // Create a View #2 SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); // Set View #2 to the same zoom as View #1 pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 17933, 4853)); pModelObj->setClientZoom(256, 256, 1333, 1333); ScTabViewShell* pView2 = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView2); pView2->SetCursor(0, 5); // A6 Scheduler::ProcessEventsToIdle(); // Activate edit mode in that A6 cell pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::F2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::F2); Scheduler::ProcessEventsToIdle(); const ScViewData* pViewData2 = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData2); // Get the View #2 EditView EditView* pEditView2 = pViewData2->GetEditView(SC_SPLIT_BOTTOMLEFT); CPPUNIT_ASSERT(pEditView2); EditEngine& rEditEngine2 = pEditView2->getEditEngine(); CPPUNIT_ASSERT(&rEditEngine1 != &rEditEngine2); // Before the fix, these had different settings, resulting in the text // dancing for the second user as they toggle in and out of edit mode, but // each user should have the same settings. CPPUNIT_ASSERT_EQUAL(rEditEngine1.GetControlWord(), rEditEngine2.GetControlWord() } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testStatusBarLocale) { // Given 2 views, the second's locale is set to German: createDoc("empty.ods"); int nView1 = SfxLokHelper::getView(); ScTestViewCallback aView1; SfxLokHelper::createView(); ScTestViewCallback aView2; SfxViewShell* pView2 = SfxViewShell::Current(); pView2->SetLOKLocale(u"de-DE"_ustr); { SfxViewFrame& rFrame = pView2->GetViewFrame(); SfxSlotPool& rSlotPool = SfxSlotPool::GetSlotPool(&rFrame); uno::Reference<util::XURLTransformer> xParser(util::URLTransformer::create(m_xConte util::URL aCommandURL; aCommandURL.Complete = ".uno:RowColSelCount"; xParser->parseStrict(aCommandURL); const SfxSlot* pSlot = rSlotPool.GetUnoSlot(aCommandURL.Path); rFrame.GetBindings().GetDispatch(pSlot, aCommandURL, false); } aView2.m_aStateChanges.clear(); // When creating a cell selection in the 2nd view and processing jobs with the 1st view set to // active: comphelper::dispatchCommand(u".uno:GoDownSel"_ustr, {}); SfxLokHelper::setView(nView1); pView2->GetViewFrame().GetBindings().GetTimer().Invoke(); // Once more to hit the pImpl->bMsgDirty = false case in SfxBindings::NextJob_Impl(). pView2->GetViewFrame().GetBindings().GetTimer().Invoke(); // Then make sure that the locale is taken into account while producing the state changed // callback: auto it = aView2.m_aStateChanges.find(".uno:RowColSelCount"); CPPUNIT_ASSERT(it != aView2.m_aStateChanges.end()); std::string aLocale = it->second.get<std::string>("locale"); // Without the accompanying fix in place, this test would have failed with: // - Expected: de-DE // - Actual : en-US // i.e. the 2nd view got its callback with the locale of the first view, which is buggy. CPPUNIT_ASSERT_EQUAL(std::string("de-DE"), aLocale); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testLongFirstColumnMouseClick) { // Document has a long first column. We want to mouse-click on the column and // check the selection changed to this column. // The issue we want to reproduce is that the click on a cell in the first column that is // very long (longer than ~800px default size of GridWindow) triggers a code-path where the cel // selected is the neighbouring cell even when we clicked on the area of the first cell. comphelper::LibreOfficeKit::setCompatFlag( comphelper::LibreOfficeKit::Compat::scPrintTwipsMsgs); ScModelObj* pModelObj = createDoc("DocumentWithLongFirstColumn.ods"); CPPUNIT_ASSERT(pModelObj); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); // Fetch current view data ScViewData* pViewData = ScDocShell::GetViewData(); CPPUNIT_ASSERT(pViewData); double nPPTX = pViewData->GetPPTX(); double nPPTY = pViewData->GetPPTX(); // Set click position // Left side of the first cell int leftCellSideX = 1 / nPPTX; // convert pixels to logical units // Right side of the first cell. First cell is long so click somewhere more than 800px (default of int rightCellSideX = 1000 / nPPTX; // convert pixels to logical units // Vertical position - doesn't matter - select the first row int y = 1 / nPPTY; // Setup view #1 ScTestViewCallback aView1; // Set client rect to 2000 x 2000 pixels pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 2000 / nPPTX, 2000 / nPPTY)); Scheduler::ProcessEventsToIdle(); // Click at on the left side of A1 cell pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, leftCellSideX, y, /*count= pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, leftCellSideX, y, /*count=*/ Scheduler::ProcessEventsToIdle(); // Check the A1 cell is selected in view #1 CPPUNIT_ASSERT_EQUAL(SCCOL(0), ScDocShell::GetViewData()->GetCurX()); CPPUNIT_ASSERT_EQUAL(SCROW(0), ScDocShell::GetViewData()->GetCurY()); // Click at on the right side of A1 cell pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, rightCellSideX, y, /*count pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, rightCellSideX, y, /*count=* Scheduler::ProcessEventsToIdle(); // Check the A1 cell is selected in view #1 CPPUNIT_ASSERT_EQUAL(SCCOL(0), ScDocShell::GetViewData()->GetCurX()); CPPUNIT_ASSERT_EQUAL(SCROW(0), ScDocShell::GetViewData()->GetCurY()); // Try to check the same scenario in a new view // Setup view #2 SfxLokHelper::createView(); int nView2 = SfxLokHelper::getView(); ScTestViewCallback aView2; // Set client rect to 2000 x 2000 pixels pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 2000 / nPPTX, 2000 / nPPTY)); // Let's make sure we are in view #2 SfxLokHelper::setView(nView2); Scheduler::ProcessEventsToIdle(); // Click at on the left side of A1 cell pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, leftCellSideX, y, /*count= pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, leftCellSideX, y, /*count=*/ Scheduler::ProcessEventsToIdle(); // Check the A1 cell is selected in view #2 CPPUNIT_ASSERT_EQUAL(SCCOL(0), ScDocShell::GetViewData()->GetCurX()); CPPUNIT_ASSERT_EQUAL(SCROW(0), ScDocShell::GetViewData()->GetCurY()); // Click at on the right side of A1 cell pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONDOWN, rightCellSideX, y, /*count pModelObj->postMouseEvent(LOK_MOUSEEVENT_MOUSEBUTTONUP, rightCellSideX, y, /*count=* Scheduler::ProcessEventsToIdle(); // Check the A1 cell is selected in view #2 CPPUNIT_ASSERT_EQUAL(SCCOL(0), ScDocShell::GetViewData()->GetCurX()); CPPUNIT_ASSERT_EQUAL(SCROW(0), ScDocShell::GetViewData()->GetCurY()); } // if we extend the tiled area to the right and bottom we want two resulting area // that don't overlap. If they overlap that typically creates an unnecessary full // screen invalidation. CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testExtendedAreasDontOverlap) { comphelper::LibreOfficeKit::setCompatFlag( comphelper::LibreOfficeKit::Compat::scPrintTwipsMsgs); ScModelObj* pModelObj = createDoc("empty.ods"); CPPUNIT_ASSERT(pModelObj); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); // Set an arbitrary initial size smaller than the final size pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 1000, 1000)); Scheduler::ProcessEventsToIdle(); // register to track View #1 invalidations ScTestViewCallback aView1; // extend to the right and bottom pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 39750, 12780)); Scheduler::ProcessEventsToIdle(); // we should get two rectangles for the two new areas CPPUNIT_ASSERT_EQUAL(size_t(2), aView1.m_aInvalidations.size()); // And those should not overlap, otherwise they would merge to form // a mega rectangle, which defeats the purpose of creating two rects // in the first place. CPPUNIT_ASSERT_MESSAGE("Invalidations should not overlap", !aView1.m_aInvalidations[0].Overlaps(aView1.m_aInvalidations[1])); // But they should be adjacent CPPUNIT_ASSERT_EQUAL(aView1.m_aInvalidations[0].Top() + aView1.m_aInvalidations[0].GetSize().Height(), aView1.m_aInvalidations[1].Top()); } // Ensure that editing a shape not in the topleft tile has its text shown inside the shape // center while editing CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testEditShapeText) { ScModelObj* pModelObj = createDoc("edit-shape-text.ods"); // Set View to initial 100% pModelObj->setClientVisibleArea(tools::Rectangle(0, 0, 28050, 10605)); pModelObj->setClientZoom(256, 256, 1920, 1920); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); const bool bShapeSelected = pView->SelectObject(u"Shape 1"); CPPUNIT_ASSERT(bShapeSelected); CPPUNIT_ASSERT(ScDocShell::GetViewData()->GetScDrawView()->GetMarkedObjectList().G Scheduler::ProcessEventsToIdle(); // Enter editing mode, shape start with no text pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::F2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::F2); Scheduler::ProcessEventsToIdle(); // Grab a snapshot of the center of the shape Bitmap aBitmapBefore = getTile(pModelObj, 4096, 3584, 15360, 7680); // reuse this to type into the active shape edit typeCharsInCell("MMMMMMM", 0, 0, pView, pModelObj, true, false); // Grab a new snapshot of the center of the shape Bitmap aBitmapAfter = getTile(pModelObj, 4096, 3584, 15360, 7680); // Without the fix, the text is not inside this tile and the before and // after are the same. CPPUNIT_ASSERT_MESSAGE("Text is not visible", aBitmapBefore != aBitmapAfter); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testNumberFormatLocaleMultiUser) { { // setup core language to FR as it will be the first session SvtSysLocaleOptions aLocalOptions; aLocalOptions.SetLocaleConfigString(u"fr-FR"_ustr); aLocalOptions.SetUILocaleConfigString(u"fr-FR"_ustr); aLocalOptions.Commit(); loadFromFile(u"numlocale.xlsx"); ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); CPPUNIT_ASSERT(pModelObj); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScDocument* pDoc = pModelObj->GetDocument(); int nViewFR = SfxLokHelper::getView(); ScTestViewCallback aView1; SfxViewShell* pViewFR = SfxViewShell::Current(); pViewFR->SetLOKLocale(u"fr-FR"_ustr); // modify G12 with FR and use French keywords in the format SfxLokHelper::setView(nViewFR); sal_Int32 nCheckPos; SvNumFormatType nType; sal_uInt32 nFormat; OUString aNumberFormat(u"JJ/MM/AAAA"_ustr); SvNumberFormatter* pFormatter = pDoc->GetFormatTable(); pFormatter->PutEntry(aNumberFormat, nCheckPos, nType, nFormat); ScAddress aCellPos1(/*nColP=*/6, /*nRowP=*/11, /*nTabP=*/0); pDoc->SetNumberFormat(aCellPos1, nFormat); Scheduler::ProcessEventsToIdle(); } { // now setup DE language in core SvtSysLocaleOptions aLocalOptions; aLocalOptions.SetLocaleConfigString(u"de-DE"_ustr); aLocalOptions.SetUILocaleConfigString(u"de-DE"_ustr); aLocalOptions.Commit(); // save and reopen // .uno:Save modifies the original file, make a copy first saveAndReload(u"Calc MS Excel 2007 VBA XML"_ustr); ScModelObj* pModelObj = comphelper::getFromUnoTunnel<ScModelObj>(mxComponent); CPPUNIT_ASSERT(pModelObj); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); CPPUNIT_ASSERT(pView); Scheduler::ProcessEventsToIdle(); uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:Save"_ustr, aArgs); Scheduler::ProcessEventsToIdle(); ScDocument* pDoc = pModelObj->GetDocument(); // verify that format is correct (German), doesn't have any "string" inside sal_uInt32 nNumberFormat = pDoc->GetNumberFormat(/*col=*/6, /*row=*/11, /*tab=*/0); const SvNumberformat* pNumberFormat = pDoc->GetFormatTable()->GetEntry(nNumberFormat); CPPUNIT_ASSERT_EQUAL(u"TT.MM.JJ"_ustr, pNumberFormat->GetFormatstring()); } } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testLeftOverflowEdit) { comphelper::LibreOfficeKit::setCompatFlag(comphelper::LibreOfficeKit::Compat::sc ScModelObj* pModelObj = createDoc("right-aligned-with-overflow.ods"); ScTestViewCallback aView; // Go to Cell B5000 uno::Sequence<beans::PropertyValue> aPropertyValues = { comphelper::makePropertyValue(u"ToPoint"_ustr, u"$B$5000"_ustr), }; dispatchCommand(mxComponent, u".uno:GoToCell"_ustr, aPropertyValues); // Enter edit mode and select all text. aView.m_aTextSelectionResult.clear(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::F2); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::F2); Scheduler::ProcessEventsToIdle(); // CTRL + A pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, KEY_MOD1 | awt::Key::A); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, KEY_MOD1 | awt::Key::A); Scheduler::ProcessEventsToIdle(); // Without the accompanying fix this would fail with // - Expected: 20 // - Actual : 1300 CPPUNIT_ASSERT_EQUAL(tools::Long(20), aView.m_aTextSelectionResult.m_aRefPoint.ge } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testFreezeRowOrColumn) { createDoc("empty.ods"); ScTestViewCallback aView; SfxViewShell* pView = SfxViewShell::Current(); // Freeze panes on a column and receive the proper state back aView.m_aStateChanges.clear(); uno::Sequence<beans::PropertyValue> aPropertyValues = { comphelper::makePropertyValue("Index", uno::Any(static_cast<sal_Int32>(8))), }; comphelper::dispatchCommand(".uno:FreezePanesColumn", aPropertyValues); Scheduler::ProcessEventsToIdle(); pView->GetViewFrame().GetBindings().GetTimer().Invoke(); pView->GetViewFrame().GetBindings().GetTimer().Invoke(); auto it = aView.m_aStateChanges.find(".uno:FreezePanesColumn"); CPPUNIT_ASSERT(it != aView.m_aStateChanges.end()); std::string values = it->second.get<std::string>("state"); std::string index = values.substr(0, values.find(' ')); // Without the accompanying fix in place, this test would have failed with: // - Expected: 8 // - Actual : 1 CPPUNIT_ASSERT_EQUAL(std::string("8"), index); // Freeze panes on a row and receive the proper state back aView.m_aStateChanges.clear(); comphelper::dispatchCommand(".uno:FreezePanesRow", aPropertyValues); Scheduler::ProcessEventsToIdle(); pView->GetViewFrame().GetBindings().GetTimer().Invoke(); pView->GetViewFrame().GetBindings().GetTimer().Invoke(); it = aView.m_aStateChanges.find(".uno:FreezePanesRow"); CPPUNIT_ASSERT(it != aView.m_aStateChanges.end()); values = it->second.get<std::string>("state"); index = values.substr(0, values.find(' ')); // Without the accompanying fix in place, this test would have failed with: // - Expected: 8 // - Actual : 1 CPPUNIT_ASSERT_EQUAL(std::string("8"), index); } CPPUNIT_TEST_FIXTURE(ScTiledRenderingTest, testCursorVisibilityAfterPaste) { ScModelObj* pModelObj = createDoc("empty.ods"); ScTestViewCallback aView; SfxLokHelper::createView(); pModelObj->initializeForTiledRendering(uno::Sequence<beans::PropertyValue>()); ScTabViewShell* pView = dynamic_cast<ScTabViewShell*>(SfxViewShell::Current()); // copy text view 1 pView->SetCursor(0, 0); // Go to A1. Scheduler::ProcessEventsToIdle(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'B', 0); // Type B. pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'B', 0); Scheduler::ProcessEventsToIdle(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 0, awt::Key::TAB); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 0, awt::Key::TAB); Scheduler::ProcessEventsToIdle(); pView->SetCursor(0, 0); // Go to A1. Scheduler::ProcessEventsToIdle(); pView->GetViewFrame().GetBindings().Execute(SID_COPY); // Copy B. Scheduler::ProcessEventsToIdle(); pView->SetCursor(0, 1); // Go to A2. Scheduler::ProcessEventsToIdle(); pModelObj->postKeyEvent(LOK_KEYEVENT_KEYINPUT, 'B', 0); // Type B. pModelObj->postKeyEvent(LOK_KEYEVENT_KEYUP, 'B', 0); Scheduler::ProcessEventsToIdle(); uno::Sequence<beans::PropertyValue> aArgs; dispatchCommand(mxComponent, u".uno:Paste"_ustr, aArgs); // Paste B. Scheduler::ProcessEventsToIdle(); // Text cursor should still be visible. CPPUNIT_ASSERT_EQUAL(true, aView.m_textCursorVisible); } CPPUNIT_PLUGIN_IMPLEMENT(); /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
¤ Dauer der Verarbeitung: 0.55 Sekunden (vorverarbeitet am 2026-04-25) ¤*© Formatika GbR, Deutschland |
|
||||||||||||||
2026-05-26