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.

Sun Nov 18, 2018 9:20 am

Hey,

is it possibel to check if spreadsheet has changed?

GH

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

Mon Nov 19, 2018 11:16 am

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.
Sincerely,
Mike
E-iceblue support team
User avatar

Mike.Zhang
 
Posts: 93
Joined: Thu Sep 27, 2018 7:11 am

Tue Nov 20, 2018 9:47 am

Thank you for your fast help.
GH

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

Tue Nov 20, 2018 10:08 am

Hi,

It's my pleasure.
Any question, just feel free to contact us.
Sincerely,
Mike
E-iceblue support team
User avatar

Mike.Zhang
 
Posts: 93
Joined: Thu Sep 27, 2018 7:11 am

Sat Apr 13, 2019 11:26 pm

Hello

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

Whats this?

Thanks
Leo
User avatar

ronaldhaish
 
Posts: 1
Joined: Thu Apr 11, 2019 9:51 am
Location: Turkey

Mon Apr 15, 2019 9:24 am

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
User avatar

Nina.Tang
 
Posts: 968
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.Spreadsheet