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.
Unfortunately, activation email could not send to your email. Please try again.

Hiding graph data

Thread ID:

Created:

Updated:

Platform:

Replies:

79077 Jan 20,2009 03:43 AM Jan 22,2009 07:32 AM Windows Forms 2
loading
Tags: XlsIO
Tomasz (Tomek)Borucki
Asked On January 20, 2009 03:43 AM

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 11:55 AM

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 07:32 AM

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.

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.

;