xutuan Zhang wrote:
But the dropdown Box does not accept range names in Calc,i.e., only
references of the cells/range. But Excel accepts both. This is probably
very easy to add.
"Cell range" in the validity dialog also accepts a named range.
Also, the "=INDIRECT( )" function does not accept range names in Calc
either.
Right, that's issue 4695.
And, how do you reference to the cell from one spreadsheet, say
book1.sxc, to another, say, book2.sxc? (e.g., if I want, A1 in
book1.sxc equals to A1 or even range names in book2.sxc)
='book2.sxc'#Sheet1.a1
This will be converted to the full path and an absolute sheet reference
at input. Or you can just type the = character, and click the cell in
the source document with the mouse. In both cases, a hidden linked sheet
is created.
Referencing named ranges from other documents is not supported.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
