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.
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 ;)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-07-18
still present in LibO 4.4.5.1 and 5.1.0.0.alpha1+ (x64) Build ID: 5a61d7f049a81d6e747d9d097f364ae45f58697b TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-07-16_01:06:26 Locale: en-US (it_IT)
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" /> </cellStyles> And its imported into LO as 'Excel Built-in Hyperlink' cell style.
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.
Dear Yousuf Philips (jay) (retired), To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Created attachment 173365 [details] attachment 137193 [details] after adding a new link and saving as xlsx Still a problem in: Version: 7.3.0.0.alpha0+ (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.