v1.2.0

What's Changed

• Add menu to get DeepL API usage status by @ttsukagoshi in #154

Full Changelog: v1.1.0...v1.2.0

v1.1.0

What's Changed

SheetsL will now be using the POST method together with the payload property for calling the DeepL API for translation via Google Apps Script's built-in UrlFetchApp.fetch() method. This will significantly increase the number of cells and text length that the add-on can translate in a single execution of the translation.

• Switch to using payload on the POST method on calling the DeepL API for translation at the /v2/translate endpoint by @ttsukagoshi in #152

Details

The previous versions of SheetsL have used the traditional DeepL API translation method of calling the request via URL parameters, where the source text(s) and the language settings were embedded directly in the URL for calling the API. Together with Google Apps Script's limitation that URL length must be within 2KB/call, this had imposed a rather limited experience for SheetsL users, especially when they wanted to bulk translate a large number of cells.

Now that the add-on uses the payload property when calling the API, it can translate chunks of cells at the same time.

As of the time of this release, the official DeepL API documentation states that the total request body size should not exceed 128 KiB, i.e., 128 * 1024 bytes, for a single translation request. Also, a single call can contain up to 50 texts, which in SheetsL will mean 50 Google Sheets cells. Users of SheetsL, however, do not have to care about these limitations. SheetsL will automatically split the translation request when necessary and concatenate the results, so the user should not notice any difference. Select as many cells that you want to translate and let SheetsL do the job.
The only time that a user will be given a heads-up error notification is when a cell in Google Sheets selected by the user for translation contains text long enough to exceed the 128 KiB limit just by itself. Since SheetsL cannot split the translation request for a single cell, an error message will be shown to the user to prompt them to adjust the contents of the cell in question.

Full Changelog: v1.0.4...v1.1.0

v1.0.4

What's Changed

Housekeeping updates to dev dependencies and subsequent refactoring/re-formatting of the script.
No functional changes have been made.

Dev Dependency Updates

• npm dedupe by @ttsukagoshi in #94
• npm(deps-dev): bump typescript from 5.1.3 to 5.1.6 by @dependabot in #97
• npm(deps-dev): bump eslint from 8.41.0 to 8.43.0 by @dependabot in #99
• npm(deps-dev): bump @typescript-eslint/eslint-plugin from 5.59.8 to 5.60.1 by @dependabot in #98
• npm(deps-dev): bump @typescript-eslint/parser from 5.59.8 to 5.60.1 by @dependabot in #100
• npm(deps-dev): bump eslint from 8.43.0 to 8.44.0 by @dependabot in #101
• npm(deps-dev): bump ts-jest from 29.1.0 to 29.1.1 by @dependabot in #102
• github-actions(deps): bump github/accessibility-alt-text-bot from 1.2.0 to 1.3.0 by @dependabot in #108
• npm(deps-dev): bump eslint-config-prettier from 8.8.0 to 8.9.0 by @dependabot in #103
• npm(deps-dev): bump eslint from 8.44.0 to 8.47.0 by @dependabot in #109
• npm(deps-dev): bump prettier from 2.8.8 to 3.0.3 by @dependabot in #112
• github-actions(deps): bump actions/cache from 3.3.1 to 3.3.2 by @dependabot in #118
• github-actions(deps): bump actions/checkout from 3 to 4 by @dependabot in #119
• npm(deps-dev): bump jest and @types/jest by @dependabot in #128
• npm(deps-dev): bump @types/google-apps-script from 1.0.64 to 1.0.79 by @dependabot in #129
• github-actions(deps): bump github/accessibility-alt-text-bot from 1.3.0 to 1.4.0 by @dependabot in #124
• github-actions(deps): bump github/codeql-action from 2 to 3 by @dependabot in #131
• npm(deps-dev): bump eslint-config-prettier from 8.9.0 to 9.1.0 by @dependabot in #132
• npm(deps-dev): bump ts-jest from 29.1.1 to 29.1.2 by @dependabot in #133
• npm(deps-dev): bump eslint-plugin-prettier from 4.2.1 to 5.1.3 by @dependabot in #134
• Clean install dev dependenies by @ttsukagoshi in #139
• github-actions(deps): bump actions/setup-node from 3 to 4 by @dependabot in #123
• github-actions(deps): bump actions/cache from 3.3.2 to 4.0.0 by @dependabot in #130
• npm(deps-dev): bump the typescript-eslint group with 2 updates by @dependabot in #142
• Clean install dev dependencies by @ttsukagoshi in #145

Jest Testing Updates

• Update jest tests by @ttsukagoshi in #149
• Update jest tests by @ttsukagoshi in #150
• Add test for translateRange() by @ttsukagoshi in #151

Misc

• Add accessibility-alt-text-bot workflow by @ttsukagoshi in #95
• Add a11y-alt-text-bot badge to README by @ttsukagoshi in #96
• Group @typescript-eslint updates in dependabot.yml by @ttsukagoshi in #140
• Update with.node-version v16->20 by @ttsukagoshi in #143
• Update Prettier settings to v3 default by @ttsukagoshi in #144
• Update codeql.yml to latest format by @ttsukagoshi in #146
• Update ESLint & Super-Linter settings by @ttsukagoshi in #147

Full Changelog: v1.0.3...v1.0.4

v1.0.3

What's Changed

This update addresses the issue that @Fabiombolo has raised in #75: when there was a cell with text length that exceeded Google's limits, the original error message told the user that the text in question was simply too long. Now, the message will inform the user of the maximum acceptable length of the cell text. See #90 for more details.

FYI, this cap on text length comes from Google Apps Script's limitation on the URL length in UrlFetchApp.fetch(), which is 2KB at the time of this release. The DeepL API accepts texts to be translated in the form of https://api-free.deepl.com/v2/translate?auth_key=******&target_lang=en-GB&text=******, so the text length in a cell directly affects the request URL length.

New Feature 🚀

• Update error message for cells with too much text by @ttsukagoshi in #90

Dev Dependency Updates ⚙️

• npm(deps-dev): bump @typescript-eslint/eslint-plugin from 5.59.2 to 5.59.8 by @dependabot in #82
• npm(deps-dev): bump eslint from 8.39.0 to 8.41.0 by @dependabot in #78
• npm(deps-dev): bump @types/jest from 29.5.1 to 29.5.2 by @dependabot in #80
• npm(deps-dev): bump @typescript-eslint/parser from 5.59.2 to 5.59.8 by @dependabot in #79
• npm(deps-dev): bump @types/google-apps-script from 1.0.62 to 1.0.64 by @dependabot in #81
• npm dedupe by @ttsukagoshi in #83
• npm(deps-dev): bump typescript from 5.0.4 to 5.1.3 by @dependabot in #84

Misc 🌈

• Add test for verifyAuthKeyPrompt #31 by @ttsukagoshi in #85

Full Changelog: v1.0.2...v1.0.3

v1.0.2

What's Changed

Bug Fixes 🐛

• Add process to skip translation of empty cells by @ttsukagoshi in #77

Dev Dependency Updates ⚙️

• Bump typescript v4.9.5 to v5.0.4 by @ttsukagoshi in #68
• npm(deps-dev): bump ts-jest from 29.0.5 to 29.1.0 by @dependabot in #57

Misc

• Add badge and link to Google Workspace Marketplace in README by @ttsukagoshi in #69
• Update SheetsL application banner URL in README.md by @ttsukagoshi in #70
• Add test for onOpen and onInstall #31 by @ttsukagoshi in #71
• Add GitHub Actions to report coverage on PR #31 by @ttsukagoshi in #72

Thanks to @Fabiombolo for reporting #74; this issue has been fixed in this version.

Full Changelog: v1.0.1...v1.0.2

v1.0.1

What's Changed

Bug Fixes 🐞

• Fix typo in error message by @ttsukagoshi in #63
• Switch to cell-by-cell translation in all cases to avoid #65 by @ttsukagoshi in #67

Dev Dependency Updates ⚙️

• github-actions(deps): bump actions/cache from 3.2.6 to 3.3.1 by @dependabot in #45
• npm(deps-dev): bump @types/google-apps-script from 1.0.57 to 1.0.59 by @dependabot in #46
• npm(deps-dev): bump eslint from 8.35.0 to 8.37.0 by @dependabot in #47
• npm(deps-dev): bump prettier from 2.8.4 to 2.8.7 by @dependabot in #49
• npm(deps-dev): bump eslint-config-prettier from 8.6.0 to 8.8.0 by @dependabot in #51
• npm(deps-dev): bump @typescript-eslint/eslint-plugin from 5.54.0 to 5.57.0 by @dependabot in #48
• npm(deps-dev): bump @typescript-eslint/parser from 5.54.0 to 5.57.0 by @dependabot in #52
• github-actions(deps): bump github/super-linter from 4 to 5 by @dependabot in #53
• npm(deps-dev): bump prettier from 2.8.7 to 2.8.8 by @dependabot in #55
• npm(deps-dev): bump eslint from 8.37.0 to 8.39.0 by @dependabot in #56
• npm(deps-dev): bump @typescript-eslint/eslint-plugin from 5.57.0 to 5.59.2 by @dependabot in #59
• npm(deps-dev): bump @typescript-eslint/parser from 5.57.0 to 5.59.2 by @dependabot in #60
• npm(deps-dev): bump @types/google-apps-script from 1.0.59 to 1.0.62 by @dependabot in #61
• npm(deps-dev): bump @types/jest from 29.5.0 to 29.5.1 by @dependabot in #58

Misc 🌈

• Configure Jest (#31) by @ttsukagoshi in #43
• Add function to handle DeepL API errors by @ttsukagoshi in #44
• Partial testing by Jest by @ttsukagoshi in #64

Full Changelog: v1.0.0...v1.0.1

v1.0.0

Public release

v0.6.0-pre

What's Changed

• Fix separator to avoid unmatched number of columns (#38) by @ttsukagoshi in #39

Full Changelog: v0.5.0...v0.6.0

v0.5.0-pre

What's Changed

• Add process to determine byte length of text (#36) by @ttsukagoshi in #37

Full Changelog: v0.4.0...v0.5.0

v0.4.0-pre

What's Changed

Documention

• Update README by @ttsukagoshi in #35

Full Changelog: v0.3.0...v0.4.0