Issue 42120

Summary: number of rows and columns showed for selections
Product: Calc Reporter: jborat <jboratynski>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P5 (lowest) CC: gleppert, issues, kamataki, stp, thomas.lendo, weigel
Version: OOo 1.1.4   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 15522    
Attachments:
Description Flags
Quantity of selected cells already implemented for formulas none

Description jborat 2005-02-05 13:59:00 UTC 
I think it would be very convenient if Calc showed number of rows and columns of 
a selected range. 
Currntly Calc reports this information when the user selects a range as an 
argument of a formula only (in a small yellow box at the bottom-right corner of 
the selected region).
It could be shown - as in Excel - in the box showing names of ranges etc.
Comment 1 frank 2005-02-11 12:23:25 UTC 
requirements
Comment 2 frank 2006-05-14 15:56:54 UTC 
*** Issue 65343 has been marked as a duplicate of this issue. ***
Comment 3 gleppert 2009-04-05 08:47:52 UTC 
Indeed, this would be a very handy addition. If you have to deal with large
spreadsheets, showing the number of rows and columns for the selection, improves
the usability.
Comment 4 Stefan Weigel 2009-09-17 22:18:37 UTC 
*** Issue 88718 has been marked as a duplicate of this issue. ***
Comment 5 lendo 2009-09-18 14:15:23 UTC 
i88718 had target milestone "3.x". Should this issue get the same milestone?

Suggestion text from i88718:
Extend the "Name Box" of the Formula Bar with quantity information when more
than one cell is selected. If the cells A4:A31 are selected, the Name Box should
show "A4:A31 (28)". If the cells B4:E31 are selected, the Name Box should show
"B4:E31 (28x4)".
Comment 6 lendo 2010-01-25 10:25:28 UTC 
Accidentally I found out that this feature is already implemented! But it's only
available for formula selections (see attached picture).

Is it possible to implement the same feature for "normal" selection in a simple
way or to just copy that code?

This small enhancement is really desired because manually counting of cells is
waste of time in our digitally world.

Steps to reproduce the availability of this feature in formula selection:
* Open a spreadsheet.
* Insert = in a cell.
* Make a selection. In the right bottom corner of the selection a tooltip
appears with the desired information (in German e.g. "5 Z x 2 S" for 5 rows and
2 colums).
Comment 7 lendo 2010-01-25 10:26:58 UTC 
Created attachment 67393 [details]
Quantity of selected cells already implemented for formulas