204 Commits (master)

Author	SHA1	Message	Date
xuri	8d21959da3	ref #65: new formula functions VAR, VARA and VARPA	3 years ago
xuri	e64775fdcc	ref #65: new formula functions STANDARDIZE, STDEV.P and STDEVP	3 years ago
xuri	08ad10f68e	ref #65: new formula functions ERF, ERF.PRECISE, ERFC and ERFC.PRECISE	3 years ago
xuri	b0eb9ef807	ref #65: new formula functions DELTA and GESTEP	3 years ago
xuri	3447cfecf2	ref #65: new formula functions ACCRINT and ISOWEEKNUM	3 years ago
xuri	3bb2849e41	ref #65: new formula functions DEVSQ and GEOMEAN	3 years ago
Jerring	9cc6694830	ref #65: new formula functions RATE and RECEIVED (#1045)	3 years ago
xuri	8932a0a0c3	ref #65: new formula functions PV, RANK and RANK.EQ	3 years ago
xuri	5c4627a0c2	ref #65: new formula functions VALUE and WEEKDAY	3 years ago
xuri	ffc998941c	ref #65: new formula functions SWITCH and TRIMMEAN	3 years ago
xuri	2e9635ece8	ref #65: new formula functions TBILLPRICE and TBILLYIELD	3 years ago
xuri	08087e1233	ref #65: new formula functions TBILLEQ and TEXTJOIN	3 years ago
xuri	154effdf82	ref #65: new formula functions YIELDDISC and YIELDMAT	3 years ago
xuri	71684d966a	ref #65: new formula functions AVEDEV and CHIDIST	3 years ago
xuri	f126f63562	ref #65: new formula functions ADDRESS and PRICEDISC	3 years ago
xuri	49e80b9e47	ref #65: new formula functions DISC and INTRATE	3 years ago
xuri	1df7f32cc6	ref #65, new formula functions: RRI, SLN and SYD	3 years ago
xuri	5f907b7824	ref #65: new formula functions IFNA and IFS and fix string compare result issue in arithmetic operations	3 years ago
xuri	620f873186	ref #65: new formula function AMORLINC	3 years ago
xuri	c89b64c53c	ref #65: new formula functions ACCRINTM and AMORDEGRC	3 years ago
xuri	cf8766df83	ref #65, new formula function: TIME	3 years ago
Tammy	c64ce0f9ac	Update the test case of the formula function `MIRR`	3 years ago
xuri	de38402f74	This closes #1031, fix small float parsed error in some case ... - new formula function: YEARFRAC, ref #65 - update the codecov version - remove unused variable	3 years ago
xuri	28841af980	initialize formula function TRANSPOSE, ref #65 and remove unused exported error variable ErrToExcelTime	3 years ago
xuri	c05b9fe8a6	new formula function: DAYS, ref #65	3 years ago
xuri	2add938798	- new formula functions: DATEVALUE, ref #65 ... - fix ineffectual variable assignments - timeout in go test	3 years ago
xuri	1ba3690764	new formula functions: WEIBULL and WEIBULL.DIST, ref #65	3 years ago
xuri	4ef68729f5	new formula functions: Z.TEST and ZTEST, ref #65	3 years ago
xuri	684603befa	This closes #993, closes #1014 ... - Fix formula percentages calculated incorrectly - Make UpdateLinkedValue skip macro sheet - Fix conditional format bottom N not working	3 years ago
xuri	32b23ef42d	This closes #998 ... - Support text comparison in the formula, also ref #65 - `GetCellValue`, `GetRows`, `GetCols`, `Rows` and `Cols` support to specify read cell with raw value, ref #621 - Add missing properties for the cell formula - Update the unit test for the `CalcCellValue`	3 years ago
xuri	5e1fbd6bf7	This closes #1008, added new formula functions MATCH and XOR, related issue #65	3 years ago
Stani	9b55f4f9f0	This closes #1006, new fn: MONTH ref #65 ... Co-authored-by: xuri <xuri.me@gmail.com>	3 years ago
Stani	4d716fa7ed	* This closes #1004, new fn: MONTH ref #65	3 years ago
Stani	f280c03345	This closes #997, fix LOOKUP function to find nearest match (#1001)	3 years ago
Stani	935af2e356	This closes #1002, new fn: DAY ref #65 ... Co-authored-by: Stani Michiels <git@rchtct.com> Co-authored-by: xuri <xuri.me@gmail.com>	3 years ago
Stani	dca03c6230	This closes #994, fix LOOKUP function for Array form	3 years ago
bailantaotao	61d0ed1ff2	This closes #987: support nested calc for if formula (#988)	3 years ago
jaby	bafe087a61	This closes #858 (#859) ... * fixes https://github.com/360EntSecGroup-Skylar/excelize/issues/858 * fixes https://github.com/360EntSecGroup-Skylar/excelize/issues/858 Co-authored-by: dvelderp <peter.de.velder@gmail.com>	4 years ago
jaby	2c90b3f535	fixes #856 (#857)	4 years ago
xuri	be12cc27f1	This closes #652, new SetColWidth API, support set column width in stream writing mode, and export error message	4 years ago
xuri	423bc26d1f	#65 fn: BESSELK and BESSELY	4 years ago
xuri	80d832022f	#65 fn: IRR nad MIRR	4 years ago
xuri	471f4f8d2b	#65 fn: FV, FVSCHEDULE, NPER, NPV and PDURATION	4 years ago
xuri	68dd5b345c	#65 fn: DB, DDB, DOLLARDE, DOLLARFR, EFFECT, ISPMT and NOMINAL	4 years ago
xuri	a13b21fe07	fixed the negative values series missing chart color, #65 fn: CUMIPMT and CUMPRINC	4 years ago
xuri	a8197485b5	#65 fn: IPMT, PMT and PPMT	4 years ago
xuri	737b7839a2	Fixed #819, read empty after streaming data writing ... #65 fn: IMAGINARY, IMARGUMENT, IMCONJUGATE and IMDIV	4 years ago
xuri	99963f89c7	#65 fn: IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, and IMSECH	4 years ago
xuri	3345e89b96	#65 fn: IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN	4 years ago
xuri	f8f699a172	Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMEXP, IMLN and IMLOG10	4 years ago
xuri	89c262fc1d	Fixed #813, streaming data writer result missing after call normal API ... #65 formula function: COMPLEX	4 years ago
xuri	6e812a27c6	#65 fn: BESSELI and BESSELJ	4 years ago
xuri	a002a2417e	#65 fn: VAR.P and VARP and fix Yoda conditions issue	4 years ago
xuri	9d4bf88b47	#65 fn: QUARTILE and QUARTILE.INC	4 years ago
xuri	2af96c0714	#65 fn: N, PERCENTILE.INC and T ... typo fixed	4 years ago
xuri	6d7bd7cd8a	#65 fn: PERCENTILE and PERMUTATIONA	4 years ago
xuri	3903c106a4	#65, new fn: POISSON.DIST, POISSON, SKEW, and STDEV.S	4 years ago
xuri	e1abdb0e5a	This closes #809, and add new fn: HARMEAN	4 years ago
xuri	ab2c1c8fe1	#64 fn: NORM.DIST, NORMDIST, NORM.INV, NORMINV, NORM.S.DIST, NORMSDIST, NORM.S.INV, and NORMSINV	4 years ago
xuri	874d59cee0	related issue #65 fn: FIXED	4 years ago
xuri	d3227393ef	#65 fn: DATEDIF	4 years ago
xuri	2350866d46	#65 fn: NOW and TODAY, and update dependencies	4 years ago
xuri	7ef1892f32	#65 fn: LARGE, SMALL, SUBSTITUTE, refactor ARABIC	4 years ago
xuri	afe2ebc261	This improves compatibility for absolute XML path, Windows-style directory separator and inline namespace;	4 years ago
xuri	5a0d885315	handle default underline type on get rich text; #65 fn: CODE, COLUMN, FIND, FINDB	4 years ago
xuri	d84050921e	check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTB	4 years ago
xuri	2833395347	This closes #787, avoid duplicate rich text string items, new formula fn: BIN2DEC, BIN2HEX, BIN2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX	4 years ago
xuri	9154d500cf	ref: #756, set cell as blank when SetCellValue with nil #756, new formula fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR	4 years ago
xuri	ae6f56b953	#65 fn: DEC2BIN, DEC2HEX, DEC2OCT	4 years ago
xuri	b3493c5416	#65 fn: KURT, STDEV, STDEVA	4 years ago
xuri	bddea1262b	This closes #785, support to change tab color; new formula function: FISHER, FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT	4 years ago
xuri	36b7990d6b	lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX	4 years ago
xuri	ca6b1577a7	add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, NOT, REPT, SHEET, TRUE	4 years ago
xuri	ec45d67e59	binary search in range lookup and new formula function: LOOKUP	4 years ago
xuri	23c73ab527	init new formula function: HLOOKUP	4 years ago
xuri	66d85dae13	init new formula function: VLOOKUP	4 years ago
xuri	db7b4ee362	update formula functions test	4 years ago
xuri	4ac32278ff	Fix hyperbolic cotangent calculation incorrect and unit test	4 years ago
xuri	76c72e0a30	Nested formula function support cell references as arguments	4 years ago
xuri	dd77cfe44c	refactor formula calculation framework, add new function CHOOSE, and update dependencies module	4 years ago
xuri	b84bd1abc0	new formula fn: IF, LEN; not equal operator support and faster numeric precision process	4 years ago
xuri	576bfffbe6	This closes #752, fix incorrectly merged cells on duplicate row, and new formula function: LOWER, PROPER, UPPER	4 years ago
Zhang Zhipeng	ad79505173	new formula func CLEAN and TRIM, change import path to v2 (#747)	4 years ago
xuri	599a8cb0bc	Fixed #727, rounding numeric with precision for formula calculation	4 years ago
xuri	2514bb16c6	Fix #724, standardize variable naming and update unit tests	4 years ago
xuri	b812e9a1a8	New formula function AND (#701) and update doc for the NewSheet (#714)	4 years ago
xuri	02530e8c8a	Fix #701, init new formula function AND and OR, prevent formula lexer panic on retrieving the top token type	4 years ago
xuri	ac3dce0bea	- Resolve #711, update docs for the GetSheetIndex ... - Update unit test	4 years ago
jaby	5993a07422	Fix issue 665 (#666)	5 years ago
xuri	b6dd7648a1	fn: COUNTA	5 years ago
xuri	b62950a39e	fn: MEDIAN, ISNUMBER	5 years ago
xuri	22df34c493	fn: ISBLANK, ISERR, ISERROR, ISEVEN, ISNA, ISNONTEXT, ISODD, NA	5 years ago
xuri	fa2571a17e	fn: SUMIF	5 years ago
xuri	0feb819d4c	updated test and go.mod	5 years ago
xuri	882abb8098	- formula engine: reduce cyclomatic complexity ... - styles: allow empty and default cell formats, #628	5 years ago
xuri	4188dc7a4a	- fn: SUMSQ ... - resolve ineffectual assignment - handle exception with invalid formula - update range resolver	5 years ago
xuri	08185c398a	#65, fn: ROUND, ROUNDDOWN, ROUNDUP, SEC, SECH, SIN, SINH, SQRTPI, TAN, TANH, TRUNC	5 years ago
xuri	de34ecaace	#65 fn: MOD, MROUND, MULTINOMIAL, MUNIT, ODD, PI, RADIANS, RAND, RANDBETWEEN, ROMAN	5 years ago
xuri	97e3f4ce68	#65 fn: CSCH, DECIMAL, DEGREES, EVEN, EXP, FACT, FACTDOUBLE, FLOOR, FLOOR.MATH, FLOOR.PRECISE, INT, ISO.CEILING, LN, LOG, LOG10, MDETERM	5 years ago
xuri	5c82f2269d	#65 fn: CEILING.PRECISE, COMBIN, COMBINA, COS, COSH, COT, COTH, CSC	5 years ago
xuri	6f796b88e6	fn: CEILING, CEILING.MATH	5 years ago
xuri	789adf9202	fn: ACOS, ACOSH, ACOT, ACOTH, ARABIC, ASIN, ASINH, ATANH, ATAN2, BASE	5 years ago
xuri	bdf0538640	fn: ABS, GCD, LCM, POWER, PRODUCT, SIGN, SQRT, SUM, QUOTIENT	5 years ago
xuri	48fc4c08a2	init formula calculation engine, ref #65 and #599	5 years ago