Google Docs and Spreadsheets: Difference between revisions

Jump to navigation Jump to search
m
Text replacement - ": Image:Owl icon.jpg " to "{{Tips}} "
m (1個修訂)
m (Text replacement - ": Image:Owl icon.jpg " to "{{Tips}} ")
 
(46 intermediate revisions by the same user not shown)
Line 1: Line 1:
[http://docs.google.com/ Google Docs and Spreadsheets]
[https://drive.google.com/ Google drive]


== MT 3.x ==
== 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]
check [http://planetoid.info/blog/archives/2006/10/22/000647.html Post via Google Docs]






== MT 2.x ==
=== MT 2.x ===
* API: MovableType API
* API: MovableType API
* URL: http://YOURBLOG/PATH/TO/mt-xmlrpc.cgi  
* URL: http://YOURBLOG/PATH/TO/mt-xmlrpc.cgi  
Line 14: Line 53:
** Blog title: It's Case-sensitive and was not support Chinese.
** Blog title: It's Case-sensitive and was not support Chinese.


== References ==
<references />




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

Navigation menu