Bug 154873 - The Random Number Generator dialog should allow the user to inform the number of rows and columns to be generated
Summary: The Random Number Generator dialog should allow the user to inform the number...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.0 alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Dialog
  Show dependency tree / graph
 
Reported: 2023-04-17 21:35 UTC by Rafael Lima
Modified: 2023-04-19 05:05 UTC (History)
1 user (show)

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 Rafael Lima 2023-04-17 21:35:33 UTC 
Calc's Random Number Generator (accessible via Sheet - Fill Cells - Fill Random Number) allows to generate random values that will be applied to the selected cell range. This means that you need to manually select the range where the numbers will be placed.

The problem with this is when you want to create many random numbers at once, for instance 10,000 rows by 50 columns. It's a really bad experience to select such enormous range manually.

Instead, we should allow the user to enter how many columns and rows to generate from a starting selected cell.

This would be similar to what Excel does (not exactly, but similar). See attachment 186746 [details] from bug 154872 for a comparison between Calc and Excel RNG's.
Comment 1 Eike Rathke 2023-04-17 22:18:28 UTC 
Shift+Ctrl+T A1:AX10000 Enter
50x10000 range gets selected ;-)

But yeah..