h^SrSSKrSSKJrJr SSKJrJrJr "SS\ 5r "SS 5r g) 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) TokenizerToken)coordinate_to_tuplecolumn_index_from_stringget_column_letterc\rSrSrSrSrg)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____firstlineno____doc____static_attributes__r L/var/www/html/env/lib/python3.13/site-packages/openpyxl/formula/translate.pyr r s rr c\rSrSrSrSrSr\R"S5r \R"S5r \R"S5r \ S5r \ S 5r\ S 5r\S 5rSS jrSrg ) Translator!a 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). cT[U5uUlUl[U5UlgN)rrowcolr tokenizer)selfformulaorigins r__init__Translator.__init__-s#18$("7+rc.URR$)z6Returns a list with the tokens comprising the formula.)ritems)rs r get_tokensTranslator.get_tokens4s~~###rz*(\$?[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})$cURS5(aU$[U5U-nUS::a [S5e[U5$)z< Translate a range row-snippet by the given number of rows. $rFormula out of range) startswithintr str)row_strrdeltanew_rows r translate_rowTranslator.translate_row<sE   c " "N'lV+G!|%&<==w< rcURS5(aU$[[U5U-5$![a [ S5ef=f)z> Translate a range col-snippet by the given number of columns r'r()r)rr ValueErrorr )col_strcdeltas r translate_colTranslator.translate_colIsV   c " "N >(,W5>@@ >%&<== >s 1AcLSU;aURSS5upUS-U4$SU4$)zCSplits out the worksheet reference, if any, from a range reference.!r)rsplit) range_strsheets r strip_ws_nameTranslator.strip_ws_nameWs: ) (//Q7 E3; ) )9}rc^^^TRU5upATRRU5nUbIUTRUR S5T5-S-TRUR S5T5-$TR RU5nUbIUTR UR S5T5-S-TR UR S5T5-$SU;a/USRUUU4SjURS555-$TRRU5nUcU$UTR UR S5T5-TRUR S5T5-$)a& 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:c3J># UHnTRUTT5v M g7fr)translate_range).0piecer4clsr-s r -Translator.translate_range..s*&31E##E66::1s #) r= ROW_RANGE_REmatchr/group COL_RANGE_REr5joinsplit CELL_REF_RE)rFr;r-r4ws_partrJs` `` rrCTranslator.translate_rangeest!..y9  &&y1  c// AGG#M'' A?@ A  &&y1  c// AGG#M'' A?@ A )  SXX&3&__S1&333 3%%i0 = #++EKKNFCC##EKKNF;< =rNc6UR5nU(dgUSR[R:XaUSR$S/nU(a)[ U5upgX`R - nXpR- nUHnUR[R:XaLUR[R:Xa.URURURUU55 MmURUR5 M SRU5$)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). r9r=)r$typerLITERALvaluerrrOPERANDsubtypeRANGEappendrCrM) rdest row_delta col_deltatokensoutrrtokens rtranslate_formulaTranslator.translate_formulas" AY^^u}} ,!9?? "e *40HChhIhhIE emm+MMU[[0 4// Y09;< 5;;' wws|r)rrr)Nrr)r rrrrr r$recompilerIrLrO staticmethodr/r5r= classmethodrCrarr rrrr!s,$::KLL::GHL**GHK     > >   = =Drr) rrcrrropenpyxl.utilsrrr Exceptionr rr rrris4 ' i EEr