https://bugs.freedesktop.org/show_bug.cgi?id=41505
Summary: problem with CONCATENER ANNEE in xls formula
Product: LibreOffice
Version: LibO 3.3.4 release
Platform: x86-64 (AMD64)
OS/Version: Windows (All)
Status: NEW
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=52036)
--> (https://bugs.freedesktop.org/attachment.cgi?id=52036)
EXCEL 2003 file with a formula that give "7" in xls and an error in libre
office 3.3.4
I have an administrative xls spreadsheet, where the following formula is not
working :
=(CONCATENER("31/12/";ANNEE(A1))-A1)/30
where cell A1 has the format "ddmmaa"
if A1 containt "01/06/12" then in Excel the formula gives the value 7.1
(actually 7 is the cell format in integer with zero decimals, as this is the
case in the administrative spreadsheet).
In LibreOffice I get an "uncorrect data type" error.
I have created such a spreadsheet and uploaded it using Excel 2003, but I have
seen this spreadsheed working on any number of newer EXCELs.
I cannot see why this is not working, other than "ANNEE" (french for "YEAR; in
the french version the functions seem all to be translated) being in
Libreoffice not the right data type for "CONCATENER" (I guess in english
"CONCATENATE") ...
Cheers
Oliver
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
