72 Commits (v2)

Author	SHA1	Message	Date
xuri	1ec0207fb5	Fix code security issue	4 years ago
xuri	4f0d676eb7	Fix missing set each cell's styles when set columns style	4 years ago
xuri	f27624acdd	This closes #866, support use the defined name to reference the data range in pivot table options ... - Fix incorrect scope when getting defined name - Update docs: use column number instead of index on get column width	4 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	1f329e8f96	This closes #774, closes #775 and closes #776 ... - correct adjust calculation chain in duplicate rows - correct adjust defined name in the workbook when delete worksheet - use absolute reference in the auto filters defined name to make it compatible with OpenOffice - API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format - Fix cyclomatic complexity issue of internal function `newFills` and `parseToken`	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