(UTC)
  The MindFusion Forums › Grid and Spreadsheet Components › Windows Forms › ExcelExporter issue: chart legend wrong
(Moderator: Iva_P)
‹ No Topic | Next Topic ›
Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic ExcelExporter issue: chart legend wrong (Read 1088 times)
Bernard
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 4
Joined: Oct 9th, 2024
ExcelExporter issue: chart legend wrong
Nov 7th, 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 | 23 Downloads )
Back to top
 
IP Logged
 
Slavcho
God Member
*****
Offline


tech.support

Posts: 3357
Joined: Oct 19th, 2005
Re: ExcelExporter issue: chart legend wrong
Reply #1 - Nov 7th, 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
  
Back to top
 
IP Logged
 
Slavcho
God Member
*****
Offline


tech.support

Posts: 3357
Joined: Oct 19th, 2005
Re: ExcelExporter issue: chart legend wrong
Reply #2 - Nov 7th, 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
  
Back to top
 
IP Logged
 
Bernard
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 4
Joined: Oct 9th, 2024
Re: ExcelExporter issue: chart legend wrong
Reply #3 - Nov 8th, 2024 at 12:40am
Print Post  
Slavcho wrote on Nov 7th, 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 | 26 Downloads )
Back to top
 
IP Logged
 
Slavcho
God Member
*****
Offline


tech.support

Posts: 3357
Joined: Oct 19th, 2005
Re: ExcelExporter issue: chart legend wrong
Reply #4 - Nov 8th, 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
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint
‹ No Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

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

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge