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
8
votes
2 answers

Render HTML to a Google Doc using app script?

We work using Google Drive, Docs, etc. Background of the problem: One of our departments needs to print hundreds of emails to file away, with page information included. We currently have a Google web app that takes the contents of an gmail thread,…
A Kirby
  • 83
  • 1
  • 3
8
votes
1 answer

Apply conditional formatting in Google Docs if current cell exists in a range

Very simply, I am attempting to highlight a cell if that cell matches (exactly) with a different cell from a different column (in a different sheet, specifically). For example, I have an 'Active' and 'Inactive' sheet in my Google Docs Spreadsheet. …
A.B. Carroll
  • 2,404
  • 2
  • 17
  • 19
8
votes
3 answers

Open Source Web PDF Viewer?

Is their any Open Source Web PDF Viewer? Which has good api through which I can modify the looks of the viewer? I had tried the Scribd, Google Docs, FlexPaper , and this also. But it is not giving me, as I want. Then i had downloaded the shadowbox…
Nitz
  • 1,690
  • 11
  • 36
  • 56
8
votes
3 answers

Online Collaborative Schema Design (leverage google docs?)

I'm looking for an online, collaborative database schema designer. App is for MySQL specifically, but generic DB designer is fine too. It's important that it can handle revisions (history of changes). This looks cool, and I could host it on a…
ack
  • 14,285
  • 22
  • 55
  • 73
8
votes
1 answer

Apply conditional formatting to compare multiple rows and columns to a reference column

I have a Google sheet of this form:    A   B   C   D   E 1 A1 B1 C1 D1 E1 2 A2 B2 C2 D2 E2 3 A3 B3 C3 D3 E3 4 A4 B4 C4 D4 E4 5 A5 B5 C5 D5 E5 The column $A contains reference values to which I want to compare the rest of the table. The formatting I…
user2779653
  • 918
  • 1
  • 9
  • 26
8
votes
3 answers

How to programmatically create a Google Docs spreadsheet WITH CONTENT?

I have found multiple StackOverflow questions dealing with how to create or edit Google Doc spreadsheets using the Google Spreadsheets API, or older API's. However, this Spreadsheets API seems to be part of the "gdata" library, which to my…
Steve Perkins
  • 11,520
  • 19
  • 63
  • 95
8
votes
5 answers

How to merge the two cells of a table in a Google text Document without this weird result?

I've writen this function (thanks, @Mogsdad) to merge cells in a table in a text google document, like this: function onOpen() { // Add a menu with some items, some separators, and a sub-menu. DocumentApp.getUi().createMenu('Sample') …
craftApprentice
  • 2,697
  • 17
  • 58
  • 86
8
votes
1 answer

How to copy content and formatting between Google Docs?

I need to copy the content of a Google Document, and append it to another Document. If I use something like this: newDoc.getBody().appendParagraph(template.getText()); ...I get the text, but lose the formatting that was in my original file. (Bold,…
craftApprentice
  • 2,697
  • 17
  • 58
  • 86
8
votes
4 answers

"Cannot call DocumentApp.getUi() from this context" error

function createAndSendDocument() { // Create a new document with the title 'Hello World' var ui = DocumentApp.getUi(); var response1 = ui.prompt('What should be Name of your Document', ui.ButtonSet.YES_NO); var doc =…
Adit Jain
  • 151
  • 2
  • 3
  • 6
8
votes
1 answer

Google Docs Spreadsheet display data from row matching a criteria

Basically, I would like Sheet 1 to pull data FROM Sheet 2, renamed to 'Loot'. However, the data that is pulled from 'Loot' can only be from a specific column, and two other cells in the same row must contain specific data from Sheet 1. Example:…
user2103481
  • 151
  • 1
  • 5
8
votes
4 answers

setting up script to include google docs form data in email notification

I've setup a form using googledocs. I just want to have the actual data entered into the form emailed to me, as opposed to the generic response advising that the form has been completed. I have no skill or experience with code etc, but was sure i…
user1872449
  • 81
  • 1
  • 1
  • 2
8
votes
3 answers

Why does Google Docs operational transformation err on the side of deletion?

Tried out this experiment today: opened two offline editors for a Google document. In one, I bolded the first word. In the second, I deleted it. Regardless of which client I turn on first, the word always ends up deleted. First off, why is this the…
ehfeng
  • 3,807
  • 4
  • 33
  • 42
8
votes
3 answers

How to know if a google account is under a google apps domain?

I am working on an app that allows user to share their Drive files to friends. But there is a problem of Google App Account, like someone@somadomain.com, of which files cannot be shared with people who are not under that domain. Although the share…
xiaowl
  • 5,177
  • 3
  • 27
  • 28
8
votes
3 answers

Edit google form source while keeping it within the google environment

Is it possible to edit Google Forms to allow data validation and use of some javascript or similar tools on it to give an advanced feel to the form. While making sure that the form isn't removed from the google environment or atleast is able to feed…
Rijo Simon
  • 777
  • 3
  • 15
  • 35
7
votes
3 answers

TinyMCE: Copy-Paste from Google Docs

Folks, My company needs to support the following workflow: - There's rich content getting created in Google Docs (with simple formatting - bold/italic, as well as hyperlinks) - That content is then pasted into an internal CMS that uses TinyMCE.…
Alex Weinstein
  • 9,823
  • 9
  • 42
  • 59
1 2 3
…
99 100