Source code for openpyxl.comments.comments

from __future__ import absolute_import
# Copyright (c) 2010-2017 openpyxl


[docs]class Comment(object): _parent = None def __init__(self, text, author): self.content = text self.author = author self.width = '108pt' self.height = '59.25pt' @property def parent(self): return self._parent def __eq__(self, other): return ( self.content == other.content and self.author == other.author ) def __repr__(self): return "Comment: {0} by {1}".format(self.content, self.author) def __copy__(self): """Create a detached copy of this comment.""" clone = self.__class__(self.content, self.author) clone.width = self.width clone.height = self.height return clone
[docs] def bind(self, cell): """ Bind comment to a particular cell """ if cell is not None and self._parent is not None and self._parent != cell: fmt = "Comment already assigned to {0} in worksheet {1}. Cannot assign a comment to more than one cell" raise AttributeError(fmt.format(cell.coordinate, cell.parent.title)) self._parent = cell
[docs] def unbind(self): """ Unbind a comment from a cell """ self._parent = None
@property def text(self): """ Any comment text stripped of all formatting. """ return self.content @text.setter def text(self, value): self.content = value