sc/qa/uitest/calc_tests8/dataProvider.py | 29 +++++++++++++++++++++++++++++ sc/qa/uitest/data/tdf169817.csv | 9 +++++++++ sc/qa/uitest/data/tdf169817.ods |binary 3 files changed, 38 insertions(+)
New commits: commit 3e15e0e298cdd36b378ab5bad0f9bb618a89ae1a Author: Xisco Fauli <[email protected]> AuthorDate: Fri Dec 5 10:12:51 2025 +0100 Commit: Xisco Fauli <[email protected]> CommitDate: Fri Dec 5 15:10:27 2025 +0100 tdf#169817: sc: Add UItest Change-Id: I5f98daf992226881620e212089ee265b988235c8 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/195065 Tested-by: Jenkins Reviewed-by: Xisco Fauli <[email protected]> diff --git a/sc/qa/uitest/calc_tests8/dataProvider.py b/sc/qa/uitest/calc_tests8/dataProvider.py index cc9b9c69e85f..8ee9b5e60082 100644 --- a/sc/qa/uitest/calc_tests8/dataProvider.py +++ b/sc/qa/uitest/calc_tests8/dataProvider.py @@ -157,4 +157,33 @@ class DataProvider(UITestCase): for i in range(1, 101): self.assertEqual(str(i), get_cell_by_position(doc2, 0, 0, i).getString()) + def test_insert_correct_sheet(self): + + with self.ui_test.load_file(get_url_for_data_file('tdf169817.ods')) as document: + + with self.ui_test.execute_dialog_through_command(".uno:DataProvider") as xDialog: + xDB = xDialog.getChild("select_db_range") + xURL = xDialog.getChild("ed_url") + xProvider = xDialog.getChild("provider_lst") + select_by_text(xDB, "Second") + self.assertEqual("Second", get_state_as_dict(xDB)['DisplayText']) + + xBrowse = xDialog.getChild("browse") + with self.ui_test.execute_blocking_action( + xBrowse.executeAction, args=('CLICK', ()), close_button="") as dialog: + xFileName = dialog.getChild("file_name") + xFileName.executeAction("TYPE", mkPropertyValues({"TEXT": get_url_for_data_file("tdf169817.csv")})) + xOpen = dialog.getChild("open") + xOpen.executeAction("CLICK", tuple()) + + self.assertEqual(get_url_for_data_file("tdf169817.csv"), get_state_as_dict(xURL)['Text']) + self.assertEqual("CSV", get_state_as_dict(xProvider)['DisplayText']) + + # Without the fix in place, this test would have failed with + # AssertionError: 'ID' != '' + self.assertEqual("ID", get_cell_by_position(document, 1, 7, 4).getString()) + self.assertEqual("Region", get_cell_by_position(document, 1, 8, 4).getString()) + self.assertEqual("Name", get_cell_by_position(document, 1, 9, 4).getString()) + self.assertEqual("Sales", get_cell_by_position(document, 1, 10, 4).getString()) + # vim: set shiftwidth=4 softtabstop=4 expandtab: diff --git a/sc/qa/uitest/data/tdf169817.csv b/sc/qa/uitest/data/tdf169817.csv new file mode 100644 index 000000000000..def3281fdb5a --- /dev/null +++ b/sc/qa/uitest/data/tdf169817.csv @@ -0,0 +1,9 @@ +ID,Region,Name,Sales +1,West,Anne,8 +2,East,Bob,5 +3,East,Claudia,4 +4,West,Ali,8 +5,West,Doris,3 +6,East,Frieda,6 +7,East,Edith,4 +8,East,Betty,2 diff --git a/sc/qa/uitest/data/tdf169817.ods b/sc/qa/uitest/data/tdf169817.ods new file mode 100644 index 000000000000..4c90febd825e Binary files /dev/null and b/sc/qa/uitest/data/tdf169817.ods differ
