Change the font in printing time

Posted by: sathish_90 on 8 September 2017, 3:13 pm EST

  • Posted 8 September 2017, 3:13 pm EST

    I am create report using spread. In report some rows are bold and some row are italic.
    Now i want change font in printing time only so i tried to change the font of sheet like

    sheet1.DefaultStyle.Font=GlobalAppSetup.Vars.ReportPrintFont 


    GlobalAppSetup.Vars.ReportPrintFont this variable have font. But it does not change the font which row's already affected like wise which rows fonts are already changed in report bold,italic,font size changed.

    How to change the font in full spreadsheet only the printing time
  • Replied 8 September 2017, 3:13 pm EST

    Hi,

    Unfortunately, it is not possible to get the font changed at the time of printing only. However, in order to accomplish your requirements, what you can do is:
    1. create a new Spread and add a hidden sheet with the desired font
    2. print the above created hidden spread sheet while displaying the original Spread to your clients
    Please find a small sample application implementing the same attached and let me know if you still have any concerns.

    Thanks and Regards,
    Pragati Kaushik
    2014/04/ApplyFontAtPrintTimeOnly.zip
  • Replied 8 September 2017, 3:13 pm EST

    Thanks Its Worked. It change the font but if already i said any row is bold after font change its not bold?
  • Replied 8 September 2017, 3:13 pm EST

    Hello,

    I would like to inform you that the formatting applied on a spread sheet is priority based. The order of priority in descending order is:
    1. Cells formatting
    2. Rows formatting
    3. Columns formatting

    Example: If we set the FontType of a row to 'Bold' and set the FontType of the same CellRange to 'Regular', then the FontType of the row would not be applied as the cell formatting is on the higher priority.

    Hope it clarifies. Please refer to the attached sample application for better understanding.

    Thanks.
    2014/06/PriorityOfFormatting.zip
  • Marked as Answer

    Replied 8 September 2017, 3:13 pm EST

    ok Thanks

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels