public partial class Form1 : Form {
    // ...

    public Form1() {
        InitializeComponent();
        spreadsheetControl1.DocumentLoaded += spreadsheetControl1_DocumentLoaded;
        spreadsheetControl1.EmptyDocumentCreated += spreadsheetControl1_EmptyDocumentCreated;
        //...
    }
    private void spreadsheetControl1_DocumentLoaded(object sender, EventArgs e) {
        IWorkbook workbook = (sender as SpreadsheetControl).Document;
        workbook.Options.Save.CurrentFileName = 
            Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "result.xlsx");
    }
    private void spreadsheetControl1_EmptyDocumentCreated(object sender, EventArgs e) {
        IWorkbook workbook = (sender as SpreadsheetControl).Document;
        workbook.Options.Save.CurrentFileName = "newSpreadsheet.xlsx";
    }
}

Public Partial Class Form1
    Inherits Form
    Private workbook As IWorkbook
    Public Sub New()
        InitializeComponent()
        AddHandler spreadsheetControl1.DocumentLoaded, AddressOf spreadsheetControl1_DocumentLoaded
        AddHandler spreadsheetControl1.EmptyDocumentCreated, AddressOf spreadsheetControl1_EmptyDocumentCreated
        ' ...
    End Sub
    Private Sub spreadsheetControl1_DocumentLoaded(sender As Object, e As EventArgs)
        Dim workbook As IWorkbook = CType(sender, SpreadsheetControl).Document
        workbook.Options.Save.CurrentFileName = Path.Combine(
            Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "result.xlsx")
    End Sub
    Private Sub spreadsheetControl1_EmptyDocumentCreated(sender As Object, e As EventArgs)
        Dim workbook As IWorkbook = CType(sender, SpreadsheetControl).Document
        workbook.Options.Save.CurrentFileName = "newSpreadsheet.xlsx"
    End Sub
End Class

private void Form1_Load(object sender, EventArgs e) {
using (Stream stream = new FileStream("FirstLook.xlsx", FileMode.Open)) {
    spreadsheetControl1.LoadDocument(stream);
  }
}
//...
private void Form1_FormClosed(object sender, FormClosedEventArgs e) {
   spreadsheetControl1.SaveDocument("Result.xlsx", DocumentFormat.Xlsx);
}

Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs)
        Using stream As Stream = New FileStream("FirstLook.xlsx", FileMode.Open)
            spreadsheetControl1.LoadDocument(stream)
        End Using
    End Sub
'...
Private Sub Form1_FormClosed(ByVal sender As Object, ByVal e As FormClosedEventArgs)
    spreadsheetControl1.SaveDocument("Result.xlsx", DocumentFormat.Xlsx)
End Sub

private void SpreadsheetControl_BeforeImport(object sender, BeforeImportEventArgs e) {
    if (e.DocumentFormat == DocumentFormat.Text) {
        //Detects plain text encoding automatically
        ((TxtDocumentImporterOptions)e.Options).AutoDetectEncoding = true;
    }

    if (e.DocumentFormat == DocumentFormat.Csv) {
        //Disables removing all leading and trailing whitespace characters
        ((CsvDocumentImporterOptions)e.Options).TrimBlanks = false;
    }

    if (e.DocumentFormat == DocumentFormat.OpenXml) {
        //Sets manual formula calculation mode
        ((OpenXmlDocumentImporterOptions)e.Options).OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual;
    }
}

Private Sub SpreadsheetControl_BeforeImport(ByVal sender As Object, ByVal e As BeforeImportEventArgs)
    If e.DocumentFormat = DocumentFormat.PlainText Then
        'Detects plain text encoding automatically
        (CType(e.Options, TxtDocumentImporterOptions)).AutoDetectEncoding = True
    End If 

    If e.DocumentFormat = DocumentFormat.Doc Then
        'Disables removing all leading and trailing whitespace characters
        (CType(e.Options, CsvDocumentImporterOptions)).TrimBlanks = False
    End If

    If e.DocumentFormat = DocumentFormat.Html Then
        'Sets manual formula calculation mode
        (CType(e.Options, OpenXmlDocumentImporterOptions)).OverrideCalculationMode = DevExpress.XtraSpreadsheet.Import.CalculationModeOverride.Manual
    End If
End Sub

private void SpreadsheetControl_BeforeExport(object sender, BeforeExportEventArgs e) {
    if (e.DocumentFormat == DocumentFormat.Text) {
        //Specifies the formula export mode
        TxtDocumentExporterOptions plainTextOptions = e.Options as TxtDocumentExporterOptions;
        plainTextOptions.FormulaExportMode = DevExpress.XtraSpreadsheet.Export.FormulaExportMode.CalculatedValue;
    }

    if (e.DocumentFormat == DocumentFormat.Csv) {
        //Specifies CSV document hidden column behavior and the worksheet name 
        CsvDocumentExporterOptions csvOptions = e.Options as CsvDocumentExporterOptions;
        csvOptions.SkipHiddenColumns = True;
        csvOptions.WorksheetName = "Results";
    }
}

Private Sub SpreadsheetControl_BeforeExport(ByVal sender As Object, ByVal e As BeforeExportEventArgs)
    If e.DocumentFormat = DocumentFormat.Text Then
    'Specifies the formula export mode
    Dim plainTextOptions As TxtDocumentExporterOptions = TryCast(e.Options, TxtDocumentExporterOptions)
    plainTextOptions.FormulaExportMode = DevExpress.XtraSpreadsheet.Export.FormulaExportMode.CalculatedValue
    End If

    If e.DocumentFormat = DocumentFormat.Csv Then
    'Specifies CSV document hidden column behavior and the worksheet name
    Dim csvOptions As CsvDocumentExporterOptions = TryCast(e.Options, CsvDocumentExporterOptions)
    csvOptions.SkipHiddenColumns = True 
    csvOptions.WorksheetName = "Results"
    End If
End Sub