https://bugs.documentfoundation.org/show_bug.cgi?id=160720
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from ady <[email protected]> --- XLSX does not support relative references for worksheets; only absolute references to worksheets are supported in XLS(X). In ODS, "$Sheet2.A2" is an absolute reference to the worksheet named "Sheet2", and within it, a relative reference to cell "A2". Without the "$" in the ODS file, the reference to the worksheet is relative, not absolute. This relative reference to a worksheet cannot be exported to XLS(X), because those other file formats do not support it. This is not a bug. Please next time ask your question at <https://ask.libreoffice.org>. -- You are receiving this mail because: You are the assignee for the bug.
