Empty values at first position

[Semjasa]

hello,

we create a lot of charts and sometimes we have some strange constellations. we need the possibility to write a series with empty values ​​in the first position.
I have added a project file with different series that contain different series that can be written and that work but do not produce the expected result. And there are also series that cause an error in excel.

The project was created with SpireXLS version 10.10.6 on a Windows 10 machine.

Thanks
Thomas

[rachel.lei]

Hello,

Thanks for your inquiry.
When using the following two data sources, I did observe the behavior you mentioned. I have posted this issue to our Dev team with the ticket SPIREXLS-2902 for further investigation. If there is any update, we will inform you. Sorry for the inconvenience caused.

Code: Select all

            // Create Excel but show error inside
            var data = new[]
            {
                new object[]
                {
                    "#N/A",
                    100,
                    200,
                    300
                },
                new object[]
                {
                    20,
                    150,
                    250,
                    350
                },
            };

Code: Select all

            // Create Excel but create first value as 0 but should be empty
            var data = new[]
            {
                new object[]
                {
                    "",
                    100,
                    200,
                    300
                },
                new object[]
                {
                    20,
                    150,
                    250,
                    350
                },
            };

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Hope you are doing well.
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:10.11.7 that fixes the issue that the value "#N/A#" did not work properly. Please download it and refer to the code below for testing.
Website download link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget download link: https://www.nuget.org/packages/Spire.XLS/10.11.7

Code: Select all

            var data = new[]
            {
                new object[]
                {
                    "#N/A",
                    100,
                    200,
                    300
                },
                new object[]
                {
                    20,
                    150,
                    250,
                    350
                },
            };

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Hope you are doing well.
Has your issue been resolved? Any feedback will be greatly appreciated!

Sincerely,
Rachel
E-iceblue support team