Copying values in status bar in Libre Calc.

[Shubhashish]

How to copy values in status bar in Libre Calc, like Average/Sum of a range of cells?

[cwolan]

Hello and welcome @Shubhashish

FTR:

• tdf#92479 – “Make info data in status bar cut-able” (filed in 2015)
• tdf#171872 – “Allow copy results from status bar” (filed this year)

[sokol92]

Until this enhancement request is implemented, we can use a macro (assign it to any convenient hotkey):

Sub ShowStat()
  Dim aNames, aFuncs, i as Long, s as String
  Dim oSel
  aNames = Array("Average", "Count", "CountNums", "Max", "Min", "Product", "Sum")
  With com.sun.star.sheet.GeneralFunction
    aFuncs = Array(.AVERAGE, .COUNT, .COUNTNUMS, .MAX, .MIN, .PRODUCT, .SUM)
  End With   
  
  On Error GoTo ErrLabel
  
  oSel = ThisComponent.CurrentSelection
  For i = 0 To UBound(aFuncs)
    s = IIf(i = 0, "", s & Chr(10)) & aNames(i) & ": " & oSel.computeFunction(aFuncs(i))   
  Next i
  
  Msgbox s
  
  Exit Sub 
  
ErrLabel:
End Sub

The contents of the Msgbox dialog box can be copied to the clipboard.

[Shubhashish]

@cwolan Thanks for letting me know. Let’s hope it will be out soon.

[Shubhashish]

@sokol92 how should I create a macro to use this code? Can you guide me.

[sokol92]

1. Place ShowStat macro in any module of the Standard library from “My Macro”
2. Customize Keyboard.