https://bugs.documentfoundation.org/show_bug.cgi?id=106278
Bug ID: 106278
Summary: Worksheet Comment Parent is Nothing, expecting a Range
object of associated cell
Product: LibreOffice
Version: 5.2.5.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: metaxis+libreoff...@gmail.com
Description:
Comment objects do not have a Parent property defined. It should be a Range
object of the comment's associated cell. Without that, it is very difficult to
do useful work. For instance iterating over ActiveSheet.Comments becomes
useless, as you can't where the comments are or what cell contents each relates
to. Same behavior on 5.2.5.1 and 5.3.0.3
Steps to Reproduce:
1. have a worksheet with one or more comments.
2. get a comment object - eg: comment = ActiveSheet.Comments(1)
3. MsgBox typeName(comment.Parent)
Actual Results:
"Nothing"
Expected Results:
"Range"
Reproducible: Always
User Profile Reset: No
Additional Info:
Further example: ActiveSheet.Comments(1).Parent.Parent.Name should return the
name of the current Sheet. Looks like Range.Parent isn't wired up either. I
must be doing this wrong.
"Function CommentFrom(r As Range)" is trivial but "Sub
ExtractAllCommentsToTheRight()" is impossible.
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/56.0.2924.87 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs