[an error occurred while processing this directive]

Browse by category

Microsoft Excel Format (.xlsx) Numbers for iOS
Sheet Properties Supported Partially Supported Not Supported
Arranged objects supported
Background not supported
Frozen panes not supported
Grouped objects supported
Image border Some borders may be removed or may look different
Image effects Some effects may be removed or may look different
Image layout not supported
Inserted clip art supported
Inserted image supported
Inserted shapes supported
Locked cell not supported
Margins supported
Page breaks not supported
Page orientation supported
Protected sheet not supported
Shape styles Some styles may be removed or may look different
SmartArt Graphics not supported
Splits not supported
Worksheets supported
Table Properties Supported Partially Supported Not Supported
Banded columns Formatting is preserved
Banded rows Formatting is preserved
Column width supported
First column supported
Header row not supported
Inserted equations not supported
Inserted symbols supported
Last column supported
Merged cells supported
Row height supported
Table styles Formatting is preserved
Total row Cell values are preserved, but formulas are removed
Cell Type Supported Partially Supported Not Supported
Conditional formatting not supported
Currency format supported
Custom formatting Custom formatting is preserved, but formats are not editable
Date/Time format supported
Fraction format supported
General format supported
Number format supported
Percentage format supported
Scientific format supported
Special formatting not supported
Text format supported
Data Manipulation Supported Partially Supported Not Supported
Data validation not supported
External data not supported
Filters not supported
Pivot table not supported
Slicers not supported
Sort table supported
Formatting Supported Partially Supported Not Supported
Border formatting supported
Cell fill supported
Cell inset margin Margin is preserved on import, but not editable
Cell text wrap supported
Email hyperlinks supported
Font types Fonts available on iOS are imported. Unsupported fonts are substituted. Learn more
Hide and unhide columns supported
Hide and unhide rows supported
Horizontal alignment in cell supported
Rich text in cells Rich text formatting is removed when the cell is edited
Stroke styles supported
Vertical alignment in cell supported
Web hyperlinks supported
Chart Properties and Formatting Supported Partially Supported Not Supported
Category axis title supported
Category/series labels supported
Chart data source supported
Chart layouts supported
Chart styles supported
Chart title supported
Fill supported
Series axis title supported
Series data source supported
Series order supported
Shadow not supported
Show data table not supported
Show legend keys in data table not supported
Show series major gridline supported
Show series minor gridline supported
Spark lines not supported
Stroke styles supported
Value axis title supported
Charts Supported Partially Supported Not Supported
2D Column supported
2D Stacked Column supported
2D 100% Stacked Column supported
2D Bar supported
2D Stacked Bar supported
2D 100% Stacked Bar supported
2D Line supported
2D Stacked Line Imported as Line chart
2D Marked Line supported
2D Stacked Marked Line supported
2D 100% Stacked Marked Line supported
2D 100% Stacked Line Imported as Line chart
2D Area supported
2D Stacked Area supported
2D 100% Stacked Area supported
2D Smooth Marked Scatter supported
2D Smooth Lined Scatter supported
2D Straight Marked Scatter supported
2D Straight Lined Scatter supported
2D Pie supported
2D Exploded Pie supported
2D Pie of Pie Imported as Pie chart
2D Bar of Pie Imported as Pie chart
2D Marked Scatter supported
3D Column supported
3D Stacked Column supported
3D 100% Stacked Column supported
3D Bar supported
3D Stacked Bar supported
3D 100% Stacked Bar supported
3D Line supported
3D Area supported
3D Pie supported
3D Exploded Pie supported
3D Stacked Area supported
3D 100% Stacked Area supported
Bubble charts not supported
Doughnut Imported as Pie chart
Exploded Doughnut Imported as Pie chart
Surface charts not supported
Radar charts not supported
High-Low-Close Stock Imported as Line chart
Open-High-Low-Close Stock Imported as Line chart
Volume-High-Low-Close Stock Imported as Bar chart
Volume-Open-High-Low-Close Stock Imported as Bar chart
Column Cylinder supported
Stacked Column Cylinder supported
100% Stacked Column Cylinder supported
3D Column Cylinder supported
Column Cone Imported as 3D Column Cylinder chart
Stacked Column Cone Imported as 3D Column Cylinder chart
100% Stacked Column Cone Imported as 3D Column Cylinder chart
3D Column Cone Imported as 3D Column Cylinder chart
Column Pyramid Imported as 3D Rectangle Column chart
Stacked Column Pyramid Imported as 3D Rectangle Column chart
100% Stacked Column Pyramid Imported as 3D Rectangle Column chart
3D Column Pyramid Imported as 3D Rectangle Column chart
Bar Cylinder supported
Stacked Bar Cylinder supported
100% Stacked Column Cylinder supported
Bar Cone Imported as Bar Cylinder chart
Stacked Bar Cone Imported as Bar Cylinder chart
100% Stacked Bar Cone Imported as Bar Cylinder chart
Bar Pyramid Imported as 3D Rectangle Bar chart
Stacked Bar Pyramid Imported as 3D Rectangle Bar chart
100% Stacked Bar Pyramid Imported as 3D Rectangle Bar chart
Miscellaneous Supported Partially Supported Not Supported
Comments not supported
Ink annotations not supported
Macros not supported
OLE objects not supported
Protected workbook not supported
Tracked changes not supported
Cube Functions Supported Partially Supported Not Supported
CUBEKPIMEMBER not supported
CUBEMEMBER not supported
CUBEMEMBERPROPERTY not supported
CUBERANKEDMEMBER not supported
CUBESET not supported
CUBESETCOUNT not supported
CUBEVALUE not supported
Database Functions Supported Partially Supported Not Supported
DAVERAGE not supported
DCOUNT not supported
DCOUNTA not supported
DGET not supported
DMAX not supported
DMIN not supported
DPRODUCT not supported
DSTDEV not supported
DSTDEVP not supported
DSUM not supported
DVAR not supported
DVARP not supported
GETPIVOTDATA not supported
Date and Time Functions Supported Partially Supported Not Supported
DATE supported
DATEDIF supported
DATEVALUE supported
DAY supported
DAYS360 supported
EDATE supported
EOMONTH supported
HOUR supported
MINUTE supported
MONTH supported
NETWORKDAYS supported
NETWORKDAYS.INTL not supported
NOW supported
SECOND supported
TIME supported
TIMEVALUE supported
TODAY supported
WEEKDAY supported
WEEKNUM supported
WORKDAY supported
WORKDAY.INTL not supported
YEAR supported
YEARFRAC supported
Engineering Functions Supported Partially Supported Not Supported
BESSELI not supported
BESSELJ supported
BESSELK not supported
BESSELY supported
BIN2DEC supported
BIN2HEX supported
BIN2OCT supported
COMPLEX not supported
CONVERT supported
DEC2BIN supported
DEC2HEX supported
DEC2OCT supported
DELTA supported
ERF supported
ERF.PRECISE not supported
ERFC supported
ERFC.PRECISE not supported
GESTEP supported
HEX2BIN supported
HEX2DEC supported
HEX2OCT supported
IMABS not supported
IMAGINARY not supported
IMARGUMENT not supported
IMCONJUGATE not supported
IMCOS not supported
IMDIV not supported
IMEXP not supported
IMLN not supported
IMLOG10 not supported
IMLOG2 not supported
IMPOWER not supported
IMPRODUCT not supported
IMREAL not supported
IMSIN not supported
IMSQRT not supported
IMSUB not supported
IMSUM not supported
OCT2BIN supported
OCT2DEC supported
OCT2HEX supported
Financial Functions Supported Partially Supported Not Supported
ACCRINT supported
ACCRINTM supported
AMORDEGRC not supported
AMORLINC not supported
COUPDAYBS supported
COUPDAYS supported
COUPDAYSNC supported
COUPNCD not supported
COUPNUM supported
COUPPCD not supported
CUMIPMT supported
CUMPRINC supported
DB supported
DDB supported
DISC supported
DOLLARDE not supported
DOLLARFR not supported
DURATION supported
EFFECT supported
FV supported
FVSCHEDULE not supported
INTRATE supported
IPMT supported
IRR supported
ISPMT supported
MDURATION supported
MIRR supported
NOMINAL supported
NPER supported
NPV supported
ODDFPRICE not supported
ODDFYIELD not supported
ODDLPRICE not supported
ODDLYIELD not supported
PMT supported
PPMT supported
PRICE supported
PRICEDISC supported
PRICEMAT supported
PV supported
RATE supported
RECEIVED supported
SLN supported
SYD supported
TBILLEQ not supported
TBILLPRICE not supported
TBILLYIELD not supported
VDB supported
XIRR not supported
XNPV not supported
YIELD supported
YIELDDISC supported
YIELDMAT supported
Information Functions Supported Partially Supported Not Supported
CELL not supported
ERROR.TYPE not supported
INFO not supported
ISBLANK supported
ISERR not supported
ISERROR supported
ISEVEN supported
ISLOGICAL not supported
ISNA not supported
ISNONTEXT not supported
ISNUMBER not supported
ISODD supported
ISREF not supported
ISTEXT not supported
N not supported
NA not supported
TYPE not supported
Logical Functions Supported Partially Supported Not Supported
AND supported
FALSE supported
IF supported
IFERROR supported
NOT supported
OR supported
TRUE supported
Lookup and Reference Functions Supported Partially Supported Not Supported
ADDRESS Last calculated value is preserved and the function may or may not be removed depending on the values used
AREAS supported
CHOOSE supported
AGGREGATE not supported
COLUMN supported
COLUMNS supported
HLOOKUP supported
HYPERLINK supported
INDEX (array) supported
INDEX (reference) supported
INDIRECT not supported
LOOKUP (array) supported
LOOKUP (vector) supported
MATCH supported
OFFSET supported
ROW supported
ROWS supported
TRANSPOSE not supported
VLOOKUP supported
Math and Trigonometry Functions Supported Partially Supported Not Supported
ABS supported
ACOS supported
ACOSH supported
AGGREGATE not supported
ASIN supported
ASINH supported
ATAN supported
ATAN2 supported
ATANH supported
CEILING supported
CEILING.PRECISE not supported
COMBIN supported
COS supported
COSH supported
DEGREES supported
EVEN supported
EXP supported
FACT supported
FACTDOUBLE supported
FLOOR supported
FLOOR.PRECISE not supported
GCD supported
INT supported
ISO.CEILING not supported
LCM supported
LN supported
LOG supported
LOG10 supported
MDETERM not supported
MINVERSE not supported
MMULT not supported
MOD supported
MROUND supported
MULTINOMIAL supported
ODD supported
PI supported
POWER supported
PRODUCT supported
QUOTIENT supported
RADIANS supported
RAND supported
RANDBETWEEN supported
ROMAN supported
ROUND supported
ROUNDDOWN supported
ROUNDUP supported
SERIESSUM supported
SIGN supported
SIN supported
SINH supported
SQRT supported
SQRTPI supported
SUBTOTAL not supported
SUM supported
SUMIF supported
SUMIFS supported
SUMPRODUCT supported
SUMSQ supported
SUMX2MY2 supported
SUMX2PY2 supported
SUMXMY2 supported
TAN supported
TANH supported
TRUNC supported
Statistical Functions Supported Partially Supported Not Supported
AVEDEV supported
AVERAGE supported
AVERAGEA supported
AVERAGEIF supported
AVERAGEIFS supported
BETA.DIST not supported
BETA.INV not supported
BETADIST supported
BETAINV supported
BINOM.DIST not supported
BINOM.INV not supported
BINOMDIST supported
CHIDIST supported
CHIINV supported
CHISQ.DIST not supported
CHISQ.DIST.RT not supported
CHISQ.INV not supported
CHISQ.INV.RT not supported
CHISQ.TEST not supported
CHITEST supported
CONFIDENCE supported
CONFIDENCE.NORM not supported
CONFIDENCE.T not supported
CORREL supported
COUNT supported
COUNTA supported
COUNTBLANK supported
COUNTIF supported
COUNTIFS supported
COVAR supported
COVARIANCE.P not supported
COVARIANCE.S not supported
CRITBINOM supported
DEVSQ supported
EXPON.DIST not supported
EXPONDIST supported
F.DIST not supported
F.DIST.RT not supported
F.INV not supported
F.INV.RT not supported
F.TEST not supported
FDIST supported
FINV supported
FISHER not supported
FISHERINV not supported
FORECAST supported
FREQUENCY supported
FTEST not supported
GAMMA.DIST not supported
GAMMA.INV not supported
GAMMADIST supported
GAMMAINV supported
GAMMALN supported
GAMMALN.PRECISE not supported
GEOMEAN supported
GROWTH not supported
HARMEAN supported
HYPGEOMDIST not supported
INTERCEPT supported
KURT not supported
LARGE supported
LINEST supported
LOGEST not supported
LOGINV supported
LOGNORM.DIST not supported
LOGNORM.INV not supported
LOGNORMDIST supported
MAX supported
MAXA supported
MEDIAN supported
MIN supported
MINA supported
MODE supported
MODE.MULT not supported
MODE.SNGL not supported
NEGBINOM.DIST not supported
NEGBINOMDIST supported
NORM.DIST not supported
NORM.INV not supported
NORM.S.DIST not supported
NORM.S.INV not supported
NORMDIST supported
NORMINV supported
NORMSDIST supported
NORMSINV supported
PEARSON not supported
PERCENTILE supported
PERCENTILE.EXC not supported
PERCENTILE.INC not supported
PERCENTRANK supported
PERCENTRANK.EXC not supported
PERCENTRANK.INC not supported
PERMUT supported
POISSON supported
POISSON.DIST not supported
PROB supported
QUARTILE supported
QUARTILE.EXC not supported
QUARTILE.INC not supported
RANK supported
RANK.AVG not supported
RANK.EQ not supported
RSQ not supported
SKEW not supported
SLOPE supported
SMALL supported
STANDARDIZE supported
STDEV supported
STDEV.P not supported
STDEV.S not supported
STDEVA supported
STDEVP supported
STDEVPA supported
STEYX not supported
T.DIST not supported
T.DIST.2T not supported
T.DIST.RT not supported
T.INV not supported
T.INV.2T not supported
TDIST supported
TINV supported
TREND not supported
TRIMMEAN not supported
TTEST supported
VAR supported
VAR.P not supported
VAR.S not supported
VARA supported
VARP supported
VARPA supported
WEIBULL supported
WEIBULL.DIST not supported
Z.TEST not supported
ZTEST supported
Text Functions Supported Partially Supported Not Supported
ASC not supported
CHAR Last calculated value is preserved and the function may or may not be removed depending on the values used
CLEAN supported
CODE Last calculated value is preserved and the function may or may not be removed depending on the values used
CONCATENATE supported
DOLLAR supported
EXACT supported
FIND supported
FINDB not supported
FIXED supported
JIS not supported
LEFT supported
LEFTB not supported
LEN supported
LENB not supported
LOWER supported
MID supported
MIDB not supported
PHONETIC not supported
PROPER supported
REPLACE supported
REPLACEB not supported
REPT supported
RIGHT supported
RIGHTB not supported
SEARCH supported
SEARCHB not supported
SUBSTITUTE supported
T supported
TEXT not supported
TRIM supported
UPPER supported
VALUE supported
YEN not supported