U .RiV@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 ZeedZeddZeddZeZdZeZddd Zfd d Zd d ZddZddZddZddZ 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%r)@/tmp/pip-unpacked-wheel-r0v169r1/openpyxl/styles/named_styles.py__init__2s      zNamedStyle.__init__cs.t||t|ddr*|dkr*|dS)Nr&)rrr r!r"r#)super __setattr__getattr _recalculate)r(attrvalue __class__r)r*r-JszNamedStyle.__setattr__ccs0dD]&}t||d}|dk r|t|fVqdS)Nrr$r%xfId)r.r)r(keyr1r)r)r*__iter__Rs zNamedStyle.__iter__cCs||_|dS)z2 Bind a named style to a workbook N)r&r/)r(wbr)r)r*bindYszNamedStyle.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*r/as zNamedStyle._recalculatecCs|jS)z3Return a style array representing the current style)r'r(r)r)r*as_tuplepszNamedStyle.as_tuplecCsJt|j}d|_d|_d|_|jtkr2|j|_|jt krF|j|_|S)z+ Return equivalent XfStyle N) rZ from_arrayr'r5Z pivotButtonZ quotePrefixr!rr#r)r(Zxfr)r)r*as_xfus   zNamedStyle.as_xfcCst|j|j|j|jjd}|S)z. Return relevant named style r4)_NamedCellStylerr$r%r'r5)r(namedr)r)r*as_nameszNamedStyle.as_name) rNNNNNNNF)#__name__ __module__ __qualname____doc__rr rr rrr rr!rr"rr#rr$rr%rrr&rr'r+r-r7r9r/r=r>rA __classcell__r)r)r2r*rs:         rcsFeZdZdZd fdd ZeddZfddZfd d ZZ S) 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. Returns a list of NamedStyles r)cs0t|t|D]\}}||j_qt|dS)zN Allow a list of named styles to be passed in and index them. N) enumeratelenr'r5r,r+)r(iterableidxsr2r)r*r+s zNamedStyleList.__init__cCsdd|DS)NcSsg|] }|jqSr))r).0rLr)r)r* sz(NamedStyleList.names..r)r<r)r)r*namesszNamedStyleList.namescsPt|trt|St|jD]\}}||kr ||Sq td|dS)Nz&No named style with the name{0} exists) isinstanceintr, __getitem__rHrOKeyErrorformat)r(r6rKrr2r)r*rRs   zNamedStyleList.__getitem__csLt|tstdn|j|jkr0td|jt||j_ t |dS)Nz&Only NamedStyle instances can be addedzStyle {0} exists already) rPr TypeErrorrrO ValueErrorrTrIr'r5r,append)r(styler2r)r*rWs     zNamedStyleList.append)r)) rBrCrDrEr+propertyrOrRrWrFr)r)r2r*rGs     rGc@sbeZdZdZdZeZeZeddZ eddZ e ddZ e ddZ eeddZdZd dd ZdS) r?z Pointer-based representation of named styles in XML xfId refers to the corresponding CellStyleXfs Not used in client code. cellStyleTr)rrr)NcCs(||_||_||_||_||_||_dSr)rr5r$iLevelr% customBuiltin)r(rr5r$r[r%r\extLstr)r)r*r+s z_NamedCellStyle.__init__)NNNNNNN)rBrCrDrEtagnamerrrr5r$r[rr%r\rrr]Z __elements__r+r)r)r)r*r?s$     r?c@sJeZdZdZdZeddZeedZ dZ dd d Z e d d Zd dZ dS)_NamedCellStyleListzM Container for named cell style objects Not used in client code Z cellStylesTrr)countNr)cCs ||_dSr)rZ)r(r`rZr)r)r*r+sz_NamedCellStyleList.__init__cCs t|jSr)rIrZr<r)r)r*r`sz_NamedCellStyleList.countcCshdd}g}t}t}t|j|dD]<}|j|ks&|j|kr@q&||j||j||q&|S)a Some applications contain duplicate definitions either by name or referenced style. As the references are 0-based indices, styles are sorted by index. Returns a list of style references with duplicates removed cSs|jSr)r5)vr)r)r*sort_fn sz6_NamedCellStyleList.remove_duplicates..sort_fn)r6)setsortedrZr5rr:rW)r(rbZstylesrOidsnsr)r)r*remove_duplicatess    z%_NamedCellStyleList.remove_duplicates)Nr))rBrCrDrEr^rr`rr?rZ __attrs__r+rYrgr)r)r)r*r_s    r_N)#Zopenpyxl.compatrZopenpyxl.descriptorsrrrrrZopenpyxl.descriptors.excelrZ!openpyxl.descriptors.serialisabler Zfillsr r Zfontsr Zbordersrr!rr#rZnumbersrrrZ cell_stylerrrlistrGr?r_r)r)r)r*s       s-'