False True 6 Detailed Calculation Settings dialog False vertical 12 False end gtk-ok True True True True True True False True 0 gtk-cancel True True True True False True 1 False True end 0 True False True True 12 True True True True 0 0 1 1 True False 12 True False _Value: True 0 0 1 1 True False True True True True True False True 0 True True false 0 0 1 1 False True True False True 0 True true 1 0 1 1 True False True 2 0 1 1 True True start ● adjustment1 1 if-valid 3 0 1 1 True True center ● 4 0 1 0 1 1 0 1 1 1 True False 0 0 True 56 0 2 1 1 False True Conversion from text to number 0 4 1 1 False True How to treat text when encountered as operand in an arithmetic operation or as argument to a function that expects a number instead. Unambiguous conversion is possible for integer numbers including exponents and ISO 8601 dates and times in their extended formats with separators. Fractional numeric values with decimal separators or dates other than ISO 8601 are locale dependent. Note that in locale dependent conversions the resulting numeric value may differ between locales! True 56 0 5 1 1 False True Generate #VALUE! error 0 6 1 1 False True Treat as zero 0 7 1 1 False True Convert only unambiguous 0 8 1 1 False True Convert also locale dependent 0 9 1 1 False True Treat empty string as zero 0 10 1 1 False True This option determines how an empty string is treated when used in arithmetic operations. If you have set "Conversion from text to number" to either "Generate #VALUE! error" or "Treat as zero", you cannot choose (here) if conversion of an empty string to a number will generate an error or if it will treat empty strings as zero. Otherwise this option determines how empty strings are treated. True 56 0 11 1 1 False True Reference syntax for string reference 0 12 1 1 False True Formula syntax to use when parsing references given in string parameters. This affects built-in functions such as INDIRECT that takes a reference as a string value. True 56 0 13 1 1 False True Use formula syntax 0 14 1 1 False True Use OpenCL only for a subset of operations 0 15 1 1 False True Use OpenCL only for some of the operations that spreadsheet formulas are translated to. True 56 0 16 1 1 False True Minimum data size for OpenCL use 0 17 1 1 False True An approximate lower limit on the number of data cells a spreadsheet formula should use for OpenCL to be considered. True 56 0 18 1 1 False True Subset of opcodes for which OpenCL is used 0 19 1 1 False True The list of operator and function opcodes for which to use OpenCL. If a formula contains only these operators and functions, it might be calculated using OpenCL. True 56 0 20 1 1 False vertical 6 True True True True True 0 1 1 1 True False 12 True False Automatic selection of platform/device: 0 0 1 1 True True True False 0 True True automatic_select_false 1 0 1 1 False True True False 0 True True automatic_select_true 2 0 1 1 0 0 1 1 True False 6 12 True False 0 Frequency: 0 0 1 1 True False 0 Compute units: 0 1 1 1 True False 0 Memory (in MB): 0 2 1 1 True False 1 0 1 1 True False 1 1 1 1 True False 1 2 1 1 0 2 1 1 0 3 1 1 False Internal, software interpreter 0 27 1 1 _Test True True True 0 28 False True False True 1 ok cancel both vertical