setrster.blogg.se - Windows grid lines

#Windows grid lines how to#
#Windows grid lines code#

From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.

In the Appearance category, select the VerticalGridLine object in the property list.

In the Appearance category, select the HorizontalGridLine object in the property list.

Select the sheet tab for the sheet for which you want to set the grid line colors.

Both grid lines are flat.ĭim HGridLine As New (.Flat, Color.Red)ĭim VGridLine As New (.Flat, Color.Chartreuse)įpSpread1.Sheets(0).HorizontalGridLine = HGridLineįpSpread1.Sheets(0).VerticalGridLine = VGridLine

#Windows grid lines code#

This example code sets the horizontal grid line color to red and the vertical grid line color to chartreuse. Assign the GridLine object to the specified sheet by setting the SheetView object HorizontalGridLine or VerticalGridLine property to the GridLine object you created in step 1.Create a GridLine object, setting the color or colors and the style for the grid line in the constructor.Select the VerticalGridLine object in the property list.Do the same for the ShadowColor property. If the grid lines are three-dimensional, select the HighlightColor property, and then click the drop-down button to display the color picker.If the grid lines are not three-dimensional, select the Color property, and then click the drop-down button to display the color picker.If you want to display three-dimensional grid lines, set the Type property to Lowered or Raised.Select the HorizontalGridLine object in the property list. On the View tab, in the Show group, select or clear the Grid checkbox.In the Members list, select the sheet for which you want to set the grid line color.Click the button to display the SheetView Collection Editor.At design time, in the Properties window, select the Spread component.For more information, refer to Customizing Cell Borders.įor information on setting the grid lines in a header, refer to Customizing the Header Grid Lines. Note: You can display lines around individual cells by setting cell borders.

#Windows grid lines how to#

To customize other properties, you would create a new GridLine object (rather that changing a property on the existing object).įor more details on how to work with the grid lines in code, refer to the examples below, the GridLine class, and HorizontalGridLine property or VerticalGridLine property of the SheetView class.

You can hide the grid line in a particular direction by setting the type of grid line to None. Beyond this, the grid lines are non-mutable objects. The color is for flat lines the highlight and shadow color are for the other types of lines. width - the width in pixels of the grid line.shadow color - the shadow color for three-dimensional grid lines.

highlight color - the highlight color for three-dimensional grid lines.Basically, the grid line has these properties that can be customized: If you do so, set the highlight and shadow color to create the effect you want. You can choose to display the grid lines as three-dimensional lines, with a highlight and shadow color. In the following figure, the horizontal grid lines are flat and red, and the vertical grid lines are flat and green. You can set the color, the width, and the style of grid lines.