Update only cell, after insert value

[GHWels]

Hey
I want to update only the cell after set value to actual date

spreadsheet1.LoadFromFile(Datei)
dim Sheet As Spire.Spreadsheet.Forms.IWorksheet = spreadsheet1.ActiveWorksheet
Dim ColRow As CellAdressInfo = Sheet.ActiveCellAdressInfo
Sheet.Item(ColRow.Row, ColRow.Column).SetCellValue(Format(Now, "HH:mm"))
'spreadsheet1.Refresh()

the problem is if I use 'spreadsheet1.Refresh() the spreasheetviewer scrolls to the first row.

thank you GH

[Lisa.Li]

Hello,

Thank you for contacting us.
Kindly note that the default active cell is the first cell when opening an Excel file with Spire.Spreadsheet. You could refer to below code to change the active cell and update it. If there is any question, just feel free to write back.

Code: Select all

Private Sub OpenFile_Click(sender As Object, e As EventArgs) Handles Button1.Click
    Spreadsheet1.LoadFromFile("test.xlsx")
End Sub

Private Sub updateTimw_Click(sender As Object, e As EventArgs) Handles Button2.Click
    Dim sheet As Spire.Spreadsheet.Forms.IWorksheet = Spreadsheet1.ActiveWorksheet
    Dim ColRow As CellAdressInfo = sheet.ActiveCellAdressInfo
    sheet.Item(ColRow.Row, ColRow.Column).SetCellValue(Format(Now, "HH:mm"))
    Spreadsheet1.Refresh()
End Sub


Sincerely,
Lisa
E-iceblue support team

[GHWels]

Sorry I solved the problem!

Only "Spreadsheet1.Refresh()" scolls the Sheet to the TOP.
With "Sheet.SetActiveCell(ColRow)" I jump back to the CELL

Private Sub updateTimw_Click(sender As Object, e As EventArgs) Handles Button2.Click
Dim sheet As Spire.Spreadsheet.Forms.IWorksheet = Spreadsheet1.ActiveWorksheet
Dim ColRow As CellAdressInfo = sheet.ActiveCellAdressInfo
sheet.Item(ColRow.Row, ColRow.Column).SetCellValue(Format(Now, "HH:mm"))
Spreadsheet1.Refresh()
Sheet.SetActiveCell(ColRow)
End Sub

Thank you
GH

[Lisa.Li]

Dear,

Thanks for quick response.
Glad to hear that you resolved the issue. Any question, just feel free to contact us.
Wish you all the best!

Sincerely,
Lisa
E-iceblue support team