https://bugs.documentfoundation.org/show_bug.cgi?id=92256
--- Comment #7 from Christoph Lutz <chrl...@googlemail.com> --- (In reply to m.a.riosv from comment #6) > I'm not sure if the actual implementation is following ODF specification for > INDIRECT(). > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2. > html#__RefHeading__1018426_715980110 Interesting question. Is this requirement met? "For interoperability, if the Ref text includes a sheet name, evaluators should be able to parse both, the “.” dot and the “!” exclamation mark, as the sheet name separator." Both variants can be evaluated in the current version, but not at the same time. But the spec doesn't say "at the same time". I think, "at the same time" is an implicit requirement. You cannot force the user to switch between different notation settings. We distinguish experienced users and "normal" users (I think you all know what I mean). Maybe an experienced user is able to do that, but not a "normal" user. And since these documents must work for experienced and "normal" users, it is clear to me, that manual switching is not an option. What are the alternatives? 1) Change back logic to evaluates both variants at the same time? --> see Eikes concerns regarding potential feature loss in case of export to Excel. 2) Introduce another option "Calc A1 | Excel A1" which evaluates both variants at the same time. This option could be default in munich then (I don't say that this needs to be default for LO generally) In both cases 1) and 2) we optionally try to recognize potential feature loss during Excel-export and warn the user. We could for example show a popup warning message and link to some help texts that describe how to avoid feature loss. 3) Don't evaluate both variants at the same time, but switch the syntax-format automatically. Indicators could be: * If it is an Excel-Document (.xlsx, .xls), set "Excel A1" * In case of ODS-Documents, read setting from a new (LO specific) metadata-flag or fallback to default "Calc A1" We could then add the ability to write this (LO specific) metadata-flag according to the current formular-syntax setting in tools->options (on save) This way would it make easy to "repair" ods-documents with Excel syntax that were created by OOo. The Instructions for repairing could be: open the document, switch the syntax setting and save it back. What do you think about these ideas? -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs