| |
ActiveReports for .NET 2.0 Support
Started by Highven at 02-22-2010 6:47 PM. Topic has 5 replies.
  
|
|
Sort Posts:
|
|
|
|
 02-22-2010, 6:47 PM
|
Highven
Joined on 02-22-2010
Posts 3
|
How can I set the Excel footer to print "page no/ page count" by every sheet ?
|
|
|
|
|
Hi All
currently working on active report 4.3.0.1261 version
need solution for the below problem:
I used the SpreadBuilder to export a muliti sheets excel file.
I want to set the excel footer to print "page no/ page count",but I didn't found some way to do it.
Thanks in advance.
Highven
|
|
|
|
|
Report
|
|
|
|
|
02-23-2010, 5:27 AM
|
SankalpS
Joined on 12-11-2008
Posts 2,414
|
Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?
|
|
|
|
|
|
Highven,
The SpreadBuilder API is used to build up a spreadsheet cell by cell. So basically, you would use the code in the Format events of sections to place the report control data into cells. Could you kindly provide me some more information on how exactly you are looking to get the PageNumber on the sheets? As per your description the only way I can think off at the moment is to calculate the number of rows per sheet and set the value for the last cell as the PageNumber for that sheet.
Regards,
Sankalp
Sankalp Sen
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
02-23-2010, 6:13 PM
|
Highven
Joined on 02-22-2010
Posts 3
|
|
|
|
Hi,Sankalp
Thanks for your answer.
Please see my problem at the attachment.
Regards,
Highven
|
|
|
|
|
Report
|
|
|
|
|
02-23-2010, 11:13 PM
|
SankalpS
Joined on 12-11-2008
Posts 2,414
|
Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?
|
|
|
|
|
|
Highven,
Unfortunately it is not clear from the screenshot what exactly you are looking for. The screenshot displays a dialog box with Japanese text on it. Are you looking to access the properties of this dialog box using SpreadBuilder? You have mentioned that you want to print "page no/ page count" on every excel sheet. Unfortunately the screenshot provided by you does not clarify it much. What is the dialog box which you have attached as a screenshot? Any further information provided to narrow down the issue would be appreciated.
Regards,
Sankalp
Sankalp Sen
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
02-24-2010, 5:33 PM
|
Highven
Joined on 02-22-2010
Posts 3
|
Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?
|
|
|
|
|
|
Sankalp
I'm sorry for my poor English.
I only want to know how can I set the "page number / page count" on the footer of every sheet used SpreadBuilder API.
I know I can set the margin,fitToPage,Zoom,etc with the
DataDynamics.SpreadBuilder.Printing.PageSetup Class. (first screenshot in the attachment)
Unfortunately I didn't find the properties or method of the PageSetup Class that I can set the "page number/ page count" on the footer of excel sheet. (second screenshot in the attachment)
Thanks & Regards,
Highven
|
|
|
|
|
Report
|
|
|
|
|
02-26-2010, 3:18 AM
|
PrantikS
Joined on 12-11-2008
Posts 1,550
|
Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?
|
|
|
|
|
|
Hello,
When you are exporting to excel using SpreadBuilder, you are accessing the cells of the spreadsheet to write to it with code something like this.
sb.Sheets[0].Cell(1,2).SetValue("(614) 895-3142");
So, you would need to decide which cell you are going to write the pagenumber to; with code as
String s= this.PageNumber.ToString();
sb.Sheets[0].Cell(17,2).SetValue(s);
Regards,
Prantik
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » ActiveReports f... » Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?
|
|
|
|
|