summaryrefslogtreecommitdiff
path: root/datavalidation.go
Commit message (Collapse)AuthorAge
* This closes #1360, closes #1361xuri2022-09-28
| | | | | | | - Fix default number format parse issue with a long string of digits - Fix creating a sheet with an empty name cause a corrupted file - The `GetCellStyle` function no longer return master cell style of the merge cell range - Using the specialized name in variables and functions
* This closes #827, add new functions `GetDataValidations` and ↵chenliu19932022-08-27
| | | | | `GetConditionalFormats` (#1315) Signed-off-by: chenliu1993 <13630583107@163.com>
* This closes #1244 and closes #1314, improving the compatibility with Google ↵xuri2022-08-13
| | | | | | Sheet - Format code with `gofmt`
* This closes #1254, `DeleteDataValidation` support delete all data ↵z.hua2022-06-15
| | | | validations in the worksheet
* Format code, update documentation and remove exported variable `XMLHeaderByte`xuri2022-03-24
|
* 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
* Fix file corrupted in some cases, check file extension and format codexuri2022-01-23
| | | | | | Fix file corrupted when save as in XLAM / XLSM / XLTM / XLTX extension in some case New exported error ErrWorkbookExt has been added, and check file extension on save the workbook Format source code with `gofumpt`
* 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
|
* 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`
* This closes #986, fix set data validation drop list failed in some casesxuri2021-08-12
| | | | Update documentation for `GetCellValue` and simplify code
* 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.
* This closes #971, closes #972 and closes #974xuri2021-07-29
| | | | | | | | - Escape XML character in the drop list - Fix incorrect character count limit in the drop list - Fix Excel time parse issue in some case - Fix custom number format month parse issue in some case - Fix corrupted file generated caused by concurrency adding pictures
* 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
* support range validation for decimal (#739)jacentsao2020-12-10
| | | Co-authored-by: jacen_cao <jacentsao@kingdee.com>
* Update docs and typo fixedxuri2020-06-22
|
* Resolve #348, support delete Data Validationxuri2020-03-13
|
* Improve code coverage unit testsxuri2019-12-29
|
* Documentation updated, Go 1.10+ requiredxuri2019-08-11
|
* Fix invalid formula in data validation drop listxuri2019-07-22
|
* Fix structs fields definition errors and keep double quotes in data ↵xuri2019-05-04
| | | | validation formula
* godoc update and typo fixedxuri2019-04-20
|
* Resolve #369,#370xuri2019-04-15
| | | | | | | | | | | | | | | | | | add error return value exported functions: GetMergeCells ProtectSheet UnprotectSheet UpdateLinkedValue GetMergeCells SetSheetVisible inner functions: workSheetReader copySheet
* fix: datavalidation list error, formula > 255 issue #339rentiansheng2019-01-23
|
* README updatedxuri2019-01-01
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* Comments style changed.xuri2018-09-14
|
* 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 function doc and fix golint errorxuri2018-09-01
|
* add datavalidation test and fixed struct bug issue #240rentiansheng2018-09-01
|
* data validation funcationrentiansheng2018-07-30
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 00:28:30 +0000