Formatting issues with xlsx file

Aspose.Cells Product Family
1

Hi,

We are facing very weird issues while working with xlsx files as below,

1) Watermark set at the templarte level does not appear generated output.

2) Sheets created dynamicaaly through code, using AddCopy function, this creates watermark and text objects with blue background and changes the font settings.

3) Legend sometimes comes up horizontal and sometimes vertical with legend entries.

Earlier we were saving our files with xls extension. Now as we all are using office 2007, we would like to save the files with xlsx extn.

Due to above errors are not unable to save files to xlsx version.

Can you pls help us in resolving these issues. We are using 7.2.1.0 version.

(Attached screen shot of expected and actual files)

Thanks,

Hetal

2

Hi,


Please try our latest version/fix: Aspose.Cells for .NET (Latest Version)

If you still find any issue, kindly give us your runnable code and attach the template files (input + output), we will check it soon.

3

hi,

Issue still exists with new version 7.2.1.1 also.

Code logic,

Workbook oWB = new Workbook(@"C:\InputFile.xlsx");

int iIndex = oWB.Worksheets.AddCopy("Sheet1");

oWB.Worksheets[iIndex].Name = "NewSheet";

oWB.Save(@"C:\OutputFile.xlsx");

Attached the Input and Outout file.

Thanks,

Hetal

4

Hi,

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

We do not support wordart of the xlsx file now. It’s a complex feature.
We could not support it. Please replace it with the picture .

Anyway, we have logged your issue in our database. Development team will look into your issue and once we will get some update relating to it, we will let you know.

This issue has been logged as CELLSNET-40692.

C#


string filePath = @“F:\nputFile.xlsx”;


Workbook oWB = new Workbook(filePath);


int iIndex = oWB.Worksheets.AddCopy(“Sheet1”);


oWB.Worksheets[iIndex].Name = “NewSheet”;


oWB.Save(filePath + “.out.xlsx”);


5

Thanks for the clarification.

We are in process of converting our files from xls to xlsx. It will be very helpful if you can send the list of features that are removed for xlsx or limitations in using xlsx file type.

Thanks,

Hetal

6

Hi,

Thanks for your posting.

We have logged your comment in our database against the issue id: CELLSNET-40692

We will update you asap.

7

hi Team,

We are again facing the same issue. We have downloaded the laterst Aspose.Cells.dll version 7.4.0 and by using this dll with no code changes our wordart is not coming up properly. Attached the screenshot of Before (correct wordart) and After (incorrect wordart).

Hope to see quick resolution.

Thanks,

Hetal

8

Hi,

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

Reading/Writing of WordArt from Xlsx file is not supported yet. Once, it is supported, we will let you know asap. We have also logged your comments in our database against this issue.

9

hi,

We are not using xlsx because it is not supported yet. We are using xls file only and everything used to work fine just before we downloaded the Aspose.cells.dll version 7.4.0.

Pls note we are using xls file only and there is no code changes. The only change is downloaded Aspose.Cells.dll new version i.e 7.4.0

Hope this is clear.

Thanks,

Hetal

10

Hi,


Please try our latest version/fix: Aspose.Cells for .NET (Latest Version)

If you still find the issue, kindly attach your input and output files here, we will check your issue soon.

Thank you.

11

Tried it. Version 7.5.2 still have the same issue.

12

Hi,


Please attach your input and output files here. Also, paste your sample code, we will check your issue soon.

Thank you.

13

The sample template is attached. In the DATA tab there is a WordArt image which gets incorrectly rendered when data is populated into cells with Aspose 7.5.2

14

Hi,


Thanks for the template file.

After an initial test, I observed the issue as you mentioned. The WordArt shape is not rendered the same way as per the original file, the word-wrap is removed and it uses only one line. I used the following sample code.

Sample code:

Workbook oWB = new Workbook(@“e:\test2\GetReturnsAspose.xls”);
int iIndex = oWB.Worksheets.AddCopy(“DATA”);
oWB.Worksheets[iIndex].Name = “NewSheet”;
oWB.Save(@“e:\test2\OutputFile.xlsx”);

The screen shot is also attached here for your reference. I have logged a ticket with an id “CELLSNET-41938” for your issue. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.


15

Hi,

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

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

16

Hi again,


First of all, please accept our apologies for the delayed response. This is to update you that we have resolved the problem logged earlier as CELLSNET-41938. Please give a try to Aspose.Cells for .NET (Latest Version) and share your feedback.

17

The issues you have found earlier (filed as CELLSNET-41938) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.