Bug 42629

Summary: SUM, COUNT, COUNT², MAX, MIN,etc. Status bar toggle box for selections - Allow more than one
Product: LibreOffice Reporter: Nicolás Adamo <nicoadamo>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: high CC: cno, dag, edwardiv1, gerry.treppel, justinjovic, nicoadamo, nicolas.pujol+lo, suokunlong
Version: Inherited From OOo   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: screenshot example

Description Nicolás Adamo 2011-11-05 11:32:25 UTC
When selecting a range of cells, there's a sort of status bar to the left of the zoom slider where you can read by default the sum of the range. If you right click this text, you can choose wether to show the average, the count, max, min, etc. 
This is great; the request I'm asking for is to show more than one of this indicators. On normal monitor resolutions there's space for adding aditional information, so I think joinig data strings is possible. Maybe the quickest way to develop this is to change the toogle box for a tick box, allowing the user to select more than one option.

That's all, thanks.
Comment 1 Dag Wieers 2011-11-06 13:45:58 UTC
What's even more, this is a regression of some sort, as a few people were used to seeing both Sum and Average at the same time.

I often used this, and it's no longer there. In OpenOffice 3.2 you had only 2 options in that list:

    Sum/Average
    None

Where the first one would show: Sum=<value> Average=<value>

Ideally we could tick more than one option to have it added to the list, but if that's not possible/desired, at least the option "Sum/Average" would need to be restored.
Comment 2 Cor Nouws 2011-11-21 06:10:44 UTC
for those interested, I came accross some related identifiers in
/svx/source/stbctrls/stbctrls.src
Comment 3 Crusader 2013-01-13 18:33:28 UTC
Is this valuable suggestion (which is > a year old) dead?

The ability to see multiple values of one's choosing on the status bar is of immense value and can only add a feather to LibreOffice's cap.

In the real world, these kinds of "small, non-life threatening" features make a big difference when office software adoption is considered.  Please don't let LibreOffice lose out!
Comment 4 Justin 2013-02-03 17:07:00 UTC
Created attachment 74147 [details]
screenshot example

This screen shot shows the implementation in Excel. Its excellent and useful every day.
Comment 5 Justin 2013-02-03 17:07:47 UTC
I really want this feature.
Comment 6 Cor Nouws 2013-02-03 20:34:53 UTC
(In reply to comment #5)
> I really want this feature.

thanks for the example.
If you really want this, pls think about how you would be able to help.
Cor
Comment 7 Justin 2013-02-03 22:10:16 UTC
Wish i was a programmer. I will be happy to test the feature in beta if someone codes it. Seems like a pretty easy enhancement if inwas a programmer :p
Comment 8 Prashant 2013-04-16 17:51:29 UTC
Hi,

I'd recently implemented 'Selection count' feature in the same list of selections : 'Sum', 'Count', ... 

I feel that having worked on it, I may find myself comfortable working on it. Can I get some pointers for the same please ?

Thanks and Regards,
Prashant
Comment 9 Nicolas 2013-06-26 19:56:14 UTC
*** Bug 66220 has been marked as a duplicate of this bug. ***
Comment 10 Edward 2014-04-29 23:49:11 UTC
Not sure how to vote for this, but does anyone know the status? Is this still not implemented due to lack of code contribution for it or lack of agreement that it should indeed be implemented?
Comment 11 Cor Nouws 2014-04-30 11:07:07 UTC
Hi,

(In reply to comment #10)
> Not sure how to vote for this, but does anyone know the status? Is this
> still not implemented due to lack of code contribution for it or lack of
> agreement that it should indeed be implemented?

I don't expect disagreement on this. It's just that developers work on different stuff atm. If you have a little experience: it's not that hard with help of other developers to start working on this..
Comment 12 Nikhil pushkaran 2014-11-22 06:07:13 UTC
Team,
I am working in a company which need to manage large volume of data.
For my case, I need count and sum at the same status bar.
Currently all are depending excel to manage the medium sized data,
If any one try to use libeO, there are certain difficulties to overcome like this.
This is one of those simple bugs to be fixed for libO spread sheet's smooth running.
I dont know why, you team is not working on this.
This is not a request, a prayer from spread sheet users.

Keenly waiting ,

Regargs;
Nikhil
India
919946609086
Comment 13 Björn Michaelsen 2014-11-28 09:42:16 UTC
(This is an automated message.)

LibreOffice development currently prioritizes bugs with the so called MAB (most annoying bugs) -- as this bug has not run through that process (including writing a short rationale for this bug being a candidate and other who are watching the tracker bug silently approving that rationale etc.) its priority is set to high. Note this is effectively no change in the urgency assigned to this bug, as we are currently not making a difference between high and highest and severity is untouched.

You can find out more about MABs and how the process works by contacting libreoffice qa on irc:

 http://webchat.freenode.net/?channels=libreoffice-qa

The QA wiki page also gives you hints on how to get in contact with the team (if IRC fails you, your next best choice is the mailing list):

 https://wiki.documentfoundation.org/QA
Comment 14 Valter Mura 2015-01-17 12:10:00 UTC
(In reply to Nicolás Adamo from comment #0)
> When selecting a range of cells, there's a sort of status bar to the left of
> the zoom slider where you can read by default the sum of the range. If you
> right click this text, you can choose wether to show the average, the count,
> max, min, etc. 
> This is great; the request I'm asking for is to show more than one of this
> indicators. On normal monitor resolutions there's space for adding aditional
> information, so I think joinig data strings is possible. Maybe the quickest
> way to develop this is to change the toogle box for a tick box, allowing the
> user to select more than one option.
> 
> That's all, thanks.

I'm not a programmer but a user, and I vote it as an important enhancement request.
Comment 15 Cor Nouws 2015-01-17 13:30:10 UTC
Hi all,

This is a very valuable enhancement request!

Is is an improvement compared to the original OpenOffice.org behaviour.
Therefore the version is set to "Inherited from OOo" The field shows the oldest version with the behaviour.
Pls don't change that value :)
Comment 16 Cor Nouws 2015-01-17 13:33:35 UTC
Hi Prashant,

(In reply to Prashant from comment #8)

> I'd recently implemented 'Selection count' feature in the same list of
> selections : 'Sum', 'Count', ... 

Thanks a lot for that :)
(I've been distracted for some time and missed this news)

> I feel that having worked on it, I may find myself comfortable working on
> it. Can I get some pointers for the same please ?

Do you still have time/interest :) ? Usually entering the developer list is the way to go. If needed.. I could help finding a contact, but that may be superfluous ;)

Regards,
Cor
Comment 17 Gabriele Ponzo 2015-01-19 20:52:03 UTC
I'm not a programmer anymore (unfortunately), but I'd like to see this feature implemented.

Could it be a good idea to insert it among "Easy Hacks"? Or it's not that so easy?

I know a coder wondering to join TDF…
Comment 18 cantanna 2015-01-20 16:20:11 UTC
nice.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.