Commit message (Collapse) | Author | Age | |
---|---|---|---|
* | This closes #997, fix LOOKUP function to find nearest match (#1001) | Stani | 2021-08-21 |
| | |||
* | This closes #1002, new fn: DAY ref #65 | Stani | 2021-08-21 |
| | | | | Co-authored-by: Stani Michiels <git@rchtct.com> Co-authored-by: xuri <xuri.me@gmail.com> | ||
* | This closes #994, fix LOOKUP function for Array form | Stani | 2021-08-19 |
| | |||
* | Improve security and simplify code | xuri | 2021-08-15 |
| | | | | | | | - Make variable name more semantic - Reduce cyclomatic complexities for the formula calculate function - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack - Typo fix for documentation and error message | ||
* | Speed up merge cells | three | 2021-08-13 |
| | |||
* | This closes #987: support nested calc for if formula (#988) | bailantaotao | 2021-08-12 |
| | |||
* | Reduce cyclomatic complexities for the formula calculate function and update ↵ | xuri | 2021-08-09 |
| | | | | documentation for the API: `MergeCell` and `GetCellValue` | ||
* | Fix code security issue | xuri | 2021-07-20 |
| | |||
* | Fix missing set each cell's styles when set columns style | xuri | 2021-07-08 |
| | |||
* | This closes #866, support use the defined name to reference the data range ↵ | xuri | 2021-06-29 |
| | | | | | | | in pivot table options - Fix incorrect scope when getting defined name - Update docs: use column number instead of index on get column width | ||
* | This closes #858 (#859) | jaby | 2021-06-08 |
| | | | | | | | * 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> | ||
* | fixes #856 (#857) | jaby | 2021-06-07 |
| | |||
* | This closes #652, new SetColWidth API, support set column width in stream ↵ | xuri | 2021-05-10 |
| | | | | writing mode, and export error message | ||
* | #65 fn: BESSELK and BESSELY | xuri | 2021-05-09 |
| | |||
* | #65 fn: IRR nad MIRR | xuri | 2021-04-16 |
| | |||
* | #65 fn: FV, FVSCHEDULE, NPER, NPV and PDURATION | xuri | 2021-04-14 |
| | |||
* | #65 fn: DB, DDB, DOLLARDE, DOLLARFR, EFFECT, ISPMT and NOMINAL | xuri | 2021-04-13 |
| | |||
* | fixed the negative values series missing chart color, #65 fn: CUMIPMT and ↵ | xuri | 2021-04-11 |
| | | | | CUMPRINC | ||
* | #65 fn: IPMT, PMT and PPMT | xuri | 2021-04-09 |
| | |||
* | Fixed #819, read empty after streaming data writing | xuri | 2021-04-08 |
| | | | | #65 fn: IMAGINARY, IMARGUMENT, IMCONJUGATE and IMDIV | ||
* | #65 fn: IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, and IMSECH | xuri | 2021-04-07 |
| | |||
* | #65 fn: IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN | xuri | 2021-04-05 |
| | |||
* | Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵ | xuri | 2021-04-04 |
| | | | | IMCSCH, IMEXP, IMLN and IMLOG10 | ||
* | Fixed #813, streaming data writer result missing after call normal API | xuri | 2021-04-03 |
| | | | | #65 formula function: COMPLEX | ||
* | #65 fn: BESSELI and BESSELJ | xuri | 2021-04-02 |
| | |||
* | #65 fn: VAR.P and VARP and fix Yoda conditions issue | xuri | 2021-04-01 |
| | |||
* | #65 fn: QUARTILE and QUARTILE.INC | xuri | 2021-03-31 |
| | |||
* | #65 fn: N, PERCENTILE.INC and T | xuri | 2021-03-30 |
| | | | | typo fixed | ||
* | #65 fn: PERCENTILE and PERMUTATIONA | xuri | 2021-03-27 |
| | |||
* | #65, new fn: POISSON.DIST, POISSON, SKEW, and STDEV.S | xuri | 2021-03-26 |
| | |||
* | This closes #809, and add new fn: HARMEAN | xuri | 2021-03-25 |
| | |||
* | #64 fn: NORM.DIST, NORMDIST, NORM.INV, NORMINV, NORM.S.DIST, NORMSDIST, ↵ | xuri | 2021-03-24 |
| | | | | NORM.S.INV, and NORMSINV | ||
* | related issue #65 fn: FIXED | xuri | 2021-03-21 |
| | |||
* | #65 fn: DATEDIF | xuri | 2021-03-19 |
| | |||
* | #65 fn: NOW and TODAY, and update dependencies | xuri | 2021-03-14 |
| | |||
* | #65 fn: LARGE, SMALL, SUBSTITUTE, refactor ARABIC | xuri | 2021-03-02 |
| | |||
* | This improves compatibility for absolute XML path, Windows-style directory ↵ | xuri | 2021-02-27 |
| | | | | separator and inline namespace; | ||
* | handle default underline type on get rich text; #65 fn: CODE, COLUMN, FIND, ↵ | xuri | 2021-02-24 |
| | | | | FINDB | ||
* | check empty rich text run properties; new formula fn: LEFT, LEFTB, RIGHT, RIGHTB | xuri | 2021-02-23 |
| | |||
* | This closes #787, avoid duplicate rich text string items, new formula fn: ↵ | xuri | 2021-02-21 |
| | | | | BIN2DEC, BIN2HEX, BIN2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX | ||
* | ref: #756, set cell as blank when SetCellValue with nil #756, new formula ↵ | xuri | 2021-02-19 |
| | | | | fn: BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR | ||
* | #65 fn: DEC2BIN, DEC2HEX, DEC2OCT | xuri | 2021-02-18 |
| | |||
* | #65 fn: KURT, STDEV, STDEVA | xuri | 2021-02-17 |
| | |||
* | This closes #785, support to change tab color; new formula function: FISHER, ↵ | xuri | 2021-02-16 |
| | | | | FISHERINV, GAMMA, GAMMALN, MIN, MINA, PERMUT | ||
* | lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, ↵ | xuri | 2021-02-15 |
| | | | | CONCATENATE, COUNT, COUNTBLANK, MAX | ||
* | add ten formula functions: ENCODEURL, EXACT, FALSE, IFERROR, ISTEXT, LENB, ↵ | xuri | 2021-02-14 |
| | | | | NOT, REPT, SHEET, TRUE | ||
* | binary search in range lookup and new formula function: LOOKUP | xuri | 2021-02-13 |
| | |||
* | init new formula function: HLOOKUP | xuri | 2021-02-09 |
| | |||
* | init new formula function: VLOOKUP | xuri | 2021-02-04 |
| | |||
* | This closes #774, closes #775 and closes #776 | xuri | 2021-02-02 |
| | | | | | | | | - 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` |