GrapeCity.Documents.Excel.PasteOption.AllowPasteHiddenRange

AllowPasteHiddenRange Property

AllowPasteHiddenRange

Gets or sets whether hidden cells in the copied range are included in the paste operation.

Use this property with Copy(IRange, PasteOption) to determine whether content from hidden rows or columns is pasted. A new PasteOption instance allows pasting hidden ranges by default.

Declaration

public bool AllowPasteHiddenRange { get; set; }

Public Property AllowPasteHiddenRange As Boolean

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Value"},
    {"Alice", 100},
    {"Bob", 200}
};
worksheet.Range["2:2"].Hidden = true;

PasteOption option = new PasteOption();
option.AllowPasteHiddenRange = false;
bool allowPasteHiddenRange = option.AllowPasteHiddenRange;
worksheet.Range["A1:B3"].Copy(worksheet.Range["D10"], option);