sc/qa/uitest/autofilter2/tdf117328.py | 63 ++++++++++++++++++++++++++++++++++
1 file changed, 63 insertions(+)
New commits:
commit bb52b88b3ee7736c9e81e9bb1308b7a2d964c792
Author: Andreas Heinisch <andreas.heini...@yahoo.de>
AuthorDate: Tue Jul 8 18:22:43 2025 +0200
Commit: Andreas Heinisch <andreas.heini...@yahoo.de>
CommitDate: Wed Jul 9 20:06:19 2025 +0200
tdf#117328 - Unit test for auto filter restoring empty cells
Change-Id: I6c08d6a12156ce8e035e8cb71715c8f786afbfe2
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/187546
Tested-by: Jenkins
Reviewed-by: Andreas Heinisch <andreas.heini...@yahoo.de>
diff --git a/sc/qa/uitest/autofilter2/tdf117328.py
b/sc/qa/uitest/autofilter2/tdf117328.py
new file mode 100644
index 000000000000..2f4745a18764
--- /dev/null
+++ b/sc/qa/uitest/autofilter2/tdf117328.py
@@ -0,0 +1,63 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-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/.
+#
+from uitest.framework import UITestCase
+from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_state_as_dict
+from libreoffice.calc.document import is_row_hidden
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
+class tdf117328(UITestCase):
+
+ def test_tdf117328_restore_empty_cells(self):
+ with self.ui_test.create_doc_in_start_center("calc") as calcDoc:
+ xCalcDoc = self.xUITest.getTopFocusWindow()
+ xGridWindow = xCalcDoc.getChild("grid_window")
+
+ # Insert test data
+ enter_text_to_cell(xGridWindow, "A1", "Header")
+ enter_text_to_cell(xGridWindow, "A2", "1")
+ enter_text_to_cell(xGridWindow, "A3", "2")
+ enter_text_to_cell(xGridWindow, "A4", "3")
+
+ # Apply auto filter on A1:A6 (including empty cells A5 and A6)
+ xGridWindow.executeAction("SELECT", mkPropertyValues({"RANGE":
"A1:A6"}))
+ self.xUITest.executeCommand(".uno:DataFilterAutoFilter")
+
+ # Search for the first entry and apply the auto filter
+ xGridWindow.executeAction("LAUNCH",
mkPropertyValues({"AUTOFILTER": "", "COL": "0", "ROW": "0"}))
+ xFloatWindow = self.xUITest.getFloatWindow()
+ xTreeList = xFloatWindow.getChild("check_list_box")
+ xSearchEdit = xFloatWindow.getChild("search_edit")
+ xSearchEdit.executeAction("TYPE", mkPropertyValues({"TEXT" : "1"}))
+ self.ui_test.wait_until_property_is_updated(xTreeList, "Children",
str(1))
+ self.assertEqual("1",
get_state_as_dict(xTreeList.getChild('0'))['Text'])
+ self.assertEqual(1, len(xTreeList.getChildren()))
+
+ xOkButton = xFloatWindow.getChild("ok")
+ xOkButton.executeAction("CLICK", tuple())
+
+ # Check that the correct rows are hidden/visible
+ self.assertFalse(is_row_hidden(calcDoc, 0))
+ self.assertFalse(is_row_hidden(calcDoc, 1))
+ self.assertTrue(is_row_hidden(calcDoc, 2))
+ self.assertTrue(is_row_hidden(calcDoc, 3))
+ self.assertTrue(is_row_hidden(calcDoc, 4))
+ self.assertTrue(is_row_hidden(calcDoc, 5))
+
+ # Remove filter and verify restored range includes empty cells
+ xGridWindow.executeAction("SELECT", mkPropertyValues({"CELL":
"A1"}))
+ self.xUITest.executeCommand(".uno:DataFilterRemoveFilter")
+ gridWinState = get_state_as_dict(xGridWindow)
+
+ # Without the fix in place, this test would have failed with
+ # AssertionError: 'Sheet1.A1:Sheet1.A6' != 'Sheet1.A1:Sheet1.A4'
+ # i.e., empty cells have not been restored
+ self.assertEqual(gridWinState["MarkedArea"], "Sheet1.A1:Sheet1.A6")
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
