Wrong value in VerticalAlignment when using XML Spreadsheet

Aspose.Cells Product Family
1
When trying to read VerticalAttribute property of cell from XML Spreadsheet Aspose returns "Center" value, when in fact cell alignment is set to "Bottom". Single cell that is causing problems is extracted to attachment of this message. In order to easily reproduce the issue use attached spreadsheet and the following code (same issue occurs in Java and .NET version):

//load cell & display valign
var workbook = new Workbook("bug.xml");
var valign = workbook.Worksheets["AL"].Cells.GetCell(6, 1).GetStyle().VerticalAlignment;

Console.WriteLine(valign.ToString()); //incorrect - should be bottom

//workaround - save as xlsx, and load again
Stream stream = new MemoryStream();
workbook.Save(stream, SaveFormat.Xlsx);

//load cell & display valign
workbook = new Workbook(stream);
valign = workbook.Worksheets["AL"].Cells.GetCell(6, 1).GetStyle().VerticalAlignment;

Console.WriteLine(valign.ToString()); //correct - bottom

Looking forward for resolving this issue.
2

Hi,


Thanks for the sample file and sharing code segment.

After an initial test, I observed the issue as you mentioned by using your template file with your sample code. It gives me “Center” as vertical alignment at first where it should give “Bottom” value for vertical alignment. I have logged a ticket with an id “CELLSNET-42087” for your issue. We will look into your issue to figure it out soon.

Thank you.
3

Hi,

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

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.6.0.2 and let us know your feedback.

4

Actually I’m using Aspose Cells under Java environment. Are there any plans to fix this in Java version?

5

Hi Marek,

Thank you for bringing this to our knowledge.

Initially you shared .NET code so we thought you are having issues in Aspose.Cells for .NET. Anyway, I have logged another ticket in Aspose.Cells for Java space to fix the mentioned problem in Java version of the product as well. The ticket Id for your future reference is CELLSJAVA-40648.

As soon as we port out the latest implementation of Aspose.Cells for .NET to Java version, your issue will get resolved. We will keep you posted with updates on this.

6

Hi Marek,

Thanks for using Aspose.Cells.

Please download and try the latest version: Aspose.Cells
for Java v7.6.0.3. Your issue should be fixed by it.

7

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

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

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

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