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
1
vote
2 answers

Android Online PDF Load - Preview Not available error via Google Doc

The core part of my application is load PDF online and user have access to download it as per their given rights. The problem I am facing is that I want to load pdf online. After many research I have found that, There are likely two ways to show pdf…
KishuDroid
  • 5,411
  • 4
  • 30
  • 47
1
vote
2 answers

Changing border colors in GAS (and *not* changing some)

Follow up to this question using Google Apps Script: Set border color & style in spreadsheet programmatically The format is in this order: .setBorder( top, left, bottom, right, vertical, horizontal, color, style ) According to the…
1
vote
1 answer

Using google spreadsheet values for a drop down in a Google Docs Side bar

There doesnt seem to be much out there r.e. google docs side bars. Other than the fantastic work done by Mogsdad. His cursor position tool is 1/2 of what I need already (How to poll a Google Doc from an add-on). I have a google sheets template with…
Tiana
  • 201
  • 1
  • 4
  • 14
1
vote
0 answers

Get page number of selected paragraph

I would like to get a page number of selected paragraph. I want to create something like content. Now i have this: while (searchResult = body.findElement(searchType, searchResult)) { var par = searchResult.getElement().asParagraph(); if…
1
vote
1 answer

Google Docs viewer gives a blank space

I'm using the Google docs viewer:
Many times, though, when I load the page, I…
Dave
  • 11
  • 1
  • 2
1
vote
1 answer

Invalid BACKGROUND_COLOR?

Can anyone tell me why this code is returning an error that says, "invalid color?" It seems to be referring to the BACKGROUND_COLOR attribute. But I can't figure out why. function myFunction() { var bibiDoc = {}; …
GMath314
  • 73
  • 1
  • 1
  • 7
1
vote
2 answers

Google Apps Script to find URLs in body and format them as hyperlinks

I have a block of text generated from a command line script which spins up a number of virtual machines. The text output contains instructions on how to access webapps on the virtual machines, so something like: TrainingMachine01 Username: [user]…
Jangari
  • 690
  • 4
  • 12
1
vote
0 answers

Google Spreadsheet table with sums and easy row adding

I simply can't find nothing on google, I want to create a google spreadsheet table with sums and counts. The sums and counts should be dynamic to the table rows. It should be easy to add a row like in excel when you are on the last column, you click…
Tzook Bar Noy
  • 11,337
  • 14
  • 51
  • 82
1
vote
1 answer

Getting a list of active file viewers with apps script

I've been googling for a while but have come up with no results that tell me I can't, but no results telling me I can. What I'm looking for is a way in apps script (or anything in their .NET/Java/Python...API) to give me a list of people who are…
Bmo
  • 1,212
  • 11
  • 34
1
vote
1 answer

How to set table width in Google Apps Script

When a table is created in a Google Docs file, it is full width, stretching from one margin to another. I have created some tables, then amended the margins and created a few more. That has left me with tables of differing widths. I could re-size…
1
vote
1 answer

Excluding specific values from a range of cells

I would like to remove #N/A values from being counted in my sparklines. #N/As are produces with =NA(). My formula is =SPARKLINE(D5:AN5, {"ymin", 0}). How do I exclude specific values from the "D5:AN5" range? I can't seem to find a way to do it.
Kraken
  • 295
  • 1
  • 3
  • 13
1
vote
1 answer

Google Apps Script (Google Docs) - trigger on comment add or change?

I am searching thorugh Google Apps Script documentation and I don't find how to make a trigger if comment is added or changed in a google document. Under ElementType section (https://developers.google.com/apps-script/reference/document/element-type)…
1
vote
1 answer

How to get permission to run a google app Script from a Chrome Extension?

I'm trying to capture selected text in a chrome extension and put it in a Google Doc, however whenever I try to run the script with the packaged extension I get the following errors. The given range does not belong to the current selection's…
1
vote
4 answers

Showing .DOCX file in android web view using google doc giving error

I have to show different type of documents from a remote URL link in my application. I have use Google Doc in a webview like this private WebView mWvHome = (WebView) view.findViewById(R.id.wv_home); mWvHome.setWebChromeClient(new…
1
vote
1 answer

GDocs ImportHTML/XML not getting proper data

I have a simple Google Spreadsheet's question. I'm attempting to pull in a table and am not having luck with ImportHTML, it will only pull the first top cell and duplicates it somehow. I also tried ImportXML, using XPath Helper to get the proper…
Donny
  • 13
  • 4