[Solved] Display average, sum and count in status bar

Discuss the spreadsheet application

[Solved] Display average, sum and count in status bar

Postby steve2000 » Tue Aug 10, 2010 8:38 pm

Hi all,

Is it possible to configure Calc to simultaneously display average, sum and count in status bar as this is available in Excel 2007? Currently I can select only either or...
Alternatively can anyone direct me to a extension with such capabilities?

Thanks,
Stefan
Last edited by steve2000 on Wed Aug 11, 2010 2:55 pm, edited 1 time in total.
OpenOffice 3.2 on Windows 7
steve2000
 
Posts: 7
Joined: Tue Aug 10, 2010 8:22 pm

Re: Simultaneously display average, sum and count in status

Postby Hagar Delest » Tue Aug 10, 2010 9:41 pm

Hi and welcome to the forum!

I've found that one: Issue 66663 - Provide more information in the status bar (like Excel). Not sure it applies to your request. Add a comment to the report or create another: [Tutorial] Reporting bugs or suggestions.
AOO 4.1.5 on Xubuntu 17.10 (Artful Aardvark) and on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 27995
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Simultaneously display average, sum and count in status

Postby Zizi64 » Tue Aug 10, 2010 10:57 pm

Here is a OOBasic based "workaround" macro code:

SAC.ods
(11.06 KiB) Downloaded 998 times


You can copy the macro code into MyMacro Standard library, and then you can associate it with a new menu item. (Customize toolbar option)

SAC.png
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.6 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.0.2 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6463
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

[Solved] Display average, sum and count in status bar

Postby steve2000 » Wed Aug 11, 2010 2:00 pm

Thanks Zizi64 for your feedback. That makro helped a lot.

Stefan
OpenOffice 3.2 on Windows 7
steve2000
 
Posts: 7
Joined: Tue Aug 10, 2010 8:22 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests