Hello,
Thank you for the solution, but it is not really what I was looking for. Binding a command in such a way breaks MVVM since the view model knows about the view. In the end, I extended the SfSpreadsheet and added a new dependency property for the default file path:
public class SfSpreadSheetExt:SfSpreadsheet
{
public SfSpreadSheetExt() : base()
{
Commands.FileOpen = new FileOpenCommandExt(this, "FileOpen", DefaultOpenFilePath);
}
public string DefaultOpenFilePath
{
get => (string)GetValue(DefaultOpenFilePathProperty);
set => SetValue(DefaultOpenFilePathProperty, value);
}
public static readonly DependencyProperty DefaultOpenFilePathProperty =
DependencyProperty.Register(nameof(DefaultOpenFilePath), typeof(string), typeof(SfSpreadSheetExt), new PropertyMetadata(OnDefaultOpenFilePathChanged));
private static void OnDefaultOpenFilePathChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
{
if (d is not SfSpreadSheetExt spreadSheet) return;
((FileOpenCommandExt) spreadSheet.Commands.FileOpen).DefaultPath = (string) e.NewValue;
}
}
public class FileOpenCommandExt : FileOpenCommand
{
public string DefaultPath { get; set; }
public FileOpenCommandExt(SfSpreadsheet spreadsheetControl, string commandName, string defaultPath) : base(
spreadsheetControl, commandName)
{
DefaultPath = defaultPath;
}
protected override void OnExecute(object parameter)
{
var openFileDlg = new Microsoft.Win32.OpenFileDialog
{
Filter =
"Excel 97 to 2003 Workbook|*.xls|Excel Workbook(*.xlsx)|*.xlsx|CSV (Comma delimited)|*.csv|All Excel Files|*.xlsx;*.xlsm;*.xls;*.xlt;*.csv",
FilterIndex = 4,
InitialDirectory =
Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) ?? string.Empty, DefaultPath)
};
var result = openFileDlg.ShowDialog();
if (result is null or false) return;
var stream = openFileDlg.OpenFile();
SfSpreadsheet.Open(stream);
SfSpreadsheet.FocusActiveGrid();
}
}
