Google Docs and Spreadsheets: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
Line 33: Line 33:


=== 不同試算表方案的工作表或儲存格的大小限制 ===
=== 不同試算表方案的工作表或儲存格的大小限制 ===
* {{Gd}} EXCEL 2007: 工作表大小 1,048,576 列 * 16,384 欄 = 17,179,869,184 個儲存格<ref>[http://office.microsoft.com/zh-tw/excel-help/HP010073849.aspx Excel 的規格及限制] 工作表大小</ref>
* {{Gd}} EXCEL 2007:  
* [http://www.libreoffice.org/ LibreOffice] Calc 3.3.3版以後: 1,048,576 列 * 1,024 欄 = 1,073,741,824 個儲存格<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><ref>[http://www.libreoffice.org/get-help/documentation/ Documentation » LibreOffice] - [https://wiki.documentfoundation.org/images/b/b7/CG34-CalcGuideLO.pdf Calc Guide 3.4 (spreadsheets)]</ref>
** (約100萬列) 1,048,576 列 * 16,384 欄 = 17,179,869,184 個儲存格<ref>[http://office.microsoft.com/zh-tw/excel-help/HP010073849.aspx Excel 的規格及限制] 工作表大小</ref>
* [http://www.openoffice.org/ Apache OpenOffice] 3.x Calc: 65,536 列 * 1,024 欄 = 67,108,864 個儲存格<ref>[http://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What's_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F What's the maximum number of rows and cells for a spreadsheet file? - Apache OpenOffice Wiki]</ref>
* [http://www.libreoffice.org/ LibreOffice] Calc 3.3.3版以後:  
* EXCEL 2003: 工作表大小 65,536 列 * 256 欄 = 16,777,216 個儲存格<ref>[http://office.microsoft.com/zh-tw/excel-help/HP005199291.aspx Excel 的規格及限制 - Excel - Office.com]</ref>
** (約100萬列) 1,048,576 列 * 1,024 欄 = 1,073,741,824 個儲存格<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><ref>[http://www.libreoffice.org/get-help/documentation/ Documentation » LibreOffice] - [https://wiki.documentfoundation.org/images/b/b7/CG34-CalcGuideLO.pdf Calc Guide 3.4 (spreadsheets)]</ref>
* Google spreadsheet: 所有工作表共 40 萬個儲存格。如果只使用一個工作表，使用256 欄，則列數限制為 1,562 列<ref>[https://support.google.com/drive/answer/37603?hl=zh-Hant Google 文件、試算表和簡報的檔案大小限制 - 雲端硬碟說明]</ref>
* [http://www.openoffice.org/ Apache OpenOffice] 3.x Calc:  
** (約60萬列) 65,536 列 * 1,024 欄 = 67,108,864 個儲存格<ref>[http://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What's_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F What's the maximum number of rows and cells for a spreadsheet file? - Apache OpenOffice Wiki]</ref>
* EXCEL 2003: 工作表大小
** (約60萬列) 65,536 列 * 256 欄 = 16,777,216 個儲存格<ref>[http://office.microsoft.com/zh-tw/excel-help/HP005199291.aspx Excel 的規格及限制 - Excel - Office.com]</ref>
* Google spreadsheet:  
** 約 1000列。 所有工作表共 40 萬個儲存格。如果只使用一個工作表，使用256 欄，則列數限制為 1,562 列<ref>[https://support.google.com/drive/answer/37603?hl=zh-Hant Google 文件、試算表和簡報的檔案大小限制 - 雲端硬碟說明]</ref>


== MovableType ==
== MovableType ==

Revision as of 09:45, 23 October 2013

Google drive

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 Icon_exclaim.gif 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的函式，分析及統計可複選的問卷題目結果。


不同試算表方案的工作表或儲存格的大小限制

  • Good.gif EXCEL 2007:
    • (約100萬列) 1,048,576 列 * 16,384 欄 = 17,179,869,184 個儲存格[1]
  • LibreOffice Calc 3.3.3版以後:
    • (約100萬列) 1,048,576 列 * 1,024 欄 = 1,073,741,824 個儲存格[2][3]
  • Apache OpenOffice 3.x Calc:
    • (約60萬列) 65,536 列 * 1,024 欄 = 67,108,864 個儲存格[4]
  • EXCEL 2003: 工作表大小
    • (約60萬列) 65,536 列 * 256 欄 = 16,777,216 個儲存格[5]
  • Google spreadsheet:
    • 約 1000列。 所有工作表共 40 萬個儲存格。如果只使用一個工作表，使用256 欄，則列數限制為 1,562 列[6]

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.

references

  1. ↑ Excel 的規格及限制 工作表大小
  2. ↑ upper limit to number of rows in Calc - Ask LibreOffice
  3. ↑ Documentation » LibreOffice - Calc Guide 3.4 (spreadsheets)
  4. ↑ What's the maximum number of rows and cells for a spreadsheet file? - Apache OpenOffice Wiki
  5. ↑ Excel 的規格及限制 - Excel - Office.com
  6. ↑ Google 文件、試算表和簡報的檔案大小限制 - 雲端硬碟說明
Retrieved from "https://wiki.planetoid.info/index.php?title=Google_Docs_and_Spreadsheets&oldid=12577"