Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-docs]

Better asked at WebApps.StackExchange.com unless specifically involving your computer setup.

1
vote
2answers
32 views

How focus on the document after find?

I'm filling a column after finding a row via a search on the name column. So I do CTRL + F, type the name, and click the the cell with mouse to fill it. Is there a way to do this without using the ...
1
vote
1answer
8k views

How to calculate percentage in Google Docs [closed]

I have this google-doc: https://docs.google.com/spreadsheet/ccc?key=0Avl3X68NxHC-dFY2YWgzTnRVZm1xaWlBTFl6TU9NTkE&usp=sharing Now I am trying to calculate the average (=average()) of the ...
1
vote
1answer
508 views

How can I auto-share anything sent to one Drive account with another?

People sometimes share Docs with my rarely used Google account. So I have to email them and ask them to use my main Google account instead. It's a hassle for them and for me, plus it slows down our ...
0
votes
1answer
121 views

Are spreadsheet programs inherently unsuitable for “one row=one case” data?

Often when I'm working with large data sets, I structure the data in a way where every row equals one specific case. For example, in a psychological experiment, I input the data so that all data ...
20
votes
3answers
17k views

How do I get Google Drive to open text files with arbitrary extensions as text files?

I have text files on Google Drive that do not end with the .txt suffix (such as: .r, .bas, .awk...). I want to view them using the Drive Notepad app, but it does not recognize the files as text. Is ...
8
votes
3answers
22k views

Opening .pdf's on Google Drive using Adobe Acrobat

Note: this is a question about Google Drive, not Firefox options. I've been using Google Drive and Docs a lot, so I tend to keep .PDFs on Drive as well just for convenient storage. But I don't like ...
0
votes
1answer
661 views

Best way for bidirectional referenced table rows for double-entry booking

I want to move to a Google Spreadsheets setup to handle my private booking. Currently I have four tables: Overview Accounts Income Outcome Except of "Overview" all share following columns: Date ...
0
votes
1answer
5k views

Auto-Open PPT, DOCX, Etc in chrome?

I like how in chrome you can open .PDF files with the built in PDF reader (I believe it uses the adobe reader framework). Is there a way to have chrome open MS office files in google drive by default?...
0
votes
1answer
1k views

Copy distinct values in excel from one range to another

Suppose I have a table like this: A B food 12 cars 30 cars 40 food 10 food 14 living 100 fun 30 food 40 I'd like to copy all distinct values from column A to some other ...
2
votes
4answers
22k views

How to Unhide column A in Excel and Google Doc?

Let's say I hide column A in excel or in google doc, how can I unhide it (show column A again). Column A is the most left column. I have column B,C and D etc...
6
votes
2answers
1k views

Is it possible to access and edit Google documents directly from Libreoffice?

I'd like to work with a Google spreadsheet directly inside Libreoffice, without having to export and import it, in order to automatically reflect the changes on the online file. Basically, I'm looking ...
3
votes
3answers
64k views

How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel?

Usually I would just calculate the difference of each row like this: =B1-A1 Then I would sum up the values of the column like this =SUM(C1:C10) and get my desired value. I don't want the C-column. ...
1
vote
2answers
319 views

Do Google Drive and Ubuntu One have the same concept?

Do Google Drive and Ubuntu One have the same concept? I just have an Ubuntu cloud account and Google Docs.
0
votes
0answers
96 views

Place multiple columns onto one line [duplicate]

Let's say I have a table in a spreadsheet that works like a calendar: Jan Fev Mar ... 1 5 7 1 2 3 4 9 3 8 3 1 4 2 9 0 5 2 1 2 ... And so on... I need to make a chart that ...
0
votes
1answer
3k views

Google spreadsheets drop down not compatible with MS Excel

I've created a drop down list on a google docs spreadsheet but when I download the spreadsheet and open it up under excel, the drop down functionality is lost and only the first item is shown. I have ...
5
votes
1answer
3k views

Google Docs Document Private Comment

I have access to a collaborative Google Docs document on which I would like to make notes in preparation for a meeting (I am not the document owner). I would like to avoid wasting paper, so I would ...
-1
votes
2answers
946 views

Google Drive and sync?

Two questions please: Where are Google Drive offline docs stored in my computer? which folder ? (*when accessing docs.google.com/offline) I have a text file in my Google Drive. When I click on it, I ...
2
votes
2answers
72 views

How to test which MS Word files can be correctly edited in Google Docs?

Is there a way to test/verify which MS Word files can be correctly edited in Google Docs and no formatting will be lost if files are exported back to MS Word format? Basically, I have quite a number ...
1
vote
2answers
530 views

Print > Save as PDF - Saved to Google Docs, not local drive

Recently I gave the Print > Save to Google Drive option in Chome, and it works well. All my web-pages I use goes to my Google Drive account as PDF files. My problem is, whenever I use the Save as PDF ...
6
votes
1answer
17k views

Can I link to another page in Google Docs? [closed]

I'm creating a large document (text, not presentation) in Google Docs, and I want to be able to link to other pages in the same document (like a pdf or # in the url). So far all I've found is how to ...
1
vote
0answers
63 views

Shared online document editing that automatically identifies who wrote what

I'm just wondering if there's a shared online document editing tool out there that identifies who wrote what. You'd think Google Docs would be the perfect tool but annoyingly, there's no automatic ...
0
votes
1answer
1k views

Reference whole sheet in another sheet - reference dynamically NOT copy + paste

I have multiple sheets relating to each room in a house, I also have a master sheet showing the overview of the whole house, what id like to do is pull all the data from the room sheets into the ...
7
votes
4answers
27k views

Setting Google Drive to open Google Docs files with Chrome

By default, Google Drive opens Google Docs files with the default browser, which is Firefox in my case. Can I set Google Drive to open Google Docs files with Chrome?
8
votes
1answer
20k views

How do I save a pdf file to Google Drive?

If I have opened a PDF file in Chrome with its plug-in Chrome PDF viewer, how can I save it to Google Drive directly instead of downloading it first and uploading it? Is there an extension that could ...
7
votes
4answers
11k views

Google Docs drawings to Visio

Is there a way to export drawings made with Google Docs to Visio? Maybe through some other software. I can see that Lucidcharts supports both Google Drive and export to Visio, but does it actually ...
1
vote
1answer
75 views

How to use Google Docs as you would Dropbox (or any other online backup site)

What I would like to do is have files sync in the background with my Google Docs account, both up, and down. Is there any way to do this? I use Mint 11, if it helps. Thanks!
52
votes
11answers
81k views

Is there a simple method to copy an image from Google Docs to the local clipboard?

Google Docs uses a 'web clipboard' approach for cut and paste that works very well so long as the paste target is another Google doc. However, I don't know how to easily copy an image from the Google ...
0
votes
1answer
191 views

Google Docs / Exel - need to know how to add formula

I'm using Google Docs / Exel and can't work out how or where to add a 'formula'. I have a column "i" which is the number of items. I have another column "j" which is the cost of those items. Column ...
3
votes
4answers
22k views

Excel lookup data from google docs spread sheet

Can excel lookup values from a spreadsheet in google docs? I would like my current excel forms to be able to lookup data from a spread sheet that used to be held on our server but now is a google ...
6
votes
4answers
11k views

How to open a link with only a keyboard on Google Docs

I wanted to know if anyone have any experience with using Google Docs with only a keyboard? How do I open a link there? The only solution I could find was to use Microsoft’s MouseKeys option but it’s ...
0
votes
0answers
132 views

Google docs upload not working on OS X and firefox

I' d like to use Google Docs with Firefox on my OS X 10.7 . Unfortunately I cannot upload any documents. I think this is because I don't have a Java Plugin. How can I get this working?
1
vote
1answer
2k views

Is it possible to use Google Docs Viewer to view files already in Google Docs?

The title is a little confusing. I'll elaborate. As far as I can tell, the Google Docs Viewer tool accepts a link to a raw document file (e.g. .doc, .pdf, et. al.), and renders its contents in the ...
-1
votes
1answer
209 views

Will Google Docs break my Word Document [closed]

I have a word document that I want to work with in Google docs. How can i know it will not be broken (That i cant get it back as a word document comparable to the one I uploaded, with the changes i ...
0
votes
2answers
2k views

Can I use Illustrator or InDesign to make a Google Doc look good?

I've just finished collaborating on a document in Google Docs with some colleagues. The content is perfect and the formatting is pretty good, but I'd like to tweak the formatting a little more before ...
1
vote
3answers
297 views

Google Documents keyboard shortcut to jump to editor mode and other cross-browser issues

I considered posting in webapps, but since it is partly a browser issue, I chose this forum. In Firefox, I notice that when I open an existing Google doc or start a new one, I am not automatically in ...
5
votes
1answer
2k views

Chrome and Firefox will not stop loading Google Docs

When I view any Google Docs document in Chrome, the tab will not stop loading. It loads, stops for a second, then starts loading again and as far as I can tell does not stop. The "x" button does not ...
1
vote
0answers
537 views

How can I create a PDF with form fields from a collaboratively edited source document?

I want to create a PDF document with a fill-in form. The source of the document is right now Google Docs, so that my team can edit it collaboratively with ease. However, Google docs doesn't support ...
0
votes
1answer
31 views

Looking for a service which can replicate data from SharePoint to Google Docs?

Is there a service which can replicate data from SharePoint to Google Docs?
7
votes
5answers
1k views

App created in spreadsheet vs programming a full application - is there a middle ground? [closed]

A colleague has a home-grown application in Google Documents, that involves users filling in a form, alternative questions being asked depending on what the answers are, and then outputting a ...
6
votes
1answer
1k views

How can I edit a google doc with vi and automatically update the original doc in the cloud when I write the file?

I'm using ubuntu 11.04. I have installed googlecl which claims to allow me to edit google doc files with vim. I have a google doc "test": google docs edit --title "test" --editor vim opens the file ...
1
vote
1answer
603 views

Is there a Chrome browser extension for managing Dropbox files inside Google Docs?

I would like to be able to edit Dropbox files inside Google Docs web interface. Is it possible?
8
votes
3answers
663 views

How to print/upload (a web-page) directly into my Google Drive account?

Is it possible to, from the OS X 10.6 print dialog, print the web-page directly into my Google Documents account? I can save as PDF and upload it, but, well, I want to cut out the middleman (ie, me; ...
3
votes
1answer
2k views

How to synchronize SugarSync and Google Docs automatically?

I would like to be able to edit one of my SugarSync files directly from a Google Docs interface and save it online directly to SugarSync (and then be able to go back to my home computer and have the ...
0
votes
1answer
145 views

Windows 7 Google Print Service

I'm wondering if there's any way to use a custom Windows 7 print service to send documents directly to Google Docs. My end goal is to use Google Cloud Print to be able to print any document from my ...
58
votes
10answers
155k views

Formula for updated currency exchange rates in Excel or other spreadsheets?

What kind of spreadsheets support a formula like the following: =exchangeCurrency("USD"; "EUR"; 3000) The result should be 3000 USD exchanged into Euros. Possibly a date could be provided for a ...
1
vote
2answers
4k views

How to open Gmail, Google Calendar, Google Docs in the same tab

I don't want to open those applications in separate tabs because it is annoying. Anyone, knows any solution?
5
votes
1answer
213 views

Is there a clipboard manager on the cloud?

I'm looking for a service like Google Cloud Clipboard which can be used not only from Google Docs but directly from my PC (Windows 7 SP1). Is it possible?
1
vote
1answer
814 views

Any way to make interactive graphs in LibreOffice like Google Doc's Trend chart?

Google Docs has a nice trend viewer that can be created just like any other chart: Is there any way to get an interactive graphic like this in OpenOffice? Manually adjusting the axes is really ...
6
votes
4answers
19k views

Is there a way to mount Google Docs like a drive on the Mac?

I know that I can access Google Docs from Cyberduck and add/change docs. But is there a way to mount Google Docs so I can access it like a drive?
2
votes
1answer
340 views

Mirror local directory to Google Docs

I would like to use Google Docs to backup certain directories on my local machine. Trying to do this manual however is quite tedious as I have to keep track of which files have already been uploaded. ...