https://bugs.documentfoundation.org/show_bug.cgi?id=93973
Wolfgang Jäger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Wolfgang Jäger <[email protected]> --- LibreOffice might be specified not to recognise any formulas imported from a text file as unformatteed text or opening of a csv. But (Check again, please, Jean-Batiste): {=MATCH(1;ISERROR(A3:A8);0)} as given in the report here is handled inconsistently whether pasted special as unformatted text with Ctrl+Shift+V copied from a text file or directly entered from the keyboard or contained in a csv file that was opened with Calc. It is treated as a text with 28 characters in its cell. It is edited as a formula of 26 characters without the curly brackets if edit mode is entered, and this in the formula bar and in the cell as well. The range contained also is highlighted then by a border as if a formula is edited. Leaving edit mode, however will not make it a working formula but simply restore the curly brackets. Please note again: The ordinary formulas imported enclosed in "text delimiters" from csv are recognised as formulas and evaluated as such from the beginning! They are not treated as text! This is inconsistent! I would suggest to change the subject of this bug into "Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets." Fixing the issue might, however, require to accept a pair of curly brackets around a formula as an alternative to the special key-grip Ctrl+Shift+Enter, and at the same time to not allow texts matching the pattern {=SomeThing}. This in the line with other strings starting with = or, alas, with - or + in specific cases. -- 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
