Stack Overflow
Stack Overflow

Questions tagged [google-docs]

Questions related to interacting with Google word processing Documents programmatically. Usage questions about the web application should be posted at Web Applications Stack Exchange.

Google Docs is a cloud-based application and service for creating and collaborating on word processing documents. The service supports an internal API for Google Apps Script as well as an External API.

Usage questions about the web application should be posted at Web Applications Stack Exchange or the Google Drive Help Center instead of here.

Note: Google has historically used the brand "Google Docs" to encompass a suite of products, but since conforming to that would introduce ambiguity here, the tag is specifically for word processing documents while refers to the suite.

3539 questions
583
votes
47 answers

wget/curl large file from google drive

I'm trying to download a file from google drive in a script, and I'm having a little trouble doing so. The files I'm trying to download are here. I've looked online extensively and I finally managed to get one of them to download. I got the UIDs of…
Arjun
  • 5,978
  • 3
  • 12
  • 10
194
votes
4 answers

Get first item from Split()

I use the SPLIT function to split a string which looks something like 1.23/1.15. Right now it yields two cells, as it should. But how do I get a certain element from the result? I would like to do something like this: SPLIT("1.23/1.15", "/")[0] to…
filur
  • 2,116
  • 6
  • 24
  • 47
175
votes
9 answers

How to turn off page breaks in Google Docs?

How do I turn off page breaks in Google Docs so I just have a single continuous scrolling document? I don't think this method applies anymore. I never want to print out my Google Docs. The page breaks are distracting and mess up my formatting. (For…
Let Me Tink About It
  • 15,156
  • 21
  • 98
  • 207
168
votes
8 answers

How To Format A Block of Code Within a Presentation?

I am preparing a presentation using Google Slides, though I can also work on the presentation within Open Office that will include code snippets. Is there any easy way to perform basic syntax highlighting on the code snippets with either Google…
Noah Goodrich
  • 24,875
  • 14
  • 66
  • 96
164
votes
7 answers

How to number the headings in a Google Docs/Drive document?

Is it possible to number the headings in a Google Docs/Drive document?
ZehnVon12
  • 4,026
  • 3
  • 19
  • 23
70
votes
5 answers

Count number of cells with any value (string or number) in a column in Google Docs Spreadsheet

I have several columns in Google Spreadsheet. I would like to count how many cells have a value (number or string) and display that number at the top of the column. For example: Hello World 123 Some string The above column would give me the…
steakpi
  • 953
  • 1
  • 6
  • 11
66
votes
8 answers

How to define global variable in Google Apps Script

I see most examples from Google is they use only functions in a single giant script. e.g. https://developers.google.com/apps-script/quickstart/macros But in our style, we usually write all functions under a single namespace, such as MyCompany =…
Ryan
  • 10,041
  • 27
  • 91
  • 156
58
votes
3 answers

Collapsing Elements in a Google Doc With Google Apps Script - Is This Possible?

I'd love to be able to collapse and expand sections in my Google Docs document, making large documents easier to navigate. I was wondering if this is possible with Google Apps Script, or if I'd be wasting my time trying to find a way.
Squis
  • 921
  • 2
  • 8
  • 14
55
votes
2 answers

Alerts when navigating away from a web page

When I try to close my Google docs tab with unsaved changes, this is what I get in my browser (FF 3.5). Are you sure you want to navigate away from this page? You have unsaved changes in this document. Click Cancel now, then 'Save' to save…
Vijay Dev
  • 26,966
  • 21
  • 76
  • 96
52
votes
7 answers

On Google Spreadsheet how can you query 'GoogleFinance' for a past exchange rate?

I'd like to know if it is possible to query a past exchange rate on Google Spreadsheet. For example; using formula =GoogleFinance("CURRENCY:USDEUR") will return the USD/EUR rate at this present moment. How can you retrieve a historic rate?
antr
  • 867
  • 1
  • 9
  • 19
51
votes
1 answer

How does Google Docs deal with editing collisions?

I've been toying around with writing my own Javascript editor, with functionality similar to Google Docs (allowing multiple people to work on it at the same time). One thing I don't understand: Let's say you've got User A and User B connected…
MatthewSot
  • 3,516
  • 5
  • 39
  • 58
49
votes
7 answers

Convert a Markdown text file into a Google Document using Appscript?

I am trying to migrate a load of documentation which was written in markdown into a Google Doc so it can be used by our marketing department. Is there a mechanism using appscript/ Google Docs Api that I can import a file and convert it to a Google…
UKDataGeek
  • 6,338
  • 9
  • 46
  • 63
49
votes
5 answers

Google Docs - Table of contents with paging

I am working on my Google Docs file and wondering if someone knows how it is possible to make a table of contents with page numbering ? The built-in table of contents won't show numbering. Thanks a lot.
user3580316
49
votes
2 answers

Debugging a custom function in Google Apps Script

I am trying to create my first custom function for a Google Spreadsheet in Apps Script and I am having a hard time using the debugger. I am working on the custom function demo code from the Google documentation and I have set a breakpoint in the…
Jpsy
  • 20,077
  • 7
  • 118
  • 115
48
votes
2 answers

Is it possible to send HTTP request from inside Google docs?

I want to send an HTTP request to some REST service from Google drive spreadsheet. Is this possible?
Muhammad Hewedy
  • 29,102
  • 44
  • 127
  • 219
1
2 3
…
99 100