com.f1j.ss.pivot
Class DataConflictException

java.lang.Object
  |
  +--java.lang.Throwable
        |
        +--java.lang.Exception
              |
              +--com.f1j.util.F1Exception
                    |
                    +--com.f1j.util.InvalidStateException
                          |
                          +--com.f1j.util.DataConflictException
                                |
                                +--com.f1j.ss.DataConflictException
                                      |
                                      +--com.f1j.ss.pivot.DataConflictException
Direct Known Subclasses:
IllegalPivotException
public class DataConflictException
extends DataConflictException

The requested operation would conflict with existing data in the document.

Since:
11.0
See Also:
Serialized Form

Field Summary
static com.f1j.util.F1Exception.EType eAllItemsHidden
          Used to indicate that the action will cause all items to be hidden.
static com.f1j.util.F1Exception.EType eBadFormula
          "Invalid formula syntax."
static com.f1j.util.F1Exception.EType eCannotChangeThisPart
          Used to identify a data conflict when trying to modify a read-only part of a PivotRange.
static com.f1j.util.F1Exception.EType eCannotSummarizeCalcField
          Calculated fields must be summarized by sum.
static com.f1j.util.F1Exception.EType eCannotUseCustomSubtotals
          "Custom subtotals are not supported when a PivotRange report has calculated items."
static com.f1j.util.F1Exception.EType eCantMoveItemsWhenSorting
          "AutoSort must be turned off to move items in a field."
static com.f1j.util.F1Exception.EType eCircularFields
          "Your formula cannot be entered because calculated fields cannot contain circular references.
static com.f1j.util.F1Exception.EType eEndingLessThanStart
          "Ending value must be greater than starting value."
static com.f1j.util.F1Exception.EType eFieldNotCalcField
          The selected field is not in the page area.
static com.f1j.util.F1Exception.EType eFieldNotCalcItem
          The selected field is not in the page area.
static com.f1j.util.F1Exception.EType eFieldNotInPageArea
          The selected field is not in the page area.
static com.f1j.util.F1Exception.EType eFieldUsedMultipleTimes
          "A field cannot be used more than once when a PivotRange report has calculated items."
static com.f1j.util.F1Exception.EType eIncrementNotPositive
          "Increment must be greater than zero."
static com.f1j.util.F1Exception.EType eItemFormulaWithIndexName
          "Positional references cannot be used in a calculated item formula while AutoSort by values or AutoShow is on"
static com.f1j.util.F1Exception.EType eMustUngroup
          Used to identify a data conflict when trying to resize or move only a portion of a PivotRange.
static com.f1j.util.F1Exception.EType eNoFormulasAllowed
          Used to indicate that setting a field or item name to a formula value is not allowed.
static com.f1j.util.F1Exception.EType eNoNullName
          Used to indicate that the setting of a null name in things like fields and items is not allowed.
static com.f1j.util.F1Exception.EType eNotAnItem
          Used to indicate that the name entered as a page field item, does not match an existing item in the field.
static com.f1j.util.F1Exception.EType eNotOverwritingValues
          "Cannot overwrite values"
static com.f1j.util.F1Exception.EType ePartialChange
          Used to identify a data conflict when trying to resize or move only a portion of a PivotRange.
static com.f1j.util.F1Exception.EType ePivotRangesOverlap
          "A PivotRange report cannot overlap another PivotRange report."
static com.f1j.util.F1Exception.EType eTooManyColumnItems
          "You cannot place a field that has more than 8,000 items in the column area."
static com.f1j.util.F1Exception.EType eTooManyItems
          "A field in your source data has more unique items than can be used in this context in a PivotRange report."
static com.f1j.util.F1Exception.EType eTooManyRowsColumns
          "PivotRange has too many rows or columns."
 
Fields inherited from class com.f1j.ss.DataConflictException
eBadExtractRange, eFreezePanesConflict, eInsertShiftOffWorkbook, eInvalidObject, ePartialArrayFormula, ePartialMergedCell, ePasteOverflowsSheet
 
Fields inherited from class com.f1j.util.DataConflictException
eGeneric
 
Fields inherited from class com.f1j.util.InvalidStateException
eGeneric
 
Fields inherited from class com.f1j.util.F1Exception
ADVANCED_FILTER_BAD_EXTRACT_RANGE, ADVANCED_FILTER_ONLY_COPY_TO_ACTIVE_SHEET, ARRAY_OVERFLOW, BAD_ARGUMENT, BAD_FORMULA, BAD_HSS, BAD_INPUTMASK, BAD_NUMBER_FORMAT, BAD_RC, BAD_VALIDATIONRULE, BUF_TOO_SHORT, CANCEL, CANNOT_DELETE_LAST_VISIBLE_SHEET, CANNOT_HIDE_LAST_VISIBLE_SHEET, CANNOT_MODIFY_PARAMETER, CANNOT_PERFORM_IN_REPORT_PREVIEW, CANNOT_PERFORM_ON_PROTECTED_SHEET, CANNOT_PERFORM_OPERATION_ON_ARRAY_ENTERED_CELLS, CANNOT_PERFORM_OPERATION_ON_MERGED_CELLS, CANNOT_REDO, CANNOT_SET_DATA_IN_CHART_DATASOURCE, CANNOT_UNDO, CANT_DELETE_NAME_IN_USE, DP_BadCellFormattingMode, DP_DataTypeNotSupport, DP_XSLTDocumentInvalid, DP_XSLTProcessorNotFound, DUPLICATE_NAME, DUPLICATE_SHEET_NAME, eGeneric, ENCRYPTION_SCHEME_UNAVAILABLE, ENDING_LESS_THAN_START, ERROR_IN_VTF_FILE, FILE_FORMAT_NOT_SECURE, FORMULA_TOO_LONG, FREEZE_PANES_CONFLICT, GENERAL, INCREMENT_NOT_POSITIVE, INDEX_OUT_OF_BOUNDS, INSERT_SHIFT_OFF_WORKBOOK, INVALID_FIELD_NAME, INVALID_FILE, INVALID_ITEM_NAME, INVALID_NAME, INVALID_OBJECT_TYPE, INVALID_OPERATION_FOR_OBJECT, INVALID_PARAMETER_TYPE, INVALID_PASSWORD, INVALID_REQUEST, INVALID_VALUE_FOR_PARAMETER_TYPE, LOCKED_CELLS_CANNOT_BE_MODIFIED, LOCKED_DOCUMENT_CANNOT_BE_MODIFIED, MUST_HAVE_LOCK, MUST_UNGROUP, NO_MEMORY, NO_ODBC_CONNECTION, NO_TRANSACTION, NO_WINDOW, NO_WORKBOOK, NOT_FOUND, NOT_IMPLEMENTED, NOTHING_TO_PASTE, NOTHING_TO_PRINT, OBJECT_NOT_FOUND, OBJECT_NOT_VISIBLE, ONLY_ONE_RANGE, PANE_NOT_VISIBLE, PARTIAL_ARRAY_FORMULA_CANNOT_BE_MODIFIED, PARTIAL_MERGED_CELL_CANNOT_BE_MODIFIED, PASTE_WOULD_OVERFLOW_SHEET, POSSIBLE_DATA_LOSS, PRINT_MARGINS_DONT_FIT, REPORT_RANGE_BOUNDARY, REPORT_RANGE_OVERLAP, SELECTION, SQL_AMBIGUOUS_COLUMN_REF, STRING_TOO_LONG, TOO_MANY_COLORS_TO_ENCODE_GIF, TOO_MANY_FONTS, TOO_MANY_HSS, TOO_MANY_ITEMS, TOO_MANY_OBJECTS, TOO_MANY_SELECTED_RANGES, UNABLE_TO_FIND_NAME, UNABLE_TO_INITIALIZE_PRINTER, UNABLE_TO_LOAD_CALLBACK, UNABLE_TO_LOAD_ODBC, UNABLE_TO_OPEN_CLIPBOARD, UNABLE_TO_OPEN_FILE, UNABLE_TO_WRITE_FILE, UNSUPPORTED_ENCRYPTION_ALGORITHM, UNSUPPORTED_FEATURE, UNSUPPORTED_SQL_TYPE, VALIDATION_FAILED, XML_PARSER_NOT_FOUND
 
Constructor Summary
DataConflictException(com.f1j.util.F1Exception.EType eType)
          Creates a DataConflictException of the specifed type.
 
Methods inherited from class com.f1j.util.F1Exception
getError, getLocalizedMessage, getMessage, getType
 

Field Detail

eAllItemsHidden

public static final com.f1j.util.F1Exception.EType eAllItemsHidden
Used to indicate that the action will cause all items to be hidden.
See Also:
F1Exception
Since:
11.0

eCannotChangeThisPart

public static final com.f1j.util.F1Exception.EType eCannotChangeThisPart
Used to identify a data conflict when trying to modify a read-only part of a PivotRange.
See Also:
F1Exception
Since:
11.0

eNoFormulasAllowed

public static final com.f1j.util.F1Exception.EType eNoFormulasAllowed
Used to indicate that setting a field or item name to a formula value is not allowed.
See Also:
F1Exception
Since:
11.0

eNoNullName

public static final com.f1j.util.F1Exception.EType eNoNullName
Used to indicate that the setting of a null name in things like fields and items is not allowed.
See Also:
F1Exception
Since:
11.0

eNotAnItem

public static final com.f1j.util.F1Exception.EType eNotAnItem
Used to indicate that the name entered as a page field item, does not match an existing item in the field.
See Also:
F1Exception
Since:
11.0

ePartialChange

public static final com.f1j.util.F1Exception.EType ePartialChange
Used to identify a data conflict when trying to resize or move only a portion of a PivotRange.
See Also:
F1Exception
Since:
11.0

eMustUngroup

public static final com.f1j.util.F1Exception.EType eMustUngroup
Used to identify a data conflict when trying to resize or move only a portion of a PivotRange.
See Also:
F1Exception
Since:
11.0

eFieldUsedMultipleTimes

public static final com.f1j.util.F1Exception.EType eFieldUsedMultipleTimes
"A field cannot be used more than once when a PivotRange report has calculated items."
See Also:
F1Exception
Since:
11.0

eCannotUseCustomSubtotals

public static final com.f1j.util.F1Exception.EType eCannotUseCustomSubtotals
"Custom subtotals are not supported when a PivotRange report has calculated items."
See Also:
F1Exception
Since:
11.0

eBadFormula

public static final com.f1j.util.F1Exception.EType eBadFormula
"Invalid formula syntax."
See Also:
F1Exception
Since:
11.0

eTooManyItems

public static final com.f1j.util.F1Exception.EType eTooManyItems
"A field in your source data has more unique items than can be used in this context in a PivotRange report."
See Also:
F1Exception
Since:
11.0

eTooManyColumnItems

public static final com.f1j.util.F1Exception.EType eTooManyColumnItems
"You cannot place a field that has more than 8,000 items in the column area."
See Also:
F1Exception
Since:
11.0

eTooManyRowsColumns

public static final com.f1j.util.F1Exception.EType eTooManyRowsColumns
"PivotRange has too many rows or columns."
See Also:
F1Exception
Since:
11.0

eCircularFields

public static final com.f1j.util.F1Exception.EType eCircularFields
"Your formula cannot be entered because calculated fields cannot contain circular references. Change the formula to make sure that it doesn't refer to its own cells."
See Also:
F1Exception
Since:
11.0

eFieldNotInPageArea

public static final com.f1j.util.F1Exception.EType eFieldNotInPageArea
The selected field is not in the page area.
See Also:
F1Exception
Since:
11.0

eFieldNotCalcField

public static final com.f1j.util.F1Exception.EType eFieldNotCalcField
The selected field is not in the page area.
See Also:
F1Exception
Since:
11.0

eFieldNotCalcItem

public static final com.f1j.util.F1Exception.EType eFieldNotCalcItem
The selected field is not in the page area.
See Also:
F1Exception
Since:
11.0

eItemFormulaWithIndexName

public static final com.f1j.util.F1Exception.EType eItemFormulaWithIndexName
"Positional references cannot be used in a calculated item formula while AutoSort by values or AutoShow is on"
See Also:
F1Exception
Since:
11.0

ePivotRangesOverlap

public static final com.f1j.util.F1Exception.EType ePivotRangesOverlap
"A PivotRange report cannot overlap another PivotRange report."
See Also:
F1Exception
Since:
11.0

eNotOverwritingValues

public static final com.f1j.util.F1Exception.EType eNotOverwritingValues
"Cannot overwrite values"
See Also:
F1Exception
Since:
11.0

eCantMoveItemsWhenSorting

public static final com.f1j.util.F1Exception.EType eCantMoveItemsWhenSorting
"AutoSort must be turned off to move items in a field."
See Also:
F1Exception
Since:
11.0

eEndingLessThanStart

public static final com.f1j.util.F1Exception.EType eEndingLessThanStart
"Ending value must be greater than starting value."
See Also:
F1Exception
Since:
12.0

eIncrementNotPositive

public static final com.f1j.util.F1Exception.EType eIncrementNotPositive
"Increment must be greater than zero."
See Also:
F1Exception
Since:
12.0

eCannotSummarizeCalcField

public static final com.f1j.util.F1Exception.EType eCannotSummarizeCalcField
Calculated fields must be summarized by sum.
See Also:
F1Exception
Since:
12.0
Constructor Detail

DataConflictException

public DataConflictException(com.f1j.util.F1Exception.EType eType)
Creates a DataConflictException of the specifed type.
Parameters:
eType - The type of DataConflictException.
Since:
11.0