Thank you for bringing this to my attention, and sending the example. I was not able to get the image to render correctly here in the United States on my edition of Excel. I studied your fix and it provided insight. My installation of Excel creates the .gv text file using ANSI encoding, so the Russian characters are already lost before the UTF-8 conversion you added.
I believe the way for me to fix this is to convert all "Print" statements to write to an ADODB.Stream object which will create a true UTF-8 file from inception. I believe such a change will allow the tool to render images correctly in both (any) countries. See this article for more information.
If the change works, I must also make the change in several other places such as the Style Designer, and Source worksheets. I am also considering adding the character set as a runtime option within the "Graph" list on the Graphviz ribbon. These changes will take a little time, but I hope to return an updated file to you soon.
Best regards,
Jeff
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Attached you will find a revised preadsheet which creates the DOT source file in UTF-8 format.
The change has been made throughout the tool. In the 'data' worksheet any UTF-8 text in a cell will be used in the DOT file created and sent to Graphviz. In the 'style designer' worksheet you may specify the sample label in non-western text. In the 'source' worksheet the Graphviz source is written to a UTF-8 encoded file when the save source button is used.
Please contact me again if you have any questions,
Jeff
Examples in the "samples" folder have been updated to the UTF-8 macro template as of 18-Jan-2020. The examples are in English but will display correctly if someone wants to translate them to another language.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Dmitry,
Thank you for bringing this to my attention, and sending the example. I was not able to get the image to render correctly here in the United States on my edition of Excel. I studied your fix and it provided insight. My installation of Excel creates the .gv text file using ANSI encoding, so the Russian characters are already lost before the UTF-8 conversion you added.
I believe the way for me to fix this is to convert all "Print" statements to write to an ADODB.Stream object which will create a true UTF-8 file from inception. I believe such a change will allow the tool to render images correctly in both (any) countries. See this article for more information.
https://stackoverflow.com/questions/2524703/save-text-file-utf-8-encoded-with-vba
If the change works, I must also make the change in several other places such as the Style Designer, and Source worksheets. I am also considering adding the character set as a runtime option within the "Graph" list on the Graphviz ribbon. These changes will take a little time, but I hope to return an updated file to you soon.
Best regards,
Jeff
Dmitry,
Attached you will find a revised preadsheet which creates the DOT source file in UTF-8 format.
The change has been made throughout the tool. In the 'data' worksheet any UTF-8 text in a cell will be used in the DOT file created and sent to Graphviz. In the 'style designer' worksheet you may specify the sample label in non-western text. In the 'source' worksheet the Graphviz source is written to a UTF-8 encoded file when the save source button is used.
Please contact me again if you have any questions,
Jeff
Fix was published on 05-Jan-2020, version 4.5.03.
Russian letters (Cyrillic) are displayed correctly (file Relationship Visualizer). Need to fix examples in the "samples" folder.
Examples in the "samples" folder have been updated to the UTF-8 macro template as of 18-Jan-2020. The examples are in English but will display correctly if someone wants to translate them to another language.