Bug 1255811 - [fix available] Calc: Random Number generator can't be edited and applied for cell location
[fix available] Calc: Random Number generator can't be edited and applied for...
Status: CLOSED ERRATA
Product: Red Hat Enterprise Linux 7
Classification: Red Hat
Component: libreoffice (Show other bugs)
7.2
Unspecified Unspecified
unspecified Severity medium
: rc
: ---
Assigned To: Eike Rathke
Desktop QE
:
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2015-08-21 11:38 EDT by Bill Sanford
Modified: 2016-11-03 15:01 EDT (History)
5 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2016-11-03 15:01:25 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
This is the original selection with the mouse (284.23 KB, image/png)
2015-08-21 11:39 EDT, Bill Sanford
no flags Details
This is the edited dialog box using the keyboard and editing the cell value (292.90 KB, image/png)
2015-08-21 11:40 EDT, Bill Sanford
no flags Details
This shows that the cells are filled in, despite what the dialog box says. (324.02 KB, image/png)
2015-08-21 11:41 EDT, Bill Sanford
no flags Details

  None (edit)
Description Bill Sanford 2015-08-21 11:38:09 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:
Comment 3 Bill Sanford 2015-08-21 11:39:22 EDT
Created attachment 1065632 [details]
This is the original selection with the mouse
Comment 4 Bill Sanford 2015-08-21 11:40:24 EDT
Created attachment 1065633 [details]
This is the edited dialog box using the keyboard and editing the cell value
Comment 5 Bill Sanford 2015-08-21 11:41:44 EDT
Created attachment 1065634 [details]
This shows that the cells are filled in, despite what the dialog box says.
Comment 6 Eike Rathke 2015-08-25 08:33:36 EDT
I'm investigating.
Comment 9 Bill Sanford 2016-09-01 12:06:34 EDT
Verified

RHEL-7.3-20160901.1
libreoffice-5.0.6.2-3.el7.x86_64
Comment 11 errata-xmlrpc 2016-11-03 15:01:25 EDT
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

Note You need to log in before you can comment on or make changes to this bug.