When I open an XLS file using Aspose.Cells, and save it as an XLSX file, the cell’s text fomatting is discarded - in particular the vertical and horizontal text align, as well as the word-wrap setting.
I use the simplest code to reproduce the issue.
string filePath = @"E:\test2\Landing.xls";
Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + ".out.xlsx", SaveFormat.Xlsx);
Thanks for such a prompt reply.
Hi,
Thanks for your posting.
Please use Add/Update button to attach your file.
You need to click on the Reply button and not Quick Reply button.
Please see the screenshot for your help.
Edit: Its good to know you have figured it out.
Screenshot
Hi,
I have tested your files with the latest version:
Aspose.Cells for .NET (Latest Version) and could not replicate the problem.
Please take a look and if you could see problems, then please provide me screenshots, highlight the problems with red circles. You can create screenshots in Ms-Paint.
Please see the one, I have created in the above post.
Below is my code for a reference.
C#
string filePath = @“F:\Shak-Data-RW\Downloads\proj”;
string[] paths = Directory.GetFiles(filePath);
foreach (string path in paths)
{
Workbook workbook = new Workbook(path);
workbook.Save(path + “.out.xlsx”);
}
Thanks for the explanation regarding “reply” versus “quick reply”.
Hi,
Sorry, I am not able to run your C# lambda expression, can you please provide me a runnable code.
I think, if you will use the latest version:
Aspose.Cells for .NET (Latest Version) , then it will fix your problems, because I have compared your screenshot with the output xlsx file and it is fine.
Hi,
We were able to reproduce this issue using the latest version: Aspose.Cells for .NET v7.1.2.2 with the following code.
We have logged this issue in our database. Development team will look into this issue and once the fix is available or we have some update, we will let you know asap.
This issue has been logged as CELLSNET-40499.
C#
string file = @“D:\Survey Summary.xls”;
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(@“D:\landing.xls”);
workbook.Combine(new Aspose.Cells.Workbook(file));
workbook.Save(@“D:\dest.xlsx”);
The issues you have found earlier (filed as CELLSNET-40482) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.