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 Jan 25, 2021 3:49 pm

In both versions 10.1 and 10.10 of FreeSpire.XLS the methods
Code: Select all
chart.PlotArea.ForeGroundColor
to indicate the color of the plotting area and
Code: Select all
chart.PrimaryCategoryAxis.HasMajorGridLines = true
to show the vertical lines do not work.

Best regards

blastdoman
 
Posts: 27
Joined: Thu Jul 02, 2020 7:06 am

Tue Jan 26, 2021 4:03 am

Hello,

Thanks for your inquiry!

Please refer to the following code to indicate the color of the plotting area and show the vertical lines.

Code: Select all
            //indicate the color of the plotting area
            chart.PlotArea.Fill.FillType = ShapeFillType.SolidColor;
            chart.PlotArea.ForeGroundColor = Color.Green;

            //show the vertical lines.
            chart.PrimaryValueAxis.HasMajorGridLines = true;


If the issue still exists, please provide us with your input file for further investigation. Thanks in advance.

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Tue Jan 26, 2021 8:10 am

Marcia.Zhou wrote:Hello,

Thanks for your inquiry!

Please refer to the following code to indicate the color of the plotting area and show the vertical lines.

Code: Select all
            //indicate the color of the plotting area
            chart.PlotArea.Fill.FillType = ShapeFillType.SolidColor;
            chart.PlotArea.ForeGroundColor = Color.Green;

            //show the vertical lines.
            chart.PrimaryValueAxis.HasMajorGridLines = true;


If the issue still exists, please provide us with your input file for further investigation. Thanks in advance.

Sincerely,
Marcia
E-iceblue support team

Thank you for your response, Marcia.

With what you have advised me I have managed to change the background color of the plotting area. So, this issue is fixed.

As for the vertical lines, I still have the problem. What you have answered me is for the horizontal lines. Debugging I noticed that after executing the line of code
Code: Select all
chart.PrimaryCategoryAxis.HasMajorGridLines = true;
this property remains false. How can this be possible? Moreover, out of curiosity I have tried to change to false this property for the horizontal lines and then I can not put it back to True. It is as if at the moment that it is False, they cannot be changed to True.

With the FreeSpire.Office version this does not happen, but I need it to work with the FreeSpire.XLS version.

Thank you.

blastdoman
 
Posts: 27
Joined: Thu Jul 02, 2020 7:06 am

Tue Jan 26, 2021 10:52 am

Hello,

Thanks for your feedback!

I will do more investigation about the issue. Once the issue has any progress, I will inform you ASAP.

Thanks for your patience and cooperation.

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Wed Jan 27, 2021 6:50 am

Hello,

Thanks for your patience!

I have reproduced your issue and logged it in our issue tracking system with the ticket SPIREXLS-3085 for further investigation.

We will let you know if there is any update. Sorry for the inconvenience caused.

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Tue Feb 23, 2021 9:20 am

Hello,

Thanks for your patience.

Glad to inform that we just released Spire.XLS Pack(Hotfix) Version:11.2.6 which fixed the issue SPIREXLS-3085, please 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.XLS/11.2.6

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Mon Mar 22, 2021 7:52 am

Hello,

Hope you are doing well!

Has the issue been solved now? Could you please give us some feedback at your convenience?

Thanks in advance.

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Tue Mar 30, 2021 9:24 am

Marcia.Zhou wrote:Hello,

Hope you are doing well!

Has the issue been solved now? Could you please give us some feedback at your convenience?

Thanks in advance.

Sincerely,
Marcia
E-iceblue support team


Hi Marcia.

Sorry for the delay in replying but I have been off on this issue.

I have tested it and the problem is solved.

Thank you very much.

blastdoman
 
Posts: 27
Joined: Thu Jul 02, 2020 7:06 am

Tue Mar 30, 2021 9:48 am

Hello,

You are welcome, and thanks for your feedback!

Glad to hear that your issue has been solved.

If you encounter any issues related to our product in the future, just feel free to contact us.

Have a nice day!

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Return to Spire.XLS