I have a spreadsheet with URL links is some of the cells. Unfortunately, those links are often quite long. When saving as an XLSX file, links seem to get truncated to 256 characters, so the links are defective upon reopening the file. Bugzilla knows about the issue.
Is there a way I can create a cell link that reads the actual text in some other cell to make the call? Essentially, I need to do the equivalent of inserting “=A1” as the link field in the CTRL+K menu, where cell A1 contains the full link.
Use the ODF file formats: .ods for the spreadheet documents.
The question is asking for a workaround for the fact that the Hyperlink function won’t work for long URLs. Using ODS format wrecks the portability of the sheet to some other devices.
Please see that @mariosv does not suggest you to use Insert|Hyperlink (Ctrl+K), which you describe in your question, and which you refer to as “Hyperlink function”; but HYPERLINK spreadsheet function, which is used in formulas like
=HYPERLINK(A1)
or
=HYPERLINK("https://a_very_long_string_longer_than_256_characters" & "additional_string_that_you_may_concatenate_dynamically")That appears to work, but you lose the ability to have something besides the link appearing in the cell. I’ll take what I can get, though.
HYPERLINK("URL" [; "CellText"])
1 Like
Thanks to everyone !