Widths exceeding these amounts are fine, as long as you understand that your document will be scaled down and a little less predictable. For landscape prints, you can print up to 42 rows per sheet. So, for portrait prints, you can (theoretically) print up to 56 rows at the default height. How many rows can you fit? Well, each row measures 17 pixels tall. For a sheet printed in landscape, aim for 960 pixels (10 inches). Thus, for an 8.5"x11" piece of paper, printed in portrait, your total column widths combined should equal 720 pixels (7.5 inches). To keep the 96ppi rule valid (and thus always know how big your columns will be when they print), keep your data set narrower than your paper size minus one inch. This is not a bad thing, but it makes your measurements imprecise. Past that point, Docs automatically scales down your table. Spreadsheets follow the 96ppi rule until a row becomes too wide to fit on your chosen paper size with a 0.5" margin. So the first six columns of the default spreadsheet total 7.5 inches, or a portrait letter-sized document with 0.5" margins. So the default column width of 120 pixels is actually 1.25 inches. If you follow these guidelines, you can control your print output perfectly every time.Ĭolumn widths are measured in pixels only. To solve this, I did some simple math and tested it out with a few printouts. And print options are limited to choosing paper size and orientation. ![]() Problem is, Google Spreadsheet isn't well optimized for printing (yet). I use Google Spreadsheet as a substitute for Docs when I need to create complex share-able forms or layouts. Google Docs (the word processor) cannot do advanced table functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |