Issue 42120 - number of rows and columns showed for selections
Summary: number of rows and columns showed for selections
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.1.4
Hardware: All All
: P5 (lowest) Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 65343 88718 (view as issue list)
Depends on:
Blocks: 15522
  Show dependency tree
 
Reported: 2005-02-05 13:59 UTC by jborat
Modified: 2013-08-07 15:12 UTC (History)
6 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Quantity of selected cells already implemented for formulas (3.37 KB, image/png)
2010-01-25 10:26 UTC, lendo 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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