excelize commits | Ecosyste.ms: OpenCollective

Fix cpu usage problem of stream writer when merging cells (#1359)

github.com/qax-os/excelize - addcc1a0b257d3b71e33891891c3a3df4d34f0dc authored over 2 years ago by Zitao <[email protected]>

This closes #1354, stream writer will apply style in `RowOpts` for each cell (#1355)

Co-authored-by: Tianzhi Jin <[email protected]>

github.com/qax-os/excelize - 74dad51cfce19c2f67a0ed9fe1479b6d21d767e9 authored over 2 years ago by invzhi <[email protected]>

Using the specialized name in a variable and making comments clear

- Add JSON tags for `AppProperties`, `PivotTableOption` and `PivotTableField` structure

github.com/qax-os/excelize - 3f702999e6bba26afbd2a259f6849e536042ec2e authored over 2 years ago by xuri <[email protected]>

This closes #1345, support set custom line color in the charts (#1346)

github.com/qax-os/excelize - 73cc4bd44933994ffa8efad9c3e05fe7cb826b49 authored over 2 years ago by Artem Tarasenko <[email protected]>

This makes 6 functions concurrency safety

- These 6 functions now support concurrency safe: SetColWidth, GetColWidth, SetColVisible, GetCo...

github.com/qax-os/excelize - b6cc43d8242fd3f7f0c6163db9fcd759b9b992b1 authored over 2 years ago by xuri <[email protected]>

Fix DeleteComment slice bounds out of range (#1343)

github.com/qax-os/excelize - c72fb747b8a64117538229f1e5a85d220349b6f1 authored over 2 years ago by dafengge0913 <[email protected]>

This closes #744, the `Save`, `Write` and `WriteTo` function accept saving options

github.com/qax-os/excelize - fb1aab7add52808c96c9cc10570fe73ce797b7f4 authored over 2 years ago by xuri <[email protected]>

This closes #1293, add new function `GetColStyle`

- Fix generate workbook corruption after insert cols/rows in some case
- Update unit tests
- Upd...

github.com/qax-os/excelize - 0c5cdfec1868f31f6e355cdcb0a91220bad80522 authored over 2 years ago by xuri <[email protected]>

Fix get image content was empty after inserting image

github.com/qax-os/excelize - 961a3e89330ab2cd5257e04384813a7e53ea3744 authored over 2 years ago by xuri <[email protected]>

This closes #1338, fix apply AM/PM format issue

github.com/qax-os/excelize - 00470c17d95cb0f70b57b6fb0092b6f873949cd1 authored over 2 years ago by xuri <[email protected]>

This closes #1323, an error will be returned when set the not exist style ID

github.com/qax-os/excelize - 75ce2317286181e2c250c10206df892278d5b981 authored over 2 years ago by xuri <[email protected]>

This is a breaking change closes #1332 (#1333)

This use `InsertRows` instead of `InsertRow`, and using `InsertCols` instead of `InsertCol`

github.com/qax-os/excelize - 18cd63a548afa1abcddc86a998fdefa3b4cc60c1 authored over 2 years ago by Kostya Privezentsev <[email protected]>

This closes #1330 update non existing sheet error messages (#1331)

github.com/qax-os/excelize - bef49e40eec508a6413e80ee5df7df52f7827424 authored over 2 years ago by davidborry <[email protected]>

This closes #827, add new functions `GetDataValidations` and `GetConditionalFormats` (#1315)

Signed-off-by: chenliu1993 <[email protected]>

github.com/qax-os/excelize - f8667386dcde788d8232b652ac85a138c0d20bf3 authored over 2 years ago by chenliu1993 <[email protected]>

This closes #1247, add new function `SetSheetCol` for set worksheet column values (#1320)

Signed-off-by: cdenicola <[email protected]>
Co-authored-by: cdenicola <cooper.deni...

github.com/qax-os/excelize - 0e9378fec2ab4ba60ed284db4383df86555076d1 authored over 2 years ago by Cooper de Nicola <[email protected]>

This closes #1290 and closes #1328

- Add new smooth field in chart format parameter, support specify if smooth line chart
- Fix dec...

github.com/qax-os/excelize - cb8bca0e92cbec30db10c2a2863ef81fd98a6138 authored over 2 years ago by xuri <[email protected]>

This made library allowing insert EMZ and WMZ format image

- Update dependencies module

github.com/qax-os/excelize - ab12307393461e7055f664d296a3a0e686eebb39 authored over 2 years ago by xuri <[email protected]>

Support encrypt workbook with password #199 (#1324)

github.com/qax-os/excelize - cfa2d603ddb0fac50ca1af3fe1d28fe17a65a6f3 authored over 2 years ago by Sangua633 <[email protected]>

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

github.com/qax-os/excelize - 76f336809f5419343702de5b3284d46feb9ed266 authored over 2 years ago by NaturalGao <[email protected]>

This closes #1319, fix calculate error for formula with negative symbol

- Update unit test and comment for the functions

github.com/qax-os/excelize - d1e76fc432ac5c9bde99591ec5e88e46b62d9c3d authored over 2 years ago by xuri <[email protected]>

This closes #1244 and closes #1314, improving the compatibility with Google Sheet

- Format code with `gofmt`

github.com/qax-os/excelize - 551fb8a9e4b03fe718a339e75aeacc8b5581378a authored over 2 years ago by xuri <[email protected]>

This closes #1312, #1313, fix number format issue

- Add supported options in the docs of the functions `SetSheetPrOptions` and `GetSheetPrOptions`...

github.com/qax-os/excelize - 8152bbb2cec76f074dc18c43f3c66bf8abdf9de0 authored over 2 years ago by xuri <[email protected]>

This closes #1296, add new function `GetRowOpts` for stream reader (#1297)

- Support get rows properties by `GetRowOpts` function
- New exported constant `MaxCellStyles`

github.com/qax-os/excelize - ed91cddea59ce15da87ab744ac20b465a36ed5ef authored over 2 years ago by Thomas Charbonnel <[email protected]>

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 ...

github.com/qax-os/excelize - b8ceaf7bf61daecad8717abec90a8e0badb64806 authored over 2 years ago by EE <[email protected]>

Add new exported `ColorMappingType` used for color transformation

Using `ColorMappingType` color transformation types enumeration for tab color index, ref #1285

github.com/qax-os/excelize - e07dac5c2e308c952c8fdec5e6ad7089ff432ccf authored over 2 years ago by xuri <[email protected]>

This closes #1299 skip write nil values in SetRow (#1301)

Co-authored-by: Thomas Charbonnel <[email protected]>

github.com/qax-os/excelize - 4a029f7e3602ac48b6fbf410b86adac2af64983a authored over 2 years ago by Thomas Charbonnel <[email protected]>

This closes #1298, fix doc properties missing after creating new worksheet

github.com/qax-os/excelize - 504d469d3da34602a9a88bd76669ce44fdbc67cf authored over 2 years ago by xuri <[email protected]>

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 compatibilit...

github.com/qax-os/excelize - fd0eb2bcbf31eccfc2b853dc406e0cfd247f7fb2 authored over 2 years ago by Thomas Charbonnel <[email protected]>

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 docum...

github.com/qax-os/excelize - ebea684ae5c60776d4d8364b7360d0c0603cb3b0 authored over 2 years ago by xuri <[email protected]>

Optimizing line breaks for comments (#1281)

github.com/qax-os/excelize - 0d4c97c88aa9254a4db5a0b9192d0f431ff90e43 authored over 2 years ago by Regan Yue <[email protected]>

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 rang...

github.com/qax-os/excelize - 40ed1d1b81b4d30165bb73e9406e59ddbdb76fe2 authored over 2 years ago by xuri <[email protected]>

adjust `ErrColumnNumber`, rename `TotalColumns` to `MaxColumns` and add new constant `MinColumns` (#1272)

Signed-off-by: Benjamin Lösch <[email protected]>

github.com/qax-os/excelize - 6429588e1448f70539774a88840f094829cb9e07 authored over 2 years ago by MJacred <[email protected]>

This fix potential panic and file corrupted

- Fix the panic when set or get sheet view options on the sheet without views options
- Fix gene...

github.com/qax-os/excelize - e37724c22b95de974f0235e992236d555aa6ad12 authored over 2 years ago by xuri <[email protected]>

This closes #1262, support for dependence formulas calculation

- Add export option `MaxCalcIterations` for specifies the maximum iterations for iterative calcu...

github.com/qax-os/excelize - a65c5846e45fece382f72465f9e858c788dfcfef authored over 2 years ago by xuri <[email protected]>

This closes #1269, made the `NewStreamWriter` function case insensitive to worksheet name

Co-authored-by: xiangyz <[email protected]>

github.com/qax-os/excelize - 1dbed64f105db2a715d963933642839460b6642a authored over 2 years ago by Eagle Xiang <[email protected]>

ref #65, new formula function: DGET

github.com/qax-os/excelize - d74adcbb159280be962918125d20ec8ac67a3f93 authored over 2 years ago by xuri <[email protected]>

ref #65, new formula functions: DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, and DVARP

github.com/qax-os/excelize - 695db4eae06fdc2a049fc50f61e6a60f83013290 authored over 2 years ago by xuri <[email protected]>

Fix CONTRIBUTING doc typo issues (#1266)

github.com/qax-os/excelize - a77d38f04059d4febd2aba8b5656a826af51d9e7 authored over 2 years ago by yeshu <[email protected]>

This closes #1264, fix can't modify cell content issue in some cases

Remove inline rich text when setting cell value and cell formulas

github.com/qax-os/excelize - 18afc88759558478cb6d433e725ccd10d4474f7e authored over 2 years ago by yeshu <[email protected]>

ref #65, new formula function: DAVERAGE

github.com/qax-os/excelize - dd6c3905e0eadd7d02a1c0d90499d27e465216d2 authored over 2 years ago by xuri <[email protected]>

ref #65, new formula functions: DMAX and DMIN

github.com/qax-os/excelize - eee6607e477f229d2459628324cbfae5549f611a authored over 2 years ago by xuri <[email protected]>

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 cr...

github.com/qax-os/excelize - 301f7bc21755cdf7c91c9acd50ddcdcf0285f779 authored over 2 years ago by xuri <[email protected]>

ref #65, new formula function: HYPERLINK

github.com/qax-os/excelize - 2e1b0efadc0519fa4572b2437401bf2993366a07 authored over 2 years ago by xuri <[email protected]>

ref #65, new formula function: EUROCONVERT

github.com/qax-os/excelize - 61c71caf4fdd056a45c69d8f3aea2231da2c074a authored over 2 years ago by xuri <[email protected]>

This closes #1257, fix incorrect worksheet header footer fields order

github.com/qax-os/excelize - 852f211970b47c79cceedd9de934f9aa7520f131 authored over 2 years ago by xuri <[email protected]>

ref #65, new formula function: STEYX

github.com/qax-os/excelize - 7819cd7fec50513786a5d47c6f11a59cceba541a authored over 2 years ago by xuri <[email protected]>

ref #65, new formula function: DAYS360

github.com/qax-os/excelize - 5f4131aece5071cd98ac080b6ace85726d922f19 authored over 2 years ago by xuri <[email protected]>

ref #65, new formula functions: NETWORKDAYS, NETWORKDAYS.INTL, and WORKDAY

github.com/qax-os/excelize - b69da7606395bb2b05c53512663a13cce80f87d7 authored over 2 years ago by xuri <[email protected]>

This closes #1254, `DeleteDataValidation` support delete all data validations in the worksheet

github.com/qax-os/excelize - 5beeeef570e0d5a09de546dfe369a0f3753cf709 authored over 2 years ago by z.hua <[email protected]>

Fix the problem of multi arguments calculation (#1253)

github.com/qax-os/excelize - 7f570c74f8623aec6e8f89ff3701f28c3a256ffe authored over 2 years ago by ww1516123 <[email protected]>

RichTextRun support set superscript and subscript by vertAlign attribute (#1252)

check vertical align enumeration, update set rich text docs and test

github.com/qax-os/excelize - d490a0f86f02f7f2eeabd8a0f38cbaa82a669187 authored over 2 years ago by jialei <[email protected]>

ref #65: new formula function WORKDAY.INTL

github.com/qax-os/excelize - d383f0ae6e253284520d10e574a01b0b904c91d9 authored over 2 years ago by xuri <[email protected]>

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...

github.com/qax-os/excelize - 6bcf5e4ede160af2ad04f5e69636211a5ced132d authored over 2 years ago by Eng Zer Jun <[email protected]>

ref #65: new formula function EOMONTH

github.com/qax-os/excelize - f5d3d59d8c65d9396893ae0156fef21592f6f425 authored over 2 years ago by xuri <[email protected]>

ref #65: new formula function EDATE

github.com/qax-os/excelize - 980fffa2b621e933ab16debf9d9106b005941589 authored over 2 years ago by xuri <[email protected]>

ref #65: new formula function WEEKNUM

github.com/qax-os/excelize - 604a01bf6b3b1e0d95fe3501f6309d3ed78b900c authored over 2 years ago by xuri <[email protected]>

This update docs and tests for workbook encryption

github.com/qax-os/excelize - 8fde918d981e9229b43fc6045b259a1db31cf1f4 authored over 2 years ago by xuri <[email protected]>

This initialized support for encryption workbook by password, ref #199

- Remove exported variable `ErrEncrypt`

github.com/qax-os/excelize - 7a6d5f5ebe5fa9b74ec58b79baf79b369d496e21 authored over 2 years ago by xuri <[email protected]>

This update dependencies module and GitHub Action settings

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+d...

github.com/qax-os/excelize - 551b83afab85f2911410a6fa994fe5cc883d8804 authored over 2 years ago by dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

Improves the calculation engine, docs update, and adds the dependabot

- Initialize array formula support for the formula calculation engine
- Update example and unit ...

github.com/qax-os/excelize - 1c167b96a35a58990f777025914283b492d0785f authored over 2 years ago by xuri <[email protected]>

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 v...

github.com/qax-os/excelize - afb2d27c90130878b82a70b44ccb4e30344cc09e authored over 2 years ago by xuri <[email protected]>

make workbook open filed exception message clear

- New exported constant `ErrWorkbookPassword`
- Rename exported constant `ErrWorkbookExt` to `Er...

github.com/qax-os/excelize - 63adac25897f295ef4493e060d917650f03ebd3b authored over 2 years ago by xuri <[email protected]>

This fixes a part of staticcheck issues and updates the code of conduct

Update example for set cell hyperlinks with `HyperlinkOpts`

github.com/qax-os/excelize - 8f16a76781fb8f47094492c38a02c2cdc4ce5013 authored over 2 years ago by xuri <[email protected]>

This closes #1229, rename ErrMaxFileNameLength to ErrMaxFilePathLength (#1230)

Co-authored-by: sceneq

github.com/qax-os/excelize - be5a4033c0c7de6247c02dc3ab76b634ac19d4c6 authored over 2 years ago by sceneq <[email protected]>

This closed #1163, fix set cell value with column and row style inherit issue

github.com/qax-os/excelize - 19a0cf3cec71fc49851d29fb420674b027f50d93 authored over 2 years ago by xuri <[email protected]>

This made library allowing insert WMF format image

github.com/qax-os/excelize - c2311ce87dd2c681406728f885d2228dbefd7a21 authored over 2 years ago by xuri <[email protected]>

This closes #1225, allowing insert EMF format images

github.com/qax-os/excelize - 0c3fd0223c784ddcc7d2442105b920587b970727 authored over 2 years ago by xuri <[email protected]>

This closes #1219, fixes cell value reading issue, improves performance, and 1904 date system support

- Fix incorrect cell data types casting results when number formatting
- Support set cell value ...

github.com/qax-os/excelize - eed431e0fc2f61b13e7745857a41cb47d9f7f810 authored over 2 years ago by xuri <[email protected]>

This closes #1217, support update cell hyperlink

Ref #1129, make `SetRowStyle` overwrite style of the cells

github.com/qax-os/excelize - 773d4afa32a55349a7b178c4c76d182f9ed0221f authored over 2 years ago by xuri <[email protected]>

This closes #1212, init support for 1900 or 1904 date system

github.com/qax-os/excelize - 856ee57c4019b4478da0f6cb3010ae636914a6be authored over 2 years ago by xuri <[email protected]>

This closes #1213, fix get incorrect rich text value caused by missing cell type checking

github.com/qax-os/excelize - 0f93bd23c97ac0f04fe8012bd4a262c851e44a82 authored over 2 years ago by xuri <[email protected]>

This closes #1211, improve the compatibility with invalid internal styles count

github.com/qax-os/excelize - df91b34a3f816a865ba6f9ea7707c668552df9d6 authored over 2 years ago by xuri <[email protected]>

Optimization formula calculation performance and update README card badge

github.com/qax-os/excelize - 0f7a0c8f3b5c9abd5858cab80902296d1639625f authored over 2 years ago by xuri <[email protected]>

ref #65, new formula function: CONVERT

github.com/qax-os/excelize - 81d9362b4f1cf765712b61837d5b5831d1cd0c58 authored over 2 years ago by xuri <[email protected]>

This closes #1203, supporting same field used for pivot table data and rows/cols

github.com/qax-os/excelize - c2be30ce90621e4473940d521995a6ce97537da6 authored over 2 years ago by xuri <[email protected]>

ref #65, initial formula functions: GROWTH and TREND

github.com/qax-os/excelize - 0b8965dba9cf98fd1f5704ed0d354504c20776fa authored over 2 years ago by xuri <[email protected]>

ref #65, new formula functions: SKEW.P and SLOPE, remove no-required format default

github.com/qax-os/excelize - 6fa950a4f852bd45b81c941877732ec516dcc673 authored over 2 years ago by xuri <[email protected]>

added macro functionality to shape (#1182)

github.com/qax-os/excelize - 5a279321bb494141fb12ac010a33da4a78c6a309 authored over 2 years ago by David <[email protected]>

ref #65, new formula functions: PEARSON and RSQ

github.com/qax-os/excelize - 66776730b605dfef2d01dd8a59afc45d98272eb1 authored over 2 years ago by xuri <[email protected]>

ref #65, new formula functions: MINVERSE and MMULT

github.com/qax-os/excelize - c0d341706d7e6d568bb94444d58799f001a97c3f authored over 2 years ago by xuri <[email protected]>

ref #65, new formula functions: COVARIANCE.S and STDEVPA

github.com/qax-os/excelize - 396cf99d45b0b7f10acd685fab44f34e5c7ee464 authored over 2 years ago by xuri <[email protected]>

This includes new formula functions support, dependencies upgrade, and bug fix

- Fix page setup fields parsing issue
- Go Modules dependencies upgrade
- Ref #65, CONFIDENCE.T ...

github.com/qax-os/excelize - c1940c2a1ebd66519bb85abaa2fd7985f0430985 authored over 2 years ago by xuri <[email protected]>

ref #65, new formula functions: MODE.MULT and MODE.SNGL

github.com/qax-os/excelize - 9b8f1a15e1b75f56d9305b49212ee34ec085943f authored almost 3 years ago by xuri <[email protected]>

ref #65, #1196: fix the compatibility issue and added new formula function

- New formula functions: MODE and T.TEST

github.com/qax-os/excelize - 5bf4bce9d41b2f8cd9d24e0d57a0d6868ef9433d authored almost 3 years ago by xuri <[email protected]>

This closes #1196, fix the compatibility issue and added new formula function

ref #65, new formula functions: TINV and TTEST

github.com/qax-os/excelize - 26174a2c43755dff794a5d2f48a0d5bdf38e5b1b authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: T.INV and T.INV.2T

- Typo fixed

github.com/qax-os/excelize - ecbc6e2fde1941cb5ac9e5f3bfce329e7bfa8825 authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: T.DIST.2T and T.DIST.RT

- Update GitHub Action settings

github.com/qax-os/excelize - be8fc0a4c5795bb793b171c25fd90e0369812a05 authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: T.DIST and TDIST

github.com/qax-os/excelize - b8345731a477633bc82216dbc398faecafaf894f authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: NEGBINOM.DIST and NEGBINOMDIST

github.com/qax-os/excelize - d9b5afc1ac4e085b7f2e6838cb13df6ae6962b7f authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: CHISQ.INV and CHISQ.INV.RT

github.com/qax-os/excelize - 18c48d829133ec395bda8440a04d9f25dcfe11f5 authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: HYPGEOM.DIST and HYPGEOMDIST

github.com/qax-os/excelize - 29d63f6ae0a3411be7e9799c80e6be41997c4f14 authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: F.TEST and FTEST

github.com/qax-os/excelize - 0030e800ca1e151483db96172034122c86ce97fc authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: CHISQ.DIST.RT CHISQ.DIST and GAMMALN.PRECISE

github.com/qax-os/excelize - 46336bc788ce344533524a29bc9858d183f91aeb authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: CHITEST and CHISQ.TEST

github.com/qax-os/excelize - f8d763d0bd6d9e288d68d2b048023bcbefb63bce authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: F.DIST.RT and SERIESSUM

github.com/qax-os/excelize - 17141a963878adc29e1fcc210c488e1ae3fe9da3 authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: F.DIST and FDIST

github.com/qax-os/excelize - 4affeacc45166ba1b1edfe3036249fd6426dc76c authored almost 3 years ago by xuri <[email protected]>

Format code, update documentation and remove exported variable `XMLHeaderByte`

github.com/qax-os/excelize - 8a335225c705232fe1174755a1b1ea475456b864 authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: AVERAGEIFS and SUMPRODUCT

github.com/qax-os/excelize - 139ee4c4b0c86dffbdca77da346e85a4cbd97b0c authored almost 3 years ago by xuri <[email protected]>

ref #65, new formula functions: CRITBINOM and SUMIFS

github.com/qax-os/excelize - 797958210d018a7b898737309b53de53d050316a authored almost 3 years ago by xuri <[email protected]>

This closes #1185, fix formula function calculation result precision issue on arm64

* New formula functions: BINOM.DIST.RANGE and BINOM.INV
* Fix complex number calculation result ...

github.com/qax-os/excelize - 067c5d564383aa56f91fc0b9250352a5542c1e6f authored almost 3 years ago by xuri <[email protected]>