[{"id":"b66f8b1e-cc14-4e89-9679-abd5687d283d","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"569bb90a-ea68-46c6-96f1-ab151c120714","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5eb52f08-2d1a-4362-9ffc-4871bdc10f3f","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"341dd607-b97d-4d70-bde2-53acda6b6c95","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"05349273-414f-4208-9ea2-c4fc8f4ea2cb","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"86089f76-b778-4d52-821e-6f27de3df613","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b81e4fd6-1fc5-43a0-a258-b6e16a5cbec6","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8aa8ce31-43e4-438e-951f-241608435260","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"37343f41-6ec2-4c7e-b21d-2cc18d5ce1e0","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5915e52f-64f8-4146-b8bd-81bead6324a3","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"836ba889-af9e-460d-a4cc-c24d922795f2","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4ae14b06-bb68-4394-a210-a46b8f028346","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d8f42066-e9dc-4411-bdcf-43b1a203370c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"7ef86f16-b1a0-49f7-9592-612b9be02b25","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b29c7775-a9a4-451e-a1b5-01d19ed5ca5e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"e56f3989-8f81-46af-90fa-a4813eeb976f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"2526c963-f170-45a8-923e-91b0712a9810","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"24575cf0-501a-44f9-8426-c40f8f4b5552","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1a6f8d7f-acd6-42be-8c4f-f464c6218381","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"82b176fd-5cab-498c-909e-8fa7d29c38d8","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1708b3a9-4f37-44a8-8f0e-f9a2d2e5d940","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"c9ac246e-29fb-4bc4-8231-8439795bb590","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"94f2a5c3-2539-436a-af75-23fbbd1a3957","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d99594f4-2d40-4df4-9419-ba2ca6aa3f7f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"fd66e72d-0f10-4f57-9807-6db26290ab2e","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8f344863-503d-4bc3-a594-3815e7d55f5c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"9be82601-de9d-4c18-948a-23ab6f4dd431","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"6495f3c0-b463-47e0-b08a-ca949672211e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b4bede08-3f08-4839-ba4a-abc7ac195bde","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4afcdfc0-3ff5-4f2b-a223-f8fc042a5bbe","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"422062c4-fa40-4771-a86f-008efe6d86e5","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d87e8013-86a7-4840-8d25-6f62e14eb4ac","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a6acedfd-4043-4c64-a5d1-aec3326df9e7","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"dbdc0b24-06c4-48b9-8d6c-7455119dc773","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a3856849-954a-4cfc-96a6-382e530d3638","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4a39306b-ffa5-433d-80a3-28e41f929b72","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]}]
        
(Showing Draft Content)

公式函数

SpreadJS 提供了以下内置函数,按字母顺序列出。

ABS ACCRINT ACCRINTM
ACOS ACOSH ACOT
ACOTH ADDRESS AGGREGATE
AMORDEGRC AMORLINC AND
ARABIC AREAS ASIN
ASINH ATAN ATAN2
ATANH AVEDEV AVERAGE
AVERAGEA AVERAGEIF AVERAGEIFS
BAHTTEXT BASE BESSELI
BESSELJ BESSELK BESSELY
BETADIST BETA.DIST BETAINV
BETA.INV BIN2DEC BIN2HEX
BIN2OCT BINOMDIST BINOM.DIST
BINOM.DIST.RANGE BINOM.INV BITAND
BITLSHIFT BITOR BITRSHIFT
BITXOR CEILING CEILING.MATH
CEILING.PRECISE CHAR CHIDIST
CHIINV CHISQ.DIST CHISQ.DIST.RT
CHISQ.INV CHISQ.INV.RT CHISQ.TEST
CHITEST CHOOSE CLEAN
CODE COLUMN COLUMNS
COMBIN COMBINA COMPLEX
CONCAT CONCATENATE CONFIDENCE
CONFIDENCE.NORM CONFIDENCE.T CONVERT
CORREL COS COSH
COT COTH COUNT
COUNTA COUNTBLANK COUNTIF
COUNTIFS COUPDAYBS COUPDAYS
COUPDAYSNC COUPNCD COUPNUM
COUPPCD COVAR COVARIANCE.P
COVARIANCE.S CRITBINOM CSC
CSCH CUMIPMT CUMPRINC
DATE DATEDIF DATEVALUE
DAVERAGE DAY DAYS
DAYS360 DB DCOUNT
DCOUNTA DDB DEC2BIN
DEC2HEX DEC2OCT DECIMAL
DEGREES DELTA DEVSQ
DGET DISC DMAX
DMIN DOLLAR DOLLARDE
DOLLARFR DPRODUCT DSTDEV
DSTDEVP DSUM DURATION
DVAR DVARP EDATE
EFFECT ENCODEURL EOMONTH
ERF ERF.PRECISE ERFC
ERFC.PRECISE ERROR.TYPE EURO
EUROCONVERT EVEN EXACT
EXP EXPONDIST EXPON.DIST
FACT FACTDOUBLE FALSE
FDIST F.DIST F.DIST.RT
FIND FINDB FINV
F.INV F.INV.RT FILTER FISHER
FISHERINV FIXED FLOOR
FLOOR.MATH FLOOR.PRECISE FORECAST
FORMULATEXT FREQUENCY FTEST
F.TEST FV FVSCHEDULE
GAMMA GAMMADIST GAMMA.DIST
GAMMAINV GAMMA.INV GAMMALN
GAMMALN.PRECISE GAUSS GCD
GEOMEAN GESTEP GROWTH
HARMEAN HEX2BIN HEX2DEC
HEX2OCT HLOOKUP HOUR
HYPGEOMDIST HYPGEOM.DIST
IF IFERROR IFS
IFNA IMABS IMAGINARY
IMARGUMENT IMCONJUGATE IMCOS
IMDIV IMEXP IMLN
IMLOG2 IMLOG10 IMPOWER
IMPRODUCT IMREAL IMCOSH
IMCOT IMCSC IMCSCH
IMSEC IMSECH IMSIN
IMSINH IMSQRT IMSUB
IMSUM IMTAN INDEX
INDIRECT INT INTERCEPT
INTRATE IPMT IRR
ISBLANK ISERR ISERROR
ISEVEN ISFORMULA ISLOGICAL
ISNA ISNONTEXT ISNUMBER
ISO.CEILING ISODD ISOWEEKNUM
ISPMT ISREF ISTEXT
KURT LARGE LCM
LEFT LEFTB LEN
LENB LINEST LN
LOG LOG10 LOGEST
LOGINV LOGNORMDIST LOGNORM.DIST
LOGNORM.INV LOOKUP LOWER
MATCH MAX MAXA
MAXIFS MDETERM MDURATION
MEDIAN MID MIDB
MIN MINA MINIFS
MINUTE MINVERSE MIRR
MMULT MOD MODE
MODE.MULT MODE.SNGL MONTH
MROUND MULTINOMIAL NEGBINOMDIST
NEGBINOM.DIST N NA
NETWORKDAYS NETWORKDAYS.INTL NOMINAL
NORMDIST NORM.DIST NORMINV
NORM.INV NORMSDIST NORM.S.DIST
NORMSINV NORM.S.INV NOT
NOW NPER NPV
OCT2BIN OCT2DEC OCT2HEX
ODD ODDFPRICE ODDFYIELD
ODDLPRICE ODDLYIELD OFFSET
OR OFFSET
PDURATION PEARSON PERCENTILE
PERCENTILE.EXC PERCENTILE.INC PERCENTRANK
PERCENTRANK.EXC PERCENTRANK.INC PERMUT
PERMUTATIONA PHI PI
PMT POISSON POISSON.DIST
POWER PPMT PRICE
PRICEDISC PRICEMAT PROB
PRODUCT PROPER PV
QUARTILE QUARTILE.EXC QUARTILE.INC
QUOTIENT RADIANS RAND
RANDARRAY RANDBETWEEN RANK
RANK.AVG RANK.EQ RATE
RECEIVED REFRESH REPLACE
REPLACEB REPT RIGHT
RIGHTB ROMAN ROUND
ROUNDDOWN ROUNDUP ROW
ROWS RRI RSQ
SEARCH SEARCHB SEC
SECH SECOND SERIESSUM
SEQUENCE SIGN SIN
SINH SINGLE SKEW
SKEW.P SLN SLOPE
SMALL SORT SORTBY
SQRT SQRTPI STANDARDIZE
STDEV STDEVA STDEVP
STDEV.P STDEVPA STDEV.S
STEYX SUBSTITUTE SUBTOTAL
SUM SUMIF SUMIFS
SUMPRODUCT SUMSQ SUMX2MY2
SUMX2PY2 SUMXMY2 SYD
SWITCH T TAN
TANH TBILLEQ TBILLPRICE
TBILLYIELD TDIST T.DIST
T.DIST.2T T.DIST.RT TEXT
TEXTJOIN TIME TIMEVALUE
TINV T.INV T.INV.2T
TODAY TRANSPOSE TREND
TRIM TRIMMEAN TRUE
TRUNC TTEST T.TEST
TYPE
UNIQUE UNICHAR UNICODE
UPPER VALUE VAR
VARA VARP VAR.P
VARPA VAR.S VDB
VLOOKUP WEEKDAY WEEKNUM
WEIBULL WEIBULL.DIST WORKDAY
WORKDAY.INTL XIRR XNPV
XOR YEAR YEARFRAC
YIELD YIELDDISC YIELDMAT
ZTEST Z.TEST