Bug 162203 - Support open row/column notation in Calc like Google Sheets
Summary: Support open row/column notation in Calc like Google Sheets
Status: RESOLVED DUPLICATE of bug 145482
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-07-25 23:25 UTC by Óvári
Modified: 2024-07-26 00:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Open row and open column notation like Google Sheets (9.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-07-25 23:25 UTC, Óvári 		Details
View All 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 Óvári 2024-07-25 23:25:02 UTC 
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
Comment 1 Óvári 2024-07-25 23:25:31 UTC 
Created attachment 195523 [details]
Open row and open column notation like Google Sheets
Comment 2 m_a_riosv 2024-07-26 00:00:39 UTC 

*** This bug has been marked as a duplicate of bug 145482 ***