兵工厂 发表于 2015-12-8 17:16:00

fpspreadpreview如何设置纸张和打印机

vb6 + fpspread7.0的环境

怎么设置fpspread的纸张大小和选择打印机

fpspreadview怎么设置纸张大小和选择打印机

frank.zhang 发表于 2015-12-9 15:55:00

您好,

fpspreadview打印的纸张大小和打印机是操作系统提供的首选打印机选项来决定的。
只能通过操作系统来设置。

兵工厂 发表于 2015-12-9 16:54:00

回复 2楼frank.zhang的帖子

那fpspreadview呢。。。?

兵工厂 发表于 2015-12-9 22:06:00

回复 2楼frank.zhang的帖子

那fpspread的呢。。。?

另外,其它版本的可以设置不。。。?

Alice 发表于 2015-12-10 16:16:00

回复 4楼兵工厂的帖子

很抱歉回复晚了。请问您说的fpspread指的是什么平台下的? Winform平台下可以通过System.Drawing.Printing.PaperSize来设置。

兵工厂 发表于 2015-12-11 00:21:00

回复 5楼Alice的帖子

vb6+fpspread7.0

frank.zhang 发表于 2015-12-11 11:26:00

您好,

WinForms下可以通过PrinterSettings进行设置,设置打印机是操作系统提供,所以这个是一个通用的技术问题,可以参考微软的说明
https://msdn.microsoft.com/en-us/library/system.drawing.printing.printersettings.isdefaultprinter(v=vs.90).aspx?cs-save-lang=1&cs-lang=csharp#code-snippet-2

兵工厂 发表于 2015-12-13 22:31:00

回复 7楼frank.zhang的帖子

恩。。。谢谢,
另,后续版本的fpspreadprview支持纸张大小的改变不。。。?

frank.zhang 发表于 2015-12-14 09:52:00

您好,

Winforms下打印的支持纸张大小,参考代码
' Typically, not all of these settings are used together but are included here for illustration purposes

' Create the printer settings object
Dim printset As New FarPoint.Win.Spread.PrintInfo

' Allow printing of only 20 columns and 20 rows of cells
printset.ColEnd = 20
printset.ColStart = 1
printset.RowStart = 1
printset.RowEnd = 20
printset.PrintType = FarPoint.Win.Spread.PrintType.CellRange

' Allow printing of only five pages
printset.PageStart = 1
printset.PageEnd = 5

' Allow printing of the cell notes together at the end
printset.PrintNotes = FarPoint.Win.Spread.PrintNotes.AtEnd

' Allow printing of the shapes
printset.PrintShapes = True

' Allow printing of only rows and columns up to the last ones with data
printset.UseMax = true

' Assign the printer settings to the sheet and print it
FpSpread1.Sheets(0).PrintInfo = printset
FpSpread1.PrintSheet(0)
页: [1]
查看完整版本: fpspreadpreview如何设置纸张和打印机