Free Support Forum - aspose.com

New API

Hello,

with Aspose.Cells 7 there are a lot of API changes in JAVA. I’m currently missing Row.getFirstCellIndex() and Row.getLastCellIndex().

What happend to these methods? What shall I use instead?

Regards,
Jan

The next thing I’m missing:
In Aspose.Cells 2.5.4 I was able to move Sheets using Worksheets.move().

How can I do that in 7.0?

Regards,
Jan

Hi,


Well, you may use Cells.getFirstCell and Cells.getLastCell methods instead:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/com/aspose/cells/cells.html

And using some CellsHelper class methods, you may convert the cell’s name to indexed value.
Thank you.


Hi,


For moving Worksheet to other location, use Worksheet.move() method instead:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/com/aspose/cells/worksheet.html


Thank you.

Ok thanks so far.
The next thing I’m searching.
Old API: Sheet.calculateFormula(Boolean, Boolean)
New API: ???

Regards,
Jan

Cells.getFirstCell() and Cells.getLastCell() doesn’t work for me. I need the first and last cell of a row!
Any ideas?

Regards,
Jan

Hi,

We will provide those APIs in 2-3 workdays. For calculating formulas, I think you can calculate the complete workbook instead of calcualte one sheet currently.

Thank you.

Hi,

Please try the attached latest version/fix v7.0.0.2.

For calcualting formulas for a specific sheet, please use:

void com.aspose.cells.Worksheet.calculateFormula(boolean recursive, boolean ignoreError, ICustomFunction customFunction)

where the customFunction can be null.

For getting first and last cell/cell index, please use:

Cell com.aspose.cells.Row.getFirstCell()/getLastCell()

If there is no cell initialized for a given Row, null will be returned.

Thank you.

The new Version works great. Missing API’s are working great! Thanks!

Regards,
Jan

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


This message was posted using Notification2Forum from Downloads module by aspose.notifier.