5/20/2023 0 Comments Err 522 openoffice calc![]() or merely handed over to Google? - Sheets has what seems a similar issue. ![]() The suggestion here is that this has been fixed for 6.1.0.1 and up. (and also on an earlier LO version and on an OO version). Also about the significance of the 'Minimum change' (ie a value is only returned when the change is from 0 or more than 1 (ie when drops from 3 to 1).īuild ID: 92a7159f7e4af62137622921e809f8546db437e5 CPU threads: 2 I am now more convinced there is a bug, and you are correct about the doubling up. Simplifying A1 to be an integer between 1 and 3 inclusive (keyed in not generated) shows the following (repeatable) pattern when set to 1 iteration and minimum 1: 0 0 I note m.a.riosv's comment to your bug report and suspect that individual either has a different set up or is using a different generator for the values in A1. If not: How to produce an accumulator field in Calc? Is there any way to get this to work in LibreOffice Calc? In Excel this simply worked using the following settings: It always at least adds double the dice-value, but oftentimes a value that seems to have no connection to the show dice value. But when I press F9, the calculation is not correct. I can get the iterative calculation to work if I set "Minimum change:" to 6. You can see the Sum is calculated automatically. Context menu showing Auto options Calc Autosum in Action 4. Click on the sigma icon beside the formula bar and click Sum from the dropdown menu. Select the cell where you would like to put the autosum of your data. But with my current settings I most of the time get the following error: Open any Calc workbook with numbers and data, or open your workbook. This is possible if you activate iterative calculations. I need an accumulator field that adds the result of a dice-roll (simulated by =int(rand()*6)+1) to get the current sum of all prior dice-rolls plus the current one. However, there is something that worked fine in Excel that I cannot get to work in Calc. At my new school I don't have Excel at my disposition, so we do everything with Calc (which is fine generally). To finish my spreadsheet sequence I usually let my pupils write a little car racing simulation in Excel.
0 Comments
Leave a Reply. |