ClosedXML icon indicating copy to clipboard operation
ClosedXML copied to clipboard

DataValidation wiki 3 years out of date.

Open doug-w opened this issue 1 year ago • 0 comments

Read and complete the full issue template

Do not randomly delete sections. They are here for a reason.

Do you want to request a feature or report a bug?

  • [] Bug
  • [ ] Feature
  • [X] Question

Did you test against the latest CI build?

  • [X] Yes
  • [ ] No

If you answered No, please test with the latest development build first.

Version of ClosedXML

0.102.2

What is the current behavior?

Documentation at https://github.com/ClosedXML/ClosedXML/wiki/Data-Validation refers to

ws.Cell(1, 1).DataValidation.Decimal.Between(1, 5);

The DataValidation field was removed in 2021 in this change https://github.com/ClosedXML/ClosedXML/commit/478706c55db2cc39bfa1d01e80550d34ff1a1660

What is the expected behavior or new feature?

Documentation is accurate to use CreateDataValidation() (I think?)

Is this a regression from the previous version?

This would be a regression for all versions since and including 0.96.0

Reproducibility

Code as written in wiki fails to compile:

Code to reproduce problem:

public void Main()
{
   var wb = new XLWorkbook();
   var ws = wb.Worksheets.Add("Data Validation");
   ws.Cell(1, 1).DataValidation.Decimal.Between(1, 5);
}

doug-w avatar May 23 '24 23:05 doug-w