B
    ÔùÓ`­"  ã               @   sî   d dl m Z  d dlmZ d dlmZmZmZ d dlmZ d dl	m
Z
mZmZmZmZmZ d dlmZ d dlmZ d dlmZ d d	lmZ G d
d„ deeƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZG dd„ deƒZdS )é    )Úcopy)Úsafe_string)Úget_column_intervalÚcolumn_index_from_stringÚrange_boundaries)ÚDEFAULT_COLUMN_WIDTH)ÚIntegerÚFloatÚBoolÚStrictÚStringÚAlias)ÚSerialisable)ÚStyleableObject)ÚBoundDictionary)ÚElementc                   sb   e Zd ZdZdZeƒ Zeƒ Zedd�Z	e
dƒZeƒ Ze
dƒZd‡ fdd	„	Zd
d„ Zdd„ Z‡  ZS )Ú	Dimensionz<Information about the display properties of a row or column.)ÚhiddenÚoutlineLevelÚ	collapsedT)Ú
allow_noner   Ústyle_idNc                s0   t t| ƒj||d� || _|| _|| _|| _d S )N)ZsheetZstyle_array)Úsuperr   Ú__init__Úindexr   r   r   )Úselfr   r   r   r   Ú	worksheetÚvisibleÚstyle)Ú	__class__© úA/tmp/pip-unpacked-wheel-zhp1095k/openpyxl/worksheet/dimensions.pyr   (   s
    zDimension.__init__c             c   s2   x,| j D ]"}t| |d ƒ}|r|t|ƒfV  qW d S )N)Ú
__fields__Úgetattrr   )r   ÚkeyÚvaluer    r    r!   Ú__iter__1   s    zDimension.__iter__c             C   s8   |   | j¡}| j}| j|d< |jf |Ž t| jƒ|_|S )Nr   )Ú__new__r   Ú__dict__Úparentr   r   Ú_style)r   ÚcpÚattribr    r    r!   Ú__copy__8   s    
zDimension.__copy__)TN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__r"   r   r   r
   r   r   r   Úoutline_levelr   r   r   r&   r-   Ú__classcell__r    r    )r   r!   r      s   
r   c                   sr   e Zd ZdZejd ZedƒZedƒZe	dd�Z
edƒZeƒ Zeƒ Zd‡ fdd„	Zedd„ ƒZedd„ ƒZ‡  ZS )ÚRowDimensionz2Information about the display properties of a row.)ÚhtÚcustomFormatÚcustomHeightÚsÚthickBotÚthickTopr   r   T)r   r5   r   NFc                sd   |d k	r|}|d k	r|}|| _ |d k	r,| }|	d k	r8|	}|| _|| _tt| ƒj||||
||d� d S )N)r   )r5   r9   r:   r   r4   r   )r   r   r   r5   r7   r8   r6   r   r   r2   r   r   ÚheightÚrZspansr9   r:   Úkw)r   r    r!   r   M   s    zRowDimension.__init__c             C   s   | j S )z+Always true if there is a style for the row)Z	has_style)r   r    r    r!   r6   n   s    zRowDimension.customFormatc             C   s
   | j dk	S )z,Always true if there is a height for the rowN)r5   )r   r    r    r!   r7   s   s    zRowDimension.customHeight)r   NNNNFr   NFNNNNNN)r.   r/   r0   r1   r   r"   r   r<   r8   r	   r5   r;   r
   r9   r:   r   Úpropertyr6   r7   r3   r    r    )r   r!   r4   A   s2   

              r4   c                   s–   e Zd ZdZeƒ Zeƒ ZedƒZ	e
ƒ Zedd�Zedd�Zeƒ Zejd Zdedddd	dd	d	d	dd	d	f‡ fd
d„	Zedd„ ƒZdd„ Zdd„ Z‡  ZS )ÚColumnDimensionz5Information about the display properties of a column.ÚbestFitT)r   )Úwidthr@   ÚcustomWidthr   ÚminÚmaxÚAFr   Nc                sd   || _ |
| _|| _|d k	r | }|d k	r,|}|| _|d k	r>|}|| _tt| ƒj||||||	d� d S )N)r   )rA   rC   rD   r@   r   r   r?   r   )r   r   r   rA   r@   r   r   r2   r   r   rC   rD   rB   r   Ú	auto_size)r   r    r!   r   ‡   s    zColumnDimension.__init__c             C   s
   t | jƒS )z.Always true if there is a width for the column)ÚboolrA   )r   r    r    r!   rB   ¥   s    zColumnDimension.customWidthc             C   s&   t | j| jgƒs"t| jƒ | _| _dS )z6
        Set boundaries for column definition
        N)ÚallrC   rD   r   r   )r   r    r    r!   Úreindex«   s    zColumnDimension.reindexc             C   s&   t | ƒ}| ¡ ddhkr"td|ŽS d S )NrC   rD   Úcol)rJ   )ÚdictÚkeysr   )r   Úattrsr    r    r!   Úto_tree³   s    zColumnDimension.to_tree)r.   r/   r0   r1   r	   rA   r
   r@   r   rF   r   r   r   rC   rD   r   r   r"   r   r   r>   rB   rI   rN   r3   r    r    )r   r!   r?   y   s2   


r?   c                   s4   e Zd ZdZd‡ fdd„	Zddd	„Zd
d„ Z‡  ZS )ÚDimensionHolderz%
    Allow columns to be grouped
    r   Nc                s(   || _ d | _|| _tt| ƒ ||¡ d S )N)r   Úmax_outlineÚdefault_factoryr   rO   r   )r   r   Ú	referencerQ   )r   r    r!   r   ¾   s    zDimensionHolder.__init__é   Fc       	      C   s¶   |dkr|}t |  ¡ tƒrt| | }||_||_t||ƒdd… }x|D ]}|| krF| |= qFW tt||fƒ\|_|_	n>t |  ¡ t
ƒr²x.t||d ƒD ]}| jj| }||_||_q’W dS )aT  allow grouping a range of consecutive rows or columns together

        :param start: first row or column to be grouped (mandatory)
        :param end: last row or column to be grouped (optional, default to start)
        :param outline_level: outline level
        :param hidden: should the group be hidden on workbook open or not
        NrS   )Ú
isinstancerQ   r?   r2   r   r   Úmapr   rC   rD   r4   Úranger   Zrow_dimensions)	r   ÚstartÚendr2   r   Znew_dimZwork_sequenceZcolumn_letterÚelr    r    r!   ÚgroupÅ   s     

zDimensionHolder.groupc             C   st   dd„ }t dƒ}tƒ }x>t|  ¡ |d�D ]*}| ¡ }|d k	r(| |j¡ | |¡ q(W |rdt|ƒ| _	t
|ƒrp|S d S )Nc             S   s   |   ¡  | jS )N)rI   rC   )r%   r    r    r!   Úsorterâ   s    z'DimensionHolder.to_tree.<locals>.sorterÚcols)r$   )r   ÚsetÚsortedÚvaluesrN   Úaddr   ÚappendrD   rP   Úlen)r   r[   rY   ZoutlinesrJ   Úobjr    r    r!   rN   à   s    
zDimensionHolder.to_tree)r   N)NrS   F)r.   r/   r0   r1   r   rZ   rN   r3   r    r    )r   r!   rO   ¹   s   
rO   c            	   @   sp   e Zd ZdZedd�Zedd�Zeƒ Ze	dd�Z
e	dd�Ze	dd�Ze	dd�Zedd�Zedd�Zd	dd„ZdS )
ÚSheetFormatPropertiesZsheetFormatPrT)r   é   Né   c
       
      C   s:   || _ || _|| _|| _|| _|| _|| _|| _|	| _d S )N)	ÚbaseColWidthÚdefaultColWidthÚdefaultRowHeightr7   Ú
zeroHeightr:   ÚthickBottomÚoutlineLevelRowÚoutlineLevelCol)
r   rg   rh   ri   r7   rj   r:   rk   rl   rm   r    r    r!   r     s    zSheetFormatProperties.__init__)	re   Nrf   NNNNNN)r.   r/   r0   Útagnamer   rg   r	   rh   ri   r
   r7   rj   r:   rk   rl   rm   r   r    r    r    r!   rd   ö   s&   







        rd   c               @   s,   e Zd ZdZeƒ Zddd„Zedd„ ƒZdS )ÚSheetDimensionZ	dimensionNc             C   s
   || _ d S )N)Úref)r   rp   r    r    r!   r      s    zSheetDimension.__init__c             C   s
   t | jƒS )N)r   rp   )r   r    r    r!   Ú
boundaries&  s    zSheetDimension.boundaries)N)	r.   r/   r0   rn   r   rp   r   r>   rq   r    r    r    r!   ro     s   
ro   N)r   Zopenpyxl.compatr   Zopenpyxl.utilsr   r   r   Zopenpyxl.utils.unitsr   Zopenpyxl.descriptorsr   r	   r
   r   r   r   Z!openpyxl.descriptors.serialisabler   Zopenpyxl.styles.styleabler   Zopenpyxl.utils.bound_dictionaryr   Zopenpyxl.xml.functionsr   r   r4   r?   rO   rd   ro   r    r    r    r!   Ú<module>   s    '8@=$