- Update to version 5.7.1
* Fix dependencies required version by @lavigne958 in #1147
- Update to version 5.7.0
* chore: Update outdated LICENSE year by @bluzir in #1124
* add dependabot to maintain dependencies by @lavigne958 in #1126
* improve trigger on CI by @lavigne958 in #1134
* Bump bandit from 1.7.0 to 1.7.4 by @dependabot in #1133
* cancel previous run on same ref by @lavigne958 in #1135
* Bump actions/setup-python from 2 to 4 by @dependabot in #1127
* Bump actions/checkout from 2 to 3 by @dependabot in #1128
* Bump black from 22.3.0 to 22.10.0 by @dependabot in #1132
* Bump isort from 5.9.3 to 5.10.1 by @dependabot in #1131
* Bump codespell from 2.1.0 to 2.2.2 by @dependabot in #1130
* add named tuple for DateTimeRenderOption by @lavigne958 in #1136
* Feature/copy cut paste by @lavigne958 in #1138
* isSheetHidden method added to worksheet.py by @SazidAF in #1140
OBS-URL: https://build.opensuse.org/request/show/1039850
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=19
- 5.5.0 (2022-08-31)
Use pathlib by @lavigne958 in #1057
Migrate to drive API V3 by @lavigne958 in #1060
Implement __eq__ method for Cell by @chisvi in #1063
Add missing documentation on set_timeout by @lavigne958 in #1070
Add method to transfer / accept ownership of a spreadsheet by @lavigne958 in #1068
Add client_factory param to auth methods by @jlumbroso in #1075
Fix list_protected_ranges by @lavigne958 in #1076
Add function to convert column letter to column index by @lavigne958 in #1077
Fix docstring name of named_range() param by @dgilman in #1081
Fix grammar in docstring for client.export by @dgilman in #1080
Many typo fixes to worksheet docstrings by @dgilman in #1083
Fix function numericise_all by @lavigne958 in #1082
Fix documentation about oauth_from_dict by @lavigne958 in #1088
inherit_from_before option for insert_row/insert_rows by @yongrenjie in #1092
add method to change the color of a tab by @lavigne958 in #1095
docs: Fix a few typos by @timgates42 in #1094
Fix typo in Worksheet.batch_format method by @lavigne958 in #1101
## New Contributors * @chisvi made their first contribution in #1063 * @jlumbroso made their first contribution in #1075 * @yongrenjie made their first contribution in #1092
- 5.4.0 (2022-06-01)
fix typo by @joswlv in #1031
Fix error message in get_all_records by @lavigne958 in #1028
Added feature request #1022. Auto resizing is now available for rows … by @mketer1 in #1033
add new method to hide/show a worksheet by @lavigne958 in #1030
feat: Download PDF from Spreadsheet #1035 by @100paperkite in #1036
Add test on auto_resize_columns by @lavigne958 in #1039
Add method to unmerge cells by @lavigne958 in #1040
Add method to delete a protected range by @lavigne958 in #1042
Feature/clean organize documentation by @lavigne958 in #1043
Add warning about deprecated oauth flow by @lavigne958 in #1047
OBS-URL: https://build.opensuse.org/request/show/1006789
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=15
* Add `Worksheet.insert_note()`, `Worksheet.update_note()`, `Worksheet.clear_note()` (#818 by @lavigne958)
* Add `Worksheet.insert_cols()` (#802 by @AlexeyDmitriev)
* Add `value_render_option` parameter to `Worksheet.get_all_records()` (#776 by @damgad)
* Remove `requests` from `install_requires` (#801)
* Simplify implementation of `Worksheet.insert_rows()` (#799 by @AlexeyDmitriev)
* Add `auth.service_account_from_dict()` (#785 b7 @mahenzon)
* Fix `ValueRange.from_json()` (#791 by @erakli)
* Allow `auth` to be `None`. Fix#773 (#774 by @lepture)
* Add `Worksheet.insert_rows()` (#734 by @tr-fi)
* Add `Worksheet.copy_to()` (#758 by @JoachimKoenigslieb)
* Add ability to create a cell instance using A1 notation (#765 by @tivaliy)
* Add `auth.service_account()` (#768)
* Add Authlib usage (#552 by @lepture)
* Simplified OAuth2 flow (#762)
* Fix `Worksheet.delete_rows()` index error (#760 by @rafa-guillermo)
* Deprecate `Worksheet.delete_row()` (#766)
* Scope `Worksheet.find()` to a specific row or a column (#739 by @alfonsocv12)
* Add `Worksheet.add_protected_range()` #447 (#720 by @KesterChan01)
* Add ability to fetch cell address in A1 notation (#763 by @tivaliy)
* Add `Worksheet.delete_columns()` (#761 by @rafa-guillermo)
* Ignore numericising specific columns in `get_all_records` (#701 by @benjamindhimes)
* Add option ``folder_id`` when creating a spreadsheet (#754 by @Abdellam1994)
* Add `insertDataOption` to `Worksheet.append_row()` and `Worksheet.append_rows()` (#719 by @lobatt)
* Fix `TypeError` when using gspread in google colab (#750)
* Remove `oauth2client` in favor of `google-auth` #472, #529 (#637 by @BigHeadGeorge)
* Convert `oauth2client` credentials to `google-auth` (#711 by @aiguofer)
* Remove unnecessary `login()` from `gspread.authorize`
* Fix sheet name quoting issue (#554, #636, #716):
+ Add quotes to worksheet title for get_all_values (#640 by @grlbrwrg, #717 by @zynaxsoft)
+ Escaping title containing single quotes with double quotes (#730 by @vijay-shanker)
+ Use `utils.absolute_range_name()` to handle range names (#748)
* Fix `numericise()`: add underscores test to work in python2 and <python3.6 (#622 by @epicfaace)
* Add `supportsAllDrives` to Drive API requests (#709 by @justinr1234)
* Add `Worksheet.merge_cells()` (#713 by @lavigne958)
* Improve `Worksheet.merge_cells()` and add `merge_type` parameter (#742 by @aiguofer)
* Add `Worksheet.sort()` (#639 by @kirillgashkov)
* Add ability to reorder worksheets #570 (#571 by @robin900)
+ Add `Spreadsheet.reorder_worksheets()`
+ Add `Worksheet.update_index()`
* Add `test_update_cell_objects` (#698 by @ogroleg)
* Add `Worksheet.append_rows()` (#556 by @martinwarby, #694 by @fabytm)
* Add `Worksheet.delete_rows()` (#615 by @deverlex)
* Speed up `Client.open()` by querying files by title in Google Drive (#684 by @aiguofer)
* Add `freeze`, `set_basic_filter` and `clear_basic_filter` methods to `Worksheet` (#574 by @aiguofer)
* Use Drive API v3 for creating and deleting spreadsheets (#573 by @aiguofer)
* Implement `value_render_option` in `get_all_values` (#648 by @mklaber)
* Set position of a newly added worksheet (#688 by @djmgit)
* Add url properties for `Spreadsheet` and `Worksheet` (#725 by @CrossNox)
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=13
- Update to 3.3.1
* Support old and new collections.abc.Sequence (#745 by @timgates42)
* Added `Spreadsheet.values_batch_update()` (#731)
* Added more parameters to `Worksheet.append_row()` (#726)
* Fix usage of client.openall when a title is passed in (#572 by @aiguofer)
* Fixed sharing from Team Drives (#646 by @wooddar)
* Fixed KeyError in list comprehension in `Spreadsheet.remove_permissions()` (#643 by @wooddar)
* Added `Spreadsheet.values_batch_get()` (#705 by @aiguofer)
* Added `stacklevel=2` to deprecation warnings
OBS-URL: https://build.opensuse.org/request/show/792477
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=11
* Dropped Python 2.6 support
* Fixed KeyError in urllib.quote in Python 2 (#605, #558)
* Fixed Worksheet.title being out of sync after using update_title (#542 by @ryanpineo)
* Fix parameter typos in docs (#616 by @bryanallen22)
* Miscellaneous docs fixes (#604 by @dgilman)
* Fixed typo in docs (#591 by @davidefiocco)
* Added a method to copy spreadsheets (#625 by @dsask)
* Added with_link attribute when sharing / adding permissions (#621 by @epicfaace)
* Added ability to duplicate a worksheet (#617)
* Change default behaviour of numericise function #499 (#502 by @danthelion)
* Added stacklevel=2 to deprecation warnings
- Switch to github tarball for tests
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-gspread?expand=0&rev=7
