I have a problem with a long hyperlink value. When I save the document as .xslx format, the hyperlink is being truncated to 256 characters. Microsoft Excel has a limitation of 256 characters in HYPERLINK function but not in hyperlink property of a cell. When I create and save a file with long links directly in Microsoft Excel, the long links are not truncated.
I tried the workaround I found in this site with HYPERLINK(“URL” [; “CellText”]) and it’s not truncated, but Microsoft Excel cannot open it and says the file is corrupted. After fixing Excel cleans the hyperlink formula.
Microsoft Excel has a limitation on HYPERLINK function, but not on the hyperlink property of a cell. So while saving to .xlsx format, Libre Office Calc is doing the opposite of what is needed:
Expected result: hyperlink property of a cell is not truncated to 256 characters; url in HYPERLINK function is truncated to 256 characters
Actual result: hyperlink property of a cell is truncated; HYPERLINK function is not truncated
My Libre Office version is Version: 24.2.4.2 (X86_64) / LibreOffice Community
Link resaved.xlsx (5.9 KB)
Link original.ods (9.5 KB)
I open your Link resaved.xlsx file in Excel 2016.
In the context menu of cell A1, I select change hyperlink.
The dialog does not allow adding more than 1 character to the address.