copy_range() doc enhancement

[brianjmurrell]

Describe the bug
A doc bug, but I can't seem to find where the doc source is, so I will just report it here.

The explanation of dest in copy_range() seems to imply that no matter the size of the dest range, the source range is only copied once into the dest range. My experience is different. If I copy A305:BR305 to A306:BR328, I get a copy of the range of A305:BR305 into each of the ranges of A306:BR328. Happily this is what I wanted and what I went out on a limb to try to achieve despite the method's description.

It might be helpful to future users to spell this happy convenience out in the docs.

Now that said, I have not tried what happens when the source range is multiple lines [and the dest range is at least 2x, but a multiple of the source range's lines -- or not even] 😄

[alifeee]

hi @brianjmurrell, thanks for the report !

the documentation I think you are looking at is here in the repository:

gspread/gspread/worksheet.py

Lines 3230 to 3252 in a8be3b9

	"""Copies a range of data from source to dest
	.. note::
	``paste_type`` values are explained here: `Paste Types`_
	.. _Paste Types: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#pastetype
	:param str source: The A1 notation of the source range to copy
	:param str dest: The A1 notation of the destination where to paste the data
	Can be the A1 notation of the top left corner where the range must be paste
	ex: G16, or a complete range notation ex: G16:I20.
	The dimensions of the destination range is not checked and has no effect,
	if the destination range does not match the source range dimension, the entire
	source range is copies anyway.
	:param paste_type: the paste type to apply. Many paste type are available from
	the Sheet API, see above note for detailed values for all values and their effects.
	Defaults to ``PasteType.normal``
	:type paste_type: :class:`~gspread.utils.PasteType`
	:param paste_orientation: The paste orient to apply.
	Possible values are: ``normal`` to keep the same orientation, ``transpose`` where all rows become columns and vice versa.
	:type paste_orientation: :class:`~gspread.utils.PasteOrientation`
	"""

I would welcome you to suggest an edit to this that would make the behaviour more clear than you found it

If you wanted, you could also test the behaviour of copy_range in the specific situation you describe in your final sentence - you could even make a test in our test suite and then we could document it !