You can create a pivot table from this menu and look at statistics. It allows you to apply various filters to the data in the cells. This menu allows you to sort data in selected columns. You also can add comments to a cell and perform other functions. You can perform various macros on a sheet that are listed in the Assign Action. You also can connect to external files and sheets. It also allows you to perform various functions on the Sheet, such as renaming it or adding another one. This allows you to add columns and rows or delete them.

The two unique menus that Calc has are Sheet and Data. Help: This gives you access articles about the different features of the LibreOffice suite and Calc.Window: This allows you to see which documents are open and allows you to select that document, so you can work on it.It also has items to protect cells and perform macros. These include spellcheck and grammar check. Tools: This menu gives you access to spelling, grammar, and language tools.Data: This menu has items to sort, calculate, and filter data in cells.All of its items also can be found in toolbars, the sidebar, and context (right-click) menus. Sheet: In this menu, you can insert or delete cells, columns, rows, and sheets.Format: This includes items to format rows, columns, sheets, and images.Insert: The items here include ones to insert images, charts, and shapes.View: The items in this menu include ones that allow you to open each one of the toolbars, open or close the sidebar, open and close the navigator, and access the data sources.It has items to search and replace text in a document. Edit: The menu has items to copy, cut, and paste text and other items.File: This menu contains items to create a new document, save a document, access remote servers, to access templates and wizards, and print a document.Sheet and Data are the menus that are unique to Calc. Each application has different items in the menus they have in common with other applications. Most of these menus can be found in Writer and Impress as well. The menu bar has the following items in it.

Libra spreadsheet