σ •‰]c@@s~ddlmZddlZddlmZmZddlmZmZm Z de fd„ƒYZ de fd „ƒYZ dS( i(tabsolute_importNi(t TokenizertToken(tcoordinate_to_tupletcolumn_index_from_stringtget_column_lettertTranslatorErrorcB@seZdZRS(s 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. (t__name__t __module__t__doc__(((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyRs t TranslatorcB@s›eZdZd„Zd„ZejdƒZejdƒZejdƒZ e d„ƒZ e d„ƒZ e d„ƒZ ed „ƒZd d d d „ZRS( s9 Modifies a formula so that it can be translated from one cell to another. `formula`: The unicode string to translate. Must include the leading '=' character. `origin`: The cell address (in A1 notation) where this formula was defined (excluding the worksheet name). cC@s+t|ƒ\|_|_t|ƒ|_dS(N(RtrowtcolRt tokenizer(tselftformulatorigin((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyt__init__/scC@s |jjS(s6Returns a list with the tokens comprising the formula.(R titems(R((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyt get_tokens6ss*(\$?[1-9][0-9]{0,6}):(\$?[1-9][0-9]{0,6})$s&(\$?[A-Za-z]{1,3}):(\$?[A-Za-z]{1,3})$s'(\$?[A-Za-z]{1,3})(\$?[1-9][0-9]{0,6})$cC@sL|jdƒr|St|ƒ|}|dkr>tdƒ‚nt|ƒSdS(sL Translate a range row-snippet by the given number of rows. t$isFormula out of rangeN(t startswithtintRtstr(trow_strtrdeltatnew_row((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyt translate_row>s  cC@sO|jdƒr|Sytt|ƒ|ƒSWntk rJtdƒ‚nXdS(sN Translate a range col-snippet by the given number of columns RsFormula out of rangeN(RRRt ValueErrorR(tcol_strtcdelta((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyt translate_colKs cC@s<d|kr2|jddƒ\}}|d|fSd|fS(sCSplits out the worksheet reference, if any, from a range reference.t!it(trsplit(t range_strtsheet((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyt strip_ws_nameYs c@sYˆj|ƒ\}}ˆjj|ƒ}|dk rm|ˆj|jdƒˆƒdˆj|jdƒˆƒSˆjj|ƒ}|dk rΕ|ˆj|jdƒˆƒdˆj|jdƒˆƒSd|kr|dj‡‡‡fd†|j dƒDƒƒSˆj j|ƒ}|dkr#|S|ˆj|jdƒˆƒˆj|jdƒˆƒS(sV 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. it:ic3@s$|]}ˆj|ˆˆƒVqdS(N(ttranslate_range(t.0tpiece(RtclsR(s9lib/python2.7/site-packages/openpyxl/formula/translate.pys ‚sN( R%t ROW_RANGE_REtmatchtNoneRtgroupt COL_RANGE_RERtjointsplitt CELL_REF_RE(R*R#RRtws_partR,((RR*Rs9lib/python2.7/site-packages/openpyxl/formula/translate.pyR'gs  : :   ic C@sι|jƒ}|sdS|djtjkr7|djSdg}|rut|ƒ\}}||j}||j}nxd|D]\}|jtjkrΘ|j tj krΘ|j |j |j||ƒƒq||j |jƒq|Wdj |ƒS(sά 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). R!it=(RttypeRtLITERALtvalueRR R tOPERANDtsubtypetRANGEtappendR'R0( Rtdestt row_deltat col_deltattokenstoutR R ttoken((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyttranslate_formulaŠs"      N(RRR RRtretcompileR+R/R2t staticmethodRRR%t classmethodR'R-RB(((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyR #s    #(t __future__RRCR RRtopenpyxl.utilsRRRt ExceptionRtobjectR (((s9lib/python2.7/site-packages/openpyxl/formula/translate.pyts