v5.2.0

Minor Changes

• 74cdc44: Add searchDeveloperMetadata method and support DeveloperMetadataLookup filters in loadCells
• 71ee84d: Add retryConfig parameter to allow customising error handling

Patch Changes

• fd12a3b: Fix crash when saving a row with all empty values, and ensure empty cells always return '' instead of undefined
• 557ce16: Allow setting cell.stringValue to strings starting with = — they are now stored as literal string values instead of throwing an error

v5.1.0

Minor Changes

• 3edb1ba: Add deleteDimension, deleteRows, and deleteColumns methods to GoogleSpreadsheetWorksheet

• a2f00b2: Add comprehensive data manipulation and convenience methods to GoogleSpreadsheetWorksheet:

  Data Manipulation Methods:

  • pasteData: Insert delimited data at a coordinate
  • appendDimension: Append rows or columns to sheet
  • textToColumns: Split delimited text into columns
  • deleteRange: Delete cells and shift remaining
  • deleteDimension: Delete rows or columns
  • moveDimension: Move rows or columns
  • sortRange: Sort data by columns
  • trimWhitespace: Remove leading/trailing spaces
  • deleteDuplicates: Remove duplicate rows
  • copyPaste: Copy and paste ranges
  • cutPaste: Cut and paste ranges
  • autoFill: Fill cells with patterns
  • repeatCell: Repeat cell data across range
  • appendCells: Append cell data to sheet
  • findReplace: Find and replace text
  • randomizeRange: Randomize row order

  Convenience Wrapper Methods (auto-fill sheetId):

  • addNamedRange: Create named ranges in worksheet
  • updateNamedRange: Update existing named ranges
  • deleteNamedRange: Delete named ranges
  • setBasicFilter: Set basic filter on sheet
  • clearBasicFilter: Clear basic filter from sheet
  • updateBorders: Update cell borders in range

  Filter View Methods:

  • addFilterView: Add filter views to sheets
  • updateFilterView: Update existing filter views
  • deleteFilterView: Delete filter views
  • duplicateFilterView: Duplicate filter views

  Conditional Formatting Methods:

  • addConditionalFormatRule: Add conditional format rules
  • updateConditionalFormatRule: Update or move conditional format rules
  • deleteConditionalFormatRule: Delete conditional format rules

  Banding Methods:

  • addBanding: Add alternating row/column colors
  • updateBanding: Update banding properties
  • deleteBanding: Delete banded ranges

  Developer Metadata Methods:

  • createDeveloperMetadata: Create custom metadata
  • updateDeveloperMetadata: Update existing metadata
  • deleteDeveloperMetadata: Delete metadata

v5.0.3

Patch Changes

• c1db500: Implement autoResizeDimensions method to auto-resize rows or columns to fit their contents
• c1db500: Add deletePermission method to revoke access for a user, group, or domain
• c1db500: Implement insertRange method to insert empty cells in a range and shift existing cells
• c1db500: Add protected range CRUD operations (addProtectedRange, updateProtectedRange, deleteProtectedRange) on worksheets
• c1db500: Fix addNamedRange request body to correctly nest properties under namedRange key

v5.0.1

What's Changed

• fix peer dep type issue by @theoephraim in #731

Full Changelog: v5.0.0...v5.0.1

v5.0.0

What's Changed

• add changesets for release tooling by @theoephraim in #730
• modernize, update deps by @theoephraim in #729

Full Changelog: v4.1.5...v5.0.0

Release 4.1.5

• fix small ts issue (21f5d3f)
• fix download method issue when gid is 0 (d53e189)
• fix row.assign to use Partial (079c515)
• Fix/googl auth library v10 (#725) (a9c37fe)
• add tea.yaml file (ae132d7)
• move from Unlicense to MIT (ea756a1)
• swap out exposed google service account creds (10392d5)
• wiring up github action to dmno (d5f0734)

Release 4.1.4

• add dmno and remove/encrypt test-related secrets, swap jest for vitest (927e9e8)
• fix(updateProperties): getFieldMask ignore gridProperties (#674) (f874bfe)

Release 4.1.3

• fix bugs introduced by PRs (3fe15c1)
• update axios, fix new google-auth-library issue, fixes #701 #700 (d0bb05b)
• Read headers in batch on getRows() (#693) (62af3d6)
• Merge pull request #658 from duncanbarrigan/patch-1 (0478876)
• Merge pull request #699 from maykbrito/main (e02433d)
• Update authentication.md (78fa7ee)
• allow CI manual reruns (e10cbb1)
• Update FUNDING.yml (5459a87)
• fix setDataValidation docs (2bca048)
• use correct type in docs (6d210a2)

Release 4.1.2

• add setDataValidation #691
• fix docs typos
• move from CircleCI to GH Actions 53fe384

Release 4.1.1

• Merge pull request #657 from ruscon/master (93711cf)
• docs: remove outdated reference to doc.useServiceAccountAuth() (a60104b)
• chore(deps): allow google-auth-library@^9.0.0 (2652f0c)