| Summary: | FILESAVE: XLSX created hyperlinks don't show up in Excel in blue | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jay Philips <philipz85> |
| Component: | Spreadsheet | Assignee: | 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 |
||
Created attachment 101073 [details]
how it looks in word 2013
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?
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. 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
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 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 :) 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. :) 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 :-). 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. 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.
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.