Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

Sets or returns the ratio between the workbook's

...

tab

...

bar

...

and

...

the

...

horizontal

...

scroll

...

bar.

...

Signature
C#
C#
 public double TabRatio{ get; set; }
{signature}{signature:
}
Signature
vb.net
vb.net
Public Property TabRatio() As Double
{signature}
{remarks}
For 
Remarks

For example,

if

[

TabRatio

|Workbook.TabRatio]

is

set

to

50,

the

tab

bar

will

take

up

50\%

50% of

the

width

of

the

workbook

window,

while

the

horizontal

scroll

bar

will

take

up

the

other

half.The

value

of

{{

TabRatio

}}

should

be

between

0

and

100.

If

the

value

is

less

than

0,

ExcelWriter

will

set

{{

TabRatio

}}

to

0.

If

the

value

is

greater

than

100,

ExcelWriter

will

set

{{

TabRatio

}}

to

100.

{remarks} {example}{code:csharp|title=C#}

Example
Code Block
csharp
csharp
titleC#


          //--- Get the ratio between the workbook's tab bar and the horizontal scroll bar
          double ratio = wb.TabRatio;

          //--- Set the ratio between the workbook's tab bar and the horizontal scroll bar
          wb.TabRatio = 20;
        
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}


          '--- Get the ratio between the workbook's tab bar and the horizontal scroll bar
          Dim ratio As Double = wb.TabRatio

          '--- Set the ratio between the workbook's tab bar and the horizontal scroll bar
          wb.TabRatio = 20
        
{code} {example}