From The Document Foundation Wiki
Jump to navigation Jump to search

NOTE: If the number of data cells used in formulas is small, OpenCL is not used even if enabled (OpenCL is used to speed up calculation on large datasets, and is usually not efficient on small amount of data). The lower limit is 100 by default, and can be adjusted in Tools ▸ Options... ▸ LibreOffice Calc ▸ Formula by selecting Custom (use OpenCL, conversion of text to numbers, and more), clicking Details, and adjusting Minimum data size for OpenCL use.