[Libreoffice-bugs] [Bug 69211] Other: DateDif (win only)
https://bugs.freedesktop.org/show_bug.cgi?id=69211 Ady ady...@hotmail.com changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #5 from Ady ady...@hotmail.com --- Version: 4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a on Windows. The following information might require its own separate bug report(s), but I think it might be useful for this bug too. Using other date-related functions (besides DATEDIF), they _all_ fail, except when the referenced cell is formatted with my default locale setting in Calc. I have added (for testing) these Date acceptance patterns: M/D/Y;M/D;MMMDD;D/M/Y;DD/MM/ but only when using my default English (USA) MM/DD/ I get to see a result. For example, using the YEAR function, all other formatted cells return #VALUE. Moreover, I tried using CELL(FORMAT,A1), and this CELL function fails with #NAME every time (no matter which format the referenced cell A1 is using. Any variation of CELL() (e.g. CELL(CONTENTS,A1) and so on) gives me the same #NAME result, so probably this is an additional separate bug. Since the alignment is also different when using MM/DD/YYY than when using other non-default date formats (such as DD/MM/ in my case), it seems to me that the bug is not really in the DATEDIF function, but in the way Calc is identifying those cells (seemingly, as 'text'). Regards, Ady. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69211] Other: DateDif (win only)
https://bugs.freedesktop.org/show_bug.cgi?id=69211 --- Comment #6 from Ady ady...@hotmail.com --- (In reply to comment #5) Version: 4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a on Windows. The following information might require its own separate bug report(s), but I think it might be useful for this bug too. Using other date-related functions (besides DATEDIF), they _all_ fail, except when the referenced cell is formatted with my default locale setting in Calc. I have added (for testing) these Date acceptance patterns: M/D/Y;M/D;MMMDD;D/M/Y;DD/MM/ but only when using my default English (USA) MM/DD/ I get to see a result. For example, using the YEAR function, all other formatted cells return #VALUE. Moreover, I tried using CELL(FORMAT,A1), and this CELL function fails with #NAME every time (no matter which format the referenced cell A1 is using. Any variation of CELL() (e.g. CELL(CONTENTS,A1) and so on) gives me the same #NAME result, so probably this is an additional separate bug. Since the alignment is also different when using MM/DD/YYY than when using other non-default date formats (such as DD/MM/ in my case), it seems to me that the bug is not really in the DATEDIF function, but in the way Calc is identifying those cells (seemingly, as 'text'). Regards, Ady. In addition, if I first insert a date as MM/DD/ and *then* I change it to DD/MM/ formatting, the cell is correctly interpreted as a date. If I first format a cell as DD/MM/, and *then* a date is inserted with such format, the date is treated as 'text' and not as 'date' (say, 18/11/2013), but if I insert the corresponding value, 41596, the cell is correctly shown as 18/11/2013 with the expected alignment and functions such as YEAR work as expected too. BTW, I am having similar experiences (cells treated as 'text') with other number formats, not just with dates. Regards, Ady. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69211] Other: DateDif (win only)
https://bugs.freedesktop.org/show_bug.cgi?id=69211 Eike Rathke er...@redhat.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #7 from Eike Rathke er...@redhat.com --- You just correctly observed that a number format such as a date format is a DISPLAY format, not a data entry mask. Date input is evaluated according to the date acceptance patterns that can be viewed and changed under Tools - Options - LanguageSettings - Languages. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69211] Other: DateDif (win only)
https://bugs.freedesktop.org/show_bug.cgi?id=69211 Eike Rathke er...@redhat.com 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 http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69211] Other: DateDif (win only)
https://bugs.freedesktop.org/show_bug.cgi?id=69211 --- Comment #8 from Ady ady...@hotmail.com --- (In reply to comment #7) You just correctly observed that a number format such as a date format is a DISPLAY format, not a data entry mask. Date input is evaluated according to the date acceptance patterns that can be viewed and changed under Tools - Options - LanguageSettings - Languages. My tests are showing that the additional Date acceptance patterns are not working as expected (a.k.a BUG). The Date acceptance patterns is supposed to help the user introduce dates using alternative date formats (other than its default in Calc Language settings). I can insert the date in my default format and then change the format of the cell as I want; but then there is no point for the Date acceptance patterns. The whole point of Date acceptance patterns is for the user to be able to insert _other_ date formats and Calc should identify (format) it as date automatically. Hopefully I am being more clear now. Perhaps this incorrect behavior is more relevant for bug #71664, as it is not a problem exclusive to DATEDIF. Regards, Ady. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69211] Other: DateDif (win only)
https://bugs.freedesktop.org/show_bug.cgi?id=69211 Foss f...@openmailbox.org changed: What|Removed |Added OS|All |Windows (All) Summary|Other: DateDif |Other: DateDif (win only) --- Comment #4 from Foss f...@openmailbox.org --- Setting OS to windows. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69211] Other: DateDif (win only)
https://bugs.freedesktop.org/show_bug.cgi?id=69211 Ady ady...@hotmail.com changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=71664 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs