Export (0) Print
Expand All

1.1 Glossary

Office

The following terms are defined in [MS-GLOS]:

American National Standards Institute (ANSI) character set
ASCII
Augmented Backus-Naur Form (ABNF)
big-endian
checksum
client area
code page
Component Object Model (COM)
GUID
language code identifier (LCID)
little-endian
Unicode
XML
XML namespace

The following terms are defined in [MS-OFCGLOS]:

3-D Phong shading
A1
absolute reference
accelerator key
active cell
active sheet
ActiveX control
ActiveX object
add-in
add-in function
ADO
aggregation function
ALL
alternate startup directory
attribute hierarchy
AutoFilter
AutoFormat
AutoRecover
AutoShow
background color
beta
BIFF12
BIFF4
BIFF5
BIFF8
Binary Interchange File Format (BIFF)
border
border formatting
border style
bounding rectangle
bubble size
build identifier
build number
built-in name
ButtonPopup control
calculation mode
camera picture
caption
cascading style sheet (CSS)
category
cell
cell reference
cell value
center-across-selection alignment
centered alignment
character set
chart area
chart sheet
child
class identifier (CLSID)
class module
collapsed outline state
color palette
color scale
color scheme
comment
compact axis
conditional formatting
connection string
cube
cube function
custom filter
custom list
custom view
DAO
data bar
data consolidation
data marker
data provider
data recovery
data region
data source
data table
data validation
date system
DDE
DDE link
DDE server
DDE topic
defined name
descending order
diagonal-down
diagonal-up
dialog sheet
dimension
display folder
display units
distributed alignment
document library
drawing
drawing group
drawing object
drillthrough
drop lines
Dynamic Data Exchange (DDE)
embedded object
Excel Linked Library (XLL)
Excel macro (XLM)
expand/collapse button
expression
external data
external link
fill
fill color
fill pattern
filter
filtering state
fit to page
floating-point number
floor
folder
followed hyperlink
font
font face weight
font family
font scaling
font scheme
forecast
foreground color
form
format string
formatting run
formula bar
friendly name
frozen panes
function
function category
gradient fill
gradient stop
grand total
graph object
GraphicDropDown control
gridline
gutter
hash
header row
hidden
hidden protection
hidden row
hierarchy
high-low lines
horizontal alignment
hyperlink
Hypertext Markup Language (HTML)
icon
icon set
indentation level
Information Rights Management (IRM)
ink
inner rectangle
input cell
Input Method Editor (IME)
insert row
iterative calculation
justify distributed
key performance indicator (KPI)
leader line
left-to-right
legend entry
legend key
library directory
license key
line style
linear gradient
linked object
list view
locale
localization
locked
locked protection
logical left
logical right
logical top-left
logical top-right
long file name
macro
macro sheet
major gridline
major scheme
major tick mark
Mandarin phonetic symbols
manifest
MD5
MDX unique name
measure
measure group
member
member property
merged cell
metafile
minimal save
minor gridline
minor scheme
minor tick mark
module
moving average
multidimensional expression (MDX)
named range
ninched
non-contiguous range
Normal view
number format
Object Linking and Embedding (OLE)
object model
OCXDropDown control
ODBC
Office data connection (ODC) file
OLAP
OLAP calculated member
OLAP cube
OLAP hierarchy
OLAP KPI
OLAP level
OLAP measure
OLAP member
OLAP member property
OLAP named set
OLAP tuple
OLE compound file
OLE DB
OLE object
OLE server
OLE2
one-variable data table
outline
outline effect
outline level
outline state
out-of-memory
page break
Page Break Preview view
Page Layout view
pane
Pane control
phonetic guide
phonetic information
phonetic string
phonetic text run
PivotChart filter pane
PivotTable field list
pixel
placeholder
plot area
point
Popup control
precision as displayed
primary pie
print area
print settings
print titles
ProgID
protected
protection
published
published item
query
query table
R1C1
range
reading order
read-only recommended
real-time data (RTD)
rectangular gradient
red-green-blue-alpha (RGBA)
reference style
refresh
regional settings
relative reference
relative security descriptor
revision
revision history
right-to-left
routing slip
RTD server
ruler
safe load
scenario
Scenario Manager
secondary bar/pie
security descriptor
selected
selection
series line
server name
shade
shadow effect
shape
shared workbook
sheet
sheet stream
sheet tab
sheet view
shrink to fit
smart document
smart tag
smart tag actions button
smart tag indicator
sort
sort condition
sort order
source data
split pane
SplitButtonMRUPopup control
SplitButtonPopup control
SplitDropDown control
startup directory
storage
stream
strikethrough formatting
stripe band
stroke order
Structured Query Language (SQL)
style
table
template
text importation
text run
theme
time hierarchy
toolbar control
toolbar view
ToolTip
top N filter
total row
transfer protocol
transition formula entry
transition formula evaluation
trendline
tuple
twip
two-variable data table
type library
UNC volume
Uniform Resource Identifier (URI)
Uniform Resource Locator (URL)
up-down bar
user name
user-defined function (UDF)
VBA
VBA project
vertical alignment
visible
Visual Basic for Applications (VBA)
VML
volatile
wall
watched cell
web query
workbook
workbook parameter
workbook stream
worksheet
write reservation
XML map
XML node
XML Path Language (XPath)
XML schema
XML schema definition (XSD)
XOR obfuscation
XPath expression
zoom level
z-order

The following terms are specific to this document:

active pane: The pane that currently has focus or contains the current selection or object.

advanced filter: An extended filter option that enables users to specify complex filter criteria and a destination range for the filter results.

AutoComplete: A feature that suggests text automatically based on the first few characters that a user types.

BIFF2: A binary file format that is used by default to save worksheets in Microsoft Excel 2.1.

BIFF3: A binary file format that is used by default to save worksheets in Microsoft Excel 3.0 for Windows.

block-level formatting: A type of formatting that can be applied to a field or column (2) in a table. It is applied to all existing records and automatically to new records.

Briefcase: A system folder in Windows that is used to share and synchronize files between computers.

category label: (1) A label that appears on the horizontal (x) axis of a chart and identifies the categories of the source data.

(2) A label that represents a PivotTable item in a row PivotTable field in a PivotChart report.

column formula: A formula that is used in a calculated column.

column outline: A nested grouping of columns (2) in a worksheet.

consolidation range: A range of source data that is used in a data consolidation process.

cryptographic service provider: An independent software module that performs authentication (2), encoding, and encryption services that Windows-based applications access through the CryptoAPI.

custom color palette: A set of user-defined colors that is available for formatting.

custom rollup: An aggregation (1) calculation that allows Online Analytical Processing (OLAP) cube designers to aggregate measures with a custom formula or operator. A custom rollup is defined on a hierarchy.

double accounting: An underline style that places two lines beneath the formatted text. Double accounting is frequently used to indicate totals.

down bar: See up-down bar.

fill alignment: A setting that repeats a cell value to fill the horizontal space of a cell. If the cell value exceeds the horizontal width of the cell, the value is truncated.

formula error checking: A mechanism that identifies invalid worksheet data, formulas, or formatting and then proposes corrections.

frozen: See frozen panes.

full screen view: A document view that expands the display of a document to fill the computer screen. The view hides menus, toolbars, and taskbars.

general alignment: A default formatting setting for the horizontal alignment of cell content in a worksheet. Text is positioned to the left and numbers are positioned to the right.

hidden cell: A cell that does not appear in a worksheet view because it is contained within a hidden row or a hidden column.

hidden column: A column (2) that does not appear in a worksheet view because its width is set to 0 (zero). A column can be hidden if an outline is collapsed.

input language: A pairing of input language and input method. The pairing determines what language is currently being entered and how. The input language is usually determined by the keyboard language that is currently active in the operating system. Users can install keyboard layouts and Input Method Editors (IMEs) for several languages, and then switch between them at appropriate times to indicate the input language.

international macro sheet: A macro sheet that displays English function names and operates with U.S. English locale settings, regardless of product locale, user locale, or system locale.

local name: A defined name whose scope is limited to a specific sheet instead of the entire workbook.

merge conflict: A problem that occurs if two users are editing the same cell or other type of object in a workbook while changes are being merged in a shared workbook.

messaging system service provider: A business that supplies email and other messaging services to individuals, businesses, and other organizations.

Microsoft Office Web Components: A set of controls that can be used to create data analysis and reporting solutions.

narrow katakana: A non-cursive character set (1) that is used to write non-Japanese words phonetically in Japanese. Narrow katakana characters are represented with a single byte. Also referred to as half-width katakana.

natural language formula: A syntax for referring to tabular data in formulas by using column and row labels instead of cell references.

natural language label: A value of a cell or cells that identifies a range in a natural language formula. A label is typically the same as a column or row header in tabular data.

obfuscation key: A secret shared key combined with a cryptographic hash function that is intended to prevent a reversal of an encoding process. See also XOR obfuscation.

OLAP measure group: A collection of related OLAP measures in an OLAP cube. An OLAP cube can contain multiple measure groups.

OLAP set: A collection of OLAP tuples with the same dimensionality. Also referred to as OLAP named set.

OLE link: A connection between an Object Linking and Embedding (OLE) object and its OLE server. See also DDE link.

palette color: A specific color among those that are available on the active color palette.

parameterized query: A query that contains parameters. It applies to Open Database Connectivity (ODBC) and web queries. For example, a web query that retrieves stock quotes from a webpage can prompt users for a parameter, such as a stock symbol.

post method: A method of submitting form data in the header of an HTTP request.

property stream: A series of object properties that is used in processes such as checksum calculations.

recalculate: The process of computing a value in a workbook by initiating a calculation repeatedly.

reconnect condition: A condition that specifies whether to connect to a database again after a connection expires.

result cell: A cell that contains the results of the calculation of changing cells in a scenario.

revision record: Any of the records in the revision stream of a shared workbook that stores user edits to the workbook and other tracked information.

routing stage: The current status of a document with a routing slip.

row outline: A mechanism for grouping and nesting the rows in a worksheet.

RTD topic: A discrete combination of parameters that is used to request data from a real-time data (RTD) server.

single accounting: An underline style that places one line beneath the text. Single accounting can be used to indicate subtotals.

single sign-on (SSO) identifier: A string that represents the definition of user credentials that permit a user to access a network. See also single sign-on (SSO).

sort range: A range of cells that will be or has been sorted.

subtotal column: A column (2) that uses a summary or subtotal function to display the total of detail items in a PivotTable field.

text query: A query that is used to import data from text files.

text style: A formatting option, such as bold or italic, that can be applied to a font.

unfrozen pane: A portion of a worksheet that continues to scroll and function normally in split pane view. See also frozen pane.

up bar: See up-down bar.

web-only view: A view of a workbook from within a web browser.

wide katakana: A non-cursive character set (1) that is used to write non-Japanese words phonetically in Japanese. Wide katakana characters are represented with two bytes.

window state: The current positioning state of a window. Windows can be maximized or minimized, or the window size can be customized by the user.

MAY, SHOULD, MUST, SHOULD NOT, MUST NOT: These terms (in all caps) are used as described in [RFC2119]. All statements of optional behavior use either MAY, SHOULD, or SHOULD NOT.

Show:
© 2014 Microsoft