P record, which is usually declared as P;PGeneral S style style The following characters can be part of style Iitalic Dbold Tgridline top Lgridline left Bgridline bottom Rgridline right Sshaded background H If present, don't show row/column headers If absent in the entire file, show row/column headers G If present, don't show default gridlines If absent in the entire file, show default gridlines Compatible fields: At least one of ;X, ;Y, ;C, ;R, ;D, ;E, ;K, ;W, ;P, ;H, or ;G must be present. If ;X or ;Y is present, both ;X and ;Y must be present. (This sets cell format.) If ;X is present, ;R, ;C, ;E, ;K, ;W, ;N, ;H, ;G must be absent. If ;R is present, ;X, ;Y, ;C, ;E, ;K, ;W, ;N, ;H, ;G must be absent. (This sets default row format.) If ;C is present, ;X, ;Y, ;R, ;E, ;K, ;W, ;N, ;H, ;G must be absent. (This sets default column format.) If ;D is present, ;X, ;Y, ;R, ;C must be absent. (This sets default spreadsheet format.) If ;X, ;Y, ;R, ;C are present, ;P and/or ;F and/or ;S must be present. O record Use: Options Possible fields: A iter delta If present, allow value iteration If absent, circular references are not allowed. iter (maximum number of iterations) delta (step test. If smaller, then finished.) C completion test at nearest preceding C record P sheet is protected L use A1 mode references Even if ;L is given R1C1 references are used in SYLK file expressions. M If present, use manual recalculation. If absent, use automatic recalculation. E Macro sheet. This should appear before the first appearance of a ;G or ;F field in a NN record. This should appear before the first C record which uses a macro-only function. V value value indicates the base date used for calculating serial date values 0:1 January 1900 4:1 January 1904 NU record Use: file name substitution If NE record(s) are present, must precede them. Mandatory fields: L filename old filename F filename new filename NE record Use: external link Mandatory fields: E expression Target area on spreadsheet F filename Source file S expression Source area on external sheet NN record Use: Defines names More efficient if NN appears before name use. Mandatory fields: N name name E expression expression describing value of name Possible fields: G ch1 ch2 runable name (macro) with command key alias