Export (0) Print
Expand All
Expand Minimize

2.1.887 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

souFf530116.711324ea-5bc2-4ee9-9011-0a6f19dc1d5b(en-us,office.12).jpgadnice

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

koordinFf530116.1eac95af-a26a-4c48-a509-27372eee2788(en-us,office.12).jpgtas

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

koordinovvaFf530116.65e5ecaa-41b0-44d2-9336-beaf4685d98b(en-us,office.12).jpg

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

hFf530116.ca942fb9-73cd-4739-8841-502c3d3960c7(en-us,office.12).jpgrok

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

Show:
© 2015 Microsoft