Hi, I want to use the same number format for the subtotal cell based on the cells subtotals were calculated from.
This is how I set the use the subtotals: Reference< XSubTotalCalculatable > xSubtotal(rSpSheet, UNO_QUERY); Reference< XSubTotalDescriptor > descr = xSubtotal->createSubTotalDescriptor(true); Sequence< SubTotalColumn > colSeq(1); SubTotalColumn *column = new SubTotalColumn(); column->Column = 1; column->Function = GeneralFunction(2); colSeq[0] = *columns; descr->addNew(colSeq,3); xSubtotal->applySubTotals(descr,false); Can anybody help? Regard, Michael
