Description: Attached document contains some hyperlinks on cells containing formulas in row 6. This is part of bug #89633 in case of XLSX format. Steps to Reproduce: Steps to reproduce: 1. Open the attached file in Calc 2. Save the file as XLSX Actual Results: The hyperlinks on B6-D6 are not saved. Expected Results: Hyperlinks are retained. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 152311 [details] Example file from Excel
Created attachment 152312 [details] The original file saved by Calc
Created attachment 152313 [details] Screenshot of the original document Excel with hyperlink on formula cell
Created attachment 152314 [details] Screenshot of the exported document in Excel with hyperlink lost
Confirmed with: Version: 6.3.0.0.beta1+ (x86) Build ID: 5cfac16dbd4af456a7fb6d52c8953c69a72ba2ba CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; Locale: hu-HU (hu_HU); UI-Language: en-US Calc: threaded
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/1bdbdc6ebcdba2784dcfa56b50632c4706ba14b5%5E%21 tdf#126024 XLSX export: fix hyperlink on formula cell It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tünde Tóth committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/861ee491b0bf3ca1c18336924017911a1823cc31%5E%21 tdf#126024 XLSX export: fix hyperlink on formula cell It will be available in 6.3.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.