[Libreoffice-bugs] [Bug 116450] CONVERSION FORMAT DATE

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116450

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
The format code passed to the TEXT() function is a string, which can be
constant or made up of function calls or concatenations. It is user data. There
is no solution to "consider / take into account during export". It isn't known
in which environment the file will be opened next. Also, other applications may
not have the feature that the format code is tried to be interpreted with the
locale set as number format locale, so a localized format code may or may not
work. Use of the TEXT() function in different locales is fragile.

The attached document btw works only in one locale, the cell's B3 locale is
Default and not set to Dutch, so when recalculated it displays 17-03-JJJJ in an
en-US locale.

It doesn't help to reopen this. Unless someone comes up with a .xlsx document
created by Excel that works for all locales I'm closing this again.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180326/8ca91cbd/attachment.html>