summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* This closes #849, add new function `DeleteComment` for delete comment (#1317)NaturalGao2022-08-19
| | | | - Update unit tests for the delete comment - Add 3 errors function for error messages
* This closes #1319, fix calculate error for formula with negative symbolxuri2022-08-17
| | | - Update unit test and comment for the functions
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* This closes #1312, #1313, fix number format issuexuri2022-08-12
| | | | | | - Add supported options in the docs of the functions `SetSheetPrOptions` and `GetSheetPrOptions` - Add go1.19 unit test settings, and made the test case compatible with go1.19 - Update dependencies module
* This closes #1296, add new function `GetRowOpts` for stream reader (#1297)Thomas Charbonnel2022-08-11
| | | | - Support get rows properties by `GetRowOpts` function - New exported constant `MaxCellStyles`
* This reduces memory usage and speedup the `AddComment` function (#1311)EE2022-08-10
| | | By load only once for existing comment shapes, improving performance for adding comments in the worksheet
* Add new exported `ColorMappingType` used for color transformationxuri2022-08-06
| | | | Using `ColorMappingType` color transformation types enumeration for tab color index, ref #1285
* This closes #1299 skip write nil values in SetRow (#1301)Thomas Charbonnel2022-08-04
| | | Co-authored-by: Thomas Charbonnel <github@charbonnel.email>
* This closes #1298, fix doc properties missing after creating new worksheetxuri2022-08-03
|
* This closes #1283, support set and get color index, theme and tint for sheet tabThomas Charbonnel2022-07-26
| | | | | This commit renames `TabColor` into `TabColorRGB` (but keeps an alias for backwards compatibility), as well as adds support for more tab color options (Theme, Indexed and Tint). Signed-off-by: Thomas Charbonnel <github@charbonnel.email>
* Fix potential file corrupted and change worksheet name case-insensitivexuri2022-07-18
| | | | | | - Using sheet ID instead of sheet index when delete the cell in calculation chain - Update documentation for exported functions - Using `sheet` represent the sheet name in the function parameters
* Optimizing line breaks for comments (#1281)Regan Yue2022-07-17
|
* Fix potential file corrupted when changing cell value or the col/rowxuri2022-07-16
| | | | | - Remove shared formula subsequent cell when setting the cell values - Support adjust table range when removing and inserting column/row
* adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new ↵MJacred2022-07-14
| | | | | constant `MinColumns` (#1272) Signed-off-by: Benjamin Lösch <loesch.benny92@gmx.de>
* This fix potential panic and file corruptedxuri2022-07-14
| | | | | | - Fix the panic when set or get sheet view options on the sheet without views options - Fix generated workbook corruption caused by empty created or modified dcterms in the document core properties - Update the unit tests
* This closes #1262, support for dependence formulas calculationxuri2022-07-10
| | | | | - Add export option `MaxCalcIterations` for specifies the maximum iterations for iterative calculation - Update unit test for the database formula functions
* This closes #1269, made the `NewStreamWriter` function case insensitive to ↵Eagle Xiang2022-07-06
| | | | | worksheet name Co-authored-by: xiangyz <xiangyz@dustess.com>
* ref #65, new formula function: DGETxuri2022-07-03
|
* ref #65, new formula functions: DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARPxuri2022-07-02
|
* Fix CONTRIBUTING doc typo issues (#1266)yeshu2022-07-02
|
* This closes #1264, fix can't modify cell content issue in some casesyeshu2022-07-01
| | | Remove inline rich text when setting cell value and cell formulas
* ref #65, new formula function: DAVERAGExuri2022-07-01
|
* ref #65, new formula functions: DMAX and DMINxuri2022-06-28
|
* This closes #1260, fixes compiling issue under 32-bit, and new formula functionsxuri2022-06-27
| | | | | | - ref #65, new formula functions: DCOUNT and DCOUNTA - support percentile symbol in condition criteria expression - this update dependencies module
* ref #65, new formula function: HYPERLINKxuri2022-06-24
|
* ref #65, new formula function: EUROCONVERTxuri2022-06-22
|
* This closes #1257, fix incorrect worksheet header footer fields orderxuri2022-06-21
|
* ref #65, new formula function: STEYXxuri2022-06-20
|
* ref #65, new formula function: DAYS360xuri2022-06-17
|
* ref #65, new formula functions: NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAYxuri2022-06-16
|
* This closes #1254, `DeleteDataValidation` support delete all data ↵z.hua2022-06-15
| | | | validations in the worksheet
* Fix the problem of multi arguments calculation (#1253)ww15161232022-06-14
|
* RichTextRun support set superscript and subscript by vertAlign attribute (#1252)jialei2022-06-13
| | | check vertical align enumeration, update set rich text docs and test
* ref #65: new formula function WORKDAY.INTLxuri2022-06-13
|
* refactor: replace strings.Replace with strings.ReplaceAll (#1250)Eng Zer Jun2022-06-12
| | | | | | | strings.ReplaceAll(s, old, new) is a wrapper function for strings.Replace(s, old, new, -1). But strings.ReplaceAll is more readable and removes the hardcoded -1. Signed-off-by: Eng Zer Jun <engzerjun@gmail.com>
* ref #65: new formula function EOMONTHxuri2022-06-11
|
* ref #65: new formula function EDATExuri2022-06-10
|
* ref #65: new formula function WEEKNUMxuri2022-06-09
|
* This update docs and tests for workbook encryptionxuri2022-05-31
|
* This initialized support for encryption workbook by password, ref #199xuri2022-05-29
| | | | - Remove exported variable `ErrEncrypt`
* This update dependencies module and GitHub Action settingsdependabot[bot]2022-05-26
| | | | Signed-off-by: dependabot[bot] <support@github.com> Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
* Improves the calculation engine, docs update, and adds the dependabotxuri2022-05-26
| | | | | | - Initialize array formula support for the formula calculation engine - Update example and unit test of `AddPivotTable` - Update the supported hash algorithm of ProtectSheet
* This fix formula calculation accuracy issue and panic when set panexuri2022-05-23
| | | | | - Fix `GROWTH` and `TREND` calculation accuracy issue - Fix panic when add pane on empty sheet views worksheet - New exported constants `MinFontSize`
* make workbook open filed exception message clearxuri2022-05-20
| | | | | - New exported constant `ErrWorkbookPassword` - Rename exported constant `ErrWorkbookExt` to `ErrWorkbookFileFormat`
* This fixes a part of staticcheck issues and updates the code of conductxuri2022-05-18
| | | | Update example for set cell hyperlinks with `HyperlinkOpts`
* This closes #1229, rename ErrMaxFileNameLength to ErrMaxFilePathLength (#1230)sceneq2022-05-16
| | | Co-authored-by: sceneq
* This closed #1163, fix set cell value with column and row style inherit issuexuri2022-05-15
|
* This made library allowing insert WMF format imagexuri2022-05-14
|
* This closes #1225, allowing insert EMF format imagesxuri2022-05-13
|
* This closes #1219, fixes cell value reading issue, improves performance, and ↵xuri2022-05-02
| | | | | | | 1904 date system support - Fix incorrect cell data types casting results when number formatting - Support set cell value on 1904 date system enabled, ref #1212 - Improve performance for set sheet row and the merging cells, fix performance impact when resolving #1129