Russian | English
Navferty's Excel Add-In
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](images/ParseNumerics1.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/ParseNumerics2.png)
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](images/Transliterate1.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/Transliterate2.png)
-
Replace Chars
|
|
Only uppercase letters of the alphabets will be replaced, such as: Аа, Вв, Ее, Кк, Мм, Нн, Оо, Рр, Сс, Тт, Уу, Хх. |
View screenshots
![Navferty's Tools Ribbon Tab in MS Excel](images/ReplaceChars1.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/ReplaceChars2.png)
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](images/Stringify1.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/Stringify2.png)
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](images/ToggleCase1.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/ToggleCase2.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/ToggleCase3.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/ToggleCase4.png)
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](images/TrimSpaces1.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/TrimSpaces2.png)
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](images/Duplicates.png)
Unmerge Cells
|
|
Unmerge cells and fill each cell of merge area with initial value. |
View screenshots
![Navferty's Tools Ribbon Tab in MS Excel](images/Unmerge1.png)
![Navferty's Tools Ribbon Tab in MS Excel](images/Unmerge2.png)
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](images/FindErrorValues.png)
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](images/ExportToMarkdown.png)
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](images/Validate.png)
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
```
The following xml-file will be generated:
XML output - `sample.xml`
```XML
orderperson1
name1
address1
city1
country1
-
title1
note1
1
1
-
title2
note2
79228162514264337593543950335
-79228162514264337593543950335
-
title3
note3
2
79228162514264337593543950335
-
title4
note4
79228162514264337593543950334
0.9
-
title5
note5
3
1.1
```
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:
- 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