| Summary: | [FILESAVE]: changes format of date in cell from DD.MM.YY to MM.DD.YY with save file to .XLSX | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Roman Kuznetsov <79045_79045> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | aron.budea, erack, filippo.caimi, fixer5, himajin100000, jan.rysavy, j.behrendt, mikekaganski, mitja.masten, ooo, suokunlong |
| Priority: | medium | Keywords: | bibisected, bisected, regression |
| Version: | 5.4.0.0.alpha0+ | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:6.0.0 target:5.4.4 target:6.2.0 target:6.1.1 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | example of XLSX with changed format of date in cell | ||
|
Description
Roman Kuznetsov
2017-11-16 20:39:44 UTC
Created attachment 137817 [details]
example of XLSX with changed format of date in cell
That was the fix for bug 107012 to have correct date order when converting between locales ... For Excel the format is needed in en-US locale context (where date order is MDY) but Excel does not handle the date particle order for the target locale. Only thing we can do is ignore change of date order when converting for Excel export. Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=eb8bd7f21103ed2349b44c954db977709de2e4ec Resolves: tdf#113889 no date particle reordering when exporting to Excel It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Pending review https://gerrit.libreoffice.org/44841 for 5-4 Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=985523eee724f41eefb3aa84edcfcd1a4a3cf3db&h=libreoffice-5-4 Resolves: tdf#113889 no date particle reordering when exporting to Excel It will be available in 5.4.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. *** Bug 114195 has been marked as a duplicate of this bug. *** . *** Bug 114627 has been marked as a duplicate of this bug. *** *** Bug 114551 has been marked as a duplicate of this bug. *** *** Bug 112428 has been marked as a duplicate of this bug. *** *** Bug 119013 has been marked as a duplicate of this bug. *** Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0281aa380a20672d55d1d672fd4a43bdcb6c224d One more "do not reorder date particles", tdf#113889 tdf#119013 follow-up It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=11936b405094cf4a4b1c95b8cbf8e1f2c2bcad05&h=libreoffice-6-1 One more "do not reorder date particles", tdf#113889 tdf#119013 follow-up It will be available in 6.1.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. *** Bug 112159 has been marked as a duplicate of this bug. *** |