hi, i took the latest source code and there was some problem
when i copy a worksheet wich contains data validation, the resulting xlsx when opening complains about data validation ands need to be repaired, in
in xlworksheet.cs , line 628, i comment it
// DataValidations.ForEach(dv => targetSheet.DataValidations.Add(new
another issue is when i delete a worksheet, when saving it get stucked in GenerateWorkbookPartContent, in XLWorkbook_Save line 372.
i changed the while loop to this :
>().Any(w => w.SheetId == rIdSub))
rId = context.RelIdGenerator.GetNext(