Issue 105444 - It would be nice to use a full column (or row) as parameter
Summary: It would be nice to use a full column (or row) as parameter
Status: CLOSED DUPLICATE of issue 20495
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.0.1
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 93265 (view as issue list)
Depends on:
Blocks:
 
Reported: 2009-09-29 11:01 UTC by leprevost
Modified: 2017-05-20 09:53 UTC (History)
5 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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 ***