| Summary: | problem with CONCATENER ANNEE in xls formula | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Oliver <oliver.brendel> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 3.3.4 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | EXCEL 2003 file with a formula that give "7" in xls and an error in libre office 3.3.4 | ||
This seems to have been solved in LibreOffice 3.4.4, even though I have not seen anything in the changes list that woudl indicate that something had been done ;-) Oliver |
Created attachment 52036 [details] 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