�
��^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 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
t xmls %ss% |
%s
| s 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 | � | | %s( 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
%sI � 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 %s( R{ ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR� e s c C s d t | j � S( Ns %s( t reprR{ ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt
_xml_floath s c C s d t | j � S( Ns %s( 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 %s( 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, %s( 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 s s s s s 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 i t minsizei@ RR t WEs s s 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 ( 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 s@ �Y )6 � C