rafaelgodoy@argentina.com
22 de Diciembre del 2008
|
Trabaje en excel para hacer un sencillo programita para impresion de tiket, tengo una Epson TM 220B, pero no se como hacer para que me corte el papel. Lo edite con el Editor de secuencias de Comando, pero no se que tengo que agregar para que me corte el papel. Aqui les dejo como queda editado, ayudenme por favor. Muchas gracias.
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=25 class=xl69>TIQUE FACTURA A</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=7 class=xl69>Nro.</td>
<td colspan=22 class=xl94 align=center width=80 style='width:60pt'
x:num="2700019920" x:fmla="=Formulas!C3">############</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=37 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=10 class=xl101>Fecha</td>
<td colspan=14 class=xl92 x:num="39630" x:fmla="=Formulas!D3">01/07/08</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=15 class=xl45 style='mso-ignore:colspan'></td>
<td class=xl51></td>
<td colspan=55 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=37 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=10 class=xl101>Hora</td>
<td colspan=14 class=xl93 x:num="1.4605324074074075" x:fmla="=Formulas!G3">11:03:10</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=66 class=xl69
x:str="'---------------------------------------------------">---------------------------------------------------</td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=60 class=xl91 x:fmla="=Caratula!$A$3">SOC. COOP. TAMBEROS Z
ROSARIO LTDA</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=15 class=xl45 style='mso-ignore:colspan'></td>
<td class=xl51></td>
<td colspan=55 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=7 class=xl69>Cta.</td>
<td colspan=11 class=xl101 x:num x:fmla="=Caratula!$B$3">24532</td>
<td colspan=5 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=7 class=xl69>Ven.</td>
<td colspan=30 class=xl69 x:str="RICARDO " x:fmla="=Formulas!$H$3">RICARDO<span
style='mso-spacerun:yes'> </span></td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=7 class=xl69>CUIT Nro.: 30-67475612-3</td>
<td colspan=23 class=xl101 x:fmla="=Caratula!$C$3">30-52555640-5</td>
<td colspan=107 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=60 class=xl69>IVA RESPONSABLE INSCRIPTO</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=60 class=xl69 x:fmla="=Caratula!$D$3">HUMBERTO PRIMO 1255</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=60 class=xl69 x:fmla="=Caratula!$E$3">ROSARIO</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=8 class=xl69>C.P.</td>
<td colspan=9 class=xl101 x:num x:fmla="=Caratula!$F$3">2000</td>
<td colspan=120 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=60 class=xl69>CONDICION DE VENTA CONTADO</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=66 class=xl69
x:str="'---------------------------------------------------">---------------------------------------------------</td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=60 class=xl69>Cant./Precio Unit.</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=39 class=xl69>Descripcion (21,00) [%BI]</td>
<td colspan=21 class=xl105>IMPORTE</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=66 class=xl69
x:str="'---------------------------------------------------">---------------------------------------------------</td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=29 class=xl69>ESSO ENERGY DIESEL</td>
<td colspan=108 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=3 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=15 class=xl109 x:num="461247.09167054441" x:fmla="=Formulas!L3">461.247</td>
<td colspan=5 class=xl45>X $</td>
<td colspan=10 class=xl109 x:num="2149">2.149</td>
<td colspan=49 class=xl45 style='mso-ignore:colspan'></td>
<td class=xl64></td>
<td colspan=55 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=9 class=xl108>1,000</td>
<td colspan=2 class=xl101>X</td>
<td colspan=11 class=xl63 align=right x:num="653.61" x:fmla="=$AX$33">653,61</td>
<td colspan=10 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=11 class=xl100>(21,00)</td>
<td colspan=94 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=33 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=11 class=xl105>[76,52]</td>
<td colspan=5 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=12 class=xl102 x:num="653.61" x:fmla="=ROUND(65.94*AP46/100,2)">653,61</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=37 class=xl69>Base Imponible:<span style='mso-spacerun:yes'>
</span>1.0857</td>
<td colspan=100 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=22 class=xl69>DEC ITC 802/01</td>
<td colspan=115 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=22 class=xl106 x:num="72.923165193113064"
x:fmla="=D31*0.1581/1000"><span style='mso-spacerun:yes'> </span>$<span
style='mso-spacerun:yes'> </span>72,92 </td>
<td colspan=12 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=6 class=xl107>(0)</td>
<td colspan=41 class=xl45 style='mso-ignore:colspan'></td>
<td class=xl46></td>
<td colspan=55 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=51 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=10 class=xl100>0,00</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=138 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=27 class=xl69>TOT. NETO SIN IVA</td>
<td colspan=21 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=12 class=xl102 x:num="653.61" x:fmla="=AX33">653,61</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=138 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=27 class=xl69>Subtotal 21,00%</td>
<td colspan=21 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=12 class=xl102 x:num="653.61" x:fmla="=AX33">653,61</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=27 class=xl69>IVA 21,00%</td>
<td colspan=21 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=12 class=xl102 x:num="137.26" x:fmla="=ROUND(AX41*21/100,2)">137,26</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=15 class=xl45 style='mso-ignore:colspan'></td>
<td class=xl63></td>
<td colspan=55 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=36 class=xl69>IVA NO INSCRPTO 00,00</td>
<td colspan=14 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=10 class=xl100>0,00</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=36 class=xl69>CONCEPTOS NO GRAVADOS</td>
<td colspan=12 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=12 class=xl102 x:num="200.35" x:fmla="=ROUND(AP46-AX41-AX42,2)">200,35</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=138 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=18 class=xl103>TOTAL</td>
<td colspan=22 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=20 class=xl104 align=center x:num="991.22"
x:fmla="=D31*X31/1000/1000">####</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=16 class=xl69>RECIBI/MOS</td>
<td colspan=24 class=xl45 style='mso-ignore:colspan'></td>
<td class=xl66></td>
<td colspan=96 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=26 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=13 class=xl101>SU PAGO</td>
<td colspan=10 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=12 class=xl102 x:num="991.22" x:fmla="=AP46">991,22</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=27 class=xl69>Suma de sus pagos</td>
<td colspan=21 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=12 class=xl102 x:num="991.22" x:fmla="=AP46">991,22</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=27 class=xl69>Su Vuelto</td>
<td colspan=21 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=12 class=xl100>0,00</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=138 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 class=xl45 style='height:13.35pt'></td>
<td colspan=12 class=xl69>Cajero:</td>
<td colspan=30 class=xl69 x:fmla="=Formulas!$I$3">JORGE<span
style='mso-spacerun:yes'> </span>ANSEF</td>
<td colspan=13 class=xl45>TURNO:</td>
<td colspan=5 class=xl45 align=right x:num x:fmla="=Formulas!J3">12</td>
<td colspan=6 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=71 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=2 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=8 class=xl99>CF</td>
<td colspan=4 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=24 class=xl69>V: 21.00 Athena</td>
<td colspan=100 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='mso-height-source:userset;height:13.35pt'>
<td height=17 colspan=2 class=xl45 style='height:13.35pt;mso-ignore:colspan'></td>
<td colspan=8 class=xl70>DGI</td>
<td colspan=4 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=40 class=xl69>REGISTRO Nro. PEL0010789</td>
<td colspan=84 class=xl45 style='mso-ignore:colspan'></td>
<td colspan=52 class=xl65 style='mso-ignore:colspan'></td>
|
