| View previous topic :: View next topic |
| Author |
Message |
cjalmeida
Newbie
Joined: 02 Aug 2004
Posts: 1
|
 Posted: Mon Jun 11, 2007 11:46 am Post subject: Follow cell reference |
 |
|
Another Excel-OOo migration question...
When I double-click a cell in excels which links to another spreadsheet, it automatically opens the referenced sheet.
Example: a cell containing
| Code: | | =file://c:/tmp/dest.xls!Sheet1.A2 |
. When I double-click it in Excel, the sheet Sheet1 in c:\tmp\dest.xls gets open.
Is there a way to emulate this behavior in OOo Calc? |
|
| Back to top |
|
 |
squenson
Super User
Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia
|
| Posted: Mon Jun 11, 2007 12:09 pm Post subject: |
|
|
cjalmeida,
Interesting question!
I tried to reproduce this behavior in Excel 2003, but when I double-click, I just get inside the cell in edit mode, it does not open the associated file. Which version of Excel do you have?
Anyway, I do not think this can be done, as OOo does not recognize the double-click AFAIK. And how to differentiate between a double-click to edit and a double-click to open the corresponding spreadsheet?
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<< |
|
| Back to top |
|
|
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Mon Jun 11, 2007 1:14 pm Post subject: |
|
|
I always set Excel (at work) to disable "edit directly in cell" (it's in Tools, Options), thus double-clicking selects the source cell(s) or source spreadsheet. I find it a quick and handy way to determine the source cells.
I miss such a feature in Calc. 
To edit, I use F2, and have for an embarrassingly long time....
Last edited by RickRandom on Tue Jun 12, 2007 1:23 am; edited 1 time in total |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Mon Jun 11, 2007 2:02 pm Post subject: |
|
|
=HYPERLINK("file://c:/tmp/dest.xls#Sheet1.A2" ; "Open Link")
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
