https://bugs.documentfoundation.org/show_bug.cgi?id=173668
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #15 from Regina Henschel <[email protected]> --- (In reply to ady from comment #12) > For Strict (i.e. second argument equivalent to "1"), ARRAYTOTEXT() should > use the settings in menu Tools > Options > Calc > Formula > Separators ... That generates the problem, that the resulted text is not compatible with Excel. That means, that a function that has the result of ARRAYTOTEXT() as input, will give different results than in Excel. I personally like the flexibility of LibreOffice. I use the same delimiters as specified for the ODF file format, which is ; between columns and a | between rows. However, we need to find a way be compatible with Excel. -- You are receiving this mail because: You are the assignee for the bug.
