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
