C1 Community
ComponentOne Community is a free source for developers and help authors to collaborate and communicate.
Sign in
|
Join
|
Help
Home
Blogs
Forums
Wikis
Forums
»
WinForms
»
Excel for .NET
»
FitPagesDown problem
FitPagesDown problem
rated by 0 users
This post has 1 Reply | 1 Follower
Posts
23
Reply
x-invest
Posted: Fri, May 22 2009 6:00 AM
rated by 0 users
Hi! I'm using this code: Excel.Clear(); Excel.Sheets.Clear(); Excel.CompatibilityMode = CompatibilityMode.Excel2007; Excel.DefaultFont = new Font("Microsoft Sans Serif", 8F, FontStyle.Regular); XLSheet Sheet = Excel.Sheets.Add("sheet"); Sheet.PrintSettings.MarginTop = 0.5F; Sheet.PrintSettings.MarginBottom = 1F; Sheet.PrintSettings.MarginLeft = 0.5F; Sheet.PrintSettings.MarginRight = 0.5F; Sheet.PrintSettings.CenterHorizontal = true; Sheet.PrintSettings.CenterVertical = false; Sheet.PrintSettings.FitPagesAcross = 1; Sheet.PrintSettings.FitPagesDown = 100; Sheet.PrintSettings.AutoScale = true; But FitPagesAcross/FitPagesDown are always 1/1 in Excel after I open the saved xlsx file. Even when I set AutoScale to false... I'm doing something wrong ?
Posts
23
Reply
x-invest
replied on
Wed, Jun 3 2009 6:26 AM
rated by 0 users
up, plz :$
Previous
|
Next
Page 1 of 1 (2 items) |
RSS
Contact ComponentOne: 1.800.858.2739 ©1987-2010 ComponentOne LLC All Rights Reserved.