<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Related to LibreOffice Calc: Hyperlinks in cells with text saved in Excel format, error after re-opening of file"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139274">139274</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Related to LibreOffice Calc: Hyperlinks in cells with text saved in Excel format, error after re-opening of file
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>volker.stroenisch@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
the problem occurs under following conditions (repeatedly):
- a text is entered in a cell plus a hyperlink. After saving the file in
Excel-format and re-opening the file, the respective cell in the file is
damaged: formatting is destroyed, everything appears as one line and is seen as
the hyperlink, the line can not be edited any longer in a regular way.
Steps to Reproduce:
The problem occurs under following conditions (repeatedly):
1. a text is entered in a cell
2. the text is followed by a hyperlink (either a URL inserted directly with the
option "URL automatically detected" or a hyperlink itself)
3. first the cell looks ok and can further be edited etc.
4) now: save the file in Excel-format (xls or xlsx) and re-open it:
5) the format of the respective cell is destroyed. The whole cell with the
whole text is seen as the hyperlink. Editing of the cell is no longer possible
As workaround the hyperlink itself can be deleted
2.
3.
Actual Results:
the cell with containing the hyperlink is damaged. the formatting like enforcd
line breaks is gone, everything is shown in one line and the cell can not be
editied any longer in a normal way.
By the way: opening the file in Microsoft Excel shows correct results!
Expected Results:
The cell should look like before re-opening.
It seems to me like a problem with the excel-format in saving and restoring of
the file
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>