Description: For example, a Sheet1 cell A1 content is '=+Sheet2.A2', after saving the spreadsheet in xlsx extension, when I open it, the Sheet1.A1 content is now '=+$Sheet2.A2. A '$' appears in front off any Sheet name. When I save it in 'ods' extension, it does not happen. Steps to Reproduce: 1.At Sheet1.A1 cell, type +Sheet2.A2 2.Save As a xlsx type file. 3.Close spreadsheet. 4.Open spreadsheet and look at cell Sheet1.A1 content. Actual Results: At step 1, cell content is '=+Sheet2.A2'. At step 4, cell content is '=+$Sheet2.A2'. Expected Results: The expected result is '=+Sheet2.A2'. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.6.6.3 (X86_64) / LibreOffice Community Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7 CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: pt-BR (pt_BR); UI: pt-BR Calc: CL threaded
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>.
Actually, I can replicate the behavior, but I am not sure why it is happening. Setting as NEW for now.
Sorry, I misspoke. This behaves as expected, as I wrote in comment 1. NAB.