https://bugs.documentfoundation.org/show_bug.cgi?id=144252
--- Comment #6 from Eike Rathke <[email protected]> --- Fwiw, in test.xlsx for B3 the formula is saved as <c r="B3" s="1" t="e"> <f aca="false">SUM('1':'10'!B3:B3)</f> <v>#NAME?</v> </c> and apparently it was resaved after having been loaded and recalculated faulty already (#NAME? error as value); not containing the $ absolute reference flag is ok, as Excel does not know relative sheet references at all and sheet references are always absolute. Saving =SUM($'1'.B3:$'3'.B3) to .xlsx results in SUM('1':'10'!B3:B3) as well so that part seems ok and import as =SUM('1':$'10'.B3:B3) is broken. -- You are receiving this mail because: You are the assignee for the bug.
