Title icon v3 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 List

Release Description Compatibility Operating Systems License Release notes   ver_2024.01.21 Change Empty check code 6.0 Windows CC0 Download ver_2024.01.08 Change shuffle loop 6.0 Windows CC0

Change shuffle loop

Download ver_2023.12.29 New Release 6.0 Windows CC0

None

Download

Other Extensions

Tip Of The Yesterday

From the dialog, specify the relative or direct number to display the "Tip Of The Day" dialog.

04-2024

28

Not rated yet

Unlock The Matrix

Unprotects the array formula and returns it to the formula in the upper left cell.

04-2024

65

Not rated yet

RegEx Exercise Template

This is a document for practicing regular expressions. (Writer Template)

04-2024

211

Not rated yet

Fill Rand

Fill an arithmetic sequence randomly in the selected cell range.

04-2024

32

Not rated yet

\new Line

Change "\n" in a cell to a new line

04-2024

38

Not rated yet

Show Text Wrapped Cells

Highlight text wrapped cells

05-2024

112

Not rated yet

Feedback

☆ ☆ ☆ ☆ ☆

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

  • Heiko Tietze Dec 29, 2023, 10:09 AM (5 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 (4 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 (5 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 (5 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.

RSS feed for reviews on this page | RSS feed for all reviews