Aspose Customer Newsletter, December 2007

In This Issue

Welcome

Welcome to the December 2007 issue of the Aspose Newsletter! In this month’s newsletter, we will provide some introductory information about our spotlight product: Aspose.Pdf. We will also look at the new and exciting features offered in the recent releases of Aspose.Total for Reporting Services, Aspose.Words, Aspose.Cells, Aspose.Slides and Aspose.BarCode. You will learn about the latest news from Aspose along with the monthly Tech-Tip, which demonstrates how you can quickly migrate to the latest Aspose.Slides with new tables engine.

Aspose.BarCode makes headway

A more optimized Aspose.Slides for Java

Import and export Excel 2007 XLSX file with Aspose.Cells for Java

Aspose.Words for .NET 4.4.2.0 Released

Latest Aspose.Slides for .NET 2.7.0 (and for Java 1.8.0) introduced a new tables engine and a new public API which is not fully compatible with the previous versions. The most important difference is the processing of borders of a cell. In the past to change the border style we could write something like this:


[C#]

// Accessing the cell in first row and first column
Cell cell = table.GetCell(0,0);
// Accessing the top border of the cell
CellBorder border = cell.TopBorder;
// Setting the color of the top border
border.LineFormat.ForeColor = Color.Red;
// Setting the width of the top border
border.LineFormat.Width = 3;

[VB]

' Accessing the cell in first row and first column
Dim cell As Cell =  table.GetCell(0,0)
' Accessing the top border of the cell
Dim border As CellBorder =  cell.TopBorder
' Setting the color of the top border
border.LineFormat.ForeColor = Color.Red
' Setting the width of the top border
border.LineFormat.Width = 3

[Java]

// Accessing the cell in first row and first column
Cell cell = table.getCell(0,0);
// Accessing the top border of the cell
CellBorder border = cell.getTopBorder();
// Setting the color of the top border
border.getLineFormat().setForeColor(Color.RED);
// Setting the width of the top border
border.getLineFormat().setWidth(3);

Actually, border of a merged cell can have several lines which wasn't processed. New tables engine provides very simple mechanism for that. Each CellBorder has iterator to lines. So to migrate to the new versions you should rewrite code in the following way:

[C#]

// Accessing the cell in first row and first column
Cell cell = table.GetCell(0,0);
// Accessing the top border of the cell
CellBorder border = cell.TopBorder;
// Accessing the iterator of the lines in top border of the cell
IEnumerator iter = border.GetEnumerator();
// Loop through all the lines
while (iter.MoveNext())
{
    Line line = (Line) iter.Current;
    // Setting the color of the top border
    line.LineFormat.ForeColor = Color.Red;
    // Setting the width of the top border
    line.LineFormat.Width = 3;
}

[VB]

' Accessing the cell in first row and first column
Dim cell As Cell =  table.GetCell(0,0)
' Accessing the top border of the cell
Dim border As CellBorder =  cell.TopBorder
' Accessing the iterator of the lines in top border of the cell
Dim iter As IEnumerator =  border.GetEnumerator()
' Loop through all the lines
While iter.MoveNext()
    Dim line As Line = CType(iter.Current, Line)
    ' Setting the color of the top border
    line.LineFormat.ForeColor = Color.Red
    ' Setting the width of the top border
    line.LineFormat.Width = 3
End While

[Java]

// Accessing the cell in first row and first column
Cell cell = table.getCell(0,0);
// Accessing the top border of the cell
CellBorder border = cell.getTopBorder();
// Accessing the iterator of the lines in top border of the cell
Iterator iter = border.iterator();
// Loop through all the lines
while (iter.hasNext())
{
    Line line = (Line) iter.next();
    // Setting the color of the top border
    line.getLineFormat().setForeColor(Color.RED);
    // Setting the width of the top border
    line.getLineFormat().setWidth(3);
}

Aspose.Total for Reporting Services Mega Release