Bug 80040

Summary: FILESAVE: XLSX created hyperlinks don't show up in Excel in blue
Product: LibreOffice Reporter: Jay Philips <philipz85>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: minor    
Priority: low CC: barta, jorendc, reisi007
Version: Inherited From OOo   
Hardware: Other   
OS: All   
Whiteboard: interoperability
i915 platform: i915 features:
Attachments: the LibO 4.3 saved xlsx
how it looks in word 2013
how it looks in LibO 4.2.4.2
File created with master
Destroyed doc

Description Jay Philips 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 Jay Philips 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 4.2.4.2

hi Jay, would you please post your LibO screenshot and compare to mine?
Comment 3 Jay Philips 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

Version: 4.4.0.0.alpha0+
Build ID: bdd87b2acddb2e244569dcc8f228e270614dc59e
TinderBox: Win-x86@39, Branch:master, Time: 2014-06-23_00:37:24
OS:Win7x64
Comment 5 Jay Philips 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.

Steps:
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
Hi,

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 Jay Philips 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 Jay Philips 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

Hi,

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 ;)

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.