Editing Google Docs and Spreadsheets

[https://drive.google.com/ Google drive]

== search google drive ==
I used the #keyword-terms as #HashTag for better searching purpose. I found it's different between - & _ when naming the files. {{access | date = 2015-08-17}}

case1: input keyword: {{kbd | key=<nowiki>aaa-bbb</nowiki>}} & return the results:
* found the files which filename contains {{kbd | key=<nowiki>aaa-bbb</nowiki>}} 

case2: input keyword: {{kbd | key=<nowiki>aaa_bbb</nowiki>}} & return the results:
* found the files which filename contains {{kbd | key=<nowiki>aaa_bbb</nowiki>}} & {{kbd | key=<nowiki>aaa-bbb</nowiki>}} 

case3: input keyword: {{kbd | key=<nowiki>aaa bbb</nowiki>}} & return the results:
* found the files which filename contains {{kbd | key=<nowiki>aaa-bbb</nowiki>}} {{exclaim}} But NOT {{kbd | key=<nowiki>aaa_bbb</nowiki>}} 

case4: input keyword: {{kbd | key=<nowiki>aaabbb</nowiki>}} (without space separated) & return the results:
* found the files which filename contains {{kbd | key=<nowiki>aaa-bbb</nowiki>}} {{exclaim}} But NOT {{kbd | key=<nowiki>aaa_bbb</nowiki>}}


{{Tips}} 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 ==
[[Microsoft Excel]]

== Upload Microsoft Word file to Google Docs ==
* {{exclaim}} When [https://support.google.com/drive/answer/2424368?co=GENIE.Platform%3DDesktop&hl=en 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 [https://drive.google.com/drive/settings settings page] of Google Drive, do not select the option "Convert uploaded files to Google Docs editor format".

== Presentation ==
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:
<pre>
<iframe src="https://docs.google.com/presentation/d/1JW8pAVOf7eHH6gm072etM2gLsQd8E5h5u75k44QuNCk/embed?start=false&amp;loop=false&amp;delayms=3000" frameborder="0" width="480" height="389" allowfullscreen="true" mozallowfullscreen="true" webkitallowfullscreen="true"></iframe>
</pre>

{long id} of this presentation file is 1JW8pAVOf7eHH6gm072etM2gLsQd8E5h5u75k44QuNCk

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

== Post to MovableType from Google Docs ==
=== MT 3.x ===
check [http://planetoid.info/blog/archives/2006/10/22/000647.html Post via Google Docs]



=== MT 2.x ===
* API: MovableType API
* URL: http://YOURBLOG/PATH/TO/mt-xmlrpc.cgi 
** If you met the [http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.4 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 ==

<references />


[[Category:Blog]] [[Category:Google]] 
[[Category:spreadsheet]] [[Category:Excel]]
[[Category:Data Science]]
[[Category:Search]]