Google Docs and Spreadsheets

From LemonWiki共筆
Jump to: navigation, search

Google drive

search google drive[edit]

I used the #keyword-terms as #HashTag for better searching purpose. I found it's different between - & _ when naming the files. [Last visited: 2015-08-17]

case1: input keyword: aaa-bbb & return the results:

  • found the files which filename contains aaa-bbb

case2: input keyword: aaa_bbb & return the results:

  • found the files which filename contains aaa_bbb & aaa-bbb

case3: input keyword: aaa bbb & return the results:

  • found the files which filename contains aaa-bbb Icon exclaim.gif But NOT aaa_bbb

case4: input keyword: aaabbb (without space separated) & return the results:

  • found the files which filename contains aaa-bbb Icon exclaim.gif But NOT aaa_bbb


Owl icon.jpg Walkaround: If it is too difficult to search the file from many files, You may register new gmail account. Share the specific project file or folder to the new account. It will become more easier and more efficient to search.

Microsoft Excel[edit]

Microsoft Excel

Upload Microsoft Word file to Google Docs[edit]

  • Icon exclaim.gif When Upload files and folders to Google Drive, the layout of Word file after converted to Google Docs editor format may not the same with the original layout of Word file. In the settings page of Google Drive, do not select the option "Convert uploaded files to Google Docs editor format".

Presentation[edit]

Known the view mode Url of Presentation. Turn this into the downloadable Url if the owner of presentation file allowed. Sample HTML code as following:

<iframe src="https://docs.google.com/presentation/d/1JW8pAVOf7eHH6gm072etM2gLsQd8E5h5u75k44QuNCk/embed?start=false&loop=false&delayms=3000" frameborder="0" width="480" height="389" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>

{long id} of this presentation file is 1JW8pAVOf7eHH6gm072etM2gLsQd8E5h5u75k44QuNCk

  • View mode Url of Presentation ex:
    1. https://docs.google.com/presentation/d/{long id}/pub?start=false&loop=false&delayms=60000 or
    2. https://docs.google.com/presentation/d/{long id}/embed
  • downloadable Url (permission was required):
    • https://docs.google.com/presentation/d/{long id}/export/pptx?id={long id}

Post to MovableType from Google Docs[edit]

MT 3.x[edit]

check Post via Google Docs


MT 2.x[edit]

  • API: MovableType API
  • URL: http://YOURBLOG/PATH/TO/mt-xmlrpc.cgi
    • If you met the HTTP 503 code(Service Unavailable), you can switch the URL from domain name to IP address.
  • Blog ID/Title
    • Blog ID is not work!
    • Blog title: It's Case-sensitive and was not support Chinese.

references[edit]