U d%@sndZddlmZddlZddlmZddlmZmZm Z m Z m Z m Z m Z mZmZmZmZmZmZmZmZmZmZddlTdZe e e e ee ee e e iZdZedd Zd Zeeeeeeeed Zd d ddddddddg ZddZ dddZ!Gddde"Z#Gdddee#Z$ddZ%d d!Z&Gd"d#d#ee#Z'd$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBdCdDdEdFdGdH$Z(ddefddIe fdJdKefdLdMefdNdOe fdPdQefdRdRe fdSdSe fdTdUefdVdWe fdXdYe fdZd[efg Z)iZ*e)D]*\Z+Z,Z-e.e+e,dD]Z/e-e*e/<qq[+[,[-[/e0d\Z1iZ2e1e13D]Z4d]e2e4<q2[4[1iZ5e0d^D]Z4de5e4<qRe0d%d]e0d_d]e0d`d]iZ6e0d/de0dFde0d$de0dade0dbde0dGdiZ7e8dcj9Z:dddeZ;efdfdgZdldmZ?dndoZ@dpdqZAdrdsZBdtduZCdvdwZDGdxdydyee#ZEGdzd{d{ee#ZFGd|d}d}ee#ZGGd~ddee#ZHGdddeZIdS)z$ Module for formatting information. )print_functionN)unpack)FDTFGEFNUFTXFUN XL_CELL_DATEXL_CELL_NUMBER XL_CELL_TEXT XL_FORMAT XL_FORMAT2 BaseObject XLRDErrorfprintf unpack_stringunpack_unicodeupkbitsupkbitsL)*)8rrrrrrrrrrrrrrrrrrrrrrrrrrr!rrrr!r!r!rr!rr!rr!r!r(r(r!r!r!r+rr+3frrr0rrr.rr.rr!r!rr.r0r0r0rr#rrrr%r r&rrr0rr1r0rr0rrr+r+r0rrr+r0r0r+r)r<r<r-r.rr-r0r0r+r0rrr0rrr+rrr.rr.r.r+rErErr-r.r-r+r.rr-rr-r-rr+r-rr,r-r-r+r-r-r-)8rrrrrrrrr r"r#r$r%r&r'r)r*r,r/r1r2r3r4r5r#rrrr%r r&rr6r1r7r8r9r:r;)rr0r+r=r>r?r@rArBrCrDrFrGrHrIrJr,rKrL)PF2-(NormalZ RowLevel_Z ColLevel_ZCommaZCurrencyZPercentz Comma [0]z Currency [0]Z HyperlinkzFollowed HyperlinkcCsi|_i|_|jsdStdD]}t||j|<qt|j}t|}t|D]}|||j|d<qLd|j|d<d|j|dd<d|jd<d|jd<dS)NrQ) colour_mapcolour_indexes_usedformatting_infoxrangeexcel_default_palette_b8default_palette biff_versionlen)bookiZdpalZndpalrd3/tmp/pip-unpacked-wheel-zwq1az3t/xlrd/formatting.pyinitialise_colour_mapis    rfc Csd}d}|D]Z\}}|dkr"qd}t||D]\}} ||| || 7}q0||kr|}|}|dkrqlqdr|rtd|||||f|S)z General purpose function. Uses Euclidean distance. So far used only for pre-BIFF8 ``WINDOW2`` record. Doesn't have to be fast. Doesn't have to be fancy. irNz:nearest_colour_index for %r is %r -> %r; best_metric is %d)itemszipprint) rZZrgbdebugZ best_metricZ best_colourxZcolourxZcand_rgbZmetricZv1Zv2rdrdrenearest_colour_indexs$rkc@s eZdZdZddZddZdS) EqNeAttrsz This mixin class exists solely so that :class:`Format`, :class:`Font`, and :class:`XF` objects can be compared by value of their attributes. cCs |j|jkSN__dict__selfotherrdrdre__eq__szEqNeAttrs.__eq__cCs |j|jkSrmrnrprdrdre__ne__szEqNeAttrs.__ne__N)__name__ __module__ __qualname____doc__rsrtrdrdrdrerlsrlc@sPeZdZdZdZdZdZdZdZdZ dZ dZ e dZ dZdZdZdZdZdZdS)Fontz An Excel "font" contains the details of not only what is normally considered a font, but also several other display attributes. Items correspond to those in the Excel UI's Format -> Cells -> Font tab. .. versionadded:: 0.6.1 rN)rurvrwrxbold character_set colour_index escapementfamily font_indexheightitalicUNICODE_LITERALname struck_outunderline_type underlinedweightoutlineshadowrdrdrdrerys   rycCs$|js dStd|d|jd_dS)Nt d|dd\|_}|_|_|_|_|_|_|d@|_|d@d?|_|d@d?|_|d @d ?|_|d @d?|_|d @d ?|_|dkr&t|ddd|_ nt|d|jdd|_ nR|dkrt d|dd\|_}|_|d@|_|d@d?|_|d@d?|_|d @d ?|_|d @d?|_|d @d ?|_t|d|jdd|_ ddg|j|_d|_|j|_d|_d|_nt d|dd\|_}d|_|d@|_|d@d?|_|d@d?|_|d @d ?|_d|_d|_t|d|jdd|_ ddg|j|_d|_|j|_d|_d|_|r|j|jd|j dddS)Nz Dummy FontrrPz CrOGrXZymdhsrz$-+/(): #?ZGENERALZgeneralz \[[^]]*\]c Csd}d}|D]}|dkrP|tdkr*d}qv|tdkr}|t kr|t |7}q|t kr|t |7}q||krd}q|r0|s0d S|r@|s@d S|rb|jr~t |jd |||n|s~|jr~t |jd|||kS)Nrrz"rz\_*rrz+is_date_format_string: reduced format is %sfileF;Tz7WARNING *** is_date_format: ambiguous d=%d n=%d fmt=%r z/WARNING *** format %r produces constant result ) rskip_char_dictAssertionErrorrriZREPRrfmt_bracketed_subnon_date_formatsdate_char_dict num_char_dictr) rbfmtstatesc separatorZgot_sepZ date_countZ num_countrdrdreis_date_format_stringsh          rcCsd}|j}|tkrt|d}|js*|d}|dkrNtd|ddd}n|j}|dkr`d}|jd7_|dkrt|d}nt|||jdd}|p|j d k}|rt |j d |j|||| |} t tg| } |d ks<|dks %rr)r\rrrr`rrrarZpalette_recordrr]rZrri)rbrrZ n_coloursZexpected_n_coloursrZ expected_sizeZ actual_sizeZ toleranceZcoloursrcrZredZgreenZblueZold_rgbZnew_rgbrdrdrehandle_paletteAsH      rcCs|jD]h}|jdkrq|j}|dkr&q||jkrd?z|j(|j}t)|j*} Wnt+k rt,} YnX| |j-|j$<|j.r|jr|j/r|j d@krdA}!t0|j'|!|j$|j t1|||j$|j|j(krFdB}!|jr@t0|j'|!|j$|j|jd|_dS)CNrrrPrNz |j|jkrt|jd |j|jn$|j|jjs>t|jd |j|j|rf|j|jkrft|jd |j|j|j|j} |js| js|r|||| d |js| js|r|||| d |js| js|r|||| d|js| js|r|||| d|jsZ| jsZ|rZ|j | j krZt|jd|j|j | j| j |j|j j|j| j j|jsL| jsL|rL|j| jkrLt|jd|j|j| j| jqLdS)Nrrzxf_epilogue called ... cSs.t||t||kr*t|jd|j|j|dS)Nz(NOTE !!! XF[%d] parent[%d] %s different )getattrrrr)Zbook_argZxf_argZ parent_argrrdrdre check_sameszxf_epilogue..check_samerz:WARNING *** XF[%d]: is_style=%d but parent_style_index=%d rSz/NOTE !!! XF[%d]: parent_style_index is also %d z>NOTE !!! XF[%d]: parent_style_index is %d; style flag not set z9NOTE !!! XF[%d]: parent_style_index is %d; out of order? rrrrz4NOTE !!! XF[%d] fmtk=%d, parent[%d] fmtk=%r %r / %r z.NOTE !!! XF[%d] fontx=%d, parent[%d] fontx=%r )_xf_epilogue_donerarDrrrrr]rrrErrFr rGrr\rrr`_alignment_flag_background_flag _border_flag_protection_flag _format_flagr _font_flagr) rqZnum_xfsrZblah1rPZxfxrHrrLparentrdrdre xf_epilogues           rYc CsBt|d|_tttttttt t f }|D]}t |j |j |q(dS)Nr)rfrQrrrrrrrrNrYrCrru)rbmethodsmethodrdrdreinitialise_bookAs r\c@s@eZdZdZdZdZdZdZdZdZ dZ dZ dZ dZ dZdZdS)r?ao A collection of the border-related attributes of an ``XF`` record. Items correspond to those in the Excel UI's Format -> Cells -> Border tab. An explanations of "colour index" is given in :ref:`palette`. There are five line style attributes; possible values and the associated meanings are:: 0 = No line, 1 = Thin, 2 = Medium, 3 = Dashed, 4 = Dotted, 5 = Thick, 6 = Double, 7 = Hair, 8 = Medium dashed, 9 = Thin dash-dotted, 10 = Medium dash-dotted, 11 = Thin dash-dot-dotted, 12 = Medium dash-dot-dotted, 13 = Slanted medium dash-dotted. The line styles 8 to 13 appear in BIFF8 files (Excel 97 and later) only. For pictures of the line styles, refer to OOo docs s3.10 (p22) "Line Styles for Cell Borders (BIFF3-BIFF8)".

.. versionadded:: 0.6.1 rN)rurvrwrxr%r'rr r(rrrrr)r!r#rdrdrdrer?Rs r?c@seZdZdZdZdZdZdS)r@a A collection of the background-related attributes of an ``XF`` record. Items correspond to those in the Excel UI's Format -> Cells -> Patterns tab. An explanations of "colour index" is given in :ref:`palette`. .. versionadded:: 0.6.1 rN)rurvrwrxr+r/r-rdrdrdrer@s r@c@s,eZdZdZdZdZdZdZdZdZ dZ dS)r>z A collection of the alignment and similar attributes of an ``XF`` record. Items correspond to those in the Excel UI's Format -> Cells -> Alignment tab. .. versionadded:: 0.6.1 rN) rurvrwrxrr rBr r rrrdrdrdrer>sr>c@seZdZdZdZdZdS)rAad A collection of the protection-related attributes of an ``XF`` record. Items correspond to those in the Excel UI's Format -> Cells -> Protection tab. Note the OOo docs include the "cell or style" bit in this bundle of attributes. This is incorrect; the bit is used in determining which bundles to use. .. versionadded:: 0.6.1 rN)rurvrwrxrrrdrdrdrerAs rAc@sLeZdZdZdZdZdZdZdZdZ dZ dZ dZ dZ dZdZdZdZdZdS)r=a eXtended Formatting information for cells, rows, columns and styles. Each of the 6 flags below describes the validity of a specific group of attributes. In cell XFs: - ``flag==0`` means the attributes of the parent style ``XF`` are used, (but only if the attributes are valid there); - ``flag==1`` means the attributes of this ``XF`` are used. In style XFs: - ``flag==0`` means the attribute setting is valid; - ``flag==1`` means the attribute should be ignored. .. note:: the API provides both "raw" XFs and "computed" XFs. In the latter case, cell XFs have had the above inheritance mechanism applied. .. versionadded:: 0.6.1 rN)rurvrwrxrrrVrWrRrTrSrUrrrrrrrrdrdrdrer=s  r=)r)Jrx __future__rrestructrZbiffhrrrrr r r r r rrrrrrrrZ timemachinerrEZexcel_default_palette_b5Zexcel_default_palette_b2r^r_rrfrkobjectrlryrrrrZfmt_code_rangesrlohirr]rrZ date_charsrupperZ_crrrcompilesubrrrrrrrrrNrYr\r?r@r>rAr=rdrdrdres(  L    [I!-    ? 4$+  >IC"