Google Docs and Spreadsheets: Difference between revisions
Jump to navigation
Jump to search
| Line 30: | Line 30: | ||
== Google spreadsheet == | == Google spreadsheet == | ||
利用[[Google spreadsheet]]的函式，分析及統計可複選的問卷題目結果。 | 利用[[Google spreadsheet]]的函式，分析及統計可複選的問卷題目結果。 | ||
---- | |||
工作表或儲存格的大小限制 | |||
* EXCEL 2007: 工作表大小 1,048,576 列乘以 16,384 欄 = 17,179,869,184 個儲存格<ref>[http://office.microsoft.com/zh-tw/excel-help/HP010073849.aspx Excel 的規格及限制] 工作表大小</ref> | |||
* EXCEL 2003: 工作表大小 65,536 列 * 256 欄 = 16,777,216 個儲存格<ref>[http://office.microsoft.com/zh-tw/excel-help/HP005199291.aspx Excel 的規格及限制 - Excel - Office.com]</ref> | |||
* LibreOffice Calc 3.3.3版以後: 1,048,576 列<ref>[http://ask.libreoffice.org/en/question/8631/upper-limit-to-number-of-rows-in-calc/ upper limit to number of rows in Calc - Ask LibreOffice]</ref> | |||
* Google spreadsheet: 所有工作表共 40 萬個儲存格。如果只使用一個工作表，使用256 欄，則列數限制為 1,562 列<ref>[https://support.google.com/drive/answer/37603?hl=zh-Hant Google 文件、試算表和簡報的檔案大小限制 - 雲端硬碟說明]</ref> | |||
== MovableType == | == MovableType == | ||
Revision as of 12:05, 15 October 2013
Copy & Paste
- Microsoft Excel --> Google Spreadsheet:
- columns & rows: Copy & Paste is ok
- Plain text --> Google Spreadsheet: ok
- columns: Tab separated columns --> Google Spreadsheet: ok
- rows: Enter separated rows --> Google Spreadsheet: ok
- Plain text --> Microsoft Excel: ok
- columns: Tab separated columns --> Microsoft Excel: ok
- rows: Enter separated rows --> Microsoft Excel: ok
- Microsoft Excel --> Table of Google Document:
- columns & rows: Copy & Paste is ok
- Plain text --> Table of Google Document: fail
Suggest you copy to Microsoft Excel first and then copy paste to Google Document from Microsoft Excel.
- columns: Tab separated columns --> Table of Google Document: fail
- rows: Enter separated rows --> Table of Google Document: fail
- Plain text --> Microsoft Excel: ok
- columns: Tab separated columns --> Microsoft Excel: ok
- rows: Enter separated rows --> Microsoft Excel: ok
- How-to Create and Copy a Table in Google Mail (Gmail) from Excel - YouTube
Google spreadsheet
利用Google spreadsheet的函式，分析及統計可複選的問卷題目結果。
工作表或儲存格的大小限制
- EXCEL 2007: 工作表大小 1,048,576 列乘以 16,384 欄 = 17,179,869,184 個儲存格[1]
- EXCEL 2003: 工作表大小 65,536 列 * 256 欄 = 16,777,216 個儲存格[2]
- LibreOffice Calc 3.3.3版以後: 1,048,576 列[3]
- Google spreadsheet: 所有工作表共 40 萬個儲存格。如果只使用一個工作表，使用256 欄，則列數限制為 1,562 列[4]
MovableType
MT 3.x
check Post via Google Docs
MT 2.x
- 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.