Help Center Tag: google docs

Help Center Tag: google docs - Recent Posts http://www.labnol.org/forums/tags/google-docs Help Center Tag: google docs - Recent Posts en-US Sun, 22 Nov 2009 05:52:10 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q http://www.labnol.org/forums/search.php arrestinquiry1 on "How can I escape a character in Google Spreadsheets?" http://www.labnol.org/forums/topic/how-can-i-escape-a-character-in-google-spreadsheets#post-5720 Sun, 24 May 2009 22:06:53 +0000 arrestinquiry1 5720@http://www.labnol.org/forums/ Thanks - I was looking for this myself. <a href="http://ezinearticles.com/?Arrest-Inquiries---What-Can-You-Get-From-an-Online-Arrest-Inquiry-Service&id=2162973" rel="nofollow">Arrest Inquiry</a> <a href="http://ezinearticles.com/?Police-Records-Where-Can-I-Find-Free-Police-Records?&id=2255920" rel="nofollow">Police Records</a> devnullius on "How can I escape a character in Google Spreadsheets?" http://www.labnol.org/forums/topic/how-can-i-escape-a-character-in-google-spreadsheets#post-5719 Sun, 24 May 2009 16:18:46 +0000 devnullius 5719@http://www.labnol.org/forums/ I'm getting more feedback (and solutions) here: <a href="http://www.google.com/support/forum/p/Google%20Docs/thread?tid=5ea6ee468ed875a5&hl=en" rel="nofollow">http://www.google.com/support/forum/p/Google%20Docs/thread?tid=5ea6ee468ed875a5&hl=en</a> Thanx : ) devnullius on "How can I escape a character in Google Spreadsheets?" http://www.labnol.org/forums/topic/how-can-i-escape-a-character-in-google-spreadsheets#post-5715 Sun, 24 May 2009 02:24:39 +0000 devnullius 5715@http://www.labnol.org/forums/ Hello, Noticed a lot of Google Docs expertise on this website and in this forum, so here it goes.... I have a column D as a result from =ImportFeed(A1, "Items", False, 50) which contains text. Some text in the cell's in D is surrounded by "quotes". I don't want those quotes, and I want them filtered / stripped / replaced / ... Isn't this possible? I am considering Substitute SUBSTITUTE(text, search_text, new text, occurrence) Substitutes new text for old text in a string. Text is the text in which text segments are to be exchanged. Search_text is the text segment that is to be replaced (a number of times). New text is the text that is to replace the text segment. Occurrence (optional) indicates how many occurrences of the search text are to be replaced. If this parameter is missing, the search text is replaced throughout. I don't know if I can operate that on my imported output in D, but nonetheless, First problem is that I cannot escape the character?? So I cannot do a search on the quotes in D with: substitute(*, ") or substitute(*,\") or ??? Grumbl - who can help? Thanx! Devvie Nuis Conare nullius momenti videri fortasse missilibus careant ------ All spelling mistakes are my own and may only be distributed under the GNU General Public License! – (© 1995-2001 by Coredump; 2002-9 by DevNullius) Marvin on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3924 Thu, 20 Nov 2008 23:48:42 +0000 Marvin 3924@http://www.labnol.org/forums/ I think copying and pasting in Ms-Excel will be the right way to go about it! dwiner on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3899 Mon, 17 Nov 2008 21:51:30 +0000 dwiner 3899@http://www.labnol.org/forums/ @Sparx The SHARE button on the spreadsheet is available when I am signed on to the document, i.e. when I am the owner/collaborator. The Automatic Archiving Solution sounds cool enough and is a paid service...but I don't think I'll need a paid option for my stuff...at least considering that it's not that important. Iterasi, as suggested by Amit, can be considered as a work around. The work around I currently follow is: I take a screenshot every week and email it to self...all I could think of as I'm no geek! Thank you again Sparx for you invaluable suggestions. @Amit: Thank you so much Amit, I shall try Iterasi as a work around. gameplan on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3898 Sun, 16 Nov 2008 20:51:28 +0000 gameplan 3898@http://www.labnol.org/forums/ Hey Amit. I had notified you about a crucial issue via email. Its a kind of a flaw that exists in your blog. I had notified about you in the email a couple of days ago. It seems as if you haven't read the mail. I sent it from my email address: <a href="mailto:bishal1259@gmail.com" rel="nofollow">bishal1259@gmail.com</a>. Please have a look at it. I'll forward you a copy of the same mail if you've lost it. ...Bishal Adhikary Amit on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3893 Sun, 16 Nov 2008 10:40:12 +0000 Amit 3893@http://www.labnol.org/forums/ You may even try iterasi to backup your Google Docs though one by one. Sparx on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3872 Sat, 15 Nov 2008 14:05:45 +0000 Sparx 3872@http://www.labnol.org/forums/ Looking thru a spreadsheet that I've shared with others on Google Docs, I came across this: Open the shared spreadsheet. Click the SHARE button in the top right corner. Click SET NOTIFICATION RULES. Select the options that you want and click SAVE. I don't know if it'll merely send a notification or send you the actual data that has been changed, but worth a look at least... Sparx on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3871 Sat, 15 Nov 2008 13:57:56 +0000 Sparx 3871@http://www.labnol.org/forums/ You're welcome. Unfortunately, I'm out of ideas and don't recall anything pertinent other than those detailed above. UPDATE:<a href="http://sites.google.com/site/simpleappssolutions/Home" rel="nofollow"> Automatic Archiving Solution</a> - have a look at this. Good Luck ! If you have the time / willpower / inclination, then give gDataCopier a go. What is your current solution? I mean how do you go about things at this moment? Does the owner email a copy of the worksheet to you? dwiner on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3867 Fri, 14 Nov 2008 23:40:54 +0000 dwiner 3867@http://www.labnol.org/forums/ @Sparx: I wasn't clear in my response...so this repost. Firstly, NO; the file can't be exported while in READ ONLY mode. GDataCopier/API are too geeky for me...so haven't tried. Google Doc Download GM Script needs the owner/collaborator to be signed in...moreover, this will require installation if GreaseMonkey addon to FF on all the machines on which I want to perform a backup. Though not a big deal, I would refrain from this. Syncplicity is not the solution we are looking at, but FYI, I guess this also needs the owner/collaborator to be signed in. Thank you once again Sparx. dwiner on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3866 Fri, 14 Nov 2008 23:26:39 +0000 dwiner 3866@http://www.labnol.org/forums/ @Sparx Thank you so much for the info. The first and third options need the owner/collaborator to be signed in to access the files. And I haven't tried the second option...it was too geeky for me. Sparx on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3864 Fri, 14 Nov 2008 16:58:41 +0000 Sparx 3864@http://www.labnol.org/forums/ @DWiner: Does <a href="http://www.webmonkey.com/tutorial/Create_Automated_Backups_in_Google_Docs_Using_the_GData_API" rel="nofollow">this link</a> help ? Also, you haven't answered my question: can the file be exported while it's READ ONLY? See <a href="http://lifehacker.com/software/download-of-the-day/google-doc-download-greasemonkey-script-256812.php" rel="nofollow">here</a> too. For a more geeky approach, not unlike the first one, check out <a href="http://code.google.com/p/gdatacopier/" rel="nofollow">GDataCopier</a>. And finally, although this might not work EXACTLY as you want in this particular case, also see <a href="http://www.labnol.org/internet/office/backup-and-sync-google-docs-files/5188/" rel="nofollow">Syncplicity</a> - it'll sync folders containing office docs with Google Docs. Please post back with your intentions / results so others may learn. :) dwiner on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3858 Thu, 13 Nov 2008 21:02:00 +0000 dwiner 3858@http://www.labnol.org/forums/ Isn't there any tool/utility that can do this task based on the URL I provide? Sparx on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3753 Mon, 27 Oct 2008 23:44:39 +0000 Sparx 3753@http://www.labnol.org/forums/ Can a file be exported in READ-ONLY mode? That might be the only way, AFAIK. Otherwise, you'll need to get yourself on the approved list, I guess. dwiner on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3748 Mon, 27 Oct 2008 18:09:06 +0000 dwiner 3748@http://www.labnol.org/forums/ Thnx Sparx...but that doesn't help when in READ ONLY mode. I can only simply open up the document in my browser to glance and be able to do nothing in read only mode. When I am in read only mode, I only have the browsers menu option available and not Google's menu options (which I guess is available only when the viewer has write rights). Can there be some other work around? Sparx on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3726 Fri, 24 Oct 2008 16:17:51 +0000 Sparx 3726@http://www.labnol.org/forums/ You can always click FILE > REVISION HISTORY. dwiner on "How to backup shared Google docs?" http://www.labnol.org/forums/topic/how-to-backup-shared-google-docs#post-3714 Thu, 23 Oct 2008 18:58:45 +0000 dwiner 3714@http://www.labnol.org/forums/ My employer maintains a Payroll Data sheet as a Google Spreadsheet which is shared to employees as read-only. Is there any provision to backup this shared doc so I can keep a tab on the historic data? Anurag on "RSS WITH DOCS" http://www.labnol.org/forums/topic/rss-with-docs#post-2576 Thu, 10 Jul 2008 16:58:47 +0000 Anurag 2576@http://www.labnol.org/forums/ Cristi - could you please tell me the exact address of the feed that you're trying to load inside Google Docs. Or if you can just share the Google document so that we can looking into your exact problem. OlgaMirina on "RSS WITH DOCS" http://www.labnol.org/forums/topic/rss-with-docs#post-2575 Thu, 10 Jul 2008 16:53:44 +0000 OlgaMirina 2575@http://www.labnol.org/forums/ I followed step by step the tutorial about turning Google Docs in a RSS Reader. I tried several times (using both browsers - Firefox 3.0 and IE7), but the feeds didn't load (fill the column). Thanks. Frursuack on "List of Google Shared Documents?" http://www.labnol.org/forums/topic/list-of-google-shared-documents#post-1203 Fri, 01 Feb 2008 10:15:05 +0000 Frursuack 1203@http://www.labnol.org/forums/ Thanks amit, i think this can solve my problem upto much extent. By the way, can you sometime write an article explaining about banking/investing money in life insurance plans/tax savings etc....targeting a good number of IT freshers who don't exactly know how to put their money to good use?