You just fill up the sheet with the fields of the file I want to get Soloi sub total field type. I think I found the solution. I enclose a piece of script tell me if it is right
SetWSCellTextFormat (tempHandle, 3,1,3,1, ID_font, 9.0);
SetWSCellNumberFormat (tempHandle, 3,1,3,1,1,0,'','');
SetWSCellBorder (tempHandle, 3,1,3,1, TRUE, TRUE, TRUE, TRUE, FALSE);
SetWSCellFormula (tempHandle, 3,1,3,1, '= ('' hardware''.'' Type'')');
SetWSCellTextFormat (tempHandle, 3,2,3,2, ID_font, 9.0);
SetWSCellNumberFormat (tempHandle, 3,2,3,2,2,0,'','');
SetWSCellBorder (tempHandle, 3,2,3,2, TRUE, TRUE, TRUE, TRUE, FALSE);
SetWSCellFormula (tempHandle, 3,2,3,2, '= ('' hardware''.'''' Pieces Total)');
SetWSColumnOperators (tempHandle, 3, -1,0,0,1,0,0); {ordino the first column and condeso data by type}
Hello
? thanks Piero