2.1.896 Part 1 Section 18.17.7.34, CELL

a.   The standard does not specify locale specific strings for argument category.

In Excel, if the SpreadsheetML is intended to be used in certain non-English locales, the category string can be the English value shown in the standard, or the translation shown in the following tables. Locales not specified in the following tables shall only use the English versions of the category string.

[Note: Using translated versions of the category string is strongly discouraged, as spreadsheet applications might not support these translations. end note]

Locale	address	col	color	contents	coord	filename	format
az-latn-az	ünvan	col	rəng	mündəricat	coord	fayladi	format
ca-es	dirección	columna	color	contenido	coord	nombrearchivo	formato
cs-cz	adresa	sloupec	barva	obsah	souřadnice	názevsouboru	formát
da-dk	adresse	kolonne	farve	indhold	koord	filnavn	format
de-de	adresse	spalte	farbe	inhalt	koord	dateiname	format
es-es	direccion	columna	color	contenido	coord	nombrearchivo	formato
et-ee	aadress	veerg	värv	sisukord	Koordinatt	failinimi	vorming
fi-fi	osoite	sarake	väri	sisältö	koord	tiedostonnimi	muoto
fr-fr	adresse	colonne	couleur	contenu	coordonnees	nomfichier	format
hu-hu	cím	oszlop	szín	tartalom	koord	filenév	forma
it-it	indirizzo	col	colore	contenuto	coordinate	nomefile	formato
kk-kz	мекенжай	баған	түс	мазмұны	ТҰРАҒИАТ	файлатауы	пішім
lv-lv	adrese	kolonna	krāsa	saturs	koordinātas	faila_nosaukums	formāts
nb-no	adresse	kol	farge	innhold	koord	filnavn	format
nl-nl	adres	kolom	kleur	inhoud	coord	bestandsnaam	notatie
pl-pl	adres	kolumna	kolor	zawartość	WSPÓŁRZ	nazwa_pliku	format
pt-br	endereço	col	cor	conteúdo	coord	nome.arquivo	formato
pt-pt	endereço	col	cor	conteúdo	coord	nome.ficheiro	formato
ru-ru	адрес	столбец	цвет	содержимое	КООРД	имяфайла	формат
sk-sk	adresa	stĺpec	farba	obsah	koordinovať	názovsúboru	formát
sl-si	address	sto	color	contents	coord	filename	format
sv-se	adress	kol	färg	innehåll	koord	filnamn	format
tr-tr	adres	süt	renk	içerik	koord	dosyaadi	biçim
uk-ua	адреса	стовпець	колір	вміст	КООРД	ім`я_файлу	формат

Locale	parentheses	prefix	protect	row	Sheet	type	width
az-latn-az	parentheses	prefix	protect	sətir	Vərəq	tip	en
ca-es	parentesis	prefijo	proteger	fila	hoja	tipo	ancho
cs-cz	závorky	prefix	zámek	řádek	list	typ	šířka
da-dk	parenteser	foranstillet	beskyt	række	ark	værditype	bredde
de-de	klammern	präfix	schutz	zeile	blatt	typ	breite
es-es	parentesis	prefijo	proteger	fila	hoja	tipo	ancho
et-ee	sulud	eesliide	kaitse	rida	leht	tüüp	laius
fi-fi	sulkeet	etuliite	suojaus	rivi	taulukko	tyyppi	leveys
fr-fr	parentheses	prefixe	protege	ligne	feuille	type	largeur
hu-hu	zárójelek	előtag	védett	sor	lap	típus	széles
it-it	parentesi	prefisso	proteggi	riga	foglio	tipo	larghezza
kk-kz	жақшалар	префикс	қорғаныс	жол	ПАРАҚ	түр	ені
lv-lv	iekavas	prefikss	aizsargāt	rinda	lapa	tips	platums
nb-no	parenteser	prefiks	beskytt	rad	ark	verditype	bredde
nl-nl	haakjes	voorvoegsel	bescherming	rij	blad	type	breedte
pl-pl	nawiasy	prefiks	ochrona	wiersz	arkusz	typ	szerokość
pt-br	parênteses	prefixo	proteger	lin	planilha	tipo	largura
pt-pt	parênteses	prefixo	proteger	lin	folha	tipo	largura
ru-ru	скобки	префикс	защита	строка	ТАБЛИЦА	тип	ширина
sk-sk	zátvorky	vloženýznak	chrániť	riadok	hárok	typ	šírka
sl-si	parentheses	prefix	protect	vrstica	sheet	type	širina
sv-se	parenteser	prefix	skydd	rad	blad	typ	bredd
tr-tr	ayraç	önek	koruma	sat	tablo	tür	genişlik
uk-ua	дужки	префікс	захист	рядок	АРКУШ	тип	довжина

b.   The standard does not fully specify details when argument category is format.

In Excel, when the category parameter is format then the value returned depends upon the number format of the upper-left cell of reference, and more specifically upon the number format code of the upper-left cell of reference.  Depending upon the number format code of the appropriate cell, the result value of CELL when the category is format is based upon the following rules.

First, some observations regarding the rules are in order:

The various sections of the number format code are referred to within the rules. For more information on sections in the number format code, see numFmts ("[ISO/IEC-29500-1] §18.8.31; numFmts"). There are cases where it is useful to discuss the characters from the number format code which are dependent upon the value in the cell. These characters, instead of representing text or spacing in the cell’s display text, interpret, in some fashion, the value to be displayed. In the rules, these characters are referred to as interpreted characters of the number format code. The following table shows all the interpreted characters:

Interpreted Characters
0
#
@
D
M
Y
H
S
?
AM/PM
A/P
G
E
R

There are cases where it is also useful to discuss runs of similar interpreted characters.  [Example: Each d, m, and y within the number format code dd/mm/yyyy does not represent a separate interpretation of the day of the date value to be represented, and instead helps to make up a representation of the day of the date that is two digits in length. end example]. These runs of similar characters are referred to as interpreted symbols because multiple characters are used, but the result is a single symbolic representation of at least part of the value.

Because there are multiple different symbols for days, months, years, hours, minutes, seconds, and AM/PM, it is sometimes useful to discuss all of the representations of each of these. When any of Day, Month, Year, Hour, Minute, and so on, is referred to within a rule, what is meant is any of the possible representations for that date/time portion.  For example, a Day symbol would be any of d, dd, ddd, or dddd.

The use of characters such as 0, E, and % as a symbol within a number format code does not include usages of these same characters either escaped (by preceding them with a backslash character “\”) or as a part of a quoted string.

Here are the rules to determine the result value:

If the first interpreted symbols within the first section are any of the date or time characters (any of y, m, d, h, m, s), then the first one or two characters of the return value are determined by the order of interpreted symbols (including any interpreted symbols, not just date/time symbols) according to the following table ("anything" can mean "no additional symbols". If the type is "anything except <type>", then the excepted symbol type cannot follow the previously specified symbol):

Interpreted Symbols in Order	Return Value Characters
Day, month, year, anything	"D1"
Day, month, anything besides year, anything	"D2"
Month, year, anything	"D3"
Month, day, year, anything	"D4"
Month, day, anything besides year, anything	"D5"
Hours, minutes, seconds, AM/PM, anything	"D6"
Hours, minutes, AM/PM, anything	"D7"
Hours, minutes, seconds, anything besides AM/PM, anything	"D8"
Hours, minutes, anything besides seconds or AM/PM, anything	"D9"
Any other combination of symbols	"G" or "C" depending on whether there is a $ in the first condition

Otherwise, the first character of the return value is determined based upon the referenced cell’s number format code according to the rules in the following table:

First Section of the Number Format Code		First Return Value Character
Absent Characters (as Symbols)	Present Characters (as Symbols)
	@	"G"
@	$	"C"
@, $	%	"P"
@, $, %	E	"S"
@, $, %, E	A run of any combination of one or more "0", "#", and "?" characters, followed by a comma, followed by a run of any combination of one or more "0", "#", and "?" characters. This run cannot be preceded by a period (".") or by any interpreted characters.	","
@, $, %, E, or a run of characters containing a comma as described in the preceding row	At least one of "0", "?", or "#"	"F"
Any of the conditions described in the preceding rows	Anything	"G"

The final value is determined by appending any of the applicable characters from the following table to the return value characters obtained from the previous two tables:

Case	Characters to Append
The first character of the return value is C, F, S, P, or "," and the number format code contains any of "?", "0", or "#" as a symbol.	The decimal number equal to the total number of "#", "?", and "0" characters to the right of the first "." within the first section.
The first character of the return value was C, and the number format code does not contains any of "?", "0", or "#" as a symbol.	15 or the length of the string immediately following the first "$" sign in the number format code that is a symbol.
The first section of the number format code contains an open parenthesis ("(") as a symbol.	"()"
The second section of the number format code contains [Red], [Black], [Green], [White], [Blue], [Magenta], [Yellow], or [Cyan] as a symbol.	"-"

c.   The standard does not specify coord and sheet as values for argument category.

Excel allows the following additional values for the category argument:

category	Meaning	Result Type
“coord”	Returns the referenced cell in the format $A:$<referenced column>$<referenced row>.	text
“sheet”	Returns 1.	number