Bug 145482 - LibreOffice Calc: enable open column/open row notation
Summary: LibreOffice Calc: enable open column/open row notation
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 162203 (view as bug list)
Depends on:
Blocks: Calc-Enhancements
  Show dependency tree / graph
 
Reported: 2021-11-01 01:31 UTC by jackyguo579
Modified: 2024-07-26 04:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description jackyguo579 2021-11-01 01:31:51 UTC 
Description:
LibreOffice Calc already supports full column notation like this:
E:E 12:12

Google Sheets and Excel also support partial columns and rows. Example: B2:B means every cell in column B at or below B2, E5:5 means every cell in row 5 at or to the right of E5.

I'd like to see this added into LibreOffice.

Steps to Reproduce:
N/A

Actual Results:
N/A

Expected Results:
N/A


Reproducible: Always


User Profile Reset: No



Additional Info:
N/A
Comment 1 Mike Kaganski 2021-11-01 05:36:15 UTC 
(In reply to jackyguo579 from comment #0)
> Google Sheets and Excel also support partial columns and rows. Example: B2:B
> means every cell in column B at or below B2, E5:5 means every cell in row 5
> at or to the right of E5.

At least not Excel.
Comment 2 m_a_riosv 2024-07-26 00:00:39 UTC 
*** Bug 162203 has been marked as a duplicate of this bug. ***
Comment 3 Óvári 2024-07-26 00:17:45 UTC 
There are Google Sheets tutorials where this notation is referred to as "open row" and "open column".