Bug 80040 - FILESAVE: XLSX - Hyperlinks don't show up in Excel in blue or underlined
Summary: FILESAVE: XLSX - Hyperlinks don't show up in Excel in blue or underlined
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: low minor
Assignee: Not Assigned
Whiteboard: interoperability
Keywords: filter:xlsx
Depends on:
Blocks: Calc-Styles XLSX-Hyperlink Hyperlink-Calc
  Show dependency treegraph
Reported: 2014-06-15 00:37 UTC by Yousuf Philips (jay) (retired)
Modified: 2023-04-04 12:29 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

the LibO 4.3 saved xlsx (5.23 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-06-15 00:37 UTC, Yousuf Philips (jay) (retired)
how it looks in word 2013 (128.20 KB, image/jpeg)
2014-06-15 00:37 UTC, Yousuf Philips (jay) (retired)
how it looks in LibO (26.05 KB, image/jpeg)
2014-06-15 06:48 UTC, tommy27
File created with master (4.98 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-06-25 06:22 UTC, Florian Reisinger
Destroyed doc (46.39 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-06-28 07:33 UTC, Florian Reisinger
sample xlsx created in excel 2010 (9.04 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-10-21 23:38 UTC, Yousuf Philips (jay) (retired)
attachment 137193 after adding a new link and saving as xlsx (61.55 KB, image/png)
2021-07-05 10:56 UTC, NISZ LibreOffice Team

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2014-06-15 00:37:03 UTC
Created attachment 101072 [details]
the LibO 4.3 saved xlsx

I opened an xlsx file created in excel 2013 and then modified it by adding in a hyperlink and then saved the document (attached) and then re-opened it in excel 2013 and noticed the hyperlink wasnt in blue as it shows in libreoffice. Tested in 3.3.0, 4.2.4 and 4.3 beta 2 on Windows 7.
Comment 1 Yousuf Philips (jay) (retired) 2014-06-15 00:37:29 UTC
Created attachment 101073 [details]
how it looks in word 2013
Comment 2 tommy27 2014-06-15 06:48:34 UTC
Created attachment 101082 [details]
how it looks in LibO

hi Jay, would you please post your LibO screenshot and compare to mine?
Comment 3 Yousuf Philips (jay) (retired) 2014-06-15 22:17:25 UTC
hi tommy27, yes my LibO shows it in the same way as your screenshot. The issue here is that opening the attached xlsx in word shows it in black, while LibO shows it in blue. If you open the attachment in excel viewer, you can see how it is shown, if you dont have ms office.
Comment 4 Florian Reisinger 2014-06-25 06:22:22 UTC
Created attachment 101718 [details]
File created with master

Working with file from master

Build ID: bdd87b2acddb2e244569dcc8f228e270614dc59e
TinderBox: Win-x86@39, Branch:master, Time: 2014-06-23_00:37:24
Comment 5 Yousuf Philips (jay) (retired) 2014-06-25 07:14:45 UTC
Florian: you need to open the attached file in ms excel not LibO. I retested the instructions with 4.4 2014-06-23.

1. Open Excel 2013
2. Add hyperlink to A1
3. Save as xlsx
4. Open xlsx in LibO
5. Add hyperlink to B3
6. Save
7. Open xlsx in Excel 2013
8. B3 link shows in black
Comment 6 Florian Reisinger 2014-06-27 09:39:19 UTC

Yes I did know that... But it is just, that the style of the text changed automatically in Word, and LibO uses a background for links. So it is just about not setting the color, the link is working fine, used same master....

So -> NOTABUG: Why should Hyperlinks be blue and underlined automatically, if this is indicated via BG.... In LibO the hyperlink is not blue as well.... So either I do not get this bug, or you need to explain it again :)
Comment 7 Yousuf Philips (jay) (retired) 2014-06-27 11:31:45 UTC
as attachment 101082 [details] shows that the link in libO is blue and attachment 101073 [details] shows in word 2013 that its black, this is a bug as far as i am concerned as xlsx is a microsoft format and if its shown one way in libO and one way in word, libO has implemented it wrong. :)
Comment 8 Jorendc 2014-06-27 12:35:26 UTC
Lets mark this one as NEW. Screenshot of Jay provides the output in Excel 2013, Tommy's screenshot shows the incorrect behavior. I think that's a confirmation :-).
Comment 9 Yousuf Philips (jay) (retired) 2014-06-27 20:44:36 UTC
Florian clarified in the IRC that excel uses direct formatting (adds a blue color and underline to hyperlinks) to make it seem as if it is the standard hyperlink and LibO isnt imitating this practice. But LibO does imitate this practice when it creates an xlsx file itself.

Steps: Open calc, add a hyperlink, the font color is automatic, save as xlsx, reopen xlsx, font color is 'blue 3'. Tested on master.
Comment 10 Florian Reisinger 2014-06-28 07:33:07 UTC
Created attachment 101907 [details]
Destroyed doc


What I did:
Create a xlsx in LibO, open it in Excel, add a pic, close it, open it in LibO created (and always inserted) a pic and saved it. This works fine, until I add the first hyperlink in Excel. LibO opens it, but when adding a hyperlink now MS cannot open it. 
It seems a bit buggy on their side, because they remove the hyperlinks [which they say in the report generated] and the pictures are gone as well...

But I see the bug ;)
Comment 11 QA Administrators 2015-07-18 17:42:32 UTC Comment hidden (obsolete)
Comment 12 tommy27 2015-07-19 08:13:47 UTC
still present in LibO and (x64)
Build ID: 5a61d7f049a81d6e747d9d097f364ae45f58697b
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-07-16_01:06:26
Locale: en-US (it_IT)
Comment 13 Yousuf Philips (jay) (retired) 2017-10-21 23:38:13 UTC
Created attachment 137193 [details]
sample xlsx created in excel 2010

So excel has a hyperlink cell style defined in /xl/styles.xml like so.

<cellStyles count="2">
 <cellStyle name="Hyperlink" xfId="1" builtinId="8" />
 <cellStyle name="Normal" xfId="0" builtinId="0" />

And its imported into LO as 'Excel Built-in Hyperlink' cell style.
Comment 14 Yousuf Philips (jay) (retired) 2017-10-22 00:04:32 UTC
So LO automatically colors all hyperlinks text in blue with a gray background and doesnt assign it to a hyperlink cell style (whether already defined or not), so LO saves it with the default cell style, which excel opens it to look like.
Comment 15 QA Administrators 2021-02-25 04:09:12 UTC Comment hidden (obsolete)
Comment 16 NISZ LibreOffice Team 2021-07-05 10:56:34 UTC
Created attachment 173365 [details]
attachment 137193 [details] after adding a new link and saving as xlsx

Still a problem in:

Version: (x64) / LibreOffice Community
Build ID: 0afa7e64d547a8f2a48402660acf5c95a468a0ab
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL

Excel uses the Hyperlink (Excel Built-in Hyperlink as seen in Calc) cell format and Calc does not set it on export on cells that contain a hyperlink.