Defined name CRLF(Newline) cell in Excel cannot be correctly imported

users
#1

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.

<http://nabble.documentfoundation.org/file/n4118441/CRLF.png>
<http://nabble.documentfoundation.org/file/n4118441/Image.png>

CRLF.xlsx:
https://www.sendspace.com/file/ggcgya

It would convert "=CHAR(13)" with "_x000D_" when the attached file is
imported.

Excel's double quotations are acceptable. but LibreOffice behavior is not.
Why I use "=CHAR(13) & CHAR(10)" instead of "=CHAR(10)" is that some input
fields of my tools are needed. I know that CHAR(13) & CHAR(10) is the binary
type newline and only CHAR(10) is the text type newline.

Is there any way of importing this defined name correctly?

P.S.
This attached file is just a sample. I have already a ton of similar Excel
files using this method. Therefore replacing this defined name with another
way is unfortunately not a solution for me.

#2

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
<https://wiki.documentfoundation.org/UserProfile> , sometimes solves
strange issues.

<http://nabble.documentfoundation.org/file/n4118461/Captura.png>

Miguel Ángel

#3

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)

#4

Good, that you have found a solution.

And thanks for share it.

Miguel Ángel.