Edit File: ss1.pyc
� ��^c @ s� d Z d d l Z d d l Z d d l Z d d l Z d d l Z d d l m Z d d d f \ Z Z Z d � Z d � Z d � Z i e e 6e e 6e e 6Z i d e 6d e 6d e 6Z i e d 6e d 6e d 6Z i d e 6d e 6d e 6Z d � Z d f d � � YZ d f d � � YZ d f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ d � Z d � Z d � Z d � Z d d l Z d f d! � � YZ d" � Z d# � Z! e" d$ k r�e! � n d S(% s SS1 -- a spreadsheet.i����N( t expatt LEFTt CENTERt RIGHTc C s | j | � S( N( t ljust( t xt n( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s c C s | j | � S( N( t center( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s c C s | j | � S( N( t rjust( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s t leftR t rightt wt ec C s4 d } x' | D] } | d k r | | 7} q q W| S( Ni ( t None( t seqt totalR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt sum s t Sheetc B s� e Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( c C sO i | _ t j � | _ | j j d � } | j | _ | j | _ t | _ d S( Nt __main__( t cellst rexect RExect add_modulet cellvaluet cellt multicellvalueR ( t selft m( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt __init__" s c C s9 | j | | � } t | d � r1 | j | j � S| Sd S( Nt recalc( t getcellt hasattrR R ( R R t yR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR * s c C s� | | k r | | } } n | | k r8 | | } } n g } xR t | | d � D]= } x4 t | | d � D] } | j | j | | � � ql WqR W| S( Ni ( t ranget appendR ( R t x1t y1t x2t y2R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR 1 s !c C s | j j | | f � S( N( R t get( R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR < s c C sJ | d k r | d k s t � t | t � s3 t � | | j | | f <d S( Ni ( t AssertionErrort isinstancet BaseCellR ( R R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt setcell? s c C s, y | j | | f =Wn t k r' n Xd S( N( R t KeyError( R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt clearcellD s c C s1 x* | j | | | | � D] } | j | =q Wd S( N( t selectcellsR ( R R# R$ R% R& t xy( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt clearcellsJ s c C s | j d | t j | � d S( Ni ( R0 t syst maxint( R R$ R& ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt clearrowsN s c C s | j | d | t j � d S( Ni ( R0 R1 R2 ( R R# R% ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt clearcolumnsQ s c C s� | | k r | | } } n | | k r8 | | } } n g | j D]P \ } } | | k oe | k n rB | | k o� | k n rB | | f ^ qB S( N( R ( R R# R$ R% R& R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR. T s c C sI | d k r | d k r d S| | k r8 | | } } n | | k rT | | } } n | | d k rt | | d k sz t � i } x� | j D]� \ } } | j | | f } t | d � r� | j | | | | | | � } n | | k o� | k n r(| | k o | k n r(| | 7} | | 7} n | | | | f <q� W| | _ d S( Ni t renumber( R( R R R5 ( R R# R$ R% R& t dxt dyt newR R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt movecells\ s" &!8 c C s8 | d k s t � | j d | t j t j d | � d S( Ni ( R( R9 R1 R2 ( R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt insertrowso s c C s^ | | k r | | } } n | j | | � | j d | d t j t j d | | d � d S( Ni i ( R3 R9 R1 R2 ( R R$ R& ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt deleterowss s c C s8 | d k s t � | j | d t j t j | d � d S( Ni ( R( R9 R1 R2 ( R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt insertcolumnsy s c C s^ | | k r | | } } n | j | | � | j | d d t j t j | | d d � d S( Ni i ( R0 R9 R1 R2 ( R R# R% ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt deletecolumns} s c C sL d } } x5 | j D]* \ } } t | | � } t | | � } q W| | f S( Ni ( R t max( R t maxxt maxyR R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt getsize� s c C s: x3 | j j � D]" } t | d � r | j � q q Wd S( Nt reset( R t itervaluesR RB ( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRB � s c C sJ | j � x9 | j j � D]( } t | d � r | j | j � q q Wd S( NR ( RB R RC R R R ( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s c C s� | j � \ } } | d | d } } d g | } i } xZ t d | � D]I } t | � t f | | d f <\ } } t | | t | � � | | <qJ WxZ t d | � D]I } t | � t f | d | f <\ } } t | d t | � � | d <q� Wx| j j � D]\ \ } } } | d k s| d k r4qn t | d � rV| j | j � n t | d � r�| j � \ } } t | t � s�t � | t t t f k s�t � n* t | � } t | t � r�t } n t } | | f | | | f <t | | t | � � | | <qWd } x9 t | � D]+ } | r7| d 7} n | d | | 7} q Wx� t | � D]� } d } xo t | � D]a } | j | | f � p�d t f \ } } t | | | | � } | r�| d 7} n | | 7} qsW| GH| d k rZ| GHqZqZWd S( Ni i R t formatt t +t -t |( RA R! t colnum2nameR R> t lent strR t iteritemsR R R RD R) R( R R R' t align2action( R R? R@ t widtht heightt colwidtht fullR t textt alignmentR R t sept line( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt display� sR &!&!" ! ' c C s� d g } xn | j j � D]] \ \ } } } t | d � rI | j � } n d t j | � } | j d | | | f � q W| j d � d j | � S( Ns <spreadsheet>t xmls <value>%s</value>s% <cell row="%s" col="%s"> %s </cell>s </spreadsheet>s ( R RL R RW t cgit escapeR" t join( R t outR R R t cellxml( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRW � s " c C s\ | j � } t | d � } | j | � | rN | j d � rN | j d � n | j � d S( NR s ( RW t opent writet endswitht close( R t filenameRR t f( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt save� s c C s0 t | d � } t | � j | � | j � d S( Nt r( R] t SheetParsert parsefileR` ( R Ra Rb ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt load� s ( t __name__t __module__R R R R R+ R- R0 R3 R4 R. R9 R: R; R< R= RA RB R RV RW Rc Rg ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s, 2 Re c B s� e Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z e Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( c C s | | _ d S( N( t sheet( R Rj ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s c C sA t j � } | j | _ | j | _ | j | _ | j | � d S( N( R t ParserCreatet startelementt StartElementHandlert endelementt EndElementHandlert datat CharacterDataHandlert ParseFile( R Rb t parser( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRf � s c C sc t | d | d � } | rV x* | j � D] \ } } t | � | | <q) W| | � n g | _ d S( Nt start_( t getattrR RL RK t texts( R t tagt attrst methodt keyt value( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRl � s c C s t | � } | j j | � d S( N( RK Rv R" ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRp � s c C s9 t | d | d � } | r5 | d j | j � � n d S( Nt end_RE ( Ru R RZ Rv ( R Rw Ry ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRn � s c C s4 t | j d � � | _ t | j d � � | _ d S( Nt rowt col( t intR' R R ( R Rx ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt start_cell� s c C s1 | j d � | _ t j | j d � � | _ d S( NRD t align( R' t fmtt xml2alignRS ( R Rx ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt start_value s c C s* y t | � | _ Wn d | _ n Xd S( N( R R{ R ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt end_int s c C s* y t | � | _ Wn d | _ n Xd S( N( t longR{ R ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt end_long s c C s* y t | � | _ Wn d | _ n Xd S( N( t floatR{ R ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt end_double s c C s* y t | � | _ Wn d | _ n Xd S( N( t complexR{ R ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt end_complex s c C s$ y | | _ Wn d | _ n Xd S( N( R{ R ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt end_string s c C s� t | j t � r! | j | _ ni t | j t � r` t | j | j pH d | j pT t � | _ n* t | j | j pu d | j p� t � | _ d S( Ns %s( R) R{ R* R RK t StringCellR� RS R t NumericCellR ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt end_value% s c C s+ t | | j p d | j p t � | _ d S( Ns %s( t FormulaCellR� RS R R ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt end_formula1 s c C s# | j j | j | j | j � d S( N( Rj R+ R R R ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt end_cell6 s ( Rh Ri R Rf Rl Rp Rn R� R� t start_formulaR� R� R� R� R� R� R� R� ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRe � s R* c B s e Z d Z RS( N( Rh Ri R R ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR* 9 s R� c B sV e Z d e d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( s %sc C s[ t | t t t t f � s! t � | t t t f k s< t � | | _ | | _ | | _ d S( N( R) R R� R� R� R( R R R R{ R� RS ( R R{ R� RS ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR G s ! c C s | j S( N( R{ ( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR N s c C s: y | j | j } Wn t | j � } n X| | j f S( N( R� R{ RK RS ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRD Q s c C s= t | d t | j � j � } d t | j | j | � f S( Nt _xml_s( <value align="%s" format="%s">%s</value>( Ru t typeR{ Rh t align2xmlRS R� ( R Ry ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRW X s c C s8 d | j k o d k n r* d | j S| j � Sd S( Ni i s <int>%s</int>I � i �I � ( R{ t _xml_long( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt _xml_int_ s c C s d | j S( Ns <long>%s</long>( R{ ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� e s c C s d t | j � S( Ns <double>%s</double>( t reprR{ ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt _xml_floath s c C s d t | j � S( Ns <complex>%s</double>( R� R{ ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt _xml_complexk s ( Rh Ri R R R RD RW R� R� R� R� ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� E s R� c B s2 e Z d e d � Z d � Z d � Z d � Z RS( s %sc C sU t | t t f � s t � | t t t f k s6 t � | | _ | | _ | | _ d S( N( R) RK t unicodeR( R R R RR R� RS ( R RR R� RS ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR p s c C s | j S( N( RR ( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR w s c C s | j | j f S( N( RR RS ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRD z s c C s- d } | t | j | j t j | j � f S( Ns9 <value align="%s" format="%s"><string>%s</string></value>( R� RS R� RX RY RR ( R t s( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRW } s ( Rh Ri R R R RD RW ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� n s R� c B sD e Z d e d � Z d � Z d � Z d � Z d � Z d � Z RS( s %sc C sV | t t t f k s t � | | _ t | j � | _ | | _ | | _ | j � d S( N( R R R R( t formulat translatet translatedR� RS RB ( R R� R� RS ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s c C s d | _ d S( N( R R{ ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRB � s c C s� | j d k r� y4 | j d d t | j � � | j d � | _ Wq� t j � d } t | d � rw | j | _ q� t | � | _ q� Xn | j S( Ns from __future__ import division s __value__ = eval(%s)t __value__i Rh ( R{ R t r_execR� R� t r_evalR1 t exc_infoR Rh RK ( R R t exc( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s c C s: y | j | j } Wn t | j � } n X| | j f S( N( R� R{ RK RS ( R RR ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRD � s c C s d t | j | j | j f S( Ns, <formula align="%s" format="%s">%s</formula>( R� RS R� R� ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRW � s c C s� g } x� t j d | j � D]� } t j d | � } | d k r� | j � \ } } t | � } t | � } | | k o� | k n r� | | k o� | k n r� t | | | | � } q� n | j | � q Wt d j | � | j | j � S( Ns (\w+)s ^([A-Z]+)([1-9][0-9]*)$RE ( t ret splitR� t matchR t groupst colname2numR t cellnameR" R� RZ R� RS ( R R# R$ R% R& R6 R7 R[ t partR t sxt syR R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR5 � s 8 ( Rh Ri R R RB R RD RW R5 ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C s� g } x� t j d | � D]� } t j d | � } | d k rM | j | � q | j � \ } } } } t | � } | d k r� d | | f } n" t | � } d | | | | f } | j | � q Wd j | � S( s� Translate a formula containing fancy cell names to valid Python code. Examples: B4 -> cell(2, 4) B4:Z100 -> cells(2, 4, 26, 100) s (\w+(?::\w+)?)s2 ^([A-Z]+)([1-9][0-9]*)(?::([A-Z]+)([1-9][0-9]*))?$s cell(%s, %s)s cells(%s, %s, %s, %s)RE N( R� R� R� R R" R� R� RZ ( R� R[ R� R R# R$ R% R& R� ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C s& | d k s t � t | � t | � S( sE Translate a cell coordinate to a fancy cell name (e.g. (1, 1)->'A1').i ( R( RI RK ( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C sk | j � } d } xR | D]J } d | k o6 d k n sA t � | d t | � t d � d } q W| S( sC Translate a column name to number (e.g. 'A'->1, 'Z'->26, 'AA'->27).i t At Zi i ( t upperR( t ord( R� R t c( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s "&c C s\ | d k s t � d } x= | rW t | d d � \ } } t | t d � � | } q W| S( s6 Translate a column number to name (e.g. 1->'A', etc.).i RE i i R� ( R( t divmodt chrR� ( R R� R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRI � s t SheetGUIc B s� e Z d Z d d d d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z e Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( s7 Beginnings of a GUI for a spreadsheet. TO DO: - clear multiple cells - Insert, clear, remove rows or columns - Show new contents while typing - Scroll bars - Grow grid when window is grown - Proper menus - Undo, redo - Cut, copy and paste - Formatting and alignment s sheet1.xmli i c C s* | | _ t � | _ t j j | � r: | j j | � n | j j � \ } } t | | � } t | | � } t j � | _ | j j d | j � t j | j d d d d �| _ t j | j � | _ t j | j d d d | j �| _ t j | j � | _ | j j d d d d d d � | j j d d � | j j d d � | j j d d d d d d � | j j d | j � | j j d | j � | j j d | j � | j j d | j � | j j d | j � | j j d | j � | j | | � d | _ d | _ | j! d d � | j" � d S( sl Constructor. Load the sheet from the filename argument. Set up the Tk widget tree. s Spreadsheet: %sRR t A1t fontt helveticai t boldt Savet commandt sidet bottomt expandi t fillt bothR R R s <Return>s <Shift-Return>s <Tab>s <Shift-Tab>s <Delete>s <Escape>N( R� i R� (# Ra R Rj t ost patht isfileRg RA R> t Tkt roott wm_titlet Labelt beacont Entryt entryt ButtonRc t savebuttont Framet cellgridt packt bindt return_eventt shift_return_eventt tab_eventt shift_tab_eventt delete_eventt escape_eventt makegridR t currentxyt cornerxyt setcurrentt sync( R Ra t rowst columnsR? R@ ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s< c C sr | j | j k r> | j d k r> | j j | j | j � n | j j | j � | j � | j j d d � d S( Ni t endt break( R� R� R Rj R0 R- R� R� t delete( R t event( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� ' s ! c C s# | j \ } } | j | | � d S( N( R� t load_entry( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� 0 s c C s� | j j | | � } | d k r* d } n1 t | t � rI d | j } n | j � \ } } | j j d d � | j j d | � | j j d d � d S( NRE t =i R� ( Rj R R R) R� R� RD R� R� t insertt selection_range( R R R R RR RS ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� 4 s c C s | | _ | | _ i | _ t j | j d d �} | j d d d d d d � | j d | j � x� t d | d � D]� } | j j | d d �t j | j d t | � d d �} | j d | d d d d � | | j | d f <| | _ d | _ | j d | j � | j d | j � | j d | j � | j d | j � qv Wx� t d | d � D]� } t j | j d t | � d d �} | j d d d | d d � | | j d | f <d | _ | | _ | j d | j � | j d | j � | j d | j � | j d | j � q[Wx� t d | d � D]� } x� t d | d � D]� } t j | j d d d d d d �} | j d | d | d d � | | j | | f <| | _ | | _ | j d | j � | j d | j � | j d | j � | j d | j � qDWq*Wd S( s� Helper to create the grid of GUI cells. The edge (x==0 or y==0) is filled with labels; the rest is real cells. t relieft raisedt columni R} t stickyt NSWEs <ButtonPress-1>i t minsizei@ RR t WEs <B1-Motion>s <ButtonRelease-1>s <Shift-Button-1>t sunkent bgt whitet fgt blackN( R� R� t gridcellsR� R� R� t grid_configureR� t selectallR! t grid_columnconfigureRI t _SheetGUI__xt _SheetGUI__yt selectcolumnt extendcolumnRK t selectrowt extendrowt presst motiont release( R R� R� R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� @ sN $ $ c C s* | j d d � | j t j t j � d S( Ni ( R� t setcornerR1 R2 ( R R� ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� r s c C s< | j | � \ } } | j | d � | j | t j � d S( Ni ( t whichxyR� R R1 R2 ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� v s c C sR | j | � \ } } | d k rN | j | j d d � | j | t j � n d S( Ni i ( R R� R� R R1 R2 ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� { s c C s< | j | � \ } } | j d | � | j t j | � d S( Ni ( R R� R R1 R2 ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C sR | j | � \ } } | d k rN | j d | j d � | j t j | � n d S( Ni i ( R R� R� R R1 R2 ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C sD | j | � \ } } | d k r@ | d k r@ | j | | � n d S( Ni ( R R� ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C sD | j | � \ } } | d k r@ | d k r@ | j | | � n d S( Ni ( R R ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C sh | j j | j | j � } | d k rd t | t j � rd y | j | j f SWqd t k r` qd Xn d S( Ni ( i i ( R� t winfo_containingt x_roott y_rootR R) R� R� R� R� t AttributeError( R R� R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s c C s | j j | j � d S( N( Rj Rc Ra ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRc � s c C s� | j d k r | j � n | j � t | | � | j d <| j | | � | j j � | | f | _ d | _ | j j | j � } | d k r� d | d <n d S( s Make (x, y) the current cell.RR t yellowR� N( R� R t change_cellt clearfocusR� R� R� R� t focus_setR� R� R' ( R R R t gridcell( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C sc | j d k s$ | j | | f k r8 | j | | � d S| j � | | f | _ | j \ } } | j po | j \ } } | | k r� | | } } n | | k r� | | } } n xh | j j � D]W \ \ } } } | | k o� | k n r� | | k o| k n r� d | d <q� q� W| j j | j � } | d k rId | d <n | j | | | | � d S( Nt lightBlueR� R ( R� R R� R R� R� RL R' t setbeacon( R R R R# R$ R% R& R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s$ $ "8 c C s# | | k o d k n rD | | k o6 t j k n rD d } n� | | f d t j f k r� | | k rx d | } qd | | f } n� | | f d t j f k r� | | k r� d t | � } qd t | � t | � f } n. t | j � } t | j � } d | | f } | | j d <d S( Ni t :s %ds %d:%ds %ss %s:%sRR ( R1 R2 RI R� R� R� R� ( R R# R$ R% R& t namet name1t name2( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s ; c C s� | j d k r� | j \ } } | j p- | j \ } } | | k rR | | } } n | | k rn | | } } n xk | j j � D]W \ \ } } } | | k o� | k n r~ | | k o� | k n r~ d | d <q~ q~ Wn d S( NR� R� ( R� R R� R� RL ( R R# R$ R% R& R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR � s "8c C s1 | j � | j \ } } | j | | d � d S( s Callback for the Return key.i R� ( R R� R� ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C s: | j � | j \ } } | j | t d | d � � d S( s0 Callback for the Return key with Shift modifier.i R� ( R R� R� R> ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C s1 | j � | j \ } } | j | d | � d S( s Callback for the Tab key.i R� ( R R� R� ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C s: | j � | j \ } } | j t d | d � | � d S( s- Callback for the Tab key with Shift modifier.i R� ( R R� R� R> ( R R� R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s c C s� | j \ } } | j j � } d } | j d � rF t | d � } nG xD t t t t f D]0 } y | | � } Wn qY qY Xt | � } PqY W| d k r� | r� t | � } n | d k r� | j j | | � n | j j | | | � | j � d S( s+ Set the current cell from the entry widget.R� i N( R� R� R' R t startswithR� R R� R� R� R� R� Rj R- R+ R� ( R R R RR R t clsR{ ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s$ c C s� | j j � x� | j j � D]� \ \ } } } | d k s | d k rM q n | j j | | � } | d k r{ d | d <q t | d � r� | j � \ } } n t | � t } } | | d <t | | d <q Wd S( s( Fill the GUI cells from the sheet cells.i RE RR RD t anchorN( Rj R R� RL R R R RD RK R t align2anchor( R R R R R RR RS ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� s " ( Rh Ri t __doc__R R� R� R� R� R� R� R� R� R� R� R� R� R Rc R� R R R R� R� R� R� R R� ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� � s4 - 2 c C s� d d l } t � } x� t d d � D]� } x� t d d � D]� } | d k r\ t | � } nU | d k rw t | � } n: t | d � } t d | � } d | | f } t | � } | j | | | � q; Wq% W| j � | j d � d S( s Basic non-gui self-test.i����Ni i s %s*%ss sheet1.xml( R� R R! R� R� R� R+ RV Rc ( R� t aR R R t c1t c2R� ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt test_basic, s c C s@ t j d r t j d } n d } t | � } | j j � d S( s GUI test.i s sheet1.xmlN( R1 t argvR� R� t mainloop( Ra t g( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt test_guiB s R (# R R� R� R1 RX R t xml.parsersR R R R R R R RM R� R� R R R Re R* R� R� R� R� R� R� RI t TkinterR� R� R R Rh ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt <module> s@ �Y )6 � C