Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet.

Thu Jul 12, 2018 8:07 am

Hey

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim Sheet As Spire.Spreadsheet.Forms.IWorksheet = Spreadsheet1.ActiveWorksheet
Dim ColRow As CellAdressInfo = Sheet.ActiveCellAdressInfo

If Sheet.Item(ColRow.Row, ColRow.Column).Protected = False Then
Sheet.Item(ColRow.Row, ColRow.Column).Value = "12345"
Sheet.Item(ColRow.Row, ColRow.Column).Style.BackgroundColor = System.Drawing.Color.Azure
End If
Spreadsheet1.Refresh()
End Sub

GH

GHWels
 
Posts: 75
Joined: Sun Nov 23, 2014 7:22 pm

Thu Jul 12, 2018 9:42 am

Dear GH,

Thanks for your inquiry.
I have noticed the issue and posted it to our Dev team. Once there is any news, we will let you know.
Sorry for the inconvenience.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 2638
Joined: Tue Sep 06, 2016 8:30 am

Fri Sep 07, 2018 10:00 am

Hey

Can you tell me, until when the problem is solved?

gh

GHWels
 
Posts: 75
Joined: Sun Nov 23, 2014 7:22 pm

Fri Sep 07, 2018 10:25 am

Dear GH,

I am afraid your reported issue is still not resolved at present. I have urged our Dev team to fix your issue ASAP, once there is any good news, we will let you know.
Sorry for the inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 2638
Joined: Tue Sep 06, 2016 8:30 am

Sun Nov 18, 2018 9:15 am

Sorry it's still not solved! :oops:

GHWels
 
Posts: 75
Joined: Sun Nov 23, 2014 7:22 pm

Mon Nov 19, 2018 1:53 am

Hi,

I have checked the status of the issue and sorry to tell that our dev team is still working on it.
Once it is fixed, I will notify you.
Apologize for the inconvenience caused!

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.Spreadsheet