To VNI
Location on ribbon: Tab DVD Addin → Group Text and Number
Command ID: btnConvertVNI
What it does
Converts Vietnamese text in the current selection to the VNI encoding and sets the font of the converted cells to VNI-Times. Use it when a deliverable has to go back to an office that still works with the VNI font family (many older estimate and quantity templates), or when you paste a Unicode table into a legacy workbook and need one consistent typeface for printing.
How to use
- Select the cells to convert (Ctrl-click for several separate areas).
- Go to tab DVD Addin → group Text and Number → click To VNI.
- The add-in detects each cell's source encoding from its current font (
.Vn…= TCVN3,VNI…= VNI, anything else = Unicode) and rewrites the text as VNI. - Converted cells are switched to the VNI-Times font.
- The status bar reports
Converted N cells to Vni (font: VNI-Times)and clears after about 8 seconds.
Example
A contractor's quantity take-off is written in Unicode, but the client requires the old VNI-Times template. Select the work-description column and click To VNI:
| Before (Unicode) | After (VNI bytes, VNI-Times font) |
|---|---|
| Bê tông móng đá 1x2 M250 | Beâ toâng moùng ñaù 1x2 M250 |
| Ván khuôn cột, vách | Vaùn khuoân coät, vaùch |
| Thép tròn D18 trở lên | Theùp troøn D18 trôû leân |
The raw characters look odd, but rendered with VNI-Times they read as correct Vietnamese.
Notes
- Formula cells are skipped entirely; only text values are re-encoded.
- The change cannot be undone with Ctrl+Z — save the workbook first when working on a real submission.
- The recipient's machine must have the VNI-Times font installed, otherwise the text displays incorrectly; mention the font requirement when you send the file.
- Once text is VNI, lookups and comparisons against Unicode data stop matching — convert as the last step, after all calculations are finished.
- With no range selected the add-in shows "Please select a data range." and does nothing.
Related
- To Unicode — bring legacy files up to Unicode for calculation and lookups.
- To TCVN3 — the other legacy encoding still common in older archives.
- Convert encoding — dialog version with a wider scope (whole sheet or workbook).
- Remove accents — when you need unaccented text rather than a different encoding.