Grammar
Location on ribbon: Tab DVD Addin → Group AI → Menu AI Menu
Command ID: btnAIGrammarly
License required
This command needs an active DVDAddin account (Standard or PRO). During the Trial period it is fully available.
What it does
Sends the text of every selected cell to the AI (Gemini) for spelling and grammar correction, then writes the corrected text back over the same cell. The work runs in the background, one cell at a time, and reports how many cells were fixed when it finishes. Useful for cleaning up a work-description column, a method-statement narrative, or the remarks in an inspection record before the file goes out.
How to use
- Select the range of text cells you want corrected (a description column, a block of remarks, and so on).
- Go to tab DVD Addin → group AI → AI Menu → Grammar.
- The add-in counts the cells that actually contain text and shows "Fixing grammar for N cells via Gemini…".
- Wait while it works. Each cell is sent to the AI separately; the reply is stripped of
**Markdown markers and written over the cell. - A summary message appears at the end with the number of cells fixed and the number that failed.
Example
The Work description column of an inspection record was typed by several people, so the wording is inconsistent.
| Before | After |
|---|---|
inspection of slab beam rebar level 3 , accepted | Inspection of slab and beam reinforcement at Level 3, accepted. |
erect column formwork grid A-B ,not cleaned | Erect column formwork on grid A-B, not yet cleaned. |
Select the description column and click Grammar; after a few seconds the cells are rewritten with correct spelling and punctuation.
Notes
- A range must be selected first; if the selection is not a cell range, or no cell holds text, the add-in reports it and stops.
- Results overwrite the original cells and cannot be undone with Ctrl+Z — back up the sheet before running it over a large range.
- Only cells whose value is a text string are sent; numeric cells, formula cells and blanks are skipped.
- Each cell is a separate API call, so a selection of several hundred cells takes a long time and consumes API quota.
- Requires Internet and a Gemini API key set in Preferences ▸ AI Assistant; any cell whose call fails is counted as an error and keeps its original text.
Related
- Add Vietnamese accents — also AI-driven, restores diacritics on unaccented text.
- Translate — translate cell contents into another language.
- Smart case — fix capitalisation without calling any AI service.
- Preferences — where the API key and AI provider are configured.