Spreadsheet Editor - Working with Functions

Table of Contents

Formula Bar

The formula bar is a text box on top of the sheet area. It displays the formula of the current cell as well as allows the user to edit it.

How does it work?

When a cell is selected, the formula bar is synchronized with the cell and the formula is displayed. The user is allowed to edit. When the user edits and presses the Enter key, the JavaScript function saveFormulaBarContents is executed

saveFormulaBarContents

 function saveFormulaBarContents() {

    var newContents = PF('formulaBar').jq.val();

    $(sheet_datatable.selectedCell).find('.ui-cell-editor-input input').val(newContents);

    sheet_datatable.saveCell($(sheet_datatable.selectedCell));

    return false;

}

Insert a Function

To insert a function or formula:

  1. Click a cell to select it.
  2. Click the Insert Function button at the top.
  3. Follow the instructions on the Insert Function dialog.
Spreadsheet Editor - Components