Macro don't saves when editing .ods spreadsheet

GemBox.Spreadsheet
1

I have open office spreadsheet with some macro code attached to open document event. When I read and edit file and then saving afterwards all modules with macro code in document dissapears. Can gembox save macro when working with .ods format?

private async Task<Stream> FillSpreadsheet(string filePath, CancellationToken cancellationToken)
{
    var workbook = ExcelFile.Load(filePath, LoadOptions.OdsDefault);

    // some editing in workbook

    var memoryStream = new MemoryStream() { Position = 0 };
    workbook.Save(memoryStream, SaveOptions.OdsDefault);
    return memoryStream;
}

Gembox.Spreadsheet Version 49.0.1623

2

Hi Skooks,

Currently, GemBox.Spreadsheet doesn’t preserve macros in ODS.

Please send us a sample of your ODS file so we can investigate this requirement further.
You can send the file via email or support ticket, see the Contact page.

Regards,
Mario

3

Thanks for the answer. I hope someday this feature will be added

4

We can investigate if we can add support for this for you.
Please send us a sample document that we can use for testing purposes.