TRIMRANGE

Theme:

The TRIMRANGE function scans from the edge of a range or array until it finds non-blank cells (or values), and then excludes those blank rows or columns.

Syntax

=TRIMRANGE(range,[trim_rows],[trim_cols])

Argument	Description
range	(Required) The range (or array) to be trimmed.
trim_rows	(Optional) Determines which rows should be trimmed. 0 - None. 1 - Trims leading blank rows. 2 - Trims trailing blank rows. 3 - Trims both leading and trailing blank rows (default).
trim_cols	(Optional) Determines which columns should be trimmed. 0 - None. 1 - Trims leading blank columns. 2 - Trims trailing blank columns. 3 - Trims both leading and trailing blank columns (default).

Samples

sheet.setFormula(0, 0, "TRIMRANGE(A:C, 3, 0)");

Trim References

Trim References (aka Trim Refs) are a set of shorthand notations that allow you to trim blank rows and columns from a range without having to use the TRIMRANGE function explicitly. Trim Refs modify the traditional colon (:) range operator by adding dots (.) to specify how you want to trim the range. There are three types of Trim Refs:

Trim Ref Type	Syntax	Equivalent TRIMRANGE	Description
Trim All	A1.:.E10	=TRIMRANGE(A1:E10, 3, 3)	Trims both leading and trailing blanks from the range.
Trim Trailing	A1:.E10	=TRIMRANGE(A1:E10, 2, 2)	Trims only the trailing blanks from the range.
Trim Leading	A1.:E10	=TRIMRANGE(A1:E10, 1, 1)	Trims only the leading blanks from the range.

Feedback

Submit and view feedback for

This Product This Page

Syntax Argument Description range (Required) The range (or array) to be trimmed. trim_rows (Optional) Determines which rows should be trimmed. 0 - None. 1 - Trims leading blank rows. 2 - Trims trailing blank rows. 3 - Trims both leading and trailing blank rows (default). trim_cols (Optional) Determines which columns should be trimmed. 0 - None. 1 - Trims leading blank columns. 2 - Trims trailing blank columns. 3 - Trims both leading and trailing blank columns (default). Samples Trim References Trim References (aka Trim Refs) are a set of shorthand notations that allow you to trim blank rows and columns from a range without having to use the TRIMRANGE function explicitly. Trim Refs modify the traditional colon (:) range operator by adding dots (.) to specify how you want to trim the range. There are three types of Trim Refs: Trim Ref Type Syntax Equivalent TRIMRANGE Description Trim All A1.:.E10 =TRIMRANGE(A1:E10, 3, 3) Trims both leading and trailing blanks from the range. Trim Trailing A1:.E10 =TRIMRANGE(A1:E10, 2, 2) Trims only the trailing blanks from the range. Trim Leading A1.:E10 =TRIMRANGE(A1:E10, 1, 1) Trims only the leading blanks from the range.

window.onload = function () {
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), { sheetCount: 1 });
initSpread(spread);
};
function initSpread(spread) {
var sd = data;
if (sd.length > 0) {
if (!spread) {
return;
}
spread.suspendPaint();
spread.fromJSON(sd[0]);
spread.calculate();
spread.resumePaint();
}
}

<!doctype html>
<html style="height:100%;font-size:14px;">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="stylesheet" type="text/css" href="$DEMOROOT$/en/purejs/node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2013white.css">
<script src="$DEMOROOT$/en/purejs/node_modules/@mescius/spread-sheets/dist/gc.spread.sheets.all.min.js" type="text/javascript"></script>
<script src="$DEMOROOT$/spread/source/js/license.js" type="text/javascript"></script>
<script src="$DEMOROOT$/spread/source/data/trimrange.js" type="text/javascript"></script>
<script src="app.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="styles.css">
</head>
<body>
<div class="sample-tutorial">
<div id="ss" style="width:100%;height:100%"></div>
</div>
</body>
</html>

.sample-tutorial {
position: relative;
height: 100%;
overflow: hidden;
}
body {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
}