Saving your CSV files with Formulas

Whenever you are working with Formulas within Libre Calc or Excel, you will often want to save the formulas for reuse on other data sets. You can do this by going to File, Save As…, then saving the file as a ODS (OpenDocumentSpreadSheet) which is a universal file. You can also save as an XLSX file, but that with have some glitches between Excel and Cacl.

LibreOffice Calc


Microsoft Excel