Fill Rand
Fill an arithmetic sequence randomly in the selected cell range.
Calc
Macro
Download latest
latest release: 2024-03-11 20:49:17
Description
- If the range contains already entered cells, it will abort.
- If the range is abnormally large, a warning dialog box is displayed. (10000 cells)
- A dialog box for entering Start and Step numbers is displayed, so enter any number.
- Randomly fill an arithmetic sequence in the selection.
- The command is in the menu.
- Menu > Tools > Add-Ons > Fill Rand
| Release | Description | Compatibility | Operating Systems | License | Release notes | Updated | |
|---|---|---|---|---|---|---|---|
| ver_2024.01.21 | Change Empty check code | 6.0 | Windows | CC0 | 2024-01-21 09:55:02 | Download | |
| ver_2024.01.08 | Change shuffle loop | 6.0 | Windows | CC0 | Change shuffle loop | 2024-01-08 04:58:19 | Download |
| ver_2023.12.29 | New Release | 6.0 | Windows | CC0 | None | 2023-12-29 08:01:07 | Download |
☆ ☆ ☆ ☆ ☆
Post your review
You cannot post reviews until you have logged in. Login Here.
Reviews
Heiko Tietze Dec 29, 2023, 10:09 AM (12 months ago)
☆ ☆ ☆ ☆ ☆
What functionality does this macro add to the inbuilt RAND functions? https://help.libreoffice.org/latest/en-US/text/scalc/01/04060106.html?DbPAR=CALC#bm_id3164800
nobu tac Jan 8, 2024, 5:08 AM (12 months ago)
(I don't know how to create the next reply.)
Thank you for your advice.
I am open to adding functionality upon request, to the best of my understanding.
(I was able to create a sequence of 1000000 numbers in less than 1 second using the standard Python module.)
Analysts who need special random numbers should be using "Python" when they use "Calc", so I don't think I need to help them, but I will consider adding the functionality if there is a note that it is needed.
Right now I have no idea what kind of things are needed.
nobu tac Jan 2, 2024, 3:55 AM (12 months ago)
I don't know what your post means,
If you say that this extension is meaningless because it can be easily achieved by devising the "Rand function", I say that is true.
If you have the authority to delete this extension, I will permit it.
(by Google translation)
Heiko Tietze Jan 2, 2024, 9:13 AM (12 months ago)
Your contributions are definitely not meaningless. At least it's an educational gem. But you could also enhance it to provide different types randomness, for example a normal, "Gaussian" distribution.
No one has commented on this page yet.
RSS feed for reviews on this page | RSS feed for all reviews