Hello Frédérique,.
(I'm an Excel application from (OfficeXP SP3/OWC10), Office 2007 SP2/OWC11 migration), and I have run the spreadsheet control on the performance in a major obstacle. The performance issue by merging of two cells (Range.merge statement).
I know that another control, but you have a workaround for the merge statement in the hope.
Here is an example of the code. I can send you the complete workbook.
Dim sRange1Start as string
Dim sRange1End as string
sRange1Start = "$ C$ 5"
"" sRange1End = "$ C$ 6"
sRange1End = "$ E$ 15"
Form1.Spreadsheet1.Range (.)Spreadsheet1.Range(sRange1Start).Address & ":" _
& .Spreadsheet1.Range(sRange1End).(Address).Merge
Kind regards
Saleem
