Function 'CEILING.PRECISE' not resolved

Aspose.Cells Product Family
1

Hi,
when do you expect to support CEILING.PRECISE ?
I got a ‘NAME’ error after calculation.

You already support CEILING but not CEILING.PRECISE ? It is correct ?
Any timeline here ?

Regards,

2

@christoph_schroeder01_sap_com

Thanks for using Aspose APis.

Please provide us your Excel file containing your CEILING.PRECISE function for our investigation. You can create such an Excel file manually using Microsoft Excel and provide it to us. We will look into this issue with the help of your given file and update you asap.

3

Hi,

I attache the file here Ceiling.Precise.zip (5.5 KB)

Here my code:

xlsLic.SetLicense("Aspose.Total.lic");
string fileName = @"Ceiling.Precise.xlsx";
Workbook workbook = new Workbook(fileName);
       

        string value = workbook.Worksheets["Sheet1"].Cells["A1"].StringValue;
        MessageBox.Show(value);
        workbook.CalculateFormula();
        string value2 = workbook.Worksheets["Sheet1"].Cells["A1"].StringValue;
        MessageBox.Show(value2);

Kind regards,

4

@christoph_schroeder01_sap_com

Thanks for using Aspose APIs.

We were able to observe this issue and logged it in our database for investigation and implementation. Once, the issue is resolved or we have some other news for you, we will update you in this topic.

This issue has been logged as a New Feature request as follows i.e.

  • CELLSNET-46095 - Implement function CEILING.PRECISE
5

@christoph_schroeder01_sap_com

This is to inform you that we have fixed your issue CELLSNET-46095 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

6

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

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