This project has moved and is read-only. For the latest updates, please go here.

some problem

Jul 12, 2011 at 10:35 AM

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 XLDataValidation(dv)));


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 :


while (WorksheetsInternal.Cast<XLWorksheet

>().Any(w => w.SheetId == rIdSub))


rId = context.RelIdGenerator.GetNext(



rIdSub =




Jul 12, 2011 at 4:24 PM

Please create an entry in the Issue Tracker tab and attach the file with the worksheet you're trying to copy (or a sample file that reproduces the error if it has sensitive information).