Bug 124753 - Function =Randbetween(10;99) updates value in cell every time when I paste it into another cell
Summary: Function =Randbetween(10;99) updates value in cell every time when I paste it...
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.1.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2019-04-15 12:11 UTC by Roman Kuznetsov
Modified: 2019-05-16 17:59 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.