NavfertyExcelAddIn Save Abandoned
Common tools for MS Excel
Project README
Russian | 
English
Navferty's Excel Add-In
Available features
- Undo Last Action
- Parse Numerics
- Replace Chars (Transliteration or analogues)
- Stringify Numerics to Words
- Toggle Case
- Trim Spaces
- Remove File Protection
- Worksheets Protection
- Highlight Duplicates
- Unmerge Cells
- Find Formula Errors in the selected range
- Copy as Markdown
- Validate Values
- Create Sample XML based on XSD
- Validate XML with XSD
How to install
Undo Last Action
 |
Undo the last action performed with this add-in. Canceling is possible for some functions in the 'Converting values' and 'Formatting values' sections, and only if the range of cells was not edited after the action was performed. |
Parse Numerics
 |
Convert numbers stored as text to numeric format. |
View screenshots
Replace
 |
Replace Russian characters in the match table. |
-
Transliteration
The entire Russian alphabet is completely changed to English. For example, the letter "Ж" will be replaced with "Zh", and the letter "Щ" with "Shch". Based on ICAO Doc 9303. View screenshots
-
Replace Chars
Only uppercase letters of the alphabets will be replaced, such as: Аа, Вв, Ее, Кк, Мм, Нн, Оо, Рр, Сс, Тт, Уу, Хх. View screenshots
Stringify Numerics into Words
 |
Rewrites numeric values in the text with the decryption - In Russian - In English - In French |
View screenshots
Toggle Case
 |
Case switching for text values in selected cells according to the scheme:Abcde -> abcde -> ABCDE |
View screenshots
Trim Spaces
 |
Clear the text content of the selected cells from unnecessary spaces. Removes repeated spaces and line breaks, as well as beginning and ending spaces in cells that have a text format. |
View screenshots
Remove File Protection
 |
Allows you to unprotect all the pages of an open book as the entire book, no password, and also unlock VBA project (if any) to which the password is set. This feature does not apply to encrypted books. |
Worksheets Protection
|
Allows you to set protection on multiple worksheets at once. |
Highlight duplications
 |
Sets the color of cells that contain duplicate values in the selected range. Different colors correspond to different groups of duplicates. |
View a screenshot
Unmerge Cells
 |
Unmerge cells and fill each cell of merge area with initial value. |
View screenshots
Find all cells containing errors
 |
Search for all cells in the selected cells that contain calculation errors: Excel formula errors types: #N/A#NAME?#DIV/0!#REF!#VALUE!#NUM!#NULL! |
View a screenshot
Copy as Markdown
|
Contents of selected cells will be copied to clipboard in markdown format. |
View a screenshot
Validate values
 |
Check the cell values in the selected range for a specific format. |
View a screenshot
Create Sample XML based on XSD
 |
Select file with an XSD schema and create a sampe XML based on that schema. |
For example, for the diagram below
XML schema sample - `sample.xsd`
<?xml version="1.0" encoding="UTF-8" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="shiporder">
<xs:complexType>
<xs:sequence>
<xs:element name="orderperson" type="xs:string"/>
<xs:element name="shipto">
<xs:complexType>
<xs:sequence>
<xs:element name="name" type="xs:string"/>
<xs:element name="address" type="xs:string"/>
<xs:element name="city" type="xs:string"/>
<xs:element name="country" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="item" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="title" type="xs:string"/>
<xs:element name="note" type="xs:string" minOccurs="0"/>
<xs:element name="quantity" type="xs:positiveInteger"/>
<xs:element name="price" type="xs:decimal"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="orderid" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:schema>
The following xml-file will be generated:
XML output - `sample.xml`
<shiporder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" orderid="orderid1">
<orderperson>orderperson1</orderperson>
<shipto>
<name>name1</name>
<address>address1</address>
<city>city1</city>
<country>country1</country>
</shipto>
<item>
<title>title1</title>
<note>note1</note>
<quantity>1</quantity>
<price>1</price>
</item>
<item>
<title>title2</title>
<note>note2</note>
<quantity>79228162514264337593543950335</quantity>
<price>-79228162514264337593543950335</price>
</item>
<item>
<title>title3</title>
<note>note3</note>
<quantity>2</quantity>
<price>79228162514264337593543950335</price>
</item>
<item>
<title>title4</title>
<note>note4</note>
<quantity>79228162514264337593543950334</quantity>
<price>0.9</price>
</item>
<item>
<title>title5</title>
<note>note5</note>
<quantity>3</quantity>
<price>1.1</price>
</item>
</shiporder>
Validate XML with XSD
 |
Check XML file with XSD schema. Select xml and xsd files, and report with all validation errors and warnings will be created in new workbook. |
Sample error report
| Severity | Element | Message |
|---|---|---|
| Error | city | The element 'shipto' has invalid child element 'city'. List of possible elements expected: 'address'. |
| Error | quantity | The 'quantity' element is invalid - The value '-5' is invalid according to its datatype 'http://www.w3.org/2001/XMLSchema:positiveInteger' - Value '-5' was either too large or too small for PositiveInteger. |
| Error | price | The 'price' element is invalid - The value 'asdasd' is invalid according to its datatype 'http://www.w3.org/2001/XMLSchema:decimal' - The string 'не число' is not a valid Decimal value. |
How to Install the Add-In
Online Install
You can install the add-in from official website of the project: navferty.ru. Just download and run the setup.exe file.
You may need to manually import the self-signed certificate before the installation process can be finished.
The installation process also requires internet connection to load latest version.
Offline Install
The solution is build in Azure, you can download full archive with installation files from there:
-
Visit https://navferty.visualstudio.com/NavfertyExcelAddIn/_build?definitionId=3
-
Select latest build of 'NavfertyExcelAddIn - Publish' pipeline:
- Download published installation files:
- Extract files to a folder and run '.vsto' file:
Using desktop folder is highly recommended - installing updates is permitted only from the same folder where it was installed for the first time!
After installation process is completed, run (or restart) Excel application, and you will see new tab:
Open Source Agenda is not affiliated with "NavfertyExcelAddIn" Project. README Source: navferty/NavfertyExcelAddIn
Open Source Agenda Badge
