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
145
Unable to edit XamSpreadSheet
posted

Hi,

I am using a xamSpreadSheet in a WPF application as follows

<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="spreadsheetTest.MainWindow"
Title="MainWindow" Height="350" Width="525">
<Grid Margin="25,31,49.4,17.4">
<Grid.ColumnDefinitions>
<ColumnDefinition/>
<ColumnDefinition Width="0*"/>
</Grid.ColumnDefinitions>
<ig:XamSpreadsheet Name="_spreadsheet1" IsEnabled="True" Margin="21,26,0,0" VerticalAlignment="Top" Height="203" RenderTransformOrigin="0.5,0.5" HorizontalAlignment="Left" Width="338">
<ig:XamSpreadsheet.RenderTransform>
<TransformGroup>
<ScaleTransform/>
<SkewTransform AngleY="0.235" AngleX="-0.364"/>
<RotateTransform/>
<TranslateTransform Y="0.595" X="0.556"/>
</TransformGroup>
</ig:XamSpreadsheet.RenderTransform>
</ig:XamSpreadsheet>
<Button Content="Button" HorizontalAlignment="Left" Margin="80,246,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click"/>
</Grid>
</Window>

Code behind: for the button click

private void Button_Click(object sender, RoutedEventArgs e)
{
string file = @"C:\FileSample.xlsx";
using (var stream = File.Open(file, FileMode.Open, FileAccess.ReadWrite, FileShare.None))
{
_spreadsheet1.Workbook = Infragistics.Documents.Excel.Workbook.Load(stream);
}
}

After I load the excel file, I am unable to edit, on property which I have missed. Please let me know.

Thanks

Parents
No Data
Reply Children