It took me forever to learn that Calc refers to cells in other sheets like SheetName.CellNumber while Excel and Google Sheets use SheetName!CellNumber and I just thought either LibreOffice was broken or I was always doing something else wrong.