With a spreadsheet, with multiple sheets and a defined print range
- Select one sheet
- File > Export as PDF
- Tab General, Range.. choose Selected sheets
> one expects that only selected sheet (possibly print range) is exported.
If however the Full-sheet Preview (Structure) is set (is remembered from last export), the result of the export is the full spreadsheet.
So should "Full-sheet previews" disable the widgets for setting the range?
The distance/position of the various controls is not ideal for that, I think.
First of all it behaves differently depending on the checkbox on or off. And that's a clear bug (if Full Preview alters the printing options it's required to enabled/disable those respectively, but that's likely not true here).
The "Full-Sheet previews" (why plural) is another undocumented and misleading function. At least we should provide a tooltip explaining "If this option is enabled you see all pages in one" (with a better text of course).
(In reply to Heiko Tietze from comment #2)
> First of all it behaves differently depending on the checkbox on or off. And
> that's a clear bug (if Full Preview alters the printing options it's
> required to enabled/disable those respectively, but that's likely not true
That's actually the case here. full-sheet previews option disregards some other options intentionally.
> The "Full-Sheet previews" (why plural) is another undocumented and
> misleading function. At least we should provide a tooltip explaining "If
> this option is enabled you see all pages in one" (with a better text of
I explained it on a blog post, but might have forgotten to add to the release notes. I'll add it to the release notes, and create a documentation bug report also.
I agree on disabling/greying-out the disregarded options.
Let's make this an easyhack.
Check for the value of mbSinglePageSheets in the ImpPDFTabDialog class, and disable related items (all of the items under "General > Range" of the "PDF Options" dialog, which could be displayed by following "File > Export as PDF..." menu) on the dialog based on the value of it.
You will need to do the first disabling (if needed) inside ImpPDFTabGeneralPage::SetFilterConfigItem() method, probably just after this line:
Then you need to add a toggle handler for the mxCbSinglePageSheets checkbox, and enable/disable the range options inside that toggle handler based on the value/state of the checkbox. (You may check the toggle handlers of the mxCbReduceImageResolution and the mxCbWatermark checkboxes to see how it is done.)
It is also probably a good idea to check the related blog post to understand the option, and get some tips: https://muhammetkara.com/post/2019-10-18-full-sheet-previews-in-libreoffice/
I would like to work on this easy hack but I can not reproduce it as I can't find the 'Full-Sheet previewes' option. I have a Calc window with 2 empty sheets and I dont have the option described in https://muhammetkara.com/post/2019-10-18-full-sheet-previews-in-libreoffice/
a screenshot of my options https://imgur.com/a/d7Vw7DS
(In reply to Mohamed Sameh from comment #5)
> I would like to work on this easy hack but I can not reproduce it as I can't
> find the 'Full-Sheet previewes' option. I have a Calc window with 2 empty
> sheets and I dont have the option described in
> a screenshot of my options https://imgur.com/a/d7Vw7DS
It was renamed to "Whole sheet export"