# 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