summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Support workbook views settings (#1136)David2022-02-04
|
* This closes #1129, make cell support inheritance columns/rows stylexuri2022-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 codexuri2022-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 iteratorxuri2022-01-19
| | | | This removed 3 exported functions: `TotalCols`, `CurrentCol` and `CurrentRow`
* Breaking change: remove `TotalRows` of row iterator and performance optimizationxuri2022-01-17
| | | | Reduce allocation memory 20%, and 80% GC times for the row's iterator
* This closes #1122, improve compatibility with LibreOfficexuri2022-01-16
| | | Fixed the issue auto filter doesn't work on LibreOffice if the sheet name has spaces
* This closes #1119, style parsing issue fixedxuri2022-01-15
|
* Fix adjustMergeCells not modifies cell rect (#1118)Dokiy2022-01-14
|
* Breaking change for data validation and fixed #1117xuri2022-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 spreadsheetxuri2022-01-11
|
* Typo fix, rename exported constants, dependencies modules and copyright updatexuri2022-01-09
| | | | Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadataInitiative`
* feat: implement SHA-512 algorithm to ProtectSheet (#1115)Jonham.Chen2022-01-08
|
* Update create style example, using a pointer of the structure instead of JSONxuri2022-01-05
|
* This closes #1107, stream writer will create a time number format for time ↵xuri2021-12-31
| | | | | | type cells Unit test coverage improved
* Preserve horizontal tab character when set the cell value (#1108)vst2021-12-30
|
* This closes #1096, memory usage optimization and another 4 changesxuri2021-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 propertiesxuri2021-12-26
|
* This closes #1097, initialized formula function XLOOKUP and update testxuri2021-12-25
|
* ref #65, new formula functions MAXIFS and MINIFSxuri2021-12-19
|
* new formula function and update docs for formula functionsxuri2021-12-17
| | | | ref #65, new formula function: INDEX (array formula not support yet)
* ref #65: new formula function COUNTIFSxuri2021-12-14
|
* ref #65: new formula functions: AVERAGEIF and COUNTIFxuri2021-12-13
|
* ref #65: new formula function: SHEETS, and fix SHEET function count issuexuri2021-12-12
|
* This closes #1090 (#1092)jaby2021-12-10
| | | Keep track of operators per function
* ref #65: new formula functions: ISFORMULA, ISLOGICAL and ISREFxuri2021-12-09
|
* This closes #1088 (#1089)jaby2021-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 errorsxuri2021-12-07
|
* Fix adjustMergeCellsHelper and add some test cases (#1082)Dokiy2021-12-06
| | | Signed-off-by: Dokiys <dokiychang@gmail.com>
* ref #65: new formula function ODDFPRICExuri2021-12-06
|
* Update docs for SetSheetStyle, and added 2 formula functionsxuri2021-12-04
| | | | | ref #65: new formula functions DURATION and MDURATION fix incorrect example in SetSheetStyle docs
* Simplify code and update unit testxuri2021-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 Wiesenbauer2021-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_idxuri2021-12-02
|\ | | | | Fix call getNumFmtID with builtInNumFmt return -1
| * Fix call getNumFmtID with builtInNumFmt return -1Dokiy2021-12-01
|/
* This closes #1075, reload temporary files into memory on savexuri2021-12-01
|
* ref #65: new formula function YIELDxuri2021-11-29
|
* ref #65: new formula functions CONFIDENCE and CONFIDENCE.NORMxuri2021-11-25
|
* This closes #1069, support time zone location when set cell valuexuri2021-11-24
|
* ref #65: new formula function VDBxuri2021-11-22
|
* ref #65: new formula function XIRRxuri2021-11-21
|
* This closes #1060, fix build-in time number format parse errorxuri2021-11-20
|
* Fix sheet deletion fail in some casexuri2021-11-18
|
* ref #65: new formula function PRICExuri2021-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 footerxuri2021-11-16
| | | | typo fixed and simplify code for read the data values arguments of formula functions
* ref #65, new formula functions: COUPDAYBS, COUPDAYS and COUPDAYSNCxuri2021-11-15
|
* This closes #1057, merge column styles to reduce spreadsheet sizexuri2021-11-14
|
* This closes #1059, represent boolean in XML as 0/1 rather than true/falsexuri2021-11-13
|
* ref #65: new formula function MINUTExuri2021-11-12
|
* ref #65: new formula function XNPVxuri2021-11-11
|
* ref #65: new formula functions PERCENTRANK.EXC, PERCENTRANK.INC and PERCENTRANKxuri2021-11-09
|