按類別瀏覽
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 | ![]() |