In Calc, how can I create a MOBILE display cell that varies with the ‘selected cell’?
Fr me this would speed up data capture by typing considerably.
Purpose: to display emphatically the contents of another cell WITHOUT changing format of the sheet in general.
A simple example: Column B holds identifiers for each row.
eg Cell B1250 reads “Bill1234”
Cell B1251 reads “Bill1973” etc
Click on any cell in row 1250 to edit it.
A draggable ‘frame’ that is in large type will show “Bill1234”. This frame floats over the parent sheet somewhere near row n
So if I edit cell M1250, I KNOW I am editing Bill1234 record. No need to read along the row. Even with highlighting the row, this is prone to error and is s-l-o-w.
The frame could be
a) A comment ‘frame’ - content by a formula as for a cell.
or b) A new chart type to display the result of a formula as for a cell, (extension: a group of cells)
Either of these would need a function to define the present selected cell (and cope with multiple selections) eg SELCELL( ) giving the address or maybe SELROW or SELCOL.
So you could define the mobile cell content above as = INDIRECT(selrow(),“B”)
-----------------------------------------------------
There’s another valuable use of this function and frame. It would speed up finding which row to edit significantly.