Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet.

Mon Aug 27, 2018 5:01 am

I use Spire.xls to build a Excel 2007 with DataValidation property in it,
The DataValidation cell shows checkBox well in Microsoft Excel Application but miss in Spire.Spread V2.8.3 ;
Is that Spire.Spread V2.8.3 doesn't support DataValidation property?

Codes as:
Validation listValidation = sheet.Range["A1"].DataValidation;
listValidation.Values = new string[] {"false", "true"};

Thank you!

Posts: 5
Joined: Tue Jul 03, 2018 3:19 am

Mon Aug 27, 2018 10:26 am


Thanks for you post.
Our Spire.SpreadSheet doesn't support showing the checkbox at present. We will consider adding it as a new feature into our upgrade list. If it is realized, we will let you know.

E-iceblue support team
User avatar

Posts: 1138
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.Spreadsheet