Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

excelize

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
Collective - Host: opensource - https://opencollective.com/excelize - Website: https://xuri.me/excelize - Code: https://github.com/xuri/excelize

ref #65, #1185, new formula functions and precision improvement

* New formula functions: BETA.DIST, BINOMDIST and BINOM
* Fix a part of formula function calcula...

github.com/qax-os/excelize - 49424b0eb3e35201fd7f922a1ad80b6c4d4976c4 authored almost 3 years ago by xuri <[email protected]>
This improved formula calculate precision and added zero placeholder number format support

github.com/qax-os/excelize - 94f197c4fe6531f96a42fe4e960c1c921a3ee0e8 authored almost 3 years ago by xuri <[email protected]>
This fix scientific notation and page setup fields parsing issue

github.com/qax-os/excelize - 14b461420fc3d3b06b01d7b0584b422b3e1b40fb authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions: CHIINV and BETADIST

github.com/qax-os/excelize - 1da129a3df144d69cfc67f05a4dec88063a774e8 authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions: LOGNORM.DIST and LOGNORMDIST

github.com/qax-os/excelize - c3424a9a0fc4f62b4884701e1430b420bbd8d0e4 authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions: LOGNORM.INV and LOGINV

* Update docs for the function `SetCellHyperLink`

github.com/qax-os/excelize - 4220bf4327a35a07ac6b47b652a120ed978a3a2a authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions: GAMMA.INV and GAMMAINV and format code

github.com/qax-os/excelize - e1d660dda7c02475a8529a252e6c1fd171065429 authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions: GAMMA.DIST and GAMMADIST

github.com/qax-os/excelize - 361611c23ae56cac091d5c7d73f5ea305b5bd3fc authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions: F.INV and GAUSS

github.com/qax-os/excelize - aee7bdd3a07cbf7f436bf79461b170a3823c3fa1 authored almost 3 years ago by xuri <[email protected]>
This closes #1172, support set hole size for doughnut (#1173)

github.com/qax-os/excelize - 74b1a998d6018785878ac43b4a4bdcb906766a40 authored almost 3 years ago by longphee <[email protected]>
ref #65, new formula functions and read boolean data type cell value support

* added 3 new formula functions: BETAINV, BETA.INV, F.INV.RT

github.com/qax-os/excelize - 56aa6b82637b3210be470a8ebac1fdec2b2a6a30 authored almost 3 years ago by xuri <[email protected]>
This closes #1171, improve the compatibility and added new formula function

ref #65, added new formula function: FINV

github.com/qax-os/excelize - 61eb265c29685957bcf16b25dba3d389c548dfee authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions: CORREL, SUMX2MY2, SUMX2PY2, and SUMXMY2

github.com/qax-os/excelize - 354d1696d8999ea00cb420f633a9abaae67228b6 authored almost 3 years ago by xuri <[email protected]>
This closes #1162, improve the compatibility with alternate content

Preserve alternate content in the workbook, worksheet, and drawingML

github.com/qax-os/excelize - f0cb29cf6668ab96992b1e48278d9f5b1f9e4976 authored almost 3 years ago by xuri <[email protected]>
This closes #1164, fix nested formula calculation result error

github.com/qax-os/excelize - 129052ae7db0fd2c59b1ea9158df0e75450cad42 authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions: COVAR, COVARIANCE.P, EXPON.DIST and EXPONDIST

github.com/qax-os/excelize - 3971e8a48b25614dfe685c4766c1bb66cd22fe18 authored almost 3 years ago by xuri <[email protected]>
ref #65, new formula functions FORMULATEXT and TYPE

github.com/qax-os/excelize - 1efa2838875efe06a9a4b7b1d582f70205de3aa5 authored almost 3 years ago by xuri <[email protected]>
ref #65: formula function INDIRECT support and formula engine improvement

Support calculation with the none parameter formula function after infix operator notation

github.com/qax-os/excelize - 42a9665aa91912f570bb83052b20cc50529d7b6a authored almost 3 years ago by xuri <[email protected]>
This closes #1160, and added 4 new formula functions

* Fix show sheet tabs issue
* Ref #65, new formula functions: ERROR.TYPE, HOUR, SECOND TIMEVALUE

github.com/qax-os/excelize - 471c8f22d0ac6cc17915eea25d171e578c06ac7d authored almost 3 years ago by xuri <[email protected]>
This improvement number format support

* Local month name and AM/PM format support Tibetan and Traditional Mongolian
* Support text pla...

github.com/qax-os/excelize - 92764195dc548ab80f336f83a283000cd45eeb34 authored almost 3 years ago by xuri <[email protected]>
This fixed code review issue in PR #1154 (#1159)

github.com/qax-os/excelize - 3231817169051fd2cd3452d276447e488a3a70b9 authored almost 3 years ago by wangxuliBY <[email protected]>
Improvement local month name and AM/PM format support in number format

* Support for the Vietnamese, Wolof and Xhosa

github.com/qax-os/excelize - e84130e55cdd172f9d07beaa563053aee40f645e authored almost 3 years ago by xuri <[email protected]>
Improvement local month name and AM/PM format support in number format

* Support for the Irish, Russian, Spanish, Thai, Turkish, Welsh, Yi, and Zulu

github.com/qax-os/excelize - 8a6815fcccc1c9f005b615fb2eb008e6af6aacd9 authored almost 3 years ago by xuri <[email protected]>
Fixed parsing decimal precision issue

github.com/qax-os/excelize - 07be99363156b2d1011954be7b5a4cc8f33b256b authored almost 3 years ago by xuri <[email protected]>
This closes #1148, resolve limitations when adding VBA project to the workbook

Added two exported functions `SetWorkbookPrOptions` and `GetWorkbookPrOptions` to support settin...

github.com/qax-os/excelize - f87c39c41ddcb2fbb75a6035ba1dd28e4de8c71b authored almost 3 years ago by xuri <[email protected]>
Initialize local month name and AM/PM format support for number format

github.com/qax-os/excelize - ad09698515b4f70496c950cca02ce612af8170e0 authored almost 3 years ago by xuri <[email protected]>
Ref: #660, #764, #1093, #1112, #1133 This improve number format support

- Introduced NFP (number format parser) dependencies module
- Initialize custom dates and times ...

github.com/qax-os/excelize - 4b64b26c52932a51ca97a2bb6bf372a07020e52b authored almost 3 years ago by xuri <[email protected]>
This closes #1139, `SetCellDefault` support non-numeric value

- Add default value on getting `View` property of sheet views
- Add examples and unit test for s...

github.com/qax-os/excelize - 3f8f4f52e68d408da5a2e5108af3cc99bf8586bc authored almost 3 years ago by xuri <[email protected]>
Support workbook views Showruler settings (#1138)

github.com/qax-os/excelize - 0f1fcb78d5518695cb80cc2266290e37df38a1ee authored almost 3 years ago by David <[email protected]>
Support workbook views settings (#1136)

github.com/qax-os/excelize - 862dc9dc1324e11a517b03267d07dd95051d5e6e authored almost 3 years ago by David <[email protected]>
This closes #1129, make cell support inheritance columns/rows style

Correct cells style in merge range
Fix incorrect style ID returned on getting cell style in some...

github.com/qax-os/excelize - 156bf6d16ecbd5257d81e781138eaaaf357ffbec authored almost 3 years ago by xuri <[email protected]>
Fix file corrupted in some cases, check file extension and format code

Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case
New exported...

github.com/qax-os/excelize - 3ee3c38f9c63de3782fad21aae9c05ee0530fc32 authored almost 3 years ago by xuri <[email protected]>
ref #1054, breaking change for the column and row's iterator

This removed 3 exported functions: `TotalCols`, `CurrentCol` and `CurrentRow`

github.com/qax-os/excelize - 74f6ea94eae45c8fb89a23cc94802e57ce279a84 authored almost 3 years ago by xuri <[email protected]>
Breaking change: remove `TotalRows` of row iterator and performance optimization

Reduce allocation memory 20%, and 80% GC times for the row's iterator

github.com/qax-os/excelize - 4daa6ed0b46fdd994e46403feb049b162eca19b8 authored almost 3 years ago by xuri <[email protected]>
This closes #1122, improve compatibility with LibreOffice

Fixed the issue auto filter doesn't work on LibreOffice if the sheet name has spaces

github.com/qax-os/excelize - 50c4dedf8ddb4a7a696a668946bb536c2e8e5623 authored almost 3 years ago by xuri <[email protected]>
This closes #1119, style parsing issue fixed

github.com/qax-os/excelize - 236ee61d201e45b1fe33a58b290adb7ee32d3488 authored almost 3 years ago by xuri <[email protected]>
Fix adjustMergeCells not modifies cell rect (#1118)

github.com/qax-os/excelize - 67127883dddf6a923d12231da8b089861bcca28c authored almost 3 years ago by Dokiy <[email protected]>
Breaking change for data validation and fixed #1117

- Remove second useless parameter `isCurrentSheet` of the function `SetSqrefDropList`
- Fix miss...

github.com/qax-os/excelize - b96329cc88b87da25a4389f1d4d5ad08cd40605a authored almost 3 years ago by xuri <[email protected]>
ref #1096, reduce memory usage by about 50% for large data spreadsheet

github.com/qax-os/excelize - 891e5baac1a6ac67123fbc6a68f801720882b8ec authored almost 3 years ago by xuri <[email protected]>
Typo fix, rename exported constants, dependencies modules and copyright update

Rename exported constants `NameSpaceDublinCoreMetadataIntiative` to `NameSpaceDublinCoreMetadata...

github.com/qax-os/excelize - 2245fccca0beb25a1bf309a1c9cbd273512f125a authored about 3 years ago by xuri <[email protected]>
feat: implement SHA-512 algorithm to ProtectSheet (#1115)

github.com/qax-os/excelize - af5c4d00e81b62a3f6ff6cb34a89502400552a2d authored about 3 years ago by Jonham.Chen <[email protected]>
Update create style example, using a pointer of the structure instead of JSON

github.com/qax-os/excelize - 9e64df6a96685afcfbc7295beda38739868a6871 authored about 3 years ago by xuri <[email protected]>
This closes #1107, stream writer will create a time number format for time type cells

Unit test coverage improved

github.com/qax-os/excelize - e37e060d6f97274c1e967cea40609623493bce25 authored about 3 years ago by xuri <[email protected]>
Preserve horizontal tab character when set the cell value (#1108)

github.com/qax-os/excelize - c5990ea3484932fd6066c04e36c63735889a8228 authored about 3 years ago by vst <[email protected]>
This closes #1096, memory usage optimization and another 4 changes

- Unzip shared string table to system temporary file when large inner XML, reduce memory usage a...

github.com/qax-os/excelize - 89b85934f60ba0012f3de6da03eb12959e4b4b72 authored about 3 years ago by xuri <[email protected]>
This closes #1095, support to set and get document application properties

github.com/qax-os/excelize - 6b1e592cbc7b1412da5f6d0badeaf1083117c762 authored about 3 years ago by xuri <[email protected]>
This closes #1097, initialized formula function XLOOKUP and update test

github.com/qax-os/excelize - 089cd365a33c1cb0b50af2f4e766a05468cb8277 authored about 3 years ago by xuri <[email protected]>
ref #65, new formula functions MAXIFS and MINIFS

github.com/qax-os/excelize - 6051434bf8988947e2a9688ff2359768db385087 authored about 3 years ago by xuri <[email protected]>
new formula function and update docs for formula functions

ref #65, new formula function: INDEX (array formula not support yet)

github.com/qax-os/excelize - 63fe422299ed9d31d079711d1173b288faa6838d authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function COUNTIFS

github.com/qax-os/excelize - c0ac3165bd8923efdaf95b377771d14f5879b1ec authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions: AVERAGEIF and COUNTIF

github.com/qax-os/excelize - 33719334945f0ce0752cedfbd4267b83850ab85d authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function: SHEETS, and fix SHEET function count issue

github.com/qax-os/excelize - 76aacfda0b7c0b3b21c2e0909b0f24eb9c5769a4 authored about 3 years ago by xuri <[email protected]>
This closes #1090 (#1092)

Keep track of operators per function

github.com/qax-os/excelize - b33e39369aa3898d2f6e079240545f9d84abec73 authored about 3 years ago by jaby <[email protected]>
ref #65: new formula functions: ISFORMULA, ISLOGICAL and ISREF

github.com/qax-os/excelize - 1b3040659d3155732961c45b0c2e13e39e0b2576 authored about 3 years ago by xuri <[email protected]>
This closes #1088 (#1089)

Support check string equality with the string value of a defined name

github.com/qax-os/excelize - 5bf35f8c1c18eafb2e423ae3b77868bcccc505ff authored about 3 years ago by jaby <[email protected]>
Export 7 errors so users can act differently on different type of errors

github.com/qax-os/excelize - 44a13aa402b0189b119635d2f0a26961795c6bda authored about 3 years ago by xuri <[email protected]>
Fix adjustMergeCellsHelper and add some test cases (#1082)

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

github.com/qax-os/excelize - 3325c3946d0ab77083555bab334381a1167ee580 authored about 3 years ago by Dokiy <[email protected]>
ref #65: new formula function ODDFPRICE

github.com/qax-os/excelize - 7af55a54552d36805ed9ad2e2173757fd6626a55 authored about 3 years ago by xuri <[email protected]>
Update docs for SetSheetStyle, and added 2 formula functions

ref #65: new formula functions DURATION and MDURATION
fix incorrect example in SetSheetStyle docs

github.com/qax-os/excelize - e0c6fa1beb0f1025489bbd21859bc9134c1d661a authored about 3 years ago by xuri <[email protected]>
Simplify code and update unit test

Improve unit test coverage for the functions: `NewStyle`, `SetActiveSheet`, `SearchSheet` and `d...

github.com/qax-os/excelize - 577a07f08c6121d627323db00fdf9e74989a5515 authored about 3 years ago by xuri <[email protected]>
refactor DeleteSheet for better readability (#1078)

Signed-off-by: Michael Wiesenbauer <[email protected]>
Co-authored-by: Michael Wiese...

github.com/qax-os/excelize - aa359f1c748b5cbdc57ae032255e8b8940001e0b authored about 3 years ago by Michael Wiesenbauer <[email protected]>
Merge pull request #1077 from Dokiys/hotfix/get_num_fmt_id

Fix call getNumFmtID with builtInNumFmt return -1

github.com/qax-os/excelize - 4ca1b305fe5b4117aeee5e8626ff49b8ee1a7abe authored about 3 years ago by xuri <[email protected]>
Fix call getNumFmtID with builtInNumFmt return -1

github.com/qax-os/excelize - 45a1f08a2ad12ec613fd435ba5efcb830e617a71 authored about 3 years ago by Dokiy <[email protected]>
This closes #1075, reload temporary files into memory on save

github.com/qax-os/excelize - bb0eb4a42be2c004a3c2ce59a8c748a9822b5f99 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function YIELD

github.com/qax-os/excelize - 49c9ea40d7cf7c20e9b94723c84780f4d048f4a4 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions CONFIDENCE and CONFIDENCE.NORM

github.com/qax-os/excelize - f26df480e56561c30f9453a98ebf788acd48c3e2 authored about 3 years ago by xuri <[email protected]>
This closes #1069, support time zone location when set cell value

github.com/qax-os/excelize - 7907650a97115dbb771c7b977c5f260a1ff1cc65 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function VDB

github.com/qax-os/excelize - 9561976074eb3f8260845735bf6028a5d5f3bd71 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function XIRR

github.com/qax-os/excelize - a6c8803e91018898f8e6f960340709e970a99560 authored about 3 years ago by xuri <[email protected]>
This closes #1060, fix build-in time number format parse error

github.com/qax-os/excelize - 9b0aa7ac30c69dc0975c8945103dcf909d080912 authored about 3 years ago by xuri <[email protected]>
Fix sheet deletion fail in some case

github.com/qax-os/excelize - 6b277c61d22419b1006e9b5c557e1175fb2f2d99 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function PRICE

- fix COUPPCD result accuracy issue
- update close spreadsheet example in documentation and README

github.com/qax-os/excelize - bc3c7d51a2efe5f0ad85667a8f9636f13941d577 authored about 3 years ago by xuri <[email protected]>
This closes #1061, support multi-byte language on set header footer

typo fixed and simplify code for read the data values arguments of formula functions

github.com/qax-os/excelize - bda8e7f8129dae0064c47f8e051f76492e1128f5 authored about 3 years ago by xuri <[email protected]>
ref #65, new formula functions: COUPDAYBS, COUPDAYS and COUPDAYSNC

github.com/qax-os/excelize - 72410361b07e7539037252467a38a73b32986dce authored about 3 years ago by xuri <[email protected]>
This closes #1057, merge column styles to reduce spreadsheet size

github.com/qax-os/excelize - 57275db22e3a7f9dce51556f7579b704b8033dcb authored about 3 years ago by xuri <[email protected]>
This closes #1059, represent boolean in XML as 0/1 rather than true/false

github.com/qax-os/excelize - adecf447e15244207af5dfb7177447d278db7526 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function MINUTE

github.com/qax-os/excelize - 5de671f8bb8a4d8951d5511c3bd1745fc46ce842 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula function XNPV

github.com/qax-os/excelize - 00eece4f53f034a8dff009330ca45f1012e64ee3 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions PERCENTRANK.EXC, PERCENTRANK.INC and PERCENTRANK

github.com/qax-os/excelize - a68bc34b0c60143bc649415fd7ff7acca70d6bdf authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions COUPNCD and COUPNUM

github.com/qax-os/excelize - 8f82d8b02909ca96a9c7f7c3431d1ae990c90191 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions COUPPCD and PRICEMAT

github.com/qax-os/excelize - 1df76b583c1b77fb37f14d30a54ff5f356280f60 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions PERCENTILE.EXC, QUARTILE.EXC and VAR.S

github.com/qax-os/excelize - 02b0fdf2c97bbdff35bc77bacf9126cb42e4f880 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions VAR, VARA and VARPA

github.com/qax-os/excelize - 8d21959da39eba34d04475c3549496c8dfd823da authored about 3 years ago by xuri <[email protected]>
Support get current row/col and total rows/cols in the stream reader (#1054)

github.com/qax-os/excelize - 60b13affbda954261888a7829c88a32993edb5b2 authored about 3 years ago by li <[email protected]>
ref #65: new formula functions STANDARDIZE, STDEV.P and STDEVP

github.com/qax-os/excelize - e64775fdcc38a9bc882ef32b4d4d491ad63acbdd authored about 3 years ago by xuri <[email protected]>
return immediately when matched for efficiency (#1049)

github.com/qax-os/excelize - 32548a6cac35caced7d016074c2de4219ad5de01 authored about 3 years ago by Sean Liang <[email protected]>
ref #65: new formula functions ERF, ERF.PRECISE, ERFC and ERFC.PRECISE

github.com/qax-os/excelize - 08ad10f68e0c603bac1499a0d7b93b251123a54b authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions DELTA and GESTEP

github.com/qax-os/excelize - b0eb9ef807afb46b1b4f7932b4e08da1780e4fc1 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions ACCRINT and ISOWEEKNUM

github.com/qax-os/excelize - 3447cfecf2402f58e4667b9995dfa21e949b9b69 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions DEVSQ and GEOMEAN

github.com/qax-os/excelize - 3bb2849e419e07d0f582537a3dc48f7a265596a8 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions RATE and RECEIVED (#1045)

github.com/qax-os/excelize - 9cc66948307300b9bac41dc38e39f7e1d7810fd0 authored about 3 years ago by Jerring <[email protected]>
ref #65: new formula functions PV, RANK and RANK.EQ

github.com/qax-os/excelize - 8932a0a0c34b67c5a1c1b2ffa757885def4cc5d4 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions VALUE and WEEKDAY

github.com/qax-os/excelize - 5c4627a0c2ac631aceda207b55f25df195185517 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions SWITCH and TRIMMEAN

github.com/qax-os/excelize - ffc998941c12f84917e15b74e6db7a936d5aab76 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions TBILLPRICE and TBILLYIELD

github.com/qax-os/excelize - 2e9635ece8ecf2617b0144451029aeca78edd9d9 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions TBILLEQ and TEXTJOIN

github.com/qax-os/excelize - 08087e12333542dddfc7be2c87c3333171ee0ffa authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions YIELDDISC and YIELDMAT

github.com/qax-os/excelize - 154effdf82df2f662b91361006c46a69c3cd3635 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions AVEDEV and CHIDIST

github.com/qax-os/excelize - 71684d966aaddf1cfa178f1c2a1677b0a1106766 authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions ADDRESS and PRICEDISC

github.com/qax-os/excelize - f126f635629d1029660f1960184d226f35d7947f authored about 3 years ago by xuri <[email protected]>
ref #65: new formula functions DISC and INTRATE

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