Bug 105811 - Enhancement to CELL() function
Summary: Enhancement to CELL() function
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsDevAdvice
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2017-02-06 22:24 UTC by Don Edwards
Modified: 2017-07-23 22:46 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Don Edwards 2017-02-06 22:24:20 UTC
What I really want is to be able to pass cell ranges (as opposed to the contents copied into arrays) around freely between Calc and Basic - but that would raise HUGE backward-compatibility issues, so I'm quite confident it won't happen.

(Before I switched to Linux I had rewritten a number of Excel's built-in functions that return the value of a cell, to instead return the cell.)

As a second choice, can the spreadsheet Cell() function be extended - or another function created - that will take a cell or range</b> and return its full name as a string? I don't want to just type the string, because =SomeFunctionOf(Cell("Range",A1:C5)) is a reference to the indicated cells and will be re-called if anything in the range changes; =SomeFunctionOf("Sheet1.A1:C5") is not.

Cell("Address",C5) does this but only for cells, not ranges, and won't include filename or sheetname unless they are included in the function call. A macro needs this information as well.
Comment 1 Carlos 2017-04-03 18:36:21 UTC
We need another function (to avoid causing incompatibilities with MS Excel), that works like the CELL function but accepts ranges or cell as the second argument. 
Perhaps it can be called RANGE. 

Perhaps not all InfoType will be relevant:
  *  TYPE
  *  WIDTH
  *  COLOR

I have set the bug's status to 'NEW'.