Ask Your Question

Revision history [back]

The problem is on the Input sheet. The cells C43, C50, C57, C64 contain strings which represent eferences to another sheet's cells (CC!A1, CC!A10, CC!A6, CC!A6). The syntax of the strings is Excel's.

(If my employee would create such a worksheet, I'd make them to redo it from scratch.)

LO uses another syntax by default: like CC.A1 (notice dot instead of exclamation). You may change it on Tools>Options>LibreOffice Calc>Formula>Custom>Details.... Be prepared for other problems though.