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, like:
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
Layer currently does not support:
Protected & locked cells
*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
See how we deal with references in formulas here: 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 email@example.com