o g@s|ddlZddlmZddlmZmZddlmZddlm Z ddl m Z Gdd d e Z Gd d d eZ Gd d d e ZdS)N) Serialisable)IntegerSequence) MergedCell)Border) CellRangecs6eZdZdZejZdZ dfdd ZddZ Z S) MergeCell mergeCell)refNcst|dSN)super__init__)selfr  __class__R/var/www/html/api-tag/env/lib/python3.10/site-packages/openpyxl/worksheet/merge.pyrszMergeCell.__init__cCs ||jSr )rr rrrr__copy__s zMergeCell.__copy__r ) __name__ __module__ __qualname__tagnamercoordr __attrs__rr __classcell__rrrrr sr c@sFeZdZdZeddZeedZdZ dZ  d d d Z e d d ZdS) MergeCells mergeCellsT) allow_none) expected_typer )countNrcCs ||_dSr r!)rr"r rrrr-s zMergeCells.__init__cCs t|jSr )lenr rrrrr"4s zMergeCells.count)Nr) rrrrrr"rr r __elements__rrpropertyrrrrr#s   rcs@eZdZdZfddZddZddZdd Zd d ZZ S) MergedCellRangea MergedCellRange stores the border information of a merged cell in the top left cell of the merged cell. The remaining cells in the merged cell are stored as MergedCell objects and get their border information from the upper left cell. cs&||_tj|dd|_|dS)N) range_string)wsr r start_cell _get_borders)r worksheetrrrrrBs zMergedCellRange.__init__cCs~|jj|j|jf|_|jdur|jj|j|jd|_|jj|j|jf}|dur=|jj t |j j |j j d7_ dSdS)a If the upper left cell of the merged cell does not yet exist, it is created. The upper left cell gets the border information of the bottom and right border from the bottom right cell of the merged cell, if available. Nrowcolumn)rightbottom) r(_cellsgetmin_rowmin_colr)cellmax_rowmax_colborderrr/r0)rend_cellrrrr*Is zMergedCellRange._get_bordersc Csgd}|D]J}t|jj|}|r|jdurqtdi||i}t||D]*}|jj|}|durH|\}}t|j||d}||jj|j |j f<|j|7_q%q|jj du} | r`t |jj } |j D](}|jj|}|dur|\}}t|j||d}||jj|j |j f<| r| |_ qcdS)a  Each cell of the merged cell is created as MergedCell if it does not already exist. The MergedCells at the edge of the merged cell gets its borders from the upper left cell. - The top MergedCells get the top border from the top left cell. - The bottom MergedCells get the bottom border from the top left cell. - The left MergedCells get the left border from the top left cell. - The right MergedCells get the right border from the top left cell. )topleftr/r0Nr,r)getattrr)r8stylerr(r1r2rr-r. protectioncopycells) rnamesnamesider8rr5r-col protectedr>rrrformat]s6  zMergedCellRange.formatcCs|t|jvSr )rr)rrrrr __contains__szMergedCellRange.__contains__cCs||j|jSr )rr(rrrrrrszMergedCellRange.__copy__) rrr__doc__rr*rFrGrrrrrrr&9s +r&)r?!openpyxl.descriptors.serialisableropenpyxl.descriptorsrropenpyxl.cell.cellropenpyxl.styles.bordersr cell_rangerr rr&rrrrs