[Libreoffice-bugs] [Bug 132106] CELL() function "format" should include more date formats to return "D1" (or a new "D0")
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #16 from Eike Rathke --- (In reply to peter.hyatt from comment #15) > I'm not entirely sure if its related, but when I open a Excel document that > dropped in `[$-en-US]` prefixes to the number values, especially date > formats, it doesn't get read properly by Calc. Is this issue close enough? > Or should I open a new issue about the problems with using the format > prefixes in Calc? That's something completely different. If that really is the case then at some point Excel (which version anyway?) may have started to write a language tag instead of a numeric LCID as locale designator. Or it's some broken piece of software that writes to an Excel file format. That's simply not implemented (and probably not even specified in any standard) and should get a distinct RFE bug if that is really a MS-Excel thing. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132106] CELL() function "format" should include more date formats to return "D1" (or a new "D0")
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #15 from peter.hy...@gmail.com --- I'm not entirely sure if its related, but when I open a Excel document that dropped in `[$-en-US]` prefixes to the number values, especially date formats, it doesn't get read properly by Calc. Is this issue close enough? Or should I open a new issue about the problems with using the format prefixes in Calc? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132106] CELL() function "format" should include more date formats to return "D1" (or a new "D0")
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #14 from Eike Rathke --- No, it's not. Only some ground laying work done. -- 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 132106] CELL() function "format" should include more date formats to return "D1" (or a new "D0")
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added CC||79045_79...@mail.ru Blocks||108827 --- Comment #13 from Roman Kuznetsov <79045_79...@mail.ru> --- Eike, possibly it already fixed? Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions 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 132106] CELL() function "format" should include more date formats to return "D1" (or a new "D0")
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 Xisco Faulí changed: What|Removed |Added Status|ASSIGNED|NEW CC||xiscofa...@libreoffice.org Assignee|er...@redhat.com|libreoffice-b...@lists.free ||desktop.org --- Comment #12 from Xisco Faulí --- Dear Eike Rathke, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assign it back to yourself if you're still working on this. -- 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 132106] CELL() function "format" should include more date formats to return "D1" (or a new "D0")
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 Eike Rathke changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Summary|CELL() function "format"|CELL() function "format" |should include more date|should include more date |formats to return "D1" |formats to return "D1" (or ||a new "D0") --- Comment #9 from Eike Rathke --- Thanks a lot! So the Excel documentation is incomplete and it's more like ODFF says for D1 (with example and "or similar") and what we implemented so far, but still the differentiation between D1 and D4 is somewhat a mystery to me. Maybe D4 is *only* for formats where M precedes D in a MDY date(+time) format, and D1 is *only* for formats where D precedes M in DMY. That would make sense with your list. And the D4 example would be wrong in the ODFF. And leaves no choice for YMD. Maybe we should just introduce D0 for the YMD order (D10 isn't a good choice as it is 3 characters instead of the other 2), and rework using the simplified predefined index returns. Actually the D1 vs D4 (and then D0) and other Dx returns could be used to determine how to parse a date display string if those actually follow the DMY vs MDY vs YMD order. I'll try to take a stab at this. Btw, it's news to me that Excel allows these [$-x-...] and [$-ru-RU] and [$-ru-RU-x-...] language tag modifiers. Are they saved the same to document storage? -- 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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #8 from Mike Kaganski --- М-Д => D5 -- 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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #7 from Mike Kaganski --- Д is for D, М for M, Г for Y, ч for h, м for m; decimal separator is comma ДД.ММ. ч:мм => D1 ДД.ММ. => D1 ДД.МММ.ГГ => D1 Д.М.ГГ;@ => D1 ДД.ММ.ГГ;@ => D1 [$-ru-RU] ;@ => D1 ДД.ММ.ГГ ч:мм;@ => D1 Д.М.;@ => D1 ДД/ММ/ГГ => D1 ДД/МММ/ГГ => D1 ДД/МММ/ => D1 ДД-МММ-ГГ => D1 ДД-МММ- => D1 ДД => D1 ДД.МММ => D2 Д.М;@ => D2 [$-ru-RU];@ => D2 МММ.ГГ => D3 МММ-ДД/ => D4 М-Д/ГГ => D4 ч:мм:сс AM/PM => D6 ч:мм AM/PM => D7 ч:мм:сс => D8 ч:мм:сс;@ => D8 ч:мм => D9 ч:мм;@ => D9 -ММ-ДД;@ => G ГГ-М-Д => G [$-x-sysdate], ДД, => G [$-ru-RU]Д МММ;@ => G [$-ru-RU]Д МММ ГГ;@ => G [$-ru-RU]ДД МММ ГГ;@ => G [$-ru-RU-x-nomlower], ;@ => G [$-ru-RU-x-genlower], ДД ;@ => G [$-ru-RU-x-genlower]Д "г." => G [$-ru-RU-x-genlower]ДД \г\.;@ => G [$-ru-RU]Д-МММ-;@ => G [$-en-US]ДД.ММ.ГГ ч:мм AM/PM;@ => G [$-x-systime]ч:мм:сс AM/PM => G [$-en-US]ч:мм AM/PM;@ => G [$-en-US]ч:мм:сс AM/PM;@ => G мм:сс => G мм:сс,0 => G мм:сс,0;@ => G [ч]:мм:сс => G [ч]:мм:сс;@ => G -- 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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #6 from Eike Rathke --- @Mike: Can you please try what Excel returns for your usual Russian date and date+time formats, also with month names (DD-MMM-YY, DD-MMM-), and maybe long date formats (DD or similar)? -- 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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #5 from Eike Rathke --- What an utter mess.. So, ODFF in https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#CELL tried to follow https://support.office.com/en-US/article/CELL-function-51BD39A5-F338-4DBE-A33F-955D67C2B2CF (or an older version thereof) but got one example for D1 wrong, namely MM-D-YY should not be there and the "and similar formats" is misleading in that context. Inspecting the MS-Excel examples (d-mmm-yy or dd-mmm-yy) I deduce that only date formats containing all three DMY and using an abbreviated month name should return D1. The long month names are nowhere mentioned. Maybe it's also even only for those en-US D-MMM-YY formats, which are contrary to the "normal" en-US MDY order, as the examples (m/d/yy or m/d/yy h:mm or mm/dd/yy) for D4 are all en-US centric. I tried to compare with the German page https://support.office.com/de-de/article/zelle-funktion-51bd39a5-f338-4dbe-a33f-955d67c2b2cf but that stupidly lists the same formats just with the localized format code keywords. Seeing D4 (m/d/yy or m/d/yy h:mm or mm/dd/yy) I'd say that *all* formats using all three DMY numeric in any order with or without time should be D4, so also -MM-DD or -MM-DD HH:MM and the like. -- 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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #4 from Mike Kaganski --- I thought that D1 is for three-element dates with MDY order, D2 for DM, D3 for MY, etc. My perception was based on D2 vs D5, but I see that I must be wrong, because three-part dates then would only have one order (D1). I don't know which D category is the correct one for ISO dates, but definitely G is not right here. -- 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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 --- Comment #3 from Eike Rathke --- Question remains, do we continue to follow that nonsense? I suggest at least for the clear cases of ISO 8601 date and date+time we do not. The current implementation may vary anyway between locales because it does not use the format code but the semantic index of the format for predefined formats, which most times is correct but in the cases of MM-DD vs DD-MM may not. That could be improved as well. -- 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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106
--- Comment #2 from Mike Kaganski ---
Created attachment 159569
--> https://bugs.documentfoundation.org/attachment.cgi?id=159569=edit
Sample with CELL("format")
This gives "G" in both cases in Excel 2016.
--
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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 Eike Rathke changed: What|Removed |Added CC||mikekagan...@hotmail.com --- Comment #1 from Eike Rathke --- @Mike: What does Excel return for -MM-DD and -MM-DD HH:MM:SS for example? -- 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 132106] CELL() function "format" should include more date formats to return "D1"
https://bugs.documentfoundation.org/show_bug.cgi?id=132106 Eike Rathke changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW -- 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
