diff options
author | Kevin Hunter <hunteke@earlham.edu> | 2014-02-16 22:12:27 -0500 |
---|---|---|
committer | Stephan Bergmann <sbergman@redhat.com> | 2014-02-20 12:01:34 +0100 |
commit | f2471280c7c625e39369f76bd0efa1d2402f62bf (patch) | |
tree | 80e2fb2e19ae3d85f75d72660a8cca51cfe16cee /pyuno/qa | |
parent | A rudimentary framework for additional Python tests not run by default (diff) | |
download | core-f2471280c7c625e39369f76bd0efa1d2402f62bf.tar.gz core-f2471280c7c625e39369f76bd0efa1d2402f62bf.zip |
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.py | 85 | ||||
-rw-r--r-- | pyuno/qa/pytests/testdocuments/fdo74824.ods | bin | 0 -> 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 Binary files differnew file mode 100644 index 000000000000..122bae22d9d4 --- /dev/null +++ b/pyuno/qa/pytests/testdocuments/fdo74824.ods |