U d(@sddlmZddlmZmZmZmZmZddlm Z ddl m Z ddl m Z mZddlmZddlmZdd lmZdd lmZdd lmZmZmZdd lmZmZGd dde ZGdddeZ Gddde Z!Gddde Z"dS)) safe_string)TypedIntegerBoolStringSequence) ExtensionList) Serialisable) PatternFillFill)Font)Border) Alignment) Protection)NumberFormatDescriptorBUILTIN_FORMATS_MAX_SIZEBUILTIN_FORMATS_REVERSE) StyleArray CellStylec seZdZdZeedZeedZee dZ ee dZ e ZeedZeddZeddZeddZeZdZeZddd Zfd d Zd d ZeddZddZddZ ddZ!ddZ"ddZ#ddZ$Z%S) NamedStylez# Named and editable styles  expected_typeT allow_noneNNormalFc Csf||_|pt|_|pt|_|p&t|_|p2t|_||_ |pDt |_ ||_ | |_ d|_t|_dSN)namer fontr fillrborderr alignment number_formatr protection builtinIdhidden_wbr_style) selfrrrr r!r"r#r$r%xfIdr*@/tmp/pip-unpacked-wheel-rwywncvq/openpyxl/styles/named_styles.py__init__3s      zNamedStyle.__init__cs2tt|||t|ddr.|dkr.|dS)Nr&)rrr r!r"r#)superr __setattr__getattr _recalculate)r(attrvalue __class__r*r+r.LszNamedStyle.__setattr__ccs0dD]&}t||d}|dk r|t|fVqdS)Nrr$r%r))r/r)r(keyr2r*r*r+__iter__Ts zNamedStyle.__iter__cCs|jjS)z@ Index of the style in the list of named styles r'r)r(r*r*r+r)[szNamedStyle.xfIdcCs ||j_dS)z< Allow the containing list to set the index Nr8)r(idxr*r*r+ _set_indexcszNamedStyle._set_indexcCs||_|dS)z2 Bind a named style to a workbook N)r&r0)r(wbr*r*r+bindjszNamedStyle.bindcCs|jj|j|j_|jj|j|j_|jj |j |j_ |jj |j |j_|jj|j|j_|j}|tkr|t|}n|jj|jt}||j_dSr)r&Z_fontsaddrr'ZfontIdZ_bordersr ZborderIdZ_fillsrZfillIdZ _protectionsr#Z protectionIdZ _alignmentsr!Z alignmentIdr"rZ_number_formatsrZnumFmtId)r(fmtr*r*r+r0rs zNamedStyle._recalculatecCs|jS)z3Return a style array representing the current style)r'r9r*r*r+as_tupleszNamedStyle.as_tuplecCsJt|j}d|_d|_d|_|jtkr2|j|_|jt krF|j|_|S)z+ Return equivalent XfStyle N) rZ from_arrayr'r)Z pivotButtonZ quotePrefixr!rr#r)r(Zxfr*r*r+as_xfs   zNamedStyle.as_xfcCst|j|j|j|jd}|S)z. Return relevant named style r5)_NamedCellStylerr$r%r))r(namedr*r*r+as_nameszNamedStyle.as_name) rNNNNNNNFN)&__name__ __module__ __qualname____doc__rr rr rrr rr!rr"rr#rr$rr%r)rrr&rr'r,r.r7propertyr;r=r0r@rArD __classcell__r*r*r3r+rsD           rcs8eZdZdZeddZfddZfddZZS)NamedStyleListz Named styles are editable and can be applied to multiple objects As only the index is stored in referencing objects the order mus be preserved. cCsdd|DS)NcSsg|] }|jqSr*)r).0sr*r*r+ sz(NamedStyleList.names..r*r9r*r*r+namesszNamedStyleList.namescs`t|trtt||S|j}||kr6td|t|D]\}}||kr>||Sq>dS)Nz&No named style with the name{0} exists) isinstanceintr-rK __getitem__rOKeyErrorformat enumerate)r(r6rOr:rr3r*r+rRs zNamedStyleList.__getitem__csRt|tstdn|j|jkr0td|j|t|t t | |dS)Nz&Only NamedStyle instances can be addedzStyle {0} exists already) rPr TypeErrorrrO ValueErrorrTr;lenr-rKappend)r(styler3r*r+rYs    zNamedStyleList.append) rErFrGrHrIrOrRrYrJr*r*r3r+rKs   rKc@sbeZdZdZdZeZeZeddZ eddZ e ddZ e ddZ eeddZdZd dd ZdS) rBz Pointer-based representation of named styles in XML xfId refers to the corresponding CellStyleXfs Not used in client code. cellStyleTr)rrr*NcCs(||_||_||_||_||_||_dSr)rr)r$iLevelr% customBuiltin)r(rr)r$r\r%r]extLstr*r*r+r,s z_NamedCellStyle.__init__)NNNNNNN)rErFrGrHtagnamerrrr)r$r\rr%r]rrr^Z __elements__r,r*r*r*r+rBs$     rBc@sNeZdZdZdZeddZeedZ dZ dd d Z e d d Ze d dZ dS)_NamedCellStyleListzM Container for named cell style objects Not used in client code Z cellStylesTrr)countNr*cCs ||_dSr)r[)r(rar[r*r*r+r,sz_NamedCellStyleList.__init__cCs t|jSr)rXr[r9r*r*r+rasz_NamedCellStyleList.countcCsrdd}g}t}t|j|dD]H}|j|kr0q t|j|j|jd}||j|t || |q t |S)z Convert to NamedStyle objects and remove duplicates. In theory the highest xfId wins but in practice they are duplicates so it doesn't matter. cSs|jSr)r))vr*r*r+sort_fnsz*_NamedCellStyleList.names..sort_fn)r6)rr%r$) setsortedr[rrr%r$r>r;rXrYrK)r(rcZstylesrOnsrZr*r*r+rOs    z_NamedCellStyleList.names)Nr*)rErFrGrHr_rrarrBr[ __attrs__r,rIrOr*r*r*r+r`s    r`N)#Zopenpyxl.compatrZopenpyxl.descriptorsrrrrrZopenpyxl.descriptors.excelrZ!openpyxl.descriptors.serialisabler Zfillsr r Zfontsr Zbordersrr!rr#rZnumbersrrrZ cell_stylerrrlistrKrBr`r*r*r*r+s       #'