Returns a vertical range of cells as a horizontal range, or vice versa.
Object Model
Syntax
'Declaration Public Class CalcTransposeFunction Inherits CalcBuiltinFunction
'Usage Dim instance As CalcTransposeFunction
public class CalcTransposeFunction : CalcBuiltinFunction
Remarks
TRANSPOSE must be entered as an array formula in a range that has the same number of rows and columns, respectively, as an array has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array on a worksheet.
Inheritance Hierarchy
System.Object
GrapeCity.CalcEngine.Functions.CalcFunction
GrapeCity.CalcEngine.Functions.CalcBuiltinFunction
GrapeCity.CalcEngine.Functions.CalcTransposeFunction
Requirements
Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also