During the last days I have evaluated Aspose.Grid. First of all, Aspose.Grid could be a powerful control. But there are also a lot of questions.
- Performance: I create the grid structure at runtime, depending on the content of some database tables. I’m using different styles and fonts as well as formulas. The generation of the initial grid takes in the most cases over 90 seconds (please find an example attached). In my opinion this is far too much.
- Formulas: Please take a look at the following lines of code. First of all I’m writing 4 numbers into 4 cells. Then I add a Formula that should add the values of the second row. To set the values (both values as well as the formula) of this row I used the member “temprow” that is set to 1. The result of this operation is 5, and not 2! The formula refers every time to the row with the index temprow – 1.
Worksheet wks = mGridDesktop.Worksheets;
Style rowcountStyle = new Style(mGridDesktop);
rowcountStyle.HAlignment = HorizontalAlignmentType.Right;
rowcountStyle.NumberFormat = 1;
int temprow = 1;
wks.Cells[temprow,3].SetCellValue("=SUM(B" + temprow.ToString() + ":C" + temprow.ToString()+ ")" );
- It is planed to offer the same functions for the DesktopGrid as they are offered for the WebGrid. It is frustrating to find out that functions are implemented for WebGrid and not for the DesktopGrid
- How can I change the title of a HeaderColumn? It is possible to hide Row and Column Headers?