Hi all,

I need some formulas that I can't find in the "basic" formulas.

I'm talking about MROUND, FLOOR and CEILING that you can find in Excel.

Is there some component that can help me ?

Thanks !

Hi Luca,

The only component that I find with formulas is this:

https://www.outsystems.com/forge/component-overview/98/excel-financial-functions


If this can't help you, you can always try do develop that formulas in Outsystems actions.


Hope this can help you.


Best regards,

Ricardo

Hi Ricardo, thanks for your answer !


Unfortunately I'm not able to open / install it ...


I have the message "Unsupported older version 4.1.3.76"

Luca De Mori wrote:

Hi all,

I need some formulas that I can't find in the "basic" formulas.

I'm talking about MROUND, FLOOR and CEILING that you can find in Excel.

Is there some component that can help me ?

Thanks !

Hello Luca,

In my humble opinion, it is better to develop those formulas by yourself. In terms of governance is a much better decision.
If you have difficulties, let me know and I can maybe create those for you.

Kind regards,
Ruben Bonito


Hi Ruben !

in the end ... I used Spire.XLS (I already have the license) with an Excel template.

I send the values in INPUT to my Excel file and the XIF give me back the results ...

Hi Luca, 

You can also built an extension using a .net excel nuget. That way you can create your extension and whenever you need additional functions already built in excel you can just update it and share with the community!

This is very interesting, but i am thinking how to call excel function in c# with many parameters? The parameters is in a range that can be 1, 2, etc?

regards and thank you