File: //proc/2/root/usr/lib/python2.4/Demo/tkinter/guido/ss1.pyo
m
=5Dc @ s d Z d k Z d k Z d k Z d k Z d k Z d k l Z d d d f \ Z Z Z
d Z d Z d Z
h e e <e e <e
e
<Z h e d <e d
<e
d <Z h d e <d
e <d e
<Z h e d <e d
<e
d
<Z 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 k Z d f d YZ d! Z d" Z! e" d# j o e! n d S($ s SS1 -- a spreadsheet.N( s expatt LEFTt CENTERt RIGHTc C s
| i | S( N( t xt ljustt n( R R ( ( t, /usr/lib/python2.4/Demo/tkinter/guido/ss1.pyR s c C s
| i | S( N( R t centerR ( R R ( ( R R s c C s
| i | S( N( R t rjustR ( R R ( ( R R s t leftR t rightt wt ec C s6 d } x) | D]! } | d j o | | 7} q
q
W| S( Ni ( t totalt seqR t None( R R R
( ( R t sum s
t Sheetc B s t 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( Nc C sO h | _ t i | _ | i i d } | i | _ | i | _ t | _ d S( Nt __main__(
t selft cellst rexect RExect
add_modulet mt cellvaluet cellt multicellvalueR ( R R ( ( R t __init__" s c C s> | i | | } t | d o | i | i Sn | Sd S( Nt recalc( R t getcellR t yR t hasattrR R ( R R R R ( ( R R * s c C s | | j o | | } } n | | j o | | } } n g } xR t | | d D]= } x4 t | | d D] } | i | i
| | qp WqV W| S( Ni ( t x1t x2t y1t y2R t rangeR R t appendR R ( R R! R# R" R$ R R R ( ( R R 1 s
!c C s | i i | | f S( N( R R t getR R ( R R R ( ( R R < s c C s | | i | | f <d S( N( R R R R R ( R R R R ( ( R t setcell? s c C s. y | i | | f =Wn t j
o n Xd S( N( R R R R t KeyError( R R R ( ( R t clearcellD s c C s1 x* | i | | | | D] } | i | =q Wd S( N( R t selectcellsR! R# R" R$ t xyR ( R R! R# R" R$ R, ( ( R t
clearcellsJ s c C s | i d | t i | d S( Ni ( R R- R# t syst maxintR$ ( R R# R$ ( ( R t clearrowsN s c C s | i | d | t i d S( Ni ( R R- R! R" R. R/ ( R R! R" ( ( R t clearcolumnsQ s c C s | | j o | | } } n | | j o | | } } n g } | i D]Y \ } } | | j o
| j n o/ | | j o
| j n o | | | f qJ qJ ~ S( N( R! R" R# R$ t _[1]R R R R ( R R! R# R" R$ R R2 R ( ( R R+ T s
c C s4 | d j o | d j o d Sn | | j o | | } } n | | j o | | } } n h }
x | i D] \ } } | i | | f } t | d o" | i
| | | | | | } n | | j o
| j n o6 | | j o
| j n o | | 7} | | 7} n | |
| | f <qn W|
| _ d S( Ni t renumber( t dxt dyR! R" R# R$ t newR R R R R R R3 ( R R! R# R" R$ R4 R5 R R R R6 ( ( R t movecells\ s$
"<
c C s& | i d | t i t i d | d S( Ni ( R R7 R R. R/ R ( R R R ( ( R t
insertrowso s c C s` | | j o | | } } n | i | | | i d | d t i t i d | | d d S( Ni i ( R# R$ R R0 R7 R. R/ ( R R# R$ ( ( R t
deleterowss s
c C s& | i | d t i t i | d d S( Ni ( R R7 R R. R/ R ( R R R ( ( R t
insertcolumnsy s c C s` | | j o | | } } n | i | | | i | d d t i t i | | d d d S( Ni i ( R! R" R R- R7 R. R/ ( R R! R" ( ( R t
deletecolumns} s
c C sL d } } x5 | i D]* \ } } t | | } t | | } q W| | f S( Ni ( t maxxt maxyR R R R t max( R R< R= R R ( ( R t getsize s
c C s< x5 | i i D]$ } t | d o | i q q Wd S( Nt reset( R R t
itervaluesR R R@ ( R R ( ( R R@ s c C sL | i x; | i i D]* } t | d o | i | i q q Wd S( NR ( R R@ R RA R R R R ( R R ( ( R R s
c C s | i \ } } | d | d } } d g | } h }
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 | i i D] \ \ }
} } |
d j p
| d j o qn t | d o | i | i n t | d o | i \ } } n- t | } t | t o
t } n t } | | f |
|
| f <t | |
t | | |
<qWd } x; t | D]- }
| o | d 7} n | d | |
7} qWx t | D] } d } xr t | D]d }
|
i |
| f p
d t f \ } } t | | | |
} | o | d 7} n | | 7} qNW| GH| d j o | GHq5q5Wd S( Ni i R t formatt t +t -t |( R R? R< R= t widtht heightt colwidtht fullR% R t colnum2nameR t textt alignmentR> t lenR t strR t iteritemsR R R R RB t
isinstanceR t sept lineR' t align2action( R RR RL RH RM R< R= R RG RI RJ RS R R ( ( R t display s^
&! &!
!
(
c C s d g } xp | i i D]_ \ \ } } } t | d o | i } n d t
i | } | i d | | | f q W| i d d i
| S( Ns
<spreadsheet>t xmls <value>%s</value>s% <cell row="%s" col="%s">
%s
</cell>s </spreadsheet>s
( t outR R RP R R R R RV t cellxmlt cgit escapeR& t join( R RX R R R RW ( ( R RV s
c C s_ | i } t | d } | i | | o" | i d o | i d n | i d S( NR s
( R RV RL t opent filenamet ft writet endswitht close( R R] RL R^ ( ( R t save s
c C s0 t | d } t | i | | i d S( Nt r( R\ R] R^ t SheetParserR t parsefileRa ( R R] R^ ( ( R t load s ( t __name__t
__module__R R R R R( R* R- R0 R1 R+ R7 R8 R9 R: R; R? R@ R RU RV Rb Rf ( ( ( R R s, 2 Rd c B s t 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( Nc C s
| | _ d S( N( t sheetR ( R Ri ( ( R R s c C sA t i } | i | _ | i | _ | i | _ | i
| d S( N( t expatt ParserCreatet parserR t startelementt StartElementHandlert
endelementt EndElementHandlert datat CharacterDataHandlert ParseFileR^ ( R R^ Rl ( ( R Re s
c C se t | d | d } | o; x* | i D] \ } } t | | | <q* W| | n g | _
d S( Nt start_( t getattrR t tagR t methodt attrsRP t keyt valueRO t texts( R Rv Rx Rz Ry Rw ( ( R Rm s
c C s t | } | i i | d S( N( RO RL R R{ R& ( R RL ( ( R Rq s c C s; t | d | d } | o | d i | i n d S( Nt end_RC ( Ru R Rv R Rw R[ R{ ( R Rv Rw ( ( R Ro s c C s4 t | i d | _ t | i d | _ d S( Nt rowt col( t intRx R' R R R ( R Rx ( ( R t
start_cell s c C s1 | i d | _ t i | i d | _ d S( NRB t align( Rx R' R t fmtt xml2alignRM ( R Rx ( ( R t start_value s c C s* y t | | _ Wn d | _ n Xd S( N( R RL R Rz R ( R RL ( ( R t end_int s c C s* y t | | _ Wn d | _ n Xd S( N( t longRL R Rz R ( R RL ( ( R t end_long
s c C s* y t | | _ Wn d | _ n Xd S( N( t floatRL R Rz R ( R RL ( ( R t
end_double s c C s* y t | | _ Wn d | _ n Xd S( N( t complexRL R Rz R ( R RL ( ( R t end_complex s c C s$ y
| | _ Wn d | _ n Xd S( N( RL R Rz R ( R RL ( ( R t
end_string s
c C s t | i t o | i | _ np t | i t o0 t | i | i p d | i p t | _ n- t
| i | i p d | i p t | _ d S( Ns %s( RQ R Rz t BaseCellR RO t
StringCellR RM R t NumericCellR ( R RL ( ( R t end_value% s
c C s- t | | i p d | i p t | _ d S( Ns %s( t FormulaCellRL R R RM R R ( R RL ( ( R t end_formula1 s
c C s# | i i | i | i | i d S( N( R Ri R( R R R ( R RL ( ( R t end_cell6 s ( Rg Rh R Re Rm Rq Ro R R t
start_formulaR R R R R R R R ( ( ( R Rd s R c B s t Z d Z RS( N( Rg Rh R R ( ( ( R R 9 s R c B sV t Z d e d Z d Z d Z d Z d Z d Z d Z d Z
RS(
Ns %sc C s | | _ | | _ | | _ d S( N( Rz R R RM ( R Rz R RM ( ( R R G s
c C s | i S( N( R Rz ( R R ( ( R R N s c C s: y | i | i } Wn t | i } n X| | i f S( N( R R Rz RL RO RM ( R RL ( ( R RB Q s
c C s= t | d t | i i } d t | i | i | f S( Nt _xml_s( <value align="%s" format="%s">%s</value>( Ru R t typeRz Rg Rw t align2xmlRM R ( R Rw ( ( R RV X s c C sG d d | i j o d d j n o d | i Sn | i Sd S( Ni i s
<int>%s</int>( R Rz t _xml_long( R ( ( R t _xml_int_ s *c C s d | i S( Ns <long>%s</long>( R Rz ( R ( ( R R e s c C s d t | i S( Ns <double>%s</double>( t reprR Rz ( R ( ( R t
_xml_floath s c C s d t | i S( Ns <complex>%s</double>( R R Rz ( R ( ( R t _xml_complexk s ( Rg Rh R R R RB RV R R R R ( ( ( R R E s R c B s2 t Z d e d Z d Z d Z d Z RS( Ns %sc C s | | _ | | _ | | _ d S( N( RL R R RM ( R RL R RM ( ( R R p s
c C s | i S( N( R RL ( R R ( ( R R w s c C s | i | i f S( N( R RL RM ( R ( ( R RB z s c C s- d } | t | i | i t i | i f S( Ns9 <value align="%s" format="%s"><string>%s</string></value>( t sR R RM R RY RZ RL ( R R ( ( R RV } s ( Rg Rh R R R RB RV ( ( ( R R n s R c B sD t Z d e d Z d Z d Z d Z d Z d Z RS( Ns %sc C s; | | _ t | i | _ | | _ | | _ | i d S( N( t formulaR t translatet
translatedR RM R@ ( R R R RM ( ( R R s c C s
d | _ d S( N( R R Rz ( R ( ( R R@ s c C s | i d j o y4 | i d d t | i | i d | _ Wq t i d } t | d o | i | _ q t
| | _ q Xn | i S( Ns from __future__ import division
s __value__ = eval(%s)t __value__i Rg ( R Rz R R t r_execR R t r_evalR. t exc_infot excR Rg RO ( R R R ( ( R R s c C s: y | i | i } Wn t | i } n X| | i f S( N( R R Rz RL RO RM ( R RL ( ( R RB s
c C s d t | i | i | i f S( Ns, <formula align="%s" format="%s">%s</formula>( R R RM R R ( R ( ( R RV s c C s g }
x t i d | i D] }
t i d |
} | d j o | i \ } } t | } t | } | | j o
| j n o9 | | j o
| j n o t | | | | }
q n |
i |
q Wt d i |
| i | i S( Ns (\w+)s ^([A-Z]+)([1-9][0-9]*)$RC ( RW t ret splitR R t partt matchR R t groupst sxt syt colname2numR R R R! R" R# R$ t cellnameR4 R5 R& R R[ R RM ( R R! R# R" R$ R4 R5 R R R R R R RW ( ( R R3 s
< ( Rg Rh R R R@ R RB RV R3 ( ( ( R R s c C s g } x t i d | D] } t i d | } | d j o | i | q | i \ } } } } t | } | d j o d | | f } n# t | } d | | | | f } | i | q Wd i | 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)RC N( RW R R R R R R R R& R R! R# R" R$ R R R[ ( R R$ R R" R R R# R! RW ( ( R R s
c C s t | t | S( sE Translate a cell coordinate to a fancy cell name (e.g. (1, 1)->'A1').N( RK R RO R ( R R ( ( R R s c C sI | i } d } x0 | D]( } | d t | t d d } q W| S( sC Translate a column name to number (e.g. 'A'->1, 'Z'->26, 'AA'->27).i i t Ai N( R t upperR t ct ord( R R R ( ( R R s &c C sL d } x? | o7 t | d d \ } } t | t d | } q W| S( s6 Translate a column number to name (e.g. 1->'A', etc.).RC i i R N( R R t divmodR t chrR ( R R R ( ( R RK s t SheetGUIc B s t 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 i i | o | i i | n | i i \ } } t | | } t | | } t i | _ | i i d | i t i | i d d d d | _ t i | i | _ t i | i d d d | i | _ t i | i | _ | i i d
d d d
d d | i i d
d | i i d
d | i i d
d d d
d d | i i d | i | i i d | i | i i d | i | i i d | i | i i d | i | i i d | i! | i" | | d | _$ d | _% | i& d
d
| i' d S( sl Constructor.
Load the sheet from the filename argument.
Set up the Tk widget tree.
s Spreadsheet: %sRL 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 (( R] R R Ri t ost patht isfileRf R? R< R= R> t rowst columnst Tkt roott wm_titlet Labelt beacont Entryt entryt ButtonRb 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 R] R R R< R= ( ( R R s> c C su | i | i j o. | i d j o | i i | i | i n | i i | i | i | i i d d d S( Ni t endt break(
R R R R Ri R- R* R R t delete( R t event( ( R R ' s #
c C s# | i \ } } | i | | d S( N( R R R R t
load_entry( R R R R ( ( R R 0 s c C s | i i | | } | d j o
d } n4 t | t o d | i
} n | i \ } } | i
i d d | i
i d | | i
i d d d S( NRC t =i R ( R Ri R R R R R RL RQ R R RB RM R R t insertt selection_range( R R R RL R RM ( ( R R 4 s
c
C s | | _ | | _ h | _ t i | i d d } | i d d d d d d | i d | i
x t d | d D] } | i i
| d
d t i | i d t | d d } | i d | d d d d
| | i | d f <| | _ d | _ | i d | i | i d | i | i d | i | i d | i qv Wx t d | d D] } t i | i d t | d d } | i d d d | d d
| | i d | f <d | _ | | _ | i d | i | i d | i | i d | i | i d | i q[Wx t d | d D] } x t d | d D] } t i | i d d d d d d } | i d | d | d d | | i | | f <| | _ | | _ | i d | i | i d | i | i d | i | i d | i 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@ RL t WEs <B1-Motion>s <ButtonRelease-1>s <Shift-Button-1>t sunkent bgt whitet fgt blackN( R R R t gridcellsR R R R t grid_configureR t selectallR% R t grid_columnconfigureRK t _SheetGUI__xt _SheetGUI__yt selectcolumnt extendcolumnR RO t selectrowt extendrowt presst motiont release( R R R R R R ( ( R R @ sX $ $ c C s* | i d d | i t i t i d S( Ni ( R R t setcornerR. R/ ( R R ( ( R R r s c C s< | i | \ } } | i | d | i | t i d S( Ni ( R t whichxyR R R R R R. R/ ( R R R R ( ( R R v s c C sT | i | \ } } | d j o. | i | i d d | i | t i n d S( Ni i (
R R R R R R R R R. R/ ( R R R R ( ( R R { s
c C s< | i | \ } } | i d | | i t i | d S( Ni ( R R R R R R R R. R/ ( R R R R ( ( R R s c C sT | i | \ } } | d j o. | i d | i d | i t i | n d S( Ni i (
R R R R R R R R R. R/ ( R R R R ( ( R R s
c C sG | i | \ } } | d j o! | d j o | i | | n d S( Ni ( R R R R R R ( R R R R ( ( R R s c C sG | i | \ } } | d j o! | d j o | i | | n d S( Ni ( R R R R R R ( R R R R ( ( R R s c C sm | i i | i | i } | d j oA t | t i
o. y | i | i f SWqi t
j
o qi Xn d S( Ni ( i i ( R R t winfo_containingR t x_roott y_rootR R RQ R R R R t AttributeError( R R R ( ( R R s c C s | i i | i d S( N( R Ri Rb R] ( R ( ( R Rb s c C s | i d j o | i n | i t | | | i d <| i | | | i
i | | f | _ d | _ | i
i | i } | d j o d | d <n d S( s Make (x, y) the current cell.RL t yellowR N( R R R t change_cellt
clearfocusR R R R R R t focus_setR R R' t gridcell( R R R R ( ( R R s
c C su | i d j p | i | | f j o | i | | d Sn | i | | f | _ | i \ } } | i p | i \ } } | | j o | | } } n | | j o | | } } n xm | i i
D]\ \ \ } } } | | j o
| j n o, | | j o
| j n o d | d <q q W| i i | i } | d j o d | d <n | i | | | | d S( Nt lightBlueR R ( R R R R R R R R R! R# R" R$ R RP R R' R t setbeacon( R R R R R$ R R" R# R! ( ( R R s& &
<
c C s0 | | j o
d j n o+ | | j o
t i j n o
d } n | | f d t i f j o/ | | j o d | } q d | | f } n | | f d t i f j oA | | j o d t | } q d t | t | f } n/ t | i
} t | i } d | | f } | | i d <d S( Ni t :s %ds %d:%ds %ss %s:%sRL ( R! R# R" R$ R. R/ t nameRK R R R t name1R t name2R ( R R! R# R" R$ R
R R ( ( R R s ?
c C s | i d j o | i \ } } | i p | i \ } } | | j o | | } } n | | j o | | } } n xq | i i D]\ \ \ } } } | | j o
| j n o, | | j o
| j n o d | d <q q Wn d S( NR R (
R R R R! R# R R" R$ R RP R R R ( R R$ R R R" R# R R! ( ( R R s
<c C s1 | i | i \ } } | i | | d d S( s Callback for the Return key.i R N( R R R R R R ( R R R R ( ( R R s
c C s: | i | i \ } } | i | t d | d d S( s0 Callback for the Return key with Shift modifier.i R N( R R R R R R R> ( R R R R ( ( R R s
c C s1 | i | i \ } } | i | d | d S( s Callback for the Tab key.i R N( R R R R R R ( R R R R ( ( R R s
c C s: | i | i \ } } | i t d | d | d S( s- Callback for the Tab key with Shift modifier.i R N( R R R R R R R> ( R R R R ( ( R R s
c C s | i \ } } | i i } d } | i d o t
| d } nH xD t t t
t f D]0 } y | | } Wn
q[ q[ Xt | } Pq[ W| d j o | o t | } n | d j o | i i | | n | i i | | | | i d S( s+ Set the current cell from the entry widget.R i N( R R R R R R' RL R R t
startswithR R R R R t clsRz R R Ri R* R( R ( R Rz RL R R R R ( ( R R s(
c C s | i i x | i i D] \ \ } } } | d j p
| d j o q n | i i | | } | d j o d | d <q t | d o | i \ } } n t | t } } | | d <t | | d <q Wd S( s( Fill the GUI cells from the sheet cells.i RC RL RB t anchorN( R Ri R R RP R R R R R R R RB RL RM RO R t align2anchor( R RL R R RM R R ( ( R R s
( Rg Rh t __doc__R R R R R R R R R R R R R R Rb R R R R R R R R R R ( ( ( R R s4 - 2 c C s d k } t } x t d d D] } x t d d D] } | d j o t | } nX | d j o t | } n; t | d } t d | } d | | f } t | } | i
| | | q8 Wq" W| i | i d d S( s Basic non-gui self-test.Ni i s %s*%ss
sheet1.xml( R R t aR% R R R R R t c1t c2R R R( RU Rb ( R R R R R R R R ( ( R t
test_basic, s$
c C sB t i d o t i d } n d } t | } | i i d S( s GUI test.i s
sheet1.xmlN( R. t argvR] R t gR t mainloop( R R] ( ( R t test_guiB s R (# R R R R. RY R t xml.parsersRj R R R R R R RT R R R R R Rd R R R R R R R RK t TkinterR R R R Rg ( R R R Rj R R R R R R R R R R R RK R R RY RT R R. R R R Rd R R R R R ( ( R t ? s@
!!!! Y )6 C