Spread.Sheets Documentation
margin Method
The margins for printing.
value.top {number} top The top margin, in hundredths of an inch.
value.bottom {number} bottom The bottom margin, in hundredths of an inch.
value.left {number} left The left margin, in hundredths of an inch.
value.right {number} right The right margin, in hundredths of an inch.
value.header {number} header The header offset, in hundredths of an inch.
value.footer {number} footer The footer offset, in hundredths of an inch.
Gets or sets the margins for printing, in hundredths of an inch.
Syntax
var instance = new GC.Spread.Sheets.Print.PrintInfo();
var returnValue; // Type: any
returnValue = instance.margin(value);
function margin( 
   value : Object
) : any;

Parameters

value
The margins for printing.
value.top {number} top The top margin, in hundredths of an inch.
value.bottom {number} bottom The bottom margin, in hundredths of an inch.
value.left {number} left The left margin, in hundredths of an inch.
value.right {number} right The right margin, in hundredths of an inch.
value.header {number} header The header offset, in hundredths of an inch.
value.footer {number} footer The footer offset, in hundredths of an inch.

Return Value

If no value is set, returns the margins for printing; otherwise, returns the print setting information.
Example
This example sets print margins.
activeSheet.setRowCount(3, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setColumnCount(3, GC.Spread.Sheets.SheetArea.viewport);

activeSheet.suspendPaint();
            //set value
            for (var r = 0, rc = activeSheet.getRowCount(); r < rc; r++) {
                for (var c = 0, cc = activeSheet.getColumnCount(); c < cc; c++) {
                    activeSheet.setValue(r, c, r + c);
                }
            }
activeSheet.resumePaint();

$("#button1").click(function () {
var printInfo = new GC.Spread.Sheets.Print.PrintInfo();
printInfo.headerLeft("Header Left");
printInfo.headerCenter("Header Center");
printInfo.headerRight("Header Right");
printInfo.footerLeft("Footer Left");
printInfo.footerCenter("Footer Center");
printInfo.footerRight("Footer Right");
printInfo.margin({top:75, bottom:75, left:20, right:20, header:10, footer:20});
activeSheet.printInfo(printInfo);
spread.print(0);
   });
Remarks
value.top {number} top The top margin, in hundredths of an inch.
value.bottom {number} bottom The bottom margin, in hundredths of an inch.
value.left {number} left The left margin, in hundredths of an inch.
value.right {number} right The right margin, in hundredths of an inch.
value.header {number} header The header offset, in hundredths of an inch.
value.footer {number} footer The footer offset, in hundredths of an inch.
See Also

Reference

PrintInfo type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.