https://bugs.freedesktop.org/show_bug.cgi?id=69211
--- Comment #6 from Ady <[email protected]> --- (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;YYYYMMMDD;D/M/Y;DD/MM/YYYY > but only when using my default English (USA) "MM/DD/YYYY" 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/YYYY 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/YYYY and *then* I change it to DD/MM/YYYY formatting, the cell is correctly interpreted as a date. If I first format a cell as DD/MM/YYYY, 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 [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
