https://bugs.documentfoundation.org/show_bug.cgi?id=144252
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |filter:xlsx CC| |[email protected] --- Comment #5 from ady <[email protected]> --- This is still repro in a recent LO Dev 24.2. Simplified case: * In ODS and XLS: =SUM($'1'.D5:$'3'.D5) * But saved as xlsx: =SUM('1':$'3'.D5:D5) Notes for XLSX format (ODS and XLS are OK): * Hard Recalculate results in #NAME? error for the formula. * The initial worksheet in the formula lacks absolute worksheet reference ($). * The range separator (:) is present twice in the formula; once for the worksheets and once for the cells (range). I think there is some other bug report describing a similar behavior (but I don't recall whether it was also regarding 3D ranges / functions). Maybe Eike Rathke does recall such report(?). CC'ing. FWIW, FTR and JIC (including Sheet Naming Restrictions): https://help.libreoffice.org/latest/en-US/text/scalc/guide/rename_table.html -- You are receiving this mail because: You are the assignee for the bug.
