Bug 149871 - Menu for define / view cell ranges on a worksheet
Summary: Menu for define / view cell ranges on a worksheet
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.4.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Calc-UX
  Show dependency treegraph
 
Reported: 2022-07-05 17:25 UTC by Ramon Tavarez
Modified: 2022-08-23 07:54 UTC (History)
2 users (show)

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 Ramon Tavarez 2022-07-05 17:25:45 UTC
Description:
Create a new menu to define, view, edit and delete ranges of cells:
Enhancement asked to make easier hide or show range of cells (rows and/or columns) on worksheets.
With this tool, several ranges of visible cells can be predefined on the same worksheet to use according to the user's requirement, without having to repeat, manually, the process of showing or hiding the rows and/or columns that you need visible.

Actual Results:
doesn't exist

Expected Results:
on FORMAT menu:
Format-> View Range -> Define (to define the range of cells to view on screen)
                    -> Call (to activate the rage of cells to use for work)
                    -> Edit (to hide or show ranges of cells on a defined range)
                    -> Clear (to delete a defined range of cells)


Reproducible: Always


User Profile Reset: No



Additional Info:
Something similar to the  Print range's tool, But only to predefine a visible cell ranges to work.
Comment 1 m_a_riosv 2022-07-05 22:06:57 UTC Comment hidden (off-topic)
Comment 2 Roman Kuznetsov 2022-07-09 09:26:59 UTC
Ramon do you want the fast way to change a spreadsheet view on the screen from A1:O35 to AL450:AZ480? 
Or you want automatic changes the grouping status for columns/rows?
Comment 3 Ramon Tavarez 2022-07-12 12:22:38 UTC
(In reply to Roman Kuznetsov from comment #2)
> Ramon do you want the fast way to change a spreadsheet view on the screen
> from A1:O35 to AL450:AZ480? 
> Or you want automatic changes the grouping status for columns/rows?

Hi.
My request is about a fast way to change a spreadsheet view, a way of change the range of cells (rows and columns) to view and work through the option of using a range of visible cells named.
Comment 4 QA Administrators 2022-07-13 03:31:06 UTC Comment hidden (obsolete)
Comment 5 Roman Kuznetsov 2022-07-27 16:09:00 UTC
UX-team, what do you think here?
Comment 6 Eike Rathke 2022-07-28 09:12:44 UTC
I don't see what a menu would do better (or easier) that the Name Box already does, except maybe what the request calls "Edit" (which it isn't) to hide/show columns or rows of a range; click or Shift+Ctrl+T to focus, then
* type in a cell range reference and hit Enter to mark/select that
* define a new name for a marked/selected cell range by typing it in
* type in an already defined named range to select its cells, or choose from listed named ranges

Apart from that, the Format menu would not be the right place as it is not formatting. More likely under Edit, as there is already the Select entry.
Comment 7 Ramon Tavarez 2022-07-28 15:48:22 UTC
(In reply to Eike Rathke from comment #6)
> I don't see what a menu would do better (or easier) that the Name Box
> already does, except maybe what the request calls "Edit" (which it isn't) to
> hide/show columns or rows of a range; click or Shift+Ctrl+T to focus, then
> * type in a cell range reference and hit Enter to mark/select that
> * define a new name for a marked/selected cell range by typing it in
> * type in an already defined named range to select its cells, or choose from
> listed named ranges
> 
> Apart from that, the Format menu would not be the right place as it is not
> formatting. More likely under Edit, as there is already the Select entry.

The request is about show/hide cells in an easier way, not  about define a NAME (already included).
Comment 8 Eike Rathke 2022-07-29 13:40:43 UTC
Maybe I just don't understand. What do you call "show/hide cells"? Hide/Show is available for entire columns or rows only. What exactly should happen with "Edit (to hide or show ranges of cells on a defined range)" and "Call (to activate the rage of cells to use for work)"?
Comment 9 Heiko Tietze 2022-08-01 10:21:16 UTC
(In reply to Eike Rathke from comment #8)
> Maybe I just don't understand.

Me neither.

(In reply to Ramon Tavarez from comment #0)
> Something similar to the  Print range's tool, But only to predefine a
> visible cell ranges to work.

You cannot hide cells, only rows or columns.