Bug 144069 - FORMATTING: Hyperlink for substring expands to entire string, including multi-line text
Summary: FORMATTING: Hyperlink for substring expands to entire string, including multi...
Status: RESOLVED DUPLICATE of bug 65136
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-08-25 00:11 UTC by Justin
Modified: 2021-08-30 09:16 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Justin 2021-08-25 00:11:53 UTC
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?
Comment 1 yellowplane 2021-08-25 15:31:26 UTC
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.
Comment 2 yellowplane 2021-08-25 15:41:57 UTC
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
Comment 3 NISZ LibreOffice Team 2021-08-30 09:16:29 UTC
(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 ***