When sharing an entire spreadsheet
The exact same file will be shared without any Excel feature limitations.
When sharing entire sheets or parts of sheets
Layer supports most Excel features, including:
Cell values, including all sorts of number formats and stylings.
With currently 430 available Excel functions, we support the vast majority*
Hiding and grouping of rows & columns
Freeze panes
Layer currently does not support:
Pivot tables
Filters
Protected & locked cells
VBScripts
Comments
Zoom settings
*currently unsupported functions (77)
ACOT, ACOTH, ARABIC, BAHTTEXT, BASE, BINOM.DIST.RANGE, BINOM.INV, CALL, CHISQ.INV, COMBINA, CONCAT, CONFIDENCE.T, COT, COTH, CSC, CSCH, CUBEKPIMEMBER, CUBEMEMBER, CUBEMEMBERPROPERTY, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBEVALUE, DBCS, DECIMAL, ENCODEURL, ERF.PRECISE, ERFC.PRECISE, EUROCONVERT, EXPON.DIST, FILTERXML, FINV, FLOOR.PRECISE, FORECAST.ETS, FORECAST.ETS.SEASONALITY, FORECAST.ETS.STAT, FORMULATEXT, F.TEST, FTEST, GAMMA, GAMMALN.PRECISE, GAUSS, GETPIVOTDATA, IMCOSH, IMCOT, IMCSC, IMCSCH, IMSEC, IMSECH, IMSINH, IMTAN, INFO, ISFORMULA, ISO.CEILING, JIS, LOGNORM.INV, MUNIT, PERMUTATIONA, PHI, PHONETIC, RANDARRAY, REGISTER.ID, RRI, RTD, SEC, SECH, SEQUENCE, SHEET, SHEETS, SKEW.P, SORTBY, SQRT, T.DIST, T.INV, UNIQUE, WEBSERVICE, XLOOKUP, XMATCH, XOR
Check out how we deal with references in formulas: Handling references
Do you have a question about the limitations of sharing data?
Chat with us now (click on the blue chat icon on the bottom right corner) or write us an email to support@golayer.io