https://bugs.freedesktop.org/show_bug.cgi?id=71560
Priority: medium
Bug ID: 71560
Assignee: [email protected]
Summary: Other: Enhancement - Selecting entire row(s) or
column(s)
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
