[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Subtotal function



I'm looking into adding the subtotal functionality that exists in Excel's
Data menu as it's one that I use often in my work, but I've noticed that the
subtotal worksheet function in Gnumeric isn't working correctly. It doesn't
handle nested subtotals correctly, and the subtotal function's whole reason
for being is to nest. <grin>

For instance, I subtotal(9,) the numbers from A1-A3 in A4 and subtotal(9,)
the numbers from A5-A7 in A8. If I put a subtotal(9,A1-A8) in A9, I should
get the grand total of the two subtotals, but I'm getting just the sum of
A1-A8 instead. (Just in case you're lost, the 9 tells subtotal to sum the
numbers as opposed to counting them or averaging them, etc.)

I've looked at the code and I think it'd take me a while to understand what
it's trying to do. Anyone know anything about why this function isn't
working in Gnumeric before I venture deeper into the code?

Darin Maxwell
falcon@wt.net




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]