https://bugs.documentfoundation.org/show_bug.cgi?id=163554
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Eike Rathke <[email protected]> --- The exported formula in OOXML is SUM('time (pnrst)':'time (misc) - last'!A1:A1) and as such should be correct, would be =SUM('time (pnrst)':'time (misc) - last'!A1:A1) in Excel A1 notation, but is parsed back badly. Same if Formula syntax is switched to Excel A1. (In reply to Eric Wilson from comment #0) > Also opened in MS EXCEL and formula was incorrect. What does Excel do with it? > Sum shows as "0" - Does not show error even though formula is incorrect, > unless cell edited. For me the correct sums are displayed when opening the attached document. That is because results are not recalculated when opening .xlsx unless forced under Tools -> Options -> Calc -> Formula, after recalculation the #NAME? error is displayed. It works if the sheets are renamed to time1 and time2 so the single quotes aren't needed and the expression is =SUM(time1:time2!A1:A1) -- You are receiving this mail because: You are the assignee for the bug.
