https://bugs.freedesktop.org/show_bug.cgi?id=88490
Bug ID: 88490 Summary: function CELL errors - date, currency,coord InfoType Product: LibreOffice Version: 4.3.5.2 release Hardware: Other OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Spreadsheet Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: r...@post.cz Created attachment 112335 --> https://bugs.freedesktop.org/attachment.cgi?id=112335&action=edit testing file During creating of tests for bug 43534 (EDITING: CELL doesn't support external references.) I found following errors in CELL function: Steps to reproduce: - unzip attachment - open file fdo43534test.ods Actual results (cells in red color): cell C3 - external reference lead to DATE format, function returns " number without thousands separator" cell B6 - the same as C3 but local reference - DATE format, function returns " All other formats" cell E3 - external reference lead to CURRENCY format, function returns "number without thousands separator" cell G3 - for infotype “COORD” returns ERR504 in external references Expected results C3 returns D1 B6 returns D1 E3 returns C2- (as local reference in A6) G3 returns $A:$A$3 (as local reference in C6) see https://help.libreoffice.org/Calc/Information_Functions#CELL -- 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