您好,没有打印出页脚的问题在于没有设置正确的margin,
因为margin中需要为页脚留出一些空间,我改动了一些代码,贴出来您参考:
- var sheet = spread.getActiveSheet();
- sheet.printInfo().showBorder(false);
- sheet.printInfo().showGridLine(false);
- sheet.printInfo().showColumnHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);
- sheet.printInfo().showRowHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);
- sheet.printInfo().orientation(GC.Spread.Sheets.Print.PrintPageOrientation.landscape);
- sheet.printInfo().footerCenter("&P/&N");
- sheet.printInfo().footerLeft("&D");
- sheet.printInfo().margin({top:0, bottom:30, left:30, right:0, header:0, footer:0});
- sheet.printInfo().centering(GC.Spread.Sheets.Print.PrintCentering.horizontal);
- sheet.printInfo().paperSize(new GC.Spread.Sheets.Print.PaperSize(
- GC.Spread.Sheets.Print.PaperKind.a4));
- console.log(sheet.printInfo());
- spread.print();
复制代码 |