https://bugs.documentfoundation.org/show_bug.cgi?id=92256
--- Comment #15 from Christoph Lutz <[email protected]> --- Thanks bubli, for this summary. I abbreviate "formula syntax for string references" as FSFSR my +1 for 1a, 1b, 2a and 3 this also means that we have no longer a global FSFSR-setting, because this setting is always derived from a document by some logics (read explicit setting if present, heuristics for documents without explicit setting) regarding 2b and 4: I think an alternative solution for Export to excel could be to treat xls(x) documents always as FSFSR=EXCEL A1, in both directions, import and export. This would also de facto prevent the users from storing documents with FSFSR=CALC A1 to xls(x): 0) let's asume I have got a spreadsheet with Indirect-Functions that uses strings in calc syntax. If this document is stored to xls(x), then the following things happen: 1) I get the typical "would you really like to export to an alien format" dialog 2) FSFSR is automatically switched to EXCEL. 3) Now some formulars in the document are no longer evaluated as (possibly) expected. The user is forced to change the syntax of the strings in order to make the document running with EXCEL syntax evaluation. 4) if the file is stored for a second time, it is also interoperable with MS Excel. With this idea, I would not store any settings to xls(x) documents, because it is automatically fixed to EXCEL. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
