[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
