summaryrefslogtreecommitdiff
path: root/datavalidation_test.go
Commit message (Collapse)AuthorAge
* This closes #1330 update non existing sheet error messages (#1331)davidborry2022-08-28
|
* This closes #827, add new functions `GetDataValidations` and ↵chenliu19932022-08-27
| | | | | `GetConditionalFormats` (#1315) Signed-off-by: chenliu1993 <13630583107@163.com>
* 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
* This closes #1148, resolve limitations when adding VBA project to the workbookxuri2022-02-17
| | | | | | | | Added two exported functions `SetWorkbookPrOptions` and `GetWorkbookPrOptions` to support setting and getting the code name property of the workbook Re-order fields of the workbook properties group to improve the compatibility Go Modules dependencies upgrade Put workbook related operating in new `workbook.go` source code Library introduction docs block updated
* 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
* 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
|
* Export 7 errors so users can act differently on different type of errorsxuri2021-12-07
|
* 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
* This closes #1012, support specify the formula in the data validation range, ↵xuri2021-08-26
| | | | and update the documentation for the `AddPicture`
* Improve security and simplify codexuri2021-08-15
| | | | | | | - Make variable name more semantic - Reduce cyclomatic complexities for the formula calculate function - Support specified unzip size limit on open file options, avoid zip bombs vulnerability attack - Typo fix for documentation and error message
* This closes #979, fix the data validation deletion issue and tidy the ↵xuri2021-08-06
| | | | internal function in the source code
* Fix data validation issues (#975)Arnie972021-07-31
| | | | | | | | | | | | | | | | | | | | | | * Fix `SetDropList` to allow XML special characters * This closes #971, allow quotation marks in SetDropList() This patch included a XML entity mapping table instead of xml.EscapeText() to be fully compatible with Microsoft Excel. * This closes #972, allow more than 255 bytes of validation formulas This patch changed the string length calculation unit of data validation formulas from UTF-8 bytes to UTF-16 code units. * Add unit tests for SetDropList() * Fix: allow MaxFloat64 to be used in validation range 17 decimal significant digits should be more than enough to represent every IEEE-754 double-precision float number without losing precision, and numbers in this form will never reach the Excel limitation of 255 UTF-16 code units.
* Go 1.15 and later required, #65 fn: IMABS, IMCOS, IMCOSH, IMCOT, IMCSC, ↵xuri2021-04-04
| | | | IMCSCH, IMEXP, IMLN and IMLOG10
* #65 fn: N, PERCENTILE.INC and Txuri2021-03-30
| | | | typo fixed
* Resolve #348, support delete Data Validationxuri2020-03-13
|
* Improve code coverage unit testsxuri2019-12-29
|
* optimization: checking error in unit testsxuri2019-12-24
|
* Improve code coverage unit testsxuri2019-12-22
|
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* Resolve #394, init set header and footer supportxuri2019-05-05
|
* fix: datavalidation list error, formula > 255 issue #339rentiansheng2019-01-23
|
* New feature: File.DuplicateRowTo() duplicate row to specified row position.Veniamin Albaev2019-01-10
| | | | | | | | DuplicateRowTo() is similar to DuplicateRow() but copies specified row not just after specified source row but to any other specified position below or above source row. Also I made minor modifications of tests: using filepath.Join() instead of direct unix-way paths strings to avoid possible tests fails on other OS.
* README updatedxuri2019-01-01
|
* Tests refactoringVeniamin Albaev2018-12-27
| | | | | | | | | | | Primary motivation: Avoid statefull tests with not ignorable git file tree changes. Multiple tests reads and overwrites signle file for won needs. Multiple tests reads and overwrites file under version control. Secondary motivation: Minimal tests logic aligment, separate error expectation and not error expectation tests. Introduce sub-test over test data sets and so far. This commit is not ideal but necessary (IMHO)
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* New function `AddPictureFromBytes()` has been added, this resolve #259 and ↵xuri2018-09-14
| | | | close #271.
* Complete unit testing case for data validationxuri2018-09-13
|
* Fix golint errors under confidence 0.1xuri2018-09-12
|
* data validation drop-down list use sqref cell issue #268rentiansheng2018-09-04
|
* Fix typo.xuri2018-09-02
|
* add datavalidation test and fixed struct bug issue #240rentiansheng2018-09-01