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.
3,602
questions
605
votes
48
answers
858k
views
wget/curl large file from google drive [closed]
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 ...
- 6,198
209
votes
4
answers
192k
views
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 ...
- 1,844
175
votes
9
answers
227k
views
How to turn off page breaks in Google Docs? [closed]
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 ...
- 15.6k
173
votes
8
answers
209k
views
How To Format A Block of Code Within a Presentation? [closed]
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 ...
- 25.1k
170
votes
7
answers
146k
views
How to number the headings in a Google Docs/Drive document?
Is it possible to number the headings in a Google Docs/Drive document?
- 4,106
70
votes
5
answers
124k
views
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
...
- 953
67
votes
7
answers
65k
views
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 ...
- 6,572
66
votes
8
answers
157k
views
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 ...
- 10.4k
58
votes
3
answers
109k
views
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 ...
- 921
55
votes
2
answers
36k
views
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 ...
- 27.2k
53
votes
1
answer
19k
views
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 ...
- 3,576
52
votes
7
answers
56k
views
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 ...
- 867
50
votes
2
answers
56k
views
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?
- 29.5k
49
votes
5
answers
68k
views
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 ...
user3580316
49
votes
2
answers
27k
views
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 ...
- 20.5k
45
votes
4
answers
62k
views
Google Surveys -- a way to pass URL parameters into survey?
I have created a Google Survey and I want to be able to pass URL parameters into the survey so that I can track where responses are coming from. Ideally these URL parameters will be populated into ...
- 5,117
45
votes
4
answers
37k
views
What are the Google Apps MIME Types in Google Docs and Google Drive?
What are the MIME types for each of the following file extensions:
gdoc
gslide
gsheet
gdraw
- 8,530
45
votes
5
answers
20k
views
Google Docs Viewer occasionally failing to load content in iframe
I'm having an issue with the Google Docs viewer that is causing a nightmare to solve because it only happens intermittently. I'm looking for guidance on how to make the content in the iframe load ...
- 817
43
votes
10
answers
109k
views
Insert date time in google document
I would like to insert a timestamp (date and/or time) into Google Documents. The support documentation () says that there should be a keyboard shortcut, but it does not work in my environment (Win7 + ...
- 447
43
votes
1
answer
5k
views
Creating anchored comments programmatically in Google Docs
I have been unable to programmatically create a comment that is anchored to specific text in a Google Doc using an app script with the document.
Google documentation about how to create an anchored ...
- 558
40
votes
13
answers
68k
views
Download a spreadsheet from Google Drive / Workspace using Python
Can you produce a Python example of how to download a Google Sheets spreadsheet given its key and worksheet ID (gid)? I can't.
I've scoured versions 1, 2 and 3 of the API. I'm having no luck, I can't ...
- 31.2k
39
votes
5
answers
153k
views
Is it possible to force a copy of a protected Google doc? [closed]
Google docs can “lock” a page so that it’s impossible to copy from its text. This seems wrong to me; shouldn't a computer’s ability to copy and paste be intrinsic? I can’t understand how a webpage can ...
- 567
36
votes
4
answers
95k
views
Spreadsheets get unique names but ignore blank cells
I would like to use spreadsheets to get all unique names from Column A in a table but in the same time I would like blank cells to be ignored. So far I've got this formula that returns all of the ...
- 363
36
votes
5
answers
32k
views
How to force newlines in Google Apps jsdoc descriptions
I can't figure out how in a Google Apps Script to display this correctly. I need it to display new lines in the jsdoc output(e.g. when the function tooltip window comes up in a Spreadheet functions.) ...
- 521
31
votes
2
answers
82k
views
JSON import to Excel
Is it possible to script JSON calls in a macro?
I want to get a JSON string through an API connection. It looks like the problem is Excel expects the parameters to be passed in the HTML-string, but ...
- 311
31
votes
4
answers
37k
views
How do you create a document in Google Docs programmatically?
The documentation for Google Documents List API, seems to say that you can create a local document and upload it. Is there no way to actually create and edit a document on Google Docs through an API?
- 613
31
votes
3
answers
1k
views
Google docs - Access text changes realtime
Goal
Our users work in Google Docs. The text they write will be read to them as they type using text-to-speech.
It should work across as many platforms and browsers as possible.
Our solution
This ...
- 1,385
30
votes
5
answers
52k
views
Embed editable Google Docs spreadsheet without header & toolbar
I have the requirement to embed a Google Docs spreadsheet on a webpage, but it needs to be just the editable cells, without the Google navigation and toolbar at the top.
I can't find a reference to ...
- 5,862
30
votes
4
answers
11k
views
How to correct spelling in google docs using keyboard shortcut? [closed]
I would like to be able to replace a misspelled word in a Google doc with Google's recommended correction with a keyboard shortcut, instead of having to mouseover the word, right click on it, and ...
- 379
29
votes
10
answers
36k
views
Google Docs viewer returning 204 responses, no longer working, alternatives?
UPDATE 2016-11-16 9:53am EST
It appears many people are still seeing 204 responses even though Google has claimed to have "fixed" the problem. When I myself tested the loading of a document 50 times,...
- 1,945
28
votes
6
answers
6k
views
Is there a good R API for accessing Google Docs?
I'm using R for data analysis, and I'm sharing some data with collaborators via Google docs. Is there a simple interface that I can use to access a R data.frame object to and from a Google Docs ...
- 47.4k
26
votes
1
answer
34k
views
Wrong results in Google spreadsheets Lookup functions (vlookup, hlookup, match)
The following spreadsheet demonstrates a very odd behaviour of Google Spreadsheets Lookup functions. I've used these functions many times without any problem. Can anyone confirm it happens on their ...
- 481
25
votes
7
answers
5k
views
How do I prevent exposure of my password when using RGoogleDocs?
I love RGoogleDocs and use it a lot. However, I don't like entering my password all the time. Obviously I could just type the password into the R script and would never have to enter it again. But ...
- 10.4k
24
votes
2
answers
15k
views
How do I export the revision history of a gdoc to git?
I have a spreadsheet in google docs that I'd want to integrate in a git workflow (and push to github). Are there any tools (or even libraries that are gdoc version aware) that do, or help me do, that?
...
- 5,080
24
votes
2
answers
47k
views
How to add image numbers in Google Docs
I have a document in Google Docs which has a lot of images numbered sequentially. Every time I add a new image in the middle of the document I have to renumber all the image numbers along the document ...
- 990
24
votes
4
answers
15k
views
How are scrollbars in new Google Docs UI styled (esp. the arrow buttons)?
The new Google Docs UI features cool gray scrollbars.
These appear to be regular scrollbars styled with selectors like ::-webkit-scrollbar-thumb. Which is nice and accessible.
However, I can't get ...
- 33.1k
24
votes
4
answers
71k
views
Add link to open a local file in Google Docs
I have made a guide (or something like a tutorial) about my tool to share with my company. I used Google Docs to do that, and I would like to add links to open video guides. I want to know a way to ...
- 1,049
24
votes
1
answer
11k
views
VIM with Google Docs? [closed]
I finally got around to teaching myself VIM and am really liking it. I was wondering if anyone here knew of a way to set up my Google Docs to support the VIM commands?
- 899
23
votes
5
answers
49k
views
how to open specific page on Google's docs viewer
I'm using google's docs viewer to show a pdf document in a html page and I would like to open the document starting on page 20 instead of 1 for example.
There's hardly any documentation about Google'...
- 459
23
votes
4
answers
30k
views
Google docs viewer url parameters
Is there any sort of documentation on exactly what parameters you can put in the url of Google viewer?
Originally, I thought it was just url,embedded,chrome, but I've recently come accross other ...
- 1,223
23
votes
3
answers
54k
views
Google docs - automated List of tables
Is it possible to add captions to tables in Google docs?
I would like to be able to produce an automated list of tables.
For example something like this :
Any idea ?
- 4,271
22
votes
8
answers
32k
views
Get Google Document as HTML
I had a wild idea that I could build a website blog for an unsophisticated user friend using Google Drive Documents to back it. I was able to create a contentService that compiles a list of documents....
- 884
22
votes
5
answers
58k
views
How to add a hyperlink in a Google Docs using a Google Script
I have always used the insertText() function, but now I want to write a link in my google docs. The ideal would be to be able to write in HTML, but I don't know how.. it seems that it is not possible ...
- 573
22
votes
4
answers
7k
views
Convert Google Docs to Jekyll Markdown
How can I convert a Google Docs, which contains images and tables, into a Markdown file which can be published as a post using Jekyll?
Is it possible to first export the Google Docs into a PDF and ...
- 20.9k
21
votes
5
answers
13k
views
Google Docs using multiple manual criterion in DSUM
How can I manually enter multiple criterion into a DSUM function?
I can have it check a single set of criterion with: =DSUM(J3:L55, "Charge", {"Category";"Coffee"})
However changing that to =DSUM(J3:...
- 9,591
21
votes
4
answers
64k
views
Remove line break within cell google spreadsheet
Is there an easy way to remove the line breaks within each cell?
Each cell on column E, has extra line that I am having to manually remove, any easy to remove all.
- 275
21
votes
5
answers
7k
views
Prevent automatic tab insertion or conversion of spaces to tabs
Google Docs has a "feature" that sometimes converts four spaces to one tab.
Copying and pasting text does not solve this problem, because the spaces in that text are converted to tabs automatically.
...
- 11.5k
21
votes
3
answers
116k
views
Axis scale in google charts (from google spreadsheets)
I've generated chart form google spreadsheets. In my report for horizontal axis I have values: 1
,2
,3
,4
,5
,10
,20
,30
,40
,50
,100
,200
,300
,400
,500
,600
,700
,800
,900
,1000.
Chart interprets ...
- 8,782
21
votes
1
answer
6k
views
Is it possible to modify the Google Docs/Sheets right-click context menu?
It's well known on how to make a custom upper menu item (https://developers.google.com/apps-script/guides/menus), but can you append a function to the context menu when right clicking a cell or item?
- 409
21
votes
6
answers
44k
views
Integrate Google Docs into web site for content creation
I am building a self-publishing web site. I want to integrate Google Docs into my website and allow every publisher/writer to write her/his book from my website and later update the content from ...
- 1,880