v5.12.0

What's Changed

• feature -- adding worksheet.get_records to get specific row ranges by @AndrewBasem1 in #1301
• Fix list_spreadsheet_files return value by @mephinet in #1308
• Fix warning message for worksheet.update method by @ksj20 in #1312
• change lambda function to dict (fix pyupgrade issue) by @alifeee in #1319
• allows users to silence deprecation warnings by @lavigne958 in #1324
• Add maintain_size to keep asked for size in get, get_values by @alifeee in #1305

New Contributors

• @AndrewBasem1 made their first contribution in #1301
• @mephinet made their first contribution in #1308
• @ksj20 made their first contribution in #1312

Full Changelog: v5.11.3...v5.12.0

v5.11.3

• Fix list_spreadsheet_files return value by @mephinet in #1308

Full Changelog: v5.11.2...v5.11.3

v5.11.2

What's Changed

• Fix merge_combined_cells in get_values (AND 5.11.2 RELEASE) by @alifeee in #1299

Full Changelog: v5.11.1...v5.11.2

v5.11.1

What's Changed

• Bump actions/checkout from 3 to 4 by @dependabot in #1288
• remove Drive API access on Spreadsheet init (FIX - VERSION 5.11.1) by @alifeee in #1291

Full Changelog: v5.11.0...v5.11.1

v5.11.0

Why is my code broken?

If you are now getting an APIError when opening a spreadsheet, you might not have enabled the Google Drive API for your access token. Please see #1286.

fixed in v5.11.1

What's Changed

• add docs/build to .gitignore by @alifeee in #1246
• add release process to CONTRIBUTING.md by @alifeee in #1247
• Update/clean readme badges by @lavigne958 in #1251
• add test_fill_gaps and docstring for fill_gaps by @alifeee in #1256
• Remove API calls from creationTime/lastUpdateTime by @alifeee in #1255
• Fix Worksheet ID Type Inconsistencies by @FlantasticDan in #1269
• Add column_count prop as well as col_count by @alifeee in #1274
• Add required kwargs with no default value by @lavigne958 in #1271
• Add deprecation warnings for colors by @alifeee in #1278
• Add better Exceptions on opening spreadsheets by @alifeee in #1277

New Contributors

• @FlantasticDan made their first contribution in #1269

Full Changelog: v5.10.0...v5.11.0

v5.10.0

What's Changed

• Fix rows_auto_resize in worksheet.py by removing redundant self by @MagicMc23 in #1194
• Add deprecation warning for future release 6.0.x by @lavigne958 in #1195
• FEATURE: show/hide gridlines (#1197) by @alifeee in #1202
• CLEANUP: cleanup tox.ini, and ignore ./env by @alifeee in #1200
• Refactor/update-contributing-guide by @alifeee in #1206
• Spelling fix (with legacy option) by @alifeee in #1210
• 457-fetch-without-hidden-worksheets by @alifeee in #1207
• Add_deprecated_warning_sort_method by @lavigne958 in #1198
• Update (and test for) internal properties on change by @alifeee in #1211
• Feature: Add "Remove tab colour" method by @alifeee in #1199
• Refresh-test-cassettes by @alifeee in #1217
• update self._properties after batch_update by @alifeee in #1221
• 700-fill-merged-cells by @alifeee in #1215
• Fix/update-internal-properties by @alifeee in #1225
• Add breaking change warning in Worksheet.update() by @lavigne958 in #1226
• Bump codespell from 2.2.4 to 2.2.5 by @dependabot in #1232
• Add/refresh last update time by @alifeee in #1233
• Update-build-tools by @alifeee in #1231
• add read the doc configuration file by @lavigne958 in #1235
• update licence year by @alifeee in #1237
• remove deprecated methods from tests by @alifeee in #1238

New Contributors

• @MagicMc23 made their first contribution in #1194

Full Changelog: v5.9.0...v5.10.0

v5.9.0

What's Changed

• Bugfix/fix get last update time by @lavigne958 in #1186
• Add batch notes insert/update/clear by @lavigne958 in #1189

Full Changelog: v5.8.1...v5.9.0

v5.8.1

What's Changed

• Bump black from 22.10.0 to 22.12.0 by @dependabot in #1154
• Bump isort from 5.10.1 to 5.11.3 by @dependabot in #1155
• Bump isort from 5.11.3 to 5.11.4 by @dependabot in #1157
• #1104: added a delete by worksheet id method by @muddi900 in #1148
• improve CI workflow - upgrade setuptools to fix CVE by @lavigne958 in #1179
• Bump codespell from 2.2.2 to 2.2.4 by @dependabot in #1178
• Bump bandit from 1.7.4 to 1.7.5 by @dependabot in #1177
• Bump black from 22.12.0 to 23.1.0 by @dependabot in #1168
• Update user-guide.rst to include a warning by @alsaenko in #1181
• Fixed typo in docs/user-guide.rst by @raboba2re in #1182
• Bump black from 23.1.0 to 23.3.0 by @dependabot in #1183
• Handle cases when rgbColor is not set by @lavigne958 in #1184

New Contributors

• @muddi900 made their first contribution in #1148
• @alsaenko made their first contribution in #1181
• @raboba2re made their first contribution in #1182

Full Changelog: v5.7.2...v5.8.0

v5.7.2

What's Changed

• Fix: hidden property might not be set from the API by @lavigne958 in #1151

Full Changelog: v5.7.1...v5.7.2

v5.7.1

What's Changed

• Fix dependencies required version by @lavigne958 in #1147

Full Changelog: v5.7.0...v5.7.1