Description: If you have multiple words in a string, and have multiple lines of text (via Ctrl+Enter), when you add a hyperlink to a subset of the first line, the entire cell becomes one line and becomes the hyperlink. This ruins the cell contents and the hyperlink. Steps to Reproduce: In the cell: I am line one I am line two 1) select text "one" -> Insert menu -> Hyperlink cmd - observe the Text field shows only the selected text (this is the desired behavior) 2) type your URL, OK - observe the result looks correct; the cell is unchanged except for the substring being colored to reflect the hyperlink 3) Close+Save the file 4) open the file - observe two things: a) the lines of text are concatenated into one: "I am line oneI am line two" b) the entire text string is now hyperlinked Actual Results: open the file - observe two things: a) the lines of text are concatenated into one: "I am line oneI am line two" b) the entire text string is now hyperlinked Expected Results: a) only the selected text should be hyperlinked, as reflected in the Hyperlink dlg when the link was created b) the multi-line text should not be altered (not concatenated into one line) Reproducible: Always User Profile Reset: No Additional Info: It should have done what is described in 'expected results', right?
I could reproduce in Version: 7.1.5.2 (x64) / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: ko-KR (en_US); UI: en-US Calc: threaded However, initially was unable to reproduce until I saved the document file type as an Excel file (I used Excel 2007-365) instead of an ODF spreadsheet.
Can also repro in Version: 7.3.0.0.alpha0+ (x86) / LibreOffice Community Build ID: 4debb7e8cc12563f46d1aaa58afdcb831f21cc83 CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: en-GB (en_US); UI: en-US Calc: threaded
(In reply to yellowplane from comment #1) > However, initially was unable to reproduce until I saved the document file > type as an Excel file (I used Excel 2007-365) instead of an ODF spreadsheet. Then this is a duplicate. Hyperlink in Calc is a text level attribute, while in Excel it's a cell level attribute. *** This bug has been marked as a duplicate of bug 65136 ***