Randomly shuffle a cell range contents.
A block of cells is a rectangular range of cells surrounded by empty cells.
LibreOfficeDev Calc automatically identifies a block of cells for shuffling. Place the cursor within the block, and the shuffling will take place accordingly.
If all the cells in the first row of a block are text cells, this row is assumed to be the header. The shuffling will then be performed from the second row to the last row of the block, except if all the block cells are text cells.
However, if any cell in the first row contains a numerical value, or all the block cells are text cells, the first row will not be considered a header, and shuffling will be applied to the entire block.
The shuffling is applied to the selected column or the first column of the block.
If the selected column is inside the block, LibreOfficeDev Calc prompts to extend the shuffling to the adjacent columns.