Calculation is the process of calculating formulas and then displaying the values of the results in cells.
By default, formulas in the document are recalculated automatically in the following cases:
–When you open a document with outdated formula values.
–When you change values in cells used in any formulas.
–When you enter a formula in an empty cell or in a cell that contains a value.
–When you insert or delete a row.
–When you insert or delete cells with a shift.
If there are a large number of formulas in a document, their automatic recalculation can make opening and working with the document difficult. In order to speed up work with such documents, MyOffice Spreadsheet provides a manual formula recalculation mode, where recalculation is performed at the user's request.
In manual formula recalculation mode:
–When you open a document and change the associated cells, no formulas are automatically recalculated.
–When you work with a document, formulas are recalculated only when you carry out manual operations on the cells that contain them.
–Manual recalculation of outdated formula values is available in the entire document, on the sheet, and in selected cells.
–When saving a document, recalculation of outdated formula values is performed only if the Before saving checkbox is selected.
Outdated values in formulas are irrelevant data that were previously calculated but are no longer relevant. They may occur as a result of data entry errors, errors in formulas and functions, data type mismatches, changes in table structure, errors in macros, or synchronization problems. MyOffice Spreadsheet stores information about the presence of such cells within the file itself.