Preferences

Location on ribbon: Tab DVD Addin → Group About → Menu About Menu

Command ID: btnPreferences

What it does

Opens the Preferences window, the single place where all of DVDAddin's default behaviour is configured. Instead of re-picking the same options every time you run a command, you set them once here and the related commands follow. The window is split into sections listed down the left: Text & Number, Cells & Rows, Formula, Graphics, File & Print, View & Sheets, AI Assistant and Shortcuts.

How to use

1. Go to tab DVD Addin → group About → About Menu → Preferences.
2. Click a section on the left; its settings appear in the panel on the right.
3. Adjust what you need. Typical settings per section:
   • Text & Number — the default translation engine (Google, ChatGPT or Gemini).
   • Cells & Rows — the delimiter used when joining cells (space, comma, semicolon, newline or a custom string), whether deletion skips hidden rows, and the default number of rows to insert.
   • Formula — the default rounding function and decimal count, the reference-locking style (lock both row and column, row only, or column only), skip hidden cells, and error checking on or off.
   • Graphics — how inserted pictures fit the cell, comment width, auto-click interval, and whether captures include the Excel frame.
   • File & Print — default paper size and automatic row-height fitting for printing.
   • AI Assistant — the provider, model and API key used by every AI command.
4. Click the save button at the bottom to commit your settings, or close the window to discard them.

Example

An estimating team standardises on ROUND to three decimals for all quantity sheets, and on column-only reference locking. Each machine opens Preferences → Formula, sets the rounding function to ROUND, decimals to 3, locking style to column only, and saves. From then on the Rounding functions and Lock cell references commands produce identical results across the team without anyone remembering to pick the options by hand.

Notes

• The window is modal — close it before you can work in Excel again.
• Settings are stored in your Windows user profile, not in the workbook; copy the file to another PC and that PC uses its own preferences.
• Changes apply to subsequent runs of a command only; they do not rework output produced earlier.
• The API key in the AI Assistant section is mandatory for every AI-backed command; without it those commands return nothing.
• A few settings only take effect the next time you reopen the relevant command window.

Related

• AI Chat — uses the provider and model set in the AI Assistant section.
• Rounding functions — takes its function and decimal count from the Formula section.
• Lock cell references — follows the locking style set in the Formula section.
• Lang: EN — the interface language, which is toggled outside this window.