SpreadJS 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 GcSpread.Sheets.PrintInfo();
var returnValue; // Type: Object
returnValue = instance.margin(value);
function margin( 
   value : Object
) : Object;

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

The margins for printing.
Example
This example sets print margins.
activeSheet.setRowCount(3, GcSpread.Sheets.SheetArea.viewport);
activeSheet.setColumnCount(3, GcSpread.Sheets.SheetArea.viewport);

activeSheet.isPaintSuspended(true);
            //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.isPaintSuspended(false);

$("#button1").click(function () {
var printInfo = activeSheet.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.