Issue 105444

Summary:	It would be nice to use a full column (or row) as parameter
Product:	Calc	Reporter:	leprevost <michel.leprevost>
Component:	programming	Assignee:	AOO issues mailing list <issues>
Status:	CLOSED DUPLICATE	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	damjan, elish, issues, jbf.faure, muthukumarti
Version:	OOo 3.0.1
Target Milestone:	---
Hardware:	PC
OS:	Windows, all
Issue Type:	ENHANCEMENT	Latest Confirmation in:	4.1.0-dev
Developer Difficulty:	---

Description leprevost 2009-09-29 11:01:24 UTC

The users of this other spreadsheet application are used to apply functions 
(in cells)like RechercheV or RechercheH on ful column and they are used to 
write simply $B as parameter or A:F. When they use calc they have to precise 
B$1:B$65535 or A$1:F$65535 to be sure they get the same result.
It would be nice to have the same expression available for calc.
Best regards.
MLP

Comment 1 Edwin Sharp 2013-12-20 12:41:36 UTC

Useful enhancement.

Comment 2 Edwin Sharp 2014-01-16 12:48:09 UTC

*** Issue 93265 has been marked as a duplicate of this issue. ***

Comment 3 damjan 2015-12-11 13:04:37 UTC

Duplicate of 20495.

*** This issue has been marked as a duplicate of issue 20495 ***