The MindFusion Forums - Export excel

(UTC)

The MindFusion Forums › Flow Diagramming Components › Windows Forms › Export excel

(Moderator: Slavcho)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Hot Topic (More than 10 Replies)

Export excel (Read 4012 times)

jlagniez YaBB Newbies Offline I Love MindFusion! Posts: 12 Joined: Feb 15^th, 2022	Export excel Feb 15^th, 2022 at 1:29pm	Print Post
	Hi, I am new in the forum. I would need an opinion on an export problem in excel with mindfusion. First, I upgraded from .Net Framework 3.5.0 to .Net Framework 4.6.2 in order to use mindfusion version 6.7. I can now export my diagram in excel but I have a problem: - The labels are not displayed on my links on excel I added images to illustrate the problem. I also wanted to thank you for adding the excel export! It's a great feature

	mindfusion_pb.PNG ( 22 KB \| 93 Downloads )
	IP Logged

Slavcho YaBB Moderator Offline tech.support Posts: 3171 Joined: Oct 19^th, 2005	Re: Export excel Reply #1 - Feb 15^th, 2022 at 2:09pm	Print Post
	Hi, I think that's because Excel's connector shapes do not support text, or at least they did not when our developers created this exporter some years ago. Let us know if you are seeing a way to set connector's text in latest Excel UI. At this time, you could try adding some temporary nodes on top of links before exporting, to serve as labels in the Excel diagram. Regards, Slavcho Mindfusion


	IP Logged

jlagniez YaBB Newbies Offline I Love MindFusion! Posts: 12 Joined: Feb 15^th, 2022	Re: Export excel Reply #2 - Feb 15^th, 2022 at 3:17pm	Print Post
	Hi, Thanks, yes that's a good idea, I'll give it a try. I just tested and yes, you can't put a label on the connectors, it's also bad


	IP Logged

jlagniez YaBB Newbies Offline I Love MindFusion! Posts: 12 Joined: Feb 15^th, 2022	Re: Export excel Reply #3 - Feb 21^st, 2022 at 1:58pm	Print Post
	Hi, We made the decision to split the connector into two connectors and add a shape with the value of the connector. This works. Thanks for the idea There are still two problems that we cannot solve: - Link size is not exported. We do newLink1.Pen.Width = 20 - The connector is not attached to the form. When I move the shape, the connector attaches correctly to the shape. I added images to illustrate the problem. Regards, Jean-Marc

	Before_moving_after_moving.PNG ( 13 KB \| 98 Downloads )
	IP Logged

Slavcho YaBB Moderator Offline tech.support Posts: 3171 Joined: Oct 19^th, 2005	Re: Export excel Reply #4 - Feb 22^nd, 2022 at 9:37am	Print Post
	Hi, Try this build, it applies stroke width attribute to link shapes - https://mindfusion.eu/_temp/diaglinks_excel.zip We can't find any way to set exact control point coordinates in Excel, but can only specify connector's bounding rectangle. Our developer has adjusted that code to create more precise end points at least. Regards, Slavcho Mindfusion


	IP Logged

jlagniez YaBB Newbies Offline I Love MindFusion! Posts: 12 Joined: Feb 15^th, 2022	Re: Export excel Reply #5 - Feb 22^nd, 2022 at 11:11am	Print Post
	hi, This version does not work no, could it come from me with an error not visible? I understand ! It's a bad because there is "redirect the connector" on excel. We used the LayeredLayout algorithm before the export. It's not perfect but it's a little better. (the LayeredLayout algorithm is really good ) Regards, Jean-Marc


	IP Logged

Slavcho YaBB Moderator Offline tech.support Posts: 3171 Joined: Oct 19^th, 2005	Re: Export excel Reply #6 - Feb 22^nd, 2022 at 12:25pm	Print Post
	Hi, Please attach a saved diagram with which it's not working. Regards, Slavcho


	IP Logged

jlagniez YaBB Newbies Offline I Love MindFusion! Posts: 12 Joined: Feb 15^th, 2022	Re: Export excel Reply #7 - Feb 22^nd, 2022 at 1:04pm	Print Post
	hi, Diagram.SaveToFile(name), is it ok? I add it as an attachment Regards, Jean-Marc

	saveToFile ( 20 KB \| 104 Downloads )
	IP Logged

Slavcho YaBB Moderator Offline tech.support Posts: 3171 Joined: Oct 19^th, 2005	Re: Export excel Reply #8 - Feb 22^nd, 2022 at 2:52pm	Print Post
	Hi, What's not working exactly? Link widths and end points from your file look correct on our end with last build. We can't find a way to add intermediate points to Excel connectors, so bends from LayeredLayout won't be visible in Excel. You might try using layouts that create straight lines only, so appearance is preserved in exported xlsx too - e.g. SpringLayout or AnnealLayout. Regards, Slavcho


	IP Logged

jlagniez YaBB Newbies Offline I Love MindFusion! Posts: 12 Joined: Feb 15^th, 2022	Re: Export excel Reply #9 - Feb 23^rd, 2022 at 8:12am	Print Post
	hi, Ok, on my side, I don't have a different width on the excel connectors. I add an image Regards, Jean-Marc

	width.PNG ( 54 KB \| 95 Downloads )
	IP Logged

jlagniez YaBB Newbies Offline I Love MindFusion! Posts: 12 Joined: Feb 15^th, 2022	Re: Export excel Reply #10 - Feb 23^rd, 2022 at 8:19am	Print Post
	We also noticed that the more we increased the value of link.Pen.width, the more the connectors on excel were buggy. Regards, Jean-Marc

	left_widht_0_right_width_15.PNG ( 49 KB \| 90 Downloads )
	IP Logged

Slavcho YaBB Moderator Offline tech.support Posts: 3171 Joined: Oct 19^th, 2005	Re: Export excel Reply #11 - Feb 23^rd, 2022 at 9:00am	Print Post
	Your project is still loading the old assemblies then. Please check if 'use specific version' property isn't set for references/Mindfusion*, and their path is the one where you unzipped patched dlls. Regards, Slavcho


	IP Logged

jlagniez YaBB Newbies Offline I Love MindFusion! Posts: 12 Joined: Feb 15^th, 2022	Re: Export excel Reply #12 - Feb 23^rd, 2022 at 9:38am	Print Post
	Yes ! That's right ! Everything is perfect ! Thanks very much. Regards, Jean-Marc


	IP Logged

Page Index Toggle

Pages: 1

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

The MindFusion Forums » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge