text:
<!DOCTYPE HTML>

<title>Index (PicoXLSX4j 2.6.0 API)</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="dc.created" content="2020-09-01">
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">
<link rel="stylesheet" type="text/css" href="jquery/jquery-ui.css" title="Style">

JavaScript is disabled on your browser.

Skip navigation links

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

All Classes

SEARCH:
<input type="text" id="search" value="search" disabled="disabled">
<input type="reset" id="reset" value="reset" disabled="disabled">

JavaScript is disabled on your browser.

A B C D E F G H I J L M N O P R S T U V W
All Classes All Packages

A

AbstractStyle - Class in ch.rabanti.picoxlsx4j.style

Class represents an abstract style component

AbstractStyle() - Constructor for class ch.rabanti.picoxlsx4j.style.AbstractStyle

addAllowedActionOnSheetProtection(Worksheet.SheetProtectionValue) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Method to add allowed actions if the worksheet is protected.

addCell(Object, int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds an object to the defined cell address.

addCell(Object, int, int, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds an object to the defined cell address.

addCell(Object, String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds an object to the defined cell address.

addCell(Object, String, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds an object to the defined cell address.

addCellFormula(String, int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a cell formula as string to the defined cell address

addCellFormula(String, int, int, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a cell formula as string to the defined cell address

addCellFormula(String, String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a cell formula as string to the defined cell address

addCellFormula(String, String, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a cell formula as string to the defined cell address

addCellRange(List<Object>, Address, Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a list of object values to a defined cell range.

addCellRange(List<Object>, Address, Address, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a list of object values to a defined cell range.

addCellRange(List<Object>, String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a list of object values to a defined cell range.

addCellRange(List<Object>, String, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a list of object values to a defined cell range.

addHiddenColumn(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the defined column as hidden

addHiddenColumn(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the defined column as hidden

addHiddenRow(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the defined row as hidden

addNextCell(Object) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds an object to the next cell position.

addNextCell(Object, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds an object to the next cell position.

addNextCellFormula(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a formula as string to the next cell position

addNextCellFormula(String, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Adds a formula as string to the next cell position

addPart(String, String, Document) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer

Adds a Part to the file

addPart(String, String, Document, boolean) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer

Adds a Part to the file

addRelationshipEntry(String, String) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer.Relationship

Adds a relationship entry to the relationship

Address - Class in ch.rabanti.picoxlsx4j

C class representing a cell address (no getters and setters to simplify handling)

Address(int, int) - Constructor for class ch.rabanti.picoxlsx4j.Address

Constructor with with row and column as arguments

Address(int, int, Cell.AddressType) - Constructor for class ch.rabanti.picoxlsx4j.Address

Constructor with with row, column and address type as arguments

Address(String) - Constructor for class ch.rabanti.picoxlsx4j.Address

Constructor with address as string

Address(String, Cell.AddressType) - Constructor for class ch.rabanti.picoxlsx4j.Address

Constructor with address as string and address type.

addStyle(Style) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Adds a style component to the manager

addStyle(Style) - Method in class ch.rabanti.picoxlsx4j.Workbook

Adds a style to the style manager

addStyleComponent(Style, AbstractStyle) - Method in class ch.rabanti.picoxlsx4j.Workbook

Adds a style component to a style

addWorksheet(Worksheet) - Method in class ch.rabanti.picoxlsx4j.Workbook

Adding a new Worksheet.

addWorksheet(String) - Method in class ch.rabanti.picoxlsx4j.Workbook

Adding a new Worksheet.

addWorksheet(String, boolean) - Method in class ch.rabanti.picoxlsx4j.Workbook

Adding a new Worksheet with a sanitizing option.

append(AbstractStyle) - Method in class ch.rabanti.picoxlsx4j.style.Style

Appends the specified style parts to the current one.

AppendAnnotation - Annotation Type in ch.rabanti.picoxlsx4j.style

Annotation designated to control the copying of style properties

APPLICATIONNAME - Static variable in class ch.rabanti.picoxlsx4j.Version

Application name of the library

autoFilter - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can use auto filters if the worksheets is protected

Average(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a average formula

Average(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a average formula

B

backgroundColor - Variable in class ch.rabanti.picoxlsx4j.style.Fill

BasicFormulas - Class in ch.rabanti.picoxlsx4j

Class for handling of basic Excel formulas

BasicFormulas() - Constructor for class ch.rabanti.picoxlsx4j.BasicFormulas

BasicStyles - Class in ch.rabanti.picoxlsx4j.style

Factory class with the most important predefined styles

BasicStyles() - Constructor for class ch.rabanti.picoxlsx4j.style.BasicStyles

Bold() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the bold style

BoldItalic() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the bold and italic style

BOOL - ch.rabanti.picoxlsx4j.Cell.CellType

Type for boolean

Border - Class in ch.rabanti.picoxlsx4j.style

Class representing a Border entry.

Border() - Constructor for class ch.rabanti.picoxlsx4j.style.Border

Default constructor

Border.StyleValue - Enum in ch.rabanti.picoxlsx4j.style

Enum for the border style

BorderFrame() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the border frame style

BorderFrameHeader() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the border style for header cells

bottom - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

Content will be aligned on the bottom (default)

buildRange(int, int, int, int) - Static method in class ch.rabanti.picoxlsx4j.Range

Method to build a range object from zwo column and two row numbers.

buildRange(Address, Address) - Static method in class ch.rabanti.picoxlsx4j.Range

Method to build a range object from two addresses.

C

calculateInternalRotation() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Method to calculate the internal text rotation.

Ceil(Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a ceil formula

Ceil(Worksheet, Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a ceil formula

Cell - Class in ch.rabanti.picoxlsx4j

Class representing a cell of a worksheet

Cell() - Constructor for class ch.rabanti.picoxlsx4j.Cell

Default constructor.

Cell(Object, Cell.CellType) - Constructor for class ch.rabanti.picoxlsx4j.Cell

Constructor with value and cell type.

Cell(Object, Cell.CellType, int, int, Worksheet) - Constructor for class ch.rabanti.picoxlsx4j.Cell

Constructor with value, cell type, row number, column number and the link to a worksheet

Cell(Object, Cell.CellType, String) - Constructor for class ch.rabanti.picoxlsx4j.Cell

Constructor with value, cell type and address.

Cell.AddressType - Enum in ch.rabanti.picoxlsx4j

Enum for the referencing style of the address

Cell.CellType - Enum in ch.rabanti.picoxlsx4j

Enum defines the basic data types of a cell

CellXf - Class in ch.rabanti.picoxlsx4j.style

Class representing an XF entry.

CellXf() - Constructor for class ch.rabanti.picoxlsx4j.style.CellXf

Default constructor

CellXf.HorizontalAlignValue - Enum in ch.rabanti.picoxlsx4j.style

Enum for the horizontal alignment of a cell

CellXf.TextBreakValue - Enum in ch.rabanti.picoxlsx4j.style

Enum for text break options

CellXf.TextDirectionValue - Enum in ch.rabanti.picoxlsx4j.style

Enum for the general text alignment direction

CellXf.VerticalAlignValue - Enum in ch.rabanti.picoxlsx4j.style

Enum for the vertical alignment of a cell

center - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

Content will be aligned in the center

center - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

Content will be aligned in the center

centerContinuous - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

Center continuous alignment

ch.rabanti.picoxlsx4j - package ch.rabanti.picoxlsx4j

ch.rabanti.picoxlsx4j.demo - package ch.rabanti.picoxlsx4j.demo

ch.rabanti.picoxlsx4j.demo.testing - package ch.rabanti.picoxlsx4j.demo.testing

ch.rabanti.picoxlsx4j.exception - package ch.rabanti.picoxlsx4j.exception

ch.rabanti.picoxlsx4j.lowLevel - package ch.rabanti.picoxlsx4j.lowLevel

ch.rabanti.picoxlsx4j.style - package ch.rabanti.picoxlsx4j.style

clearActiveStyle() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Clears the active style of the worksheet.

colorizedBackground(String) - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets a style to colorize the background of a cell

colorizedText(String) - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets a style to colorize the text of a cell

Column - Class in ch.rabanti.picoxlsx4j

Class representing a column of a worksheet

Column - Variable in class ch.rabanti.picoxlsx4j.Address

Column of the address (zero-based)

Column() - Constructor for class ch.rabanti.picoxlsx4j.Column

Default constructor

Column(int) - Constructor for class ch.rabanti.picoxlsx4j.Column

Constructor with column number

Column(String) - Constructor for class ch.rabanti.picoxlsx4j.Column

Constructor with column address

ColumnToColumn - ch.rabanti.picoxlsx4j.Worksheet.CellDirection

The next cell will be on the same row (A1,B1,C1...)

compareTo(Address) - Method in class ch.rabanti.picoxlsx4j.Address

Compares two addresses and returns whether the passed one is bigger or not.

compareTo(Cell) - Method in class ch.rabanti.picoxlsx4j.Cell

Implemented compareTo method

compareTo(AbstractStyle) - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle

Method to compare two objects for sorting purpose

convertArray(List<T>) - Static method in class ch.rabanti.picoxlsx4j.Cell

Converts a List of supported objects into a list of cells

copy() - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle

Abstract method to copy a component (dereferencing)

copy() - Method in class ch.rabanti.picoxlsx4j.style.Border

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.picoxlsx4j.style.Fill

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.picoxlsx4j.style.Font

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.picoxlsx4j.style.Style

Method to copy the current object to a new one

copyStyle() - Method in class ch.rabanti.picoxlsx4j.style.Style

Copies the current object as casted style

createBytesFromDocument(Document) - Static method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel

Method to convert an XML document to a byte array

createRelationship(String) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer

Creates a relationship.

createXMLDocument(String, String) - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel

Creates a XML document from a string

custom - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Custom Format (ID 164 and higher)

CUSTOMFORMAT_START_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.style.NumberFormat

Start ID for custom number formats as constant

D

darkGray - ch.rabanti.picoxlsx4j.style.Fill.PatternValue

Dark gray fill

dashDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue

dash-dotted border

dashDotDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue

dashed border with double-dots

dashed - ch.rabanti.picoxlsx4j.style.Border.StyleValue

dashed border

DATE - ch.rabanti.picoxlsx4j.Cell.CellType

Type for dates and times (Note: Dates before 1900-01-01 and after 9999-12-31 are not allowed)

DateFormat() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the date format style

dateStressTest(String, String, int) - Static method in class ch.rabanti.picoxlsx4j.demo.testing.Performance

Method to test and measure the performance if a huge number of date vales is inserted as new cells.

Default - ch.rabanti.picoxlsx4j.Cell.AddressType

Default behavior (e.g.

DEFAULT - ch.rabanti.picoxlsx4j.Cell.CellType

Default Type, not specified

DEFAULT_COLUMN_WIDTH - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Default column width as constant

DEFAULT_ROW_HEIGHT - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Default row height as constant

DEFAULTCOLOR - Static variable in class ch.rabanti.picoxlsx4j.style.Fill

DEFAULTFONT - Static variable in class ch.rabanti.picoxlsx4j.style.Font

Default font family as constant

deleteColumns - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can delete columns if the worksheets is protected

deleteRows - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can delete rows if the worksheets is protected

Disabled - ch.rabanti.picoxlsx4j.Worksheet.CellDirection

The address of the next cell will be not changed when adding a cell (for manual definition of cell addresses)

distributed - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

Distributed alignment

distributed - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

Distributed alignment

dotted - ch.rabanti.picoxlsx4j.style.Border.StyleValue

dotted border

DottedFill_0_125() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the special pattern fill style (for compatibility)

DoubleUnderline() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the double underline style

down() - Method in class ch.rabanti.picoxlsx4j.Shortener

Moves the cursor one row down

down(int) - Method in class ch.rabanti.picoxlsx4j.Shortener

Moves the cursor the number of defined rows down

E

EMPTY - ch.rabanti.picoxlsx4j.Cell.CellType

Type for empty cells.

EndAddress - Variable in class ch.rabanti.picoxlsx4j.Range

End address of the range

equals(AbstractStyle) - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle

Method to compare two objects for sorting purpose

equals(Object) - Method in class ch.rabanti.picoxlsx4j.Address

Compares two addresses whether they are equal.

equals(Object) - Method in class ch.rabanti.picoxlsx4j.Range

Overwritten equals method

F

fill - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

Content will fill up the cell

Fill - Class in ch.rabanti.picoxlsx4j.style

Class representing a Fill (background) entry.

Fill() - Constructor for class ch.rabanti.picoxlsx4j.style.Fill

Default constructor

Fill(String, Fill.FillType) - Constructor for class ch.rabanti.picoxlsx4j.style.Fill

Constructor with color value and fill type

Fill(String, String) - Constructor for class ch.rabanti.picoxlsx4j.style.Fill

Constructor with foreground and background color

Fill.FillType - Enum in ch.rabanti.picoxlsx4j.style

Enum for the type of the fill

Fill.PatternValue - Enum in ch.rabanti.picoxlsx4j.style

Enum for the type of the fill pattern

fillColor - ch.rabanti.picoxlsx4j.style.Fill.FillType

Color defines a solid fill color

FixedColumn - ch.rabanti.picoxlsx4j.Cell.AddressType

Column of the address is fixed (e.g.

FixedRow - ch.rabanti.picoxlsx4j.Cell.AddressType

Row of the address is fixed (e.g.

FixedRowAndColumn - ch.rabanti.picoxlsx4j.Cell.AddressType

Row and column of the address is fixed (e.g.

Floor(Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a floor formula

Floor(Worksheet, Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a floor formula

font(String) - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets a style with a user defined Font (Font size 11)
Note: The Font name as well as the availability of bold and italic on the Font cannot be validated by PicoXLSX4j.

font(String, int) - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets a style with a user defined Font
Note: The Font name as well as the availability of bold and italic on the Font cannot be validated by PicoXLSX4j.

font(String, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets a style with a user defined Font
Note: The Font name as well as the availability of bold and italic on the Font cannot be validated by PicoXLSX4j.

font(String, int, boolean, boolean) - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets a style with a user defined Font
Note: The Font name as well as the availability of bold and italic on the Font cannot be validated by PicoXLSX4j.

Font - Class in ch.rabanti.picoxlsx4j.style

Class representing a Font entry.

Font() - Constructor for class ch.rabanti.picoxlsx4j.style.Font

Default constructor

Font.SchemeValue - Enum in ch.rabanti.picoxlsx4j.style

Enum for the font scheme

Font.VerticalAlignValue - Enum in ch.rabanti.picoxlsx4j.style

Enum for the vertical alignment of the text from base line

foregroundColor - Variable in class ch.rabanti.picoxlsx4j.style.Fill

format_1 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: 0

format_10 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: 0.00%

format_11 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: 0.00E+00

format_12 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: # ?

format_13 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: # ??

format_14 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: m/d/yyyy

format_15 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: d-mmm-yy

format_16 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: d-mmm

format_17 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: mmm-yy

format_18 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: mm AM/PM

format_19 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: h:mm:ss AM/PM

format_2 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: 0.00

format_20 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: h:mm

format_21 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: h:mm:ss

format_22 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: m/d/yyyy h:mm

format_3 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: #,##0

format_37 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: #,##0_);(#,##0)

format_38 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: #,##0_);[Red](#,##0)

format_39 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: #,##0.00_);(#,##0.00)

format_4 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: #,##0.00

format_40 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: #,##0.00_);[Red](#,##0.00)

format_45 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: mm:ss

format_46 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: [h]:mm:ss

format_47 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: mm:ss.0

format_48 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: ##0.0E+0

format_49 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: #

format_5 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: $#,##0_);($#,##0)

format_6 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: $#,##0_);[Red]($#,##0)

format_7 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: $#,##0.00_);($#,##0.00)

format_8 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: $#,##0.00_);[Red]($#,##0.00)

format_9 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Format: 0%

formatCells - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can format cells if the worksheets is protected

formatColumns - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can format columns if the worksheets is protected

FormatException - Exception in ch.rabanti.picoxlsx4j.exception

Class for exceptions regarding format error incidents

FormatException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.FormatException

Default constructor

FormatException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.FormatException

Constructor with passed message

FormatException(String, String, Exception) - Constructor for exception ch.rabanti.picoxlsx4j.exception.FormatException

Constructor with passed message and inner

formatRows - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can format rows if the worksheets is protected

formula(String) - Method in class ch.rabanti.picoxlsx4j.Shortener

Sets a formula into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction)

formula(String, Style) - Method in class ch.rabanti.picoxlsx4j.Shortener

Sets a formula with style into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction)

FORMULA - ch.rabanti.picoxlsx4j.Cell.CellType

Type for Formulas (The cell will be handled differently)

G

general - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

General alignment

getAddress() - Method in class ch.rabanti.picoxlsx4j.Address

Gets the address as string

getAlignment() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Gets the text break options of the style

getApplication() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the application which created the workbook.

getApplicationVersion() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the version of the creation application.

getAutoFilterRange() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the range of the auto filter.

getBackgroundColor() - Method in class ch.rabanti.picoxlsx4j.style.Fill

Gets the Background color of the fill.

getBorder() - Method in class ch.rabanti.picoxlsx4j.style.Style

Gets the border component of the style

getBorderByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets a border by its hash

getBorders() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets all borders of the style manager

getBorderStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets the number of borders in the style manager

getBottomColor() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the color code of the bottom border.

getBottomStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the style of bottom cell border

getCategory() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the category of the document.

getCell(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the cell of the specified column and row number (zero-based)

getCell(Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the cell of the specified address

getCellAddress() - Method in class ch.rabanti.picoxlsx4j.Cell

Gets the combined cell Address as string in the format A1 - XFD1048576

getCellAddress2() - Method in class ch.rabanti.picoxlsx4j.Cell

Gets the combined cell address as class

getCellRange(int, int, int, int) - Static method in class ch.rabanti.picoxlsx4j.Cell

Get a list of cell addresses from a cell range

getCellRange(Address, Address) - Static method in class ch.rabanti.picoxlsx4j.Cell

Get a list of cell addresses from a cell range

getCellRange(String) - Static method in class ch.rabanti.picoxlsx4j.Cell

Gets a list of cell addresses from a cell range (format A1:B3 or AAD556:AAD1000)

getCellRange(String, String) - Static method in class ch.rabanti.picoxlsx4j.Cell

Get a list of cell addresses from a cell range

getCells() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the cells of the worksheet as map with the cell address as key and the cell object as value

getCellStyle() - Method in class ch.rabanti.picoxlsx4j.Cell

Gets the assigned style of the cell

getCellXf() - Method in class ch.rabanti.picoxlsx4j.style.Style

Gets the cellXf component of the style

getCellXfByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets a cellXf by its hash

getCellXfs() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets all cellXfs of the style manager

getCellXfStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets the number of cellXfs in the style manager

getCharset() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the charset of the Font (Default is empty)

getColorTheme() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the font color theme (Default is 1)

getColorValue() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the Font color (default is empty)

getColumn() - Method in class ch.rabanti.picoxlsx4j.Address

Gets the column address (A - XFD)

getColumnAddress() - Method in class ch.rabanti.picoxlsx4j.Column

Gets the column address

getColumnNumber() - Method in class ch.rabanti.picoxlsx4j.Cell

Gets the number of the column (zero-based)

getColumns() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets all columns with non-standard properties, like auto filter applied or a special width as map with the zero-based column index as key and the column object as value

getCompany() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the company owning the document.

getContentStatus() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the status of the document.

getCreator() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the creator of the workbook.

getCurrentCellDirection() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the direction when using AddNextCell method

getCurrentColumnNumber() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the current column number (zero based)

getCurrentRowNumber() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the current row number (zero based)

getCurrentWorksheet() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets the current worksheet

getCustomFormatCode() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Gets the custom format code in the notation of Excel

getCustomFormatID() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Gets the format number of the custom format.

getDataType() - Method in class ch.rabanti.picoxlsx4j.Cell

Gets the type of the cell

getDefaultColumnWidth() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the default column width

getDefaultRowHeight() - Method in class ch.rabanti.picoxlsx4j.Worksheet

getDescription() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the description of the document or comment about it

getDiagonalColor() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the color code of the diagonal lines.

getDiagonalStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the style of the diagonal lines

getDocumentInterception() - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel

Gets whether XML documents are intercepted during creation

getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.FormatException

Gets the title of the exception

getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.IOException

Gets the title of the exception

getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.RangeException

Gets the title of the exception

getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.StyleException

Gets the title of the exception

getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.WorksheetException

Gets the title of the exception

getFamily() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the font family (Default is 2)

getFilename() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets the filename of the workbook

getFill() - Method in class ch.rabanti.picoxlsx4j.style.Style

Gets the fill component of the style

getFillByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets a font by its hash

getFills() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets all fills of the style manager

getFillStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets the number of fills in the style manager

getFont() - Method in class ch.rabanti.picoxlsx4j.style.Style

Gets the font component of the style

getFontByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets a font by its hash

getFonts() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets all fonts of the style manager

getFontStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets the number of fonts in the style manager

getForegroundColor() - Method in class ch.rabanti.picoxlsx4j.style.Fill

Gets the foreground color of the fill.

getHiddenRows() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the hidden rows as map with the zero-based row number as key and a boolean as value.

getHorizontalAlign() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Gets the horizontal alignment of the style

getHyperlinkBase() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the hyper-link base of the document

getIndexedColor() - Method in class ch.rabanti.picoxlsx4j.style.Fill

Gets the indexed color (Default is 64)

getInnerException() - Method in exception ch.rabanti.picoxlsx4j.exception.FormatException

Gets the inner exception

getInnerException() - Method in exception ch.rabanti.picoxlsx4j.exception.IOException

Gets the inner exception

getInterceptedDocuments() - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel

Gets the intercepted documents if interceptDocuments is set to true

getInternalID() - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle

Gets the internal ID for sorting purpose in the Excel style document

getKeywords() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the keyword for the workbook.

getLastColumnNumber() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the last existing column number in the current worksheet (zero-based)

getLastRowNumber() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the last existing row number in the current worksheet (zero-based)

getLeftColor() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the color code of the left border.

getLeftStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the style of left cell border

getManager() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the responsible manager of the document.

getMergedCells() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the merged cells (only references) as map with the cell address as key and the range object as value

getName() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the font name (Default is Calibri)

getName() - Method in class ch.rabanti.picoxlsx4j.style.Style

Gets the name of the style.

getNumber() - Method in class ch.rabanti.picoxlsx4j.Column

Gets the column number

getNumber() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Gets the format number.

getNumberFormat() - Method in class ch.rabanti.picoxlsx4j.style.Style

Gets the number format component of the style

getNumberFormatByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets a number format by its hash

getNumberFormats() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets all number formats of the style manager

getNumberFormatStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets the number of number formats in the style manager

getOADateTimeString(Date) - Static method in class ch.rabanti.picoxlsx4j.Helper

Method to calculate the OA date (OLE automation) of the passed date.

 OA Date format starts at January 1st 1900 (actually 00.01.1900)and ends at December 31 9999.

getOATimeString(LocalTime) - Static method in class ch.rabanti.picoxlsx4j.Helper

Method to convert a time into the internal Excel time format (OAdate without days)

getPatternFill() - Method in class ch.rabanti.picoxlsx4j.style.Fill

Gets the pattern type of the fill (Default is none)

getPatternName(Fill.PatternValue) - Static method in class ch.rabanti.picoxlsx4j.style.Fill

Gets the pattern name from the enum

getRightColor() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the color code of the right border.

getRightStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the style of right cell border

getRowHeights() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets defined row heights as map with the zero-based row number as key and the height (float from 0 to 409.5) as value

getRowNumber() - Method in class ch.rabanti.picoxlsx4j.Cell

Gets the number of the row (zero-based)

getScheme() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the font scheme (Default is minor)

getSelectedCells() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the range of selected cells of this worksheet.

getSelectedWorksheet() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets the selected worksheet.

getSheetID() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the internal ID of the worksheet

getSheetName() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the name of the sheet

getSheetProtectionPassword() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the password used for sheet protection

getSheetProtectionValues() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the list of SheetProtectionValues.

getSize() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the font size.

getStyleByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets a style by its hash

getStyleByName(String) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets a style by its name

getStyleManager() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets the style manager of this workbook

getStyleName(Border.StyleValue) - Static method in class ch.rabanti.picoxlsx4j.style.Border

Gets the border style name from the enum

getStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets the number of styles in the style manager

getStyles() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Gets all styles of the style manager

getSubject() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the subject of the workbook

getTextDirection() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Gets the direction of the text within the cell

getTextRotation() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Gets the text rotation in degrees (from +90 to -90)

getTitle() - Method in class ch.rabanti.picoxlsx4j.Metadata

Gets the title of the workbook

getTopColor() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the color code of the top border.

getTopStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the style of top cell border

getValue() - Method in class ch.rabanti.picoxlsx4j.Cell

Gets the value of the cell (generic object type)

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Border.StyleValue

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Fill.FillType

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Fill.PatternValue

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Font.SchemeValue

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue

getValue() - Method in enum ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Gets the numeric value of the enum entry

getVerticalAlign() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Gets the vertical alignment of the style

getVerticalAlign() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the alignment of the font (Default is none)

getWidth() - Method in class ch.rabanti.picoxlsx4j.Column

Gets the width of the column

getWorkbookMetadata() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets the meta data object of the workbook

getWorkbookProtectionPassword() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets the password used for workbook protection

getWorkbookReference() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets the Reference to the parent Workbook

getWorksheetReference() - Method in class ch.rabanti.picoxlsx4j.Cell

Gets or sets the parent worksheet reference

getWorksheets() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets the list of worksheets in the workbook

goToNextColumn() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Moves the current position to the next column

goToNextColumn(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Moves the current position to the next column with the number of cells to move

goToNextRow() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Moves the current position to the next row (use for a new line)

goToNextRow(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Moves the current position to the next row with the number of cells to move (use for a new line)

gray0625 - ch.rabanti.picoxlsx4j.style.Fill.PatternValue

6.25% gray fill

gray125 - ch.rabanti.picoxlsx4j.style.Fill.PatternValue

12.5% gray fill

H

hair - ch.rabanti.picoxlsx4j.style.Border.StyleValue

hair border

hasAutoFilter() - Method in class ch.rabanti.picoxlsx4j.Column

Gets whether auto filter is enabled on the column

hasCell(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets whether the specified address exists in the worksheet.

hasCell(Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets whether the specified address exists in the worksheet.

hashCode() - Method in class ch.rabanti.picoxlsx4j.style.Border

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.picoxlsx4j.style.Fill

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.picoxlsx4j.style.Font

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.picoxlsx4j.style.Style

Override method to calculate the hash of this component

Helper - Class in ch.rabanti.picoxlsx4j

Class for shared used (static) methods

Helper() - Constructor for class ch.rabanti.picoxlsx4j.Helper

horizontal - ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue

Text direction is horizontal (default)

I

ignore() - Method in annotation type ch.rabanti.picoxlsx4j.style.AppendAnnotation

Indicates whether the property annotated with the attribute is ignored during the copying of properties

indexedColor - Variable in class ch.rabanti.picoxlsx4j.style.Fill

insertColumns - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can insert columns if the worksheets is protected

insertHyperlinks - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can insert hyperlinks if the worksheets is protected

insertRows - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can insert rows if the worksheets is protected

IOException - Exception in ch.rabanti.picoxlsx4j.exception

Class for exceptions regarding stream or save error incidents

IOException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.IOException

Default constructor

IOException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.IOException

Constructor with passed message

IOException(String, String, Exception) - Constructor for exception ch.rabanti.picoxlsx4j.exception.IOException

Constructor with passed message and inner exception

isBold() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the bold parameter of the font

isCustomFormat() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Gets whether this object is a custom format

isDefaultFont() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets whether this object is the default font

isDiagonalDown() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the downwards diagonal line

isDiagonalUp() - Method in class ch.rabanti.picoxlsx4j.style.Border

Gets the upwards diagonal line

isDoubleUnderline() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the double-underline parameter of the font

isEmpty() - Method in class ch.rabanti.picoxlsx4j.style.Border

Method to determine whether the object has no values but the default values (means: is empty and must not be processed)

isForceApplyAlignment() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Gets whether the applyAlignment property (used to merge cells) will be defined in the XF entry of the style.

isHidden() - Method in class ch.rabanti.picoxlsx4j.Column

Gets whether the column is hidden or visible

isHidden() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Gets whether the hidden property (used for protection or hiding of cells) will be defined in the XF entry of the style.

isInternalStyle() - Method in class ch.rabanti.picoxlsx4j.style.Style

Gets whether the style is system internal

isItalic() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the italic parameter of the font

isLocked() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Gets whether the locked property (used for locking / protection of cells or worksheets) will be defined in the XF entry of the style.

isNullOrEmpty(String) - Static method in class ch.rabanti.picoxlsx4j.Helper

Method of a string to check whether its reference is null or the content is empty

isStrike() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets whether the font is struck through

isStructureLockedIfProtected() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets whether the structure are locked if workbook is protected

isUnderline() - Method in class ch.rabanti.picoxlsx4j.style.Font

Gets the underline parameter of the font

isUseColorMRU() - Method in class ch.rabanti.picoxlsx4j.Metadata

If true, custom defined colors (in styles) will be added as recent colors (MRU)

isUseSheetProtection() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Gets whether the worksheet is protected

isWindowsLockedIfProtected() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets whether the windows are locked if workbook is protected

isWorkbookProtectionUsed() - Method in class ch.rabanti.picoxlsx4j.Workbook

Gets whether the workbook is protected

Italic() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the italic style

J

justify - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

justify alignment

justify - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

justify alignment

L

left - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

Content will be aligned left

lightGray - ch.rabanti.picoxlsx4j.style.Fill.PatternValue

Light gray fill

LowLevel - Class in ch.rabanti.picoxlsx4j.lowLevel

Class for low level handling (XML, formatting, preparing of packing)
This class is only for internal use.

LowLevel(Workbook) - Constructor for class ch.rabanti.picoxlsx4j.lowLevel.LowLevel

Constructor with defined workbook object

M

main(String[]) - Static method in class ch.rabanti.picoxlsx4j.demo.PicoXLSX4j

Method to run all demos

major - ch.rabanti.picoxlsx4j.style.Font.SchemeValue

Font scheme is major

Max(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a max formula

Max(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a max formula

MAX_COLUMN_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Maximum column number (zero-based)

MAX_COLUMN_WIDTH - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Maximum column width as constant

MAX_OADATE_VALUE - Static variable in class ch.rabanti.picoxlsx4j.Helper

Maximum valid OAdate value (9999-12-31)

MAX_ROW_HEIGHT - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Maximum row height as constant

MAX_ROW_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Maximum row number (zero-based)

Median(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a median formula

Median(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a median formula

medium - ch.rabanti.picoxlsx4j.style.Border.StyleValue

medium border

mediumDashDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue

medium dash-dotted border

mediumDashDotDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue

medium-dashed border with double-dots

mediumDashed - ch.rabanti.picoxlsx4j.style.Border.StyleValue

medium dashed border

mediumGray - ch.rabanti.picoxlsx4j.style.Fill.PatternValue

Medium gray fill

mergeCells(Address, Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Merges the defined cell range

mergeCells(Range) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Merges the defined cell range

mergeCells(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Merges the defined cell range

MergeCellStyle() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the style used when merging cells

Metadata - Class in ch.rabanti.picoxlsx4j

Class representing the meta data of a workbook

Metadata() - Constructor for class ch.rabanti.picoxlsx4j.Metadata

Default constructor

Min(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a min formula

Min(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a min formula

MIN_COLUMN_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Minimum column number (zero-based)

MIN_COLUMN_WIDTH - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Minimum column width as constant

MIN_OADATE_VALUE - Static variable in class ch.rabanti.picoxlsx4j.Helper

Minimum valid OAdate value (1900-01-01)

MIN_ROW_HEIGHT - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Minimum row height as constant

MIN_ROW_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.Worksheet

Minimum row number (zero-based)

minor - ch.rabanti.picoxlsx4j.style.Font.SchemeValue

Font scheme is minor (default)

N

nestedProperty() - Method in annotation type ch.rabanti.picoxlsx4j.style.AppendAnnotation

Indicates whether the property annotated with the attribute is a nested property.

none - ch.rabanti.picoxlsx4j.style.Border.StyleValue

no border

none - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

No alignment.

none - ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue

Text will overflow in cell

none - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

No alignment.

none - ch.rabanti.picoxlsx4j.style.Fill.PatternValue

No pattern (default)

none - ch.rabanti.picoxlsx4j.style.Font.SchemeValue

No Font scheme is used

none - ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue

Text will be rendered normal

none - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

No format / Default

NUMBER - ch.rabanti.picoxlsx4j.Cell.CellType

Type for all numeric types (long, integer and float and double)

NumberFormat - Class in ch.rabanti.picoxlsx4j.style

Class representing a NumberFormat entry.

NumberFormat() - Constructor for class ch.rabanti.picoxlsx4j.style.NumberFormat

Default constructor

NumberFormat.FormatNumber - Enum in ch.rabanti.picoxlsx4j.style

Enum for predefined number formats

O

objects - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can edit objects if the worksheets is protected

P

pack(OutputStream) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer

Method to pack the data into a XLSX file.

Packer - Class in ch.rabanti.picoxlsx4j.lowLevel

Class representing packer to compile XLSX files

Packer(LowLevel) - Constructor for class ch.rabanti.picoxlsx4j.lowLevel.Packer

Default constructor with parameter

Packer.Relationship - Class in ch.rabanti.picoxlsx4j.lowLevel

Nested class representing a relationship (MSXML)

parseVersion(int, int, int, int) - Static method in class ch.rabanti.picoxlsx4j.Metadata

Method to parse a common version (major.minor.revision.build) into the compatible format (major.minor).

patternColor - ch.rabanti.picoxlsx4j.style.Fill.FillType

Color defines a pattern color

patternFill - Variable in class ch.rabanti.picoxlsx4j.style.Fill

Performance - Class in ch.rabanti.picoxlsx4j.demo.testing

Class for performance tests

Performance() - Constructor for class ch.rabanti.picoxlsx4j.demo.testing.Performance

PicoXLSX4j - Class in ch.rabanti.picoxlsx4j.demo

Demo Program for PicoXLSX4j

PicoXLSX4j() - Constructor for class ch.rabanti.picoxlsx4j.demo.PicoXLSX4j

pivotTables - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can use pivot tables if the worksheets is protected

R

Range - Class in ch.rabanti.picoxlsx4j

Class representing a cell range (no getters and setters to simplify handling)

Range(Address, Address) - Constructor for class ch.rabanti.picoxlsx4j.Range

Constructor with with addresses as arguments

Range(String) - Constructor for class ch.rabanti.picoxlsx4j.Range

Constructor with a range string as argument

RangeException - Exception in ch.rabanti.picoxlsx4j.exception

Class for exceptions regarding range incidents (e.g out-of-range)

RangeException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.RangeException

Default constructor

RangeException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.RangeException

Constructor with passed message

recalculateAutoFilter() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Method to recalculate the auto filter (columns) of this worksheet.

recalculateColumns() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Method to recalculate the collection of columns of this worksheet.

removeAutoFilter() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Removes auto filters from the worksheet

removeCell(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Removes a previous inserted cell at the defined address

removeCell(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Removes a previous inserted cell at the defined address

removeHiddenColumn(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets a previously defined, hidden column as visible again

removeHiddenColumn(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets a previously defined, hidden column as visible again

removeHiddenRow(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets a previously defined, hidden row as visible again

removeMergedCells(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Removes the defined merged cell range

removeSelectedCells() - Method in class ch.rabanti.picoxlsx4j.Worksheet

Removes the cell selection of this worksheet

removeStyle() - Method in class ch.rabanti.picoxlsx4j.Cell

Removes the assigned style from the cell

removeStyle(Style) - Method in class ch.rabanti.picoxlsx4j.Workbook

Removes the passed style from the style sheet

removeStyle(Style, boolean) - Method in class ch.rabanti.picoxlsx4j.Workbook

Removes the defined style from the style manager of the workbook

removeStyle(String) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager

Removes a style and all its components from the style manager

removeStyle(String) - Method in class ch.rabanti.picoxlsx4j.Workbook

Removes the defined style from the style sheet of the workbook

removeStyle(String, boolean) - Method in class ch.rabanti.picoxlsx4j.Workbook

Removes the defined style from the style manager of the workbook

removeWorksheet(String) - Method in class ch.rabanti.picoxlsx4j.Workbook

Removes the defined worksheet

resolveCellAddress(int, int) - Static method in class ch.rabanti.picoxlsx4j.Cell

Gets the address of a cell by the column and row number (zero based)

resolveCellAddress(int, int, Cell.AddressType) - Static method in class ch.rabanti.picoxlsx4j.Cell

Gets the address of a cell by the column and row number (zero based)

resolveCellCoordinate(String) - Static method in class ch.rabanti.picoxlsx4j.Cell

Gets the column and row number (zero based) of a cell by the address

resolveCellRange(String) - Static method in class ch.rabanti.picoxlsx4j.Cell

Resolves a cell range from the format like A1:B3 or AAD556:AAD1000

resolveCellType() - Method in class ch.rabanti.picoxlsx4j.Cell

Method resets the Cell type and tries to find the actual type.

resolveColumn(String) - Static method in class ch.rabanti.picoxlsx4j.Cell

Gets the column number from the column address (A - XFD)

resolveColumnAddress(int) - Static method in class ch.rabanti.picoxlsx4j.Cell

Gets the column address (A - XFD)

resolveMergedCells() - Method in class ch.rabanti.picoxlsx4j.Workbook

Method to resolve all merged cells in all worksheets.

right - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

Content will be aligned right

right() - Method in class ch.rabanti.picoxlsx4j.Shortener

Moves the cursor one column to the right

right(int) - Method in class ch.rabanti.picoxlsx4j.Shortener

Moves the cursor the number of defined columns to the right

Round(Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a round formula

Round(Worksheet, Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a round formula

RoundFormat() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the round format style

Row - Variable in class ch.rabanti.picoxlsx4j.Address

Row of the address (zero-based)

RowToRow - ch.rabanti.picoxlsx4j.Worksheet.CellDirection

The next cell will be on the same column (A1,A2,A3...)

S

s_double - ch.rabanti.picoxlsx4j.style.Border.StyleValue

double border

sanitizeWorksheetName(String, Workbook) - Static method in class ch.rabanti.picoxlsx4j.Worksheet

Sanitizes a worksheet name

save() - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel

Method to save the workbook

save() - Method in class ch.rabanti.picoxlsx4j.Workbook

Saves the workbook

saveAs(String) - Method in class ch.rabanti.picoxlsx4j.Workbook

Saves the workbook with the defined name

saveAsStream(OutputStream) - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel

saveAsStream(OutputStream) - Method in class ch.rabanti.picoxlsx4j.Workbook

Save the workbook to a output stream

scenarios - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can edit scenarios if the worksheets is protected

selectLockedCells - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can select locked cells if the worksheets is protected

selectUnlockedCells - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can select unlocked cells if the worksheets is protected

setActiveStyle(Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the active style of the worksheet.

setAlignment(CellXf.TextBreakValue) - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Sets the text break options of the style

setApplication(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the application which created the workbook.

setApplicationVersion(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the version of the creation application.

setAutoFilter(boolean) - Method in class ch.rabanti.picoxlsx4j.Column

Sets whether auto filter is enabled on the column

setAutoFilter(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the column auto filter within the defined column range

setAutoFilterRange(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the column auto filter within the defined column range

setBackgroundColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Fill

Sets the background color of the fill.

setBold(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the bold parameter of the font

setBorder(Border) - Method in class ch.rabanti.picoxlsx4j.style.Style

Sets the border component of the style

setBottomColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the color code of the bottom border.

setBottomStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the style of bottom cell border

setCategory(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the category of the document.

setCellAddress(String) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the combined cell Address as string in the format A1 - XFD1048576

setCellAddress2(Address) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the combined cell address as class

setCellLockedState(boolean, boolean) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the lock state of the cell

setCellXf(CellXf) - Method in class ch.rabanti.picoxlsx4j.style.Style

Sets the cellXf component of the style

setCharset(String) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the charset of the Font (Default is empty)

setColor(String, Fill.FillType) - Method in class ch.rabanti.picoxlsx4j.style.Fill

Sets the color and the depending fill type

setColorTheme(int) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the font color theme (Default is 1)

setColorValue(String) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the font color (default is empty)

setColumnAddress(String) - Method in class ch.rabanti.picoxlsx4j.Column

Sets the column address

setColumnNumber(int) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the number of the column (zero-based)

setColumnWidth(int, float) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the width of the passed column number (zero-based)

setColumnWidth(String, float) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Set the current cell address

setCompany(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the company owning the document.

setContentStatus(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the status of the document.

setCreator(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the creator of the workbook.

setCurrentCellAddress(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Set the current cell address

setCurrentCellAddress(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Set the current cell address

setCurrentCellDirection(Worksheet.CellDirection) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the direction when using AddNextCell method

setCurrentColumnNumber(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the current column number (zero based)

setCurrentRowNumber(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the current row number (zero based)

setCurrentWorksheet(Worksheet) - Method in class ch.rabanti.picoxlsx4j.Shortener

Sets the worksheet accessed by the shortener

setCurrentWorksheet(String) - Method in class ch.rabanti.picoxlsx4j.Workbook

Sets the current worksheet

setCustomFormatCode(String) - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Sets the custom format code in the notation of Excel

setCustomFormatID(int) - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Sets the format number of the custom format.

setDataType(Cell.CellType) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the type of the cell

setDefaultColumnWidth(float) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the default column width

setDefaultRowHeight(float) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the default Row height

setDescription(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the description of the document or comment about it

setDiagonalColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the color code of the diagonal lines.

setDiagonalDown(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the downwards diagonal line

setDiagonalStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the style of the diagonal lines

setDiagonalUp(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the upwards diagonal line

setDocumentInterception(boolean) - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel

Set whether XML documents are intercepted during creation

setDoubleUnderline(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the double-underline parameter of the font

setFamily(String) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the font family (Default is 2)

setFilename(String) - Method in class ch.rabanti.picoxlsx4j.Workbook

Sets the filename of the workbook

setFill(Fill) - Method in class ch.rabanti.picoxlsx4j.style.Style

Sets the fill component of the style

setFont(Font) - Method in class ch.rabanti.picoxlsx4j.style.Style

Sets the font component of the style

setForceApplyAlignment(boolean) - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Sets whether the applyAlignment property (used to merge cells) will be defined in the XF entry of the style.

setForegroundColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Fill

Sets the foreground color of the fill.

setHidden(boolean) - Method in class ch.rabanti.picoxlsx4j.Column

Sets whether the column is hidden or visible

setHidden(boolean) - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Sets whether the hidden property (used for protection or hiding of cells) will be defined in the XF entry of the style.

setHorizontalAlign(CellXf.HorizontalAlignValue) - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Sets the horizontal alignment of the style

setHyperlinkBase(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the hyper-link base of the document

setIndexedColor(int) - Method in class ch.rabanti.picoxlsx4j.style.Fill

Sets the indexed color (Default is 64)

setInternalID(Integer) - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle

Sets the internal ID for sorting purpose in the Excel style document

setItalic(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the italic parameter of the font

setKeywords(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the keywords for the workbook.

setLeftColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the color code of the left border.

setLeftStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the style of left cell border

setLocked(boolean) - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Sets whether the locked property (used for locking / protection of cells or worksheets) will be defined in the XF entry of the style.

setManager(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the responsible manager of the document.

setName(String) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the font name (Default is Calibri)

setName(String) - Method in class ch.rabanti.picoxlsx4j.style.Style

Sets the name of the style.

setNumber(int) - Method in class ch.rabanti.picoxlsx4j.Column

Sets the column number

setNumber(NumberFormat.FormatNumber) - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Sets the format number.

setNumberFormat(NumberFormat) - Method in class ch.rabanti.picoxlsx4j.style.Style

Sets the number format component of the style

setPatternFill(Fill.PatternValue) - Method in class ch.rabanti.picoxlsx4j.style.Fill

Sets the pattern type of the fill (Default is none)

setRightColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the color code of the right border.

setRightStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the style of right cell border

setRowHeight(int, float) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the height of the passed row number (zero-based)

setRowNumber(int) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the number of the row (zero-based)

setScheme(Font.SchemeValue) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the Font scheme (Default is minor)

setSelectedCells(Address, Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the selected cells on this worksheet

setSelectedCells(Range) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the selected cells on this worksheet

setSelectedCells(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the selected cells on this worksheet

setSelectedWorksheet(int) - Method in class ch.rabanti.picoxlsx4j.Workbook

Sets the selected worksheet in the output workbook
Note: This method does not set the current worksheet while design time.

setSelectedWorksheet(Worksheet) - Method in class ch.rabanti.picoxlsx4j.Workbook

Sets the selected worksheet in the output workbook
Note: This method does not set the current worksheet while design time.

setSheetID(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the internal ID of the worksheet

setSheetName(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the name of the sheet

setSheetName(String, boolean) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the name of the sheet

setSheetProtectionPassword(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets or removes the password for worksheet protection.

setSize(int) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the Font size.

setStrike(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets whether the font is struck through

setStyle(Style) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the style of the cell

setStyleManagerReference(StyleManager) - Method in class ch.rabanti.picoxlsx4j.style.Style

Sets the reference of the style manager

setSubject(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the subject of the workbook

setTextDirection(CellXf.TextDirectionValue) - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Sets the direction of the text within the cell

setTextRotation(int) - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Sets the text rotation in degrees (from +90 to -90)

setTitle(String) - Method in class ch.rabanti.picoxlsx4j.Metadata

Sets the title of the workbook

setTopColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the color code of the top border.

setTopStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border

Sets the style of top cell border

setUnderline(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the underline parameter of the font

setUseColorMRU(boolean) - Method in class ch.rabanti.picoxlsx4j.Metadata

If true, custom defined colors (in styles) will be added as recent colors (MRU)

setUseSheetProtection(boolean) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets whether the worksheet is protected

setValue(Object) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the value of the cell (generic object type)

setVerticalAlign(CellXf.VerticalAlignValue) - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Sets the vertical alignment of the style

setVerticalAlign(Font.VerticalAlignValue) - Method in class ch.rabanti.picoxlsx4j.style.Font

Sets the Alignment of the font (Default is none)

setWidth(float) - Method in class ch.rabanti.picoxlsx4j.Column

Sets the width of the column

setWorkbookMetadata(Metadata) - Method in class ch.rabanti.picoxlsx4j.Workbook

Sets the meta data object of the workbook

setWorkbookProtection(boolean) - Method in class ch.rabanti.picoxlsx4j.Workbook

Sets whether the workbook is protected

setWorkbookProtection(boolean, boolean, boolean, String) - Method in class ch.rabanti.picoxlsx4j.Workbook

Sets or removes the workbook protection.

setWorkbookReference(Workbook) - Method in class ch.rabanti.picoxlsx4j.Worksheet

Sets the Reference to the parent Workbook

setWorksheetReference(Worksheet) - Method in class ch.rabanti.picoxlsx4j.Cell

Sets the parent worksheet reference

Shortener - Class in ch.rabanti.picoxlsx4j

Class to provide access to the current worksheet with a shortened syntax

 Note: The WS object can be null if the workbook was created without a worksheet.

Shortener() - Constructor for class ch.rabanti.picoxlsx4j.Shortener

Default constructor

shrinkToFit - ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue

Text will be resized to fit the cell

slantDashDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue

slant dash-dotted border

solid - ch.rabanti.picoxlsx4j.style.Fill.PatternValue

Solid fill (for colors)

sort - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can sort cells if the worksheets is protected

StartAddress - Variable in class ch.rabanti.picoxlsx4j.Range

Start address of the range

Strike() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the strike style

STRING - ch.rabanti.picoxlsx4j.Cell.CellType

Type for single characters and strings

Style - Class in ch.rabanti.picoxlsx4j.style

Class representing a style which consists of several components

Style() - Constructor for class ch.rabanti.picoxlsx4j.style.Style

Default constructor

Style(String) - Constructor for class ch.rabanti.picoxlsx4j.style.Style

Constructor with parameters

Style(String, int, boolean) - Constructor for class ch.rabanti.picoxlsx4j.style.Style

Constructor with parameters (internal use)

StyleException - Exception in ch.rabanti.picoxlsx4j.exception

Class for exceptions regarding Styles

StyleException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.StyleException

Default constructor

StyleException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.StyleException

Constructor with passed message

StyleManager - Class in ch.rabanti.picoxlsx4j.style

Class representing a style manager to maintain all styles and its components of a workbook

StyleManager() - Constructor for class ch.rabanti.picoxlsx4j.style.StyleManager

Default constructor

subscript - ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue

Text will be rendered as subscript

Sum(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a sum formula

Sum(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Returns a cell with a sum formula

superscript - ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue

Text will be rendered as superscript

T

thick - ch.rabanti.picoxlsx4j.style.Border.StyleValue

thick border

thin - ch.rabanti.picoxlsx4j.style.Border.StyleValue

thin border

TIME - ch.rabanti.picoxlsx4j.Cell.CellType

Type for times (Note: Internally handled as OAdate, represented by LocalTime

TimeFormat() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the time format style

top - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

Content will be aligned on the top

toString() - Method in class ch.rabanti.picoxlsx4j.Address

Returns the address as string or "Illegal Address" in case of an exception

toString() - Method in class ch.rabanti.picoxlsx4j.Range

Overwritten toString method

toString() - Method in class ch.rabanti.picoxlsx4j.style.Border

Override toString method

toString() - Method in class ch.rabanti.picoxlsx4j.style.CellXf

Override toString method

toString() - Method in class ch.rabanti.picoxlsx4j.style.Fill

Override toString method

toString() - Method in class ch.rabanti.picoxlsx4j.style.Font

Override toString method

toString() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat

Override toString method

toString() - Method in class ch.rabanti.picoxlsx4j.style.Style

Override toString method

Type - Variable in class ch.rabanti.picoxlsx4j.Address

U

Underline() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles

Gets the underline style

V

value(Object) - Method in class ch.rabanti.picoxlsx4j.Shortener

Sets a value into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction)

value(Object, Style) - Method in class ch.rabanti.picoxlsx4j.Shortener

Sets a value with style into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction)

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.Cell.AddressType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.Cell.CellType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Border.StyleValue

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Fill.FillType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Fill.PatternValue

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Font.SchemeValue

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.Worksheet.CellDirection

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

Returns the enum constant of this type with the specified name.

values() - Static method in enum ch.rabanti.picoxlsx4j.Cell.AddressType

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.Cell.CellType

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.Border.StyleValue

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.Fill.FillType

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.Fill.PatternValue

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.Font.SchemeValue

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.Worksheet.CellDirection

Returns an array containing the constants of this enum type, in
the order they are declared.

values() - Static method in enum ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue

Returns an array containing the constants of this enum type, in
the order they are declared.

Version - Class in ch.rabanti.picoxlsx4j

Final class to provide meta data for the library

Version() - Constructor for class ch.rabanti.picoxlsx4j.Version

VERSION - Static variable in class ch.rabanti.picoxlsx4j.Version

Version of the library

vertical - ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue

Text direction is vertical

VLookup(Address, Range, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Function to generate a Vlookup as Excel function

VLookup(Worksheet, Address, Worksheet, Range, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Function to generate a Vlookup as Excel function

VLookup(Object, Range, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Function to generate a Vlookup as Excel function

VLookup(Object, Worksheet, Range, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas

Function to generate a Vlookup as Excel function

W

Workbook - Class in ch.rabanti.picoxlsx4j

Class representing a workbook

Workbook(boolean) - Constructor for class ch.rabanti.picoxlsx4j.Workbook

Constructor with additional parameter to create a default worksheet.

Workbook(String) - Constructor for class ch.rabanti.picoxlsx4j.Workbook

Constructor with additional parameter to create a default worksheet with the specified name.

Workbook(String, String) - Constructor for class ch.rabanti.picoxlsx4j.Workbook

Constructor with filename ant the name of the first worksheet

Workbook(String, String, boolean) - Constructor for class ch.rabanti.picoxlsx4j.Workbook

Constructor with filename ant the name of the first worksheet

Worksheet - Class in ch.rabanti.picoxlsx4j

Class representing a worksheet of a workbook

Worksheet() - Constructor for class ch.rabanti.picoxlsx4j.Worksheet

Default constructor.

Worksheet(Workbook) - Constructor for class ch.rabanti.picoxlsx4j.Worksheet

Constructor with workbook reference

Worksheet(String, int, Workbook) - Constructor for class ch.rabanti.picoxlsx4j.Worksheet

Constructor with workbook reference, name and sheet ID

Worksheet.CellDirection - Enum in ch.rabanti.picoxlsx4j

Enum to define the direction when using AddNextCell method

Worksheet.SheetProtectionValue - Enum in ch.rabanti.picoxlsx4j

Enum to define the possible protection types when protecting a worksheet

WorksheetException - Exception in ch.rabanti.picoxlsx4j.exception

Class for exceptions regarding worksheets

WorksheetException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.WorksheetException

Default constructor

WorksheetException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.WorksheetException

Constructor with passed message

wrapText - ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue

Word wrap is active

WS - Variable in class ch.rabanti.picoxlsx4j.Workbook

Shortener omits getter and setter to simplify the access (Can throw a WorksheetException if not defined)

A B C D E F G H I J L M N O P R S T U V W
All Classes All Packages

Skip navigation links

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

All Classes

JavaScript is disabled on your browser.

Copyright © 2020. All rights reserved.


text:
package legal

// Portrait legal page dimensions
var Portrait = [2]float32{612.0, 1008.0}

// Landscape legal page dimensions
var Landscape = [2]float32{1008.0, 612.0}

redpajama_set_name: RedPajamaGithub


text:
  Oison est
       un village
       géographiquement positionné dans le département de Loiret en Centre. Elle totalisait 125 habitants en 2008.

Le nombre de logements, à Oison, était réparti en 2011 en zero appartements et 65 maisons soit
 un marché relativement équilibré.

À proximité de Oison sont positionnées géographiquement les villes de
Ruan à 3 km, 208 habitants,
Aschères-le-Marché située à 4 km, 1 165 habitants,
Trinay située à 5 km, 204 habitants,
Poinville située à 6 km, 116 habitants,
Lion-en-Beauce située à 2 km, 116 habitants,
Chaussy localisée à 3 km, 333 habitants,
 entre autres. De plus, Oison est située à seulement 26 km de Orléans.

Si vous pensez emmenager à Oison, vous pourrez facilement trouver une maison à vendre.


text:
<?php
error_reporting(E_ALL);
session_start();
require('./ortc.php');
//see if is the same file

/* -------------------- */
/* REPLACE THESE VALUES */
/* -------------------- */
$URL = 'http://ortc-developers.realtime.co/server/2.1';

// your realtime.co application key
//sua realtime.co aplicação
$AK = 'YOUR_APPLICATION_KEY';

// your realtime.co private key
// sua realtime.co chave privada
$PK = 'YOUR_APPLICATION_PRIVATE_KEY';

// token: could be randomly generated in the session
// token: pode ser randomicamente gerada na sessão
$TK = 'YOUR_AUTHENTICATION_TOKEN';

$CH = 'myChannel'; //channel // canal
$ttl = 180;
$isAuthRequired = false;
$result = false;
/* -------------------- */
/*        END / FIM     */
/* -------------------- */

// ORTC auth
// on a live usage we would already have the auth token authorized and stored in a php session
// Since a developer appkey does not require authentication the following code is optional

// ORTC auth
// em uma aplicação rodando você já tem o token auth autorizado e armazenado na sessão do php
// Uma vez que um desenvolvedor AppKey não exige autenticação o código a seguir é opcional

if( ! array_key_exists('ortc_token', $_SESSION) ){
	$_SESSION['ortc_token'] = $TK;
}

$rt = new Realtime( $URL, $AK, $PK, $TK );

if($isAuthRequired){
	$result = $rt->auth(
		array(
			$CH => 'w'
		),
		$ttl
	);//post authentication permissions. w -> write; r -> read
	  //autenticação de permissões para publicação. w -> escrita; r -> leitura
	echo '
authentication status '.( $result ? 'success' : 'failed' ).'
';
}

if($result || !$isAuthRequired){
	$result = $rt->send($CH, "Sending message from php API", $response);

	if($result){

		echo '
 send status connected
';
	}else{
		echo '
 send status failed
';

	}
}

?>

<!doctype html>

    <title>Testando Realtime.co</title>

    <input type="text" id="message" />
    <input type="button" id="myButton" value="Send to myChannel" />

0


text:
var S = require('../../store');
var Components = require('../../components');
var Images = require('../../images');
var Message = require('../message');

var Backend = require('../../services/backend');
var API = Backend.api;

var Profile = Components.createStateful({
    stateName: "f",
    filterState: function(s) {
        return {
            profile: s.profile,
            messages: s.messages,
        };
    },
    componentWillMount: function() {
        if (this.props.data.has('id')) {
            // Download the other user's messages and profile.
            Backend.messages.get(this.props.data.get('id'), "profile");
        } else {
            this.state.f.profile.getCurrent(S);
        }
    },
    renderBackdrop: function(profile) {
        var backdrop = {
            "backgroundColor": "#1A8BB0",
        };

        if (profile.backdrop) {
            var url = API.endpoints.data(profile.backdrop);
            backdrop = Images.background(url);
        }

        return (

        );
    },
    renderAvatar: function(profile) {
        var avatar;
        if (profile.image) {
            var url = API.endpoints.data(profile.image);
            avatar = (

            );
        }

        return avatar;
    },
    render: function() {
        var profile = this.state.f.profile.store;
        profile.messages = this.state.f.messages.store.filter(function(val) {
            return val.get('self') && val.get('public');
        });

        if (this.props.data.has('id')) {
            var alias = this.props.data.get('id');
            var messageId = alias + "/profile";

            var profileMessage = this.state.f.messages.index.get(messageId);
            var profileState = this.state.f.messages.state.get(messageId);

            if (this.state.f.messages.index.has(messageId)) {
                var components = profileMessage.get('components');
                var names = {
                    name: "airdispat.ch/profile/name",
                    description: "airdispat.ch/profile/description",
                    image: "airdispat.ch/profile/avatar",
                };

                profile = {
                    name: components.get(names.name).get('string'),
                    description: components.get(names.description).get('string'),
                    image: components.get(names.image).get('string'),
                    messages: this.state.f.messages.store.filter(function(val) {
                        return val.getIn(['from', 'alias']) == alias && val.get('public');
                    }),
                };
            } else {
                profile = {
                    name: "Loading...",
                }
            }
        }

        var description;
        if (profile.description) {
            description = profile.description;
        }

        var messages = profile.messages.map(function(val) {
            return (
                <Message message={ val }/>
            )
        });

        return (

                { this.renderBackdrop(profile) }
                { this.renderAvatar(profile) }

{ profile.name }

                        Edit My Profile

                        { description }

                    { messages }

        );
    }
});

module.exports = Profile;


text:
#ifndef __CMEM7_CONF_H
#define __CMEM7_CONF_H

#define _ADC
#define _AES
#define _CAN
#define _DDR
#define _DMA
#define _EFUSE
#define _ETH
#define _FLASH
#define _GPIO
#define _I2C
#define _MISC
#define _RTC
#define _SPI
#define _TIM
#define _UART
#define _USB
#define _WDG

#define USE_FULL_ASSERT    1

#ifdef  USE_FULL_ASSERT
/**
  * @brief  The assert_param macro is used for function's parameters check.
  * @param  expr: If expr is false, it calls assert_failed function which reports
  *         the name of the source file and the source line number of the call
  *         that failed. If expr is true, it returns no value.
  * @retval None
  */
  #define assert_param(expr) ((expr) ? (void)0 : assert_failed((unsigned char *)__FILE__, __LINE__))

	static void assert_failed(unsigned char* file, unsigned long line) {
		while (1) {
			;
		}
	}
#else
  #define assert_param(expr) ((void)0)
#endif /* USE_FULL_ASSERT */

typedef enum _BOOL {FALSE = 0, TRUE = 1} BOOL;

/**
  * System clock frequency, unit is Hz.
  */
#define SYSTEM_CLOCK_FREQ         200000000

/**
  * @brief  usecond delay
	* @note 	It can't delay in an accurate time
	* @param[in] usec usecond to be delay
	* @retval None
	*/
static void udelay(unsigned long usec) {
  unsigned long count = 0;
  unsigned long utime = SYSTEM_CLOCK_FREQ / 1000000 * usec;

  while(++count < utime) ;
}

/**
  * UART definition for print
	*/
#define PRINT_UART							UART2

/**
  * DDR type definition
  */
#define DDR_TYPE				3	// 2 for DDR2, 3 for DDR3

#if (DDR_TYPE == 3)
# define DDR_SIZE				(256 << 20)
#elif (DDR_TYPE == 2)
# define DDR_SIZE				(128 << 20)
#else
# error
#endif

#endif /* __CMEM7_CONF_H */


text:
package asana_test

import (
	"testing"
)

func TestUsers(t *testing.T) {
}

func TestTasks(t *testing.T) {
}


text:
            Schema Manager

                        <button href="javascript:void(0)" class="btn btn-default btn-sm" ng-click="createNewClass()">
                            New
                            Class
                        </button>

                        <button href="javascript:void(0)" class="btn btn-default btn-sm" ng-click="allIndexes()">
                            All Indexes
                        </button>

                        <button href="javascript:void(0)" class="btn btn-default btn-sm" ng-click="rebuildAllIndexes()">

                            Rebuild All Indexes
                        </button>

                    <form class="form-search">

                            <input type="text" class="input-xxlarge form-control search-query" ng-model="queryy" placeholder="Search class">

                        <button type="submit" class="btn" ng-click="">

                        </button>

                    </form>

                                Name

                                SuperClass

                                Alias
                                Abstract
                                Clusters

                                Default Cluster

                                    Cluster Selection

                                Records

                                Actions

                                {{result['name']}}
                                {{result['superClass']}}
                                {{result['alias']}}

                                    <input type="checkbox" ng-model="result['abstract']" ng-disabled="true">

                                {{result['clusters']}}
                                {{result['defaultCluster']}}

                                    <select type="text" ng-options="opt for opt in clusterStrategies" ng-change="setClusterStrategy(result)" ng-model="result['clusterSelection']">
                                    </select>

                                {{result['records'] | number }}

                                    <button href="javascript:void(0)" class="btn btn-primary btn-xs" ng-click="rename(result)">
                                        Rename
                                    </button>
                                    <button href="javascript:void(0)" class="btn btn-default btn-xs" ng-click="queryAll(result['name'])">
                                         Query All
                                    </button>

                                    <button href="javascript:void(0)" class="btn btn-default btn-xs" ng-click="createRecord(result['name'])">
                                         New Record
                                    </button>

                                    <button href="javascript:void(0)" ng-disabled="!canDrop(result['name'])" class="btn btn-danger btn-xs" ng-click="dropClass(result)">
                                         Drop
                                    </button>


text:
from django.db.models.signals import post_migrate
from django.dispatch import receiver

import lfs
from lfs.export.utils import register
from lfs.export.generic import export as export_script

@receiver(post_migrate)
def register_lfs_scripts(sender, **kwargs):
    # don't register our scripts until the table has been created by syncdb
    if sender == lfs.export.models:
        register(export_script, "Generic")


text:
/************************************************************************
 *
 * mouseevent.h
 * MouseEvent class
 *
 ************************************************************************/

#ifndef MOUSEEVENT_H
#define MOUSEEVENT_H

#include "vector4.h"

/**
 * A MouseEvent is generated by Application when a the mouse pointer is moved.
 * The pointer position is always reported relative to the window and the z
 * coordinate is zero.
 */
class MouseEvent {
public:
    /**
     * Constructor.
     *   - pos is the latest pointer position relative to the window
     *   - delta is the change in position since the last event
     */
     MouseEvent(vector4 pos, vector4 delta);

    /**
     * Copy constructor. The offset is subtracted from the position.
     */
     MouseEvent(MouseEvent event, vector4 offset);

    /**
     * Returns the latest pointer position relative to the window.
     */
    vector4 getPosition();

    /**
     * Returns the change in position since the last event.
     */
    vector4 getDelta();

private:
    /**
     * The position of the pointer.
     */
     vector4 pos;
    /**
     * The position of the pointer relative to the last event.
     */
     vector4 delta;
};

#endif //MOUSEEVENT_H


text:
title: Font Style Property
---
## Font Style Property

`font-style` property lets you to change the style of font meaning you can make font italicized. This property accepts following values:

* `normal` - Default value.
* `italic` - Font gets italicized by selecting the font that is classified as italic in its font family.
* `oblique` - Font that classified as oblique in its font family gets used.

`Italic` and `oblique` may look similar. According to [MDN](https://developer.mozilla.org/en-US/) *oblique are just sloped version of the regular face*.
You can also specify angle for the lean degree of font when providing `oblique` value. If angle is not provided, 14 degrees will be used as default.

#### More Information:

* [MDN - font-style](https://developer.mozilla.org/en-US/docs/Web/CSS/font-style)
* [CSS-Tricks - font-style](https://css-tricks.com/almanac/properties/f/font-style/)