}\c:@s dZddlmZddlZddlmZddlmZmZm Z m Z m Z m Z m Z mZmZmZmZmZmZmZmZmZmZddlTdZie e 6e e 6e e6e e6e e 6Zdddfd d d fd ddfdd dfddd fd d dfd dd fdd d fd ddfdd dfddd fd d dfd dd fdd d fd d d fd d d fd d d fd d dfd d dfdd d fdddfd d d fdddfddd fddd fd dd fd d dfdd d fd dd fd ddfdd d fddd fddd fdd d fdd dfd d d fd dd fd d dfdd d fdddfd dd fd ddfd ddfd ddfd d dfd ddfddd fdddfdd dfd d dfdd dfd d dfd d dfd d dfd d d fd d d ff8Zed Zdddfd d d fd ddfdd dfddd fd d dfd dd fdd d fd ddfdd dfddd fd d dfd dd fdd d fd d d fd d d fd d d fd d dfd d dfdd d fdddfd d d fdddfddd fddd fd dd fd d dfdd d fd dd fd ddfdd d fddd fddd fdd d fdd dfd d d fd dd fd d dfdd d fd dd fd dd fd ddfd ddfd ddfd d dfd ddfddd fdddfdd dfd d dfdd dfd d dfd d dfd d dfd d d fd d d ff8Zied6ed6ed6ed6ed6ed6ed6ed6Zdddddd d!d"d#d$g Zd%Z dd&Z!d'e"fd(YZ#d)ee#fd*YZ$d+Z%d,Z&d-ee#fd.YZ'i$d/d6d0d6d1d26d3d46d5d66d7d86d9d:6d;d<6d=d>6d?d@6dAdB6dCdD6dEdF6dGdH6dIdJ6dKdL6dMd6dNdO6dPdQ6dRdS6dTd6dUd6dVdW6dXdY6dZd[6d\d]6d^d6d_d`6dadb6dcdd6dedf6dgd6dhdi6djdk6dldm6dndo6Z(ddefddHe fdJdWefdpdqefdYdfe fddkefdmdme fdodoe fddrefdsdte fdude fdvdwefg Z)iZ*x?e)D]7\Z+Z,Z-x%e.e+e,dD]Z/e-e*e/ Wid8e0d06d8e0dz6d8e0d{6Z6ide0dC6de0dl6de0d/6de0d|6de0d}6de0dn6Z7ej8d~j9Z:dZ;edZ<dZ=dZ>dZ?dZ@dZAdZBdZCdZDdee#fdYZEdee#fdYZFdee#fdYZGdee#fdYZHdefdYZIdS(s$ Module for formatting information. i(tprint_functionN(tunpacki(tFDTtFGEtFNUtFTXtFUNt XL_CELL_DATEtXL_CELL_NUMBERt XL_CELL_TEXTt XL_FORMATt XL_FORMAT2t BaseObjectt XLRDErrortfprintft unpack_stringtunpack_unicodetupkbitstupkbitsL(t*iiiiii3ifiiiiiPiFi2i-i(iiitNormalt RowLevel_t ColLevel_tCommatCurrencytPercents Comma [0]s Currency [0]t HyperlinksFollowed HyperlinkcCsi|_i|_|jsdSx%tdD]}t||j| %r; best_metric is %diiN(titemsR#tziptprint( Rtrgbtdebugt best_metrict best_colourxtcolourxtcand_rgbtmetrictv1tv2((s.lib/python2.7/site-packages/xlrd/formatting.pytnearest_colour_indexs"     t EqNeAttrscBs eZdZdZdZRS(s 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|jkS(N(t__dict__(tselftother((s.lib/python2.7/site-packages/xlrd/formatting.pyt__eq__scCs|j|jkS(N(R7(R8R9((s.lib/python2.7/site-packages/xlrd/formatting.pyt__ne__s(t__name__t __module__t__doc__R:R;(((s.lib/python2.7/site-packages/xlrd/formatting.pyR6s tFontcBsneZdZdZdZdZdZdZdZdZ dZ e dZ dZ dZdZdZdZdZRS(s 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 iti(R<R=R>tboldt character_sett colour_indext escapementtfamilyt font_indextheighttitalictUNICODE_LITERALtnamet struck_outtunderline_typet underlinedtweighttoutlinetshadow(((s.lib/python2.7/site-packages/xlrd/formatting.pyR?s   cCs.|js dStd|d|jd_dS(NsReRRfRIRgRi(((s.lib/python2.7/site-packages/xlrd/formatting.pyRdLs   tGeneralt0s0.00is#,##0is#,##0.00is$#,##0_);($#,##0)is$#,##0_);[Red]($#,##0)is$#,##0.00_);($#,##0.00)is$#,##0.00_);[Red]($#,##0.00)is0%i s0.00%i s0.00E+00i s# ?/?i s# ??/??i sm/d/yyisd-mmm-yyisd-mmmsmmm-yyis h:mm AM/PMis h:mm:ss AM/PMish:mmsh:mm:sss m/d/yy h:mmis#,##0_);(#,##0)i%s#,##0_);[Red](#,##0)i&s#,##0.00_);(#,##0.00)i's#,##0.00_);[Red](#,##0.00)s'_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)i)s*_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)i*s/_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)i+s2_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)i,smm:sss [h]:mm:ssi.smm:ss.0i/s##0.0E+0i0t@i1ii$i:i;i>iCiGiQtymdhss$-+/(): t#t?tGENERALtgenerals \[[^]]*\]c Cs(d}d}x|D]}|dkrw|tdkr@d}q|tdkr[d}q|tkrjq||7}n?|dkr|tdkrd}qn|dkrd}nd|kodknstqW|jdkr tdt|d |jntd|}|tkr*t Sd}d }d}d}}x]|D]U}|t krp|t |7}qM|t kr|t |7}qM||krMd}qMqMW|r| rt S|r| rt S|r|jrt |jd |||qn(|s|jrt |jd |qn||kS( NiR@t"is\_*iis+is_date_format_string: reduced format is %stfilet;s7WARNING *** is_date_format: ambiguous d=%d n=%d fmt=%r s/WARNING *** format %r produces constant result (RItskip_char_dicttAssertionErrorRZR+tREPRR]tfmt_bracketed_subtnon_date_formatstFalsetdate_char_dictt num_char_dicttTrueR( R$tfmttstatetstct separatortgot_sept date_countt num_count((s.lib/python2.7/site-packages/xlrd/formatting.pytis_date_format_strings`           &               cCsFd}|j}|tkr-t|d}n|jsC|jnd}|dkrrtd|dd!d}n|j}|dkrd}n|jd7_|dkrt|d}nt|||jdd}|p|j d k}|rt |j d |j|||n|j |} t tg| } |d kpI|dkstj|t} | tk} |j rd|kodknr| | Ard}t |j d ||qn|dkrt |j d | | | |nt|| |} |r%| j|j dd|jdfn| |j|<|jj| dS(Niiii2s %rRs(ii8(RRYRZRR!RR]R"R tpalette_recordRvRRR[R+(R$RRR^t n_colourstexpected_n_coloursR~t expected_sizet actual_sizet tolerancetcoloursR%Rtredtgreentbluetold_rgbtnew_rgb((s.lib/python2.7/site-packages/xlrd/formatting.pythandle_palette>s@ !          cCsx|jD]}|jdkr%q n|j}|dkr@q n||jkr_d|j|NOTE !!! XF[%d]: parent_style_index is %d; style flag not set s9NOTE !!! XF[%d]: parent_style_index is %d; out of order? RRRRs4NOTE !!! XF[%d] fmtk=%d, parent[%d] fmtk=%r %r / %r s.NOTE !!! XF[%d] fontx=%d, parent[%d] fontx=%r (t_xf_epilogue_doneR"RRYRZRR]RRReRRfRR RRRRRR!t_alignment_flagt_background_flagt _border_flagt_protection_flagt _format_flagRgt _font_flagRF( R8tnum_xfsR^tblah1RtxfxRR~Rtparent((s.lib/python2.7/site-packages/xlrd/formatting.pyt xf_epilogues              c Cs_t|d|_tttttttt t f }x$|D]}t |j |j |q;WdS(Ni(R(RRcRSRRRRRRR"RRR<(R$tmethodstmethod((s.lib/python2.7/site-packages/xlrd/formatting.pytinitialise_book>s    RcBsVeZdZdZdZdZdZdZdZdZ dZ dZ dZ dZ dZRS(so 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 i(R<R=R>RRRRRRRRRRRR(((s.lib/python2.7/site-packages/xlrd/formatting.pyROsRcBs eZdZdZdZdZRS(s 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 i(R<R=R>RRR(((s.lib/python2.7/site-packages/xlrd/formatting.pyRsRcBs8eZdZdZdZdZdZdZdZdZ RS(s 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 i( R<R=R>RRRRRRR(((s.lib/python2.7/site-packages/xlrd/formatting.pyRsRcBseZdZdZdZRS(sd 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 i(R<R=R>RR(((s.lib/python2.7/site-packages/xlrd/formatting.pyRs RcBsheZdZdZdZdZdZdZdZdZ dZ dZ dZ dZ dZdZdZdZRS(s 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 iN(R<R=R>RRRRRRRRRRFReR#RRRR(((s.lib/python2.7/site-packages/xlrd/formatting.pyRs  (JR>t __future__RtretstructRtbiffhRRRRRRRR R R R R RRRRRt timemachineRYRtexcel_default_palette_b5texcel_default_palette_b2RR RR(R5tobjectR6R?RSRcRdRtfmt_code_rangesRtlothiRhRRRIt date_charsR{tuppert_cRuR|RytcompiletsubRxRRRRRRRRR"R%RRRRR(((s.lib/python2.7/site-packages/xlrd/formatting.pyt s: p  00000000000006 00000000000006     X  I                      ? 4 $  + = I C"