Ask Your Question

Revision history [back]

Calc and Excel use different separators and different syntax for addressing files.

Just two short examples:

=Sheet1!D23 is the Excel syntax for addressing a cell in another sheet =Sheet1.B14 is it in Calc

='Untitled1'#$Sheet1.$B$14 is the calc syntax to reference a cell in another file =[Book1]Sheet2!$F$17 is it in Excel

Please also note that all special character from CalcA1, ExcelA1 and ExcelR1C1 are forbidden in names.