Ë
|
dñúhó ã ó¾ d dl mZ d dlmZ d dlmZ d dlmZ d dlm Z m
|
Z
|
m Z m Z m Z mZmZ d dlmZ d dlmZmZmZ ddZd Zd
|
d lmZ G d d e« Z G d de« Zy)é )Ú defaultdict©Úchain)Ú
|
itemgetter)Ú Serialisable)ÚBoolÚNoneSetÚStringÚSequenceÚAliasÚIntegerÚ Convertible)Ú
|
NestedText)Úrows_from_rangeÚcoordinate_to_tupleÚget_column_letterc ó¦ t |« }d | D « }t t « }t |t d« ¬« D ] \ }}|| j |« |j « D ]Y \ }} t |« }d}t | « dk( rd}|j |t | « |t | « « }|j |« [ dj |« S )ax Collapse a collection of cell co-ordinates down into an optimal
|
range or collection of ranges.
|
|
E.g. Cells A1, A2, A3, B1, B2 and B3 should have the data-validation
|
object applied, attempt to collapse down to a single range, A1:B3.
|
|
Currently only collapsing contiguous vertical ranges (i.e. above
|
example results in A1:A3 B1:B3).
|
c 3 ó2 K | ] }t |« y w©N)r )Ú.0Úcells úTH:\Change_password\venv_build\Lib\site-packages\openpyxl/worksheet/datavalidation.pyú <genexpr>z*collapse_cell_addresses.<locals>.<genexpr>( s è ø Ò>°Ô% d×+Ñ>ùó é )Úkeyz {0}{1}:{2}{3}z{0}{1}ú ) Úlistr Úsortedr ÚappendÚitemsr ÚlenÚformatÚminÚmaxÚjoin) ÚcellsÚ input_rangesÚrangesÚ
|
raw_coordsÚgrouped_coordsÚrowÚcolÚfmtÚrs r Úcollapse_cell_addressesr0 sÍ ô ,Ó Fñ ?¸Ô>Jô !¤Ó&NÜ:¬:°a«=Ô9ò (SØsÑ×"Ñ" 3Õ'ð(ð %×*Ñ*Ó,ò
|
UÜ Ó$Ø Ü u:?ØCØ JJsC J¨¬S°«ZÓ 8Ø aÕð ð 88FÓ Ðó c ód d | j « D « }d |D « }t t | « S )z
|
Expand cell ranges to a sequence of addresses.
|
Reverse of collapse_cell_addresses
|
Eg. converts "A1:A2 B1:B2" to (A1, A2, B1, B2)
|
c 3 ó2 K | ] }t |« y wr )r )r Úrss r r z%expand_cell_ranges.<locals>.<genexpr>B s è ø Ò ? BOB× Ñ ?ùr c 3 ó, K | ] }t | y wr r )r r, s r r z%expand_cell_ranges.<locals>.<genexpr>C s è ø Ò )SUC[Ñ )ùs )ÚsplitÚsetr )Ú range_stringÚrowsr' s r Úexpand_cell_rangesr: ; s1 ñ @¨,×*<Ñ*<Ó*>Ô ?DÙ ) DÔ )EÜ ue}Ó Ð r1 r )ÚMultiCellRangec ó¦ e Zd ZdZ ee¬« Z ed« Z ed« Z e
|
d¬« Z ed« Z e
|
d¬« Z e
|
d¬« Z e
|
d¬« Z ed« Z ed¬« Z ed¬« Z ed¬« Z ed¬« Z ede¬« Z ede¬« Z ed ¬
|
« Z ed ¬
|
« Z ed ¬
|
« Z ed ¬
|
« Z ed« Z ddZ d Z!d Z"y)ÚDataValidationÚdataValidation©Ú expected_typeÚsqrefT©Ú
|
allow_noneÚ showDropDownÚ
|
allowBlank)rC r@ )ÚwholeÚdecimalr ÚdateÚtimeÚ
|
textLengthÚcustom)Úvalues)ÚstopÚwarningÚ information) Ú noControlÚoffÚonÚdisabledÚhiraganaÚ fullKatakanaÚ halfKatakanaÚ fullAlphaÚ halfAlphaÚ
|
fullHangulÚ
|
halfHangul)ÚbetweenÚ
|
notBetweenÚequalÚnotEqualÚlessThanÚlessThanOrEqualÚ greaterThanÚgreaterThanOrEqualÚtypeNc óÞ || _ || _ || _ || _ || _ || _ ||}|| _ || _ || _ || _ | | _
|
|
|
| _ | | _ | | _ | | _ y r )rA rD ÚimeModeÚoperatorÚformula1Úformula2rE ÚshowErrorMessageÚshowInputMessagerc Ú promptTitleÚ
|
errorStyleÚerrorÚpromptÚ
|
errorTitle)Úselfrc rg rh ri rj rD rE rA rk rl rm rn ro re rf Ú allow_blanks r Ú__init__zDataValidation.__init__j s| ð$
|
Ø (ÔØ Ø Ø Ø Ø Ð "Ø$JØ$Ø 0Ô Ø 0Ô Ø Ø&ÔØ$Ø
|
Ø Ø$r1 c ó^ t |d« r |j }| xj |z c_ y)z0Adds a cell or cell coordinate to this validatorÚ
|
coordinateN©Úhasattrrt rA ©rp r s r ÚaddzDataValidation.add s# ä 4 Ô &Ø??DØ
|
|
dÑ
|
r1 c óN t |d« r |j }|| j v S )Nrt ru rw s r Ú __contains__zDataValidation.__contains__ s$ Ü 4 Ô &Ø??DØtzzÐ!Ð!r1 )NNNFFFF© NNNNNNNN)#Ú__name__Ú
|
__module__Ú __qualname__Útagnamer r; rA r r' r) r rD Úhide_drop_downrj ri rE rq r
|
ro rm rk rn r Ústrrg rh r rc rl re rf Úvalidation_typerr rx rz r{ r1 r r= r= J s( à Gá nÔ 5EÙ 'NEÙ 7^Fá 4Ô(LÙ>Ó*NÙ tÔ,ÐÙ tÔ,ÐÙ Ô&JÙ Ó%Ká TÔ*JÙ Ô %EÙ dÔ+KÙ Ô &FÙ T¸Ô=HÙ T¸Ô=Há ð 3ô 4DáÐ BÔCJÙð :ô ;Gñ ð cô dHáFmOð Ø Ø Ø"'Ø"'Ø #Ø !ØØ !Ø ØØ Ø Ø Ø Ø !ó!"%òJó"r1 r= c ó¢ e Zd ZdZ ed¬« Z ed¬« Z ed¬« Z e e
|
¬« Z dZ dZ d dZed « Zd Zd
|
Zd fd Z xZS )ÚDataValidationListÚdataValidationsTrB r? )r> )ÚdisablePromptsÚxWindowÚyWindowÚcountc ó< || _ || _ || _ || _ y r )r r r r> )rp r r r r r> s r rr zDataValidationList.__init__¨ s" ð -ÔØ Ø Ø ,Õr1 c ó t | « S r )r" ©rp s r r zDataValidationList.countµ s ä4yÐr1 c ó, t | j « S r )r" r> r s r Ú__len__zDataValidationList.__len__º s Ü4×&Ñ&Ó'Ð'r1 c ó: | j j |« y r )r> r )rp Údvs r r zDataValidationList.append¾ s Ø ×Ñ×"Ñ" 2Õ&r1 c óÀ | j }| j D cg c] }t |j « s| c}| _ t | |« }|| _ |S c c}w )zC
|
Need to skip validations that have no cell ranges
|
)r> ÚboolrA ÚsuperÚto_tree)rp r r) r/ ÚxmlÚ __class__s r r zDataValidationList.to_tree sT ø ð ×$Ñ$Ø*.×*=Ñ*=Ö O QÄÀaÇgÁgÅ qÒ OÔÜgogÓ&Ø $ÔØ
|
ùò Ps
|
A·A)NNNNr{ r )r| r} r~ r r r r r r r r= r> Ú __elements__Ú __attrs__rr Úpropertyr r r r Ú __classcell__)r s @r r r sx ø à Gá TÔ*NÙ Ô&GÙ Ô&GÙ ¨NÔ;Nà&LØAIð !%Ø Ø ØØ "ó
|
-ð ñó ðò(ò'÷ñ r1 r N)r{ ) Ú collectionsr Ú itertoolsr rf r Ú!openpyxl.descriptors.serialisabler Úopenpyxl.descriptorsr r r
|
r r r r Úopenpyxl.descriptors.nestedr Úopenpyxl.utilsr r r r0 r: Ú
|
cell_ranger; r= r r{ r1 r ú<module>r¢ s\ ðõ $Ý Ý å :÷÷ ñ õ 3÷ñ ó òB õ 'ôO"\ô O"ôd. õ .r1
|
