2.4.315 BrtCalcProp

The BrtCalcProp record specifies workbook calculation properties.

0	1	2	3	4	5	6	7	8	9	1 0	1	2	3	4	5	6	7	8	9	2 0	1	2	3	4	5	6	7	8	9	3 0	1
recalcID
fAutoRecalc
cCalcCount
xnumDelta
...
cUserThreadCount
A	B	C	D	E	F	G	H	I	reserved

recalcID (4 bytes): An unsigned integer that specifies the recalculation engine identifier of the recalculation engine that performed the last recalculation. If the value is less than the recalculation engine identifier associated with the application, the application will recalculate the results of all formulas on this workbook immediately after loading the file.

fAutoRecalc (4 bytes): An unsigned integer that specifies the calculation mode for the workbook. This value MUST be one of the values from the following table.

Value	Meaning
0x00000000	Workbook is in manual calculation mode.
0x00000001	Workbook is in automatic calculation mode.
0x00000002	Same as 0x00000001, except that tables are excluded from automatic calculation.

cCalcCount (4 bytes): An unsigned integer that specifies the number of iterations to run when calculating a workbook in iterative calculation mode. This value is used when fIter is set to 1.

xnumDelta (8 bytes): An Xnum (section 2.5.172) that specifies the minimum change for iterative calculations. This value is used when fIter is set to 1. The application stops calculating after cCalcCount iterations or after all values in the circular reference change by less than xnumDelta between iterations, whichever comes first.

cUserThreadCount (4 bytes): A signed integer that specifies the number of concurrent calculation processes to be used to calculate this workbook. This value is used when fUserSetThreadCount and fMTREnabled are set to 1. This value MUST be greater than 0 and MUST be less than or equal to 1,024.

A - fFullCalcOnLoad (1 bit): A bit that specifies whether the application performs a full calculation when the workbook is opened.

B - fRefA1 (1 bit): A bit that specifies the cell reference style used by this workbook. Possible values for this field are listed in the following table.

Value	Meaning
0	Specifies R1C1 reference style.
1	Specifies A1 reference style.

 

C - fIter (1 bit): A bit that specifies whether to enable iterative calculation. If the value is 0, iterative calculation is disabled. If the value is 1, iterative calculation is enabled.

D - fFullPrec (1 bit): A bit that specifies whether the precision as displayed mode is selected. Possible values for this field are listed in the following table.

Value	Meaning
0	Specifies that precision as displayed mode is selected.
1	Specifies that precision as displayed mode is not selected.

E - fSomeUncalced (1 bit): A bit that specifies whether the workbook was calculated before it was saved. Possible values for this field are listed in the following table.

Value	Meaning
0	Specifies that recalculation was fully finished before save.
1	Specifies that recalculation was not fully finished before the workbook was saved.

F - fSaveRecalc (1 bit): A bit that specifies whether to recalculate the workbook before it is saved, when in manual calculation mode.

G - fMTREnabled (1 bit): A bit that specifies whether concurrent calculation processes are enabled for this workbook.

H - fUserSetThreadCount (1 bit): A bit that specifies whether the user has set the number of concurrent calculation processes for this workbook.

I - fNoDeps (1 bit): A bit that specifies whether all cells in the workbook are calculated. Possible values for this field are listed in the following table.

Value	Meaning
0	Dependencies are respected and only formulas (section 2.2.2) that depend on cells that changed in the workbook are calculated.
1	Dependencies are ignored and all cell formulas in this workbook fully calculate every time a calculation is triggered.

reserved (7 bits): This value MUST be 0, and MUST be ignored.