p71924506
/
excelize
forked from p30928647/excelize
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
1,029 Commits 2 Branches 0 Tags 6.5 MiB
Commit Graph

1029 Commits

Author SHA1 Message Date
chenliu1993 f8667386dc
This closes #827, add new functions `GetDataValidations` and `GetConditionalFormats` (#1315) 
Signed-off-by: chenliu1993 <13630583107@163.com>
 2022-08-27 00:45:46 +08:00
Cooper de Nicola 0e9378fec2
This closes #1247, add new function `SetSheetCol` for set worksheet column values (#1320) 
Signed-off-by: cdenicola <cooper.denicola@instabase.com>
Co-authored-by: cdenicola <cooper.denicola@instabase.com>
 2022-08-25 09:34:29 +08:00
xuri cb8bca0e92
This closes #1290 and closes #1328 
- Add new smooth field in chart format parameter, support specify if smooth line chart
- Fix decimal number format round issue with build-in number format
 2022-08-24 00:00:47 +08:00
xuri ab12307393
This made library allowing insert EMZ and WMZ format image 
- Update dependencies module
 2022-08-21 01:09:32 +08:00
Sangua633 cfa2d603dd
Support encrypt workbook with password #199 (#1324) 2022-08-20 15:51:03 +08:00
NaturalGao 76f336809f
This closes #849, add new function `DeleteComment` for delete comment (#1317) 
- Update unit tests for the delete comment
- Add 3 errors function for error messages
 2022-08-19 23:24:13 +08:00
xuri d1e76fc432
This closes #1319, fix calculate error for formula with negative symbol 
- Update unit test and comment for the functions
 2022-08-17 10:59:52 +08:00
xuri 551fb8a9e4
This closes #1244 and closes #1314, improving the compatibility with Google Sheet 
- Format code with `gofmt`
 2022-08-13 11:21:59 +08:00
xuri 8152bbb2ce
This closes #1312, #1313, fix number format issue 
- 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
 2022-08-12 00:32:51 +08:00
Thomas Charbonnel ed91cddea5
This closes #1296, add new function `GetRowOpts` for stream reader (#1297) 
- Support get rows properties by `GetRowOpts` function
- New exported constant `MaxCellStyles`
 2022-08-11 00:20:48 +08:00
EE b8ceaf7bf6
This reduces memory usage and speedup the `AddComment` function (#1311) 
By load only once for existing comment shapes, improving performance for adding comments in the worksheet
 2022-08-10 10:35:33 +08:00
xuri e07dac5c2e
Add new exported `ColorMappingType` used for color transformation 
Using `ColorMappingType` color transformation types enumeration for tab color index, ref #1285
 2022-08-06 15:23:03 +08:00
Thomas Charbonnel 4a029f7e36
This closes #1299 skip write nil values in SetRow (#1301) 
Co-authored-by: Thomas Charbonnel <github@charbonnel.email>
 2022-08-04 16:50:33 +08:00
xuri 504d469d3d
This closes #1298, fix doc properties missing after creating new worksheet 2022-08-03 00:42:16 +08:00
Thomas Charbonnel fd0eb2bcbf
This closes #1283, support set and get color index, theme and tint for sheet tab 
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>
 2022-07-26 12:36:21 +08:00
xuri ebea684ae5
Fix potential file corrupted and change worksheet name case-insensitive 
- 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
 2022-07-18 00:21:34 +08:00
Regan Yue 0d4c97c88a
Optimizing line breaks for comments (#1281) 2022-07-17 12:18:25 +08:00
xuri 40ed1d1b81
Fix potential file corrupted when changing cell value or the col/row 
- Remove shared formula subsequent cell when setting the cell values
- Support adjust table range when removing and inserting column/row
 2022-07-16 12:50:40 +08:00
MJacred 6429588e14
adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new constant `MinColumns` (#1272) 
Signed-off-by: Benjamin Lösch <loesch.benny92@gmx.de>
 2022-07-14 23:36:43 +08:00
xuri e37724c22b
This fix potential panic and file corrupted 
- 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
 2022-07-14 00:17:51 +08:00
xuri a65c5846e4
This closes #1262, support for dependence formulas calculation 
- Add export option `MaxCalcIterations` for specifies the maximum iterations for iterative calculation
- Update unit test for the database formula functions
 2022-07-10 18:14:48 +08:00
Eagle Xiang 1dbed64f10
This closes #1269, made the `NewStreamWriter` function case insensitive to worksheet name 
Co-authored-by: xiangyz <xiangyz@dustess.com>
 2022-07-06 20:39:10 +08:00
xuri d74adcbb15
ref #65, new formula function: DGET 2022-07-03 15:31:24 +08:00
xuri 695db4eae0
ref #65, new formula functions: DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARP 2022-07-02 13:43:31 +08:00
yeshu a77d38f040
Fix CONTRIBUTING doc typo issues (#1266) 2022-07-02 00:38:24 +08:00
yeshu 18afc88759
This closes #1264, fix can't modify cell content issue in some cases 
Remove inline rich text when setting cell value and cell formulas
 2022-07-01 00:46:23 +08:00
xuri dd6c3905e0
ref #65, new formula function: DAVERAGE 2022-07-01 00:43:27 +08:00
xuri eee6607e47
ref #65, new formula functions: DMAX and DMIN 2022-06-28 23:18:48 +08:00
xuri 301f7bc217
This closes #1260, fixes compiling issue under 32-bit, and new formula functions 
- ref #65, new formula functions: DCOUNT and DCOUNTA
- support percentile symbol in condition criteria expression
- this update dependencies module
 2022-06-27 21:00:59 +08:00
xuri 2e1b0efadc
ref #65, new formula function: HYPERLINK 2022-06-24 01:03:19 +08:00
xuri 61c71caf4f
ref #65, new formula function: EUROCONVERT 2022-06-22 20:17:22 +08:00
xuri 852f211970
This closes #1257, fix incorrect worksheet header footer fields order 2022-06-21 20:08:47 +08:00
xuri 7819cd7fec
ref #65, new formula function: STEYX 2022-06-20 22:05:23 +08:00
xuri 5f4131aece
ref #65, new formula function: DAYS360 2022-06-17 00:03:31 +08:00
xuri b69da76063
ref #65, new formula functions: NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAY 2022-06-16 00:01:32 +08:00
z.hua 5beeeef570
This closes #1254, `DeleteDataValidation` support delete all data validations in the worksheet 2022-06-15 17:28:59 +08:00
ww1516123 7f570c74f8
Fix the problem of multi arguments calculation (#1253) 2022-06-14 15:04:43 +08:00
jialei d490a0f86f
RichTextRun support set superscript and subscript by vertAlign attribute (#1252) 
check vertical align enumeration, update set rich text docs and test
 2022-06-13 23:38:59 +08:00
xuri d383f0ae6e
ref #65: new formula function WORKDAY.INTL 2022-06-13 00:05:52 +08:00
Eng Zer Jun 6bcf5e4ede
refactor: replace strings.Replace with strings.ReplaceAll (#1250) 
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>
 2022-06-12 00:19:12 +08:00
xuri f5d3d59d8c
ref #65: new formula function EOMONTH 2022-06-11 14:08:21 +08:00
xuri 980fffa2b6
ref #65: new formula function EDATE 2022-06-10 00:10:22 +08:00
xuri 604a01bf6b
ref #65: new formula function WEEKNUM 2022-06-09 08:16:48 +08:00
xuri 8fde918d98
This update docs and tests for workbook encryption 2022-05-31 11:14:42 +08:00
xuri 7a6d5f5ebe
This initialized support for encryption workbook by password, ref #199 
- Remove exported variable `ErrEncrypt`
 2022-05-29 19:37:10 +08:00
dependabot[bot] 551b83afab
This update dependencies module and GitHub Action settings 
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
 2022-05-26 13:01:49 +08:00
xuri 1c167b96a3
Improves the calculation engine, docs update, and adds the dependabot 
- Initialize array formula support for the formula calculation engine
- Update example and unit test of `AddPivotTable`
- Update the supported hash algorithm of ProtectSheet
 2022-05-26 00:15:28 +08:00
xuri afb2d27c90
This fix formula calculation accuracy issue and panic when set pane 
- Fix `GROWTH` and `TREND` calculation accuracy issue
- Fix panic when add pane on empty sheet views worksheet
- New exported constants `MinFontSize`
 2022-05-23 13:02:11 +08:00
xuri 63adac2589
make workbook open filed exception message clear 
- New exported constant `ErrWorkbookPassword`
- Rename exported constant `ErrWorkbookExt` to `ErrWorkbookFileFormat`
 2022-05-20 20:46:29 +08:00
xuri 8f16a76781
This fixes a part of staticcheck issues and updates the code of conduct 
Update example for set cell hyperlinks with `HyperlinkOpts`
 2022-05-18 23:15:24 +08:00