Red Hat Bugzilla – Bug 1255811
[fix available] Calc: Random Number generator can't be edited and applied for cell location
Last modified: 2016-11-03 15:01:25 EDT
Description of problem: The Random Number Generator dialog box only sees what the mouse selects on the spreadsheet and ignores manual input for a cell range. Edit -> Fill -> Random Number, I selected $C$1:$H$25 as a range with my mouse. I then edited the range by replacing $C$1 with $A$1. When I click apply, the random numbers are only filled out in $C$1:$H$25 when clearly, the dialog box has $A$1:$H$25. I will attach the screen captures of what I witnessed. Version-Release number of selected component (if applicable): RHEL-7.2-20150817.n.2 libreoffice-4.3.7.2-5.el7.x86_64 How reproducible: 100% Steps to Reproduce: 1. See Above 2. 3. Actual results: Filling in random numbers in original cells from mouse swipe. Expected results: Filling in random numbers in edited cells from keyboard editing. Additional info:
Created attachment 1065632 [details] This is the original selection with the mouse
Created attachment 1065633 [details] This is the edited dialog box using the keyboard and editing the cell value
Created attachment 1065634 [details] This shows that the cells are filled in, despite what the dialog box says.
I'm investigating.
Verified RHEL-7.3-20160901.1 libreoffice-5.0.6.2-3.el7.x86_64
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHSA-2016-2579.html