Problem with new line in cell saving the file

Hi, i’ve a problem with this operation. In an application installed in production environmente I open a workbook 2007 in xlsm format that contains cell with new line, do some operation and then i save the workbook in 2007 xlsm format.



The output file is different in the cell that contains the new line: a strange char (that seems a space) was added where the new line was.

I produce a simple program that do the simple operation of open and save the file and the problem persist.

I've aspose.cells for .NET 4.8.0.0 version.

There is a fix for this version?

This is the code

Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook();
wb.Open(file, Aspose.Cells.FileFormatType.Excel2007Xlsm);
wb.Save(target, Aspose.Cells.FileFormatType.Excel2007Xlsm);

I attached the file on which you can replicate the problem and see the differences:
book1.xlsm is the original file
book1_aftersave.xlsm is the file that is saved.

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and try the latest version:

Aspose.Cells for .NET 7.2.0

it is working fine as I have tested your file.

Please see the code below. I have also attached the output file generated by it.

Please also see the screenshot and red highlighted area with a circle around it.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Book1.xlsm”;


Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + “.out.xlsm”);


Screenshot:

Hi, thanks for the fastest reply.

I tried the new version, and seems to be ok, as you tell me.
Because the application is installed in production environment, i’m afraid to install a new version, to avoid the risk of new problems.
Isn’t there a fix on the version 4.8.0 without using the new 7.2.0

Thanks
Hi,

Thanks for your posting.

I am afraid, it’s our policy not to provide fixes based on older versions.