if filter is set in program like below

worksheet.FilterSettings.SetRegion("A2:G2");

String[] categories = new string[] {"High", "Medium"};

worksheet.FilterSettings.ApplyFixedValuesFilter(0, false, categories);

filter is set and it odes not support insert copy row command on Excel. and cannot insert row

the reason why above code needed was to set filtering on worksheet.

If a customer sets worksheet filtering in excel, nothing has been filtered out and can insert rows.

Summary: 

The customer wants to achieve following state with Excel Library - worksheet filtering is on, but nothing is filtered