workbook load and save, data lost

GemBox.Spreadsheet
1

Hi everyone,

I’m currently working with GemBox Spreadsheet for the first time and have encountered several issues.

My main problem involves copying data into an input worksheet (worksheet[0]) with 63 rows and 161 columns. The Excel file, in .xls format, contains 27 worksheets, each with various calculations and graphs. My problem is however already seen when using the operations load and save.

When I load the workbook using ExcelFile::Load and save it immediately after, opening the file in Excel prompts a dialogue box saying: “File Error: data may have been lost,” which is accurate as my file size has reduced by almost 1 MB and all my references and graphs have dissapeared.

Has anyone experienced a similar issue or have any insights on what might be going wrong?

FYI; I am using an old GemBox version (v. 3.7).

Thanks, Lasse

2

Hi Lasse,

Please send us your XLS file so we can investigate it.

Also, I’m afraid that charts are not supported in XLS format. Can you use XLSX instead?

Regards,
Mario

3

I am unfortunately not able to send you the XLS file, as the customer doesn’t allow.
Okay, I can try using the XLSX format instead

4

Converting the Excel file to .xlsx format worked, but I’ve noticed that 16 worksheets, which contain only charts, are being omitted from the workbook when saving. Other than this issue, everything else functions correctly. Do you have any idea what might be causing this?

5

Unfortunately, I don’t have any guesses as to what the problem could be. I’m afraid that I will need to be able to reproduce your issue and investigate it.

Can you remove the confidential data from the file and send it to us? You can send it via email or support ticket; see the Contact page.

Last, just in case, can you try using the current latest version:

For starters, you can try using it in Trial mode:

// Set license key to use GemBox.Spreadsheet in a Free mode.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

// Continue to use the component in a Trial mode when free limit is reached.
SpreadsheetInfo.FreeLimitReached += (sender, e) => e.FreeLimitReachedAction = FreeLimitReachedAction.ContinueAsTrial;