Ë
|
dñúhý ã ó^ d Z ddlZddlmZmZ ddlmZmZmZ G d de « Z
|
G d d « Z y)
|
a!
|
This module contains code to translate formulae across cells in a worksheet.
|
|
The idea is that if A1 has formula "=B1+C1", then translating it to cell A2
|
results in formula "=B2+C2". The algorithm relies on the formula tokenizer
|
to identify the parts of the formula that need to change.
|
|
é Né )Ú TokenizerÚToken)Úcoordinate_to_tupleÚcolumn_index_from_stringÚget_column_letterc ó e Zd ZdZy)ÚTranslatorErrora
|
Raised when a formula can't be translated across cells.
|
|
This error arises when a formula's references would be translated outside
|
the worksheet's bounds on the top or left. Excel represents these
|
situations with a #REF! literal error. E.g., if the formula at B2 is
|
'=A1', attempting to translate the formula to B1 raises TranslatorError,
|
since there's no cell above A1. Similarly, translating the same formula
|
from B2 to A2 raises TranslatorError, since there's no cell to the left of
|
A1.
|
|
N)Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__© ó úMH:\Change_password\venv_build\Lib\site-packages\openpyxl/formula/translate.pyr
|
r
|
s ò r r
|
c óÐ e Zd ZdZd Zd Z ej d« Z ej d« Z ej d« Z
|
e d « Z e d « Z e d « Zed
|
« Zd d Zy )Ú
|
Translatora5
|
Modifies a formula so that it can be translated from one cell to another.
|
|
`formula`: The str string to translate. Must include the leading '='
|
character.
|
`origin`: The cell address (in A1 notation) where this formula was
|
defined (excluding the worksheet name).
|
|
c óT t |« \ | _ | _ t |« | _ y ©N)r ÚrowÚcolr Ú tokenizer)ÚselfÚformulaÚorigins r Ú__init__zTranslator.__init__- s# ô 1°Ó 8Ñ$(Ü" 7Ó+r c ó. | j j S )z6Returns a list with the tokens comprising the formula.)r Úitems)r s r Ú
|
get_tokenszTranslator.get_tokens4 s à~~×#Ñ#Ð#r z*(\$?[1-9][0-9]{0,6}):(\$?[1-9][0-9]{0,6})$z&(\$?[A-Za-z]{1,3}):(\$?[A-Za-z]{1,3})$z'(\$?[A-Za-z]{1,3})(\$?[1-9][0-9]{0,6})$c óz | j d« r| S t | « |z }|dk r t d« t |« S )zL
|
Translate a range row-snippet by the given number of rows.
|
ú$r úFormula out of range)Ú
|
startswithÚintr
|
Ústr)Úrow_strÚrdeltaÚnew_rows r Ú translate_rowzTranslator.translate_row< sB ð
|
× Ñ cÔ "ØNä'l VÑ+GØ!|Ü%Ð&<Ó=Ð=Üw<Ð r c ó | j d« r| S t t | « |z « S # t $ r t d« w xY w)zN
|
Translate a range col-snippet by the given number of columns
|
r! r" )r# r r Ú
|
ValueErrorr
|
)Úcol_strÚcdeltas r Ú translate_colzTranslator.translate_colI sS ð
|
× Ñ cÔ "ØNð >Ü(Ü,¨WÓ5¸Ñ>ó@ð @øä ò >Ü%Ð&<Ó=Ð=ð >ús , ¬Ac óJ d| v r | j dd« \ }} |dz | fS d| fS )zCSplits out the worksheet reference, if any, from a range reference.ú!r Ú )Úrsplit)Ú range_strÚsheets r Ú strip_ws_namezTranslator.strip_ws_nameW s< ð )Ñ Ø (× /Ñ /°°QÓ 7Ñ E9Ø3; Ð)Ð )Ø9}Ð r c óö j |« \ }} j j |« }|I| j |j d« « z dz j |j d« « z S j
|
j |« }|I| j |j d« « z dz j |j d« « z S d|v r.|dj fd|j d« D « « z S j j |« }||S | j |j d« « z j |j d« « z S )aV
|
Translate an A1-style range reference to the destination cell.
|
|
`rdelta`: the row offset to add to the range
|
`cdelta`: the column offset to add to the range
|
`range_str`: an A1-style reference to a range. Potentially includes
|
the worksheet reference. Could also be a named range.
|
|
r ú:é c 3 óD K | ] }j |« y wr )Útranslate_range)Ú.0Úpiecer- Úclsr' s r ú <genexpr>z-Translator.translate_range.<locals>.<genexpr> s( øè ø ò &3àð ×#Ñ# E¨6°6×:ñ&3ùs )
|
r5 Ú ROW_RANGE_REÚmatchr) ÚgroupÚ COL_RANGE_REr. ÚjoinÚsplitÚ CELL_REF_RE)r= r3 r' r- Úws_partr@ s ` `` r r: zTranslator.translate_rangee sv ú ð !× .Ñ .¨yÓ 9ÑØ× Ñ ×&Ñ& yÓ1Ø Ð Øc× /Ñ /°· ± ¸A³ÀÓ GÑGÈ#ÑMØ×'Ñ'¨¯ © °A«¸Ó?ñ@ð Aà× Ñ ×&Ñ& yÓ1Ø Ð Øc× /Ñ /°· ± ¸A³ÀÓ GÑGÈ#ÑMØ×'Ñ'¨¯ © °A«¸Ó?ñ@ð Aà )Ñ ð SXXõ &3à &__¨SÓ 1ô&3ó 3ñ 3ð 3ð ×%Ñ% iÓ0Ø =Ø Ð Ø#×+Ñ+¨E¯K©K¸«N¸FÓCÑCØ×#Ñ# E§K¡K°£N°FÓ;ñ<ð =r Nc ó | j « }|sy|d j t j k( r|d j S dg}|r,t |« \ }}|| j z
|
}|| j z
|
}|D ] }|j t j k( rJ|j t j k( r-|j | j |j ||« « j|j |j « dj |« S )zÜ
|
Convert the formula into A1 notation, or as row and column coordinates
|
|
The formula is converted into A1 assuming it is assigned to the cell
|
whose address is `dest` (no worksheet name).
|
|
r1 r ú=)r Útyper ÚLITERALÚvaluer r r ÚOPERANDÚsubtypeÚRANGEÚappendr: rC ) r ÚdestÚ row_deltaÚ col_deltaÚtokensÚoutr r Útokens r Útranslate_formulaz Translator.translate_formula sá ð Ó"ÙØØ AY^^u}}Ò ,Ø!9??Ð "Øeñ Ü*¨4Ó0HCØdhhIØdhhIØò (EØ
|
|
emmÒ+ØMM¤U§[¡[Ò0Ø
|
|
4×/Ñ/°· ± ¸YØ09ó ;õ <ð
|
|
5;;Õ'ð (ð wws|Ðr )Nr r )r r r r r r ÚreÚcompiler? rB rE Ú staticmethodr) r. r5 Ú classmethodr: rV r r r r r ! s ñò,ò$ð 2::Ð KÓLLØ 2::Ð GÓHLØ "**Ð GÓHKàñ
|
ó ð
|
ð ñ >ó ð >ð ñ ó ð ð ñ =ó ð =ôD r r ) r rW r r r Úopenpyxl.utilsr r r Ú Exceptionr
|
r r r r ú<module>r] s4 ðñó
|
ß '÷ñ ô iô ÷ E ò E r
|
