Telerik Document Processing Feedback Portal
Back to Feed
Request a Feature Report a Bug
Completed
Last Updated: 03 Dec 2024 16:05 by ADMIN
ADMIN
Tanya
Created on: 19 May 2016 06:51
Category: SpreadProcessing
Type: Feature Request
20
SpreadProcessing: Add automatic scaling to page print options
This will enable printing with the following printing options: 

- Fit Sheet on One Page

- Fit All Columns on One Page

- Fit All Rows on One Page

- Custom automatic scaling


A possible implementation of a similar behavior is to use the PageSize property of WorksheetPageSetup and subtract the corresponding margin values (from the Margins property) from the width to calculate how many columns are fitting in some particular page size with 100% scale factor. 

Available in R2 2018 Official Release version.
9 comments
ADMIN
Yoan
Posted on: 03 Dec 2024 16:05

Hello Andrew,

Thank you so much for your collaboration and for sharing this feedback with us. I truly appreciate you taking the time to bring this to our attention. Your insights are invaluable and help us understand how we can better meet our client's needs. I want to assure you that we’re committed to addressing this feedback and implementing improvements promptly.

Your input plays a vital role in shaping our approach, and we’re grateful for your collaboration.

Regards,
Yoan
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Andrew
Posted on: 29 Nov 2024 23:09

This says it's Completed, but the linked documentation does not explain it very well.

To answer Tim's question, the documentation does NOT explain how to "Fit All Columns on One Page". But this can be achieved by doing this:

worksheet.WorksheetPageSetup.FitToPagesWide = 1;

worksheet.WorksheetPageSetup.ScaleFactor = PageScaleFactorCalculator.CalculateScaleAccordingToFitToPages(worksheet);

That worked for me. The documentation should really address "Fit All Columns on One Page" by that phrasing exactly because that's what Excel says and that's how this post claims it was implemented, but in reality it's a two step process that's a bit of a manual workaround, rather than having something like this:

worksheet.WorksheetPageSetup.FitAllColumnsToOnePage = true; which is probably what Tim was expecting to find in the documentation.

Hope that helps :)

 

Tim
Posted on: 17 Aug 2018 06:27 
Hi Tanya,

I've gone through the page you linked but I can't find a property that will allow setting the scaling to 'Fit All Columns on One Page'.
ADMIN
Tanya
Posted on: 16 Aug 2018 14:47 
Hi Stefan,

Yes, this option is available as well and you can use it through the properties of the WorksheetPageSetup class. More information you can find in the related documentation topic at https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/worksheetpagesetup#worksheetpagesetup-properties .

Regards,
Tanya
Tim
Posted on: 16 Aug 2018 14:03 
Hi

Is it possible to set 'Fit All Columns on One Page' from the code? Not from the Print preview page.
ADMIN
Tanya
Posted on: 22 Dec 2017 14:31 
Hi Eric,

The task is with relatively high priority in our backlog but is currently not scheduled for implementation and I am unable to say when it might be available. Continue following this item so you can get a notification when its status changes.

Regards,
Tanya
Eric
Posted on: 07 Dec 2017 12:41 
Is it possible to say when it will be implemented?
ADMIN
Tanya
Posted on: 03 Aug 2017 12:17 
Hi Davide,

As we discussed in the support thread, the current status of the item is Approved. Once implemented, the status will be changed to Completed.

Regards,
Tanya
Davide
Posted on: 03 Aug 2017 09:58 
Is this feature already implemented ?
Create an account Log In
View
Type
Status
Category