Bug 71560

Summary: Other: Enhancement - Selecting entire row(s) or column(s)
Product: LibreOffice Reporter: Óvári <ovari123>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: enhancement CC: miguelangelrv
Priority: medium    
Version: 4.1.3.2 release   
Hardware: Other   
OS: Windows (All)   
Whiteboard: BSA
Crash report or crash signature: Regression By:

Description Óvári 2013-11-13 06:39:43 UTC 
Problem description: 
When typed into a cell, would D:D or $D:$D select the entire D column.
Likewise, would 4:4 or $4:$4 select the entire 4th row.

For example
=VLOOKUP(Sheet2.$D$3,Sheet4.$D1:$D1048576,1)
=VLOOKUP(Sheet2.$D$3,Sheet4.$D:$D,1)

These ranges can be used in other functions too.

This would be helpful as if rows are deleted, or the number of rows are increased in future versions of Calc, the end range will not need to be changed.

Thanks in advance.

Steps to reproduce:
1. =VLOOKUP(Sheet2.$D$3,Sheet4.$D:$D,1)
2. #NAME?

Current behavior:
#NAME?

Expected behavior:
Correct value returned, given by
=VLOOKUP(Sheet2.$D$3,Sheet4.$D1:$D1048576,1)
Operating System: Windows 7
Version: 4.1.3.2 release
Comment 1 m_a_riosv 2013-11-13 09:15:48 UTC 

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