Commit message (Collapse) | Author | Age | |
---|---|---|---|
* | ref #65: new formula functions AVEDEV and CHIDIST | xuri | 2021-10-23 |
| | |||
* | ref #65: new formula functions ADDRESS and PRICEDISC | xuri | 2021-10-22 |
| | |||
* | ref #65: new formula functions DISC and INTRATE | xuri | 2021-10-21 |
| | |||
* | ref #65, new formula functions: RRI, SLN and SYD | xuri | 2021-10-20 |
| | |||
* | ref #65: new formula functions IFNA and IFS and fix string compare result ↵ | xuri | 2021-10-19 |
| | | | | issue in arithmetic operations | ||
* | ref #65: new formula function AMORLINC | xuri | 2021-10-18 |
| | |||
* | ref #65: new formula functions ACCRINTM and AMORDEGRC | xuri | 2021-10-17 |
| | |||
* | ref #65, new formula function: TIME | xuri | 2021-10-16 |
| | |||
* | Update the test case of the formula function `MIRR` | Tammy | 2021-10-15 |
| | |||
* | This closes #1031, fix small float parsed error in some case | xuri | 2021-10-15 |
| | | | | | | - new formula function: YEARFRAC, ref #65 - update the codecov version - remove unused variable | ||
* | This closes #1030, fix date rounding error | xuri | 2021-10-12 |
| | |||
* | This closes #1029, support specify compact and outline for the pivot table | xuri | 2021-10-11 |
| | |||
* | initialize formula function TRANSPOSE, ref #65 and remove unused exported ↵ | xuri | 2021-10-01 |
| | | | | error variable ErrToExcelTime | ||
* | Now support set row style in the stream writer | xuri | 2021-09-29 |
| | |||
* | This closes #1027 and closes #1028 | xuri | 2021-09-28 |
| | | | | | * Fix build-in scientific number format failed * An error will be returned if given an invalid custom number format when creating a new style | ||
* | This closes #1026, time parse accuracy issue and typo fixed | xuri | 2021-09-26 |
| | |||
* | new formula function: DAYS, ref #65 | xuri | 2021-09-24 |
| | |||
* | This closes #833, closes #845, and closes #1022, breaking changes | xuri | 2021-09-19 |
| | | | | | | - Close spreadsheet and row's iterator required - New options `WorksheetUnzipMemLimit` have been added - Improve streaming reading performance, memory usage decrease about 93.7% | ||
* | - new formula functions: DATEVALUE, ref #65 | xuri | 2021-09-17 |
| | | | | | - fix ineffectual variable assignments - timeout in go test | ||
* | new formula functions: WEIBULL and WEIBULL.DIST, ref #65 | xuri | 2021-09-14 |
| | |||
* | new formula functions: Z.TEST and ZTEST, ref #65 | xuri | 2021-09-13 |
| | |||
* | This closes #1017, fix duplicate image caused by incorrect internal ↵ | xuri | 2021-09-10 |
| | | | | relationships ID calculation | ||
* | This closes #417 and closes #520, new API `GetCellType` has been added | xuri | 2021-09-09 |
| | |||
* | This closes #262, support set line width of add the shape | xuri | 2021-09-08 |
| | |||
* | This closes #993, closes #1014 | xuri | 2021-09-06 |
| | | | | | | - Fix formula percentages calculated incorrectly - Make UpdateLinkedValue skip macro sheet - Fix conditional format bottom N not working | ||
* | This closes #998 | xuri | 2021-09-05 |
| | | | | | | | - 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` | ||
* | Add set shared formula support and documentation for the `SetCellFormula` | xuri | 2021-09-03 |
| | |||
* | This closes #1008, added new formula functions MATCH and XOR, related issue #65 | xuri | 2021-08-29 |
| | |||
* | Preserve XML control character in bstrUnmarshal result | xuri | 2021-08-28 |
| | |||
* | This closes #1012, support specify the formula in the data validation range, ↵ | xuri | 2021-08-26 |
| | | | | and update the documentation for the `AddPicture` | ||
* | Improve compatibility with row element with r="0" attribute | xuri | 2021-08-23 |
| | |||
* | - This fix panic and incorrect cell read on some case | xuri | 2021-08-22 |
| | | | | | - Make unit test on Go 1.7 - API documentation updated | ||
* | This closes #1006, new fn: MONTH ref #65 | Stani | 2021-08-21 |
| | | | Co-authored-by: xuri <xuri.me@gmail.com> | ||
* | * This closes #1004, new fn: MONTH ref #65 | Stani | 2021-08-21 |
| | |||
* | 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 |
| | |||
* | This closes #989, closes #990 | xuri | 2021-08-17 |
| | | | | | New API: `SetRowStyle` support for set style for the rows Update documentation for the `GetRows`, `SetCellStyle` and `SetColStyle` | ||
* | This closes #844, support get shared formula | raochq | 2021-08-15 |
| | |||
* | 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 |
| | |||
* | This closes #986, fix set data validation drop list failed in some cases | xuri | 2021-08-12 |
| | | | | Update documentation for `GetCellValue` and simplify code | ||
* | Reduce cyclomatic complexities for the formula calculate function and update ↵ | xuri | 2021-08-09 |
| | | | | documentation for the API: `MergeCell` and `GetCellValue` | ||
* | This closes #979, fix the data validation deletion issue and tidy the ↵ | xuri | 2021-08-06 |
| | | | | internal function in the source code | ||
* | Update dependencies module and bump version 2.4.1 | xuri | 2021-08-02 |
| | |||
* | Improve compatibility for SetRichText (#976) | Arnie97 | 2021-07-31 |
| | | | | | | | - support escaped string literal - maximum character limit added - fix missing preserve character in some case Co-authored-by: xuri <xuri.me@gmail.com> | ||
* | Fix data validation issues (#975) | Arnie97 | 2021-07-31 |
| | | | | | | | | | | | | | | | | | | | | | | * Fix `SetDropList` to allow XML special characters * This closes #971, allow quotation marks in SetDropList() This patch included a XML entity mapping table instead of xml.EscapeText() to be fully compatible with Microsoft Excel. * This closes #972, allow more than 255 bytes of validation formulas This patch changed the string length calculation unit of data validation formulas from UTF-8 bytes to UTF-16 code units. * Add unit tests for SetDropList() * Fix: allow MaxFloat64 to be used in validation range 17 decimal significant digits should be more than enough to represent every IEEE-754 double-precision float number without losing precision, and numbers in this form will never reach the Excel limitation of 255 UTF-16 code units. | ||
* | This closes #971, closes #972 and closes #974 | xuri | 2021-07-29 |
| | | | | | | | | - Escape XML character in the drop list - Fix incorrect character count limit in the drop list - Fix Excel time parse issue in some case - Fix custom number format month parse issue in some case - Fix corrupted file generated caused by concurrency adding pictures | ||
* | change go module import path to github.com/xuri/excelize | xuri | 2021-07-28 |
| |