o
    ðäjá  ã                   @   sF   d dl mZmZmZ d dlmZ dZdZdZG dd„ dƒZ	dd	„ Z
d
S )é    )ÚElementÚ
SubElementÚtostring)Úcoordinate_to_tuplezurn:schemas-microsoft-com:vmlz'urn:schemas-microsoft-com:office:officez&urn:schemas-microsoft-com:office:excelc                   @   s8   e Zd ZdZdZdZdd„ Zdd„ Zdd„ Zd	d
„ Z	dS )ÚShapeWriterz!
    Create VML for comments
    Nc                 C   s
   || _ d S )N)Úcomments)Úselfr   © r	   úb/var/www/ticemtrilhas/avaliacao_env/lib/python3.10/site-packages/openpyxl/comments/shape_writer.pyÚ__init__   s   
zShapeWriter.__init__c                 C   sŒ   t |dt dt diƒ}t |dt dt dddiƒ t |dt dd	d
ddt dddiƒ}t |dt ddiƒ t |dt dddt diƒ d S )Nz{%s}shapelayoutz{%s}extÚeditz	{%s}idmapÚdataÚ1z{%s}shapetypeÚidÚ_x0000_t202Ú	coordsizez21600,21600z{%s}sptÚ202Úpathzm,l,21600r21600,l21600,xez
{%s}strokeÚ	joinstyleÚmiterú{%s}pathÚgradientshapeokÚtú{%s}connecttypeÚrect)r   ÚofficensÚvmlns)r   ÚrootÚshape_layoutÚ
shape_typer	   r	   r
   Úadd_comment_shapetype   s,   

ÿþýþÿþz!ShapeWriter.add_comment_shapetypec           	      C   sH   t |ƒ\}}|d8 }|d8 }t||||ƒ}| dd| ¡ | |¡ d S )Né   r   z_x0000_s%04d)r   Ú_shape_factoryÚsetÚappend)	r   r   ÚidxÚcoordÚheightÚwidthÚrowÚcolÚshaper	   r	   r
   Úadd_comment_shape0   s   zShapeWriter.add_comment_shapec                 C   sŒ   t |dƒs	tdƒ}| dt ¡}|D ]}| |¡ q| dt ¡}|d u r*|  |¡ t| jdƒD ]\}\}}|  	||||j
|j¡ q0t|ƒS )NÚfindallÚxmlz{%s}shape[@type='#_x0000_t202']z {%s}shapetype[@id='_x0000_t202']i  )Úhasattrr   r-   r   ÚremoveÚfindr    Ú	enumerater   r,   r'   r(   r   )r   r   r   ÚcÚshape_typesr%   r&   Úcommentr	   r	   r
   Úwrite:   s   

zShapeWriter.write)
Ú__name__Ú
__module__Ú__qualname__Ú__doc__ÚvmlÚvml_pathr   r    r,   r6   r	   r	   r	   r
   r      s    
r   c           	      C   s  dj ||d�}ddd|dddt d	i}td
t |ƒ}t|dt ddiƒ t|dt dddœƒ t|dt dt diƒ t|dt ddiƒ}t|dddiƒ t|dt ddiƒ}t|dt ƒ t|dt ƒ dt|dt ƒ_t| ƒt|dt ƒ_t|ƒt|d t ƒ_|S )!Nzuposition:absolute; margin-left:59.25pt;margin-top:1.5pt;width:{width}px;height:{height}px;z-index:1;visibility:hidden)r'   r(   Útypez#_x0000_t202ÚstyleÚ	fillcolorz#ffffe1z{%s}insetmodeÚautoz	{%s}shapez{%s}fillÚcolor2z
{%s}shadowÚblackr   )ÚcolorÚobscuredr   r   Únonez{%s}textboxzmso-direction-alt:autoÚdivztext-align:leftz{%s}ClientDataÚ
ObjectTypeÚNotez{%s}MoveWithCellsz{%s}SizeWithCellsÚFalsez{%s}AutoFillz{%s}Rowz
{%s}Column)Úformatr   r   r   r   ÚexcelnsÚtextÚstr)	r)   Úcolumnr'   r(   r>   Úattrsr+   ÚtextboxÚclient_datar	   r	   r
   r"   O   s@   ù	ü
ÿ
ÿ

ÿ
ÿ
ÿr"   N)Úopenpyxl.xml.functionsr   r   r   Úopenpyxl.utilsr   r   r   rK   r   r"   r	   r	   r	   r
   Ú<module>   s   ?