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

I often use defined name CRLF in Excel like below images. The formula is "=CHAR(13) + CHAR(10)". This method cannot be correctly imported from Excel to LibreOffice. Here are summarized images.

[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) -