This project has moved. 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(

RelType

.Workbook);

rIdSub =

Int32

.Parse(rId.Substring(3));

}

Coordinator
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).

Thanks,