Edit

Excel.ClearApplyTo enum

Package:
excel

Remarks

[Api set: ExcelApi 1.1]

Fields

all = "All"

Clears everything in the range.

  • [Api set: ExcelApi 1.1]
contents = "Contents"

Clears the contents of the range, leaving formatting intact.

  • [Api set: ExcelApi 1.1]
formats = "Formats"

Clears all formatting for the range, leaving values intact.

  • [Api set: ExcelApi 1.1]
hyperlinks = "Hyperlinks"

Clears all hyperlinks, but leaves all content and formatting intact.

  • [Api set: ExcelApi 1.7]
removeHyperlinks = "RemoveHyperlinks"

Removes hyperlinks and formatting for the cell but leaves content, conditional formats, and data validation intact.

  • [Api set: ExcelApi 1.7]
resetContents = "ResetContents"

Sets all cells in the range to their default state. Cells with cell controls are set to the default value defined by each control. Cells without cell controls are set to blank.

  • [Api set: ExcelApi 1.18]