Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
315
WPF Spread Sheet 14.2 crashes, when deleting sheet.
posted

WPF Spread Sheet 14.2

Open dbenfachALL.xlsx, delete [Filial] sheet, it crashes.

dbenfachALL.xlsx (https://www.devexpress.com/Support/Center/Question/Details/Q571743)

It is Excel Engine error, not Spreadsheet control error.

===================================================================================================
Infragistics WPF Spreadsheet demo.

<Window
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation";
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml";
        xmlns:ig="http://schemas.infragistics.com/xaml"; x:Class="WpfApp.MainWindow"
        Title="MainWindow" Height="350" Width="525">
   
       
       
           
           
       
       
        Load

      

  

using System.IO;
using System.Windows;
using Infragistics.Documents.Excel;

namespace WpfApp
{
    ///


    /// Interaction logic for MainWindow.xaml
    ///
    public partial class MainWindow : Window
    {
      
        public MainWindow()
        {
            InitializeComponent();
        }

       private void ButtonBase_OnClick(object sender, RoutedEventArgs e)
        {

           Stream stream = File.Open("mydocument.xlsx", FileMode.OpenOrCreate);
            Workbook wb = Workbook.Load(stream);
            if (wb != null)
            {
                this.spread.Workbook = wb;
            }
        }
    }
}