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

steve2000 · Post by **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

Post by **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.

Post by **Zizi64** » Tue Aug 10, 2010 10:57 pm

Here is a OOBasic based "workaround" macro code:

SAC.ods: (11.06 KiB) Downloaded 1257 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)

steve2000 · Post by **steve2000** » Wed Aug 11, 2010 2:00 pm

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

Stefan