Equivalence in smart markets Aspose Cells - basic functions of EXCEL

Aspose.Cells Product Family
1

We are working with smart markets Aspose Cells, and we need to know if there is some reference where I can check the equivalence of the functions of Excel and aspose.cells

For example, we found the equivalence of the sum: in Aspose.Cells is &=&=SUM(H9:H10) and excel translate =SUM(H9:H10) .

other hand, in our excel, we have a field wich is &=Datos.Nombre in cell B1 (but then this value will grow) and we want another cell with the value of B1 once executed the query. How could we do?

Now need the other basic functions of EXCEL: for text uppercase, lowercase, date formatting, etc..

Thanks and best regards,

iASoft team.
2

Hi,


Please check the topic for your complete reference on different options and features available in Smart Markers:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/smart-markers.html

For your information, you may use any Excel formula/functions with setting dynamic formulas in smart markers, e.g
“&=&=TEXT(C{r},“0”)” → this is repeat dynamic formula that will be implemented on each row of Column, it will convert to text with specified format. You may try other functions for your need.

Thank you.