Class SpinButtonActiveXControl

SpinButtonActiveXControl class

Represents the SpinButton control.

public class SpinButtonActiveXControl : ActiveXControl

Properties

NameDescription
virtual BackOleColor { get; set; }Gets and sets the ole color of the background.(Inherited from ActiveXControlBase.)
override Data { get; }Gets and sets the binary data of the control.(Inherited from ActiveXControl.)
Font { get; }Represents the font of the control.(Inherited from ActiveXControl.)
virtual ForeOleColor { get; set; }Gets and sets the ole color of the foreground.(Inherited from ActiveXControlBase.)
virtual Height { get; set; }Gets and sets the height of the control in unit of points.(Inherited from ActiveXControlBase.)
IMEMode { get; set; }Gets and sets the default run-time mode of the Input Method Editor for the control as it receives focus.(Inherited from ActiveXControl.)
virtual IsAutoSize { get; set; }Indicates whether the control will automatically resize to display its entire contents.(Inherited from ActiveXControl.)
IsEnabled { get; set; }Indicates whether the control can receive the focus and respond to user-generated events.(Inherited from ActiveXControl.)
IsLocked { get; set; }Indicates whether data in the control is locked for editing.(Inherited from ActiveXControl.)
IsTransparent { get; set; }Indicates whether the control is transparent.(Inherited from ActiveXControl.)
virtual IsVisible { get; set; }Indicates whether this control is visible.(Inherited from ActiveXControlBase.)
LinkedCell { get; set; }Gets and sets the linked cell.(Inherited from ActiveXControlBase.)
ListFillRange { get; set; }Gets and sets the list fill range.(Inherited from ActiveXControlBase.)
Max { get; set; }Gets and sets the maximum acceptable value.
Min { get; set; }Gets and sets the minimum acceptable value.
MouseIcon { get; set; }Gets and sets a custom icon to display as the mouse pointer for the control.(Inherited from ActiveXControlBase.)
MousePointer { get; set; }Gets and sets the type of icon displayed as the mouse pointer for the control.(Inherited from ActiveXControlBase.)
Orientation { get; set; }Gets and sets whether the SpinButton or ScrollBar is oriented vertically or horizontally.
Position { get; set; }Gets and sets the value.
virtual Shadow { get; set; }Indicates whether to show a shadow.(Inherited from ActiveXControlBase.)
SmallChange { get; set; }Gets and sets the amount by which the Position property changes
TextAlign { get; set; }Represents how to align the text used by the control.(Inherited from ActiveXControl.)
override Type { get; }Gets the type of the ActiveX control.
virtual Width { get; set; }Gets and sets the width of the control in unit of points.(Inherited from ActiveXControlBase.)
Workbook { get; }Gets the Workbook object.(Inherited from ActiveXControlBase.)

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using Aspose.Cells.Drawing;
    using Aspose.Cells.Drawing.ActiveXControls;
    using System;

    public class SpinButtonActiveXControlDemo
    {
        public static void SpinButtonActiveXControlExample()
        {
            // Initialize a new workbook.
            Workbook workbook = new Workbook();

            // Add a SpinButtonActiveXControl.
            Shape shape = workbook.Worksheets[0].Shapes.AddActiveXControl(ControlType.SpinButton, 1, 0, 1, 0, 100, 50);
            SpinButtonActiveXControl activeXControl = (SpinButtonActiveXControl)shape.ActiveXControl;

            // Setting properties
            activeXControl.Min = 0;
            activeXControl.Max = 100;
            activeXControl.Position = 30;
            activeXControl.SmallChange = 5;

            if (activeXControl.Orientation == ControlScrollOrientation.Auto)
            {
                activeXControl.Orientation = ControlScrollOrientation.Horizontal;
            }

            activeXControl.IsEnabled = true;
            activeXControl.IsLocked = false;
            activeXControl.IsTransparent = false;
            activeXControl.IsAutoSize = true;
            activeXControl.IMEMode = InputMethodEditorMode.On;
            activeXControl.TextAlign = TextAlignmentType.Center;
            activeXControl.Width = 150;
            activeXControl.Height = 30;
            activeXControl.MousePointer = ControlMousePointerType.Default;
            activeXControl.ForeOleColor = 0x000000; // Black color
            activeXControl.BackOleColor = 0xFFFFFF; // White color
            activeXControl.IsVisible = true;
            activeXControl.Shadow = false;
            activeXControl.LinkedCell = "A1";
            activeXControl.ListFillRange = "A2:A10";

            // Save the workbook
            workbook.Save("SpinButtonActiveXControlExample.xlsx");

            return;
        }
    }
}

See Also