1 files changed, 33 insertions, 35 deletions
diff --git a/sc/qa/uitest/chart/tdf107097.py b/sc/qa/uitest/chart/tdf107097.py
index 50ecccaff309..09db67f197cc 100644
--- a/sc/qa/uitest/chart/tdf107097.py
+++ b/sc/qa/uitest/chart/tdf107097.py
@@ -14,52 +14,50 @@ from uitest.uihelper.common import get_url_for_data_file
 class tdf107097(UITestCase):
 
   def test_tdf107097(self):
-    calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf107097.ods"))
-    xCalcDoc = self.xUITest.getTopFocusWindow()
-    gridwin = xCalcDoc.getChild("grid_window")
+    with self.ui_test.load_file(get_url_for_data_file("tdf107097.ods")) as calc_doc:
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
 
-    document = self.ui_test.get_component()
+        document = self.ui_test.get_component()
 
-    xFirstMatrix = []
-    for row in range(6, 18):
-        xRow = []
-        for column in range(3, 7):
-            xRow.append(get_cell_by_position(document, 1, column, row).getValue())
-        xFirstMatrix.append(xRow)
+        xFirstMatrix = []
+        for row in range(6, 18):
+            xRow = []
+            for column in range(3, 7):
+                xRow.append(get_cell_by_position(document, 1, column, row).getValue())
+            xFirstMatrix.append(xRow)
 
-    gridwin.executeAction("SELECT", mkPropertyValues({"OBJECT": "Object 1"}))
+        gridwin.executeAction("SELECT", mkPropertyValues({"OBJECT": "Object 1"}))
 
-    self.xUITest.executeCommand(".uno:Copy")
+        self.xUITest.executeCommand(".uno:Copy")
 
-    self.xUITest.executeCommand(".uno:CloseDoc")
+        self.xUITest.executeCommand(".uno:CloseDoc")
 
-    self.ui_test.create_doc_in_start_center("calc")
-    xCalcDoc = self.xUITest.getTopFocusWindow()
-    gridwin = xCalcDoc.getChild("grid_window")
-    document = self.ui_test.get_component()
+        self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
 
-    self.xUITest.executeCommand(".uno:Paste")
+        self.xUITest.executeCommand(".uno:Paste")
 
-    xData = document.Sheets[0].Charts[0].getEmbeddedObject().Data
+        xData = document.Sheets[0].Charts[0].getEmbeddedObject().Data
 
-    xSecondMatrix = []
-    for row in xData.Data:
-        xRow = []
-        for value in row:
-            xRow.append(value)
-        xSecondMatrix.append(xRow)
+        xSecondMatrix = []
+        for row in xData.Data:
+            xRow = []
+            for value in row:
+                xRow.append(value)
+            xSecondMatrix.append(xRow)
 
-    self.assertEqual(xFirstMatrix, xSecondMatrix)
+        self.assertEqual(xFirstMatrix, xSecondMatrix)
 
-    aExpectedColumnDescriptions = ('Sum - Sales T1', 'Sum - Sales T2',
-            'Sum - Sales T3', 'Sum - Sales T4')
-    aExpectedRowDescriptions = ('DE Berlin A', 'DE Berlin B', 'DE Munich A',
-            'DE Munich B', 'EN Glasgow A', 'EN Liverpool B', 'EN London A',
-            'EN London B', 'FR Nantes A', 'FR Nantes B', 'FR Paris A', 'FR Paris B')
+        aExpectedColumnDescriptions = ('Sum - Sales T1', 'Sum - Sales T2',
+                'Sum - Sales T3', 'Sum - Sales T4')
+        aExpectedRowDescriptions = ('DE Berlin A', 'DE Berlin B', 'DE Munich A',
+                'DE Munich B', 'EN Glasgow A', 'EN Liverpool B', 'EN London A',
+                'EN London B', 'FR Nantes A', 'FR Nantes B', 'FR Paris A', 'FR Paris B')
 
-    self.assertEqual(aExpectedColumnDescriptions, xData.ColumnDescriptions)
-    self.assertEqual(aExpectedRowDescriptions, xData.RowDescriptions)
-
-    self.ui_test.close_doc()
+        self.assertEqual(aExpectedColumnDescriptions, xData.ColumnDescriptions)
+        self.assertEqual(aExpectedRowDescriptions, xData.RowDescriptions)
 
 # vim: set shiftwidth=4 softtabstop=4 expandtab: