Command PV SET CELL PROPERTY

4D View

previous page next page

PV SET CELL PROPERTY

version 2004 (Modified)

PV SET CELL PROPERTY (area; column; row; property; value)

Parameter Type Description

area Longint 4D View area

column Longint Cell column number

row Longint Cell row number

property Longint Property number

value Longint Property value

Description

The PV SET CELL PROPERTY command sets the value of the property defined in the column and row parameters.

To define property, you can use:

• the constants of the PV Cell properties theme. In this case, pass the height or width of the cell in pixels in the value parameter.

• the constants of the PV Style properties theme. In this case, to define the value parameter, use the constants of the PV Style values, PV Style special values, PV Style format date time or PV Picture mapping mode theme.

The following list describes the different constants used in the property parameter and the associated values:

PV Cell properties theme

pv cell width

Allows setting of cell width. Associated values: width expressed in pixels.

pv cell height

Allows setting of cell height. Associated values: height expressed in pixels.

PV Style properties theme

pv style locked

Allows setting of locking for the cell user. Locked cell contents can no longer be modified, selected, etc. Associated values: constants of the PV Style values theme.

• pv value on: cell locked.

• pv value off: cell not locked.

pv style hidden

Allows setting of cell locking and hiding. Locked and hidden cell contents are not displayed and can no longer be modified, selected, etc. Associated values: constants of the PV Style values theme.

• pv value on: cell locked and hidden.

• pv value off: cell not locked or hidden.

pv style spellcheck

Allows application of spellcheck for the cell. Associated values: constants of the PV Style values theme.

• pv value on: a spellcheck is applied to the cell.

• pv value off: no spellcheck is applied to the cell.

pv style use picture height

Allows adapting of cell size according to the picture height associated with it. Associated values: constants of the PV Style values theme.

• pv value on: cell size is adapted to the height of the picture it contains. If there is no picture associated with it, the cell is not resized.

• pv value off: cell size does not vary according to the picture height associated with it.

pv style based on

The cell uses, as a model, the style sheet whose number is passed in the value parameter. Associated values: style sheet numbers or constants of the PV Style special values theme.

pv style format alpha

The cell uses the text display format whose number is passed in the value parameter. Associated values: display format numbers.

pv style format num

The cell uses the number display format whose number is passed in the value parameter. Associated values: display format numbers.

Note: Default display format numbers correspond to their position in the menu used for selecting formats in the cell Format dialog box.

pv style format bool

The cell uses the Boolean display format whose number is passed in the value parameter. Associated values: display format numbers.

pv style format date time

The cell uses the date and time display format whose number is passed in the value parameter. Associated values: constants of the PV Style format date time theme.

• pv Short: 02/21/02

• pv Abbreviated: thu 21 feb 2002

• pv Long: thursday 21 february 2002

• pv Short2: 02/21/2002

• pv Month Day Year: 21 february, 2002

• pv Abbr Month Day Year: 21 feb, 2002

• pv Day Name: thursday

• pv Day Number: 21

• pv Month Name: february

• pv Month Number: 2

• pv Year Number: 2002

• pv Long H MM AM PM: thursday 21 february 2002 at 12:30 PM

• pv Abbreviated H MM AM PM: thu 21 feb 2002 at 12:30 PM

• pv Short HH MM SS: 02/21/02 at 12:30:00

• pv Month Day Year H MM AM PM: 21 february, 2002 at 12:30 PM

• pv Short2 Hour Min Sec: 21/02/2002 and 12 hours 30 minutes 0 second

• pv HH MM SS: 12:30:00

• pv HH MM: 12:30

• pv Hour Min Sec: 12 hours 30 minutes 0 second

• pv Hour Min: 12 hours 30 minutes

• pv HH MM AM PM: 12:30 PM

Note: Depending on your current System settings, the resulting display can be different.

pv style format picture

Allows definition of the picture display format associated with the cell. Associated values: constants of the PV Picture mapping mode theme.

• pv mapping trunc non-centered

• pv mapping truncated centered

• pv mapping replicated

• pv mapping scaled to fit prop

• pv mapping scaled to fit

• pv mapping scaled centered prop

pv style color back even

Allows setting of the cell background color if it is located on an even-numbered line. Associated values: color numbers (see the PV RGB to color and PV Index to color commands) or pv value none (PV Style Values theme) to set no color.

pv style color back odd

Allows setting of the cell background color if it is located on an odd-numbered line. Associated values: color numbers (see the PV RGB to color and PV Index to color commands) or pv value none (PV Style Values theme) to set no color.

pv style color text even

Allows setting of cell text color if it is located on an even-numbered line. Associated values: color numbers (see the PV RGB to color and PV Index to color commands).

pv style color text odd

Allows setting of cell text color if it is located on an odd-numbered line. Associated values: color numbers (see the PV RGB to color and PV Index to color commands).

pv style color zero even

Allows setting of cell text color if it is located on an even-numbered line and its value is 0 (zero). Associated values: color numbers (see the PV RGB to color and PV Index to color commands).

pv style color zero odd

Allows setting of cell text color if it is located on an odd-numbered line and its value is 0 (zero). Associated values: color numbers (see the PV RGB to color and PV Index to color commands).

pv style color minus odd

Allows setting of cell text color if it is located on an even-numbered line and its value is negative. Associated values: color numbers (see the PV RGB to color and PV Index to color commands).

pv style color minus odd

Allows setting of cell text color if it is located on an odd-numbered line and its value is negative. Associated values: color numbers (see the PV RGB to color and PV Index to color commands).

pv style text font

Allows setting of cell font. Associated values: font numbers (see the PV Add font and PV GET FONT LIST commands).

pv style text size

Allows setting of cell font size. Associated values: size in pixels.

pv style text face

Allows setting of cell style sheet. Associated values: style sheet numbers or constants of the PV Style special values theme.

pv style text bold

Allows setting of Bold for the cell text. Associated values: constants of the PV Style values theme.

• pv value on: Bold applied in cell.

• pv value off: Bold not applied in cell.

pv style text italic

Allows setting of Italic for the cell text. Associated values: constants of the PV Style values theme.

• pv value on: Italic applied in cell.

• pv value off: Italic not applied in cell.

pv style text underline

Allows setting of Underline for the cell text. Associated values: constants of the PV Style values theme.

• pv value on: Underline applied in cell.

• pv value off: Underline not applied in cell.

pv style text outline

Allows setting of Outline for the cell text. Associated values: constants of the PV Style values theme.

• pv value on: Outline applied in cell.

• pv value off: Outline applied in cell.

pv style text shadow

Allows setting of Shadow for the cell text. Associated values: constants of the PV Style values theme.

• pv value on: Shadow applied in cell.

• pv value off: Shadow not applied in cell.

pv style text condensed

Allows setting of Condensed for the cell text. Associated values: constants of the PV Style values theme.

• pv value on: Condensed applied in cell.

• pv value off: Condensed not applied in cell.

pv style text extended

Allows setting of Extended for the cell text. Associated values: constants of the PV Style values theme.

• pv value on: Extended applied in cell.

• pv value off: Extended not applied in cell.

pv style hor alignment

Allows setting of horizontal alignment of cell content. Associated values: constants of the PV Style values theme.

• pv value hor alignment default: applies horizontal alignment by default to the cell.

• pv value hor alignment left: applies left horizontal alignment to the cell.

• pv value hor alignment center: applies center horizontal alignment to the cell.

• pv value hor alignment right: applies right horizontal alignment to the cell.

pv style vert alignment

Allows setting of vertical alignment of cell content. Associated values: constants of the PV Style values theme.

• pv value vert alignment top: applies top vertical alignment to the cell.

• pv value vert alignment center: applies center vertical alignment to the cell.

• pv value vert alignment bottom: applies bottom vertical alignment to the cell.

pv style rotation

Allows setting of cell content rotation. Associated values: constants of the PV Style values theme.

• pv value rotation 0: no rotation applied to the cell.

• pv value rotation 90: applies rotation of 90° to the left.

• pv value rotation 180: applies rotation of 180°.

• pv value rotation 270: applies rotation of 270° to the left.

pv style format forced text

Allows "forcing" the cell display in raw text, i.e. without the automatic display format applied by 4D View based on the cell contents (number, date, text, etc.). Associated values: constants of the PV Style values theme.

• pv value on: cell contents are displayed without automatic format.

• pv value off (default): cell contents are displayed with automatic format.

pv style automatic word wrap

Allows enabling the automatic word wrap function when the contents of a cell exceed its width. Associated values: constants of the PV Style values theme.

• pv value on: cell contents automatically move to the next line if necessary.

• pv value off: cell contents run over into the adjacent cells if necessary.

Note: To define, in one selection, the property of a range of cells, you can use the PV SET RANGE PROPERTY command.

Example

Find all cells containing a formula which refers to cell D20, in order to switch between locking and unlocking them.

   C_LONGINT($ProtectedCell)  `To lock or unlock cells
   C_LONGINT($EndColumn;$EndRow)  `To save lower/right limits
   C_LONGINT($StartColumn;$StartRow)  `To save upper/left limits
   C_LONGINT($Column;$Row)  `To get coordinates in loop

   ARRAY LONGINT($LeftTab;0)
   ARRAY LONGINT($UpperTab;0)
   ARRAY LONGINT($RightTab;0)
   ARRAY LONGINT($LowerTab;0)

   PV FIND ALL (Area;"$D$20";0;0)  `Cells containing "$D$20"
      `Selected cell coordinates
   PV GET SELECTED RANGES LIST (Area;$LeftTab;$UpperTab;$RightTab;$LowerTab) 

   If (Size of array($LeftTab)#0)  `Are there formulas corresponding to search criteria?
       SORT ARRAY($LeftTab;$UpperTab;$RightTab;$LowerTab;>)
        $StartColumn:=$LeftTab{1}  `Get left-most cell
  
        SORT ARRAY($UpperTab;$LeftTab;$RightTab;$LowerTab;>)
        $StartRow:=$UpperTab{1}  `Get upper-most cell
  
        SORT ARRAY($RightTab;$UpperTab;$LeftTab;$LowerTab;>)
        $EndColumn:=$RightTab{Size of array($RightTab)}  `Get right-most cell
  
        SORT ARRAY($LowerTab;$RightTab;$UpperTab;$LeftTab;>)
        $EndRow:=$LowerTab{Size of array($LowerTab)}    `Get lowest cell

          `Review the selection
       For ($Column;$StartCol;$EndCol)
         For ($Row;$StartRow;$EndRow)
             If (Position("$D$20";PV Get cell formula (Area;$Column;$Row))>0)
                  `Lock?
               $ProtectedCell:=PV Get cell property (Area;$Column;$Row;pv style locked )
               `Switch locked/unlocked
               PV SET CELL PROPERTY (Area;$Column;$Row;pv style locked ;Num($ProtectedCell=0))  `0  1
            End if
            End for
      End for
   End if  `Range(s) selected?

Constants

PV Style properties, PV Cell properties, PV Style values, PV Style special values, PV Style format date time and PV Picture mapping mode themes.

previous page start next page

Parameter	Type	Description
area	Longint	4D View area
column	Longint	Cell column number
row	Longint	Cell row number
property	Longint	Property number
value	Longint	Property value