ó –‰]c@@s¾ddlmZmZddlmZddlmZddlmZddlmZm Z ddl m Z ddl m Z mZmZmZde fd „ƒYZd efd „ƒYZd S( i(tabsolute_importtunicode_literals(tcopy(t safe_repr(tStrict(tMinMaxtSequence(t Serialisable(trange_boundariestrange_to_tupletget_column_lettertquote_sheetnamet CellRangecB@seZdZedddddeƒZedddddeƒZedddddeƒZedddddeƒZd%d%d%d%d%d%d„Z e d„ƒZ e d „ƒZ e d „ƒZe d „ƒZd „Zd „Zd„ZeZd„Zd„Zddd„Zd„Zd„Zd„ZeZd„Zd„ZeZd„Zd„Zd„Z d„Z!e!Z"d„Z#e#Z$d„Z%ddddd„Z&ddddd„Z'e d „ƒZ(e d!„ƒZ)e d"„ƒZ*e d#„ƒZ+e d$„ƒZ,RS(&uÜ Represents a range in a sheet: title and coordinates. This object is used to perform operations on ranges, like: - shift, expand or shrink - union/intersection with another sheet range, We can check whether a range is: - equal or not equal to another, - disjoint of another, - contained in another. We can get: - the size of a range. - the range bounds (vertices) - the coordinates, - the string representation, tminitmaxifGt expected_typeicC@së|dk rTd|kr9t|ƒ\}\}}}}qTt|ƒ\}}}}n||_||_||_||_||_||kr´d}t|j d|d|ƒƒ‚n||krçd}t|j d|d|ƒƒ‚ndS(Nu!u({max_col} must be greater than {min_col}tmin_coltmax_colu({max_row} must be greater than {min_row}tmin_rowtmax_row( tNoneR RRRRRttitlet ValueErrortformat(tselft range_stringRRRRRtfmt((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__init__1s  !      ! cC@s|j|j|j|jfS(u2 Vertices of the range as a tuple (RRRR(R((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytboundsGsc C@smd}|j|jkr3|j|jkr3d}n|jdt|jƒd|jdt|jƒd|jƒS(u9 Excel-style representation of the range u%{min_col}{min_row}:{max_col}{max_row}u{min_col}{min_row}RRRR(RRRRRR (RR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytcoordOs   cc@sYxRt|j|jdƒD]7}gt|j|jdƒD]}||f^q:VqWdS(u1 Return cell coordinates as rows iN(trangeRRRR(Rtrowtcol((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytrows`s cc@sYxRt|j|jdƒD]7}gt|j|jdƒD]}||f^q:VqWdS(u4 Return cell coordinates as columns iN(RRRRR(RR R((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytcolsis cC@sXt|tƒs*ttt|ƒƒƒ‚n|jrT|j|jkrTtdƒ‚ndS(u² Check whether comparisons between ranges are possible. Cannot compare ranges from different worksheets Skip if the range passed in has no title. u1Cannot work with ranges from different worksheetsN(t isinstanceR t TypeErrortreprttypeRR(Rtother((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt _check_titlerscC@sFd}|jrd}nt|jd|jjd|jd|jƒƒS(Nu<{cls} {coord}>u<{cls} {title!r}!{coord}>tclsRR(RRRt __class__t__name__R(RR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__repr__s  cC@sCd}|j}|r*d}t|ƒ}n|jd|d|jƒS(Nu{coord}u{title}!{coord}RR(RR RR(RRR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt_get_range_string†s  cC@s|jƒ}t|ƒS(N(R-R(RR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__str__‘s c C@s7|jd|jd|jd|jd|jd|jƒS(NRRRRR(R*RRRRR(R((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__copy__–sicC@s|j|dks&|j|dkrAtdj||ƒƒ‚n|j|7_|j|7_|j|7_|j|7_dS(u{ Shift the focus of the range according to the shift values (*col_shift*, *row_shift*). :type col_shift: int :param col_shift: number of columns to be moved by, can be negative :type row_shift: int :param row_shift: number of rows to be moved by, can be negative :raise: :class:`ValueError` if any row or column index < 1 iu1Invalid shift value: col_shift={0}, row_shift={1}N(RRRRRR(Rt col_shiftt row_shift((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytshiftœs cC@sly|j|ƒWntk r%tSX|j|jkpk|j|jkpk|j|jkpk|j|jkS(uÏ Test whether the ranges are not equal. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* != *other*. (R(RtTrueRRRR(RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__ne__°s cC@s|j|ƒ S(uË Test whether the ranges are equal. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* == *other*. (R4(RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__eq__ÅscC@so|j|ƒ|j|jko;|jko;|jknon|j|jkol|jkol|jkSS(uâ Test whether every cell in this range is also in *other*. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* <= *other*. (R(RRRR(RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytissubsetÐs 3cC@s|j|ƒo|j|ƒS(ué Test whether *other* contains every cell of this range, and more. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* < *other*. (t__le__R4(RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__lt__ãscC@so|j|ƒ|j|jko;|jko;|jknon|j|jkol|jkol|jkSS(uõ Test whether every cell in *other* is in this range. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* >= *other* (or *other* in *range*). (R(RRRR(RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt issupersetîs 3cC@s:|j|ƒ}|jdkr-|j|_n|j|ƒS(uO Check whether the range contains a particular cell coordinate N(R*RRR9(RRtcr((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt __contains__scC@s|j|ƒo|j|ƒS(ué Test whether this range contains every cell in *other*, and more. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range :return: ``True`` if *range* > *other*. (t__ge__R4(RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__gt__ scC@sc|j|ƒ|j|jkr/||}}n|j|jkpb|j|jkpb|j|jkS(uV Return ``True`` if this range has no cell in common with *other*. Ranges are disjoint if and only if their intersection is the empty range. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range. :return: ``True`` if the range has no cells in common with other. (R(RRRRR(RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt isdisjoints c C@s|j|ƒr*tdj||ƒƒ‚nt|j|jƒ}t|j|jƒ}t|j|jƒ}t|j|jƒ}t d|d|d|d|ƒS(uN Return a new range with cells common to this range and *other* :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range. :return: the intersecting sheet range. :raise: :class:`ValueError` if the *other* range doesn't intersect with this range. uRange {0} doesn't intersect {0}RRRR( R>RRRRR RRRR (RR'RRRR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt intersection*s c C@s‰|j|ƒt|j|jƒ}t|j|jƒ}t|j|jƒ}t|j|jƒ}td|d|d|d|d|jƒS(u Return the minimal superset of this range and *other*. This new range will contain all cells from this range, *other*, and any additional cells required to form a rectangular ``CellRange``. :type other: openpyxl.worksheet.cell_range.CellRange :param other: Other sheet range. :return: a ``CellRange`` that is a superset of this and *other*. RRRRR( R(R RRRRRR R(RR'RRRR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytunionBs cc@sDx=|jD]2}|dkr"q nt||ƒ}||fVq WdS(uC For use as a dictionary elsewhere in the library. utitleN(t __attrs__tgetattr(Rtxtv((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__iter__Xs  cC@s@|j|8_|j|8_|j|7_|j|7_dS(u¦ Expand the range by the dimensions provided. :type right: int :param right: expand range to the right by this number of cells :type down: int :param down: expand range down by this number of cells :type left: int :param left: expand range to the left by this number of cells :type up: int :param up: expand range up by this number of cells N(RRRR(Rtrighttdowntlefttup((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytexpandcs cC@s@|j|7_|j|7_|j|8_|j|8_dS(uÀ Shrink the range by the dimensions provided. :type right: int :param right: shrink range from the right by this number of cells :type down: int :param down: shrink range from the top by this number of cells :type left: int :param left: shrink range from the left by this number of cells :type up: int :param up: shrink range from the bottown by this number of cells N(RRRR(RRFtbottomRHttop((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytshrinkvs cC@s:|jd|j}|jd|j}i|d6|d6S(uC Return the size of the range as a dictionary of rows and columns. iucolumnsurows(RRRR(RR"R!((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytsize‰scC@s3gt|j|jdƒD]}|j|f^qS(u=A list of cell coordinates that comprise the top of the rangei(RRRR(RR ((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyRL‘scC@s3gt|j|jdƒD]}|j|f^qS(u@A list of cell coordinates that comprise the bottom of the rangei(RRRR(RR ((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyRK—scC@s3gt|j|jdƒD]}||jf^qS(uCA list of cell coordinates that comprise the left-side of the rangei(RRRR(RR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyRHscC@s3gt|j|jdƒD]}||jf^qS(uDA list of cell coordinates that comprise the right-side of the rangei(RRRR(RR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyRF£sN(-R+t __module__t__doc__RtintRRRRRRtpropertyRRR!R"R(R,R-t __unicode__R.R/R2R4R5R6R7R8R9R<R;R=R>R?t__and__R@t__or__RERJRMRNRLRKRHRF(((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyR sP             tMultiCellRangecB@s’eZedeƒZd d„Zd„Zd„Zd„ZeZ d„Z d„Z d„Z d„Z d „ZeZd „Zd „Zd „ZRS(RcC@sDt|tƒr7g|jƒD]}t|ƒ^q}n||_dS(N(R#tstrtsplitR tranges(RRYtr((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyR¯s(cC@s(x!|jD]}||kr tSq WtS(N(RYR3tFalse(RRRZ((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyR;µs cC@sAdjg|jD]}t|ƒ^qƒ}dj|jj|ƒS(Nu u <{0} [{1}]>(tjoinRYRWRR*R+(RRZRY((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyR,¼s+cC@s/djg|jD]}t|ƒ^qƒ}|S(Nu (R\RYRW(RRZRY((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyR.Ás+cC@std}t|tƒr'|}|j}n||krp|dkrNt|ƒ}n|j}|j|ƒ||_ndS(u4 Add a cell coordinate or CellRange N(RR#R RRYtappend(RRR:RY((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pytaddÈs     cC@s|j|ƒ|S(N(R^(RR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__iadd__Øs cC@s1t|tƒr!|j|ƒ}n|j|jkS(N(R#RWR*RY(RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyR5ÝscC@s ||k S(N((RR'((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyR4ãscC@s t|jƒS(N(tboolRY(R((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyt__bool__çscC@s2t|tƒst|ƒ}n|jj|ƒdS(N(R#R RYtremove(RR((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyRbíscc@sx|jD] }|Vq WdS(N(RY(RR:((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyREóscC@s7tƒ}x'|jD]}|jjt|ƒƒqW|S(N(RVRYR]R(RtnRZ((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyR/øs ((R+RORR RYRR;R,R.RSR^R_R5R4Rat __nonzero__RbRER/(((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyRV©s           N(t __future__RRRtopenpyxl.compat.stringsRtopenpyxl.descriptorsRRRt!openpyxl.descriptors.serialisableRtopenpyxl.utilsRR R R R RV(((s<lib/python2.7/site-packages/openpyxl/worksheet/cell_range.pyts"ÿ—