summaryrefslogtreecommitdiff
path: root/pyuno/qa
diff options
context:
space:
mode:
authorKevin Hunter <hunteke@earlham.edu>2014-02-16 22:12:27 -0500
committerStephan Bergmann <sbergman@redhat.com>2014-02-20 12:01:34 +0100
commitf2471280c7c625e39369f76bd0efa1d2402f62bf (patch)
tree80e2fb2e19ae3d85f75d72660a8cca51cfe16cee /pyuno/qa
parent4e887567c5b4b06646ab1340376e240d6c5af9cb (diff)
Test for fdo#74824.
The bug in question crashed LibO when inserting a group of cells. This bug was quashed, per se, by commit 07e2c31831ad265b018e5fdf59bdde048fbb4d35, but it occurs to me that at least the particular functionality of inserting a group of cells could use more testing. Change-Id: Icdbfff86fb0265eef325bcc94d9fc9f3e9e38413
Diffstat (limited to 'pyuno/qa')
-rw-r--r--pyuno/qa/pytests/insertremovecells.py85
-rw-r--r--pyuno/qa/pytests/testdocuments/fdo74824.odsbin0 -> 4811 bytes
2 files changed, 85 insertions, 0 deletions
diff --git a/pyuno/qa/pytests/insertremovecells.py b/pyuno/qa/pytests/insertremovecells.py
new file mode 100644
index 000000000000..4ce2707602bc
--- /dev/null
+++ b/pyuno/qa/pytests/insertremovecells.py
@@ -0,0 +1,85 @@
+import unittest
+
+from os import getenv, path
+
+try:
+ from urllib.parse import quote
+except ImportError:
+ from urllib import quote
+
+from org.libreoffice.unotest import pyuno, mkPropertyValue
+
+class InsertRemoveCells(unittest.TestCase):
+
+ @classmethod
+ def setUpClass(cls):
+ cls.xContext = pyuno.getComponentContext()
+ pyuno.experimentalExtraMagic()
+
+
+ # no need for a tearDown(cls) method.
+
+
+ def test_fdo74824_load(self):
+ ctxt = self.xContext
+ assert(ctxt)
+
+ smgr = ctxt.ServiceManager
+ desktop = smgr.createInstanceWithContext('com.sun.star.frame.Desktop', ctxt)
+ loadProps = tuple(mkPropertyValue(k, v) for (k, v) in (
+ ('Hidden', True),
+ ('ReadOnly', False)
+ ))
+ tdoc_dir = getenv('TDOC')
+ url = 'file://' + quote(path.join(tdoc_dir, 'fdo74824.ods'))
+ doc = desktop.loadComponentFromURL(url, "_blank", 0, loadProps)
+
+ sheet = doc.Sheets.Sheet1
+ area = sheet.getCellRangeByName( 'A2:B4' )
+ addr = area.getRangeAddress()
+
+ # 2 = intended to shift cells right, but I don't know where to find
+ # the ENUM to put in it's place. Corrections welcome.
+ sheet.insertCells( addr, 2 )
+
+ # basically, the insertCells call is the test: it should not crash
+ # LibreOffice. However, for completeness, we should test the cell
+ # contents as well.
+
+ empty_cells = (
+ (0, 0), (0, 1), (0, 2), (0, 3), (1, 0), (1, 1), (1, 2), (1, 3),
+ (3, 1), (4, 0), (4, 2), (5, 0), (5, 2), (5, 3),
+ )
+ formula_cells = (
+ (2, 0, '=(1+GDR)^-D1', '1.000', 1.0),
+ (4, 1, '=(1+GDR)^-F2', '0.125', 0.125),
+ (4, 3, '=SUM(C1:C2)', '1.000', 1.0),
+ )
+ value_cells = (
+ (2, 2, '2010', 2010.0),
+ (2, 3, '7', 7.0),
+ (3, 0, '0', 0),
+ (3, 2, '2012', 2012.0),
+ (3, 3, '6', 6.0),
+ (5, 1, '1', 1.0),
+ )
+ for pos in empty_cells:
+ cell = sheet.getCellByPosition(*pos)
+ self.assertEqual( 'EMPTY', cell.Type.value )
+ for x, y, f, s, val in formula_cells:
+ cell = sheet.getCellByPosition(x, y)
+ self.assertEqual( 'FORMULA', cell.Type.value )
+ self.assertEqual( f, cell.getFormula() )
+ self.assertEqual( s, cell.String )
+ self.assertEqual( val, cell.Value )
+ for x, y, s, val in value_cells:
+ cell = sheet.getCellByPosition(x, y)
+ self.assertEqual( s, cell.String )
+ self.assertEqual( val, cell.Value )
+
+ doc.close( True )
+
+
+if __name__ == '__main__':
+ unittest.main()
+
diff --git a/pyuno/qa/pytests/testdocuments/fdo74824.ods b/pyuno/qa/pytests/testdocuments/fdo74824.ods
new file mode 100644
index 000000000000..122bae22d9d4
--- /dev/null
+++ b/pyuno/qa/pytests/testdocuments/fdo74824.ods
Binary files differ