0

The below code generates a two-page document with a 1" margin around both pages. Need to adjust it to around 0.5". I've tried a few workarounds, but none seemed to work.

I've tried to implement the workaround mentioned on PDF margins - Google Script but failed.

function generatepdf() {
  reset_rows();
  hideprow();
  importdata_summary();

  var sourceSpreadsheet12 = SpreadsheetApp.getActive();
  var destSheet6 = sourceSpreadsheet12.getSheetByName("Request_Info");
  var specsheet = destSheet6.getRange('C2:C2').getValue();
  var companyname = destSheet6.getRange('C5:C5').getValue();
  var ref1 = destSheet6.getRange('G4:G4').getValue();
  var pdfName = specsheet + "_" +  companyname + "_" + ref1 + ".pdf" ;

  showSheet(specsheet);
  showSheet("Quotation");
  hideSheet("Request_Info");
  hideSheet("Summary");

  var sourceSpreadsheet = SpreadsheetApp.getActive();
  
  // Get active sheet.
  var sheets = sourceSpreadsheet.getSheets();

  var sourceSheet10 = sourceSpreadsheet.getSheetByName('Request_Info');


  // Get folder containing spreadsheet to save pdf in.
  var parents = DriveApp.getFileById(sourceSpreadsheet.getId()).getParents();
  if (parents.hasNext()) {
    var folder = parents.next();
  }
  else {
    folder = DriveApp.getRootFolder();
  }
  
  // Copy whole spreadsheet.
  var destSpreadsheet = SpreadsheetApp.open(DriveApp.getFileById(sourceSpreadsheet.getId()).makeCopy("tmp_convert_to_pdf", folder))

  var destSheet = destSpreadsheet.getSheets()[0];


  // Replace cell values with text (to avoid broken references).
  var sourceRange = sourceSheet10.getRange(1,1,sourceSheet10.getMaxRows(),sourceSheet10.getMaxColumns());
  var sourcevalues = sourceRange.getValues();
  
  var destRange = destSheet.getRange(1, 1, destSheet.getMaxRows(), destSheet.getMaxColumns());
  destRange.setValues(sourcevalues);

  // Save to pdf.
  var theBlob = destSpreadsheet.getBlob().getAs('application/pdf').setName(pdfName);
  
  var newFile = folder.createFile(theBlob);

  // Delete the temporary sheet.
  DriveApp.getFileById(destSpreadsheet.getId()).setTrashed(true);
  
  //cleardata

  var sourceSheet3 = sourceSpreadsheet.getSheetByName('Quotation');
  sourceSheet3.getRange('J6').setValue(sourceSheet3.getRange('J6').getValue() + 1);

  showSheet("Request_Info");
  var sourceSheet5 = sourceSpreadsheet.getSheetByName('Request_Info');

  showSheet("Request_Info");

  hideSheet(specsheet);
  hideSheet("Quotation");
  showSheet("Summary");
  //reset_rows();
}
Rubén
  • 34,714
  • 9
  • 70
  • 166

0 Answers0