ExcelExporter issue: chart legend wrong - Grid and Spreadsheet Components - Windows Forms

(UTC)

MindFusion Forums › Grid and Spreadsheet Components › Windows Forms › ExcelExporter issue: chart legend wrong

(Moderator: Iva_P)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Normal Topic

ExcelExporter issue: chart legend wrong (Read 2363 times)

Bernard YaBB Newbies Offline I Love MindFusion! Posts: 4 Joined: Oct 9^th, 2024	ExcelExporter issue: chart legend wrong Nov 7^th, 2024 at 8:19am	Print Post
	Hi, I create my chart in Winform and it looks good(see picture 1). But after ExcelExporter, chart legend different(see picture 2). Then i ask my boss to buy Winform licence for me and test it again, nothing change. Can you tell me how to solve this issue? (Win 10, excel 2007, visual studio 2022)

	pic.zip ( 112 KB \| 86 Downloads )
	IP Logged

Slavcho God Member Offline tech.support Posts: 3419 Joined: Oct 19^th, 2005	Re: ExcelExporter issue: chart legend wrong Reply #1 - Nov 7^th, 2024 at 9:15am	Print Post
	Hi, Our developer will investigate. Could you also attach the spreadsheet file as saved by the control (e.g. Workbook.SaveToXml method)? Regards, Slavcho Mindfusion


	IP Logged

Slavcho God Member Offline tech.support Posts: 3419 Joined: Oct 19^th, 2005	Re: ExcelExporter issue: chart legend wrong Reply #2 - Nov 7^th, 2024 at 12:25pm	Print Post
	Hi, It should export as expected if the Series.Name starts with "=" formula symbol: We've now noticed that the Insert Chart command from demo project does not add it automatically. Regards, Slavcho Mindfusion


	IP Logged

Bernard YaBB Newbies Offline I Love MindFusion! Posts: 4 Joined: Oct 9^th, 2024	Re: ExcelExporter issue: chart legend wrong Reply #3 - Nov 8^th, 2024 at 12:40am	Print Post
	Slavcho wrote on Nov 7^th, 2024 at 9:15am: Hi, Our developer will investigate. Could you also attach the spreadsheet file as saved by the control (e.g. Workbook.SaveToXml method)? Regards, Slavcho Mindfusion

	XML_20241108083555.xml ( 324 KB \| 82 Downloads )
	IP Logged

Slavcho God Member Offline tech.support Posts: 3419 Joined: Oct 19^th, 2005	Re: ExcelExporter issue: chart legend wrong Reply #4 - Nov 8^th, 2024 at 6:13am	Print Post
	The XML shows <name>Data!$E$1</name>. As per my second post above, change the Series.Name property to start with "=" symbol and it should export as expected, e.g. Series.Name = "=Data!$E$1"; Regards, Slavcho Mindfusion


	IP Logged

Page Index Toggle

Pages: 1

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

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

Valid XHTML

Valid CSS

Powered by Perl

Source Forge