Guido, Thank you for the compliment. I am pleased that you find this spreadsheet useful. My apologies for the delay in replying. I only saw your posting yesterday (11-Sep-2021). I receive notifications if someone enters a ticket, but not if someone creates a Discussion topic, so I was unaware of your request. I have made the change you requested, and you can download the updated zip file. The enhancement will appear beginning in the file which has Version 5.3.02 and date 11-September-2021 in the...
I found this software an exceptional tool to help visualize complex graphs with many relationships. But I am not administrator of the PC in use. Can you please add configuration of path to the installed Graphviz files, inside the excel file? As said in current PC I do not have privileges to install the Graphviz package, I only can unzip files in a directory and I do not have also privileges to modify the path of the PC. A configuration inside the excel file to let the routine point to the- Graphviz...
Any plan to support "Excel to Graphviz" in mac os x ?
Porting is complete. Version 5.0 released on 2020-12-31 contains the Mac support. V5.0 provides one spreadsheet which works on either Windows and Mac. In addition, the documentation has been brought current, with dedicated manuals for Windows and Mac. Note that the installation steps are different by OS due to Mac sandbox requirements.
Many thanks Jeffrey! I couldnt find a way to modify the western font but the JSON file made it as best example! now JSON is the file for ongoing work :-)
It is quite simple. You must specify the fontname attribute with the name of the font to use. I believe that Graphviz's default font is "Times Roman". In Excel the font may appear as Chinese, but the font used in an Excel cell is not passed to Graphviz. It is up to the user to specify the font to Graphviz. There are multiple ways you can specify a fontname 1. Design a style using the 'Style Designer' worksheet, save it, and applying it where desired. 2. Use the "Extra Attributes" column to specify...
how to graphviz in chinese characters?
Closing ticket, not a defect. The font name must be specified in the data to override Graphviz's default western font.
It is quite simple. You must specify the fontname attribute with the name of the font to use. I believe that Graphviz's default font is "Times Roman". In Excel the font may appear as Chinese, but the font used in an Excel cell is not passed to Graphviz. It is up to the user to specify the font to Graphviz. There are multiple ways you can specify a fontname 1. Design a style using the 'Style Designer' worksheet, save it, and applying it where desired. 1. Use the "Extra Attributes" column to specify...
how to graphviz in chinese characters?
Any plan to support "Excel to Graphviz" in mac os x ?
Work to port "Excel to Graphviz" to run under Mac OS X has started. Anticipated release is summer 2020. Ability to invoke Graphviz within Excel on Mac OS X is resolved, and a solution has been created to address the font list. Excel on Mac OS X is sand boxed, and these restrictions have also been addressed. What I never anticipated was the amount of work needed to fix the ribbon controls . Ribbon support differs between Windows and Mac OS X, and cross-platform compromises needed to be created. Most...
Request support for splines="true"
Thank you for the compliment. I don't receive much feedback on this tool, and often wonder if anyone uses it. Your note is very encouraging. I have added the option you requested, and a little more. The distribution is available for download. The version number is 4.7.14 in the "about..." worksheet. I added the values '', 'true', 'false', and 'compound' to the Splines dropdown list. If you choose the '' entry then the spline attribute is omitted from the DOT file and the rendering of the edges uses...
Request support for splines="true"
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.
Russian letters (Cyrillic) are displayed correctly (file Relationship Visualizer). Need to fix examples in the "samples" folder.
file is not created in utf-8
Fix was published on 05-Jan-2020, version 4.5.03.
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...
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...
file is not created in utf-8
Prevent Picture Count from incrementing on "graph to worksheet"
Prevent Picture Count from incrementing on "graph to worksheet"
I learn something new all the time with this tool. To be honest, I never noticed it was assigning a name to the graph, let alone incrementing a counter. Your request was an easy change. I added a new configuration setting where you can assign a static name to the picture created from the graph file when the graph is pulled into the workbook. The new setting is on the 'settings' worksheet in the "Graph Options" area. it is the 4th setting with the name "Graph to Worksheet" Picture Name:. If you leave...
Prevent Picture Count from incrementing on "graph to worksheet"
Chenda, You are the second person to ask me this question within the last few days. At the moment I do not have plans to support "Excel to Graphviz" under Mac OS X for a few reasons. 1. There is open-source code included in "Excel to Graphviz" called "ShellAndWait" which is used as an invisible command line prompt to invoke the Graphviz executable to render the graph. It is very Microsoft Windows specific code, and a suitable replacement which would run under OS X would need to be identified. 2....
Any plan to support "Excel to Graphviz" in mac os x ?
Conversion to x64 Architecture
The zip file published on 2017-02-05 contains the requested change to add the "ptrsafe"...
The "PtrSafe" change has been made to the Excel Macro-enabled Template (xltm) file...
Fantastic! Thanks for the prompt reply! I think this a great tool, given that Graphviz...