Description: On some spreadsheets (but not all), going to Tools | Options | Libre Office Calc and using the arrow keys to move down the list gives a window 'Invalid increment' when I get to 'Formula'. Following this, other movements give the same, and then it goes hard, and the only way out is to forcibly close LO with Task Manager. I tried safe mode with a factory reset but get the same. Steps to Reproduce: 1.Load attached spreadsheet. 2.Go to Tools | Options menu. 3. Click on 'Libre Office Calc' 4. Press the down arrow key 5 times (to move to 'formula') Actual Results: Invalid increment error (see attached screenshot) Expected Results: The Formula options! Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-GB Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no Version: 7.0.5.2 (x64) Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a CPU threads: 12; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded
Created attachment 171414 [details] A spreadsheet which fails.
Created attachment 171415 [details] After the failure.
That is because travelling down visits the Calculate dialog page, in which iterations are switched on with a minimum change of 0 (however you managed to enter and save that), upon the next arrow down the page is checked for validity, for which that value 0 is not valid, so the error is raised. Not much that could be done there.
(In reply to Eike Rathke from comment #3) > That is because travelling down visits the Calculate dialog page, in which > iterations are switched on with a minimum change of 0 (however you managed > to enter and save that), upon the next arrow down the page is checked for > validity, for which that value 0 is not valid, so the error is raised. Not > much that could be done there. Ah, I see what you mean. To the best of my knowledge I've never changed the iteration parameters - I can't even remember when I last used iteration (if ever). I have now found that setting the increment to 0 and clicking 'Apply' does not produce an error. So I think it's a bug which needs correction - probably best by not allowing the focus to be taken away from the 'Calculate' window if the values are illegal.
The reason is a false setting for "Minimum change:" set to 0. An increment value of 0 is pointless with respect to "Iterations". The value must be greater 0 (default is: 0.001) From my perspective not a bug but an incorrect setting and causing an error message as one would expect.
(In reply to Uwe Auer from comment #5) > The reason is a false setting for "Minimum change:" set to 0. An increment > value of 0 is pointless with respect to "Iterations". The value must be > greater 0 (default is: 0.001) > > From my perspective not a bug but an incorrect setting and causing an error > message as one would expect. Agreed. But as the error message occurs when the relevant window has disappeared, it's not very helpful.
To fix this, go to Tools/Options/LO Calc/Calculate. Put something else than "0" in Iterative References, eg: 0.001 or 0,001 (depending what's the separator for the decimal). How did you generate this file? I mean if I use a brand new file, I can't put 0 and have this popup so the file can't be saved with 0.
(In reply to Julien Nabet from comment #7) > To fix this, go to Tools/Options/LO Calc/Calculate. > Put something else than "0" in Iterative References, eg: 0.001 or 0,001 > (depending what's the separator for the decimal). > > How did you generate this file? I mean if I use a brand new file, I can't > put 0 and have this popup so the file can't be saved with 0. As I said in comment 4 I have no idea!
If files can be fixed with the process indicated, perhaps it's just due to a old LO version which generated buggy files. Can't help here=>uncc myself.
Agreed. I've no idea how it happened, but once it has, the error message is still in the wrong place! The spreadsheet goes back at least to 2010, and the increment is 0 there. I've found that's also the case in another ancient spreadsheet, so you may well be right. At least I now know what the problem is and can cope with it. Thanks all for the help.
Based on the last comments, I guess we can close this
I'm not sure - we've found out why it's happeneing, but if you look at the last sentence in
(In reply to Buovjaga from comment #11) > Based on the last comments, I guess we can close this I'm not sure. I agree that that cause has been found, but there is also the point that the error message occurs in the wrong place. See the last sentence in comment #7 https://bugs.documentfoundation.org/show_bug.cgi?id=141912#c7 (How does one put links to comments into a reply?)