4D View Pro Constants

Home

4D v19

Constant	Type	Value	Comment
vk 4D View Pro format	String	.4VP	4D View Pro format (default format)
vk clipboard paste options all	Longint	0	Pastes all data objects, including values, formatting, and formulas.
vk clipboard paste options formatting	Longint	2	Pastes only formatting.
vk clipboard paste options formulas	Longint	3	Pastes only formulas.
vk clipboard paste options formulas and formatting	Longint	5	Pastes formulas and formatting.
vk clipboard paste options values	Longint	1	Pastes only values.
vk clipboard paste options values and formatting	Longint	4	Pastes values and formatting.
vk current sheet	Longint	-1	Designates current sheet of the 4D View Pro area (default)
vk find flag exact match	Longint	2	Specifies that the entire content of the cell must completely match the search value.
vk find flag ignore case	Longint	1	Specifies that capital and lower-case letters are considered the same. Ex: "a" is the same as "A".
vk find flag none	Longint	0	Specifies that no search flags are considered. (default)
vk find flag use wild cards	Longint	4	Specifies that wildcard characters (,?) can be used in the search string. Wildcard characters can be used in any string comparison to match any number of characters. - For zero or multiple characters. For example, searching for "bl*" can find "bl", "black", "blue", and "blob". ? - For a single character. For example, searching for "h?t" can find "hot", "hat", and "hit".
vk find order by columns	Longint	1	Specifies that the search is performed by columns. Each row of a column is searched before the search continues to the next column.
vk find order by rows	Longint	0	Specifies that the search is performed by rows. Each column of a row is searched before the search continues to the next row. (default)
vk find target formula	Longint	8	Specifies that the search is performed in the cell formula.
vk find target tag	Longint	4	Specifies that the search is performed in the cell tag.
vk find target text	Longint	1	Specifies that the search is performed in the cell text. (default)
vk font size large	String	"large"	Large text
vk font size larger	String	"larger"	Larger text
vk font size medium	String	"medium"	Medium sized text
vk font size small	String	"small"	Small text
vk font size smaller	String	"smaller"	Smaller text
vk font size x large	String	"x-large"	Extra large sized text
vk font size x small	String	"x-small"	Extra small sized text
vk font size xx large	String	"xx-large"	Extra extra large sized text
vk font size xx small	String	"xx-small"	Extra extra small sized text
vk font style italic	String	"italic"	Italic text
vk font style oblique	String	"oblique"	Oblique text
vk font variant small caps	String	"small-caps"	Text displayed in small capital letters.
vk font weight 100	String	"100"	Thin text
vk font weight 200	String	"200"	Extra light text
vk font weight 300	String	"300"	Light text
vk font weight 400	String	"400"	Normal weight text
vk font weight 500	String	"500"	Medium weight text
vk font weight 600	String	"600"	Semi bold text
vk font weight 700	String	"700"	Bold text.
vk font weight 800	String	"800"	Extra bold text
vk font weight 900	String	"900"	Ultra bold text
vk font weight bold	String	"bold"	Bold text.
vk font weight bolder	String	"bolder"	Heavier bold text
vk font weight lighter	String	"lighter"	Lighter text
vk header auto text blank	Longint	0	Displays blanks in the headers.
vk header auto text letters	Longint	2	Displays letters in the headers.
vk header auto text numbers	Longint	1	Displays numbers in the headers.
vk horizontal align center	Longint	1	Cell contents are horizontally aligned to the center
vk horizontal align general	Longint	3	Cell contents are horizontally aligned according to their value type
vk horizontal align left	Longint	0	Cell contents are horizontally aligned to the left
vk horizontal align right	Longint	2	Cell contents are horizontally aligned to the right
vk image layout center	Longint	1	Background image is displayed in the center of the 4D View Pro ara
vk image layout none	Longint	3	Original-sized background image is displayed in the upper left corner of the 4D View Pro area
vk image layout stretch	Longint	0	Background image fills the entire 4D View Pro area
vk image layout zoom	Longint	2	Background image is displayed with its original aspect ratio
vk label alignment bottom center	Longint	4	Cell label is center-aligned on the bottom
vk label alignment bottom left	Longint	3	Cell label is left-aligned on the bottom
vk label alignment bottom right	Longint	5	Cell label is right-aligned on the bottom
vk label alignment top center	Longint	1	Cell label is center-aligned on the top
vk label alignment top left	Longint	0	Cell label is left-aligned on the top
vk label alignment top right	Longint	2	Cell label is right-aligned on the top
vk label visibility auto	Longint	2	Displays watermark in padding area (if cell has a value) or in the cell (if cell has no value)
vk label visibility hidden	Longint	1	Displays watermark in cell area based on a value condition
vk label visibility visible	Longint	0	Watermark is always shown in padding area, regardless of cell value
vk line style dash dot	Longint	9	Line made from a single dash and and single dot
vk line style dash dot dot	Longint	11	Line made from a single dash and two dots
vk line style dashed	Longint	3	Line made from dashes
vk line style dotted	Longint	4	Line made from dots
vk line style double	Longint	6	Line made from two lines
vk line style empty	Longint	0	A simple, un-styled line
vk line style hair	Longint	7	Line made from dots.
vk line style medium	Longint	2	Solid, medium-weight line
vk line style medium dash dot	Longint	10	Medium-weight line made from a single dash and and single dot
vk line style medium dash dot dot	Longint	12	Medium-weight line made from a single dash and two dots
vk line style medium dashed	Longint	8	Medium-weight line made from dashes
vk line style slanted dash dot	Longint	13	Line made from a slanted dash and slanted dot
vk line style thick	Longint	5	Heavy-weight solid line
vk line style thin	Longint	1	Light-weight solid line
vk MS Excel format	String	.xlsx	Microsoft Excel format
vk pattern full date time	String	"_fullDateTimePattern_"	ISO 8601 format for the full date and time in current localization. USA default pattern: "dddd, dd MMMM yyyy HH:mm:ss"
vk pattern long date	String	"_longDatePattern_"	ISO 8601 format for the full date in current localization. USA default pattern: "dddd, dd MMMM yyyy"
vk pattern long time	String	"_longTimePattern_"	ISO 8601 format for the time in current localization. USA default pattern: "HH:mm:ss"
vk pattern month day	String	"_monthDayPattern_"	ISO 8601 format for the month and day in current localization. USA default pattern: "MMMM dd"
vk pattern short date	String	"_shortDatePattern_"	Abbreviated ISO 8601 format for the date in current localization. USA default pattern: "MM/dd/yyyy"
vk pattern short time	String	"_shortTimePattern_"	Abbreviated ISO 8601 format for the time in current localization. USA default pattern: "HH:mm"
vk pattern sortable date time	String	"_sortableDateTimePattern_"	ISO 8601 format for the date and time in current localization which can be sorted. USA default pattern: "yyyy\'-\'MM\'-\'dd\'T\'HH\':\'mm\':\'ss"
vk pattern universal sortable date time	String	"_universalSortableDateTimePattern_"	ISO 8601 format for the date and time in current localization using UTC which can be sorted. USA default pattern: "yyyy\'-\'MM\'-\'dd HH\':\'mm\':\'ss\'Z\'"
vk pattern year month	String	"_yearMonthPattern_"	ISO 8601 format for the month and year in current localization. USA default pattern: "yyyy MMMM"
vk pdf format	String	.pdf	PDF format
vk position bottom	Longint	2	Vertical aligment to the bottom of cell or row
vk position center	Longint	1	Alignment to the center. The alignment will be to the cell, row, or column limit according to the view position indicated: Vertical view position - cell or row Horizontal view position - cell or column
vk position left	Longint	0	Horizontal alignment to the left of the cell or column
vk position nearest	Longint	3	Alignment to the closest limit (top, bottom, left, right, center). The alignment will be to the cell, row, or column limit according to the view position indicated: Vertical view position (top, center, bottom) - cell or row Horizontal view position (left, center, right) - cell or column
vk position right	Longint	2	Horizontal alignment to the right of the cell or column
vk position top	Longint	0	Vertical alignment to the top of cell or row
vk print centering both	Longint	3	Printing is centered both horizontally and vertically on the page
vk print centering horizontal	Longint	1	Printing is centered horizontally on the page.
vk print centering none	Longint	0	Printing is not centered. (default)
vk print centering vertical	Longint	2	Printing is centered vertically on the page.
vk print page order auto	Longint	0	Printing order is determined automatically. (default)
vk print page order down then over	Longint	1	Pages are printed in descending order, then across.
vk print page order over then down	Longint	2	Pages are printed across, then descending order.
vk print page orientation landscape	Longint	2	Landscape orientation
vk print page orientation portrait	Longint	1	Portrait orientation. (default)
vk print visibility hide	Longint	1	The header is not visible.
vk print visibility inherit	Longint	0	Inherits the settings from the sheet (default)
vk print visibility show	Longint	2	The header is visible on every page.
vk print visibility show once	Longint	3	The header is visible once.
vk text decoration double underline	Longint	8	Displays a double line below text
vk text decoration line through	Longint	2	Displays a line through text
vk text decoration none	Longint	0	Displays text without decoration
vk text decoration overline	Longint	4	Displays a line above text
vk text decoration underline	Longint	1	Displays a single line below text
vk vertical align bottom	Longint	2	Cell contents are vertically alligned to the bottom
vk vertical align center	Longint	1	Cell contents are vertically aligned to the center
vk vertical align top	Longint	0	Cell contents are vertically aligned to the top
vk workbook	Longint	-2	Designates the entire workbook of the 4D View Pro area.