Differences between 4.7.1.0 and 5.1.1.0 - Aspose.Cells - Aspose.Cells Product Family

Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » Differences between 4.7.1.0 and 5.1.1.0 - Aspose.Cells

Differences between 4.7.1.0 and 5.1.1.0 - Aspose.Cells

Last post 11-16-2010, 10:55 AM by dtiziani. 4 replies.


	Sort Posts: Previous Next

11-12-2010, 11:22 AM 268701

dtiziani
Joined on 11-12-2010
Posts 3

Differences between 4.7.1.0 and 5.1.1.0 - Aspose.Cells

Hello,

I had to migrate some reports from version 5.1.1.0 to 4.7.1.0 (downgrade), but after making the changes, the cell positions were totally different.

Is there any changes for the position of the cells between those versions? It seems like the row/column index changed from version to version. And also the merge cells function.

Thanks,
Daniel

Filed under: asP.NETPRO

11-12-2010, 11:51 AM 268707 in reply to 268701

Amjad Sahi
Joined on 08-30-2006
Posts 18,411

Re: Differences between 4.7.1.0 and 5.1.1.0 - Aspose.Cells

Hi,

Well, there is no change of cells row/column indexes positions, they remain the same as they start from 0 based indexed position.
For Merge function, here is the method reference:

public void Merge(
   int firstRow,
   int firstColumn,
   int totalRows,
   int totalColumns
);

Parameters

firstRow: First row of this range(zero based)
firstColumn: First column of this range(zero based)
totalRows: Number of rows(one based)
totalColumns: Number of columns(one based)

Is there any thing I can make you understand.

Thank you.

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

11-12-2010, 12:01 PM 268710 in reply to 268707

dtiziani
Joined on 11-12-2010
Posts 3

Re: Differences between 4.7.1.0 and 5.1.1.0 - Aspose.Cells

Hi Amjad,

I found out what was happened:

I'm loading a xls file as template to work on it.
When I was using 5.1.1.0 I used this snippet:

FileStream file = new FileStream("C:\pathToFile.xsl",
FileMode.Open,
FileAccess.Read);
Workbook workbook = new Workbook(file);

and then started working on it.

Now that I'm on 4.7.1.0 I have to:

Workbook workbook = new Workbook();
workbook.LoadData("C:\pathToFile.xsl");

But it is not parsing right, as the first cell is merged in a range of three cells, and the generated file is not. I do not touch those cells on the code, so maybe the LoadData did not parse it right.

Do you have any ideas? I'm desperate here!

Thanks for your help!

11-12-2010, 12:08 PM 268711 in reply to 268710

Amjad Sahi
Joined on 08-30-2006
Posts 18,411

Re: Differences between 4.7.1.0 and 5.1.1.0 - Aspose.Cells

Hi,

Well, Workbook.LoadData() method only extract data and the formatting, objects would be lost. So, you should use Workbook.Open() method instead in v4.7.1.x.

Workbook workbook = new Workbook();
workbook.Open("C:\pathToFile.xsl");

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

11-16-2010, 10:55 AM 269134 in reply to 268711

dtiziani
Joined on 11-12-2010
Posts 3

Re: Differences between 4.7.1.0 and 5.1.1.0 - Aspose.Cells

Thanks for your prompt response, Amjad!