https://bugs.freedesktop.org/show_bug.cgi?id=69211
Ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #5 from Ady <[email protected]> --- 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. -- 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
