summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* This closes #1026, time parse accuracy issue and typo fixedxuri2021-09-26
|
* new formula function: DAYS, ref #65xuri2021-09-24
|
* This closes #833, closes #845, and closes #1022, breaking changesxuri2021-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 #65xuri2021-09-17
| | | | | - fix ineffectual variable assignments - timeout in go test
* new formula functions: WEIBULL and WEIBULL.DIST, ref #65xuri2021-09-14
|
* new formula functions: Z.TEST and ZTEST, ref #65xuri2021-09-13
|
* This closes #1017, fix duplicate image caused by incorrect internal ↵xuri2021-09-10
| | | | relationships ID calculation
* This closes #417 and closes #520, new API `GetCellType` has been addedxuri2021-09-09
|
* This closes #262, support set line width of add the shapexuri2021-09-08
|
* This closes #993, closes #1014xuri2021-09-06
| | | | | | - Fix formula percentages calculated incorrectly - Make UpdateLinkedValue skip macro sheet - Fix conditional format bottom N not working
* This closes #998xuri2021-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`xuri2021-09-03
|
* This closes #1008, added new formula functions MATCH and XOR, related issue #65xuri2021-08-29
|
* Preserve XML control character in bstrUnmarshal resultxuri2021-08-28
|
* This closes #1012, support specify the formula in the data validation range, ↵xuri2021-08-26
| | | | and update the documentation for the `AddPicture`
* Improve compatibility with row element with r="0" attributexuri2021-08-23
|
* - This fix panic and incorrect cell read on some casexuri2021-08-22
| | | | | - Make unit test on Go 1.7 - API documentation updated
* This closes #1006, new fn: MONTH ref #65Stani2021-08-21
| | | Co-authored-by: xuri <xuri.me@gmail.com>
* * This closes #1004, new fn: MONTH ref #65Stani2021-08-21
|
* This closes #997, fix LOOKUP function to find nearest match (#1001)Stani2021-08-21
|
* This closes #1002, new fn: DAY ref #65Stani2021-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 formStani2021-08-19
|
* This closes #989, closes #990xuri2021-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 formularaochq2021-08-15
|
* Improve security and simplify codexuri2021-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 cellsthree2021-08-13
|
* This closes #987: support nested calc for if formula (#988)bailantaotao2021-08-12
|
* This closes #986, fix set data validation drop list failed in some casesxuri2021-08-12
| | | | Update documentation for `GetCellValue` and simplify code
* Reduce cyclomatic complexities for the formula calculate function and update ↵xuri2021-08-09
| | | | documentation for the API: `MergeCell` and `GetCellValue`
* This closes #979, fix the data validation deletion issue and tidy the ↵xuri2021-08-06
| | | | internal function in the source code
* Update dependencies module and bump version 2.4.1xuri2021-08-02
|
* Improve compatibility for SetRichText (#976)Arnie972021-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)Arnie972021-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 #974xuri2021-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/excelizexuri2021-07-28
|
* This closes #882, support set rows height and hidden row by stream writerxuri2021-07-25
|
* Improvement compatibility with invalid first-page number attribute in the ↵xuri2021-07-21
| | | | page layout
* Fix code security issuexuri2021-07-20
|
* This closes #883, fix missing pivot attribute of conditional formattingxuri2021-07-16
|
* This closes #879, fix delete defined name failed in some casexuri2021-07-15
|
* This closes #848 and closes #852, fix reading decimals precisionxuri2021-07-12
|
* This closes #873, make the sheet names are not case sensitive for ↵xuri2021-07-10
| | | | `NewSheet`, `GetSheetIndex`, `DeleteSheet`
* Prevent panic when incorrect range is provided as PivotTableRange to (#874)Deepak S2021-07-10
|
* This closes #872, support re-save the new spreadsheet after `SaveAs`xuri2021-07-09
|
* Fix missing set each cell's styles when set columns stylexuri2021-07-08
|
* Make the functions `SetSheetRow`, `New Style` and `SetCellStyle` concurrency ↵xuri2021-07-07
| | | | safety
* Support concurrency add picturexuri2021-07-06
|
* - Support concurrency iterate rows and columnsxuri2021-07-05
| | | | | - Rename exported field `File.XLSX` to `File.Pkg` - Exported error message
* This closes #861, support concurrency get cell picture and remove unused ↵xuri2021-07-04
| | | | internal function `getSheetNameByID`
* fix: LocalSheetID in DefinedName should be equal to SheetIndex instead of ↵vettich2021-07-03
| | | | SheetID (#868)