I have thought it again and as introductory step (to speed up the whole thing) you can bring \"fixed row\" functionality at first.
E.g. property FixedRow with enum value (None, TopRow, Bottom Row), so the scrolling will not affect these if set. And totals we can do programmatically for now.
And later on you can bring on AutoSum and formulas etc..