In a Calc spreadsheet, you can use the Data tab page to create a two-way link between a scrollbar and a cell.Pivot Tables are one of the most powerful and useful tools in Calc. To make the width of the scrollbar equal to the height of the scrollbar, set the Visible Size to zero. For example, a value of ('Scroll value max.' minus 'Scroll value min.') / 2 results in a scrollbar thumb that occupies half of the scrollbar. Specifies the size of the scrollbar thumb in 'value units'. Specifies the color of the arrows on the scrollbar. For example, the delay that occurs when you click an arrow button on the scrollbar and hold down the mouse button. Specifies the delay in milliseconds between scrollbar trigger events. Specifies the amount that a large step scrolls a scrollbar, for example, when you click between the scrollbar thumb and a scrollbar arrow.

Specifies the minimum amount by which you can scroll a scrollbar, for example, by clicking an arrow. Specifies the orientation of a scrollbar, that is, horizontal or vertical. Specifies the default value of a scrollbar, used when the form is reset. Specifies the maximum height or the maximum width of a scrollbar. Specifies the minimum height or the minimum width of a scrollbar. You can specify the following properties for a scrollbar: You can view these properties on the Data tab page of the Form properties dialog. For example, a control that displays contents from an address book continues to display the same contents after you copy the control to a different document. When you insert a control from another document, LibreOffice analyzes the data source, content type, and content properties of the control so that the control fits the logical structure in the target document. You can also copy and paste controls between documents. You can drag and drop controls from one document to another document. To specify a accelerator key for a control, add a tilde ( ~) in front of the character in the label for the control. A dialog opens where you can define the properties of the control. Right-click the control and choose Control. To include a label for the field, hold down the Command Ctrl+ Shift key down when you drag a column head. In a text document, you can also drag a column header to add a field to a form. To add a field from the field list of a table or query to a form, drag a cell into the form.

Openoffice calc dynamic drop down list