[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 #17 from QA Administrators --- Dear Eike Rathke, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- 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 #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
