Implementing a Custom “Whole Sheet Export” via UNO API to Preserve Hyperlinks in PDFs

Question

When the “whole sheet export” option is enabled during the PDF export process in Calc, the hyperlinks in the exported PDF do not preserve their original URLs and instead show local file paths.

References:

https://ask.libreoffice.org/t/web-hyperlinks-not-preserved-after-export-to-pdf/96762 https://bugs.documentfoundation.org/show_bug.cgi?id=157780

Idea:

I’m considering using the UNO API to implement a custom solution that would:

Iterate through each sheet in a Calc document.

For each sheet, calculate the total width and height required to fit the content within one page, considering all columns and rows.

Generate a custom paper size based on these dimensions for each sheet.

Export to PDF with the custom paper size, ensuring that the “whole sheet export” option is not used, thus preserving the hyperlinks.

Question:

Is this approach feasible using the UNO API?

Cui Pengfei 崔鹏飞 · Accepted Answer · 2024-07-28 08:29:26Z

0

this code is working for now: https://cuipengfei-me.translate.goog/blog/2024/07/28/libre-jod-single-page-excel/?_x_tr_sl=auto&_x_tr_tl=en&_x_tr_hl=en&_x_tr_pto=wapp

could be improved later

answered Jul 28, 2024 at 8:29

Cui Pengfei 崔鹏飞

8,3756 gold badges51 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Implementing a Custom “Whole Sheet Export” via UNO API to Preserve Hyperlinks in PDFs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related