Warning: session_start(): Session cannot be started after headers have already been sent in /home/tvrreohg/public_html/manga.php on line 13
^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 s | | j | | f R! t colnum2nameR R; t lent strR t iteritemsR R R RA t
isinstanceR 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 sP
&!&!" !
'
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 RI R RU t cgit escapeR" t join( R t outR R R t cellxml( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRU s "
c C s\ | j } t | d } | j | | rN | j d rN | j d n | j d S( NR s
( RU t opent writet endswitht close( R t filenameRP 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 R_ R` ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt load s ( t __name__t
__module__R R R R R( R* R- R0 R1 R+ R6 R7 R8 R9 R: R> R? R RT RU Ra Re ( ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s, 2 Rc 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 Rh ( ( 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 R` t parser( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRd s
c C sc t | d | d } | rV x* | j D] \ } } t | | | %s( Rs t typeRy Rf t align2xmlRQ R ( R Rw ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRU 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 ( Ry 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( Ry ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR e s c C s d t | j S( Ns %s( t reprRy ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt
_xml_floath s c C s d t | j S( Ns %s( R Ry ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyt _xml_complexk s ( Rf Rg R R R RA RU 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 s | | _ | | _ | | _ d S( N( RP R RQ ( R RP R RQ ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR p s c C s | j S( N( RP ( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR w s c C s | j | j f S( N( RP RQ ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRA z s c C s- d } | t | j | j t j | j f S( Ns9 %s( R RQ R RV RW RP ( R t s( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRU } s
( Rf Rg R R R RA RU ( ( ( 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 s; | | _ t | j | _ | | _ | | _ | j d S( N( t formulat translatet
translatedR RQ R? ( R R R RQ ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s
c C s
d | _ d S( N( R
Ry ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR? 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 Rf ( Ry R
t r_execR R t r_evalR. t exc_infoR Rf RH ( 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 Ry RH RQ ( R RP ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRA s
c C s d t | j | j | j f S( Ns, %s( R RQ R R ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRU 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]*)$RB ( t ret splitR t matchR
t groupst colname2numR} t cellnameR" R RX R RQ ( R R# R$ R% R& R3 R4 RY t partR t sxt syR R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR2 s 8 ( Rf Rg R R R? R RA RU R2 ( ( ( 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)RB N( R R R R
R" R R RX ( R RY R R R# R$ R% R& R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s c C s t | t | S( sE Translate a cell coordinate to a fancy cell name (e.g. (1, 1)->'A1').( RF RH ( R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s c C sI | j } 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 ( t uppert ord( R R t c( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyR s
&c C sJ d } x= | rE t | d d \ } } t | t d | } q W| S( s6 Translate a column number to name (e.g. 1->'A', etc.).RB i i R ( t divmodt chrR ( R R R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRF 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: %sRP 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 (# R_ R Rh t ost patht isfileRe R> R; t Tkt roott wm_titlet Labelt beacont Entryt entryt ButtonRa 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_ 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
Rh R- 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( NRB t =i R ( Rh R R
RJ R R RA R R t insertt selection_range( R R R R RP RQ ( ( 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@ RP t WEs s s t sunkent bgt whitet fgt blackN( R R t gridcellsR R R t grid_configureR t selectallR! t grid_columnconfigureRF t _SheetGUI__xt _SheetGUI__yt selectcolumnt extendcolumnRH 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 setcornerR. R/ ( 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 R. R/ ( 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 R. R/ ( 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 R. R/ ( 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 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 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
RJ 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( Rh Ra R_ ( R ( ( s. /usr/lib64/python2.7/Demo/tkinter/guido/ss1.pyRa 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 s@ Y )6 C