Package com._1c.g5.v8.dt.qw.ui.utils

Class SpreadsheetUtils

java.lang.Object

com._1c.g5.v8.dt.qw.ui.utils.SpreadsheetUtils

public final class SpreadsheetUtils
extends Object

Spreadsheet utilities methods

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	SpreadsheetUtils.TextParams	Cell text parameters

Field Summary

Fields

Modifier and Type	Field	Description
static final int	ALL_BORDERS
static final int	BOTTOM_BORDER
static final int	LEFT_BORDER
static final int	NONE_BORDER
static final int	RIGHT_BORDER
static final int	TOP_BORDER
static final int	UNLIMITED_WIDTH

Method Summary

Modifier and Type	Method	Description
static Pair<SpreadsheetDocument,BasicTemplate>	buildDocument(String templateName, org.eclipse.emf.ecore.EObject mdObject, boolean isReplaceTemplate)	Make new spreadsheet document
static void	closeEditor(org.eclipse.emf.ecore.EObject object)	Close opened editor with object
static Column	createColumn(SheetAccessor sheet, int width)	Create column from sheet accessor
static BasicTemplate	findTemplateWithName(org.eclipse.emf.ecore.EObject mdObject, org.eclipse.emf.ecore.EReference reference, String templateName)	Find template with name
static int	getColumnWidth(TypeDescription type, int minWidth)	Calculate column width for given type
static String	getDataFormat(TypeDescription type, ScriptVariant scriptVariant)	Get text format for type
static String	getText(String text, String textRu, ScriptVariant scriptVariant)	Get text depended from script variant
static void	openEditor(org.eclipse.emf.ecore.EObject object)	Open editor with object
static void	saveDocument(SpreadsheetDocument spreadsheetDocument)	Save document
static void	setCellText(SheetAccessor sheet, int row, int column, String text, FillType fillType, boolean isBoold, int border, String dataFormat, int autoIndent, String detailParameter)	Set cell text
static void	setCellText(SheetAccessor sheet, SpreadsheetUtils.TextParams textParams)	Set cell text
static void	setColumnWidth(SheetAccessor sheet, int width, int columnIndex, int rowIndex, int rowsCount)	Set column width

Methods inherited from class java.lang.Object

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

Field Details

NONE_BORDER

public static final int NONE_BORDER

See Also:

• Constant Field Values

LEFT_BORDER

public static final int LEFT_BORDER

See Also:

• Constant Field Values

RIGHT_BORDER

public static final int RIGHT_BORDER

See Also:

• Constant Field Values

TOP_BORDER

public static final int TOP_BORDER

See Also:

• Constant Field Values

BOTTOM_BORDER

public static final int BOTTOM_BORDER

See Also:

• Constant Field Values

ALL_BORDERS

public static final int ALL_BORDERS

See Also:

• Constant Field Values

UNLIMITED_WIDTH

public static final int UNLIMITED_WIDTH

See Also:

• Constant Field Values

Method Details

buildDocument

public static Pair<SpreadsheetDocument,BasicTemplate> buildDocument(String templateName,
 org.eclipse.emf.ecore.EObject mdObject,
 boolean isReplaceTemplate)

Make new spreadsheet document

Parameters:

templateName - - name

mdObject - - parent mdobject

isReplaceTemplate - - replace exist template

Returns:

pair with SpreadsheetDocument and BasicTemplate

setCellText

public static void setCellText(SheetAccessor sheet,
 int row,
 int column,
 String text,
 FillType fillType,
 boolean isBoold,
 int border,
 String dataFormat,
 int autoIndent,
 String detailParameter)

Set cell text

Parameters:

sheet - - sheet accessor

row - - row

column - - column

text - - text

fillType - - fill type

isBoold - - is text bold

border - - borders

dataFormat - - data format

autoIndent - - auto indent

detailParameter - - detail parameter

setCellText

public static void setCellText(SheetAccessor sheet,
 SpreadsheetUtils.TextParams textParams)

Set cell text

Parameters:

sheet - - sheet accessor

textParams - - text parameters

getColumnWidth

public static int getColumnWidth(TypeDescription type,
 int minWidth)

Calculate column width for given type

Parameters:

type - - type

minWidth - - minimum width

Returns:

width

getDataFormat

public static String getDataFormat(TypeDescription type,
 ScriptVariant scriptVariant)

Get text format for type

Parameters:

type - - type

scriptVariant - - Script variant

Returns:

text format

setColumnWidth

public static void setColumnWidth(SheetAccessor sheet,
 int width,
 int columnIndex,
 int rowIndex,
 int rowsCount)

Set column width

Parameters:

sheet - - sheet accessor

width - - width

columnIndex - - column index

rowIndex - - row index

rowsCount - - rows count

createColumn

public static Column createColumn(SheetAccessor sheet,
 int width)

Create column from sheet accessor

Parameters:

sheet - - sheet accessor

width - - width

Returns:

column

saveDocument

public static void saveDocument(SpreadsheetDocument spreadsheetDocument)

Save document

Parameters:

spreadsheetDocument - - spreadsheet document

openEditor

public static void openEditor(org.eclipse.emf.ecore.EObject object)

Open editor with object

Parameters:

object - - object

closeEditor

public static void closeEditor(org.eclipse.emf.ecore.EObject object)

Close opened editor with object

Parameters:

object - - object in editor

findTemplateWithName

public static BasicTemplate findTemplateWithName(org.eclipse.emf.ecore.EObject mdObject,
 org.eclipse.emf.ecore.EReference reference,
 String templateName)

Find template with name

Parameters:

mdObject - - MdObject

reference - - reference with templates

templateName - - template name

Returns:

template or null

getText

public static String getText(String text,
 String textRu,
 ScriptVariant scriptVariant)

Get text depended from script variant

Parameters:

text - - default text

textRu - - russian text

scriptVariant - - script variant

Returns:

text