2.9.4 ReportStyle


Menu Information

Preference: Report Style

Brief Information

Customize the report sheet style.

Additional Information

Minimum Origin Version Required: Origin 2025

Command Line Usage

ReportStyle rowFill:=30862532 colFill:=28109823 tlfColor:=31420186 tlfThickness:=3 tlgColor:=28913021 tlsColor:=15 tlsThickness:=2 ttFontColor:=21525541 ttItalic:=1 graphWidth:=200 graphKeepRatio:=1 gapBetBranch:=150;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Row Fill rowFill

Input

int

18

Specify the color filled in the rows of table header in the report sheet.
Color may be an index into Origin's Color List : 1 (Black), 2 (Red), up to 24 (Dark Gray) or up to 40 if you have defined the 16 Custom Colors in the Color dialog. Additionally, you can use the color function to assign any RGB color, as rowFill:=color(240,208,0)

Font Color rowFontColor

Input

int

1

Specify the color of the font in the rows of table header in the report sheet.
Color may be an index into Origin's Color List : 1 (Black), 2 (Red), up to 24 (Dark Gray) or up to 40 if you have defined the 16 Custom Colors in the Color dialog. Additionally, you can use the color function to assign any RGB color, as rowFontColor:=color(240,208,0)

Bold rowBold

Input

int

0

Specify whether set the font to bold in the rows of table header in the report sheet.

Option list:

  • 0=false
  • 1=true
Column Fill colFill

Input

int

18

Specify the color filled in the columns of table header in the report sheet.
Color may be an index into Origin's Color List : 1 (Black), 2 (Red), up to 24 (Dark Gray) or up to 40 if you have defined the 16 Custom Colors in the Color dialog. Additionally, you can use the color function to assign any RGB color, as colFill:=color(240,208,0)

Font Color colFontColor

Input

int

1

Specify the color of the font in the columns of table header in the report sheet.
Color may be an index into Origin's Color List : 1 (Black), 2 (Red), up to 24 (Dark Gray) or up to 40 if you have defined the 16 Custom Colors in the Color dialog. Additionally, you can use the color function to assign any RGB color, as colFontColor:=color(240,208,0)

Bold colBold

Input

int

1

Specify whether set the font to bold in the columns of table header in the report sheet.

Option list:

  • 0=false
  • 1=true
Fill to 1st Cell colFillTo1

Input

int

1

Specify whether fill color to the first cell of table header in the report sheet.

Option list:

  • 0=false
  • 1=true
Frame tlfFrame

Input

int

2

Control the frame displaying for the table lines.

Option list:

  • 0=no: No Frame
  • 1=full: Full Frame
  • 2=tb: Top&Bottom Frame
  • 3=lr: Left&Right Frame
Color tlfColor

Input

int

24

Specify the color of the frame in the report table.
Color may be an index into Origin's Color List : 1 (Black), 2 (Red), up to 24 (Dark Gray) or up to 40 if you have defined the 16 Custom Colors in the Color dialog. Additionally, you can use the color function to assign any RGB color, as tlfColor:=color(240,208,0)

Thickness tlfThickness

Input

double

2

Specify the thickness of the frame in the report table.

Grids tlgGrids

Input

int

2

Control the grid line displaying in the report table.

Option list:

  • 0=no:No Grid
  • 1=all:All Grids
  • 2=row:Row Grids Only
  • 3=col:Column Grids Only
Color tlgColor

Input

int

30593746

Specify the color of the grid line in the report table.
Color may be an index into Origin's Color List : 1 (Black), 2 (Red), up to 24 (Dark Gray) or up to 40 if you have defined the 16 Custom Colors in the Color dialog. Additionally, you can use the color function to assign any RGB color, as tlgColor:=color(240,208,0)

Thickness tlgThickness

Input

double

<auto>

Specify the thickness of the grid line in the report table.

Separator tlsSeparator

Input

int

2

Control the separator line displaying in the report table.

Option list:

  • 0=header:Header Separator
  • 1=colHeader:Column Header
  • 2=rowGroup:Group Separator
Color tlsColor

Input

int

24

Specify the color of the separator line in the report table.
Color may be an index into Origin's Color List : 1 (Black), 2 (Red), up to 24 (Dark Gray) or up to 40 if you have defined the 16 Custom Colors in the Color dialog. Additionally, you can use the color function to assign any RGB color, as tlsColor:=color(240,208,0)

Thickness tlsThickness

Input

double

1

Specify the thickness of the separator line in the report table.

Color ttFontColor

Input

int

24

Specify the font color of table titles.
Color may be an index into Origin's Color List : 1 (Black), 2 (Red), up to 24 (Dark Gray) or up to 40 if you have defined the 16 Custom Colors in the Color dialog. Additionally, you can use the color function to assign any RGB color, as ttFontColor:=color(240,208,0)

Bold ttBold

Input

int

1

Specify whether set the font of table titles to bold..

Option list:

  • 0=false
  • 1=true
Italic ttItalic

Input

int

0

Specify whether set the font of table titles to italic..

Option list:

  • 0=false
  • 1=true
Graph Width graphWidth

Input

int

300

Specify the graph width size in the report sheet.

Keep Aspect Ratio graphKeepRatio

Input

int

0

Specify the graph in the report sheet whether keep aspect ratio

Option list:

  • 0=false
  • 1=true
Gap Between Branches gapBetBranch

Input

int

100

Specify the gap size between each branch. For example, gap size between table and the graph.

Grids for Report Branches reportGrids

Input

int

0
Grids for Report Branches

Specify whether to show the grid lines for the report branches.

Option list:

  • 0=false
  • 1=true


Description

This X-Function is used to customize the report sheet style. You also can control it by the dialog and preview the style in the Preview window.

ReportSytle 01.png