Can Cell content will displayed in comment box

Discuss the spreadsheet application

Can Cell content will displayed in comment box

Postby chandrankrishnan » Thu Apr 11, 2019 9:24 am

Hi,
I had some workouts in my spread sheet.Attached my work sheet for your reference

I have my activity sheet which number of persons x1,x2,x3.....

The activity of all x1,x2,x3... has to be mapped with date (in comment box ) of 1st may,2nd may .....so on.

By help of this forum i read an topic with insertion of comment with some text,where i am struggling to get the cell reference in comment box it allows only the text...

Any help by formula or macro program to get the comment with activity as shown in cell D3.

Thanks in advance
Attachments
Date Vs Activity.ods
(14.48 KiB) Downloaded 14 times
OpenOffice 4.1.2 windows vista
User avatar
chandrankrishnan
 
Posts: 63
Joined: Sat Mar 05, 2016 1:21 pm

Re: Can Cell content will displayed in comment box

Postby Zizi64 » Thu Apr 11, 2019 11:42 am

Use a helper cell range to store DATA instead of the comment box.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8213
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Can Cell content will displayed in comment box

Postby chandrankrishnan » Mon Apr 15, 2019 1:39 pm

Hi all,

Attached my sample sheet.

with help of this forum i had tried with some macro and formula to show the cell content in comment box.

Now i stucked up in macro(comment shows with cell address) which allows only one cell reference to show in comment box,whether it can be made to show with some more cell reference like E3:G3 & B4:G4 & B5:G5 & B6:G6 & B7:F7.
Also it does not allows me to call the cell reference form result sheet,so i need to call the result sheet into date sheet of reference as shown K2:Q2) to map with date.

Help me with macro or any ideas to complete the task.


Thanks in advance
Attachments
Date Vs Activity1.ods
(40.15 KiB) Downloaded 8 times
OpenOffice 4.1.2 windows vista
User avatar
chandrankrishnan
 
Posts: 63
Joined: Sat Mar 05, 2016 1:21 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 38 guests