Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon Jul 25, 2022 6:17 pm

Hello,
im working in a poc concept for apossible project and I have found some questions to resolve for recomended use of Soire XLS.

I have any questions:

1. Axis Right not working.
View sample in folder readme, ChartSheet.png. How can I draw the right Axis for have a grid similar to objective report (upload report_Objetive.png)

2. When export chart to image change the position of legend "elongation"??
View sample in folder readme, ChartSheet.png in project in shared site url:
https://drive.google.com/file/d/1vtt2Qn ... sp=sharing

3. Axis "X", is possible set minvalue and MAX value similar to eje "Y"? In horizontal axis, I can min and max value.

4. Axis "X", is possible set frequency Label in 10,2o,30,...

5. When save chart to image, not export minor vertical gridlines.
View sample in folder readme, ChartSheet.png in project in shared site url:

6. In folder Readme, threis an example of obetive reprt to generate/devlope. IS there any limitations or problems to gnerate theis report with library Soire XLS and export to Image the chart? ¿IS posible?

The complete project is in public url

https://drive.google.com/file/d/1vtt2Qn ... sp=sharing



Thanks.
Attachments
report_Objetive.png
report_Objetive.png (451.68 KiB) Viewed 530 times

E.PTENA@LKS.ES
 
Posts: 8
Joined: Fri Nov 21, 2014 10:40 am

Tue Jul 26, 2022 10:58 am

Hi,

Thank you for your inquiry. Here is my answers to your questions.
1. Please refer to the code below to achieve the effect you want. If there is any misunderstanding, please provide more detailed explanation.
Code: Select all
chart.PlotArea.LineProperties.Color = Color.Black;

2. I reproduced your problem and logged it into our bug tracking system with ticket SPIREXLS-4019. Our dev team will investigate this issue, once there is any good news, I will inform you. Apologize for the inconvenience.
3. Please note that our Spire.XLS is based on Microsoft Excel document specifications, the X-axis is determined according to the data you give, so the maximum and minimum values cannot be set.
4. The TickLabelSpacing method represents the number of categories or series between tick-mark labels. So you can only change the data source of chart as 10, 20....to achieve your needs.
5. Do you want to save the picture without vertical grid lines? If so, please comment out this line( chart.PrimaryCategoryAxis.HasMajorGridLines = true;) in your code.
6. There is no limitation on saving Chart as Image using Spire.XLS.

Sincerely,
Kylie
E-iceblue support team
User avatar

kylie.tian
 
Posts: 412
Joined: Mon Mar 07, 2022 2:30 am

Wed Aug 17, 2022 10:42 am

Hi,

Glad to inform that we just released Spire.Office Platinum(Hotfix) Version:7.8.4 which fixed SPIREXLS-4019, you can download it from the following links to test.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.Office/7.8.4

Sincerely,
Kylie
E-iceblue support team
User avatar

kylie.tian
 
Posts: 412
Joined: Mon Mar 07, 2022 2:30 am

Return to Spire.XLS