Showing posts with label Google Docs. Show all posts
Showing posts with label Google Docs. Show all posts

Monday, December 14, 2009

Google Spreadsheets, Exporting and those Damn Gridlines

I have been piloting my business critical documents in Google Docs and I have just been floored by a limitation in the PDF exporting and printing (which generates a PDF for printing) functionality. It appears impossible to print or export a PDF of a Google Spreadsheet without the grey background grid also being included.

Google has what they generously label a workaround but it only provides a way to access a grid-less HTML page, which for printing purposes is less than ideal. Also troublesome is the fact that the workaround is slightly onerous (you need to publish the spreadsheet, modify the supplied URL, navigate to the URL and then use your browser's print function) and worse yet in my tests is not 100% effective in removing the grid lines.

This limitation means generating attractive invoices and timesheets or other structured designs with Spreadsheets is difficult or impossible. I am awaiting a more effective workaround or an actual fix from Google with baited breath. Help them get the message for voting for any or all of the currently five distinct petitions for sorting this out on Google Docs Product Ideas.