check if spreadsheet has changed

[GHWels]

Hey,

is it possibel to check if spreadsheet has changed?

GH

[Mike.Zhang]

Hi,

Thanks for you inquiry.
Kindly note that Spire.Spreadsheet has an event to check if the sheet has changed. Please refer to below code.

Code: Select all

    Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load
        AddHandler Me.Spreadsheet1.ActiveSheetChanged, AddressOf spreadsheet1_ActiveSheetChanged
    End Sub
    Private Sub spreadsheet1_ActiveSheetChanged(ByVal sender As Object, ByVal args As EventArgs)
        MessageBox.Show("sheet changed!!!")
    End Sub

If you mean checking if the file has been changed, sorry there is no such method in Spire.Spreadsheet.

[GHWels]

Thank you for your fast help.
GH

[Mike.Zhang]

Hi,

It's my pleasure.
Any question, just feel free to contact us.

[ronaldhaish]

Hello

When I open the visualizer in Sunlite it appears the message attention - the patch has changed.

Whats this?

Thanks
Leo

[Nina.Tang]

Hi Leo,

Thank you for contacting us.
Did you encounter error behavior when using our Spire.Spreadsheet? Sorry I'm not clear about your issue, could you please provide detailed information? Thanks in advance.

Sincerely,
Nina
E-iceblue support team