Oνομασία στήλης υπολογιστικού φύλλου σε τύπο
 

Εργασία:
Απόδοση ονομασίας στήλης υπολογιστικού φύλλου με τύπο.

<table style="BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"> <td>
</td> <td>AW</td> <td>AX</td> <td>AY</td> <td>AZ</td> <td>BA</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">AW</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">AX</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">AY</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">AZ</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">BA</td></tr></tbody></table>
<table style="BORDER-BOTTOM-STYLE: groove; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove"> <tbody> <tr> <td>Τύποι</td></tr> <tr> <td> <table style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"> <td>Κελί</td> <td>Τύπος</td></tr> <tr> <td>AW1</td> <td>=SUBSTITUTE(ADDRESS(1;COLUMN();4);1;)</td></tr></tbody></table></td></tr></tbody></table>

Για τις πρώτες 26 στήλες:

<table style="BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"> <col style="WIDTH: 64px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">A</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">B</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">C</td> <td style="TEXT-ALIGN: center; FONT-WEIGHT: bold">D</td></tr></tbody></table>
<table style="BORDER-BOTTOM-STYLE: groove; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove"> <tbody> <tr> <td>Τύποι</td></tr> <tr> <td> <table style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"> <td>Κελί</td> <td>Τύπος</td></tr> <tr> <td>A1</td> <td>=CHAR(COLUMN()+64)</td></tr></tbody></table></td></tr></tbody></table>