Getting started

LibreOffice Calc not working: fixing formulas, files and crashes

LibreOffice Calc not working? Fix formulas showing as text, numbers stored as text, wrong separators and files that will not open, with the formulas to use.

Editorial illustration for LibreOffice Calc not working: fixing formulas, files and crashes

If LibreOffice Calc is not working, find out which of these four you have: the program will not start, a file will not open, a formula shows as text, or a formula gives the wrong answer. Each has a short fix. The most common spreadsheet complaints are really data problems, such as numbers stored as text, not software faults.

A formula shows as text instead of a result

If you see =SUM(B2:B10) in the cell instead of a number, the cell was formatted as Text before you typed. Change the cell format to General, then click in the cell and press Enter again. Also check that the formula does not start with a space or an apostrophe.

The sum is zero or too small

This usually means your numbers are text. Amounts copied from a bank PDF or a web page often carry commas, spaces or a currency symbol. Calc left-aligns them by default. Test it with a new cell: =ISNUMBER(C2) returns FALSE for text.

To clean a column, put this in D2 and fill down:

  • =VALUE(SUBSTITUTE(C2,",",""))
  • =VALUE(SUBSTITUTE(SUBSTITUTE(C2,"₹",""),",",""))

Say C2:C4 hold the text 1,250 and 850 and 2,400. Summed as text they give 0. After cleaning, they give 1250 + 850 + 2400 = 4,500. Then copy the cleaned column and paste it back as values.

Why does my formula give an error about a separator?

Depending on your language and region settings, Calc may expect a semicolon between function arguments instead of a comma. For example, =SUMIF($B$2:$B$200;"Food";$C$2:$C$200) in one setup is =SUMIF($B$2:$B$200,"Food",$C$2:$C$200) in another. If a formula pasted from a website returns an error, try swapping the separator. The formula options in the program's settings show which one is active.

SymptomLikely causeFix
Formula visible as textCell format is TextSet to General, re-enter
SUM gives 0Numbers stored as textVALUE and SUBSTITUTE
Error on pasted formulaArgument separatorSwap comma and semicolon
Dates sort wronglyDates are textConvert with DATEVALUE
File will not openDamaged file or old versionOpen a backup, update the program

What about dates that sort the wrong way?

If 01/02/2026 and 15/01/2026 sort strangely, the dates are probably text. Test with =ISNUMBER(A2): FALSE means text. For a column of dates written day first, split the parts and rebuild them with DATE: =DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2)). This works on text such as 15/01/2026 and returns a real date that sorts and filters correctly. Format the result as a date, then copy and paste it back as values.

The program freezes or a file will not open

  1. Look for a recovery prompt when you restart; accept it and save the recovered file under a new name.
  2. Copy the original file before any experiment.
  3. Update to the current stable version.
  4. Try opening the file with a different spreadsheet program to check it is not damaged.
  5. If a macro or a huge range is slowing it, test on a copy with the extra sheets removed.

When a sheet stops being enough

A tidy sheet with SUMIF and a category column handles a lot. When you spend more time cleaning bank files than reading your spending, SpendixAI is an alternative: you upload the statement as PDF, CSV or Excel, review rows before saving, and use categories and reports without writing formulas. The sheet remains useful for one-off calculations.

Checklist

  • Is the cell General, not Text?
  • Are numbers stored as numbers?
  • Is the separator right for your setup?
  • Is there a recent backup copy?
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports