Checkbox bug

[ducphu]

This is my code

Code: Select all

Dim cb1 As Core.ICheckBox = sheet.CheckBoxes.AddCheckBox(50, 7, 30, 30)
                cb1.CheckState = CheckState.Unchecked
                cb1.Text = ""

                Dim cb2 As Core.ICheckBox = sheet.CheckBoxes.AddCheckBox(50, 8, 35, 35)
                cb2.CheckState = CheckState.Unchecked
                cb2.Text = ""

                Dim cb3 As Core.ICheckBox = sheet.CheckBoxes.AddCheckBox(50, 9, 40, 40)
                cb3.CheckState = CheckState.Unchecked
                cb3.Text = ""

                Dim cb4 As Core.ICheckBox = sheet.CheckBoxes.AddCheckBox(50, 10, 45, 45)
                cb4.CheckState = CheckState.Unchecked
                cb4.Text = ""

I supposed to see 4 checkboxes at row 50, column 7, 8, 9 and 10. However, what I got is 4 checkboxes at row 50 and column 1 (column A), overlaying each other. See attached photos. I'm using Net 3.5 and excel 2019

[Lisa.Li]

Hello,

Thanks for your letter.
I tested your case with our latest Spire.XLS Pack(Hotfix) Version:9.6.1 and opened the generated excel file in MS Excel 2013, 2016 and WPS 2019, but I didn't reproduce your issue. I attached my generated file and the screenshot when opening in MS Excel 2013 for your reference. Please help to firstly open my generated file in your MS Excel 2019 to verify if this issue only occurs in MS Excel 2019. If it could display correctly, I suggest you try again with the latest version. Look forward to your further reply.

Sincerely,
Lisa
E-iceblue support team

[Lisa.Li]

Hello,

Greetings from E-iceblue.
How is your issue going? Did the latest version work for you? Thanks in advance for your valuable feedback and time.

Sincerely,
Lisa
E-iceblue support team

[ducphu]

1. I opened your file and it displays correctly with excel 2019
2. I'm using the free version of Spire.XLS and my version is 9.2.12.61035
3. Can you try on the file I attached? I need to have checkboxes for each cell from G26 to J50

[Lisa.Li]

Hello,

Thanks for your feedback.
Using our Free Spire.XLS for .NET Version:9.2 (Spire.XLS.dll: 9.2.2.61035), I still didn't reproduce your issue. Here, I uploaded my testing application which I tested with your sample Excel file and added CheckBoxes for each cell from G26 to J50. Please run it directly. If the issue still occurs, please share us with your system information (E.g. Win7, 64 bit) and region setting (E.g. China, Chinese) to help further investigate it. Look forward to your further feedback.

Sincerely,
Lisa
E-iceblue support team

[ducphu]

1. I run your code and the output is correct
2. I attached the code that I use to generate the file. Can you help to see if anything is wrong with it?
3. My system: Win10 64bit, MS Office 2019 64bit, Region Singapore/English. I'm using Microsoft Visual Studio 2008

[Lisa.Li]

Hello,

Thanks for your quick response.
Since your program code has many defined variables by yourself, sorry it's hard to check if anything is wrong with it. Could you please provide your runnable application to help us look into it accurately? You can upload your application to DropBox or OneDrive and then share us with the download link via email (support@e-iceblue.com). Thanks in advance.

Sincerely,
Lisa
E-iceblue support team