Skip to content

You are not logged in. Register orLog In

start:

OpenOffice.org - Testcase specification

Testname: Array constants

Document Owner:

Oliver Craemer

Last document change:

21.11.2007

Status of document:

Standard

Valid for version: OpenOffice.org_2.3, OpenOffice.org_2.3.1, OpenOffice.org_2.4, OpenOffice.org_3.0, OpenOffice.org_3.1, OO, OpenOffice.org_3.2

Test purpose:

Test for verifiing the support of inline matrix/array constants in formulas

Known issues:

Preconditions of test:

none

Test documents:

http://www.openoffice.org/nonav/issues/showattachment.cgi/49796/arrayconstants.xls

Testcases:

Array constants in formulasStatus: Standard
Open new spreadsheet document
In cell A1 enter "={1;2;3}"
Check that the cellvalue is "1"

In cell A2 enter "={1;2;3|4;5;6}"
Check that the cellvalue is "1"

In cell A3 enter "={0;1;2|False;TRUE;"two"}"
Check that the cellvalue is "0"

Multiselect cells A4:C4, type "=sin({1;2;3})" and press <ctrl shift enter>
Check that the cellvalue  of A4 is "0.84"
Check that the cell contents of B4 is "0.91"
Check that the cell contents of C4 is "0.14"

In cell A5 enter "={1;2|4;5;6}"
Check that the cellvalue is "ERR:512"

In cell A6 enter "={1;2+3}"
Check that the cellvalue is "ERR:512"

In cell A7 enter "={1;2;{3;4;5}}"
Check that the cellvalue is "ERR:533"

In Cell A8 enter "={-1;2;3}"
Check that the cellvalue is "-1"

Save, close and reload the document
Check that all cellvalues are the same as before.
XLS Import/Export of array constantsStatus: Standard
Load xls testdocument

Check that the cell contents of B4 is 1
Check that the cell contents of C5 is 4
Check that the editline shows "={1;2|3;4}" for cell B4

Check that the cell contents of B8 is 10
Check that the editline for cell B8 is "=SUM({1;2|3;4})"

Check that the cell contents of B11 is -2
Check that the editline for cell B11 is "=MDETERM({1;2|3;4})"

Check that the cell contents of B14 is 1
Check that the editline for cell B11 is "{=name}"

Save the document to xls, close and reload
Check that all cellvalues are the same as before

References:

-

Acronyms:

-

testcase specification history

Array constants

DateChangeUser
21.11.2007 (15:48:27)status updatedFrank Stecher
21.11.2007 (15:48:15)status updatedFrank Stecher
21.11.2007 (15:48:08)testcase :XLS Import/Export of array constants updatedFrank Stecher
16.10.2007 (16:36:37)status updatedFrank Stecher
16.10.2007 (16:32:04)testcase details updatedFrank Stecher
13.06.2007 (09:43:48)status updatedOliver Craemer
13.06.2007 (09:43:32)status updatedOliver Craemer
13.06.2007 (09:42:53)testcase details updatedOliver Craemer
13.06.2007 (09:42:20)testcase details updatedOliver Craemer
13.06.2007 (09:37:07)testcase details addedOliver Craemer
13.06.2007 (09:28:07)testcase addedOliver Craemer
13.06.2007 (09:26:04)testcase details addedOliver Craemer
13.06.2007 (09:11:01)testcase addedOliver Craemer
06.06.2007Testcase specification createdOliver Craemer


06.11.09 12:11:09