Reading\Writing to\from Drop List Cells

Hi there. I am trying to set a cell that contains two choices. TRUE\FALSE. I can read the cell value. However, when I set it, I get some really undefined results from a worksheet that normally plays very nice with these two choices. I get crazy calculations after I set it, so is there something I am missing in setting the value in here? I am guessing that I cannot just send the text to the field. There is another field that reads from this one as a 0 or a 1 and calculates based on that. Is there a special way to set values in a drop list cell?

Hi,

Thanks for your posting and using Aspose.Cells.

We think, Cell.GetValidationValue() and Cell.GetValidation() methods may help you. Please see this article for your reference.

( Verify that Cell Value Satisfies Data Validation Rules|Documentation )

Unfortunately, these methods are throwing exception for dropdown lists. Please clarify your requirements more and illustrate it with screenshots, sample code and sample excel files.

You may also download and try the latest version: Aspose.Cells for .NET v8.7.2.5 to see if it makes any difference and resolves your issue.

Let us know your feedback.