SpreadJS 14
Features / Formulas / Show Cell Formulas
In This Topic
    Show Cell Formulas
    In This Topic

    Users can view all the formulas in the cells and easily copy and paste these formulas between cells in a spreadsheet. SpreadJS provides showFormulas property, which enables the user to see the formula in a cell. Once the formula is visible, it can be copied and pasted in any application.

    Using Code

    This example sets the options.showFormulas property.

    JavaScript
    Copy Code
    // set showFormulas to true to enable users copy the formulas into other application
    activeSheet.options.showFormulas = true;
    

    Limitations