Bug 154304 - [Feature request] - Display "Count" same as MS Excel
Summary: [Feature request] - Display "Count" same as MS Excel
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.3 release
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-03-21 09:30 UTC by spkatsi
Modified: 2023-03-21 10:41 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description spkatsi 2023-03-21 09:30:42 UTC
Description:
Hello all,

An important MS Excel feature is missing from Libre Calc.

While Selecting a number of cells, you get the following info shown bottom right of the screen.

MS Excel  : AVERAGE, SUM, COUNT

Libre Calc: AVERAGE, SUM but missing the "COUNT" 

Steps to Reproduce:
1. Fill some cells with numbers or text
2. Select them

Actual Results:
Bottom right will only show "Average" and "Sum" for cells with number

Expected Results:
will not see the "Count" for cells with either text or number, excluding blank.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Experienced users can use workarounds for a slight productivity loss.
Comment 1 Mike Kaganski 2023-03-21 10:41:20 UTC
Try right-cluicking the "sum + average" indicator in the status bar, and select whatever you need.