Bug 164549 - Calc, export as pdf automatically adds sheet name as pdf bookmark
Summary: Calc, export as pdf automatically adds sheet name as pdf bookmark
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
24.8.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:25.8.0
Keywords:
Depends on:
Blocks: PDF-Export
  Show dependency treegraph
 
Reported: 2025-01-02 23:52 UTC by John
Modified: 2025-01-08 11:20 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description John 2025-01-02 23:52:56 UTC
Description:
The summary says it all. I have search, but I have found no way to stop calc from using the sheet name as a pdf bookmark. Also, no setting in the export as pdf options to prevent adobe reader from opening with bookmarks displayed. There are some old references to options that are no longer in the newest version, and my Panes section is disabled, which may be another problem, but I was unable to experiment with those options that are disabled.

Steps to Reproduce:
1.Create multiple sheets with various names.
2. Export one sheet as pdf, and set option to open pdf after export.


Actual Results:
PDf opens, bookmark section is open, and bookmark name matches the sheet name.

Expected Results:
PDF opens without the bookmark section open, and without a bookmark automatically created and set to the sheet name.


Reproducible: Always


User Profile Reset: No

Additional Info:
Unsure what you want in this section.
Comment 1 John 2025-01-02 23:57:00 UTC
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Comment 2 BogdanB 2025-01-03 07:36:14 UTC
Hi, John. I tested on Windows, and you can disable the option Export outlines, and you have no bookmark in your document. If checked the document will have sheets name. Can you check this option?
Comment 3 John 2025-01-03 13:39:55 UTC
When I open export to pdf, the option to which you are referring is checked, but disabled. Please advise.
Comment 4 BogdanB 2025-01-03 19:43:58 UTC
I don't have access for 4 days to test a Windows machine.
Comment 5 BogdanB 2025-01-06 13:22:48 UTC
(In reply to John from comment #3)
> When I open export to pdf, the option to which you are referring is checked,
> but disabled. Please advise.

John, try to disable Universal Accesibility, or other checkboxes above from that dialog. Something is disabling your option. I tried now and if I check Universal Accesibility, Export outline is checked but can not be changed.
Comment 6 John 2025-01-06 14:27:33 UTC
That worked, thanks. It may be helpful in avoiding erroneous bug submissions to update the help section. I searched it as well as the internet for this particular issue, and found nothing conclusive. There's a mention of the 'Export Outlines' in reference to Writer, but not Calc. There's no mention of which options are disabled/enabled by or dependent on any other options.

Also, there may still be a bug, but lmk if I need to submit it or if this bug report can serve. Why does checking the 'universal accessibility' force/require 'export outlines', as well as 'outline and page' under the 'Panes' section on the 'Initial View' tab?

I will say that the majority of my issue stemmed from the bookmark section being opened after pdf export as it takes up a majority of the window in which it is open.
Comment 7 BogdanB 2025-01-06 18:46:21 UTC
UX Team -- please take a look at this enhancement (comment 6). Thanks!
Comment 8 Heiko Tietze 2025-01-07 09:35:00 UTC
(In reply to John from comment #6)
> Why does checking the 'universal accessibility'
> force/require 'export outlines', as well as 'outline and page' under the
> 'Panes' section on the 'Initial View' tab?

https://cdn.standards.iteh.ai/samples/82278/61329d7c9eb54e3fbc58a69f6036031d/ISO-14289-2-2024.pdf (you may find better resources)
"The accessibility of a PDF document depends on the inclusion of a variety of semantic information such as (but not limited to):
...
— appropriate semantic structures for elements such as paragraphs, lists, tables and headings
..."

As for UX, the only possible improvement might be to add a hint to the tooltip (also for Use reference XObjects) but this sounds like over-engineering to me. The better place would be the online help but I neither find a hint in https://help.libreoffice.org/24.8/en-US/text/shared/01/ref_pdf_export_general.html nor https://help.libreoffice.org/24.8/en-US/text/shared/01/ref_pdf_export_universal_accessibility.html => documentation
Comment 9 Commit Notification 2025-01-08 09:46:39 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/703c344328b4751e2c6a6477323798848c5594d7

tdf#164549 PDF/UA requires tagged PDF