https://bugs.documentfoundation.org/show_bug.cgi?id=162203
Bug ID: 162203
Summary: Support open row/column notation in Calc like Google
Sheets
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Support open row/column in Calc like Google Sheets
Steps to Reproduce:
1. In cell A3, type: =SUM(B3:C)
2. In cell E1, type: =SUM(G1:1)
Actual Results:
1. #NAME?
2. Err:502
Expected Results:
1. Should be functionally equivalent to =SUM(B3:C1048576), when there are
1048576 rows; programmatically equivalent to MAX_ROW
2. Should be functionally equivalent to =SUM(G1:XFD1), when there are XFD
columns; programmatically equivalent to MAX_COLUMN
Reproducible: Always
User Profile Reset: No
Additional Info:
Compatibility with Google Sheets and may provide better compatibility if the
MAX_ROW and MAX_COLUMN is varied.
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
