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: [email protected] 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
