✘✘ GRAYBYTE WORDPRESS FILE MANAGER ✘✘

�
��f�cc@s�
dZd
dl
Z
d
dlZd
dlZd
dlmZ
d
dlmZ
dddf\ZZ	Z
dd	�Zd
d�Zdd
�Z
iee6ee	6e
e
6Zide6de	6de
6Zied6e	d6e
d6Zide6de	6de
6Zdd�ZGdd�d�ZGdd�d�ZGdd�d�ZGdd�de�ZGdd�de�ZGdd�de�Zd d!�Zd"d#�Zd$d%�Zd&d'�Zd
dlZGd(d)�d)�Zd*d+�Z d,d-�Z!e"d.kr�
e!�
ndS(/u(
SS1 -- a spreadsheet-like application.
iN(
uexpat(
uescapeuLEFTuCENTERuRIGHTcCs
|j|
�
S(
N(
uljust(u
xu
n((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuljusts
uljustcCs
|j|
�
S(
N(
ucenter(u
xu
n((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyucenters
ucentercCs
|j|
�
S(
N(
urjust(u
xu
n((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyurjusts
urjustulefturightu
wu
ec
Cs4d
}
x'|D]}|dk	r
|
|7}
q
q
W|
S(Ni(
uNone(usequtotalu
x((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyusums






usumc

Bs
|EeZ
dZd
d�Zdd�Zdd�Zdd�Zd	d
�Zdd�Zd
d�Z	dd�Z
dd�Zdd�Zdd�Z
dd�Zdd�Zdd�Zdd�Zdd �Zd!d"�Zd#d$�Zd%d&�Zd'd(�Zd)d*�Zd+d,�Zd-S(.uSheetc

Cs1i|_t
d
|jd|jdt�|_dS(Nucellucellsusum(ucellsudictu	cellvalueumulticellvalueusumuns(
uself((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu__init__%s

	

	
	
uSheet.__init__cCs9|j|
|�}t
|d
�r1|j|j�
S|SdS(Nurecalc(ugetcelluhasattrurecalcuns(uselfu
xu
yucell((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	cellvalue-s


uSheet.cellvaluecCs�|
|kr||
}
}n||kr8||}}ng}xRt||d
�D]=}x4t|
|d
�D]}|j
|j||��

qlWqRW|S(Ni
(urangeuappendu	cellvalue(uselfux1uy1ux2uy2usequ
yu
x((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyumulticellvalue4s







!
uSheet.multicellvaluecCs|jj
|
|f�
S(
N(ucellsuget(uselfu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyugetcell?s
u
Sheet.getcellcCs||j|
|f<dS(
N(
ucells(uselfu
xu
yucell((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyusetcellBsu
Sheet.setcellcCs-y|j|
|f=Wnt
k
r(


Yn
XdS(
N(ucellsuKeyError(uselfu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	clearcellGs




uSheet.clearcellcCs1x*|j|
|||�D]}|j
|=qWdS(
N(uselectcellsucells(uselfux1uy1ux2uy2uxy((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
clearcellsMs

uSheet.clearcellscCs|jd
|
t
j|�
dS(Ni(u
clearcellsusysumaxsize(uselfuy1uy2((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	clearrowsQs
uSheet.clearrowscCs|j|
d
|t
j�
dS(Ni(u
clearcellsusysumaxsize(uselfux1ux2((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuclearcolumnsTs
uSheet.clearcolumnscs[��
kr�
���
n��kr8����n��
��fd
d�|jD�
S(Nc
sZg|]P\}
}�|
k
o)�
k
n
r�|k
oE�k
n
r|
|f�qS(((u.0u
xu
y(ux1ux2uy1uy2(u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
<listcomp>\s		
u%Sheet.selectcells.<locals>.<listcomp>(
ucells(uselfux1uy1ux2uy2((ux1ux2uy1uy2u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuselectcellsWs





uSheet.selectcellsc	Cs#
|d
kr|d
krdS|
|kr8||
}
}n||krT||}}ni}x�|jD]�\}}	|j||	f}
t
|
d�r�|
j|
|||||�}
n|
|k
o�|k
n
r
||	k
o�|k
n
r
||7}|	|7}	n|
|||	f<qdW||_dS(Niurenumber(ucellsuhasattrurenumber(uselfux1uy1ux2uy2udxudyunewu
xu
yucell((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	movecells_s 









!
8





uSheet.movecellscCs&|jd
|
t
jt
jd
|�
dS(Ni(u	movecellsusysumaxsize(uselfu
yu
n((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
insertrowsrsuSheet.insertrowscCs^|
|kr||
}
}n|j|
|�
|j
d
|dtjtjd
|
|d�
dS(Nii
(u	clearrowsu	movecellsusysumaxsize(uselfuy1uy2((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
deleterowsvs



uSheet.deleterowscCs&|j|
d
t
jt
j|d
�
dS(Ni(u	movecellsusysumaxsize(uselfu
xu
n((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
insertcolumns|suSheet.insertcolumnscCs^|
|kr||
}
}n|j|
|�
|j
|d
dtjtj|
|d
d�
dS(Ni
i(u
clearcellsu	movecellsusysumaxsize(uselfux1ux2((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
deletecolumns�s



uSheet.deletecolumnsc
CsLd
}
}x5|jD]*\}}t
|
|�}
t
||�}qW|
|fS(Ni(ucellsumax(uselfumaxxumaxyu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyugetsize�s






u
Sheet.getsizec
Cs:x3|jj
�D]"}
t|
d
�r|
j�
qqWdS(Nureset(ucellsuvaluesuhasattrureset(uselfucell((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyureset�s


uSheet.resetc
CsJ|j�
x9|j
j�D](}
t|
d
�r|
j|j�

qqWdS(Nurecalc(uresetucellsuvaluesuhasattrurecalcuns(uselfucell((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyurecalc�s




uSheet.recalcc
Cs�|j�\}
}|
d
|d
}}d
g
|}i}xZt
d
|�D]I}t|�
tf||df<\}}	t||t|�
�||<qJWxZt
d
|�D]I}
t|
�
tf|d|
f<\}}	t|dt|�
�|d<q�Wx�|jj�D]�\\}}
}|dk
s
|
dk
r4
q
nt	|d�rV
|j
|j�

nt	|d�rz
|j�\}}	n*t|�
}t
|t�r�
t}	nt}	||	f|||
f<t||t|�
�||<q
Wd}x9t
|�
D]+}|r|d7}n|d||7}q�
Wx�t
|�
D]�}
d}
xot
|�
D]a}|j||
f�
pgdtf\}}	t|	|||�}|
r�|
d7}
n|
|7}
qCWt|
�

|
dkr*t|�

q*q*WdS(	Ni
iurecalcuformatuu
+u
-u
|(ugetsizeurangeucolnum2nameuRIGHTumaxulenustrucellsuitemsuhasattrurecalcunsuformatu
isinstanceuLEFTugetualign2actionuprint(uselfumaxxumaxyuwidthuheightucolwidthufullu
xutextu	alignmentu
yucellusepuline((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyudisplay�sP





&
!
&
!"







	

!







'








u
Sheet.displayc
Cs�d
g
}
xk|jj
�D]Z\\}}}t|d�rI|j�}ndt|�
}|
jd|||f�

qW|
jd�

dj|
�
S(Nu
<spreadsheet>uxmlu<value>%s</value>u%<cell row="%s" col="%s">
  %s
</cell>u</spreadsheet>u

(ucellsuitemsuhasattruxmluescapeuappendujoin(uselfuoutu
xu
yucellucellxml((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuxml�s
	
"


	



u	Sheet.xmlc
Csa|j�}t
|
d
dd�
�:}|j|�

|rW|jd�
rW|jd�

nWdQXdS(Nu
wuencodinguutf-8u

(uxmluopenuwriteuendswith(uselfufilenameutextu
f((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyusave�s






u
Sheet.savec	Cs/t|
d
��}t
|�
j|�

WdQXdS(Nurb(uopenuSheetParseru	parsefile(uselfufilenameu
f((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuload�s

u
Sheet.loadN(u__name__u
__module__u__qualname__u__init__u	cellvalueumulticellvalueugetcellusetcellu	clearcellu
clearcellsu	clearrowsuclearcolumnsuselectcellsu	movecellsu
insertrowsu
deleterowsu
insertcolumnsu
deletecolumnsugetsizeureseturecalcudisplayuxmlusaveuload(
u
__locals__((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuSheet#s,2uSheetc

Bs�|EeZ
dZd
d�Zdd�Zdd�Zdd�Zd	d
�Zdd�Zd
d�Z	e	Z
dd�ZeZdd�Z
dd�Zdd�Zdd�Zdd�Zdd�ZdS(uSheetParsercCs
|
|_dS(
N(
usheet(uselfusheet((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu__init__�s
uSheetParser.__init__cCsAtj
�}|j|_|j|_|j|_|j|
�

dS(
N(	uexpatuParserCreateustartelementuStartElementHandleru
endelementuEndElementHandlerudatauCharacterDataHandleru	ParseFile(uselfu
fuparser((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	parsefile�s





uSheetParser.parsefilecCs6t|d
|
d�}|r)||�

ng|_dS(Nustart_(ugetattruNoneutexts(uselfutaguattrsumethod((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyustartelement�s




uSheetParser.startelementcCs|jj
|
�

dS(
N(utextsuappend(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyudata�s
uSheetParser.datacCs9t|d
|
d�}|r5|dj|j�
�

ndS(Nuend_u(ugetattruNoneujoinutexts(uselfutagumethod((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
endelement�s


uSheetParser.endelementcCs4t|
j
d
�
�
|_t|
j
d�
�
|_dS(Nurowucol(uintugetu
yu
x(uselfuattrs((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
start_cell�s

uSheetParser.start_cellcCs1|
jd
�
|_
tj|
jd�
�
|_dS(Nuformatualign(ugetufmtu	xml2alignu	alignment(uselfuattrs((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyustart_value�s

uSheetParser.start_valuec	Cs+yt|
�
|_
Wn


d|_
Yn
XdS(
N(uintuvalueuNone(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuend_int
s



uSheetParser.end_intc	Cs+yt|
�
|_
Wn


d|_
Yn
XdS(
N(ufloatuvalueuNone(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
end_double

s



uSheetParser.end_doublec	Cs+yt|
�
|_
Wn


d|_
Yn
XdS(
N(ucomplexuvalueuNone(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuend_complex
s



uSheetParser.end_complexcCs
|
|_dS(
N(
uvalue(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
end_string
s
uSheetParser.end_stringcCs�t|j
t�r!|j
|_nit|j
t�r`t|j
|jpHd
|jpTt�|_n*t	|j
|jpud
|jp�t
�|_dS(Nu%s(u
isinstanceuvalueuBaseCellucellustru
StringCellufmtu	alignmentuLEFTuNumericCelluRIGHT(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	end_value
s



	

	

uSheetParser.end_valuecCs+t|
|j
pd
|jpt�|_dS(Nu%s(uFormulaCellufmtu	alignmentuRIGHTucell(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuend_formula(
s


uSheetParser.end_formulacCs#|jj
|j|j|j�
dS(
N(usheetusetcellu
xu
yucell(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuend_cell-
s
uSheetParser.end_cellN(u__name__u
__module__u__qualname__u__init__u	parsefileustartelementudatau
endelementu
start_cellustart_valueu
start_formulauend_intuend_longu
end_doubleuend_complexu
end_stringu	end_valueuend_formulauend_cell(
u
__locals__((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuSheetParser�s uSheetParserc


Bs|EeZ
dZd
Zd
S(uBaseCellN(u__name__u
__module__u__qualname__uNoneu__init__(
u
__locals__((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuBaseCell0
s
	uBaseCellc

Bsn|EeZ
dZd
edd�Zdd�Zdd�Zdd	�Zd
d�Zdd
�Z	dd�Z
dS(uNumericCellu%scCs|
|_||_
||_dS(
N(uvalueufmtu	alignment(uselfuvalueufmtu	alignment((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu__init__>
s	
	
uNumericCell.__init__c
Cs|jS(
N(
uvalue(uselfuns((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyurecalcE
s
uNumericCell.recalcc
	Cs;y|j|j
}
Wn


t|j
�
}
Yn
X|
|jfS(
N(ufmtuvalueustru	alignment(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuformatH
s





uNumericCell.formatc
Cs=t|d
t
|j�
j�}
dt|j|j|
�fS(Nu_xml_u(<value align="%s" format="%s">%s</value>(ugetattrutypeuvalueu__name__u	align2xmlu	alignmentufmt(uselfumethod((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuxmlO
s






uNumericCell.xmlc

Cs9d|jk
odkn
r*d|jSd|jSdS(Niiu
<int>%s</int>u<long>%s</long>li�l(
uvalue(
uself((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu_xml_intV
s

uNumericCell._xml_intc

Csd
|jS(Nu<double>%r</double>(
uvalue(
uself((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
_xml_float\
s
uNumericCell._xml_floatc

Csd
|jS(Nu<complex>%r</complex>(
uvalue(
uself((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu_xml_complex_
s
uNumericCell._xml_complexN(u__name__u
__module__u__qualname__uRIGHTu__init__urecalcuformatuxmlu_xml_intu
_xml_floatu_xml_complex(
u
__locals__((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuNumericCell<
suNumericCellc

BsJ|EeZ
dZd
edd�Zdd�Zdd�Zdd	�Zd
S(u
StringCellu%scCs|
|_||_
||_dS(
N(utextufmtu	alignment(uselfutextufmtu	alignment((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu__init__d
s	
	
uStringCell.__init__c
Cs|jS(
N(
utext(uselfuns((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyurecalck
s
uStringCell.recalcc

Cs|j|j
fS(
N(utextu	alignment(
uself((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuformatn
s
uStringCell.formatc
Cs*d
}
|
t|j
|jt|j�
fS(Nu9<value align="%s" format="%s"><string>%s</string></value>(u	align2xmlu	alignmentufmtuescapeutext(uselfu
s((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuxmlq
s






uStringCell.xmlN(u__name__u
__module__u__qualname__uLEFTu__init__urecalcuformatuxml(
u
__locals__((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
StringCellb
su
StringCellc

Bsb|EeZ
dZd
edd�Zdd�Zdd�Zdd	�Zd
d�Zdd
�Z	dS(uFormulaCellu%scCs;|
|_t
|j�
|_||_||_|j�
dS(
N(uformulau	translateu
translatedufmtu	alignmentureset(uselfuformulaufmtu	alignment((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu__init__z
s
	

	
	
uFormulaCell.__init__c

Cs
d|_
dS(
N(uNoneuvalue(
uself((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyureset�
s
uFormulaCell.resetc	Csz|jdkrsyt|j|
�|_Wqs


tj�d
}t|d�r\|j|_nt|�
|_YqsXn|jS(Niu__name__(	uvalueuNoneuevalu
translatedusysuexc_infouhasattru__name__ustr(uselfunsuexc((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyurecalc�
s







uFormulaCell.recalcc
	Cs;y|j|j
}
Wn


t|j
�
}
Yn
X|
|jfS(
N(ufmtuvalueustru	alignment(uselfutext((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuformat�
s





uFormulaCell.formatc

Cs$d
t|j
|jt|j�
fS(Nu,<formula align="%s" format="%s">%s</formula>(u	align2xmlu	alignmentufmtuescapeuformula(
uself((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuxml�
s




uFormulaCell.xmlcCs�g}x�tj
d
|j�D]�}tjd|�}	|	dk	r�|	j�\}
}t|
�
}t|�
}
|
|k
o�|k
n
r�||
k
o�|k
n
r�t|||
|�}q�n|j	|�

qWt
dj|�
|j|j
�S(Nu(\w+)u^([A-Z]+)([1-9][0-9]*)$u(ureusplituformulaumatchuNoneugroupsucolname2numuintucellnameuappenduFormulaCellujoinufmtu	alignment(uselfux1uy1ux2uy2udxudyuoutupartu
musxusyu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyurenumber�
s







8


uFormulaCell.renumberN(
u__name__u
__module__u__qualname__uRIGHTu__init__ureseturecalcuformatuxmlurenumber(
u
__locals__((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuFormulaCellx
suFormulaCellc
	Cs�g}
x�tj
d
|�D]�}tjd|�}|dkrM|
j|�

q|j�\}}}}t|�
}|dkr�d||f}n"t|�
}d||||f}|
j|�

qWdj|
�
S(u�Translate a formula containing fancy cell names to valid Python code.

    Examples:
        B4 -> cell(2, 4)
        B4:Z100 -> cells(2, 4, 26, 100)
    u(\w+(?::\w+)?)u2^([A-Z]+)([1-9][0-9]*)(?::([A-Z]+)([1-9][0-9]*))?$ucell(%s, %s)ucells(%s, %s, %s, %s)uN(ureusplitumatchuNoneuappendugroupsucolname2numujoin(	uformulauoutupartu
mux1uy1ux2uy2u
s((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	translate�
s









u	translatecCst|�
t
|
�
S(
uETranslate a cell coordinate to a fancy cell name (e.g. (1, 1)->'A1').(ucolnum2nameustr(u
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyucellname�
sucellnamec
CsI|j�}d
}
x0|D](}|
dt
|�
t
d�
d}
qW|
S(uCTranslate a column name to number (e.g. 'A'->1, 'Z'->26, 'AA'->27).iiu
Ai
(uupperuord(u
su
nu
c((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyucolname2num�
s



&
ucolname2numc
CsJd
}
x=|rEt|dd�\}}t
|td�
�
|
}
q	W|
S(u6Translate a column number to name (e.g. 1->'A', etc.).ui
iu
A(udivmoduchruord(u
nu
su
m((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyucolnum2name�
s

	


ucolnum2namec

BsI
|EeZ
dZd
Zddddd�Zdd�Zd	d
�Zdd�Zd
d�Zdd�Z	dd�Z
dd�Zdd�Zdd�Z
dd�Zdd�ZeZdd�Zdd �Zd!d"�Zd#d$�Zd%d&�Zd'd(�Zd)d*�Zd+d,�Zd-d.�Zd/d0�Zd1d2�Zd3d4�Zd5S(6uSheetGUIu7
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
    u
sheet1.xmli
icCs*|
|_t
�|_tjj|
�
r:|jj|
�

n|jj�\}}t||�}t||�}t	j	�|_
|j
jd
|j�

t	j|j
dddd�
|_
t	j|j
�
|_t	j|j
ddd	|j�
|_t	j|j
�
|_|jjd
ddd
dd�
|j
jd
d�

|jjd
d�

|jjd
ddd
dd�
|jjd|j�
|jjd|j�
|jjd|j�
|jjd|j�
|jjd|j�
|jjd|j�
|j||�
d|_d|_ |j!d
d
�
|j"�
dS(ulConstructor.

        Load the sheet from the filename argument.
        Set up the Tk widget tree.
        uSpreadsheet: %sutextuA1ufontu	helveticaiubolduSaveucommandusideubottomuexpandi
ufillubothulefturightu
xu<Return>u<Shift-Return>u<Tab>u<Shift-Tab>u<Delete>u<Escape>N(u	helveticaiubold(#ufilenameuSheetusheetuosupathuisfileuloadugetsizeumaxuTkurootuwm_titleuLabelubeaconuEntryuentryuButtonusaveu
savebuttonuFrameucellgridupackubindureturn_eventushift_return_eventu	tab_eventushift_tab_eventudelete_eventuescape_eventumakegriduNoneu	currentxyucornerxyu
setcurrentusync(uselfufilenameurowsucolumnsumaxxumaxy((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu__init__�
s<	



















	
	
uSheetGUI.__init__cCsr|j|j
kr>|jdk	r>|jj|j
|j�
n|jj|j
�
|j�
|jjd
d�
dS(Niuendubreak(	ucornerxyu	currentxyuNoneusheetu
clearcellsu	clearcellusyncuentryudelete(uselfuevent((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyudelete_events
!




uSheetGUI.delete_eventcCs#|j\}}|j
||�
dS(
N(u	currentxyu
load_entry(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuescape_event!s

uSheetGUI.escape_eventcCs�|jj
|
|�}|dkr*d
}n1t|t�rId|j}n|j�\}}|jjdd�
|jj	d|�
|jj
dd�
dS(Nuu
=iuend(usheetugetcelluNoneu
isinstanceuFormulaCelluformulauformatuentryudeleteuinsertuselection_range(uselfu
xu
yucellutextu	alignment((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
load_entry%s


	




uSheetGUI.load_entryc
Cs|
|_||_
i|_tj|jd
d�

}|jdddddd�
|jd|j�
x�t	d	|d	�D]�}|jj
|d
d�


tj|jdt|�
d
d�
}|jd|dddd
�
||j|df<||_d|_
|jd|j�
|jd|j�
|jd|j�
|jd|j�
qvWx�t	d	|
d	�D]�}tj|jdt|�
d
d�
}|jddd|dd
�
||jd|f<d|_||_
|jd|j�
|jd|j�
|jd|j�
|jd|j�
q[
Wx�t	d	|d	�D]�}x�t	d	|
d	�D]�}tj|jd
ddddd�
}|jd|d|dd�
||j||f<||_||_
|jd|j�
|jd|j�
|jd|j�
|jd|j�
qDWq*WdS(u�Helper to create the grid of GUI cells.

        The edge (x==0 or y==0) is filled with labels; the rest is real cells.
        ureliefuraiseducolumniurowustickyuNSWEu<ButtonPress-1>i
uminsizei@utextuWEu<B1-Motion>u<ButtonRelease-1>u<Shift-Button-1>usunkenubguwhiteufgublackN(urowsucolumnsu	gridcellsuTkuLabelucellgridugrid_configureubindu	selectallurangeugrid_columnconfigureucolnum2nameu_SheetGUI__xu_SheetGUI__yuselectcolumnuextendcolumnustru	selectrowu	extendrowupressumotionurelease(uselfurowsucolumnsucellu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyumakegrid1sN	
	
	



$


	
	




$


	
	









	
	


uSheetGUI.makegridcCs*|jd
d
�
|j
tjtj�
dS(Ni
(u
setcurrentu	setcornerusysumaxsize(uselfuevent((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	selectallcs

uSheetGUI.selectallcCs<|j|
�
\}}|j
|d
�
|j|tj�
dS(Ni
(uwhichxyu
setcurrentu	setcornerusysumaxsize(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuselectcolumngs


uSheetGUI.selectcolumncCsR|j|
�
\}}|d
krN|j
|jd
d�
|j|tj�
ndS(Nii
(uwhichxyu
setcurrentu	currentxyu	setcornerusysumaxsize(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuextendcolumnls



uSheetGUI.extendcolumncCs<|j|
�
\}}|j
d
|�
|jtj|�
dS(Ni
(uwhichxyu
setcurrentu	setcornerusysumaxsize(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	selectrowrs


uSheetGUI.selectrowcCsR|j|
�
\}}|d
krN|j
d|jd�
|jtj|�
ndS(Nii
(uwhichxyu
setcurrentu	currentxyu	setcornerusysumaxsize(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	extendrowws



uSheetGUI.extendrowcCsD|j|
�
\}}|d
kr@|d
kr@|j
||�
ndS(Ni(uwhichxyu
setcurrent(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyupress}s


uSheetGUI.presscCsD|j|
�
\}}|d
kr@|d
kr@|j
||�
ndS(Ni(uwhichxyu	setcorner(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyumotion�s


uSheetGUI.motioncCsi|jj
|
j|
j�}|dk	ret|tj�rey|j|j	fSWqet
k
ra


YqeXndS(Ni(ii(ucellgriduwinfo_containingux_rootuy_rootuNoneu
isinstanceuTkuLabelu_SheetGUI__xu_SheetGUI__yuAttributeError(uselfueventu
w((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuwhichxy�s







uSheetGUI.whichxyc

Cs|jj
|j�

dS(
N(usheetusaveufilename(
uself((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyusave�s
u
SheetGUI.savecCs�|jdk	r|j�
n|j�
t|
|�|jd
<|j|
|�
|jj�
|
|f|_d|_	|j
j|j�
}|dk	r�d|d<ndS(uMake (x, y) the current cell.utextuyellowubgN(u	currentxyuNoneuchange_cellu
clearfocusucellnameubeaconu
load_entryuentryu	focus_setucornerxyu	gridcellsuget(uselfu
xu
yugridcell((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
setcurrent�s









	


uSheetGUI.setcurrentc		Csc
|jdks$|j|
|fkr8|j|
|�
dS|j�
|
|f|_|j\}}|jpo|j\}}||kr�||}}n||kr�||}}nxh|jj�D]W\\}
}}||
k
o�|k
n
r�||k
o
|k
n
r�d
|d<q�q�W|jj|j�
}|dk	rI
d|d<n|j||||�
dS(Nu	lightBlueubguyellow(	u	currentxyuNoneu
setcurrentu
clearfocusucornerxyu	gridcellsuitemsugetu	setbeacon(	uselfu
xu
yux1uy1ux2uy2ucellugridcell((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	setcorner�s$
$











"
8





uSheetGUI.setcornercCs#
|
|kod
kn
rD||ko6tj
kn
rDd}n�|
|fd
tj
fkr�||krxd|}q
d||f}n�||fd
tj
fkr�|
|kr�dt|
�
}q
dt|
�
t|�
f}n.t|j�}t|j�}d||f}||jd<dS(Ni
u
:u%du%d:%du%su%s:%sutext(usysumaxsizeucolnum2nameucellnameu	currentxyucornerxyubeacon(uselfux1uy1ux2uy2unameuname1uname2((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	setbeacon�s
;
	









uSheetGUI.setbeaconc
Cs�|jdk	r�|j\}
}|jp-|j\}}|
|krR||
}
}n||krn||}}nxk|jj�D]W\\}}}|
|k
o�|k
n
r~||k
o�|k
n
r~d
|d<q~q~WndS(Nuwhiteubg(u	currentxyuNoneucornerxyu	gridcellsuitems(uselfux1uy1ux2uy2u
xu
yucell((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
clearfocus�s







"
8
uSheetGUI.clearfocuscCs1|j�
|j
\}}|j||d
�
dS(uCallback for the Return key.i
ubreak(uchange_cellu	currentxyu
setcurrent(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyureturn_event�s



uSheetGUI.return_eventcCs:|j�
|j
\}}|j|td
|d
��
dS(u0Callback for the Return key with Shift modifier.i
ubreak(uchange_cellu	currentxyu
setcurrentumax(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyushift_return_event�s



uSheetGUI.shift_return_eventcCs1|j�
|j
\}}|j|d
|�
dS(uCallback for the Tab key.i
ubreak(uchange_cellu	currentxyu
setcurrent(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu	tab_event�s



uSheetGUI.tab_eventcCs:|j�
|j
\}}|jtd
|d
�|�
dS(u-Callback for the Tab key with Shift modifier.i
ubreak(uchange_cellu	currentxyu
setcurrentumax(uselfueventu
xu
y((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyushift_tab_event�s



uSheetGUI.shift_tab_eventc

Cs�|j\}
}|j
j�}d}|jd
�
rLt|dd��
}nExBtttfD]1}y||�
}Wn


w\Yq\Xt	|�
}Pq\W|dkr�|r�t
|�
}n|dkr�|jj|
|�
n|jj
|
||�
|j�
dS(u+Set the current cell from the entry widget.u
=i
N(u	currentxyuentryugetuNoneu
startswithuFormulaCelluintufloatucomplexuNumericCellu
StringCellusheetu	clearcellusetcellusync(uselfu
xu
yutextucelluclsuvalue((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuchange_cell�s$













uSheetGUI.change_cellc
Cs�|jj
�
x�|jj�D]�\\}
}}|
d
ks|d
krMqn|jj|
|�}|dkr{d|d<qt|d�r�|j�\}}nt|�
t	}}||d<t
||d<qWdS(u(Fill the GUI cells from the sheet cells.iuutextuformatuanchorN(usheeturecalcu	gridcellsuitemsugetcelluNoneuhasattruformatustruLEFTualign2anchor(uselfu
xu
yugridcellucellutextu	alignment((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyusyncs

"









u
SheetGUI.syncN(u__name__u
__module__u__qualname__u__doc__u__init__udelete_eventuescape_eventu
load_entryumakegridu	selectalluselectcolumnuextendcolumnu	selectrowu	extendrowupressumotionureleaseuwhichxyusaveu
setcurrentu	setcorneru	setbeaconu
clearfocusureturn_eventushift_return_eventu	tab_eventushift_tab_eventuchange_cellusync(
u
__locals__((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyuSheetGUI�
s4-	2	uSheetGUIcCs�t�}x�t
d
d�D]�}
x�t
d
d�D]�}|
d
krPt|�
}nU|d
krkt|
�
}n:t|
d
�}td
|�}d||f}t|�
}|j|
||�
q/WqW|j�
|jd�

dS(uBasic non-gui self-test.i
iu%s*%su
sheet1.xmlN(uSheeturangeuNumericCellucellnameuFormulaCellusetcelludisplayusave(u
au
xu
yucelluc1uc2uformula((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu
test_basics	











u
test_basiccCsFtj
d
d�r#tj
d
}nd}t|�
}
|
jj�
dS(u	GUI test.i
Nu
sheet1.xml(usysuargvuSheetGUIurootumainloop(ufilenameu
g((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyutest_gui2s



utest_guiu__main__(#u__doc__uosureusysuxml.parsersuexpatuxml.sax.saxutilsuescapeuLEFTuCENTERuRIGHTuljustucenterurjustualign2actionu	align2xmlu	xml2alignualign2anchorusumuSheetuSheetParseruBaseCelluNumericCellu
StringCelluFormulaCellu	translateucellnameucolname2numucolnum2nameutkinteruTkuSheetGUIu
test_basicutest_guiu__name__(((u3/opt/alt/python33/lib64/python3.3/Tools/demo/ss1.pyu<module>s>




�O&3		�C