github.com/shakinm/xlsReader@v0.9.12/xls/record/array.go (about)

     1  package record
     2  
     3  //ARRAY: Array-Entered Formula
     4  
     5  var ArrayRecord = []byte{0x021, 0x02} //(221h)
     6  
     7  /*
     8  An ARRAY record describes a formula that was array-entered into a range of cells.
     9  The range of cells in which the array is entered is defined by the rwFirst , rwLast ,
    10  colFirst , and colLast fields.
    11  The ARRAY record occurs directly after the FORMULA record for the cell in the upper-
    12  left corner of the array — that is, the cell defined by the rwFirst and colFirst
    13  fields.
    14  
    15  Record Data
    16  Offset		Field Name		Size		Contents
    17  ------------------------------------------------
    18  4			rwFirst			2			First row of the array
    19  6			rwLast			2			Last row of the array
    20  8			colFirst		1			First column of the array
    21  9			colLast			1			Last column of the array
    22  10			grbit			2			Option flags
    23  12			chn				4
    24  16			cce				2			Length of the parsed expression
    25  18			rgce			var			Parsed formula expression
    26  
    27  Ignore the chn field when reading the BIFF file. If a BIFF file is written, the chn field
    28  must be 00000000h .
    29  
    30  The grbit field contains the following option flags:
    31  
    32  Offset		Bits		Mask		Flag Name		Contents
    33  ------------------------------------------------------------
    34  0			0			01h			fAlwaysCalc		Always calculate the formula.
    35   			1			02h			fCalcOnLoad		Calculate the formula when the file is opened.
    36  			7–2			FCh			(unused)
    37  1			7–2			FFh			(unused)
    38  
    39  */
    40  
    41  type Array struct {
    42  	RwFirst  [2]byte
    43  	RwLast   [2]byte
    44  	ColFirst [1]byte
    45  	ColLast  [1]byte
    46  	Grbit    [2]byte
    47  	Chn      [4]byte
    48  	Cce      [2]byte
    49  	Rgce     []byte
    50  }