Skip to content

navferty/NavfertyExcelAddIn

Repository files navigation

Russian | English

Navferty's Excel Add-In

Navferty's Tools Ribbon Tab in MS Excel

Available features


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.
View screenshots

Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel

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

    Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel

  • Replace Chars

    Only uppercase letters of the alphabets will be replaced, such as: Аа, Вв, Ее, Кк, Мм, Нн, Оо, Рр, Сс, Тт, Уу, Хх.
    View screenshots

    Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel

Stringify Numerics into Words

Rewrites numeric values in the text with the decryption
- In Russian
- In English
- In French
View screenshots

Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel

Up


Toggle Case

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

Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel

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

Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel

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.
View a screenshot

Navferty's Tools Ribbon Tab in MS Excel

Unmerge Cells

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

Navferty's Tools Ribbon Tab in MS Excel Navferty's Tools Ribbon Tab in MS Excel

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

Navferty's Tools Ribbon Tab in MS Excel

Copy as Markdown

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

Navferty's Tools Ribbon Tab in MS Excel

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

View a screenshot

Navferty's Tools Ribbon Tab in MS Excel

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

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:

Navferty's Tools Ribbon Tab in MS Excel

  • Download published installation files:

Navferty's Tools Ribbon Tab in MS Excel

  • 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!

Navferty's Tools Ribbon Tab in MS Excel

After installation process is completed, run (or restart) Excel application, and you will see new tab:

Navferty's Tools Ribbon Tab in MS Excel

Up

About

Common tools for MS Excel

Topics

Resources

License

Code of conduct

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published