Spreadsheet view problem?

Hi, I want to ask the problem with view spreadsheet, even though I have setting cell alignment the excel file, but the view process does not show cell alignment properly so I have to set it up when form.load but after scrolling the mouse, they broke down again:

                Spreadsheet1.ActiveGrid.SetRowHeight(3, 100, 40)
                Spreadsheet1.Workbook.Worksheets(0).Range("B3:C218").CellStyle.VerticalAlignment = ExcelVAlign.VAlignCenter
                Spreadsheet1.ActiveGrid.Invalidate

What can I do ? 
My image:


my gif:

4 Replies

TG The GridLock March 23, 2020 08:20 PM UTC

Well, I realize it seems that the problem is when there is hypelink!


TG The GridLock March 23, 2020 08:41 PM UTC

my video: when i double click in hypelink cell and receive error!

Attachment: Video_200324_032730_f67b3dca.rar


TG The GridLock March 23, 2020 10:07 PM UTC

oh I don't know why it works now. It seems to be affected by form size or column width.
Earlier when I clicked on the cell containing the hypelink it also didn't work. however now process works


AR Arulpriya Ramalingam Syncfusion Team March 24, 2020 04:45 PM UTC

Hi khanh, 
 
Thank you for your interest in Syncfusion products. 
 
We have tried to replicate the reported scenario by adding a hyperlink in spreadsheet cell. The link is navigated properly at our end and suspect that the reported issue might be occurred due to some other customization at your end. Please refer to the below sample and let us know the exact use case of the reported scenario which will be helpful for us to assist you further with proper solution. 
 
 
Regards, 
Arulpriya 


Loader.
Up arrow icon