In options->LO calc->formula when selecting the custom setting for detailed calculation setting it doesn’t “stick”. I need the setting “treat empty string as zero: false” to be in effect. Is this option the default option?? It is automatically reverted to the default setting when I reenter the options menu. This is highly annoying since I have a rather large spreadsheet littered with random empty strings that I don’t want calculated as zeroes.
(LO calc vs 188.8.131.52, Mac OS X 10.9.3)