Description: When the HYPERLINK function calculates (has some nested function(s)) a hyperlink to another cell and that calculation results in #N/A the hyperlink breaks completely even if the calculation changes to a valid link due to changes external to the HYPERLINK() cell. Recovery requires re-edit of cell (F2,Space,Enter) or reload of the document. Recalculate/Hard recalculate do not avert the issue [nor does adding a recalculation trigger such as &T(RAND()*0)]. Steps to Reproduce: 1. Insert into A1: =HYPERLINK(ADDRESS(B1,C1)) 2. Insert into B1: 1 3. Insert into B2: 2 4. Recalculate (F9) as needed since using indirect reference. 5. Hyperlink works as expected, to B1 6. Now insert into B2: =MATCH(-1,{1},1) //Or other throw of #N/A 7. Hyperlink shows #N/A Actual Results: 8. Ctrl-click on hyperlink acts as 'normal' Ctrl-click multi-select instead of hyperlink 9. Hyperlink is unusable 10. Other hyperlinks in document continue to work 11. Reverting B2 to original (Ctrl-z) value will not reactivate hyperlink, nor will any valid value Expected Results: Expectation would be for the HYPERLINK() function to recover from the #N/A once B2 was reverted back to a valid argument for ADDRESS(). Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Thanks to Villeroy for double-checking and creating the original spreadsheet that pointed out this oddity.
Created attachment 176661 [details] Simple demonstration following steps to reproduce
Correction: Read C1 for B2 in steps to reproduce. Sorry.
I can repro the hyperlink getting broken. Already in 3.3.0 on Win and also 6.3 on Linux. Arch Linux 64-bit Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8b442d7fae17660b3665da2c1f7a084341987693 CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 24 November 2022
Dear Joshua Coppersmith, 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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Bug persists in: Version: 25.2.5.2 (X86_64) / LibreOffice Community Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022 CPU threads: 20; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded