0

I have a script that created a menu in a spreadsheet. When I click on the menu option, it asks for what line I want to print and it sets the data in another sheet (formatted for printing). I want to be able to open the print window of one of my sheets. Is there any way to achieve this?

I don't want to export the pdf automatically because I want to be able to choose the printer and the page format.

Thank you

TheMaster
  • 45,448
  • 6
  • 62
  • 85
Steven
  • 33
  • 1
  • 10

1 Answers1

1

This functionality is currently not possible in Google Apps Script. There is no option to automate opening the print dialog.

As a workaround, you could programmatically export the Sheet you want to print as a PDF and use Apps Script's MailApp to mail it to your printer.

If you are still interested in this feature and would like to communicate it to the Google Sheets team, I suggest you create a Feature Request in the Google's Public Issue Tracker.

carlesgg97
  • 4,184
  • 1
  • 8
  • 24