Commit message (Collapse) | Author | Age | |
---|---|---|---|
* | Support workbook views settings (#1136) | David | 2022-02-04 |
| | |||
* | This closes #1129, make cell support inheritance columns/rows style | xuri | 2022-01-27 |
| | | | | | | Correct cells style in merge range Fix incorrect style ID returned on getting cell style in some cases Unit test updated and simplified code | ||
* | Fix file corrupted in some cases, check file extension and format code | xuri | 2022-01-23 |
| | | | | | | Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case New exported error ErrWorkbookExt has been added, and check file extension on save the workbook Format source code with `gofumpt` | ||
* | ref #1054, breaking change for the column and row's iterator | xuri | 2022-01-19 |
| | | | | This removed 3 exported functions: `TotalCols`, `CurrentCol` and `CurrentRow` | ||
* | Breaking change: remove `TotalRows` of row iterator and performance optimization | xuri | 2022-01-17 |
| | | | | Reduce allocation memory 20%, and 80% GC times for the row's iterator | ||
* | This closes #1122, improve compatibility with LibreOffice | xuri | 2022-01-16 |
| | | | Fixed the issue auto filter doesn't work on LibreOffice if the sheet name has spaces | ||
* | This closes #1119, style parsing issue fixed | xuri | 2022-01-15 |
| | |||
* | Fix adjustMergeCells not modifies cell rect (#1118) | Dokiy | 2022-01-14 |
| | |||
* | Breaking change for data validation and fixed #1117 | xuri | 2022-01-12 |
| | | | | | - Remove second useless parameter `isCurrentSheet` of the function `SetSqrefDropList` - Fix missing page setup of worksheet after re-saving the spreadsheet | ||
* | ref #1096, reduce memory usage by about 50% for large data spreadsheet | xuri | 2022-01-11 |
| | |||
* | Typo fix, rename exported constants, dependencies modules and copyright update | xuri | 2022-01-09 |
| | | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative` | ||
* | feat: implement SHA-512 algorithm to ProtectSheet (#1115) | Jonham.Chen | 2022-01-08 |
| | |||
* | Update create style example, using a pointer of the structure instead of JSON | xuri | 2022-01-05 |
| | |||
* | This closes #1107, stream writer will create a time number format for time ↵ | xuri | 2021-12-31 |
| | | | | | | type cells Unit test coverage improved | ||
* | Preserve horizontal tab character when set the cell value (#1108) | vst | 2021-12-30 |
| | |||
* | This closes #1096, memory usage optimization and another 4 changes | xuri | 2021-12-27 |
| | | | | | | | | - Unzip shared string table to system temporary file when large inner XML, reduce memory usage about 70% - Remove unnecessary exported variable `XMLHeader`, we can using `encoding/xml` package's `xml.Header` instead of it - Using constant instead of inline text for default XML path - Rename exported option field `WorksheetUnzipMemLimit` to `UnzipXMLSizeLimit` - Unit test and documentation updated | ||
* | This closes #1095, support to set and get document application properties | xuri | 2021-12-26 |
| | |||
* | This closes #1097, initialized formula function XLOOKUP and update test | xuri | 2021-12-25 |
| | |||
* | ref #65, new formula functions MAXIFS and MINIFS | xuri | 2021-12-19 |
| | |||
* | new formula function and update docs for formula functions | xuri | 2021-12-17 |
| | | | | ref #65, new formula function: INDEX (array formula not support yet) | ||
* | ref #65: new formula function COUNTIFS | xuri | 2021-12-14 |
| | |||
* | ref #65: new formula functions: AVERAGEIF and COUNTIF | xuri | 2021-12-13 |
| | |||
* | ref #65: new formula function: SHEETS, and fix SHEET function count issue | xuri | 2021-12-12 |
| | |||
* | This closes #1090 (#1092) | jaby | 2021-12-10 |
| | | | Keep track of operators per function | ||
* | ref #65: new formula functions: ISFORMULA, ISLOGICAL and ISREF | xuri | 2021-12-09 |
| | |||
* | This closes #1088 (#1089) | jaby | 2021-12-09 |
| | | | Support check string equality with the string value of a defined name | ||
* | Export 7 errors so users can act differently on different type of errors | xuri | 2021-12-07 |
| | |||
* | Fix adjustMergeCellsHelper and add some test cases (#1082) | Dokiy | 2021-12-06 |
| | | | Signed-off-by: Dokiys <dokiychang@gmail.com> | ||
* | ref #65: new formula function ODDFPRICE | xuri | 2021-12-06 |
| | |||
* | Update docs for SetSheetStyle, and added 2 formula functions | xuri | 2021-12-04 |
| | | | | | ref #65: new formula functions DURATION and MDURATION fix incorrect example in SetSheetStyle docs | ||
* | Simplify code and update unit test | xuri | 2021-12-03 |
| | | | | | Improve unit test coverage for the functions: `NewStyle`, `SetActiveSheet`, `SearchSheet` and `deleteAndAdjustDefinedNames` Simplify code and add comments for the function: `deleteAndAdjustDefinedNames` | ||
* | refactor DeleteSheet for better readability (#1078) | Michael Wiesenbauer | 2021-12-02 |
| | | | | Signed-off-by: Michael Wiesenbauer <michael.wiesenbauer@ambos.io> Co-authored-by: Michael Wiesenbauer <michael.wiesenbauer@fau.de> | ||
* | Merge pull request #1077 from Dokiys/hotfix/get_num_fmt_id | xuri | 2021-12-02 |
|\ | | | | | Fix call getNumFmtID with builtInNumFmt return -1 | ||
| * | Fix call getNumFmtID with builtInNumFmt return -1 | Dokiy | 2021-12-01 |
|/ | |||
* | This closes #1075, reload temporary files into memory on save | xuri | 2021-12-01 |
| | |||
* | ref #65: new formula function YIELD | xuri | 2021-11-29 |
| | |||
* | ref #65: new formula functions CONFIDENCE and CONFIDENCE.NORM | xuri | 2021-11-25 |
| | |||
* | This closes #1069, support time zone location when set cell value | xuri | 2021-11-24 |
| | |||
* | ref #65: new formula function VDB | xuri | 2021-11-22 |
| | |||
* | ref #65: new formula function XIRR | xuri | 2021-11-21 |
| | |||
* | This closes #1060, fix build-in time number format parse error | xuri | 2021-11-20 |
| | |||
* | Fix sheet deletion fail in some case | xuri | 2021-11-18 |
| | |||
* | ref #65: new formula function PRICE | xuri | 2021-11-17 |
| | | | | | - fix COUPPCD result accuracy issue - update close spreadsheet example in documentation and README | ||
* | This closes #1061, support multi-byte language on set header footer | xuri | 2021-11-16 |
| | | | | typo fixed and simplify code for read the data values arguments of formula functions | ||
* | ref #65, new formula functions: COUPDAYBS, COUPDAYS and COUPDAYSNC | xuri | 2021-11-15 |
| | |||
* | This closes #1057, merge column styles to reduce spreadsheet size | xuri | 2021-11-14 |
| | |||
* | This closes #1059, represent boolean in XML as 0/1 rather than true/false | xuri | 2021-11-13 |
| | |||
* | ref #65: new formula function MINUTE | xuri | 2021-11-12 |
| | |||
* | ref #65: new formula function XNPV | xuri | 2021-11-11 |
| | |||
* | ref #65: new formula functions PERCENTRANK.EXC, PERCENTRANK.INC and PERCENTRANK | xuri | 2021-11-09 |
| |