Issue 104102 - increased flexibility of ADDRESS function
Summary: increased flexibility of ADDRESS function
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO310m11
Hardware: Other All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-08-08 10:57 UTC by risch
Modified: 2014-01-15 18:39 UTC (History)
2 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 risch 2009-08-08 10:57:56 UTC
Currently, ADDRESS(row; column; mode; sheet) accepts the following arguments

row: number, specifying the row; works also, if number is entered as string
column: number (not a letter) specifying the column
mode: (an optional number) determines whether the cell address is absolute or 
relative
sheet: (optional) text string specifying the sheet

I suggest that ADDRESS performs a type evaluation of the arguments column and 
sheet:
-if column is a string, ADDRESS should try to interpret it as a column name, 
calculating automatically the corresponding index
-if sheet is entered as a number, ADDRESS should try to interpret it as a sheet 
index, calculating automatically the corresponding sheet name
Comment 1 Edwin Sharp 2014-01-15 18:39:43 UTC
Column should be accepted as letter.
I am against the proposed change regarding Sheet.