- →
Check spelling of words in the worksheet.
- →
View or amend the special series of words recognized by Calligra Sheets. These list can be used to insert special series into the worksheet.
- →
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.
- →
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.
- → (Shift+F9)
Recalculate formulae in the current sheet.
- → (F9)
Recalculate all sheets.
- →
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 → submenu.
- →
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).
- →
Opens the Scripts Manager dialog to execute, load, unload, install, uninstall and get more scripts.
- →
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.