Cell comments

Feb 5, 2011 at 6:55 PM

Hello, 

 

How to access cell comments?! create/update or delete them?!

 

Thanks

 

 

Coordinator
Feb 6, 2011 at 2:12 AM

Cell comments are not implemented yet.

Developer
Aug 11, 2011 at 10:34 AM

Manuel,

Have you had a chance to implement working with cell comments since that post in February? If not, do you have any plans to get to it any time soon? Perhaps I could help with some coding, if you can provide necessary assistance with understanding your framework.

Thanks,
Fyodor

Coordinator
Aug 12, 2011 at 8:22 PM

I have even less time right now so all I can do is fix bugs and add small things to the library. Someone is helping me implement pivot tables though. I provide him with the interface I want and he's making the implementation.

If you want we could do the same for comments (I provide you with the interface and you implement it). Let me know if you're interested.

-Manuel

Developer
Aug 12, 2011 at 9:33 PM
Edited Aug 25, 2011 at 11:10 AM
I certainly understand you not having enough time for maintaining such a comprehensive library. Glad you have time at all :)
And why not. On the surface it sounds like comments should be quite straightforward to implement. Let's give it a shot with your interface approach.
Coordinator
Aug 12, 2011 at 10:08 PM

Cool. I'll prepare the interface for you and shoot you a PM...

Thanks for the help.

Developer
Aug 25, 2011 at 11:12 AM

Manuel,

Our small development team put together some code to provide basic ability to add cell comments. Let me know what would be the best way to pass it to you and have you integrate it into your next build.

Developer
Aug 25, 2011 at 11:12 AM
Edited Aug 25, 2011 at 11:12 AM

You have my email address, I believe. Feel free to contact me there.

Nov 24, 2011 at 8:53 AM

Hello,

I'm desperately looking for a way to create excel sheets with cell comments..

Is this possible today?

=

Current
ClosedXML 0.60.0
Date
Mon Nov 7 2011 at 9:00 AM
Coordinator
Nov 24, 2011 at 10:03 AM

I'll check in a version that will let you add comments later today...

Nov 25, 2011 at 7:50 AM
Edited Nov 25, 2011 at 7:50 AM

That would be so perfect!

I've been struggling with this for a while now, using "NPOI".. But a sheet full of comments: they (comments) become all visible.. Looks horrible... And using a template with macro to hide them is a last resort...

Coordinator
Nov 25, 2011 at 10:32 PM

Okay, download the latest check-in. It will let you create comments. Keep in mind that it's halfway done so there will probably be things that don't work. If you need anything let me know and I'll implement it as needed. Right now you can add the comments like the following:

            var wb = new XLWorkbook();
            var ws = wb.Worksheets.Add("Sheet1");
            var c = ws.FirstCell().Comment;
            c.AddText("Author's Comments:").SetBold();
            c.AddNewLine();
            c.AddText("None that matters.");
            c.Visible = false;
Note: Here I only use .SetBold() but you can set any font property accordingly.

Jan 5, 2012 at 4:24 PM
Edited Jan 5, 2012 at 4:29 PM

Not work for me... something wrong???

 

EDITED:

After download last version 0.61.0. Its works!!!!