Testname: Enhanced Formula Input

Document Owner:

Frank Stecher

Last document change:

28.09.2007

Status of document:

Preliminary



Valid for version: StarOffice8 PP10

Test purpose:

Make sure the new enhanced formula input works as specified


Known issues:


Preconditions of test:


Test documents:

-


Testcases:


Values (or Calculator)

Status: Preliminary

-


  • Download and open the test document named Enhanced_Formula_input.ods

  • Make sure the Sheet Numbers is active and the cell cursor is placed on B3

  • Type +1 into B3

  • Type -15 into B4

  • Type +-24.7 into B5

  • Type +8*8 into B6

  • Type -9/2 into B7

  • Type +1e3-999 into B8

  • Type +1/4+6/8 into B9

  • Type --70 into B10

  • Compare A3:A10 with the values shown in B3:B10, any difference ? If so, file an Issue.

  • Does the background color for C3:C10 changed from Grey to Green ? If not, file an Issue for the corresponding typed in values.


  • Type *1+2 into B14

  • Type /2+9 into B15

  • Type +5+6+ into B16 (Do not accept the correction dialog, click on No)

  • Type ++42 into B17

  • Type +-+62 into B18

  • Type +into B19 and delete the Autoinput value

  • Type - into B20

  • Type ++ into B21

  • Type -- into B22

  • Type +-+ into B23

  • Compare A14:A23 with the values shown in B14:B23, any difference ? If so, file an Issue.

  • Does the background color for C14:C23 changed from Grey to Green ? If not, file an Issue for the corresponding typed in values.


References

Status: Preliminary

-


  • Download and open the test document named Enhanced_Formula_input.ods

  • Make sure the Sheet References is active and the cell cursor is placed on B3

  • Type + and Cursor right, leave the cell by pressing Enter.

  • Type -16+ and Cursor right, leave the cell by pressing Enter.

  • Type + and Cursor right * Cursor up and Cursor down, leave the cell by pressing Enter.

  • Type - 9 * Cursor right + 4 - Cursor up, leave the cell by pressing Enter.

  • Type + ( 69 * Cursor right and ), leave the cell by pressing Enter.

  • Type + 8 ( and cursor right and ) Confirm the Messagebox with no, leave the cell by pressing Enter.

  • Type - Cursor right  / - ( Cursor up Cursor up + 8 ), leave the cell by pressing Enter.

  • Type - Cursor right  / ( - Cursor up Cursor up + 8 ), leave the cell by pressing Enter.

  • Compare B3:B10 with the Values shown in A3:A10, any difference ? If so, file an Issue.

  • Does the background color for D3:D10 changed from Grey to Green ? If not, file an Issue for the corresponding typed in values.


Formulas and Functions

Status: Preliminary

-


  • Download and open the test document named Enhanced_Formula_input.ods

  • Make sure the Sheet Functions is active and the cell cursor is placed on B3

  • Type + MAX( cursor right and 2 times SHIFT Cursor down and ) return

  • Type - AVERAGE(C3:C5) return

  • Type -(- cursor up / cursor right ) + 1.5 * MAX( cursor down and 2 times SHIFT Cursor up ) return

  • Compare B3:B5 with the Values shown in A3:A5, any difference ? If so, file an Issue.

  • Does the background color for D3:D5 changed from Grey to Green ? If not, file an Issue for the corresponding typed in values.


References:

-


Acronyms:

-


testcase specification history

Enhanced Formula Input

Date

Change

User

28.09.2007 (11:50:02)

testcase details added

Frank Stecher

25.09.2007 (17:03:57)

testcase details updated

Frank Stecher

25.09.2007 (16:57:54)

testcase details added

Frank Stecher

21.09.2007 (15:43:33)

header updated

Frank Stecher

21.09.2007 (15:24:50)

testcase :References updated

Frank Stecher

21.09.2007

Testcase specification created

Frank Stecher