Editing of matrix cells

Edit matrix screen look like this:

Changing matrix size

You can at any time increase/descrease number for columns and rows in the matrix.

Delete row by clicking on the red cross icon for that row.
Delete column by clicking on the red cross icon for that column.
Insert row by clicking on the green plus icon. The row will be inserted before the row where you clicked on the icon.
Insert column by clicking on the green plus icon. The column will be inserted before the row where you clicked on the icon.
User resize matrix feature. Set number of columns and rows you want and click on the Ok button. New rows/columns will be added and existing columns and rows will be deleted from the end of the matrix to match the requested size.
You can set number of visible rows for the matrix question. This is the number of matrix rows that will be displayed to the respondent. An expand button will be displayed in the bottom of the matrix. If respondent clicks the expland button, then the rest of the rows will be displayed. The expand button can be configured for each matrix.

After the respondent clicks the expand button:

Moving a cell

You can move position of the cell by one cell. Hold the mouse over the cell a couple of seconds and a little move cell window will appear. Click on the arrow to move the cell. NOTE: cells can be moved only within the same group type. For example you can't move cell of type Radio to a group of Checkboxes.

Changing a cell.

Click on the cell you want to change. A new window will open allowing you to enter the cell details. You can name the cell for better identification in the reports. The cell identifier is optional. You can also set background of the cell and a tooltip. The tooltip can have multiple lines and include html elements. Cells of type text, numeric, dropdown and checkbox can also have data variable names attached to them.

There can be 8 types of matrix cells:

Empty cell Empty cell can be used when the cell does not need to carry any visible element. Most of the cells are empty when you first create a matrix question. Click on the Empty cell-button and set the type from the dialog window that appear. Empty cells do not have an identifier and background color.
Text Cell of type text allows respondents to enter any text in the field. "Field size" is the visible length of the fields, in characters.

Validation: Validate/check the answer from the respondent. It can be used to demand a specific type or length of answer from the respondent and set the appropriate error message if these requirements are not met.
Numeric Cell of type numeric restricting the answer to a number only. Select this type if you need calculations on the report (type text will only produce a comment listing). Numeric types available are integer or decimal.

Formula: If a formula is entered for a numeric cell, a calculation will be performed as the respondent enters numeric values in other cells in a matrix question, which can either be the same question, or another matrix question within the survey. The resulting value from the calculation will be placed in the cell containing the formula. The result will also be saved as part of the survey response, as if the respondent typed in the answer for the cell. The cell containing the formula will not be editable by the respondent; it will be a calculation-only field.

A formula supports basic arithmetic calculations (+, -, * and /), as well as sum() and avg() functions. Sums and averages are written in the form "sum(A4:A7)" and "avg(B2:C24)".

In a formula, you refer to other cells in a similar manner as spreadsheets (MS Excel, OpenOffice Calc, etc). The values from these cells will be included in the calculation of the formula. A cell is referenced as A1, A2, B1 etc., if it is within the same matrix question where the cell containing the formula lies, or as Q2!A1, Q2!A2, Q2!B1 etc., if it is from another matrix question. If the cell reference is Q2!A1, the cell you are referencing is question 2, column A, row 1. You can also include numbers directly in the formula. The starting and ending cells in the sum() and avg() functions should be from the same question.

Formula examples:
```
        A7 + B1 + B2
        
        Q2!A3 + Q6!B5 * Q8!E7
        
        Q6!C3 + sum(C4:C10) + avg(Q8!D5:Q8!E10)
        
        avg(A1:A19) + 50
        
        C7 + Q2!D20/sum(Q6!F2:Q6!F10) - (20*Q8!G10)
                                                                        
```
Circular references are not allowed. For instance, in cell A1, you can not write a formula that includes A1 in it. The circularity is also checked across multiple questions, cells and formulas. Another example, is Q4!A1 contains formula "A2+Q6!B2". Then cell Q6!B2 contains the formula "sum(Q4!A1:Q4!B6)". This is also a circular reference, and is invalid.

NOTE: Use numeric type only for numbers you want statistic analysis for. For input like telephone numbers, credit cards and country zip codes, text type is recommended.

Validation: Use this to set restrictions for answers and error messages for invalid numbers, required input, and min/max values.
Dropdown Cell of type dropdown list are exactly the same as the usual dropdown list for the question types, except it can only have a single selection. You can either create a dropdown list directly, or create and load from the bank if you are to use it again later. See dropdown list question for more details.
Checkbox. The checkbox simply inserts a checkbox for your respondents to check. This is a true/false type answer.
Radio button. Radio buttons can only be used/defined if it is grouped with other cells. See Cell groups below.
Label. Text to be displayed in the cell.
Image. Set image to be displayed in the cell. See the section called “Images”