If you have a new account but are having problems posting or verifying your account, please email us on [email protected] for help. Thanks :)
Hello All, This is just a friendly reminder to read the Forum Charter where you wish to post before posting in it. :)
Hi all, The AutoSave Draft feature is now disabled across the site. The decision to disable the feature was made via a poll last year. The delay in putting it in place was due to a bug/update issue. This should serve as a reminder to manually save your drafts if you wish to keep them. Thanks, The Boards Team.
Hello all! This is just a quick reminder to ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere.

Obtaining contents of a comment in LibreOffice Calc

  • 30-12-2022 3:08pm
    Registered Users Posts: 7,092 ✭✭✭ funkey_monkey


    Got some spreadsheets that have cells with information stored in the comments. Is there a formula/function that I can use which will extract the text from the comment and populate it into a cell?

    There is too much to undertake manually.



  • Moderators, Technology & Internet Moderators Posts: 1,326 Mod ✭✭✭✭ croo

    DId you find a function @funkey_money?

    If not you can add a macro/function that does it

    REM Example to read a cells comments
    Function myReadComment(incell As Variant) As String
    		myReadComment = ThisComponent.CurrentController.ActiveSheet.getCellRangeByName(incell).getAnnotation().getString()
    End Function

    To use it to get the comments of cell A1 use


  • Registered Users Posts: 7,092 ✭✭✭ funkey_monkey

    @croo - no I didn't, but thanks for that. I'll store it off for next time.