[libreoffice-users] Re: Defined name CRLF(Newline) cell in Excel cannot be correctly imported

Good, that you have found a solution. And thanks for share it. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Defined-name-CRLF-Newline-cell-in-Excel-cannot-be-correctly-imported-tp4118441p4118470.html Sent from the Users mailing list archive at Nabble.co

[libreoffice-users] Re: Defined name CRLF(Newline) cell in Excel cannot be correctly imported

Thanks for your reply. I have tried the User Profile matter, but it doesn't work. After that, I have found out the solution for this problem. Tools -> Options - LibreOffice Calc -> Formula -- Recalculation on file load -> Excel 2007 and newer: Always recalculate (from Never recalculate) -

[libreoffice-users] Re: Defined name CRLF(Newline) cell in Excel cannot be correctly imported

Hi @katsum, works for me as I think it must be expected, with: Win7x64, LibreOffice 4.2.6.5 / 4.2.7.2 / 4.3.0.4 / 4.3.1.0.0+ / 4.4.0.0.alpha0+ I don't remember any option to change this behavior, but maybe there is any. Try resetting the User Profile