Saving spreadsheet as SpreadsheetML with Rate formula has issues

Aspose.Cells Product Family
1

I have a very simple spreadsheet that contains a Rate formula in cell A1...

=RATE(12, -250, 5000).

When I save the spreadsheet in SpreadsheetML format with the below code, if you look at the contents of the XML file you will see that the formula was saved as...

=12,-250,5000

I have attached the Excel files for reference.

Can this be fixed?

Harry

var workbook = new Workbook();

workbook.Open("Rate.xls");

workbook.Save("Rate.xml");

2

Hi Harry,

We are able to reproduce the issue mentioned by you. The issue has been logged with ID CELLSNET-21276. We will update you as soon as possible.

Thanks,

3

Hi Harry,

Please use the updated version Aspose.Cells5.1.4.5.zip attached. The issue has been fixed.

Thanks,

4

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

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