The Tools Menu

ToolsSpelling...

Check spelling of words in the worksheet.

ToolsCustom Lists...

View or amend the special series of words recognized by Calligra Sheets. These list can be used to insert special series into the worksheet.

ToolsProtect Sheet...

Protect the sheet with a password. A dialog pops up prompting you for a password. Unchecking this option will prompt you for the password in order to unprotect the sheet. Protecting a sheet means protecting all cells in the sheet. In a protected sheet, the cells cannot be reformatted or overwritten.

ToolsProtect Document...

Protect the whole document with a password. A dialog pops up prompting you for a password. Unchecking this option will prompt you for the password in order to unprotect the document. In a protected document you cannot rename or remove a sheet. Document protection does not mean that each individual sheet is protected.

ToolsRecalculate Sheet (Shift+F9)

Recalculate formulae in the current sheet.

ToolsRecalculate Document (F9)

Recalculate all sheets.

ToolsExecute Script File...

Execute the chosen external script in Calligra Sheets. Calligra Sheets supports scripting in JavaScript, Python and Ruby. Default examples of the scripts can be found in the ToolsScripts submenu.

ToolsScripts

Here you can execute the script to export or import data in various formats, save your Calligra Sheets log into file, use Orca speech for accessibility, debug Python and Ruby scripts or add functions to display stock or weather condition values. You can even use some R functions (RPy module should be installed).

ToolsScript Manager...

Opens the Scripts Manager dialog to execute, load, unload, install, uninstall and get more scripts.

ToolsFunction Optimizer...

Opens the Function Optimizer dialog where you can choose an objective function cell, optimization target (Maximize, Minimize or enter the Value) and a set of decision parameter cells.