Hello
I've attached a workbook in which I'm testing/learning the software. Cell E15 contains a custom validation formula (E15=F15). DataValidation.Formula1 shows an incorrect formula(I29=J29).
Could you please verify the case?
Regards
byte[] b2 = File.ReadAllBytes(FilePath);
MemoryStream stream2 = new MemoryStream(b2);
stream2.Write(b2, 0, b2.Length);
Spire.Xls.Workbook SpireWorkbook = new Spire.Xls.Workbook();
SpireWorkbook.LoadFromStream(stream2);
Spire.Xls.Worksheet SpireSheet = SpireWorkbook.Worksheets["Sheet1"];
Spire.Xls.CellRange SpireCell = SpireSheet.Range["E10"];
string s1 = SpireCell.DataValidation.Formula1;
string s2 = SpireCell.DataValidation.Formula2;
stream2 = new MemoryStream();
SpireWorkbook.SaveToStream(stream2);
File.WriteAllBytes(FilePath, stream2.ToArray());