Description: When Wrapped hyperlinks are exported to PDF, the link is the text in the topmost row. Steps to Reproduce: 1. Open new Calc. 2. Insert hyperlink into Cell [A1]. ( Ctrl + K ) For example: Link is "https://help.libreoffice.org/latest/en-US/text/shared/guide/hyperlink_insert.html". 3. Apply "Wrap Text" to [A1]. Manually expand the row height. Cell's format must be aligned to the top. 4. Select A1, and Export as PDF with selected range. 5. Open the PDF ( with Web Browser). Actual Results: 6. The hyperlink appears to work in only the top row, but it's not the correct link. The link is the text in the first row. Expected Results: 6. The link works correctly throughout the entire text. Reproducible: Always User Profile Reset: No Additional Info: The HYPERLINK() function has some minor issues with cell functionality, but it is known to work correctly in PDFs. --- Reproducible Version: 26.2.0.0.beta1 (X86_64) Build ID: 620(Build:0) CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (ja_JP); UI: en-US Calc: CL threaded
Created attachment 204567 [details] Sample ods
Created attachment 204568 [details] Sample PDF
Reproductible Version: 26.2.0.0.beta1 (X86_64) Build ID: 620(Build:0) CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (en_CH); UI: en-US Calc: CL threaded 'Hyperlink Settings': First, even after resetting the user profile and creating a new spreadsheet, clicking on a new cell and pressing Ctrl+K still displays the old URL in the 'Link' field of 'Hyperlink Settings'. Second, the 'Reset' button in 'Hyperlink Settings' doesn't work on the 'Link' field. Furthermore, even if the URL is cleared from the 'Link' field, clicking the 'Close' button and returning to the worksheet doesn't change anything; the URL is still stored in 'Hyperlink Settings'. Finally, when exporting to PDF, the link is not clickable, even if you haven't gone into 'Format Cells' -> 'Alignment' -> 'Wrap Text Automatically'; the problem of the unclickable link remains. Regarding text alignment at the top of the cell when the 'Wrap Text automatically' option is enabled, I can't comment, as I'm not familiar with the LibreOffice standard on this matter. I can only say that with version 25.8.3, alignment doesn't seem to default to the top of the cell when the text wraps.
Steps details : 1) create a new calc document, save it 2) Select Cell A1 3) CTR + K (Hyperlink Settings) 4) Hyperlink Settings window : fill in the field 'Link' = https://help.libreoffice.org/latest/en-US/text/shared/guide/hyperlink_insert.html fill in the field 'Text' = https://help.libreoffice.org/latest/en-US/text/shared/guide/hyperlink_insert.html 5) Click button 'OK' 6) Select the Cell A1 again 7) Right mouse click -> 'Format Cells' 8) Format cells window : Choose menu 'Alignment' -> 'Properties' -> check the box 'Wrap text automatically' 9) Click button 'OK' 10) now in the example, the selection is still on the A1 Cell and the hyperlink text in the cell should display something like : 'https://help.li' 11) Meu 'File' -> 'Export as PDF' and save the pdf The hyperlink text displays 'https://help.lib' and when you click on it the browser open the link 'https://help.lib' and not the real url. tests done : ------------ not repro in Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e repro in Version: 26.8.0.0.alpha0+ (X86_64) Build ID: 680(Build:0)
Created attachment 204594 [details] bug 169929 repro - LOC 26.8.0.0.a0
Created attachment 204595 [details] bug 169929 not repro - LOC 25.8.3.2
bug related bug 169928
bug related bug 169926