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

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |WONTFIX

--- Comment #10 from Eike Rathke  ---
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- 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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #9 from Buovjaga  ---
(In reply to Luuk from comment #8)
> "LibreOffice now accepts English format codes in the few locales ..."
> 
> It should also tak info account this info when creating an export.
> 
> The export format is not 'defined' by LibreOffice, but in this case by
> someone else, so LO should follow that definition, and not it's own.

How should this be taken into account? Please give concrete details. Such as
"When saving as XLSX, change format codes to match locale" or "When saving in
any file format, change format codes to match locale".

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Luuk  changed:

   What|Removed |Added

 Status|CLOSED  |REOPENED
 Resolution|NOTOURBUG   |---

--- Comment #8 from Luuk  ---
"LibreOffice now accepts English format codes in the few locales ..."

It should also tak info account this info when creating an export.

The export format is not 'defined' by LibreOffice, but in this case by someone
else, so LO should follow that definition, and not it's own.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |NOTOURBUG

--- Comment #7 from Eike Rathke  ---
LibreOffice now accepts English format codes in the few locales that use
localized format codes so that a document using the TEXT() function can be
loaded in different locales. There's nothing we can do about other products if
they expect and only accept a localized format code.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Thomas Lendo  changed:

   What|Removed |Added

 Blocks||107575


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=107575
[Bug 107575] [META] Number format bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW
 OS|Windows (All)   |All

--- Comment #6 from Buovjaga  ---
NEW per Xavier's confirmation.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #5 from Luuk  ---
Created attachment 140677
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140677=edit
ODS sample

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #4 from Buovjaga  ---
(In reply to Xavier Van Wijmeersch from comment #3)
> Created attachment 140675 [details]
> formatting date with different locale's

Can you include an ODS?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #3 from Xavier Van Wijmeersch  ---
Created attachment 140675
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140675=edit
formatting date with different locale's

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

--- Comment #2 from Xavier Van Wijmeersch  ---
With LO and Gnumeric there is no problem to open the file saved as xlsx with
the two different formatting's. But with AOO it is and maybe also with exel.

Version: 6.1.0.0.alpha0+
Build ID: 953a5cb1c8c750df24ed0316349a5916c384296d
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||todven...@suomi24.fi
 Ever confirmed|0   |1

--- Comment #1 from Buovjaga  ---
I don't understand how to repro, so please attach an example ODS.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs