Function Randbetween(10;99) updates value in cell every time when I paste it into another cell
Steps to Reproduce:
1. Open Calc
2. Paste in to cell A1 a formula =Randbetween(10;99). Remember a value in cell
3. Paste the same formula into cell A2. Value in A1 cell have changed
4. Paste the same formula into cell A3. Values in A1 and A2 have changed again
Values in A1 and A2 changes after pasting the formula in to A3
Values in A1 and A2 don't change after pasting the formula in to A3
User Profile Reset: No
ID сборки: 757c58e8cb70b2982843211a54750fb3cd79acd5
Потоков ЦП: 4; ОС:Windows 6.1; Отрисовка ИП: по умолчанию; VCL: win;
Локаль: ru-RU (ru_RU); Язык UI: ru-RU
but value doesn't update in
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 4; OS: Windows 6.1; UI render: default;
Locale: ru-RU (ru_RU); Calc: group threaded
I don't know it's a regression or not. May be in LO 6.2 it became to work right?
RANDBETWEEN() is now (since 6.2) a volatile function, meaning it recalculates on every edit event in the spreadsheet document as it should and like RAND() did all the time. This is on purpose and not a bug. See bug 102257
It's a very bad choice, sad.
Can you add options to choose old type?
(In reply to djtalisman from comment #3)
> Can you add options to choose old type?
I think better to create a new enhancement for this
(In reply to Roman Kuznetsov from comment #4)
> (In reply to djtalisman from comment #3)
> > Can you add options to choose old type?
> I think better to create a new enhancement for this
Please don't. RAND() and RANDBETWEEN() recalculating new results if AutoCalc is enabled every time the document is changed is standard behaviour in all major spreadsheet implementations and expected.