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,