We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Hiding graph data

Thread ID:

Created:

Updated:

Platform:

Replies:

79077 Jan 20,2009 08:43 AM UTC Jan 22,2009 12:32 PM UTC WinForms 2
loading
Tags: XlsIO
Tomasz (Tomek)Borucki
Asked On January 20, 2009 08:43 AM UTC

Hello,
I'm not sure how to solve following problem with XlsIO. There are graphs on worksheet using data from some ranges on it. User doesn't want to print the graph data however. How to hide it in a best way ? I mean, I want the data stay on the sheet. Maybe white font color? But what if user changes background color (is any way to read actual sheet background color?)? Best if the data could be visible in worksheet but not in printed version.

thanks
Tomek


Tomasz (Tomek)Borucki
Replied On January 21, 2009 04:55 PM UTC

After better testing, in fact white font is not the good solution, because Excel prints just empty sheets... So actually no idea how to solve it (except not printing data on sheet at all)

Tomek

>Hello,
I'm not sure how to solve following problem with XlsIO. There are graphs on worksheet using data from some ranges on it. User doesn't want to print the graph data however. How to hide it in a best way ? I mean, I want the data stay on the sheet. Maybe white font color? But what if user changes background color (is any way to read actual sheet background color?)? Best if the data could be visible in worksheet but not in printed version.

thanks
Tomek




Geetha M [Syncfusion]
Replied On January 22, 2009 12:32 PM UTC

Hi Tomek,

Thank you for your interest in Syncfusion products.

Yes. It is possible to print selected areas of any worksheet using the code snippet given below:

sheet.PageSetup.PrintArea = "$A$1:$E$11";

Please refer to the sample demonstrating the same in the below link:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F79077/main.htm

Regards,
Geetha


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;