https://bugs.documentfoundation.org/show_bug.cgi?id=152805
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Hardware|x86-64 (AMD64) |All See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=92 | |256 Summary|indirekt() works |'Calc A1 | Excel A1' syntax |incorrectly after Excel |is used when opening XLSX, |import |but 'Excel A1' when | |creating files from XLTX Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 OS|Windows (All) |All --- Comment #5 from Mike Kaganski <[email protected]> --- Aha. No, it doesn't "work incorrectly", and also, despite the original claim that it happens after "import from an xlsx", the described behavior occurs after creation from an *XLTX*. In version 5.1, a new string reference syntax was introduced: "Calc A1 | Excel A1", available under Options->Calc->Formula->Detailed Calculation Syntax->Details (tdf#92256). It allows using mixed Calc / Excel string references in a single spreadsheet; and it is used by default now, when one opens XLSX files. (It re-introduced what was used in old OOo versions without any specific syntax.) However, when creating files from an XLTX, the older (and stricter) "Excel A1" string reference mode is still used. It disallows the Calc-style string references. *Possibly* using "Calc A1 | Excel A1" here would also be reasonable, because Excel syntax could be used in pre-existing formulas coming from XLTX, and Calc syntax could be expected by users in the new documents ... but OTOH, this mixed mode is not ideal anyway. Documents containing such mixed syntax would fail when opened in Excel, so would not be interoperable. Why do you expect the mixed mode? IMO, you either should use ODS and its syntax (Calc A1), or you would need interoperability, and then use Excel A1 syntax - but not both. And thus, I'd say this is not a bug, and this behavior is better than more liberal mixed mode, requiring user to decide on the syntax explicitly if they intend to use Calc syntax when they use Excel templates (wouldn't users better use OTS templates in this case?). As for the space in the sheet name, the standards require that names containing special characters be enclosed into single quotes; so the proper reference would be =INDIRECT("'test Mittwoch'!A1") -- You are receiving this mail because: You are the assignee for the bug.
