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. -- View this message in context: http://nabble.documentfoundation.org/Defined-name-CRLF-Newline-cell-in-Excel-cannot-be-correctly-imported-tp4118441.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
