v5.7.0

What's Changed

• chore: Update outdated LICENSE year by @bluzir in #1124
• add dependabot to maintain dependecies 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

New Contributors

• @bluzir made their first contribution in #1124
• @dependabot made their first contribution in #1133
• @SazidAF made their first contribution in #1140

Full Changelog: v5.6.2...v5.7.0

v5.6.2

What's Changed

• update parent folder for client.copy method by @lavigne958 in #1123

Full Changelog: v5.6.0...v5.6.2

v5.6.0

What's Changed

• Fix clear_note method when using numeric boundaries by @lavigne958 in #1106
• Fix a typo in the permissions:create API payload by @jiananma in #1107
• Fix spreadsheet URL by @lavigne958 in #1110
• Return created permission on Spreadsheet.share() by @lavigne958 in #1111
• (fixed #1113) Supply correct Google API v3 permission for domains by @NickCrews in #1115
• Bugfix/numericese all by @lavigne958 in #1119
• Lavigne958 prepare release 5.6.0 by @lavigne958 in #1120

New Contributors

• @jiananma made their first contribution in #1107
• @NickCrews made their first contribution in #1115

Full Changelog: v5.5.0...v5.6.0

v5.5.0

What's Changed

• 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 parameter 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

Full Changelog: v5.4.0...v5.5.0

v5.4.0

What's Changed

• 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
• Add new batch_format method. by @lavigne958 in #1049
• Encode string to utf-8 when importing CSV content by @lavigne958 in #1054

New Contributors

• @joswlv made their first contribution in #1031
• @mketer1 made their first contribution in #1033
• @100paperkite made their first contribution in #1036

Full Changelog: v5.3.2...v5.4.0

v5.3.2

What's Changed

• Bugfix/black python3.10 by @lavigne958 in #1020
• Automate releases by @lavigne958 in #1025
• Bugfix/get all record duplicated columns by @lavigne958 in #1021

Full Changelog: v5.3.0...v5.3.2

v5.3.0

What's Changed

• Feature/rework test cassettes recording by @lavigne958 in #1004
• add method list protected ranges by @lavigne958 in #1008
• Add new methods to add/list/delete dimensionGroups by @lavigne958 in #1010
• Add method to hide rows/columns by @lavigne958 in #1012
• Add ability to rename Spreadsheets (via a new Spreadsheet.update_title) by @jansim in #1013

New Contributors

• @jansim made their first contribution in #1013

Full Changelog: v5.2.0...v5.3.0

5.2.0

What's Changed

• Copy comments when during spreadsheet copy by @lavigne958 in #979
• Update user-guide.rst by @maky-hnou in #980
• merge setup test cassettes by @lavigne958 in #982
• Feature/add header validation get all records by @lavigne958 in #984
• Add timeout to client by @lavigne958 in #987
• Feature/update timezone and locale by @lavigne958 in #989
• Feature/make case comparison in find by @lavigne958 in #990
• Updated API rate limits by @hvinayan in #993
• Feature/prevent insert row to sheet with colon by @lavigne958 in #992

New Contributors

• @maky-hnou made their first contribution in #980
• @hvinayan made their first contribution in #993

Full Changelog: v5.1.1...v5.2.0

v5.1.1

5.1.1 (2021-12-22)

• Fix documentation about oauth (#975 by @lavigne958)

v5.1.0

5.1.0 (2021-12-22)

• Codespell skip docs build folder (#962 by @lavigne958)

• Update contributing guidelines (#964 by @lavigne958)

• Add oauth from dict (#967 by @lavigne958)

• Update README.md to include badges (#970 by @lavigne958)

• Add new method to get all values as a list of Cells (#968 by @lavigne958)

• automatic conversion of a cell letter to uppercase (#972 by @burovytskyi)