org.simpleods

Class Util

java.lang.Object

org.simpleods.Util

public class Util
extends java.lang.Object

Author:

Martin Schulz
Copyright 2008-2013 Martin Schulz
This file Util.java is part of SimpleODS.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COLOR_AliceBlue
static java.lang.String	COLOR_AntiqueWhite
static java.lang.String	COLOR_Aqua
static java.lang.String	COLOR_Aquamarine
static java.lang.String	COLOR_Azure
static java.lang.String	COLOR_Beige
static java.lang.String	COLOR_Bisque
static java.lang.String	COLOR_Black
static java.lang.String	COLOR_BlanchedAlmond
static java.lang.String	COLOR_Blue
static java.lang.String	COLOR_BlueViolet
static java.lang.String	COLOR_Brown
static java.lang.String	COLOR_Burlywood
static java.lang.String	COLOR_CadetBlue
static java.lang.String	COLOR_Chartreuse
static java.lang.String	COLOR_Chocolate
static java.lang.String	COLOR_Coral
static java.lang.String	COLOR_CornflowerBlue
static java.lang.String	COLOR_Cornsilk
static java.lang.String	COLOR_Crimson
static java.lang.String	COLOR_Cyan
static java.lang.String	COLOR_DarkBlue
static java.lang.String	COLOR_DarkCyan
static java.lang.String	COLOR_DarkGoldenrod
static java.lang.String	COLOR_DarkGray
static java.lang.String	COLOR_DarkGreen
static java.lang.String	COLOR_DarkKhaki
static java.lang.String	COLOR_DarkMagenta
static java.lang.String	COLOR_DarkOliveGreen
static java.lang.String	COLOR_DarkOrange
static java.lang.String	COLOR_DarkOrchid
static java.lang.String	COLOR_DarkRed
static java.lang.String	COLOR_DarkSalmon
static java.lang.String	COLOR_DarkSeaGreen
static java.lang.String	COLOR_DarkSlateBlue
static java.lang.String	COLOR_DarkSlateGray
static java.lang.String	COLOR_DarkTurquoise
static java.lang.String	COLOR_DarkViolet
static java.lang.String	COLOR_DeepPink
static java.lang.String	COLOR_DeepSkyBlue
static java.lang.String	COLOR_DimGray
static java.lang.String	COLOR_DodgerBlue
static java.lang.String	COLOR_Firebrick
static java.lang.String	COLOR_FloralWhite
static java.lang.String	COLOR_ForestGreen
static java.lang.String	COLOR_Fuchsia
static java.lang.String	COLOR_Gainsboro
static java.lang.String	COLOR_GhostWhite
static java.lang.String	COLOR_Gold
static java.lang.String	COLOR_Goldenrod
static java.lang.String	COLOR_Gray
static java.lang.String	COLOR_GRAY16
static java.lang.String	COLOR_GRAY32
static java.lang.String	COLOR_GRAY48
static java.lang.String	COLOR_GRAY64
static java.lang.String	COLOR_GRAY80
static java.lang.String	COLOR_GRAY96
static java.lang.String	COLOR_Green
static java.lang.String	COLOR_GreenYellow
static java.lang.String	COLOR_Honeydew
static java.lang.String	COLOR_HotPink
static java.lang.String	COLOR_IndianRed
static java.lang.String	COLOR_Indigo
static java.lang.String	COLOR_Ivory
static java.lang.String	COLOR_Khaki
static java.lang.String	COLOR_Lavender
static java.lang.String	COLOR_LavenderBlush
static java.lang.String	COLOR_LawnGreen
static java.lang.String	COLOR_LemonChiffon
static java.lang.String	COLOR_LightBlue
static java.lang.String	COLOR_LightCoral
static java.lang.String	COLOR_LightCyan
static java.lang.String	COLOR_LightGoldenrodYellow
static java.lang.String	COLOR_LightGreen
static java.lang.String	COLOR_LightGrey
static java.lang.String	COLOR_LightPink
static java.lang.String	COLOR_LightSalmon
static java.lang.String	COLOR_LightSeaGreen
static java.lang.String	COLOR_LightskyBlue
static java.lang.String	COLOR_LightSlateGray
static java.lang.String	COLOR_LightSteelBlue
static java.lang.String	COLOR_LightYellow
static java.lang.String	COLOR_Lime
static java.lang.String	COLOR_LimeGreen
static java.lang.String	COLOR_Linen
static java.lang.String	COLOR_Magenta
static java.lang.String	COLOR_Maroon
static java.lang.String	COLOR_MediumAquamarine
static java.lang.String	COLOR_MediumBlue
static java.lang.String	COLOR_MediumOrchid
static java.lang.String	COLOR_MediumPurple
static java.lang.String	COLOR_MediumSeaGreen
static java.lang.String	COLOR_MediumSlateBlue
static java.lang.String	COLOR_MediumSpringGreen
static java.lang.String	COLOR_MediumTurquoise
static java.lang.String	COLOR_MediumVioletRed
static java.lang.String	COLOR_MidnightBlue
static java.lang.String	COLOR_Mintcream
static java.lang.String	COLOR_MistyRose
static java.lang.String	COLOR_Moccasin
static java.lang.String	COLOR_NavajoWhite
static java.lang.String	COLOR_Navy
static java.lang.String	COLOR_Oldlace
static java.lang.String	COLOR_Olive
static java.lang.String	COLOR_OliveDrab
static java.lang.String	COLOR_Orange
static java.lang.String	COLOR_OrangeRed
static java.lang.String	COLOR_Orchid
static java.lang.String	COLOR_PaleGoldenrod
static java.lang.String	COLOR_PaleGreen
static java.lang.String	COLOR_PaleTurquoise
static java.lang.String	COLOR_PaleVioletRed
static java.lang.String	COLOR_PapayaWhip
static java.lang.String	COLOR_Peachpuff
static java.lang.String	COLOR_Peru
static java.lang.String	COLOR_Pink
static java.lang.String	COLOR_Plum
static java.lang.String	COLOR_PowderBlue
static java.lang.String	COLOR_Purple
static java.lang.String	COLOR_Red
static java.lang.String	COLOR_RosyBrown
static java.lang.String	COLOR_RoyalBlue
static java.lang.String	COLOR_SaddleBrown
static java.lang.String	COLOR_Salmon
static java.lang.String	COLOR_SandyBrown
static java.lang.String	COLOR_SeaGreen
static java.lang.String	COLOR_SeaShell
static java.lang.String	COLOR_Sienna
static java.lang.String	COLOR_Silver
static java.lang.String	COLOR_SkyBlue
static java.lang.String	COLOR_SlateBlue
static java.lang.String	COLOR_SlateGray
static java.lang.String	COLOR_Snow
static java.lang.String	COLOR_SpringGreen
static java.lang.String	COLOR_SteelBlue
static java.lang.String	COLOR_Tan
static java.lang.String	COLOR_Teal
static java.lang.String	COLOR_Thistle
static java.lang.String	COLOR_Tomato
static java.lang.String	COLOR_Turquoise
static java.lang.String	COLOR_Violet
static java.lang.String	COLOR_Wheat
static java.lang.String	COLOR_White
static java.lang.String	COLOR_WhiteSmoke
static java.lang.String	COLOR_Yellow
static java.lang.String	COLOR_YellowGreen

Constructor Summary

Constructors

Constructor and Description
Util()

Method Summary

Methods

Modifier and Type	Method and Description
void	appendElement(java.lang.StringBuffer sb, java.lang.String sElementName, int nValue) Append a new element to StringBuffer sb, the name of the element is sElementName and the value is nValue.
void	appendElement(java.lang.StringBuffer sb, java.lang.String sElementName, java.lang.String sValue) Append a new element to StringBuffer sb, the name of the element is sElementName and the value is sValue.
void	copyStylesFromTo(OdsFile source, OdsFile target) Copy all styles from one OdsFile to another OdsFile.
java.lang.String	createHexColor(int nRed, int nGreen, int nBlue) Helper function to create any available color string from color values.
java.lang.String	dateToday(java.lang.String sDateFormat) Get the todays date in format sDateFormat.
static Util	getInstance()
int	positionToColumn(java.lang.String sPos) Convert a cell position string like B3 to the column number.
int	positionToRow(java.lang.String sPos) Convert a string like B3 to the row number.
java.lang.String	replace(java.lang.String sHaystack, java.lang.String sNeedle, java.lang.String sReplacement) Replace all occurrences of a sub-string within a string.
java.lang.String	toXmlString(java.lang.String sString) Helper function to convert non-ASCII character to XML encoding.
boolean	writeString(java.util.zip.ZipOutputStream o, java.lang.String sText)
boolean	writeStringArray(java.util.zip.ZipOutputStream o, java.lang.String[] sText)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

COLOR_GRAY16

public static final java.lang.String COLOR_GRAY16

See Also:

Constant Field Values

COLOR_GRAY32

public static final java.lang.String COLOR_GRAY32

See Also:

Constant Field Values

COLOR_GRAY48

public static final java.lang.String COLOR_GRAY48

See Also:

Constant Field Values

COLOR_GRAY64

public static final java.lang.String COLOR_GRAY64

See Also:

Constant Field Values

COLOR_GRAY80

public static final java.lang.String COLOR_GRAY80

See Also:

Constant Field Values

COLOR_GRAY96

public static final java.lang.String COLOR_GRAY96

See Also:

Constant Field Values

COLOR_Maroon

public static final java.lang.String COLOR_Maroon

See Also:

Constant Field Values

COLOR_DarkRed

public static final java.lang.String COLOR_DarkRed

See Also:

Constant Field Values

COLOR_Firebrick

public static final java.lang.String COLOR_Firebrick

See Also:

Constant Field Values

COLOR_Red

public static final java.lang.String COLOR_Red

See Also:

Constant Field Values

COLOR_Salmon

public static final java.lang.String COLOR_Salmon

See Also:

Constant Field Values

COLOR_Tomato

public static final java.lang.String COLOR_Tomato

See Also:

Constant Field Values

COLOR_Coral

public static final java.lang.String COLOR_Coral

See Also:

Constant Field Values

COLOR_OrangeRed

public static final java.lang.String COLOR_OrangeRed

See Also:

Constant Field Values

COLOR_Chocolate

public static final java.lang.String COLOR_Chocolate

See Also:

Constant Field Values

COLOR_SandyBrown

public static final java.lang.String COLOR_SandyBrown

See Also:

Constant Field Values

COLOR_DarkOrange

public static final java.lang.String COLOR_DarkOrange

See Also:

Constant Field Values

COLOR_Orange

public static final java.lang.String COLOR_Orange

See Also:

Constant Field Values

COLOR_DarkGoldenrod

public static final java.lang.String COLOR_DarkGoldenrod

See Also:

Constant Field Values

COLOR_Goldenrod

public static final java.lang.String COLOR_Goldenrod

See Also:

Constant Field Values

COLOR_Gold

public static final java.lang.String COLOR_Gold

See Also:

Constant Field Values

COLOR_Olive

public static final java.lang.String COLOR_Olive

See Also:

Constant Field Values

COLOR_Yellow

public static final java.lang.String COLOR_Yellow

See Also:

Constant Field Values

COLOR_YellowGreen

public static final java.lang.String COLOR_YellowGreen

See Also:

Constant Field Values

COLOR_GreenYellow

public static final java.lang.String COLOR_GreenYellow

See Also:

Constant Field Values

COLOR_Chartreuse

public static final java.lang.String COLOR_Chartreuse

See Also:

Constant Field Values

COLOR_LawnGreen

public static final java.lang.String COLOR_LawnGreen

See Also:

Constant Field Values

COLOR_Green

public static final java.lang.String COLOR_Green

See Also:

Constant Field Values

COLOR_Lime

public static final java.lang.String COLOR_Lime

See Also:

Constant Field Values

COLOR_LimeGreen

public static final java.lang.String COLOR_LimeGreen

See Also:

Constant Field Values

COLOR_SpringGreen

public static final java.lang.String COLOR_SpringGreen

See Also:

Constant Field Values

COLOR_MediumSpringGreen

public static final java.lang.String COLOR_MediumSpringGreen

See Also:

Constant Field Values

COLOR_Turquoise

public static final java.lang.String COLOR_Turquoise

See Also:

Constant Field Values

COLOR_LightSeaGreen

public static final java.lang.String COLOR_LightSeaGreen

See Also:

Constant Field Values

COLOR_MediumTurquoise

public static final java.lang.String COLOR_MediumTurquoise

See Also:

Constant Field Values

COLOR_Teal

public static final java.lang.String COLOR_Teal

See Also:

Constant Field Values

COLOR_DarkCyan

public static final java.lang.String COLOR_DarkCyan

See Also:

Constant Field Values

COLOR_Aqua

public static final java.lang.String COLOR_Aqua

See Also:

Constant Field Values

COLOR_Cyan

public static final java.lang.String COLOR_Cyan

See Also:

Constant Field Values

COLOR_DarkTurquoise

public static final java.lang.String COLOR_DarkTurquoise

See Also:

Constant Field Values

COLOR_DeepSkyBlue

public static final java.lang.String COLOR_DeepSkyBlue

See Also:

Constant Field Values

COLOR_DodgerBlue

public static final java.lang.String COLOR_DodgerBlue

See Also:

Constant Field Values

COLOR_RoyalBlue

public static final java.lang.String COLOR_RoyalBlue

See Also:

Constant Field Values

COLOR_Navy

public static final java.lang.String COLOR_Navy

See Also:

Constant Field Values

COLOR_DarkBlue

public static final java.lang.String COLOR_DarkBlue

See Also:

Constant Field Values

COLOR_MediumBlue

public static final java.lang.String COLOR_MediumBlue

See Also:

Constant Field Values

COLOR_Blue

public static final java.lang.String COLOR_Blue

See Also:

Constant Field Values

COLOR_BlueViolet

public static final java.lang.String COLOR_BlueViolet

See Also:

Constant Field Values

COLOR_DarkOrchid

public static final java.lang.String COLOR_DarkOrchid

See Also:

Constant Field Values

COLOR_DarkViolet

public static final java.lang.String COLOR_DarkViolet

See Also:

Constant Field Values

COLOR_Purple

public static final java.lang.String COLOR_Purple

See Also:

Constant Field Values

COLOR_DarkMagenta

public static final java.lang.String COLOR_DarkMagenta

See Also:

Constant Field Values

COLOR_Fuchsia

public static final java.lang.String COLOR_Fuchsia

See Also:

Constant Field Values

COLOR_Magenta

public static final java.lang.String COLOR_Magenta

See Also:

Constant Field Values

COLOR_MediumVioletRed

public static final java.lang.String COLOR_MediumVioletRed

See Also:

Constant Field Values

COLOR_DeepPink

public static final java.lang.String COLOR_DeepPink

See Also:

Constant Field Values

COLOR_HotPink

public static final java.lang.String COLOR_HotPink

See Also:

Constant Field Values

COLOR_Crimson

public static final java.lang.String COLOR_Crimson

See Also:

Constant Field Values

COLOR_Brown

public static final java.lang.String COLOR_Brown

See Also:

Constant Field Values

COLOR_IndianRed

public static final java.lang.String COLOR_IndianRed

See Also:

Constant Field Values

COLOR_RosyBrown

public static final java.lang.String COLOR_RosyBrown

See Also:

Constant Field Values

COLOR_LightCoral

public static final java.lang.String COLOR_LightCoral

See Also:

Constant Field Values

COLOR_Snow

public static final java.lang.String COLOR_Snow

See Also:

Constant Field Values

COLOR_MistyRose

public static final java.lang.String COLOR_MistyRose

See Also:

Constant Field Values

COLOR_DarkSalmon

public static final java.lang.String COLOR_DarkSalmon

See Also:

Constant Field Values

COLOR_LightSalmon

public static final java.lang.String COLOR_LightSalmon

See Also:

Constant Field Values

COLOR_Sienna

public static final java.lang.String COLOR_Sienna

See Also:

Constant Field Values

COLOR_SeaShell

public static final java.lang.String COLOR_SeaShell

See Also:

Constant Field Values

COLOR_SaddleBrown

public static final java.lang.String COLOR_SaddleBrown

See Also:

Constant Field Values

COLOR_Peachpuff

public static final java.lang.String COLOR_Peachpuff

See Also:

Constant Field Values

COLOR_Peru

public static final java.lang.String COLOR_Peru

See Also:

Constant Field Values

COLOR_Linen

public static final java.lang.String COLOR_Linen

See Also:

Constant Field Values

COLOR_Bisque

public static final java.lang.String COLOR_Bisque

See Also:

Constant Field Values

COLOR_Burlywood

public static final java.lang.String COLOR_Burlywood

See Also:

Constant Field Values

COLOR_Tan

public static final java.lang.String COLOR_Tan

See Also:

Constant Field Values

COLOR_AntiqueWhite

public static final java.lang.String COLOR_AntiqueWhite

See Also:

Constant Field Values

COLOR_NavajoWhite

public static final java.lang.String COLOR_NavajoWhite

See Also:

Constant Field Values

COLOR_BlanchedAlmond

public static final java.lang.String COLOR_BlanchedAlmond

See Also:

Constant Field Values

COLOR_PapayaWhip

public static final java.lang.String COLOR_PapayaWhip

See Also:

Constant Field Values

COLOR_Moccasin

public static final java.lang.String COLOR_Moccasin

See Also:

Constant Field Values

COLOR_Wheat

public static final java.lang.String COLOR_Wheat

See Also:

Constant Field Values

COLOR_Oldlace

public static final java.lang.String COLOR_Oldlace

See Also:

Constant Field Values

COLOR_FloralWhite

public static final java.lang.String COLOR_FloralWhite

See Also:

Constant Field Values

COLOR_Cornsilk

public static final java.lang.String COLOR_Cornsilk

See Also:

Constant Field Values

COLOR_Khaki

public static final java.lang.String COLOR_Khaki

See Also:

Constant Field Values

COLOR_LemonChiffon

public static final java.lang.String COLOR_LemonChiffon

See Also:

Constant Field Values

COLOR_PaleGoldenrod

public static final java.lang.String COLOR_PaleGoldenrod

See Also:

Constant Field Values

COLOR_DarkKhaki

public static final java.lang.String COLOR_DarkKhaki

See Also:

Constant Field Values

COLOR_Beige

public static final java.lang.String COLOR_Beige

See Also:

Constant Field Values

COLOR_LightGoldenrodYellow

public static final java.lang.String COLOR_LightGoldenrodYellow

See Also:

Constant Field Values

COLOR_LightYellow

public static final java.lang.String COLOR_LightYellow

See Also:

Constant Field Values

COLOR_Ivory

public static final java.lang.String COLOR_Ivory

See Also:

Constant Field Values

COLOR_OliveDrab

public static final java.lang.String COLOR_OliveDrab

See Also:

Constant Field Values

COLOR_DarkOliveGreen

public static final java.lang.String COLOR_DarkOliveGreen

See Also:

Constant Field Values

COLOR_DarkSeaGreen

public static final java.lang.String COLOR_DarkSeaGreen

See Also:

Constant Field Values

COLOR_DarkGreen

public static final java.lang.String COLOR_DarkGreen

See Also:

Constant Field Values

COLOR_ForestGreen

public static final java.lang.String COLOR_ForestGreen

See Also:

Constant Field Values

COLOR_LightGreen

public static final java.lang.String COLOR_LightGreen

See Also:

Constant Field Values

COLOR_PaleGreen

public static final java.lang.String COLOR_PaleGreen

See Also:

Constant Field Values

COLOR_Honeydew

public static final java.lang.String COLOR_Honeydew

See Also:

Constant Field Values

COLOR_SeaGreen

public static final java.lang.String COLOR_SeaGreen

See Also:

Constant Field Values

COLOR_MediumSeaGreen

public static final java.lang.String COLOR_MediumSeaGreen

See Also:

Constant Field Values

COLOR_Mintcream

public static final java.lang.String COLOR_Mintcream

See Also:

Constant Field Values

COLOR_MediumAquamarine

public static final java.lang.String COLOR_MediumAquamarine

See Also:

Constant Field Values

COLOR_Aquamarine

public static final java.lang.String COLOR_Aquamarine

See Also:

Constant Field Values

COLOR_DarkSlateGray

public static final java.lang.String COLOR_DarkSlateGray

See Also:

Constant Field Values

COLOR_PaleTurquoise

public static final java.lang.String COLOR_PaleTurquoise

See Also:

Constant Field Values

COLOR_LightCyan

public static final java.lang.String COLOR_LightCyan

See Also:

Constant Field Values

COLOR_Azure

public static final java.lang.String COLOR_Azure

See Also:

Constant Field Values

COLOR_CadetBlue

public static final java.lang.String COLOR_CadetBlue

See Also:

Constant Field Values

COLOR_PowderBlue

public static final java.lang.String COLOR_PowderBlue

See Also:

Constant Field Values

COLOR_LightBlue

public static final java.lang.String COLOR_LightBlue

See Also:

Constant Field Values

COLOR_SkyBlue

public static final java.lang.String COLOR_SkyBlue

See Also:

Constant Field Values

COLOR_LightskyBlue

public static final java.lang.String COLOR_LightskyBlue

See Also:

Constant Field Values

COLOR_SteelBlue

public static final java.lang.String COLOR_SteelBlue

See Also:

Constant Field Values

COLOR_AliceBlue

public static final java.lang.String COLOR_AliceBlue

See Also:

Constant Field Values

COLOR_SlateGray

public static final java.lang.String COLOR_SlateGray

See Also:

Constant Field Values

COLOR_LightSlateGray

public static final java.lang.String COLOR_LightSlateGray

See Also:

Constant Field Values

COLOR_LightSteelBlue

public static final java.lang.String COLOR_LightSteelBlue

See Also:

Constant Field Values

COLOR_CornflowerBlue

public static final java.lang.String COLOR_CornflowerBlue

See Also:

Constant Field Values

COLOR_Lavender

public static final java.lang.String COLOR_Lavender

See Also:

Constant Field Values

COLOR_GhostWhite

public static final java.lang.String COLOR_GhostWhite

See Also:

Constant Field Values

COLOR_MidnightBlue

public static final java.lang.String COLOR_MidnightBlue

See Also:

Constant Field Values

COLOR_SlateBlue

public static final java.lang.String COLOR_SlateBlue

See Also:

Constant Field Values

COLOR_DarkSlateBlue

public static final java.lang.String COLOR_DarkSlateBlue

See Also:

Constant Field Values

COLOR_MediumSlateBlue

public static final java.lang.String COLOR_MediumSlateBlue

See Also:

Constant Field Values

COLOR_MediumPurple

public static final java.lang.String COLOR_MediumPurple

See Also:

Constant Field Values

COLOR_Indigo

public static final java.lang.String COLOR_Indigo

See Also:

Constant Field Values

COLOR_MediumOrchid

public static final java.lang.String COLOR_MediumOrchid

See Also:

Constant Field Values

COLOR_Plum

public static final java.lang.String COLOR_Plum

See Also:

Constant Field Values

COLOR_Violet

public static final java.lang.String COLOR_Violet

See Also:

Constant Field Values

COLOR_Thistle

public static final java.lang.String COLOR_Thistle

See Also:

Constant Field Values

COLOR_Orchid

public static final java.lang.String COLOR_Orchid

See Also:

Constant Field Values

COLOR_LavenderBlush

public static final java.lang.String COLOR_LavenderBlush

See Also:

Constant Field Values

COLOR_PaleVioletRed

public static final java.lang.String COLOR_PaleVioletRed

See Also:

Constant Field Values

COLOR_Pink

public static final java.lang.String COLOR_Pink

See Also:

Constant Field Values

COLOR_LightPink

public static final java.lang.String COLOR_LightPink

See Also:

Constant Field Values

COLOR_Black

public static final java.lang.String COLOR_Black

See Also:

Constant Field Values

COLOR_DimGray

public static final java.lang.String COLOR_DimGray

See Also:

Constant Field Values

COLOR_Gray

public static final java.lang.String COLOR_Gray

See Also:

Constant Field Values

COLOR_DarkGray

public static final java.lang.String COLOR_DarkGray

See Also:

Constant Field Values

COLOR_Silver

public static final java.lang.String COLOR_Silver

See Also:

Constant Field Values

COLOR_LightGrey

public static final java.lang.String COLOR_LightGrey

See Also:

Constant Field Values

COLOR_Gainsboro

public static final java.lang.String COLOR_Gainsboro

See Also:

Constant Field Values

COLOR_WhiteSmoke

public static final java.lang.String COLOR_WhiteSmoke

See Also:

Constant Field Values

COLOR_White

public static final java.lang.String COLOR_White

See Also:

Constant Field Values

Constructor Detail

Util

public Util()

Method Detail

getInstance

public static Util getInstance()

writeStringArray

public boolean writeStringArray(java.util.zip.ZipOutputStream o,
                       java.lang.String[] sText)

writeString

public boolean writeString(java.util.zip.ZipOutputStream o,
                  java.lang.String sText)

createHexColor

public java.lang.String createHexColor(int nRed,
                              int nGreen,
                              int nBlue)

Helper function to create any available color string from color values.

Parameters:

nRed - The red value, 0-255

nGreen - The green value, 0-255

nBlue - The blue value, 0-255

Returns:

The hex string in the format '#rrggbb'

replace

public java.lang.String replace(java.lang.String sHaystack,
                       java.lang.String sNeedle,
                       java.lang.String sReplacement)

Replace all occurrences of a sub-string within a string.

Parameters:

sHaystack - The source string to be checked

sNeedle - The sub-string to be replaced

sReplacement - The replacement string

Returns:

The new string

toXmlString

public java.lang.String toXmlString(java.lang.String sString)

Helper function to convert non-ASCII character to XML encoding.

Parameters:

sString - The string to be converted

Returns:

The converted string

dateToday

public java.lang.String dateToday(java.lang.String sDateFormat)

Get the todays date in format sDateFormat. See Javas 'SimpleDateFormat' for details.
The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved):
Letter Date or Time Component Presentation Examples
G Era designator Text AD
y Year Year 1996; 96
M Month in year Month July; Jul; 07
w Week in year Number 27
W Week in month Number 2
D Day in year Number 189
d Day in month Number 10
F Day of week in month Number 2
E Day in week Text Tuesday; Tue
a Am/pm marker Text PM
H Hour in day (0-23) Number 0
k Hour in day (1-24) Number 24
K Hour in am/pm (0-11) Number 0
h Hour in am/pm (1-12) Number 12
m Minute in hour Number 30
s Second in minute Number 55
S Millisecond Number 978
z Time zone General time zone Pacific Standard Time; PST; GMT-08:00
Z Time zone RFC 822 time zone -0800

Parameters:

sDateFormat - The date format for todays date that should be returned.

Returns:

A string with the current date in sDateFormat

positionToColumn

public int positionToColumn(java.lang.String sPos)

Convert a cell position string like B3 to the column number.

Parameters:

sPos - The cell position in the range 'A1' to 'IV65536'

Returns:

The row, e.g. A1 will return 0, B1 will return 1, E1 will return 4

positionToRow

public int positionToRow(java.lang.String sPos)

Convert a string like B3 to the row number.

Parameters:

sPos - The cell position in the range 'A1' to 'IV65536'

Returns:

The column, e.g. A1 will return 0, B3 will return 2, X65000 will return 64999

copyStylesFromTo

public void copyStylesFromTo(OdsFile source,
                    OdsFile target)

Copy all styles from one OdsFile to another OdsFile.
The target file will then contain all styles from the source file.

Parameters:

source - The source file

target - The target file.

appendElement

public void appendElement(java.lang.StringBuffer sb,
                 java.lang.String sElementName,
                 java.lang.String sValue)

Append a new element to StringBuffer sb, the name of the element is sElementName
and the value is sValue.

Parameters:

sb - The StringBuffer to which the new element should be added.

sElementName - The new element name

sValue - The value of the element

appendElement

public void appendElement(java.lang.StringBuffer sb,
                 java.lang.String sElementName,
                 int nValue)

Append a new element to StringBuffer sb, the name of the element is sElementName
and the value is nValue.

Parameters:

sb - The StringBuffer to which the new element should be added.

sElementName - The new element name

nValue - The value of the element