We will get back to you soon with details on specific validation rule for your requirements.
@nagasivaos
Please add the below code for this spread sheet file prduction_worksheet_0205.xlsx. After removing the date validation, it can be loaded.
GridValidationCollection vcs = GWExcelEditor.WorkSheets[4].Validations;
for(int i= vcs.Count-1; i>=0;i--)
{
Console.WriteLine(i+" validation info: type:"+ vcs[i].ValidationType+ " , "+vcs[i].Formula1 +" "+ vcs[i].Formula2);
ArrayList list = vcs[i].AreaList;
foreach(GridCellArea area in list)
{
Console.WriteLine(i + " area in validation " +area.StartRow+" "+area.StartColumn) ;
}
if(vcs[i].ValidationType==GridValidationType.Date)
{// just remove the date validation, we now have issues when parse the value
vcs.RemoveAt(i);
Console.WriteLine(i + " removed validation " );
}
}
//the first visible worksheet: NOTES & RATING
Console.WriteLine(GWExcelEditor.WorkSheets[4].Name);
The issues you have found earlier (filed as CELLSNET-55077,CELLSNET-55117,CELLSNET-55118) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi