Created attachment 197307 [details] Spreadsheet with many hyperlink formulas This is very difficult to reproduce. I think, I've managed to create a reproducible sample file. Column A is a text column of a database import range. Don't try to refresh it. Column B calculates a file name from that column. Column C calculates a smb: hyperlink for Linux PC. Column D calculates a file: hyperlink for Windows PC. The hyperlinks are not clickable on either system. The mouse pointer does not change when I hover over the hyperlink cells. If the hyperlinks point to actual files, I can paste the calculated URLs into a browser or file manager and the respective file opens. When I added the first hyperlink formulas, they worked properly. They became unclickable after dragging down the formulas. Reducing the amount of rows and reloading the file makes them clickable again. This used to work with version 7.6.
After eliminating all errors (clear text in column A causing error values), all the hyperlinks work. Nevertheless, errors in some row should not affect the hyperlinks in other rows.
Tested on Linux and hyperlinks in column C are not clickable in Version: 7.3.7.2, 7.6.8.0.0+ nor Version: 25.2.0.0.alpha0+
Try $Sheet2.$H$2 -> Sheet2.$H$2
(In reply to nobu from comment #3) > Try > $Sheet2.$H$2 -> Sheet2.$H$2 This change creates a working hyperlink in one cell but when you drag down the formula, the links fail again.
Hi Andreas, All the hyperlinks in the sample file you provided are not clickable. Can you provide a sample file with the first row that is clickable? Can you also specify how did you drag down the formula? I have changed the status to NEEDINFO. Version used for reproducing the issue: Version: 24.8.2.1 (X86_64) / LibreOffice Community Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 CPU threads: 2; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
(In reply to mkt from comment #5) > Hi Andreas, > > All the hyperlinks in the sample file you provided are not clickable. Can > you provide a sample file with the first row that is clickable? > > Can you also specify how did you drag down the formula? > > I have changed the status to NEEDINFO. > > Version used for reproducing the issue: > Version: 24.8.2.1 (X86_64) / LibreOffice Community > Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 > CPU threads: 2; OS: Windows 10 X86_64 (10.0 build 19045); UI render: > Skia/Raster; VCL: win > Locale: en-US (en_US); UI: en-US > Calc: threaded New Calc document. A1: a.pdf A2: b.pdf A3: c.pdf B1: =Hyperlink("file:///tmp/"&A1) Drag down B1. Hyperlinks are clickable A4: =1/0 raising some error in this single cell. Drag down B3. None of the hyperlinks is clickable. It has nothing to do with the first formula or with the amount of formulas. A single error in the column of calculated hyperlink disables all the hyperlinks.
Created attachment 197604 [details] enter =1/0 in A4 Hi Andreas, I agree with you that after drag down B1, the links in B1 ~ B3 are all clickable. For cell A4, please see the attached image. I wanted to make sure I understand you correctly—did you mean to enter =1/0 in A4? Entering a 0 in the denominator would cause an error, and therefore, cell B4 would show an error after dragging down from B3. Which prevented me from going further. Please clarify.
Yes, =1/0 or ="a"+1 or =NA() If there is some error, the error spoils all the hyperlinks, not only in the same row.
[Automated Action] NeedInfo-To-Unconfirmed
I can confirm this following steps from comment 6 in Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 7a7ba9cbee91485a9254949d1594352b3629c070 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded and 7.3.7, 7.5.0.0.alpha1+ Andreas, you wrote it worked in 7.6. Are you sure?
> Andreas, you wrote it worked in 7.6. Are you sure? Let me put it this way: It always used to work when needed to find some pdf file, and the error values in my original file are several years old. The original file includes a date column.