HotXLS Docs
Home Contents Overview

OfficeArtOptions property

Returns a TXLSOfficeArtOptions object that exposes the raw OfficeArt FOPT option table for the specified shape. Read-only TXLSOfficeArtOptions.

Syntax

property OfficeArtOptions: TXLSOfficeArtOptions;

Example

This example sets and later removes an OfficeArt shadow-colour option on a comment shape. 

with Workbook.Sheets[1].Range['B2', 'B2'].AddComment('Review').Shape do begin
  OfficeArtOptions.LongValue[optShadowColor] := $00112233;
  if OfficeArtOptions.IsDefined[optShadowColor] then
    OfficeArtOptions.Delete(optShadowColor);
end;