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.

Up

Parse Numerics

	Convert numbers stored as text to numeric format.

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

Up

Toggle Case

	Case switching for text values in selected cells according to the scheme: Abcde -> abcde -> ABCDE

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.

Up

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.

Unmerge Cells

	Unmerge cells and fill each cell of merge area with initial value.

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!

Copy as Markdown

	Contents of selected cells will be copied to clipboard in markdown format.

Validate values

Check the cell values in the selected range for a specific format. Supported format: - Number - Date - TIN of an individual* (12 digits, with two verification digits) - TIN of the legal entity* (10 digits, with one verification digit) - Text for XML (no < and > characters or other invalid characters for XML content) * - The correct TIN does not guarantee the existence of an organization or individual who would own this INN

Up

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 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:

<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

Up

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:

Up