Bug 124753

Summary: Function =Randbetween(10;99) updates value in cell every time when I paste it into another cell
Product: LibreOffice Reporter: Roman Kuznetsov <79045_79045>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED NOTABUG    
Severity: normal    
Priority: medium    
Version: 6.2.1.1 rc   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108827    

Description Roman Kuznetsov 2019-04-15 12:11:59 UTC 
Description:
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

Actual Results:
Values in A1 and A2 changes after pasting the formula in to A3

Expected Results:
Values in A1 and A2 don't change after pasting the formula in to A3


Reproducible: Always


User Profile Reset: No



Additional Info:
Версия: 6.2.1.1
ID сборки: 757c58e8cb70b2982843211a54750fb3cd79acd5
Потоков ЦП: 4; ОС:Windows 6.1; Отрисовка ИП: по умолчанию; VCL: win; 
Локаль: ru-RU (ru_RU); Язык UI: ru-RU
Calc: threaded

but value doesn't update in

Version: 6.1.2.1
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?
Comment 1 Eike Rathke 2019-04-15 12:44:46 UTC 
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
Comment 2 djtalisman 2019-05-15 16:40:55 UTC 
It's a very bad choice, sad.
Comment 3 djtalisman 2019-05-15 18:05:13 UTC 
Can you add options to choose old type?
Comment 4 Roman Kuznetsov 2019-05-15 18:56:00 UTC 
(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
Comment 5 Eike Rathke 2019-05-16 17:59:19 UTC 
(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.