Hello,
I have a problem when I load and show existing excel file.
When I load excel file, unwanted cell borders are appears in screen.
And when I click "Load " button to reload, the problems dissapears.
How can I solve this problem?
Unexpected cell borders appear when the LoadDocument method is called in the Window_Loaded event handler
Answers approved by DevExpress Support
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
- v15.1.8Download Official Update
- v14.2.11Download Official Update
- v14.1.12Download Official Update
Here is the screenshot of the problem.
Hi,
We have successfully reproduced the behavior you described and passed this ticket to our developers' team for further research.
Please bear with us. We will notify you as soon as we make any progress.
As workaround, you can use the Dispatcher.InvokeAsync method. See the following code snippet:
private void PrepareTemplate() { var book = this.EmployeeTable.Document; book.LoadDocument(SpreadsheetLoading.Properties.Resources.Template, DevExpress.Spreadsheet.DocumentFormat.Xls); book.BeginUpdate(); var worksheet = book.Worksheets.ActiveWorksheet; var cells = worksheet.Cells; for (int i = 1; i <= 10; i++) { cells[i, 0].Value = i.ToString(); cells[i, 1].Value = "Employee" + i.ToString(); cells[i, 2].Value = "Department"; DevExpress.Spreadsheet.Style style = book.Styles[(i % 2 == 0) ? "EvenRow" : "OddRow"]; worksheet.Range.FromLTRB(0, i, 2, i).Style = style; } book.EndUpdate(); book.History.Clear(); } private void Window_Loaded(object sender, RoutedEventArgs e) { this.Dispatcher.InvokeAsync(PrepareTemplate); }Thank you for your reply.
But my project is based on .Net Framework v4 and it doesn't suppoert InvokeAsync method for Dispatcher.
How can I solve this problem?
Hi,
You can use Dispatcher.BeginInvoke method under .NET Framework 4. See the following code snippet:
delegate void PrepareTemplateDelegate(); private void Window_Loaded(object sender, RoutedEventArgs e) { this.Dispatcher.BeginInvoke(new PrepareTemplateDelegate(PrepareTemplate)); }Ok, it's done. Thank you for your help.
You are welcome.
Should you have additional questions regarding our products or need our further assistance, do not hesitate to contact us.