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"
Dear Cor Nouws,
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
(In reply to QA Administrators from comment #7)
> If you have time, please do the following:
Still the same in Version: 126.96.36.199
Build ID: b585d7d90ab863bf29b2d110c174c0c2a98f3ee4
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: nl-NL (en_US.UTF-8); UI: en-US