按類別瀏覽
| Microsoft Excel 格式 (.xlsx) | iOS 版 Numbers | ||
|---|---|---|---|
| 工作表屬性 | 支援 | 部分支援 | 不支援 |
| 排列物件 |  |
||
| 背景 | |
||
| 凍結窗格 | 輸出時支援 | ||
| 群組物件 | |
||
| 圖片框線 | 部分描邊可能被移除或顯示有所不同 | ||
| 圖片效果 | 部分效果可能被移除或顯示有所不同 | ||
| 插入美工圖案 | |
||
| 插入圖片 | |
||
| 插入圖案 | |
||
| 鎖定儲存格 | |
||
| 邊界 | |
||
| 頁面分隔 | |
||
| 頁面方向 | |
||
| 保護工作表 | |
||
| 圖案樣式 | 部分樣式可能被移除或顯示有所不同 | ||
| SmartArt 圖形 | 輸入為影像 | ||
| 平分儲存格 | |
||
| 工作表 | |
||
| 表格屬性 | 支援 | 部分支援 | 不支援 |
| 帶狀欄 | 可保留格式 | ||
| 帶狀列 | 可保留格式 | ||
| 欄寬 | |
||
| 首欄 | |
||
| 標題列 | 可保留格式 | ||
| 插入方程式 | |
||
| 插入符號 | |
||
| 末欄 | |
||
| 合併儲存格 | |
||
| 列高 | |
||
| 表格樣式 | 可保留格式 | ||
| 合計列 | 可保留輸入格數值，但公式會被移除。 | ||
| 儲存格類型 | 支援 | 部分支援 | 不支援 |
| 會計格式 | |
||
| 設定格式化的條件 | |
||
| 貨幣格式 | |
||
| 自訂格式 | |
||
| 日期/時間格式 | |
||
| 分數格式 | |
||
| 通用格式 | |
||
| 數字格式 | |
||
| 百分比格式 | |
||
| 科學格式 | |
||
| 特殊格式 | |
||
| 文字格式 | |
||
| 資料操作運算 | 支援 | 部分支援 | 不支援 |
| 資料驗證 | |
||
| 外部資料 | |
||
| 篩選 | 可保留格式及結果 | ||
| 樞紐分析表 | |
||
| 交叉分析篩選器 | |
||
| 排序表 | |
||
| 格式 | 支援 | 部分支援 | 不支援 |
| 框線格式 | |
||
| 儲存格填滿 | |
||
| 儲存格內邊界 | |
||
| 儲存格文繞圖 | |
||
| 電子郵件地址超連結 | |
||
| 字型種類 | 可供下載的字體將會輸入，不支援的字體則被取代。進一步了解 | ||
| 隱藏及取消隱藏欄 | |
||
| 隱藏及取消隱藏列 | |
||
| 儲存格內水平對齊 | |
||
| 儲存格內 RichText | |
||
| 線條樣式 | |
||
| 儲存格內垂直對齊 | |
||
| 網頁超連結 | |
||
| 圖表屬性與格式 | 支援 | 部分支援 | 不支援 |
| 類別座標軸標題 | |
||
| 類別/數列標籤 | |
||
| 圖表資料來源 | |
||
| 版面配置 | |
||
| 圖表樣式 | |
||
| 圖表標題 | |
||
| 填滿 | |
||
| 數列座標軸標題 | |
||
| 數列資料來源 | |
||
| 數列順序 | |
||
| 陰影 | |
||
| 顯示資料表格 | |
||
| 顯示資料表格圖例符號 | |
||
| 顯示數列主要格線 | |
||
| 顯示數列次要格線 | |
||
| 走勢圖 | |
||
| 線條樣式 | |
||
| 數值座標軸標題 | |
||
| 圖表 | 支援 | 部分支援 | 不支援 |
| 2D 直條圖 | |
||
| 2D 堆疊直條圖 | |
||
| 2D 百分比堆疊直條圖 | |
||
| 2D 橫條圖 | |
||
| 2D 堆疊橫條圖 | |
||
| 2D 百分比堆疊橫條圖 | |
||
| 2D 折線圖 | |
||
| 2D 堆疊折線圖 | 輸入為折線圖 | ||
| 2D 含有資料標記的折線圖 | |
||
| 2D 含有資料標記的堆疊折線圖 | |
||
| 2D 含有資料標記的百分比堆疊折線圖 | |
||
| 2D 百分比堆疊折線圖 | 輸入為折線圖 | ||
| 2D 區域圖 | |
||
| 2D 堆疊區域圖 | |
||
| 2D 百分比堆疊區域圖 | |
||
| 2D 帶有平滑線及資料標記的 XY 散佈圖 | |
||
| 2D 帶有平滑線的 XY 散佈圖 | |
||
| 2D 帶有直線及資料標記的 XY 散佈圖 | |
||
| 2D 帶有直線的 XY 散佈圖 | |
||
| 2D 圓形圖 | |
||
| 2D 分裂式圓形圖 | |
||
| 2D 子母圓形圖 | 輸入為圓餅圖 | ||
| 2D 圓形圖帶有子橫條圖 | 輸入為圓餅圖 | ||
| 2D 帶有資料標記的 XY 散佈圖 | |
||
| 3D 直條圖 | |
||
| 3D 堆疊直條圖 | |
||
| 3D 百分比堆疊直條圖 | |
||
| 3D 橫條圖 | |
||
| 3D 堆疊橫條圖 | |
||
| 3D 百分比堆疊橫條圖 | |
||
| 3D 折線圖 | |
||
| 3D 區域圖 | |
||
| 3D 圓形圖 | |
||
| 3D 分裂式圓形圖 | |
||
| 3D 堆疊區域圖 | |
||
| 3D 百分比堆疊區域圖 | |
||
| 泡泡圖 | |
||
| 環圈圖 | 輸入為單層環圈圖 | ||
| 分裂式環圈圖 | 輸入為單層環圈圖 | ||
| 曲面圖 | |
||
| 雷達圖 | |
||
| 高－低－收盤股票圖 | 輸入為折線圖 | ||
| 開盤－高－低－收盤股票圖 | 輸入為折線圖 | ||
| 成交量－高－低－收盤股票圖 | 輸入為長條圖 | ||
| 成交量－開盤－高－低－收盤股票圖 | 輸入為長條圖 | ||
| 圓柱圖 | |
||
| 堆疊圓柱圖 | |
||
| 百分比堆疊圓柱圖 | |
||
| 3D 圓柱圖 | |
||
| 圓錐圖 | 輸入為 3D 柱狀圓柱圖 | ||
| 堆疊圓錐圖 | 輸入為 3D 柱狀圓柱圖 | ||
| 百分比堆疊圓錐圖 | 輸入為 3D 柱狀圓柱圖 | ||
| 3D 圓錐圖 | 輸入為 3D 柱狀圓柱圖 | ||
| 金字塔圖 | 輸入為 3D 矩形柱狀圖 | ||
| 堆疊金字塔圖 | 輸入為 3D 矩形柱狀圖 | ||
| 百分比堆疊金字塔圖 | 輸入為 3D 矩形柱狀圖 | ||
| 3D 金字塔圖 | 輸入為 3D 矩形柱狀圖 | ||
| 水平圓柱圖 | |
||
| 堆疊水平圓柱圖 | |
||
| 百分比堆疊圓柱圖 | |
||
| 水平圓錐圖 | 輸入為長條圓柱圖 | ||
| 堆疊水平圓錐圖 | 輸入為長條圓柱圖 | ||
| 百分比堆疊水平圓錐圖 | 輸入為長條圓柱圖 | ||
| 水平金字塔圖 | 輸入為 3D 矩形長條圖 | ||
| 堆疊水平金字塔圖 | 輸入為 3D 矩形長條圖 | ||
| 百分比堆疊水平金字塔圖 | 輸入為 3D 矩形長條圖 | ||
| 雜項 | 支援 | 部分支援 | 不支援 |
| 註解 | |
||
| 筆跡註釋 | 輸入為繪圖 | ||
| 巨集 | |
||
| OLE 物件 | |
||
| 保護活頁簿 | |
||
| 追蹤修訂 | |
||
| Cube 函數 | 支援 | 部分支援 | 不支援 |
| CUBEKPIMEMBER | |
||
| CUBEMEMBER | |
||
| CUBEMEMBERPROPERTY | |
||
| CUBERANKEDMEMBER | |
||
| CUBESET | |
||
| CUBESETCOUNT | |
||
| CUBEVALUE | |
||
| 數據庫函數 | 支援 | 部分支援 | 不支援 |
| DAVERAGE | |
||
| DCOUNT | |
||
| DCOUNTA | |
||
| DGET | |
||
| DMAX | |
||
| DMIN | |
||
| DPRODUCT | |
||
| DSTDEV | |
||
| DSTDEVP | |
||
| DSUM | |
||
| DVAR | |
||
| DVARP | |
||
| GETPIVOTDATA | |
||
| 日期及時間函數 | 支援 | 部分支援 | 不支援 |
| DATE | |
||
| DATEDIF | |
||
| DATEVALUE | |
||
| DAY | |
||
| DAYS360 | |
||
| EDATE | |
||
| EOMONTH | |
||
| HOUR | |
||
| MINUTE | |
||
| MONTH | |
||
| NETWORKDAYS | |
||
| NETWORKDAYS.INTL | |
||
| NOW | |
||
| SECOND | |
||
| TIME | |
||
| TIMEVALUE | |
||
| TODAY | |
||
| WEEKDAY | |
||
| WEEKNUM | |
||
| WORKDAY | |
||
| WORKDAY.INTL | |
||
| YEAR | |
||
| YEARFRAC | |
||
| 工程函數 | 支援 | 部分支援 | 不支援 |
| BESSELI | |
||
| BESSELJ | |
||
| BESSELK | |
||
| BESSELY | |
||
| BIN2DEC | |
||
| BIN2HEX | |
||
| BIN2OCT | |
||
| COMPLEX | |
||
| CONVERT | |
||
| DEC2BIN | |
||
| DEC2HEX | |
||
| DEC2OCT | |
||
| DELTA | |
||
| ERF | |
||
| ERF.PRECISE | |
||
| ERFC | |
||
| ERFC.PRECISE | |
||
| GESTEP | |
||
| HEX2BIN | |
||
| HEX2DEC | |
||
| HEX2OCT | |
||
| IMABS | |
||
| IMAGINARY | |
||
| IMARGUMENT | |
||
| IMCONJUGATE | |
||
| IMCOS | |
||
| IMDIV | |
||
| IMEXP | |
||
| IMLN | |
||
| IMLOG10 | |
||
| IMLOG2 | |
||
| IMPOWER | |
||
| IMPRODUCT | |
||
| IMREAL | |
||
| IMSIN | |
||
| IMSQRT | |
||
| IMSUB | |
||
| IMSUM | |
||
| OCT2BIN | |
||
| OCT2DEC | |
||
| OCT2HEX | |
||
| 財務函數 | 支援 | 部分支援 | 不支援 |
| ACCRINT | |
||
| ACCRINTM | |
||
| AMORDEGRC | |
||
| AMORLINC | |
||
| COUPDAYBS | |
||
| COUPDAYS | |
||
| COUPDAYSNC | |
||
| COUPNCD | |
||
| COUPNUM | |
||
| COUPPCD | |
||
| CUMIPMT | |
||
| CUMPRINC | |
||
| DB | |
||
| DDB | |
||
| DISC | |
||
| DOLLARDE | |
||
| DOLLARFR | |
||
| DURATION | |
||
| EFFECT | |
||
| FV | |
||
| FVSCHEDULE | |
||
| INTRATE | |
||
| IPMT | |
||
| IRR | |
||
| ISPMT | |
||
| MDURATION | |
||
| MIRR | |
||
| NOMINAL | |
||
| NPER | |
||
| NPV | |
||
| ODDFPRICE | |
||
| ODDFYIELD | |
||
| ODDLPRICE | |
||
| ODDLYIELD | |
||
| PMT | |
||
| PPMT | |
||
| PRICE | |
||
| PRICEDISC | |
||
| PRICEMAT | |
||
| PV | |
||
| RATE | |
||
| RECEIVED | |
||
| SLN | |
||
| SYD | |
||
| TBILLEQ | |
||
| TBILLPRICE | |
||
| TBILLYIELD | |
||
| VDB | |
||
| XIRR | |
||
| XNPV | |
||
| YIELD | |
||
| YIELDDISC | |
||
| YIELDMAT | |
||
| 資訊函數 | 支援 | 部分支援 | 不支援 |
| CELL | |
||
| ERROR.TYPE | |
||
| INFO | |
||
| ISBLANK | |
||
| ISERR | |
||
| ISERROR | |
||
| ISEVEN | |
||
| ISLOGICAL | |
||
| ISNA | |
||
| ISNONTEXT | |
||
| ISNUMBER | |
||
| ISODD | |
||
| ISREF | |
||
| ISTEXT | |
||
| N | |
||
| NA | |
||
| TYPE | |
||
| 邏輯函數 | 支援 | 部分支援 | 不支援 |
| AND | |
||
| FALSE | |
||
| IF | |
||
| IFERROR | |
||
| NOT | |
||
| OR | |
||
| TRUE | |
||
| 查閱與參照函數 | 支援 | 部分支援 | 不支援 |
| ADDRESS | 可保留最後計算的數值，並視乎所用的數值而決定是否移除函數。 | ||
| AREAS | |
||
| CHOOSE | |
||
| AGGREGATE | |
||
| COLUMN | |
||
| COLUMNS | |
||
| HLOOKUP | |
||
| HYPERLINK | |
||
| INDEX (array) | |
||
| INDEX (reference) | |
||
| INDIRECT | |
||
| LOOKUP (array) | |
||
| LOOKUP (vector) | |
||
| MATCH | |
||
| OFFSET | |
||
| ROW | |
||
| ROWS | |
||
| TRANSPOSE | |
||
| VLOOKUP | |
||
| 數學與三角函數 | 支援 | 部分支援 | 不支援 |
| ABS | |
||
| ACOS | |
||
| ACOSH | |
||
| AGGREGATE | |
||
| ASIN | |
||
| ASINH | |
||
| ATAN | |
||
| ATAN2 | |
||
| ATANH | |
||
| CEILING | |
||
| CEILING.PRECISE | |
||
| COMBIN | |
||
| COS | |
||
| COSH | |
||
| DEGREES | |
||
| EVEN | |
||
| EXP | |
||
| FACT | |
||
| FACTDOUBLE | |
||
| FLOOR | |
||
| FLOOR.PRECISE | |
||
| GCD | |
||
| INT | |
||
| ISO.CEILING | |
||
| LCM | |
||
| LN | |
||
| LOG | |
||
| LOG10 | |
||
| MDETERM | |
||
| MINVERSE | |
||
| MMULT | |
||
| MOD | |
||
| MROUND | |
||
| MULTINOMIAL | |
||
| ODD | |
||
| PI | |
||
| POWER | |
||
| PRODUCT | |
||
| QUOTIENT | |
||
| RADIANS | |
||
| RAND | |
||
| RANDBETWEEN | |
||
| ROMAN | |
||
| ROUND | |
||
| ROUNDDOWN | |
||
| ROUNDUP | |
||
| SERIESSUM | |
||
| SIGN | |
||
| SIN | |
||
| SINH | |
||
| SQRT | |
||
| SQRTPI | |
||
| SUBTOTAL | |
||
| SUM | |
||
| SUMIF | |
||
| SUMIFS | |
||
| SUMPRODUCT | |
||
| SUMSQ | |
||
| SUMX2MY2 | |
||
| SUMX2PY2 | |
||
| SUMXMY2 | |
||
| TAN | |
||
| TANH | |
||
| TRUNC | |
||
| 統計函數 | 支援 | 部分支援 | 不支援 |
| AVEDEV | |
||
| AVERAGE | |
||
| AVERAGEA | |
||
| AVERAGEIF | |
||
| AVERAGEIFS | |
||
| BETA.DIST | |
||
| BETA.INV | |
||
| BETADIST | |
||
| BETAINV | |
||
| BINOM.DIST | |
||
| BINOM.INV | |
||
| BINOMDIST | |
||
| CHIDIST | |
||
| CHIINV | |
||
| CHISQ.DIST | |
||
| CHISQ.DIST.RT | |
||
| CHISQ.INV | |
||
| CHISQ.INV.RT | |
||
| CHISQ.TEST | |
||
| CHITEST | |
||
| CONFIDENCE | |
||
| CONFIDENCE.NORM | |
||
| CONFIDENCE.T | |
||
| CORREL | |
||
| COUNT | |
||
| COUNTA | |
||
| COUNTBLANK | |
||
| COUNTIF | |
||
| COUNTIFS | |
||
| COVAR | |
||
| COVARIANCE.P | |
||
| COVARIANCE.S | |
||
| CRITBINOM | |
||
| DEVSQ | |
||
| EXPON.DIST | |
||
| EXPONDIST | |
||
| F.DIST | |
||
| F.DIST.RT | |
||
| F.INV | |
||
| F.INV.RT | |
||
| F.TEST | |
||
| FDIST | |
||
| FINV | |
||
| FISHER | |
||
| FISHERINV | |
||
| FORECAST | |
||
| FREQUENCY | |
||
| FTEST | |
||
| GAMMA.DIST | |
||
| GAMMA.INV | |
||
| GAMMADIST | |
||
| GAMMAINV | |
||
| GAMMALN | |
||
| GAMMALN.PRECISE | |
||
| GEOMEAN | |
||
| GROWTH | |
||
| HARMEAN | |
||
| HYPGEOMDIST | |
||
| INTERCEPT | |
||
| KURT | |
||
| LARGE | |
||
| LINEST | |
||
| LOGEST | |
||
| LOGINV | |
||
| LOGNORM.DIST | |
||
| LOGNORM.INV | |
||
| LOGNORMDIST | |
||
| MAX | |
||
| MAXA | |
||
| MEDIAN | |
||
| MIN | |
||
| MINA | |
||
| MODE | |
||
| MODE.MULT | |
||
| MODE.SNGL | |
||
| NEGBINOM.DIST | |
||
| NEGBINOMDIST | |
||
| NORM.DIST | |
||
| NORM.INV | |
||
| NORM.S.DIST | |
||
| NORM.S.INV | |
||
| NORMDIST | |
||
| NORMINV | |
||
| NORMSDIST | |
||
| NORMSINV | |
||
| PEARSON | |
||
| PERCENTILE | |
||
| PERCENTILE.EXC | |
||
| PERCENTILE.INC | |
||
| PERCENTRANK | |
||
| PERCENTRANK.EXC | |
||
| PERCENTRANK.INC | |
||
| PERMUT | |
||
| POISSON | |
||
| POISSON.DIST | |
||
| PROB | |
||
| QUARTILE | |
||
| QUARTILE.EXC | |
||
| QUARTILE.INC | |
||
| RANK | |
||
| RANK.AVG | |
||
| RANK.EQ | |
||
| RSQ | |
||
| SKEW | |
||
| SLOPE | |
||
| SMALL | |
||
| STANDARDIZE | |
||
| STDEV | |
||
| STDEV.P | |
||
| STDEV.S | |
||
| STDEVA | |
||
| STDEVP | |
||
| STDEVPA | |
||
| STEYX | |
||
| T.DIST | |
||
| T.DIST.2T | |
||
| T.DIST.RT | |
||
| T.INV | |
||
| T.INV.2T | |
||
| TDIST | |
||
| TINV | |
||
| TREND | |
||
| TRIMMEAN | |
||
| TTEST | |
||
| VAR | |
||
| VAR.P | |
||
| VAR.S | |
||
| VARA | |
||
| VARP | |
||
| VARPA | |
||
| WEIBULL | |
||
| WEIBULL.DIST | |
||
| Z.TEST | |
||
| ZTEST | |
||
| 文字函數 | 支援 | 部分支援 | 不支援 |
| ASC | |
||
| CHAR | 可保留最後計算的數值，並視乎所用的數值而決定是否移除函數。 | ||
| CLEAN | |
||
| CODE | 可保留最後計算的數值，並視乎所用的數值而決定是否移除函數。 | ||
| CONCATENATE | |
||
| DOLLAR | |
||
| EXACT | |
||
| FIND | |
||
| FINDB | |
||
| FIXED | |
||
| JIS | |
||
| LEFT | |
||
| LEFTB | |
||
| LEN | |
||
| LENB | |
||
| LOWER | |
||
| MID | |
||
| MIDB | |
||
| PHONETIC | |
||
| PROPER | |
||
| REPLACE | |
||
| REPLACEB | |
||
| REPT | |
||
| RIGHT | |
||
| RIGHTB | |
||
| SEARCH | |
||
| SEARCHB | |
||
| SUBSTITUTE | |
||
| T | |
||
| TEXT | |
||
| TRIM | |
||
| UPPER | |
||
| VALUE | |
||
| YEN | |
||