OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

subtotals - why bother?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Tue Feb 28, 2006 8:27 am    Post subject: subtotals - why bother? Reply with quote

Just need to get the frustration out!
I have been using SUBTOTAL a bit today and now realise that it automatically treats the first line as a heading and does not include it in the total.That makes my results unreliable.
I have now made a mental note to not use it again till there is an option to not do this (as is the case with SORT)
Or have I missed something?
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Tue Feb 28, 2006 11:11 am    Post subject: Reply with quote

I think that Data Subtotals ... is working as intended. The first row is always treated as a heading and is used to distinguish the columns that you wish to use in grouping. Your results will always be consistent with this.
The subtotal function which is inserted automatically by the use of the menu option above specifies the cells to be included in the subtotal exactly. That is, the range does not include the header row.
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Tue Feb 28, 2006 10:47 pm    Post subject: Reply with quote

Thats exactly my difficulty!
If a set of data doesnt have a heading (for instance when it just an intergral part of a longer list) then I have to create one temporarily to get round this auto assumption.
I am convinved that I could organise my thoughts to fit with SUBTOTAL but I am not so far sighted, as a mere person I change my mind and SUBTOTAL is too inflexible for me.
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Tue Feb 28, 2006 11:20 pm    Post subject: Reply with quote

I would go along with your idea, if only for consistency. Put in an enhancement request technically it would not be a big deal . I don't have excel to hand but you might be able to make a case by comparison withthe functionality there.
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Wed Mar 01, 2006 10:53 pm    Post subject: Reply with quote

I am sorry to pester but can you give me a hint as to where I put in such a request.
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Thu Mar 02, 2006 12:36 am    Post subject: Reply with quote

no problem there is some reading to do first ...
http://qa.openoffice.org/issue_handling/bug_writing_guidelines.html
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group