[libreoffice-users] hyperlink truncation problem

Hello
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 ask.libreoffice.org 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

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy