| View previous topic :: View next topic |
| Author |
Message |
wachu13
Newbie
Joined: 14 Jan 2010
Posts: 2
|
 Posted: Thu Jan 14, 2010 10:31 am Post subject: Note? |
 |
|
Hi
I need something like "Note" but showing me informations from diferent sheet for example: =Sheet2.D12
What I need is that after I move mouse over the cell I need informations from another sheets but they will show only when I move mouse over that cell. I tryed Note but from what I can tell it's only work with simple text and I don't want to repeat informations which will change in another sheet.
Is there any way to do this? |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Thu Jan 14, 2010 1:52 pm Post subject: |
|
|
I rather doubt it, but I may just not understand the question. Are you entering something into the note or do you want the note to volunteer information about the cell references?
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
wachu13
Newbie
Joined: 14 Jan 2010
Posts: 2
|
| Posted: Thu Jan 14, 2010 2:35 pm Post subject: |
|
|
I have few sheets, in one (sheet1) lets say there are cells with names in second sheet (sheet2) there are many cells with diferent informations in. Now what I need is, when I'm in sheet1 and move mouse over cell D8 with name in I need to show up informations from lets say sheet2 cell B12.
I was thinking about Note and use "=Sheet2.B12" so when I move mouse over the cell D8 in sheet1 Note will show me what is in cell B12 in sheet2. But that dosn't work.
I need this way so the first sheet (sheet1) don't have too much informations, they are in sheet2, sheet3.... The second reason is that informations in sheet2, sheet3 will change so when I'm in sheet1 they will show me accurate informations. I want to sheet1 looks like preview, moving mouse over one cell will display little informations from another sheet and if I need more informations then click on that cell will jump do sheet2.
If I can't use Note to do this is there any diferent way to accomplish something like this? |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Sat Jan 16, 2010 10:16 am Post subject: |
|
|
| wachu13 wrote: | I have few sheets, in one (sheet1) lets say there are cells with names in second sheet (sheet2) there are many cells with diferent informations in. Now what I need is, when I'm in sheet1 and move mouse over cell D8 with name in I need to show up informations from lets say sheet2 cell B12.
I was thinking about Note and use "=Sheet2.B12" so when I move mouse over the cell D8 in sheet1 Note will show me what is in cell B12 in sheet2. But that dosn't work.
I need this way so the first sheet (sheet1) don't have too much informations, they are in sheet2, sheet3.... The second reason is that informations in sheet2, sheet3 will change so when I'm in sheet1 they will show me accurate informations. I want to sheet1 looks like preview, moving mouse over one cell will display little informations from another sheet and if I need more informations then click on that cell will jump do sheet2.
If I can't use Note to do this is there any diferent way to accomplish something like this? |
I believe I understand the problem but I don't have any idea if there is a solution. You might want to ask this in the Macros and API forum. I suspect that if there is a solution you would need to do some programming. Sorry not to be of more help.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
