^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 re! n d S(% s SS1 -- a spreadsheet.iN( 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