Free Support Forum - aspose.com

Excel document is changed after touching by Aspose

Hello,

When I open source.xlsx attachmed to the post with Aspose using the code below it gets changed significantly. First of all, colors are changed. Another problem - static text in some cells is replaced with formulas. Please check dest.xlsx for differences.

The code executed:

Dim Workbook As New Aspose.Cells.Workbook

Workbook.Open(OpenFileDialog1.FileName, Aspose.Cells.FileFormatType.Excel2007Xlsx)

Workbook.CalculateFormula(True)

Workbook.Save(OpenFileDialog1.FileName, Aspose.Cells.FileFormatType.Excel2007Xlsx)

Hi,

Thanks for the template file.

We found the issue and will fix it soon.

Thank you.

Hi,

Please try the attached fix. Thank you.

Hello,

New dll doesn't break cell content, but it changes background and border colors, which could be pretty confusing for users.

Please see attachment.

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

My output file with the new dll is in the attachment, please check it. The fill color and border color is the same as the input file’s. Please make sure if you are using the new dll file.

If you still find the problem, please give us more details and sample codes to show and reproduce the problem. We will check and fix it soon if found the problem.

Thank you.

Hi,

I am using Aspose.Cells 4.4.3.17 which you have posted to this thread.

I thought that maybe the problem was in missing license file, so I tried to include it, but the result is still the same: different background and different border styles.

Please take a close look at the source_out.xlsx you have posted. Background in this file is also slightly different from the original. Also column width of some columns is different.

The code I am using is pretty simple

Dim Workbook As New Aspose.Cells.Workbook

Workbook.Open("source.xlsx", Aspose.Cells.FileFormatType.Excel2007Xlsx)

Workbook.CalculateFormula(True)

Workbook.Save("dest.xlsx", Aspose.Cells.FileFormatType.Excel2007Xlsx)

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Background and border styles shall have nothing to do with license file.

Well, background color and column width may be little difference between input/output xlsx files. We are working on the issues.

It’s so strange that you cannot get the same output file as the one I send you. Could you please check carefully if you are using the new dll file(4.4.3.17)?

Thank you.

Hello,

I am sure I am using 4.4.3.17. You can guess it from the fact that 'cell content' problem is fixed.

I also think it is strange that dll gives different results on different PCs, so I am ready to provide you any info about my PC in order to help you to fix the problem.

BR,

Olexandr

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Could you try the attached fix (the latest version) and post us the output file?

Thank you.

Here it is.

Aspose.Cells 4.4.3.19 is used in references.

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Could you please try the following code and tell us the output?

using System.Reflection;

try

{

Assembly a = Assembly.LoadFrom("Aspose.Cells.dll");

Console.WriteLine("Assembly Version Info: " + a.FullName);

Console.WriteLine("Assembly .NET Runtime info: " + a.ImageRuntimeVersion.ToString());

}

catch (Exception ee)

{

Console.WriteLine("Exception occurred: " + ee.Message);

}

Console.Read();// press any key to continue

Thank you.

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Could you try to open and save the attached xlsx file and post us the output file?

Thank you.

Hi,

The first line says:

Assembly Version Info: Aspose.Cells, Version=4.4.3.19, Culture=neutral, PublicKeyToken=716fcc553a201e56

Second:

Assembly .NET Runtime info: v1.0.3705

Hi,

Output file looks strange

BR,

Olexandr

Hi,

Thank you for the output file. We will check it ASAP.

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached debug version. It will add some debug info to the output file to help us to solve the problem.

Please try it with your source file or file “TestTint.xlsx” and post us the output file.

Thank you.

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for the output file.

The color tint issue is cause by culture setting of radix point character. We will figure out this issue and get back to you next week.

Thank you for your patient.

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached version.

We will figure out the “background color and column width may be little difference between input/output xlsx files” issue next week.

Thank you.

Hi,

It looks like 4.3.3.21 has fixed color issues.

I have attached the test file just in case you are interested.

BR,

Olexandr