Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV LETTER NEXT LETTER | FRAMES NO FRAMES

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _

## S

S_BRACKET_SYMBOL - Static variable in class org.apache.poi.ss.usermodel.ExcelStyleDateFormatter
sameProperties(FontRecord) - Method in class org.apache.poi.hssf.record.FontRecord
  Does this FontRecord have all the same font properties as the supplied FontRecord? Note that `Object.equals(Object)` will check for exact objects, while this will check for exact contents, because normally the font record's position makes a big difference too.
SaveRecalcRecord - Class in org.apache.poi.hssf.record
  Title: Save Recalc Record
SaveRecalcRecord() - Constructor for class org.apache.poi.hssf.record.SaveRecalcRecord
SaveRecalcRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.SaveRecalcRecord
ScalarConstantPtg - Class in org.apache.poi.hssf.record.formula
  Common superclass of all `Ptg`s that represent simple constant values.
ScalarConstantPtg() - Constructor for class org.apache.poi.hssf.record.formula.ScalarConstantPtg
scale(double, double) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
scale(double, double) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
ScenarioProtectRecord - Class in org.apache.poi.hssf.record
  Title: Scenario Protect Record
ScenarioProtectRecord() - Constructor for class org.apache.poi.hssf.record.ScenarioProtectRecord
ScenarioProtectRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.ScenarioProtectRecord
SCL_00A0 - Static variable in class org.apache.poi.hssf.record.UnknownRecord
SCLRecord - Class in org.apache.poi.hssf.record
  Specifies the window's zoom magnification.
SCLRecord() - Constructor for class org.apache.poi.hssf.record.SCLRecord
SCLRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.SCLRecord
SCRIPT - Static variable in class org.apache.poi.ss.usermodel.FontFamily
SEA_GREEN - Static variable in class org.apache.poi.ss.usermodel.IndexedColors
SEARCH - Static variable in class org.apache.poi.hssf.record.formula.functions.TextFunction
  Implementation of the FIND() function.

  Syntax:
  SEARCH(find_text, within_text, start_num)

  SEARCH is a case-insensitive version of FIND()
Section - Class in org.apache.poi.hpsf
  Represents a section in a `PropertySet`.
Section(byte[], int) - Constructor for class org.apache.poi.hpsf.Section
  Creates a `Section` instance from a byte array.
SectionIDMap - Class in org.apache.poi.hpsf.wellknown
  Maps section format IDs to `PropertyIDMap`s.
SectionIDMap() - Constructor for class org.apache.poi.hpsf.wellknown.SectionIDMap
SelectionRecord - Class in org.apache.poi.hssf.record
  Title: Selection Record (0x001D)
SelectionRecord(int, int) - Constructor for class org.apache.poi.hssf.record.SelectionRecord
  Creates a default selection record (cell A1, in pane ID 3)
SelectionRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.SelectionRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherBitmapBlip
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherBlipRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherBSERecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherChildAnchorRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherClientDataRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherContainerRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherDggRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherDgRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherMetafileBlip
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherOptRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherPictBlip
serialize() - Method in class org.apache.poi.ddf.EscherRecord
  Serializes to a new byte array.
serialize(int, byte[]) - Method in class org.apache.poi.ddf.EscherRecord
  Serializes to an existing byte array without serialization listener.
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherRecord
  Serializes the record to an existing byte array.
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherSpgrRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherSplitMenuColorsRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherSpRecord
  This method serializes this escher record into a byte array.
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.EscherTextboxRecord
serialize(int, byte[], EscherSerializationListener) - Method in class org.apache.poi.ddf.UnknownEscherRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.model.InternalWorkbook
  Serializes all records int the worksheet section into a big byte array.
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.AbstractEscherHolderRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.aggregates.RecordAggregate
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.AutoFilterInfoRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.BackupRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.BlankRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.BOFRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.BookBoolRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.BottomMarginRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.BoundSheetRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CalcCountRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CalcModeRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CellRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.cf.PatternFormatting
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CFHeaderRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CFRuleRecord
  called by the class that is responsible for writing this sucker.
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.AreaRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.AxisParentRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.AxisRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.AxisUsedRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.BarRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.BeginRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.CatLabRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ChartEndBlockRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ChartEndObjectRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ChartFormatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ChartFRTInfoRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ChartRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ChartStartBlockRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ChartStartObjectRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ChartTitleFormatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.DataFormatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.DatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.DefaultDataLabelTextPropertiesRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.EndRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.FontBasisRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.FontIndexRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.FrameRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.LinkedDataRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.NumberFormatIndexRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.PlotAreaRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.PlotGrowthRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.SeriesChartGroupIndexRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.SeriesIndexRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.SeriesListRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.SeriesRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.SeriesTextRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.SeriesToChartGroupRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.TextRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.TickRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.UnitsRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CodepageRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ColumnInfoRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.common.FeatProtection
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.common.FeatSmartTag
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.common.FtrHeader
serialize(LittleEndianOutput) - Method in interface org.apache.poi.hssf.record.common.SharedFeature
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.common.UnicodeString.FormatRun
serialize(ContinuableRecordOutput) - Method in class org.apache.poi.hssf.record.common.UnicodeString
  Serialises out the String.
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.cont.ContinuableRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ContinueRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CountryRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CRNCountRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.CRNRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DateWindow1904Record
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DBCellRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DefaultColWidthRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DefaultRowHeightRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DeltaRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DimensionsRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.DrawingGroupRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DrawingRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DrawingSelectionRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DSFRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DVALRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.DVRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.EmbeddedObjectRefSubRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.EndSubRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.EOFRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.EscherAggregate
  Serializes this aggregate to a byte array.
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ExternalNameRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ExternSheetRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ExtSSTRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.FeatHdrRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.FeatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.FilePassRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.FileSharingRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.FnGroupCountRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.FontRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.FormatRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.FtCblsSubRecord
  Serialize the record data into the supplied array of bytes
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.GridsetRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.GroupMarkerSubRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.GutsRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.HCenterRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.HeaderFooterBase
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.HeaderFooterRecord
  spit the record out AS IS.
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.HideObjRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.IndexRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.InterfaceEndRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.InterfaceHdrRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.IterationRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.LabelRecord
  THROWS A RUNTIME EXCEPTION..
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.LbsDataSubRecord.LbsDropData
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.LbsDataSubRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.LeftMarginRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.MergeCellsRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.MMSRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.MulBlankRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.MulRKRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.NameCommentRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.NameRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.NoteRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.NoteStructureSubRecord
  Serialize the record data into the supplied array of bytes
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ObjectProtectRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.ObjRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PageBreakRecord.Break
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PageBreakRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PaletteRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PaneRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PasswordRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PasswordRev4Record
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PrecisionRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PrintGridlinesRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PrintHeadersRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ProtectionRev4Record
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ProtectRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.RecalcIdRecord
serialize() - Method in class org.apache.poi.hssf.record.Record
  called by the class that is responsible for writing this sucker.
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.RecordBase
  called by the class that is responsible for writing this sucker.
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.RefModeRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.RefreshAllRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.RightMarginRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.RowRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.SaveRecalcRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.ScenarioProtectRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.SCLRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.SelectionRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.SharedValueRecordBase
serialize(int, byte[]) - Method in class org.apache.poi.hssf.record.StandardRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.StyleRecord
serialize() - Method in class org.apache.poi.hssf.record.SubRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.SubRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.SupBookRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.TabIdRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.TopMarginRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.UncalcedRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.UnknownRecord
  spit the record out AS IS.
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.UserSViewBegin
  spit the record out AS IS.
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.UserSViewEnd
  spit the record out AS IS.
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.UseSelFSRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.VCenterRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.WindowOneRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.WindowProtectRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.WriteAccessRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.WriteProtectRecord
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.record.WSBoolRecord
serialize(int, byte[]) - Method in class org.apache.poi.hssf.util.CellRangeAddress8Bit
  Deprecated. use `CellRangeAddress8Bit.serialize(LittleEndianOutput)`
serialize(LittleEndianOutput) - Method in class org.apache.poi.hssf.util.CellRangeAddress8Bit
serialize(LittleEndianOutput) - Method in class org.apache.poi.ss.formula.Formula
  Writes The formula encoding is includes: ushort tokenDataLen tokenData arrayConstantData (if present)
serialize(int, byte[]) - Method in class org.apache.poi.ss.util.CellRangeAddress
  Deprecated. use `CellRangeAddress.serialize(LittleEndianOutput)`
serialize(LittleEndianOutput) - Method in class org.apache.poi.ss.util.CellRangeAddress
serialize(int, byte[]) - Method in class org.apache.poi.ss.util.CellRangeAddressList
serialize(LittleEndianOutput) - Method in class org.apache.poi.ss.util.CellRangeAddressList
serializeArrayConstantData(LittleEndianOutput) - Method in class org.apache.poi.ss.formula.Formula
serializeComplexPart(byte[], int) - Method in class org.apache.poi.ddf.EscherComplexProperty
  Serializes the complex part of this property
serializeComplexPart(byte[], int) - Method in class org.apache.poi.ddf.EscherProperty
  Escher properties consist of a simple fixed length part and a complex variable length part.
serializeComplexPart(byte[], int) - Method in class org.apache.poi.ddf.EscherSimpleProperty
  Escher properties consist of a simple fixed length part and a complex variable length part.
serializePtgs(Ptg[], byte[], int) - Static method in class org.apache.poi.hssf.record.formula.Ptg
  Writes the ptgs to the data buffer, starting at the specified offset.
serializeSimplePart(byte[], int) - Method in class org.apache.poi.ddf.EscherArrayProperty
  Serializes the simple part of this property.
serializeSimplePart(byte[], int) - Method in class org.apache.poi.ddf.EscherComplexProperty
  Serializes the simple part of this property.
serializeSimplePart(byte[], int) - Method in class org.apache.poi.ddf.EscherProperty
  Escher properties consist of a simple fixed length part and a complex variable length part.
serializeSimplePart(byte[], int) - Method in class org.apache.poi.ddf.EscherSimpleProperty
  Serialize the simple part of the escher record.
serializeTokens(LittleEndianOutput) - Method in class org.apache.poi.ss.formula.Formula
SeriesChartGroupIndexRecord - Class in org.apache.poi.hssf.record.chart
  The series chart group index record stores the index to the CHARTFORMAT record (0 based).

SeriesChartGroupIndexRecord() - Constructor for class org.apache.poi.hssf.record.chart.SeriesChartGroupIndexRecord
SeriesChartGroupIndexRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.SeriesChartGroupIndexRecord
SeriesIndexRecord - Class in org.apache.poi.hssf.record.chart
  links a series to its position in the series list.

SeriesIndexRecord() - Constructor for class org.apache.poi.hssf.record.chart.SeriesIndexRecord
SeriesIndexRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.SeriesIndexRecord
SeriesLabelsRecord - Class in org.apache.poi.hssf.record.chart
  The series label record defines the type of label associated with the data format record.

SeriesLabelsRecord() - Constructor for class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
SeriesLabelsRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
SeriesListRecord - Class in org.apache.poi.hssf.record.chart
  SERIESLIST (0x1016)

  The series list record defines the series displayed as an overlay to the main chart record.
  (As with all chart related records, documentation is lacking.
SeriesListRecord(short[]) - Constructor for class org.apache.poi.hssf.record.chart.SeriesListRecord
SeriesListRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.SeriesListRecord
SeriesRecord - Class in org.apache.poi.hssf.record.chart
  The series record describes the overall data for a series.

SeriesRecord() - Constructor for class org.apache.poi.hssf.record.chart.SeriesRecord
SeriesRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.SeriesRecord
SeriesTextRecord - Class in org.apache.poi.hssf.record.chart
  SERIESTEXT (0x100D)
SeriesTextRecord() - Constructor for class org.apache.poi.hssf.record.chart.SeriesTextRecord
SeriesTextRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.SeriesTextRecord
SeriesToChartGroupRecord - Class in org.apache.poi.hssf.record.chart
  Indicates the chart-group index for a series.
SeriesToChartGroupRecord() - Constructor for class org.apache.poi.hssf.record.chart.SeriesToChartGroupRecord
SeriesToChartGroupRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.SeriesToChartGroupRecord
set(int) - Method in class org.apache.poi.util.BitField
  Set the bits.
set(byte) - Method in class org.apache.poi.util.ByteField
  set the ByteField's current value
set(byte, byte[]) - Method in class org.apache.poi.util.ByteField
  set the ByteField's current value and write it to a byte array
set(int) - Method in class org.apache.poi.util.IntegerField
  set the IntegerField's current value
set(int, byte[]) - Method in class org.apache.poi.util.IntegerField
  set the IntegerField's current value and write it to a byte array
set(int, int) - Method in class org.apache.poi.util.IntList
  Replaces the element at the specified position in this list with the specified element
set(long) - Method in class org.apache.poi.util.LongField
  set the LongField's current value
set(long, byte[]) - Method in class org.apache.poi.util.LongField
  set the LongField's current value and write it to a byte array
set(short) - Method in class org.apache.poi.util.ShortField
  set the ShortField's current value
set(short, byte[]) - Method in class org.apache.poi.util.ShortField
  set the ShortField's current value and write it to a byte array
set(int, short) - Method in class org.apache.poi.util.ShortList
  Replaces the element at the specified position in this list with the specified element
set123Prefix(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set some old holdover from lotus 123.
setActive(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  is the sheet currently displayed in the window
setActive(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets whether sheet is selected.
setActiveCellCol(short) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets the active column
setActiveCellCol(short) - Method in class org.apache.poi.hssf.record.SelectionRecord
  set the active cell's col
setActiveCellRef(short) - Method in class org.apache.poi.hssf.record.SelectionRecord
  set the active cell's reference number
setActiveCellRow(int) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets the active row
setActiveCellRow(int) - Method in class org.apache.poi.hssf.record.SelectionRecord
  set the active cell's row
setActivePane(short) - Method in class org.apache.poi.hssf.record.PaneRecord
  Set the active pane field for the Pane record.
setActiveSheet(int) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  Convenience method to set the active sheet.
setActiveSheet(int) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Convenience method to set the active sheet.
setActiveSheetIndex(int) - Method in class org.apache.poi.hssf.record.WindowOneRecord
setAddMenuCount(byte) - Method in class org.apache.poi.hssf.record.MMSRecord
  set number of add menu options (set to 0)
setAddress(String) - Method in interface org.apache.poi.common.usermodel.Hyperlink
  Hypelink address.
setAddress(String) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
  Hyperlink address.
setAddress(String) - Method in class org.apache.poi.hssf.usermodel.HSSFHyperlink
  Hypelink address.
setAdtlDiag(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set for diagonal borders? No idea (its a palette color for the other function we didn't know what was?)
setAdtlDiagLineStyle(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the diagonal border line style? Who the heck ever heard of a diagonal border?
setAdtlFillPattern(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the fill pattern
setAdtlPaletteOptions(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the additional palette options bitmask (see individual bitsetter methods that reference this method)
setAlignFormattingUnchanged() - Method in class org.apache.poi.hssf.record.CFRuleRecord
setAlignment(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the horizontal alignment of the cell.
setAlignment(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the type of horizontal alignment for the cell
setAlignment(HSSFCell, HSSFWorkbook, short) - Static method in class org.apache.poi.hssf.util.HSSFCellUtil
  Take a cell, and align it.
setAlignment(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the type of horizontal alignment for the cell
setAlignment(Cell, Workbook, short) - Static method in class org.apache.poi.ss.util.CellUtil
  Take a cell, and align it.
setAlignmentOptions(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the alignment options bitmask.
setAlternateExpression(boolean) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  whether alternate expression evaluation is on
setAlternateFormula(boolean) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  whether alternative formula entry is on
setAlternativeExpression(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  whether alternate expression evaluation is on
setAlternativeFormula(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  whether alternative formula entry is on
setAlwaysCalc(boolean) - Method in class org.apache.poi.hssf.record.FormulaRecord
setAlwaysCalc(boolean) - Method in class org.apache.poi.hssf.record.TableRecord
setAnchor(int, int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFChildAnchor
setAnchor(short, int, int, int, short, int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFClientAnchor
  Dets the top-left and bottom-right coordinates of the anchor.
setAnchor(HSSFAnchor) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
  Sets a particular anchor.
setAnchorId(short) - Method in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
  Set the anchor id field for the ObjectLink record.
setAnchorType(int) - Method in class org.apache.poi.hssf.usermodel.HSSFClientAnchor
  Sets the anchor type
setAnchorType(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Sets the anchor type
setApplicationName(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the application name.
setArabic(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  is this arabic?
setArrayData(byte[], int) - Method in class org.apache.poi.ddf.EscherArrayProperty
  We have this method because the way in which arrays in escher works is screwed for seemly arbitary reasons.
setArrayFormula(CellRangeAddress, Ptg[]) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
setArrayFormula(String, CellRangeAddress) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
setArrayFormula(String, CellRangeAddress) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets array formula to specified region for result.
setAsActiveCell() - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  Sets this cell as the active cell for the worksheet
setAsActiveCell() - Method in interface org.apache.poi.ss.usermodel.Cell
  Sets this cell as the active cell for the worksheet
setAttributes(short) - Method in class org.apache.poi.hssf.record.FontRecord
  set the font attributes (see individual bit setters that reference this method)
setAuthor(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the author.
setAuthor(String) - Method in class org.apache.poi.hssf.record.NoteRecord
  Name of the original comment author
setAuthor(String) - Method in class org.apache.poi.hssf.usermodel.HSSFComment
  Name of the original comment author
setAuthor(String) - Method in class org.apache.poi.hssf.usermodel.HSSFSimpleShape
setAuthor(String) - Method in interface org.apache.poi.ss.usermodel.Comment
  Name of the original comment author
setAuto(boolean) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
  Sets the auto field value.
setAutoBackground(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the auto background field value.
setAutobreaks(boolean) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  show automatic page breaks or not
setAutobreaks(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  show automatic page breaks or not
setAutobreaks(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Flag indicating whether the sheet displays Automatic Page Breaks.
setAutoColor(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the auto color field value.
setAutofill(boolean) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Sets the autofill field value.
setAutoFilter(CellRangeAddress) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
setAutoFilter(CellRangeAddress) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Enable filtering for a range of cells
setAutoGeneratedText(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the auto generated text field value.
setAutoLabelDeleted(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the auto label deleted field value.
setAutoline(boolean) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Sets the autoline field value.
setAutomatic(boolean) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
  Sets the automatic field value.
setAutomaticCategoryCrossing(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the automatic category crossing field value.
setAutomaticMajor(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the automatic major field value.
setAutomaticMaximum(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the automatic maximum field value.
setAutomaticMinimum(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the automatic minimum field value.
setAutomaticMinor(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the automatic minor field value.
setAutoPlotArea(boolean) - Method in class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
  Sets the auto plot area field value.
setAutoPosition(boolean) - Method in class org.apache.poi.hssf.record.chart.FrameRecord
  Sets the auto position field value.
setAutoPosition(boolean) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Sets the auto position field value.
setAutorotate(boolean) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Sets the autorotate field value.
setAutoSeries(boolean) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Sets the auto series field value.
setAutoSize(boolean) - Method in class org.apache.poi.hssf.record.chart.FrameRecord
  Sets the auto size field value.
setAutoTextBackground(boolean) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Sets the auto text background field value.
setAutoTextColor(boolean) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Sets the auto text color field value.
setAutoXPositioning(boolean) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Sets the auto x positioning field value.
setAutoYPositioning(boolean) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Sets the auto y positioning field value.
setAxisType(short) - Method in class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
  Set the axis type field for the AxisLineFormat record.
setAxisType(short) - Method in class org.apache.poi.hssf.record.chart.AxisParentRecord
  Set the axis type field for the AxisParent record.
setAxisType(short) - Method in class org.apache.poi.hssf.record.chart.AxisRecord
  Set the axis type field for the Axis record.
setBackcolorIndex(short) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
  Set the backcolor index field for the AreaFormat record.
setBackground(byte) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the background field for the Tick record.
setBackground(Color) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setBackground(Color) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics
setBackground(Color) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setBackgroundColor(int) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
  Set the background color field for the AreaFormat record.
setBackup(short) - Method in class org.apache.poi.hssf.record.BackupRecord
  set the backup flag (0,1)
setBackupFlag(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  determine whether the Excel GUI will backup the workbook when saving.
setBackuppos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
setBackwardDiagonalOn(boolean) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  Of/off top left to bottom right line
setBackwardDiagonalOn(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setBadFontHeight(boolean) - Method in class org.apache.poi.hssf.record.RowRecord
  set whether the font and row height are not compatible
setBarSpace(short) - Method in class org.apache.poi.hssf.record.chart.BarRecord
  Set the bar space field for the Bar record.
setBaseUnit(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the base unit field for the AxisOptions record.
setBAT(BlockAllocationTableReader) - Method in interface org.apache.poi.poifs.storage.BlockList
  set the associated BlockAllocationTable
setBATBlocks(int, int) - Method in class org.apache.poi.poifs.storage.HeaderBlockWriter
  Set BAT block parameters.
setBlipRecord(EscherBlipRecord) - Method in class org.apache.poi.ddf.EscherBSERecord
setBlipTypeMacOS(byte) - Method in class org.apache.poi.ddf.EscherBSERecord
  Set the expected MacOS blip type
setBlipTypeWin32(byte) - Method in class org.apache.poi.ddf.EscherBSERecord
  Set the expected win32 blip type
setBold(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
  set the font weight to bold (weight=700) or to normal(weight=400) boldness.
setBoldWeight(short) - Method in class org.apache.poi.hssf.record.FontRecord
  set the bold weight for this font (100-1000dec or 0x64-0x3e8).
setBoldweight(short) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set the boldness to use
setBoldweight(short) - Method in interface org.apache.poi.ss.usermodel.Font
setBoolean(int, boolean) - Method in class org.apache.poi.util.BitField
  Set a boolean BitField
setBorder(boolean) - Method in class org.apache.poi.hssf.record.chart.DatRecord
  Sets the border field value.
setBorderBottom(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the type of border to use for the bottom border of the cell
setBorderBottom(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the border line style for the bottom border
setBorderBottom(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setBorderBottom(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the type of border to use for the bottom border of the cell
setBorderBottom(short, Region, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
setBorderBottom(int, CellRangeAddress, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Sets the borderBottom attribute of the HSSFRegionUtil object
setBorderBottom(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the type of border to use for the bottom border of the cell
setBorderBottom(int, CellRangeAddress, Sheet, Workbook) - Static method in class org.apache.poi.ss.util.RegionUtil
  Sets the borderBottom attribute of the RegionUtil object
setBorderDiagonal(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the type of border to use for the diagonal border of the cell
setBorderDiagonal(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setBorderFormatting(BorderFormatting) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setBorderLeft(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the type of border to use for the left border of the cell
setBorderLeft(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the borderline style for the left border
setBorderLeft(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setBorderLeft(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the type of border to use for the left border of the cell
setBorderLeft(short, Region, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
setBorderLeft(int, CellRangeAddress, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
setBorderLeft(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the type of border to use for the left border of the cell
setBorderLeft(int, CellRangeAddress, Sheet, Workbook) - Static method in class org.apache.poi.ss.util.RegionUtil
  Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
setBorderOptions(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the border options bitmask (see the corresponding bitsetter methods that reference back to this one)
setBorderRight(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the type of border to use for the right border of the cell
setBorderRight(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the border line style for the right border
setBorderRight(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setBorderRight(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the type of border to use for the right border of the cell
setBorderRight(short, Region, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
setBorderRight(int, CellRangeAddress, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Sets the borderRight attribute of the HSSFRegionUtil object
setBorderRight(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the type of border to use for the right border of the cell
setBorderRight(int, CellRangeAddress, Sheet, Workbook) - Static method in class org.apache.poi.ss.util.RegionUtil
  Sets the borderRight attribute of the RegionUtil object
setBorderTop(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the type of border to use for the top border of the cell
setBorderTop(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the border line style for the top border
setBorderTop(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setBorderTop(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the type of border to use for the top border of the cell
setBorderTop(short, Region, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
setBorderTop(int, CellRangeAddress, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Sets the borderBottom attribute of the HSSFRegionUtil object
setBorderTop(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the type of border to use for the top border of the cell
setBorderTop(int, CellRangeAddress, Sheet, Workbook) - Static method in class org.apache.poi.ss.util.RegionUtil
  Sets the borderBottom attribute of the RegionUtil object
setBorderType(short) - Method in class org.apache.poi.hssf.record.chart.FrameRecord
  Set the border type field for the Frame record.
setBottomBorderColor(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the color to use for the bottom border
setBottomBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setBottomBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the color to use for the bottom border
setBottomBorderColor(short, Region, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
setBottomBorderColor(int, CellRangeAddress, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Sets the bottomBorderColor attribute of the HSSFRegionUtil object
setBottomBorderColor(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the color to use for the bottom border
setBottomBorderColor(int, CellRangeAddress, Sheet, Workbook) - Static method in class org.apache.poi.ss.util.RegionUtil
  Sets the bottomBorderColor attribute of the RegionUtil object
setBottomBorderModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setBottomBorderPaletteIdx(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the palette index for the bottom border
setBottomLeftTopRightBorderModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setBoundaryHeight(int) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the boundary height of the metafile drawing commands
setBoundaryLeft(int) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the left boundary of the metafile drawing commands
setBoundaryTop(int) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the top boundary of the metafile drawing commands
setBoundaryWidth(int) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the boundary width of the metafile drawing commands
setBounds(Rectangle) - Method in class org.apache.poi.ddf.EscherMetafileBlip
setBounds(Rectangle) - Method in class org.apache.poi.ddf.EscherPictBlip
setBspos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
setBubbleSeriesType(short) - Method in class org.apache.poi.hssf.record.chart.SeriesRecord
  Set the bubble series type field for the Series record.
setBucketOffsets(int[], int[]) - Method in class org.apache.poi.hssf.record.ExtSSTRecord
setBuild(int) - Method in class org.apache.poi.hssf.record.BOFRecord
  build that wrote this file
setBuildYear(int) - Method in class org.apache.poi.hssf.record.BOFRecord
  Year of the build that wrote this file
setBuiltinStyle(int) - Method in class org.apache.poi.hssf.record.StyleRecord
  if this is a builtin style set the number of the built in style
setByte(byte) - Method in class org.apache.poi.util.BitField
  Set the bits.
setByteBoolean(byte, boolean) - Method in class org.apache.poi.util.BitField
  Set a boolean BitField
setByteCount(int) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the byte count.
setByteOrder(int) - Method in class org.apache.poi.hpsf.MutablePropertySet
  Sets the "byteOrder" property.
setByteOrder(int) - Method in class org.apache.poi.hpsf.SpecialPropertySet
setBytes(byte[]) - Method in class org.apache.poi.hpsf.ClassID
  Sets the bytes making out the class ID.
setCachedBooleanResult(boolean) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
setCachedDoubleResult(double) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
setCachedErrorResult(int) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
setCachedResultBoolean(boolean) - Method in class org.apache.poi.hssf.record.FormulaRecord
setCachedResultErrorCode(int) - Method in class org.apache.poi.hssf.record.FormulaRecord
setCachedResultTypeEmptyString() - Method in class org.apache.poi.hssf.record.FormulaRecord
setCachedResultTypeString() - Method in class org.apache.poi.hssf.record.FormulaRecord
setCachedStringResult(String) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
setCacheOfSavedSize(int) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the cache of the saved size
setCacheOfSize(int) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the cache of the metafile size
setCalcMode(short) - Method in class org.apache.poi.hssf.record.CalcModeRecord
  set the calc mode flag for formulas
setCalcOnLoad(boolean) - Method in class org.apache.poi.hssf.record.FormulaRecord
setCalendar(Calendar, int, int, boolean) - Static method in class org.apache.poi.ss.usermodel.DateUtil
setCategory(String) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the category.
setCategoryAxisCross(double) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Set the category axis cross field for the ValueRange record.
setCategoryDataType(short) - Method in class org.apache.poi.hssf.record.chart.DefaultDataLabelTextPropertiesRecord
  Set the category data type field for the DefaultDataLabelTextProperties record.
setCategoryDataType(short) - Method in class org.apache.poi.hssf.record.chart.SeriesRecord
  Set the category data type field for the Series record.
setCategorySpace(short) - Method in class org.apache.poi.hssf.record.chart.BarRecord
  Set the category space field for the Bar record.
setCbFeatData(long) - Method in class org.apache.poi.hssf.record.FeatRecord
setCellComment(Comment) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  Assign a comment to this cell.
setCellComment(Comment) - Method in interface org.apache.poi.ss.usermodel.Cell
  Assign a comment to this cell
setCellErrorValue(byte) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  set a error value for the cell
setCellErrorValue(byte) - Method in interface org.apache.poi.ss.usermodel.Cell
  Set a error value for the cell
setCellFormula(String) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
setCellFormula(String) - Method in interface org.apache.poi.ss.usermodel.Cell
  Sets formula for this cell.
setCellNum(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  Deprecated. (Jan 2008) Doesn't update the row's idea of what cell this is, use `HSSFRow.moveCell(HSSFCell, short)` instead
setCellOptions(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  sets the options bitmask - you can also use corresponding option bit setters (see other methods that reference this one)
setCellRanges(CellRangeAddress[]) - Method in class org.apache.poi.hssf.record.CFHeaderRecord
  Set cell ranges list to a single cell range and modify the enclosing cell range accordingly.
setCellRefs(CellRangeAddress[]) - Method in class org.apache.poi.hssf.record.FeatRecord
setCellStyle(CellStyle) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  set the style for the cell.
setCellStyle(HSSFCellStyle) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
setCellStyle(CellStyle) - Method in interface org.apache.poi.ss.usermodel.Cell
  Set the style for the cell.
setCellStyleProperty(HSSFCell, HSSFWorkbook, String, Object) - Static method in class org.apache.poi.hssf.util.HSSFCellUtil
  This method attempt to find an already existing HSSFCellStyle that matches what you want the style to be.
setCellStyleProperty(Cell, Workbook, String, Object) - Static method in class org.apache.poi.ss.util.CellUtil
  This method attempt to find an already existing CellStyle that matches what you want the style to be.
setCellType(int) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  set the cells type (numeric, formula or string)
setCellType(int) - Method in interface org.apache.poi.ss.usermodel.Cell
  Set the cells type (numeric, formula or string)
setCellValue(double) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  set a numeric value for the cell
setCellValue(Date) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  set a date value for the cell.
setCellValue(Calendar) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  set a date value for the cell.
setCellValue(String) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  set a string value for the cell.
setCellValue(RichTextString) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  Set a string value for the cell.
setCellValue(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  set a boolean value for the cell
setCellValue(double) - Method in interface org.apache.poi.ss.usermodel.Cell
  Set a numeric value for the cell
setCellValue(Date) - Method in interface org.apache.poi.ss.usermodel.Cell
  Converts the supplied date to its equivalent Excel numeric value and sets that into the cell.
setCellValue(Calendar) - Method in interface org.apache.poi.ss.usermodel.Cell
  Set a date value for the cell.
setCellValue(RichTextString) - Method in interface org.apache.poi.ss.usermodel.Cell
  Set a rich string value for the cell.
setCellValue(String) - Method in interface org.apache.poi.ss.usermodel.Cell
  Set a string value for the cell.
setCellValue(boolean) - Method in interface org.apache.poi.ss.usermodel.Cell
  Set a boolean value for the cell
setCenter(String) - Method in class org.apache.poi.hssf.usermodel.HeaderFooter
setCenter(String) - Method in interface org.apache.poi.ss.usermodel.Footer
  Sets the center string.
setCenter(String) - Method in interface org.apache.poi.ss.usermodel.Header
  Sets the center string.
setCenter(String) - Method in interface org.apache.poi.ss.usermodel.HeaderFooter
  Sets the center string.
setCharCount(int) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the character count.
setCharCount(short) - Method in class org.apache.poi.hssf.record.common.UnicodeString
  set the number of characters in the string
setCharset(byte) - Method in class org.apache.poi.hssf.record.FontRecord
  set the character set
setCharSet(int) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set character-set to use.
setCharSet(byte) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set character-set to use.
setCharSet(byte) - Method in interface org.apache.poi.ss.usermodel.Font
  set character-set to use.
setCharSet(int) - Method in interface org.apache.poi.ss.usermodel.Font
  set character-set to use.
setChartGroupIndex(short) - Method in class org.apache.poi.hssf.record.chart.SeriesChartGroupIndexRecord
  Set the chart group index field for the SeriesChartGroupIndex record.
setChartGroupIndex(short) - Method in class org.apache.poi.hssf.record.chart.SeriesToChartGroupRecord
  Set the chart group index field for the SeriesToChartGroup record.
setChartTypeManuallyFormatted(boolean) - Method in class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
  Sets the chart type manually formatted field value.
setCheckCalculationErrors(boolean) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
setCheckDateTimeFormats(boolean) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
setCheckEmptyCellRef(boolean) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
setCheckInconsistentFormulas(boolean) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
setCheckInconsistentRanges(boolean) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
setCheckNumbersAsText(boolean) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
setCheckUnprotectedFormulas(boolean) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
setChildRecords(List) - Method in class org.apache.poi.ddf.EscherContainerRecord
  replaces the internal child list with the contents of the supplied `childRecords`
setChildRecords(List) - Method in class org.apache.poi.ddf.EscherRecord
  Sets the child records for this record.
setChildRecords(List) - Method in class org.apache.poi.ddf.UnknownEscherRecord
setClass(byte) - Method in class org.apache.poi.hssf.record.formula.Ptg
setClassID(ClassID) - Method in class org.apache.poi.hpsf.MutablePropertySet
  Sets the property set stream's low-level "class ID" field.
setClassID(ClassID) - Method in class org.apache.poi.hpsf.SpecialPropertySet
setClip(Shape) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setClip(int, int, int, int) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setClip(int, int, int, int) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics
setClip(Shape) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics
setClip(int, int, int, int) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setClip(Shape) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setCodepage(int) - Method in class org.apache.poi.hpsf.CustomProperties
  Sets the codepage.
setCodepage(int) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the codepage.
setCodepage(short) - Method in class org.apache.poi.hssf.record.CodepageRecord
  set the codepage for this workbook
setCol1(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  The column number for the top-left position.
setCol1(short) - Method in class org.apache.poi.hssf.usermodel.HSSFClientAnchor
setCol1(int) - Method in class org.apache.poi.hssf.usermodel.HSSFClientAnchor
setCol1(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Sets the column (0 based) of the first cell.
setCol2(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  The column of the bottom right corner of this shape.
setCol2(short) - Method in class org.apache.poi.hssf.usermodel.HSSFClientAnchor
setCol2(int) - Method in class org.apache.poi.hssf.usermodel.HSSFClientAnchor
setCol2(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Returns the column (0 based) of the second cell.
setColapsed(boolean) - Method in class org.apache.poi.hssf.record.RowRecord
  set whether or not to collapse this row
setColDeleted(boolean) - Method in class org.apache.poi.hssf.record.TableRecord
setColInputCol(int) - Method in class org.apache.poi.hssf.record.TableRecord
setColInputRow(int) - Method in class org.apache.poi.hssf.record.TableRecord
setCollapsed(boolean) - Method in class org.apache.poi.hssf.record.ColumnInfoRecord
  set whether the cells are collapsed
setColLevelMax(short) - Method in class org.apache.poi.hssf.record.GutsRecord
  set the maximum outline level for the col gutter.
setColor(Color) - Method in interface org.apache.poi.common.usermodel.Fill
setColor(short, byte, byte, byte) - Method in class org.apache.poi.hssf.record.PaletteRecord
  Sets the color value at a given index If the given index is greater than the current last color index, then black is inserted at every index required to make the palette continuous.
setColor(Color) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setColor(Color) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics
setColor(Color) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set the color for the font
setColor(short) - Method in interface org.apache.poi.ss.usermodel.Font
  set the color for the font
setColor1(int) - Method in class org.apache.poi.ddf.EscherSplitMenuColorsRecord
setColor2(int) - Method in class org.apache.poi.ddf.EscherSplitMenuColorsRecord
setColor3(int) - Method in class org.apache.poi.ddf.EscherSplitMenuColorsRecord
setColor4(int) - Method in class org.apache.poi.ddf.EscherSplitMenuColorsRecord
setColorAtIndex(short, byte, byte, byte) - Method in class org.apache.poi.hssf.usermodel.HSSFPalette
  Sets the color at the given offset
setColorPaletteIndex(short) - Method in class org.apache.poi.hssf.record.FontRecord
  set the font's color palette index
setColourPaletteIndex(short) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
  Set the colour palette index field for the LineFormat record.
setColRelative(boolean) - Method in class org.apache.poi.hssf.record.formula.RefPtgBase
setColumn(int, Short, Integer, Integer, Boolean, Boolean) - Method in class org.apache.poi.hssf.record.aggregates.ColumnInfoRecordsAggregate
setColumn(short) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
setColumn(short) - Method in class org.apache.poi.hssf.record.BlankRecord
  set the column this cell defines within the row
setColumn(short) - Method in class org.apache.poi.hssf.record.CellRecord
setColumn(short) - Method in interface org.apache.poi.hssf.record.CellValueRecordInterface
setColumn(int) - Method in class org.apache.poi.hssf.record.formula.RefPtgBase
setColumn(short) - Method in class org.apache.poi.hssf.record.LabelRecord
  NO-OP!
setColumn(int) - Method in class org.apache.poi.hssf.record.NoteRecord
  Specify the column that contains the comment
setColumn(int) - Method in class org.apache.poi.hssf.usermodel.HSSFComment
  Set the column of the cell that contains the comment
setColumn(short) - Method in class org.apache.poi.hssf.usermodel.HSSFComment
  Deprecated. (Nov 2009) use `HSSFComment.setColumn(int)` }
setColumn(int) - Method in class org.apache.poi.hssf.usermodel.HSSFSimpleShape
setColumn(int) - Method in interface org.apache.poi.ss.usermodel.Comment
  Set the column of the cell that contains the comment
setColumnBreak(short, short, short) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
  Sets a page break at the indicated column
setColumnBreak(int) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets a page break at the indicated column
setColumnBreak(int) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets a page break at the indicated column
setColumnFrom(short) - Method in class org.apache.poi.ss.util.Region
  Deprecated. set the upper left hand corner column number
setColumnGroupCollapsed(int, boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
setColumnGroupCollapsed(short, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Deprecated. (Sep 2008) use `HSSFSheet.setColumnGroupCollapsed(int, boolean)`
setColumnGroupCollapsed(int, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Expands or collapses a column group.
setColumnGroupCollapsed(int, boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Expands or collapses a column group.
setColumnHidden(int, boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
  Get the hidden property for a given column.
setColumnHidden(short, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Deprecated. (Sep 2008) use `HSSFSheet.setColumnHidden(int, boolean)`
setColumnHidden(int, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Get the visibility state for a given column.
setColumnHidden(int, boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Get the visibility state for a given column
setColumnTo(short) - Method in class org.apache.poi.ss.util.Region
  Deprecated. set the lower right hand corner column number
setColumnWidth(int, int) - Method in class org.apache.poi.hssf.model.InternalSheet
  set the width for a given column in 1/256th of a character width units
setColumnWidth(int) - Method in class org.apache.poi.hssf.record.ColumnInfoRecord
  set the columns' width in 1/256 of a character width
setColumnWidth(short, short) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Deprecated. (Sep 2008) use `HSSFSheet.setColumnWidth(int, int)`
setColumnWidth(int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Set the width (in units of 1/256th of a character width)
setColumnWidth(int, int) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Set the width (in units of 1/256th of a character width)
setColWidth(int) - Method in class org.apache.poi.hssf.record.DefaultColWidthRecord
  set the default column width
setComment(String) - Method in class org.apache.poi.hssf.usermodel.HSSFName
  Sets the comment the user provided when the name was created.
setComment(String) - Method in interface org.apache.poi.ss.usermodel.Name
  Sets the comment the user provided when the name was created.
setComments(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the comments.
setCommentText(String) - Method in class org.apache.poi.hssf.record.NameCommentRecord
setCompany(String) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the company.
setComparisonOperation(byte) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setComposite(Composite) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setComposite(Composite) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setCompressed(boolean) - Method in class org.apache.poi.ddf.EscherMetafileBlip
setCompressed(boolean) - Method in class org.apache.poi.ddf.EscherPictBlip
setCompressedSize(int) - Method in class org.apache.poi.ddf.EscherMetafileBlip
setCompressedSize(int) - Method in class org.apache.poi.ddf.EscherPictBlip
setCompressionFlag(byte) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set whether the contents of the blip is compressed
setCoordinates(int, int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFPatriarch
  Sets the coordinate space of this group.
setCoordinates(int, int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFShapeGroup
  Sets the coordinate space of this group.
setCopies(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setCopies(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Sets the number of copies.
setCopies(short) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Sets the number of copies.
setCount(short) - Method in class org.apache.poi.hssf.record.FnGroupCountRecord
  set the number of built-in functions
setCreateDateTime(Date) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the creation time.
setCrossCategoryAxisAtMaximum(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the cross category axis at maximum field value.
setCrossesFarRight(boolean) - Method in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
  Sets the crosses far right field value.
setCrossingPoint(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the crossing point field for the AxisOptions record.
setCrossingPoint(short) - Method in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
  Set the crossing point field for the CategorySeriesAxis record.
setCurrentCountry(short) - Method in class org.apache.poi.hssf.record.CountryRecord
  sets the current country
setCurrentRow(HSSFRow) - Method in class org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  Deprecated. (Aug 2008) - not needed, since the current row can be derived from the cell
setCurrentUserPassword(String) - Static method in class org.apache.poi.hssf.record.crypto.Biff8EncryptionKey
  Sets the BIFF8 encryption/decryption password for the current thread.
setCustomMenuText(String) - Method in class org.apache.poi.hssf.record.NameRecord
  sets the custom menu text
setCustomNumberFormat(boolean) - Method in class org.apache.poi.hssf.record.chart.LinkedDataRecord
  Sets the custom number format field value.
setCustomProperties(CustomProperties) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the custom properties.
setData(byte[]) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  The BLIP data
setData(byte[], int, int) - Method in class org.apache.poi.ddf.EscherTextboxRecord
  Sets the extra data (in the parent application's format) to be contained by the record.
setData(byte[]) - Method in class org.apache.poi.ddf.EscherTextboxRecord
setData(byte[]) - Method in class org.apache.poi.hssf.record.DrawingRecord
setDataFormat(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the data format (must be a valid format)
setDataFormat(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the data format (must be a valid format)
setDataLabelPlacement(short) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the data label placement field value.
setDataTable(boolean) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Sets the data table field value.
setDateToBeFormatted(double) - Method in class org.apache.poi.ss.usermodel.ExcelStyleDateFormatter
  Used to let us know what the date being formatted is, in Excel terms, which we may wish to use when handling elapsed times.
setDbcell(int, int) - Method in class org.apache.poi.hssf.record.IndexRecord
setDefaultBase(boolean) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Sets the default base field value.
setDefaultColumnStyle(int, int) - Method in class org.apache.poi.hssf.model.InternalSheet
setDefaultColumnStyle(int, CellStyle) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets the default column style for a given column.
setDefaultColumnStyle(int, CellStyle) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets the default column style for a given column.
setDefaultColumnWidth(int) - Method in class org.apache.poi.hssf.model.InternalSheet
  set the default column width for the sheet (if the columns do not define their own width)
setDefaultColumnWidth(short) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Deprecated. (Sep 2008) use `HSSFSheet.setDefaultColumnWidth(int)`
setDefaultColumnWidth(int) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  set the default column width for the sheet (if the columns do not define their own width) in characters
setDefaultColumnWidth(int) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Set the default column width for the sheet (if the columns do not define their own width) in characters
setDefaultCountry(short) - Method in class org.apache.poi.hssf.record.CountryRecord
  sets the default country
setDefaultCross(boolean) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Sets the default cross field value.
setDefaultDateSettings(boolean) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Sets the default date settings field value.
setDefaultHeader(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set whether the window should display a default header
setDefaultMajor(boolean) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Sets the default major field value.
setDefaultMaximum(boolean) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Sets the default maximum field value.
setDefaultMinimum(boolean) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Sets the default minimum field value.
setDefaultMinorUnit(boolean) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Sets the default minor unit field value.
setDefaultNumberFormat(Format) - Method in class org.apache.poi.ss.usermodel.DataFormatter
  Sets a default number format to be used when the Excel format cannot be parsed successfully.
setDefaultPlotDimensions(boolean) - Method in class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
  Sets the default plot dimensions field value.
setDefaultRowHeight(short) - Method in class org.apache.poi.hssf.model.InternalSheet
  set the default row height for the sheet (if the rows do not define their own height)
setDefaultRowHeight(short) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  set the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)
setDefaultRowHeight(short) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Set the default row height for the sheet (if the rows do not define their own height) in twips (1/20 of a point)
setDefaultRowHeightInPoints(float) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  set the default row height for the sheet (if the rows do not define their own height) in points
setDefaultRowHeightInPoints(float) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Set the default row height for the sheet (if the rows do not define their own height) in points
setDelMenuCount(byte) - Method in class org.apache.poi.hssf.record.MMSRecord
  set number of del menu options (set to 0)
setDenominator(short) - Method in class org.apache.poi.hssf.record.SCLRecord
  Set the denominator field for the SCL record.
setDescriptionText(String) - Method in class org.apache.poi.hssf.record.NameRecord
  sets the description text
setDiag(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  Not sure what this is for (maybe fill lines?) 1 = down, 2 = up, 3 = both, 0 for none..
setDiagonalBorderColor(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the color to use for the diagonal borders
setDiagonalBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setDialog(boolean) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  set whether sheet is a dialog sheet or not
setDialog(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  set whether sheet is a dialog sheet or not
setDictionary(Map) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the section's dictionary.
setDimensions(int, short, int, short) - Method in class org.apache.poi.hssf.model.InternalSheet
  Per an earlier reported bug in working with Andy Khan's excel read library.
setDisplayAsPercentage(boolean) - Method in class org.apache.poi.hssf.record.chart.AreaRecord
  Sets the display as percentage field value.
setDisplayAsPercentage(boolean) - Method in class org.apache.poi.hssf.record.chart.BarRecord
  Sets the display as percentage field value.
setDisplayedTab(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  Deprecated. - Misleading name - use setFirstVisibleTab()
setDisplayedTab(short) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  Deprecated. - Misleading name - use setFirstVisibleTab()
setDisplayFormulas(boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets whether the formulas are shown in a viewer.
setDisplayFormulas(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set whether the window should display formulas
setDisplayFormulas(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets whether the formulas are shown in a viewer.
setDisplayFormulas(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets whether the formulas are shown in a viewer
setDisplayGridlines(boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets whether the gridlines are shown in a viewer.
setDisplayGridlines(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set whether the window should display gridlines
setDisplayGridlines(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets whether the gridlines are shown in a viewer.
setDisplayGridlines(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets whether the gridlines are shown in a viewer
setDisplayGuts(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set whether the outline symbols are displaed
setDisplayGuts(boolean) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  set whether to display the guts or not
setDisplayGuts(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  set whether to display the guts or not
setDisplayGuts(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Set whether to display the guts or not
setDisplayHorizonalScrollbar(boolean) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set whether to display the horizontal scrollbar or not
setDisplayMode(short) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the display mode field for the Text record.
setDisplayRowColHeadings(boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets whether the RowColHeadings are shown in a viewer.
setDisplayRowColHeadings(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set whether the window should display row and column headings
setDisplayRowColHeadings(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets whether the RowColHeadings are shown in a viewer.
setDisplayRowColHeadings(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets whether the RowColHeadings are shown in a viewer
setDisplayTabs(boolean) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set whether to display the tabs or not
setDisplayVerticalScrollbar(boolean) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set whether to display the vertical scrollbar or not
setDisplayZeros(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set whether the window should display zero values
setDisplayZeros(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Set whether the window should show 0 (zero) in cells containing zero value.
setDisplayZeros(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Set whether the window should show 0 (zero) in cells containing zero value.
setDocId(byte[]) - Method in class org.apache.poi.hssf.record.FilePassRecord
setDocparts(byte[]) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the doc parts.
setDocument(POIFSDocument) - Method in class org.apache.poi.poifs.property.DocumentProperty
  set the POIFSDocument
setDoNotSizeWithWindow(boolean) - Method in class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
  Sets the do not size with window field value.
setDraft(boolean) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setDraft(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set whether it is in draft mode
setDraft(boolean) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set whether it is in draft mode
setDrawingsSaved(int) - Method in class org.apache.poi.ddf.EscherDggRecord
setDrawTicks(boolean) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
  Sets the draw ticks field value.
setDVRecNo(int) - Method in class org.apache.poi.hssf.record.DVALRecord
  Set the number of following DV records
setDx1(int) - Method in class org.apache.poi.ddf.EscherChildAnchorRecord
  Sets offset within the parent coordinate space for the top left point.
setDx1(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  The x offset within the top-left cell.
setDx1(int) - Method in class org.apache.poi.hssf.usermodel.HSSFAnchor
setDx1(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Sets the x coordinate within the first cell
setDx2(int) - Method in class org.apache.poi.ddf.EscherChildAnchorRecord
  Sets offset within the parent coordinate space for the bottom right point.
setDx2(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  The x offset withing the cell for the bottom-right corner of this shape.
setDx2(int) - Method in class org.apache.poi.hssf.usermodel.HSSFAnchor
setDx2(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Sets the x coordinate within the second cell
setDy1(int) - Method in class org.apache.poi.ddf.EscherChildAnchorRecord
  Sets offset within the parent coordinate space for the top left point.
setDy1(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  The y offset within the top-left corner of the current shape.
setDy1(int) - Method in class org.apache.poi.hssf.usermodel.HSSFAnchor
setDy1(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Sets the y coordinate within the first cell
setDy2(int) - Method in class org.apache.poi.ddf.EscherChildAnchorRecord
  Sets the offset within the parent coordinate space for the bottom right point.
setDy2(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  The y offset withing the cell for the bottom-right corner of this shape.
setDy2(int) - Method in class org.apache.poi.hssf.usermodel.HSSFAnchor
setDy2(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Sets the y coordinate within the second cell
setEditTime(long) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the total time spent in editing the document.
setElement(int, byte[]) - Method in class org.apache.poi.ddf.EscherArrayProperty
setEmpty(byte) - Method in class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
  Set the empty field for the SheetProperties record.
setEmpty() - Method in class org.apache.poi.hssf.record.RowRecord
  Updates the firstCol and lastCol fields to the reserved value (-1) to signify that this row is empty
setEmptyCellAllowed(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFDataValidation
setEmptyCellAllowed(boolean) - Method in interface org.apache.poi.ss.usermodel.DataValidation
  Sets if this object allows empty as a valid value
setEnclosingCellRange(CellRangeAddress) - Method in class org.apache.poi.hssf.record.CFHeaderRecord
setErrorStyle(int) - Method in class org.apache.poi.hssf.usermodel.HSSFDataValidation
setErrorStyle(int) - Method in interface org.apache.poi.ss.usermodel.DataValidation
  Sets the error style for error box
setEscapementType(short) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
  set the escapement type for the font
setEscapementType(short) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
  set the escapement type for the font
setEscapementTypeModified(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setEscapementTypeModified(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setExcelStyleRoundingMode(DecimalFormat) - Static method in class org.apache.poi.ss.usermodel.DataFormatter
  Enables excel style rounding mode (round half up) on the Decimal Format if possible.
setExplicitListValues(String[]) - Method in class org.apache.poi.hssf.usermodel.DVConstraint
setExplicitListValues(String[]) - Method in interface org.apache.poi.ss.usermodel.DataValidationConstraint
setExternSheetIndex(int) - Method in class org.apache.poi.hssf.record.formula.Area3DPtg
setExternSheetIndex(int) - Method in class org.apache.poi.hssf.record.formula.Ref3DPtg
setExternsheetPos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
  Sets the externsheetPos.
setFamily(byte) - Method in class org.apache.poi.hssf.record.FontRecord
  set the font family (TODO)
setFile(String) - Method in class org.apache.poi.hssf.dev.EFBiffViewer
setFile(String) - Method in class org.apache.poi.hssf.dev.FormulaViewer
  Method setFile
setFile(String) - Method in class org.apache.poi.hssf.dev.RecordLister
setFileIdClusters(EscherDggRecord.FileIdCluster[]) - Method in class org.apache.poi.ddf.EscherDggRecord
setFillBackground(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the background palette color index
setFillBackgroundColor(int) - Method in class org.apache.poi.hssf.record.cf.PatternFormatting
  set the background fill color.
setFillBackgroundColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the background fill color.
setFillBackgroundColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPatternFormatting
setFillBackgroundColor(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the background fill color.
setFillColor(int) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
  The color used to fill this shape.
setFillColor(int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
  The color used to fill this shape.
setFillForeground(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the foreground palette color index
setFillForegroundColor(int) - Method in class org.apache.poi.hssf.record.cf.PatternFormatting
  set the foreground fill color
setFillForegroundColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the foreground fill color Note: Ensure Foreground color is set prior to background color.
setFillForegroundColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPatternFormatting
setFillForegroundColor(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the foreground fill color Note: Ensure Foreground color is set prior to background color.
setFillPaletteOptions(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the fill palette options bitmask (see
setFillPattern(int) - Method in class org.apache.poi.hssf.record.cf.PatternFormatting
  setting fill pattern
setFillPattern(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  setting to one fills the cell with the foreground color...
setFillPattern(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPatternFormatting
setFillPattern(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  setting to one fills the cell with the foreground color...
setFilter(byte) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Filter should always be 0
setFirstCol(short) - Method in class org.apache.poi.hssf.record.DimensionsRecord
  set the first column number for the sheet
setFirstCol(int) - Method in class org.apache.poi.hssf.record.RowRecord
  set the logical col number for the first cell this row (0 based index)
setFirstColRelative(boolean) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  set whether the first column is relative
setFirstColumn(int) - Method in class org.apache.poi.hssf.record.ColumnInfoRecord
  set the first column this record defines formatting info for
setFirstColumn(int) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  set the first column in the area
setFirstColumn(int) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
  Set the first column (zero-based)of the range that contains this hyperlink
setFirstColumn(int) - Method in class org.apache.poi.hssf.usermodel.HSSFHyperlink
  Set the column of the first cell that contains the hyperlink
setFirstColumn(int) - Method in interface org.apache.poi.ss.usermodel.Hyperlink
  Set the column of the first cell that contains the hyperlink
setFirstColumn(int) - Method in class org.apache.poi.ss.util.CellRangeAddressBase
setFirstColumnRaw(int) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  set the first column irrespective of the bitmasks
setFirstRow(int) - Method in class org.apache.poi.hssf.record.DimensionsRecord
  set the first row number for the sheet
setFirstRow(int) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  sets the first row
setFirstRow(int) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
  Set the first row (zero-based)of the range that contains this hyperlink
setFirstRow(int) - Method in class org.apache.poi.hssf.record.IndexRecord
setFirstRow(int) - Method in class org.apache.poi.hssf.usermodel.HSSFHyperlink
  Set the row of the first cell that contains the hyperlink
setFirstRow(int) - Method in interface org.apache.poi.ss.usermodel.Hyperlink
  Set the row of the first cell that contains the hyperlink
setFirstRow(int) - Method in class org.apache.poi.ss.util.CellRangeAddressBase
setFirstRowRelative(boolean) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  sets the first row to relative or not
setFirstVisibleTab(int) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  Sets the first visible sheet in the worksheet tab-bar.
setFirstVisibleTab(int) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  sets the first tab that is displayed in the list of tabs in excel.
setFirstVisibleTab(int) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Sets the first tab that is displayed in the list of tabs in excel.
setFitHeight(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setFitHeight(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set the number of pages high to fit the sheet in
setFitHeight(short) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set the number of pages high to fit the sheet in
setFitToPage(boolean) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  fit to page option is on
setFitToPage(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  fit to page option is on
setFitToPage(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Flag indicating whether the Fit to Page print option is enabled.
setFitWidth(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setFitWidth(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set the number of pages wide to fit the sheet in
setFitWidth(short) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set the number of pages wide to fit the sheet in
setFlag(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  0 = Move and size with Cells, 2 = Move but don't size with cells, 3 = Don't move or size with cells.
setFlags(int) - Method in class org.apache.poi.ddf.EscherSpRecord
  The flags that apply to this shape.
setFlags(short) - Method in class org.apache.poi.hssf.record.NoteRecord
  Options flag
setFlags(int) - Method in class org.apache.poi.hssf.record.TableRecord
setFont(Font) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setFont(Font) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics
setFont(Font) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setFont(Font) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the font for this style
setFont(HSSFFont) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
setFont(HSSFCell, HSSFWorkbook, HSSFFont) - Static method in class org.apache.poi.hssf.util.HSSFCellUtil
  Take a cell, and apply a font to it
setFont(Font) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the font for this style
setFont(Cell, Workbook, Font) - Static method in class org.apache.poi.ss.util.CellUtil
  Take a cell, and apply a font to it
setFontCancellationModified(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setFontCancellationModified(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setFontColorIndex(short) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setFontColorIndex(short) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setFontFormatting(FontFormatting) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setFontHeight(int) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
  sets the height of the font in 1/20th point units
setFontHeight(short) - Method in class org.apache.poi.hssf.record.FontRecord
  sets the height of the font in 1/20th point units
setFontHeight(short) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set the font height in unit's of 1/20th of a point.
setFontHeight(int) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setFontHeight(short) - Method in interface org.apache.poi.ss.usermodel.Font
  set the font height in unit's of 1/20th of a point.
setFontHeightInPoints(short) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set the font height
setFontHeightInPoints(short) - Method in interface org.apache.poi.ss.usermodel.Font
  set the font height
setFontIndex(short) - Method in class org.apache.poi.hssf.record.chart.FontIndexRecord
  Set the font index field for the FontIndex record.
setFontIndex(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the index to the FONT record (which font to use 0 based)
setFontName(String) - Method in class org.apache.poi.hssf.record.FontRecord
  set the name of the font
setFontName(String) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set the name for the font (i.e.
setFontName(String) - Method in interface org.apache.poi.ss.usermodel.Font
  set the name for the font (i.e.
setFontOutlineModified(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setFontOutlineModified(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setFontpos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
setFontShadowModified(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setFontShadowModified(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setFontStyle(boolean, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
  set font style options.
setFontStyleModified(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setFontStyleModified(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setFontWieghtModified(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setFooter(FooterRecord) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
  Sets the FooterRecord.
setFooterMargin(double) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setFooterMargin(double) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Sets the footer margin.
setFooterMargin(double) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Sets the footer margin.
setForceFormulaRecalculation(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Whether a record must be inserted or not at generation to indicate that formula must be recalculated when workbook is opened.
setForecolorIndex(short) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
  Set the forecolor index field for the AreaFormat record.
setForegroundColor(int) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
  Set the foreground color field for the AreaFormat record.
setFormat(int) - Method in class org.apache.poi.hpsf.MutablePropertySet
  Sets the "format" property.
setFormat(int) - Method in class org.apache.poi.hpsf.SpecialPropertySet
setFormat(short) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
  Set the format field for the LineFormat record.
setFormatFlags(short) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
  Set the format flags field for the AreaFormat record.
setFormatFlags(short) - Method in class org.apache.poi.hssf.record.chart.AreaRecord
  Set the format flags field for the Area record.
setFormatFlags(short) - Method in class org.apache.poi.hssf.record.chart.BarRecord
  Set the format flags field for the Bar record.
setFormatFlags(short) - Method in class org.apache.poi.hssf.record.chart.DataFormatRecord
  Set the format flags field for the DataFormat record.
setFormatFlags(short) - Method in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
  Set the format flags field for the SeriesLabels record.
setFormatID(ClassID) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the section's format ID.
setFormatID(byte[]) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the section's format ID.
setFormatIndex(short) - Method in class org.apache.poi.hssf.record.chart.NumberFormatIndexRecord
  Set the format index field for the NumberFormatIndex record.
setFormatIndex(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the index to the Format record (which FORMAT to use 0-based)
setFormatted(boolean) - Method in class org.apache.poi.hssf.record.RowRecord
  set whether the row has been formatted (even if its got all blank cells)
setFormula1(String) - Method in class org.apache.poi.hssf.usermodel.DVConstraint
setFormula1(String) - Method in interface org.apache.poi.ss.usermodel.DataValidationConstraint
  Sets a formula for expression 1.
setFormula2(String) - Method in class org.apache.poi.hssf.usermodel.DVConstraint
setFormula2(String) - Method in interface org.apache.poi.ss.usermodel.DataValidationConstraint
  Sets a formula for expression 2.
setFormulaOfLink(Ptg[]) - Method in class org.apache.poi.hssf.record.chart.LinkedDataRecord
  Set the formula of link field for the LinkedData record.
setFormulasNotResults(boolean) - Method in class org.apache.poi.hssf.extractor.EventBasedExcelExtractor
  Should we return the formula itself, and not the result it produces? Default is false
setFormulasNotResults(boolean) - Method in class org.apache.poi.hssf.extractor.ExcelExtractor
  Should we return the formula itself, and not the result it produces? Default is false
setFormulasNotResults(boolean) - Method in interface org.apache.poi.ss.extractor.ExcelExtractor
  Should we return the formula itself, and not the result it produces? Default is false
setForwardDiagonalOn(boolean) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  Of/off bottom left to top right line
setForwardDiagonalOn(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setFreezePanes(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set whether the window should freeze panes
setFreezePanesNoSplit(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  freeze unsplit panes or not
setFullPrecision(boolean) - Method in class org.apache.poi.hssf.record.PrecisionRecord
  set whether to use full precision or just skew all you figures all to hell.
setFunction(boolean) - Method in class org.apache.poi.hssf.record.NameRecord
  Indicates that the defined name refers to a user-defined function.
setFunction(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFName
  Indicates that the defined name refers to a user-defined function.
setFunction(boolean) - Method in interface org.apache.poi.ss.usermodel.Name
  Indicates that the defined name refers to a user-defined function.
setGenerated(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the generated field value.
setGrbitFrt(short) - Method in class org.apache.poi.hssf.record.common.FtrHeader
setGridset(boolean) - Method in class org.apache.poi.hssf.record.GridsetRecord
  set whether gridlines are visible when printing
setGridsPrinted(boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
  set whether gridlines printed or not.
setGridsPrinted(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  set whether gridlines printed.
setHCenter(boolean) - Method in class org.apache.poi.hssf.record.HCenterRecord
  set whether or not to horizonatally center this sheet.
setHeader(HeaderRecord) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
  Sets the HeaderRecord.
setHeaderColor(int) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set the palette index for the header color
setHeaderMargin(double) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setHeaderMargin(double) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Sets the header margin.
setHeaderMargin(double) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Sets the header margin.
setHeadingPair(byte[]) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the heading pair.
setHeight(int) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the height of the metafile in EMU's (English Metric Units).
setHeight(int) - Method in class org.apache.poi.hssf.record.chart.AxisParentRecord
  Set the height field for the AxisParent record.
setHeight(int) - Method in class org.apache.poi.hssf.record.chart.ChartFormatRecord
setHeight(int) - Method in class org.apache.poi.hssf.record.chart.ChartRecord
  Set the height field for the Chart record.
setHeight(int) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the height field for the Text record.
setHeight(short) - Method in class org.apache.poi.hssf.record.RowRecord
  set the height of the row
setHeight(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set teh height of the window
setHeight(short) - Method in class org.apache.poi.hssf.usermodel.HSSFRow
  set the row's height or set to ff (-1) for undefined/default-height.
setHeight(short) - Method in interface org.apache.poi.ss.usermodel.Row
  Set the row's height or set to ff (-1) for undefined/default-height.
setHeightBasis(short) - Method in class org.apache.poi.hssf.record.chart.FontBasisRecord
  Set the height basis field for the FontBasis record.
setHeightInPoints(float) - Method in class org.apache.poi.hssf.usermodel.HSSFRow
  set the row's height in points.
setHeightInPoints(float) - Method in interface org.apache.poi.ss.usermodel.Row
  Set the row's height in points.
setHelpTopicText(String) - Method in class org.apache.poi.hssf.record.NameRecord
  sets the help topic text
setHidden(boolean) - Method in class org.apache.poi.hssf.record.BoundSheetRecord
  Is the sheet hidden? Different from very hidden
setHidden(boolean) - Method in class org.apache.poi.hssf.record.ColumnInfoRecord
  set whether or not these cells are hidden
setHidden(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether the cell is hidden or not
setHidden(boolean) - Method in class org.apache.poi.hssf.record.NameRecord
setHidden(boolean) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set whether the window is hidden or not
setHidden(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the cell's using this style to be hidden
setHidden(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
setHidden(boolean) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the cell's using this style to be hidden
setHidden(boolean) - Method in interface org.apache.poi.ss.usermodel.Workbook
setHiddenCount(int) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the hidden count.
setHideObj(short) - Method in class org.apache.poi.hssf.record.HideObjRecord
  set hide object options
setHistoryBitMask(int) - Method in class org.apache.poi.hssf.record.BOFRecord
  set the history bit mask (not very useful)
setHorizontal(boolean) - Method in class org.apache.poi.hssf.record.chart.BarRecord
  Sets the horizontal field value.
setHorizontalAlignment(byte) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the horizontal alignment field for the Text record.
setHorizontalAlignment(short) - Method in class org.apache.poi.hssf.usermodel.HSSFTextbox
  Sets the horizontal alignment.
setHorizontalBorder(boolean) - Method in class org.apache.poi.hssf.record.chart.DatRecord
  Sets the horizontal border field value.
setHorizontalHold(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set the horizontal position of the window (in 1/20ths of a point)
setHorizontallyCenter(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  determines whether the output is horizontally centered on the page.
setHorizontallyCenter(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Determines whether the output is horizontally centered on the page.
setHorizontalPos(int) - Method in class org.apache.poi.hssf.record.DVALRecord
setHorizontalScale(int) - Method in class org.apache.poi.hssf.record.chart.PlotGrowthRecord
  Set the horizontalScale field for the PlotGrowth record.
setHorizontalTextAlignment(int) - Method in class org.apache.poi.hssf.record.TextObjectRecord
  Sets the Horizontal text alignment field value.
setHResolution(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setHResolution(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Sets the horizontal resolution.
setHResolution(short) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Sets the horizontal resolution.
setHyperlink(Hyperlink) - Method in class org.apache.poi.hssf.usermodel.HSSFCell
  Assign a hyperlink to this cell
setHyperlink(Hyperlink) - Method in interface org.apache.poi.ss.usermodel.Cell
  Assign a hyperlink to this cell
setIconic(boolean) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set whether the window has been iconized or not
setID(long) - Method in class org.apache.poi.hpsf.MutableProperty
  Sets the property's ID.
setId(int) - Method in class org.apache.poi.hssf.record.chart.SeriesTextRecord
  Set the id field for the SeriesText record.
setIncludeBlankCells(boolean) - Method in class org.apache.poi.hssf.extractor.ExcelExtractor
  Should blank cells be output? Default is to only output cells that are present in the file and are non-blank.
setIncludeCellComments(boolean) - Method in class org.apache.poi.hssf.extractor.ExcelExtractor
  Should cell comments be included? Default is false
setIncludeCellComments(boolean) - Method in interface org.apache.poi.ss.extractor.ExcelExtractor
  Should cell comments be included? Default is false
setIncludeHeadersFooters(boolean) - Method in class org.apache.poi.hssf.extractor.ExcelExtractor
  Should headers and footers be included in the output? Default is to include them.
setIncludeSheetNames(boolean) - Method in class org.apache.poi.hssf.extractor.EventBasedExcelExtractor
  Should sheet names be included? Default is true
setIncludeSheetNames(boolean) - Method in class org.apache.poi.hssf.extractor.ExcelExtractor
  Should sheet names be included? Default is true
setIncludeSheetNames(boolean) - Method in interface org.apache.poi.ss.extractor.ExcelExtractor
  Should sheet names be included? Default is true
setIndent(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set indention (not sure of the units, think its spaces)
setIndention(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the number of spaces to indent the text in the cell
setIndention(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the number of spaces to indent the text in the cell
setIndentionOptions(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the indent options bitmask (see corresponding bitmask setters that reference this field)
setIndentNotParentAlignment(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether or not to use the alignment in this XF instead of the parent XF.
setIndentNotParentBorder(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether or not to use the border in this XF instead of the parent XF.
setIndentNotParentCellOptions(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether or not to use the locking/hidden in this XF instead of the parent XF.
setIndentNotParentFont(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether or not to use the font in this XF instead of the parent XF.
setIndentNotParentFormat(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether or not to use the format in this XF instead of the parent XF.
setIndentNotParentPattern(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  Sets whether or not to use the pattern in this XF instead of the parent XF (foreground/background).
setIndex(short) - Method in class org.apache.poi.hssf.record.chart.SeriesIndexRecord
  Set the index field for the SeriesIndex record.
setIndexNumberFmtRecord(short) - Method in class org.apache.poi.hssf.record.chart.LinkedDataRecord
  Set the index number fmt record field for the LinkedData record.
setIndexOfColorValue(short) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the index of color value field for the Text record.
setIndexToFontTable(short) - Method in class org.apache.poi.hssf.record.chart.FontBasisRecord
  Set the index to font table field for the FontBasis record.
setInvert(boolean) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
  Sets the invert field value.
setIsDate(boolean) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Sets the isDate field value.
setItalic(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
  set the font to be italics or not
setItalic(boolean) - Method in class org.apache.poi.hssf.record.FontRecord
  set the font to be italics or not
setItalic(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set whether to use italics or not
setItalic(boolean) - Method in interface org.apache.poi.ss.usermodel.Font
  set whether to use italics or not
setIteration(boolean) - Method in class org.apache.poi.hssf.record.IterationRecord
  set whether or not to iterate for calculations
setIterations(short) - Method in class org.apache.poi.hssf.record.CalcCountRecord
  set the number of iterations to perform
setJustifyLast(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  Dunno.
setKeyboardShortcut(byte) - Method in class org.apache.poi.hssf.record.NameRecord
  sets the keyboard shortcut
setKeywords(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the keywords.
setLabel(String) - Method in interface org.apache.poi.common.usermodel.Hyperlink
  Sets text label for this hyperlink
setLabel(String) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
  Sets text label for this hyperlink
setLabel(String) - Method in class org.apache.poi.hssf.usermodel.HSSFHyperlink
  Sets text label for this hyperlink
setLabelAsPercentage(boolean) - Method in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
  Sets the label as percentage field value.
setLabelColorRgb(int) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the label color rgb field for the Tick record.
setLabelFrequency(short) - Method in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
  Set the label frequency field for the CategorySeriesAxis record.
setLabelPosition(byte) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the label position field for the Tick record.
setLandscape(boolean) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setLandscape(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set whether to print in landscape
setLandscape(boolean) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set whether to print in landscape
setLastAuthor(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the last author.
setLastCol(short) - Method in class org.apache.poi.hssf.record.DimensionsRecord
  set the last col number for the sheet
setLastCol(int) - Method in class org.apache.poi.hssf.record.RowRecord
setLastColRelative(boolean) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  set whether the last column should be relative or not
setLastColumn(int) - Method in class org.apache.poi.hssf.record.ColumnInfoRecord
  set the last column this record defines formatting info for
setLastColumn(int) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  set the last column in the area
setLastColumn(int) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
  Set the last column (zero-based)of the range that contains this hyperlink
setLastColumn(int) - Method in class org.apache.poi.hssf.usermodel.HSSFHyperlink
  Set the column of the last cell that contains the hyperlink
setLastColumn(int) - Method in interface org.apache.poi.ss.usermodel.Hyperlink
  Set the column of the last cell that contains the hyperlink
setLastColumn(int) - Method in class org.apache.poi.ss.util.CellRangeAddressBase
setLastColumnRaw(short) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  set the last column irrespective of the bitmasks
setLastMSOSPID(int) - Method in class org.apache.poi.ddf.EscherDgRecord
  The last shape id used in this drawing group.
setLastPrinted(Date) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the lastPrinted.
setLastRow(int) - Method in class org.apache.poi.hssf.record.DimensionsRecord
  set the last row number for the sheet
setLastRow(int) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
setLastRow(int) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
  Set the last row (zero-based)of the range that contains this hyperlink
setLastRow(int) - Method in class org.apache.poi.hssf.usermodel.HSSFHyperlink
  Set the row of the last cell that contains the hyperlink
setLastRow(int) - Method in interface org.apache.poi.ss.usermodel.Hyperlink
  Set the row of the last cell that contains the hyperlink
setLastRow(int) - Method in class org.apache.poi.ss.util.CellRangeAddressBase
setLastRowAdd1(int) - Method in class org.apache.poi.hssf.record.IndexRecord
setLastRowRelative(boolean) - Method in class org.apache.poi.hssf.record.formula.AreaPtgBase
  set whether the last row is relative or not
setLastSaveDateTime(Date) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the total time spent in editing the document.
setLeft(String) - Method in class org.apache.poi.hssf.usermodel.HeaderFooter
setLeft(String) - Method in interface org.apache.poi.ss.usermodel.Footer
  Sets the left string.
setLeft(String) - Method in interface org.apache.poi.ss.usermodel.Header
  Sets the left string.
setLeft(String) - Method in interface org.apache.poi.ss.usermodel.HeaderFooter
  Sets the left string.
setLeftBorderColor(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the color to use for the left border
setLeftBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setLeftBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the color to use for the left border
setLeftBorderColor(short, Region, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
setLeftBorderColor(int, CellRangeAddress, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Sets the leftBorderColor attribute of the HSSFRegionUtil object
setLeftBorderColor(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the color to use for the left border
setLeftBorderColor(int, CellRangeAddress, Sheet, Workbook) - Static method in class org.apache.poi.ss.util.RegionUtil
  Sets the leftBorderColor attribute of the RegionUtil object
setLeftBorderModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setLeftBorderPaletteIdx(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the palette index for the left border color
setLeftCol(short) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets the left column to show in desktop window pane.
setLeftCol(short) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set the leftmost column displayed in the window
setLeftColumn(short) - Method in class org.apache.poi.hssf.record.PaneRecord
  Set the left column field for the Pane record.
setLeftRowGutter(short) - Method in class org.apache.poi.hssf.record.GutsRecord
  set the size of the gutter that appears at the left of the rows
setLeftToRight(boolean) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setLeftToRight(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set whether to go left to right or top down in ordering
setLeftToRight(boolean) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set whether to go left to right or top down in ordering
setLineColor(int) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
  Set the line color field for the LineFormat record.
setLineCount(int) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the line count.
setLinePattern(short) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
  Set the line pattern field for the LineFormat record.
setLineStyle(int) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
  Sets the line style.
setLineStyleColor(int) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
  The color applied to the lines of this shape.
setLineStyleColor(int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
  The color applied to the lines of this shape.
setLineWidth(int) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
  Sets the width of the line.
setLink1(short) - Method in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
  Set the link 1 field for the ObjectLink record.
setLink2(short) - Method in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
  Set the link 2 field for the ObjectLink record.
setLinksDirty(boolean) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the linksDirty.
setLinkType(byte) - Method in class org.apache.poi.hssf.record.chart.LinkedDataRecord
  Set the link type field for the LinkedData record.
setList(boolean) - Method in class org.apache.poi.hssf.dev.FormulaViewer
setLocked(boolean) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Sets the locked field value.
setLocked(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether the cell is locked or not
setLocked(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the cell's using this style to be locked
setLocked(boolean) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the cell's using this style to be locked
setLogarithmicScale(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the logarithmic scale field value.
setLogUnsupportedTypes(boolean) - Static method in class org.apache.poi.hpsf.VariantSupport
  Specifies whether warnings about unsupported variant types are to be written to `System.err` or not.
setMacoutline(boolean) - Method in class org.apache.poi.hssf.record.FontRecord
  whether to use the mac outline font style thing (mac only) - Some mac person should comment this instead of me doing it (since I have no idea)
setMacshadow(boolean) - Method in class org.apache.poi.hssf.record.FontRecord
  whether to use the mac shado font style thing (mac only) - Some mac person should comment this instead of me doing it (since I have no idea)
setMajorIncrement(double) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Set the major increment field for the ValueRange record.
setMajorTickType(byte) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the major tick type field for the Tick record.
setMajorUnit(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the major unit field for the AxisOptions record.
setMajorUnitValue(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the major unit value field for the AxisOptions record.
setManager(String) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the manager.
setMargin(short, double) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
  Sets the size of the margin in inches.
setMargin(double) - Method in class org.apache.poi.hssf.record.BottomMarginRecord
  Set the margin field for the BottomMargin record.
setMargin(double) - Method in class org.apache.poi.hssf.record.LeftMarginRecord
  Set the margin field for the LeftMargin record.
setMargin(double) - Method in interface org.apache.poi.hssf.record.Margin
  Set the margin field for the Margin.
setMargin(double) - Method in class org.apache.poi.hssf.record.RightMarginRecord
  Set the margin field for the RightMargin record.
setMargin(double) - Method in class org.apache.poi.hssf.record.TopMarginRecord
  Set the margin field for the TopMargin record.
setMargin(short, double) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets the size of the margin in inches.
setMargin(short, double) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets the size of the margin in inches.
setMarginBottom(int) - Method in class org.apache.poi.hssf.usermodel.HSSFTextbox
  Sets the bottom margin within the textbox.
setMarginBottom(int) - Method in interface org.apache.poi.ss.usermodel.Textbox
  Sets the bottom margin within the textbox.
setMarginLeft(int) - Method in class org.apache.poi.hssf.usermodel.HSSFTextbox
  Sets the left margin within the textbox.
setMarginLeft(int) - Method in interface org.apache.poi.ss.usermodel.Textbox
  Sets the left margin within the textbox.
setMarginRight(int) - Method in class org.apache.poi.hssf.usermodel.HSSFTextbox
  Sets the right margin within the textbox.
setMarginRight(int) - Method in interface org.apache.poi.ss.usermodel.Textbox
  Sets the right margin within the textbox.
setMarginTop(int) - Method in class org.apache.poi.hssf.usermodel.HSSFTextbox
  Sets the top margin within the textbox.
setMarginTop(int) - Method in interface org.apache.poi.ss.usermodel.Textbox
  Sets the top margin within the textbox.
setMarker(byte) - Method in class org.apache.poi.ddf.EscherBitmapBlip
setMaxDrawingGroupId(int) - Method in class org.apache.poi.ddf.EscherDggRecord
setMaximumAxisValue(double) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Set the maximum axis value field for the ValueRange record.
setMaximumCategory(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the maximum category field for the AxisOptions record.
setMergeCells(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether to merge cells
setMinimumAxisValue(double) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Set the minimum axis value field for the ValueRange record.
setMinimumCategory(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the minimum category field for the AxisOptions record.
setMinorIncrement(double) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Set the minor increment field for the ValueRange record.
setMinorTickType(byte) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the minor tick type field for the Tick record.
setMinorUnit(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the minor unit field for the AxisOptions record.
setMinorUnitValue(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the minor unit value field for the AxisOptions record.
setMissingCellPolicy(Row.MissingCellPolicy) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  Sets the policy on what to do when getting missing or blank cells from a row.
setMissingCellPolicy(Row.MissingCellPolicy) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Sets the policy on what to do when getting missing or blank cells from a row.
setMMClipCount(int) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the mmclip count.
setMode(short) - Method in class org.apache.poi.hssf.record.RefModeRecord
  set the reference mode to use (HSSF uses/assumes A1)
setName(byte) - Method in class org.apache.poi.ddf.EscherBSERecord
  The length in characters of the blip name.
setName(String) - Method in class org.apache.poi.hpsf.CustomProperty
  Sets the property's name.
setName(String) - Method in class org.apache.poi.hssf.record.StyleRecord
  set the style's name
setNameDefinition(Ptg[]) - Method in class org.apache.poi.hssf.record.NameRecord
setNameName(String) - Method in class org.apache.poi.hssf.usermodel.HSSFName
  Sets the name of the named range
setNameName(String) - Method in interface org.apache.poi.ss.usermodel.Name
  Sets the name of the named range
setNamepos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
  Sets the namepos.
setNameText(String) - Method in class org.apache.poi.hssf.record.NameCommentRecord
  Updates the name we're associated with, normally used when renaming that Name
setNameText(String) - Method in class org.apache.poi.hssf.record.NameRecord
  sets the name of the named range
setNeedRecalculation(boolean) - Method in class org.apache.poi.hssf.record.CFHeaderRecord
setNextChild(Child) - Method in interface org.apache.poi.poifs.property.Child
  Set the next Child
setNextChild(Child) - Method in interface org.apache.poi.poifs.property.Parent
  Set the next Child
setNextChild(Child) - Method in class org.apache.poi.poifs.property.Property
  Set the next Child
setNoColor(boolean) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setNoColor(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set whether it is black and white
setNoColor(boolean) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set whether it is black and white
setNoFill(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
  Sets whether this shape is filled or transparent.
setNoOrientation(boolean) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setNoOrientation(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set no orientation.
setNoOrientation(boolean) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set no orientation.
setNormalZoom(short) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set the zoom magnification in normal view
setNoteCount(int) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the note count.
setNotes(boolean) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setNotes(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Print the include notes
setNotes(boolean) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Print the include notes
setNumAxis(short) - Method in class org.apache.poi.hssf.record.chart.AxisUsedRecord
  Set the num axis field for the AxisUsed record.
setNumberOfConditionalFormats(int) - Method in class org.apache.poi.hssf.record.CFHeaderRecord
setNumberOfElementsInArray(int) - Method in class org.apache.poi.ddf.EscherArrayProperty
setNumberOfElementsInMemory(int) - Method in class org.apache.poi.ddf.EscherArrayProperty
setNumberOfSheets(short) - Method in class org.apache.poi.hssf.record.SupBookRecord
setNumBubbleValues(short) - Method in class org.apache.poi.hssf.record.chart.SeriesRecord
  Set the num bubble values field for the Series record.
setNumCategories(short) - Method in class org.apache.poi.hssf.record.chart.SeriesRecord
  Set the num categories field for the Series record.
setNumEntries(short) - Method in class org.apache.poi.hssf.record.AutoFilterInfoRecord
  set the number of AutoFilter drop-down arrows on the sheet
setNumerator(short) - Method in class org.apache.poi.hssf.record.SCLRecord
  Set the numerator field for the SCL record.
setNumLines(int) - Method in class org.apache.poi.hssf.record.LbsDataSubRecord.LbsDropData
  Set the number of lines to be displayed in the dropdown.
setNumSelectedTabs(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set the number of selected tabs
setNumShapes(int) - Method in class org.apache.poi.ddf.EscherDgRecord
  The number of shapes in this drawing group.
setNumShapesSaved(int) - Method in class org.apache.poi.ddf.EscherDggRecord
setNumStringsPerBucket(short) - Method in class org.apache.poi.hssf.record.ExtSSTRecord
setNumValues(short) - Method in class org.apache.poi.hssf.record.chart.SeriesRecord
  Set the num values field for the Series record.
setObjectId(int) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Set the object id field for the CommonObjectData record.
setObjectID(int) - Method in class org.apache.poi.hssf.record.DVALRecord
  set the object ID of the drop down arrow object for list boxes
setObjectType(short) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Set the object type field for the CommonObjectData record.
setOffset(int) - Method in class org.apache.poi.ddf.EscherBSERecord
  File offset in the delay stream.
setOneNotTwoVar(boolean) - Method in class org.apache.poi.hssf.record.TableRecord
setOperator(int) - Method in class org.apache.poi.hssf.usermodel.DVConstraint
setOperator(int) - Method in interface org.apache.poi.ss.usermodel.DataValidationConstraint
  Sets the comparison operator for this constraint
setOptimize(short) - Method in class org.apache.poi.hssf.record.RowRecord
  set whether to optimize or not (set to 0)
setOption(short) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Set the option field for the CommonObjectData record.
setOptionFlag(short) - Method in class org.apache.poi.hssf.record.NameRecord
  sets the option flag for the named range
setOptionFlags(byte) - Method in class org.apache.poi.hssf.record.common.UnicodeString
  set the option flags which among other things return if this is a 16-bit or 8 bit string
setOptionFlags(short) - Method in class org.apache.poi.hssf.record.DefaultRowHeightRecord
  set the (currently unimportant to HSSF) option flags
setOptions(short) - Method in class org.apache.poi.ddf.EscherRecord
  Set the options this this record.
setOptions(short) - Method in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
  Set the options field for the AxisOptions record.
setOptions(short) - Method in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
  Set the options field for the CategorySeriesAxis record.
setOptions(short) - Method in class org.apache.poi.hssf.record.chart.DatRecord
  Set the options field for the Dat record.
setOptions(short) - Method in class org.apache.poi.hssf.record.chart.FrameRecord
  Set the options field for the Frame record.
setOptions(short) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Set the options field for the Legend record.
setOptions(short) - Method in class org.apache.poi.hssf.record.chart.LinkedDataRecord
  Set the options field for the LinkedData record.
setOptions(short) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the options field for the Tick record.
setOptions(short) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Set the options field for the ValueRange record.
setOptions(short) - Method in class org.apache.poi.hssf.record.DVALRecord
setOptions(short) - Method in class org.apache.poi.hssf.record.FormulaRecord
  set the option flags
setOptions(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setOptions(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set the options bitmask (see bit setters)
setOptions(short) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set the options bitmask or just use the bit setters.
setOptions(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Sets the options flags.
setOptions1(short) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the options1 field for the Text record.
setOptions2(short) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the options2 field for the Text record.
setOSVersion(int) - Method in class org.apache.poi.hpsf.MutablePropertySet
  Sets the "osVersion" property.
setOSVersion(int) - Method in class org.apache.poi.hpsf.SpecialPropertySet
setOutline(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setOutline(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setOutlineLevel(int) - Method in class org.apache.poi.hssf.record.ColumnInfoRecord
  set the outline level for the cells
setOutlineLevel(short) - Method in class org.apache.poi.hssf.record.RowRecord
  set the outline level of this row
setOutlineStyleLevel(int) - Method in class org.apache.poi.hssf.record.StyleRecord
  set the row or column level of the style (if builtin 1||2)
setPageBreakZoom(short) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  zoom magification in page break view
setPageCount(int) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the page count.
setPaged(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  Deprecated. use setActive()
setPageStart(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setPageStart(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set the page numbering start.
setPageStart(short) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set the page numbering start.
setPaint(Paint) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setPaint(Paint) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setPaintMode() - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setPaintMode() - Method in class org.apache.poi.hssf.usermodel.EscherGraphics
setPaintMode() - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setPaletteOptions(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the palette options bitmask (see the individual bitsetter methods that reference this one)
setPalettepos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
setPane(byte) - Method in class org.apache.poi.hssf.record.SelectionRecord
  set which window pane this is for
setPaperSize(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setPaperSize(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set the paper size.
setPaperSize(short) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set the paper size.
setParCount(int) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the par count.
setParentIndex(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  for cell XF types this is the parent style (usually 0/normal).
setParsedExpression(Ptg[]) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
  Also checks for a related shared formula and unlinks it if found
setParsedExpression(Ptg[]) - Method in class org.apache.poi.hssf.record.FormulaRecord
setParsedExpression1(Ptg[]) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setParsedExpression2(Ptg[]) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setPassword(short) - Method in class org.apache.poi.hssf.record.FileSharingRecord
setPassword(int) - Method in class org.apache.poi.hssf.record.PasswordRecord
  set the password
setPassword(short) - Method in class org.apache.poi.hssf.record.PasswordRev4Record
  set the password
setPasswordVerifier(int) - Method in class org.apache.poi.hssf.record.common.FeatProtection
setPatriarch(HSSFPatriarch) - Method in class org.apache.poi.hssf.record.EscherAggregate
setPattern(short) - Method in class org.apache.poi.hssf.record.chart.AreaFormatRecord
  Set the pattern field for the AreaFormat record.
setPatternBackgroundColorModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setPatternColorModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setPatternFormatting(PatternFormatting) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setPatternStyleModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setPerformDataValidation(boolean) - Method in class org.apache.poi.hssf.record.common.FeatFormulaErr2
setPictureData(byte[]) - Method in class org.apache.poi.ddf.EscherBlipRecord
setPictureIndex(int) - Method in class org.apache.poi.hssf.usermodel.HSSFPicture
setPlotVisibleOnly(boolean) - Method in class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
  Sets the plot visible only field value.
setPointNumber(short) - Method in class org.apache.poi.hssf.record.chart.DataFormatRecord
  Set the point number field for the DataFormat record.
setPoints(int[], int[]) - Method in class org.apache.poi.hssf.usermodel.HSSFPolygon
setPolygonDrawArea(int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFPolygon
  Defines the width and height of the points in the polygon
setPosition(int) - Method in class org.apache.poi.hssf.record.aggregates.RecordAggregate.PositionTrackingVisitor
setPositionOfBof(int) - Method in class org.apache.poi.hssf.record.BoundSheetRecord
  set the offset in bytes of the Beginning of File Marker within the HSSF Stream part of the POIFS file
setPresentationFormat(String) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the presentation format.
setPreviousChild(Child) - Method in interface org.apache.poi.poifs.property.Child
  Set the previous Child
setPreviousChild(Child) - Method in interface org.apache.poi.poifs.property.Parent
  Set the previous Child
setPreviousChild(Child) - Method in class org.apache.poi.poifs.property.Property
  Set the previous Child
setPrimaryUID(byte[]) - Method in class org.apache.poi.ddf.EscherMetafileBlip
setPrintable(boolean) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Sets the printable field value.
setPrintArea(int, String) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  Sets the printarea for the sheet provided
setPrintArea(int, int, int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  For the Convenience of Java Programmers maintaining pointers.
setPrintArea(int, String) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Sets the printarea for the sheet provided
setPrintArea(int, int, int, int, int) - Method in interface org.apache.poi.ss.usermodel.Workbook
  For the Convenience of Java Programmers maintaining pointers.
setPrintGridlines(PrintGridlinesRecord) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets the PrintGridlinesRecord.
setPrintGridlines(boolean) - Method in class org.apache.poi.hssf.record.PrintGridlinesRecord
  set whether or not to print the gridlines (and make your spreadsheet ugly)
setPrintGridlines(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Turns on or off the printing of gridlines.
setPrintGridlines(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets the flag indicating whether this sheet should display the lines between rows and columns to make editing and reading easier.
setPrintHeaders(boolean) - Method in class org.apache.poi.hssf.record.PrintHeadersRecord
  set to print the headers - y/n
setPrintSetup(PrintSetupRecord) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
  Sets the PrintSetupRecord.
setProperties(Property[]) - Method in class org.apache.poi.hpsf.MutableSection
  Sets this section's properties.
setProperty(int, String) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the string value of the property with the specified ID.
setProperty(int, int) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the int value of the property with the specified ID.
setProperty(int, long) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the long value of the property with the specified ID.
setProperty(int, boolean) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the boolean value of the property with the specified ID.
setProperty(int, long, Object) - Method in class org.apache.poi.hpsf.MutableSection
  Sets the value and the variant type of the property with the specified ID.
setProperty(Property) - Method in class org.apache.poi.hpsf.MutableSection
  Sets a property.
setProperty(int, Object) - Method in class org.apache.poi.hpsf.MutableSection
  Sets a property.
setPropertyStart(int) - Method in class org.apache.poi.poifs.storage.HeaderBlockWriter
  Set start of Property Table
setProtect(boolean) - Method in class org.apache.poi.hssf.record.ObjectProtectRecord
  set whether the sheet is protected or not
setProtect(boolean) - Method in class org.apache.poi.hssf.record.ProtectionRev4Record
  set whether the this is protected shared/tracked workbook or not
setProtect(boolean) - Method in class org.apache.poi.hssf.record.ProtectRecord
  set whether the sheet is protected or not
setProtect(boolean) - Method in class org.apache.poi.hssf.record.ScenarioProtectRecord
  set whether the sheet is protected or not
setProtect(boolean) - Method in class org.apache.poi.hssf.record.WindowProtectRecord
  set whether this window should be protected or not
setProtectionFormattingUnchanged() - Method in class org.apache.poi.hssf.record.CFRuleRecord
setProtpos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
setPure(boolean) - Method in class org.apache.poi.hpsf.CustomProperties
  Sets the purity of the custom property set.
setRawData(byte[]) - Method in class org.apache.poi.hssf.record.AbstractEscherHolderRecord
setReadingOrder(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the reading order for far east versions (0 - Context, 1 - Left to right, 2 - right to left) - We could use some help with support for the far east.
setReadOnly(short) - Method in class org.apache.poi.hssf.record.FileSharingRecord
  set the readonly flag
setRecalc(boolean) - Method in class org.apache.poi.hssf.record.SaveRecalcRecord
  set whether to recalculate formulas/etc before saving or not
setRecordId(short) - Method in class org.apache.poi.ddf.EscherRecord
  Sets the record id for this record.
setRecords(List) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
setRecordType(short) - Method in class org.apache.poi.hssf.record.common.FtrHeader
setRectX1(int) - Method in class org.apache.poi.ddf.EscherSpgrRecord
  The starting top-left coordinate of child records.
setRectX2(int) - Method in class org.apache.poi.ddf.EscherSpgrRecord
  The starting bottom-right coordinate of child records.
setRectY1(int) - Method in class org.apache.poi.ddf.EscherSpgrRecord
  The starting top-left coordinate of child records.
setRectY2(int) - Method in class org.apache.poi.ddf.EscherSpgrRecord
  The starting bottom-right coordinate of child records.
setRef(int) - Method in class org.apache.poi.ddf.EscherBSERecord
  The reference count of this blip.
setReference(String) - Method in class org.apache.poi.hssf.usermodel.HSSFName
  Deprecated. (Nov 2008) Misleading name. Use `HSSFName.setRefersToFormula(String)` instead.
setReferenceType(byte) - Method in class org.apache.poi.hssf.record.chart.LinkedDataRecord
  Set the reference type field for the LinkedData record.
setRefersToFormula(String) - Method in class org.apache.poi.hssf.usermodel.HSSFName
setRefersToFormula(String) - Method in interface org.apache.poi.ss.usermodel.Name
  Sets the formula that the name is defined to refer to.
setRefreshAll(boolean) - Method in class org.apache.poi.hssf.record.RefreshAllRecord
  set whether to refresh all external data when loading a sheet
setRemainingData(byte[]) - Method in class org.apache.poi.ddf.EscherBSERecord
  Any remaining data in this record.
setRemainingData(byte[]) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  Any remaining data in the record
setRemainingData(byte[]) - Method in class org.apache.poi.ddf.EscherClientDataRecord
  Any data recording this record.
setRenderingHint(RenderingHints.Key, Object) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setRenderingHint(RenderingHints.Key, Object) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setRenderingHints(Map) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setRenderingHints(Map) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setRepeatingRowsAndColumns(int, int, int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  Sets the repeating rows and columns for a sheet (as found in 2003:File->PageSetup->Sheet, 2007:Page Layout->Print Titles).
setRepeatingRowsAndColumns(int, int, int, int, int) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Sets the repeating rows and columns for a sheet (as found in File->PageSetup->Sheet).
setRequiredVersion(int) - Method in class org.apache.poi.hssf.record.BOFRecord
  set the minimum version required to read this file
setReserved(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the reserved field value.
setReserved(byte[]) - Method in class org.apache.poi.hssf.record.common.FtrHeader
setReserved(int) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set the reserved (don't do this) value
setReserved1(int) - Method in class org.apache.poi.hssf.record.chart.AxisRecord
  Set the reserved1 field for the Axis record.
setReserved1(int) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Set the reserved1 field for the CommonObjectData record.
setReserved2(int) - Method in class org.apache.poi.hssf.record.chart.AxisRecord
  Set the reserved2 field for the Axis record.
setReserved2(int) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Set the reserved2 field for the CommonObjectData record.
setReserved3(int) - Method in class org.apache.poi.hssf.record.chart.AxisRecord
  Set the reserved3 field for the Axis record.
setReserved3(int) - Method in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
  Set the reserved3 field for the CommonObjectData record.
setReserved4(int) - Method in class org.apache.poi.hssf.record.chart.AxisRecord
  Set the reserved4 field for the Axis record.
setReversed(boolean) - Method in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
  Sets the reversed field value.
setRevNumber(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the revision number.
setRgbColor(int) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the rgbColor field for the Text record.
setRight(String) - Method in class org.apache.poi.hssf.usermodel.HeaderFooter
setRight(String) - Method in interface org.apache.poi.ss.usermodel.Footer
  Sets the right string.
setRight(String) - Method in interface org.apache.poi.ss.usermodel.Header
  Sets the right string.
setRight(String) - Method in interface org.apache.poi.ss.usermodel.HeaderFooter
  Sets the right string or footer.
setRightBorderColor(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the color to use for the right border
setRightBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setRightBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the color to use for the right border
setRightBorderColor(short, Region, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
setRightBorderColor(int, CellRangeAddress, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Sets the rightBorderColor attribute of the HSSFRegionUtil object
setRightBorderColor(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the color to use for the right border
setRightBorderColor(int, CellRangeAddress, Sheet, Workbook) - Static method in class org.apache.poi.ss.util.RegionUtil
  Sets the rightBorderColor attribute of the RegionUtil object
setRightBorderModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setRightBorderPaletteIdx(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the palette index for the right border color
setRightToLeft(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets whether the worksheet is displayed from right to left instead of from left to right.
setRotation(short) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the rotation field value.
setRotation(short) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Sets the rotation field value.
setRotation(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the degree of rotation.
setRotation(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the degree of rotation for the text in the cell
setRotation(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the degree of rotation for the text in the cell
setRow(int) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
setRow(int) - Method in class org.apache.poi.hssf.record.BlankRecord
  set the row this cell occurs on
setRow(int) - Method in class org.apache.poi.hssf.record.CellRecord
setRow(int) - Method in interface org.apache.poi.hssf.record.CellValueRecordInterface
setRow(int) - Method in class org.apache.poi.hssf.record.formula.RefPtgBase
setRow(int) - Method in class org.apache.poi.hssf.record.LabelRecord
  NO-OP!
setRow(int) - Method in class org.apache.poi.hssf.record.NoteRecord
  Specify the row that contains the comment
setRow(int) - Method in class org.apache.poi.hssf.usermodel.HSSFComment
  Set the row of the cell that contains the comment
setRow(int) - Method in class org.apache.poi.hssf.usermodel.HSSFSimpleShape
setRow(int) - Method in interface org.apache.poi.ss.usermodel.Comment
  Set the row of the cell that contains the comment
setRow1(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  The row number for the top-left corner of the shape.
setRow1(int) - Method in class org.apache.poi.hssf.usermodel.HSSFClientAnchor
setRow1(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Returns the row (0 based) of the first cell.
setRow2(short) - Method in class org.apache.poi.ddf.EscherClientAnchorRecord
  The row number for the bottom-right corner of the current shape.
setRow2(int) - Method in class org.apache.poi.hssf.usermodel.HSSFClientAnchor
setRow2(int) - Method in interface org.apache.poi.ss.usermodel.ClientAnchor
  Returns the row (0 based) of the first cell.
setRowBreak(int, short, short) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
  Sets a page break at the indicated row
setRowBreak(int) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets a page break at the indicated row
setRowBreak(int) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets a page break at the indicated row
setRowDeleted(boolean) - Method in class org.apache.poi.hssf.record.TableRecord
setRowFrom(int) - Method in class org.apache.poi.ss.util.Region
  Deprecated. set the upper left hand corner row number
setRowGroupCollapsed(int, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
setRowGroupCollapsed(int, boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Set view state of a groupped range of rows
setRowHeight(short) - Method in class org.apache.poi.hssf.record.DefaultRowHeightRecord
  set the default row height
setRowInputCol(int) - Method in class org.apache.poi.hssf.record.TableRecord
setRowInputRow(int) - Method in class org.apache.poi.hssf.record.TableRecord
setRowLevelMax(short) - Method in class org.apache.poi.hssf.record.GutsRecord
  set the maximum outline level for the row gutter.
setRowNum(int) - Method in class org.apache.poi.hssf.usermodel.HSSFRow
  set the row number of this row.
setRowNum(int) - Method in interface org.apache.poi.ss.usermodel.Row
  Set the row number of this row.
setRowNumber(int) - Method in class org.apache.poi.hssf.record.RowRecord
  set the logical row number for this row (0 based index)
setRowOrColInpCell(boolean) - Method in class org.apache.poi.hssf.record.TableRecord
setRowRelative(boolean) - Method in class org.apache.poi.hssf.record.formula.RefPtgBase
setRowStyle(HSSFCellStyle) - Method in class org.apache.poi.hssf.usermodel.HSSFRow
  Applies a whole-row cell styling to the row.
setRowSumsBelow(boolean) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  set if row summaries appear below detail in the outline
setRowSumsBelow(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  set if row summaries appear below detail in the outline
setRowSumsBelow(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Flag indicating whether summary rows appear below detail in an outline, when applying an outline.
setRowSumsRight(boolean) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  set if col summaries appear right of the detail in the outline
setRowSumsRight(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  set if col summaries appear right of the detail in the outline
setRowSumsRight(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.
setRowTo(int) - Method in class org.apache.poi.ss.util.Region
  Deprecated. get the lower right hand corner row number
setRule(int, CFRuleRecord) - Method in class org.apache.poi.hssf.record.aggregates.CFRecordsAggregate
setRule(int, HSSFConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFConditionalFormatting
  Replaces an existing Conditional Formatting rule at position idx.
setSaltData(byte[]) - Method in class org.apache.poi.hssf.record.FilePassRecord
setSaltHash(byte[]) - Method in class org.apache.poi.hssf.record.FilePassRecord
setSavedInPageBreakPreview(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  was the sheet saved in page break view
setSaveLinkValues(short) - Method in class org.apache.poi.hssf.record.BookBoolRecord
  set the save ext links flag
setSBATBlockCount(int) - Method in class org.apache.poi.poifs.storage.HeaderBlockWriter
  Set count of SBAT blocks
setSBATStart(int) - Method in class org.apache.poi.poifs.storage.HeaderBlockWriter
  Set start of small block allocation table
setScale(boolean) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the scale.
setScale(short) - Method in class org.apache.poi.hssf.record.chart.FontBasisRecord
  Set the scale field for the FontBasis record.
setScale(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setScale(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set the scale.
setScale(short) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set the scale.
setSCLRecord(SCLRecord) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets the SCL record or creates it in the correct place if it does not already exist.
setSecondaryUID(byte[]) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the secondary UID
setSecurity(int) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the security code.
setSelected(boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
  Sets whether the sheet is selected
setSelected(boolean) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  sheet tab is selected
setSelected(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets whether sheet is selected.
setSelected(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets a flag indicating whether this sheet is selected.
setSelectedTab(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  Deprecated. - Misleading name - use setActiveSheetIndex()
setSelectedTab(int) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  Selects a single sheet.
setSelectedTab(short) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  Deprecated. use setSelectedTab(int)
setSelectedTab(int) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Sets the tab whose data is actually seen when the sheet is opened.
setSelectedTabs(int[]) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
setSelection(SelectionRecord) - Method in class org.apache.poi.hssf.model.InternalSheet
setSeriesIndex(short) - Method in class org.apache.poi.hssf.record.chart.DataFormatRecord
  Set the series index field for the DataFormat record.
setSeriesNumber(short) - Method in class org.apache.poi.hssf.record.chart.DataFormatRecord
  Set the series number field for the DataFormat record.
setShadow(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setShadow(boolean) - Method in class org.apache.poi.hssf.record.chart.AreaRecord
  Sets the shadow field value.
setShadow(boolean) - Method in class org.apache.poi.hssf.record.chart.BarRecord
  Sets the shadow field value.
setShadow(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setShapeId(int) - Method in class org.apache.poi.ddf.EscherSpRecord
  Sets a number that identifies this shape.
setShapeId(int) - Method in class org.apache.poi.hssf.record.NoteRecord
  Object id for OBJ record that contains the comment
setShapeIdMax(int) - Method in class org.apache.poi.ddf.EscherDggRecord
  The maximum is actually the next available.
setShapeType(int) - Method in class org.apache.poi.hssf.usermodel.HSSFSimpleShape
  Sets the shape types.
setSharedFeature(SharedFeature) - Method in class org.apache.poi.hssf.record.FeatRecord
setSharedFormula(boolean) - Method in class org.apache.poi.hssf.record.FormulaRecord
setSheetBof(int, int) - Method in class org.apache.poi.hssf.model.InternalWorkbook
  Sets the BOF for a given sheet
setSheetHidden(int, boolean) - Method in class org.apache.poi.hssf.model.InternalWorkbook
  Hide or unhide a sheet
setSheetHidden(int, int) - Method in class org.apache.poi.hssf.model.InternalWorkbook
  Hide or unhide a sheet.
setSheetHidden(int, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
setSheetHidden(int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
setSheetHidden(int, boolean) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Hide or unhide a sheet
setSheetHidden(int, int) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Hide or unhide a sheet.
setSheetIndex(int) - Method in class org.apache.poi.hssf.usermodel.HSSFName
  Specifies if the defined name is a local name, and if so, which sheet it is on.
setSheetIndex(int) - Method in interface org.apache.poi.ss.usermodel.Name
  Tell Excel that this name applies to the worksheet with the specified index instead of the entire workbook.
setSheetName(int, String) - Method in class org.apache.poi.hssf.model.InternalWorkbook
  sets the name for a given sheet.
setSheetname(String) - Method in class org.apache.poi.hssf.record.BoundSheetRecord
  Set the sheetname for this sheet.
setSheetName(int, String) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  Sets the sheet name.
setSheetName(int, String) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Set the sheet name.
setSheetNumber(int) - Method in class org.apache.poi.hssf.record.NameRecord
setSheetOrder(String, int) - Method in class org.apache.poi.hssf.model.InternalWorkbook
  sets the order of appearance for a given sheet.
setSheetOrder(String, int) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
  sets the order of appearance for a given sheet.
setSheetOrder(String, int) - Method in interface org.apache.poi.ss.usermodel.Workbook
  Sets the order of appearance for a given sheet.
setShort(short) - Method in class org.apache.poi.util.BitField
  Set the bits.
setShortBoolean(short, boolean) - Method in class org.apache.poi.util.BitField
  Set a boolean BitField
setShortFilename(String) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
setShortFilename(String) - Method in class org.apache.poi.hssf.usermodel.HSSFHyperlink
  Convenience method equivalent to `HSSFHyperlink.setAddress(String)`
setShortValue(short, short) - Method in class org.apache.poi.util.BitField
  Replace the bits with new values.
setShowActual(boolean) - Method in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
  Sets the show actual field value.
setShowBubbleSizes(boolean) - Method in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
  Sets the show bubble sizes field value.
setShowBubbleSizes(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the show bubble sizes field value.
setShowCategoryLabelAsPercentage(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the show category label as percentage field value.
setShowErrorBox(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFDataValidation
setShowErrorBox(boolean) - Method in interface org.apache.poi.ss.usermodel.DataValidation
  Sets the behaviour when an invalid value is entered
setShowKey(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the show key field value.
setShowLabel(boolean) - Method in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
  Sets the show label field value.
setShowLabel(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the show label field value.
setShowPercent(boolean) - Method in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
  Sets the show percent field value.
setShowPromptBox(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFDataValidation
setShowPromptBox(boolean) - Method in interface org.apache.poi.ss.usermodel.DataValidation
  Sets the behaviour when a cell which belongs to this object is selected
setShowSeriesKey(boolean) - Method in class org.apache.poi.hssf.record.chart.DatRecord
  Sets the show series key field value.
setShowValue(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the show value field value.
setShowValueAsPercentage(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the show value as percentage field value.
setShrinkToFit(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether to shrink the text to fit
setSize(int) - Method in class org.apache.poi.ddf.EscherBSERecord
  Blip size in stream.
setSize(int) - Method in class org.apache.poi.poifs.property.RootProperty
  set size
setSizeEMU(Dimension) - Method in class org.apache.poi.ddf.EscherMetafileBlip
setSizeEMU(Dimension) - Method in class org.apache.poi.ddf.EscherPictBlip
setSizeOfElements(int) - Method in class org.apache.poi.ddf.EscherArrayProperty
setSlideCount(int) - Method in class org.apache.poi.hpsf.DocumentSummaryInformation
  Sets the slideCount.
setSmoothedLine(boolean) - Method in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
  Sets the smoothed line field value.
setSpacing(byte) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Set the spacing field for the Legend record.
setSSTIndex(int) - Method in class org.apache.poi.hssf.record.LabelSSTRecord
  set the index to the string in the SSTRecord
setStacked(boolean) - Method in class org.apache.poi.hssf.record.chart.AreaRecord
  Sets the stacked field value.
setStacked(boolean) - Method in class org.apache.poi.hssf.record.chart.BarRecord
  Sets the stacked field value.
setStartBlock(int) - Method in interface org.apache.poi.poifs.filesystem.BATManaged
  Set the start block for this instance
setStartBlock(int) - Method in class org.apache.poi.poifs.filesystem.POIFSDocument
  Set the start block for this instance
setStartBlock(int) - Method in class org.apache.poi.poifs.property.Property
  Set the start block for the document referred to by this Property.
setStartBlock(int) - Method in class org.apache.poi.poifs.property.PropertyTable
  Set the start block for this instance
setStartBlock(int) - Method in class org.apache.poi.poifs.storage.BlockAllocationTableWriter
  Set the start block for this instance
setStartBlock(int) - Method in class org.apache.poi.poifs.storage.SmallBlockTableWriter
  Set the start block for this instance
setStatusBarText(String) - Method in class org.apache.poi.hssf.record.NameRecord
  sets the status bar text
setStorageClsid(ClassID) - Method in interface org.apache.poi.poifs.filesystem.DirectoryEntry
  Sets the storage clsid for the directory entry
setStorageClsid(ClassID) - Method in class org.apache.poi.poifs.filesystem.DirectoryNode
  Sets the storage clsid for the directory entry
setStorageClsid(ClassID) - Method in class org.apache.poi.poifs.property.Property
  Sets the storage class ID for this property stream.
setStr(HSSFRichTextString) - Method in class org.apache.poi.hssf.record.TextObjectRecord
setStrikeout(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
  set the font to be stricken out or not
setStrikeout(boolean) - Method in class org.apache.poi.hssf.record.FontRecord
  set the font to be stricken out or not
setStrikeout(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set whether to use a strikeout horizontal line through the text or not
setStrikeout(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setStrikeout(boolean) - Method in interface org.apache.poi.ss.usermodel.Font
  set whether to use a strikeout horizontal line through the text or not
setString(String) - Method in class org.apache.poi.hssf.record.common.UnicodeString
  set the actual string this contains
setString(String) - Method in class org.apache.poi.hssf.record.StringRecord
  Sets the string represented by this record.
setString(RichTextString) - Method in class org.apache.poi.hssf.usermodel.HSSFComment
  Sets the rich text string used by this comment.
setString(RichTextString) - Method in class org.apache.poi.hssf.usermodel.HSSFSimpleShape
setString(RichTextString) - Method in class org.apache.poi.hssf.usermodel.HSSFTextbox
setString(RichTextString) - Method in interface org.apache.poi.ss.usermodel.Comment
  Sets the rich text string used by this comment.
setString(RichTextString) - Method in interface org.apache.poi.ss.usermodel.Textbox
setStroke(Stroke) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setStroke(Stroke) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setStyle(int) - Method in class org.apache.poi.hssf.record.LbsDataSubRecord.LbsDropData
  Set the style of this dropdown.
setSubject(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the subject.
setSupbookpos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
  Sets the supbookpos.
setSuperSubScript(short) - Method in class org.apache.poi.hssf.record.FontRecord
  set the type of super or subscript for the font
setSuppressDropDownArrow(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFDataValidation
setSuppressDropDownArrow(boolean) - Method in interface org.apache.poi.ss.usermodel.DataValidation
  Useful for list validation objects .
setTabIdArray(short[]) - Method in class org.apache.poi.hssf.record.TabIdRecord
  set the tab array.
setTabpos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
setTabWidthRatio(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  ratio of the width of the tabs to the horizontal scrollbar
setTag(short) - Method in class org.apache.poi.ddf.EscherBSERecord
  unused
setTemplate(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the template.
setText(String) - Method in class org.apache.poi.hssf.record.chart.SeriesTextRecord
  Set the text field for the SeriesText record.
setText(String) - Method in class org.apache.poi.hssf.record.HeaderFooterBase
  set the footer string
setTextLocked(boolean) - Method in class org.apache.poi.hssf.record.TextObjectRecord
  Sets the text locked field value.
setTextMark(String) - Method in class org.apache.poi.hssf.record.HyperlinkRecord
setTextMark(String) - Method in class org.apache.poi.hssf.usermodel.HSSFHyperlink
  Convenience method equivalent to `HSSFHyperlink.setAddress(String)`
setTextOrientation(int) - Method in class org.apache.poi.hssf.record.TextObjectRecord
  Set the text orientation field for the TextObjectBase record.
setTextRotation(short) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the text rotation field for the Text record.
setThumbnail(byte[]) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the thumbnail.
setThumbnail(byte[]) - Method in class org.apache.poi.hpsf.Thumbnail
  Sets the Thumbnail's underlying `byte[]` in `VT_CF` format.
setTickColor(short) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the tick color field for the Tick record.
setTickMarkFrequency(short) - Method in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
  Set the tick mark frequency field for the CategorySeriesAxis record.
setTitle(String) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the title.
setTitle(String) - Method in class org.apache.poi.hssf.record.common.FeatProtection
setTopBorderColor(int) - Method in class org.apache.poi.hssf.record.cf.BorderFormatting
  set the color to use for the top border
setTopBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFBorderFormatting
setTopBorderColor(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the color to use for the top border
setTopBorderColor(short, Region, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Deprecated. (Aug 2008) use `CellRangeAddress` instead of `Region`
setTopBorderColor(int, CellRangeAddress, HSSFSheet, HSSFWorkbook) - Static method in class org.apache.poi.hssf.util.HSSFRegionUtil
  Sets the topBorderColor attribute of the HSSFRegionUtil object
setTopBorderColor(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the color to use for the top border
setTopBorderColor(int, CellRangeAddress, Sheet, Workbook) - Static method in class org.apache.poi.ss.util.RegionUtil
  Sets the topBorderColor attribute of the RegionUtil object
setTopBorderModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setTopBorderPaletteIdx(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the palette index for the top border
setTopColGutter(short) - Method in class org.apache.poi.hssf.record.GutsRecord
  set the size of the gutter that appears at the above the columns
setTopLeftBottomRightBorderModified(boolean) - Method in class org.apache.poi.hssf.record.CFRuleRecord
setTopRow(short) - Method in class org.apache.poi.hssf.model.InternalSheet
setTopRow(short) - Method in class org.apache.poi.hssf.record.PaneRecord
  Set the top row field for the Pane record.
setTopRow(short) - Method in class org.apache.poi.hssf.record.WindowTwoRecord
  set the top row visible in the window
setTransform(AffineTransform) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setTransform(AffineTransform) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setType(long) - Method in class org.apache.poi.hpsf.MutableProperty
  Sets the property's type.
setType(int) - Method in class org.apache.poi.hssf.record.BOFRecord
  type of object this marks
setType(byte) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Set the type field for the Legend record.
setTypeOffset(short) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set normal,super or subscript.
setTypeOffset(short) - Method in interface org.apache.poi.ss.usermodel.Font
  set normal,super or subscript.
setUID(byte[]) - Method in class org.apache.poi.ddf.EscherBitmapBlip
setUid(byte[]) - Method in class org.apache.poi.ddf.EscherBSERecord
  16 byte MD4 checksum.
setUID(byte[]) - Method in class org.apache.poi.ddf.EscherMetafileBlip
setUID(byte[]) - Method in class org.apache.poi.ddf.EscherPictBlip
setUncalced(boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
setUncompressedSize(int) - Method in class org.apache.poi.ddf.EscherMetafileBlip
setUncompressedSize(int) - Method in class org.apache.poi.ddf.EscherPictBlip
setUnderline(byte) - Method in class org.apache.poi.hssf.record.FontRecord
  set the type of underlining for the font
setUnderline(byte) - Method in class org.apache.poi.hssf.usermodel.HSSFFont
  set type of text underlining to use
setUnderline(byte) - Method in interface org.apache.poi.ss.usermodel.Font
  set type of text underlining to use
setUnderlineType(short) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
  set the type of underlining type for the font
setUnderlineType(short) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
  set the type of underlining type for the font
setUnderlineTypeModified(boolean) - Method in class org.apache.poi.hssf.record.cf.FontFormatting
setUnderlineTypeModified(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
setUnits(short) - Method in class org.apache.poi.hssf.record.chart.UnitsRecord
  Set the units field for the Units record.
setUnknown(boolean) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
  Sets the unknown field value.
setUnused2(byte) - Method in class org.apache.poi.ddf.EscherBSERecord
setUnused3(byte) - Method in class org.apache.poi.ddf.EscherBSERecord
setup(String[], WorkbookEvaluator[]) - Static method in class org.apache.poi.ss.formula.CollaboratingWorkbooksEnvironment
setupEnvironment(String[], HSSFFormulaEvaluator[]) - Static method in class org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  Coordinates several formula evaluators together so that formulas that involve external references can be evaluated.
setupEnvironment(String[], ForkedEvaluator[]) - Static method in class org.apache.poi.ss.formula.eval.forked.ForkedEvaluator
  Coordinates several formula evaluators together so that formulas that involve external references can be evaluated.
setUsage(byte) - Method in class org.apache.poi.ddf.EscherBSERecord
  Defines the way this blip is used.
setUseExcel4Colors(boolean) - Method in class org.apache.poi.hssf.record.chart.DataFormatRecord
  Sets the use excel 4 colors field value.
setUsePage(boolean) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setUsePage(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Set whether to use page start
setUsePage(boolean) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Set whether to use page start
setUsername(String) - Method in class org.apache.poi.hssf.record.FileSharingRecord
setUsername(String) - Method in class org.apache.poi.hssf.record.WriteAccessRecord
  set the username for the user that created the report.
setUserStyleName(String) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  Sets the name of the user defined style.
setValidSettings(boolean) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setValidSettings(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Valid settings.
setValidSettings(boolean) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Valid settings.
setValue(Object) - Method in class org.apache.poi.hpsf.MutableProperty
  Sets the property's value.
setValue(boolean) - Method in class org.apache.poi.hssf.record.BoolErrRecord
  set the boolean value for the cell
setValue(byte) - Method in class org.apache.poi.hssf.record.BoolErrRecord
  set the error value for the cell
setValue(double) - Method in class org.apache.poi.hssf.record.FormulaRecord
  set the calculated value of the formula
setValue(double) - Method in class org.apache.poi.hssf.record.NumberRecord
  set the value for the cell
setValue(int, int) - Method in class org.apache.poi.util.BitField
  Replace the bits with new values.
setValue1(double) - Method in class org.apache.poi.hssf.usermodel.DVConstraint
  Sets a numeric value for expression 1.
setValue2(double) - Method in class org.apache.poi.hssf.usermodel.DVConstraint
  Sets a numeric value for expression 2.
setValueAxisCrossing(boolean) - Method in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
  Sets the value axis crossing field value.
setValuesDataType(short) - Method in class org.apache.poi.hssf.record.chart.SeriesRecord
  Set the values data type field for the Series record.
setValuesInReverse(boolean) - Method in class org.apache.poi.hssf.record.chart.ValueRangeRecord
  Sets the values in reverse field value.
setVaryDisplayPattern(boolean) - Method in class org.apache.poi.hssf.record.chart.ChartFormatRecord
setVCenter(boolean) - Method in class org.apache.poi.hssf.record.VCenterRecord
  set whether to center vertically or not
setVersion(int) - Method in class org.apache.poi.hssf.record.BOFRecord
  Version number - for BIFF8 should be 0x06
setVertical(boolean) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Sets the vertical field value.
setVertical(boolean) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Sets the vertical field value.
setVerticalAlignment(byte) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the vertical alignment field for the Text record.
setVerticalAlignment(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set the vertical alignment of text in the cell
setVerticalAlignment(short) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set the type of vertical alignment for the cell
setVerticalAlignment(short) - Method in class org.apache.poi.hssf.usermodel.HSSFTextbox
  Sets the vertical alignment.
setVerticalAlignment(short) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  set the type of vertical alignment for the cell
setVerticalBorder(boolean) - Method in class org.apache.poi.hssf.record.chart.DatRecord
  Sets the vertical border field value.
setVerticalHold(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set the vertical position of the window (in 1/20ths of a point)
setVerticallyCenter(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  determines whether the output is vertically centered on the page.
setVerticallyCenter(boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Determines whether the output is vertically centered on the page.
setVerticalPos(int) - Method in class org.apache.poi.hssf.record.DVALRecord
setVerticalScale(int) - Method in class org.apache.poi.hssf.record.chart.PlotGrowthRecord
  Set the verticalScale field for the PlotGrowth record.
setVerticalTextAlignment(int) - Method in class org.apache.poi.hssf.record.TextObjectRecord
  Sets the Vertical text alignment field value.
setVeryHidden(boolean) - Method in class org.apache.poi.hssf.record.BoundSheetRecord
  Is the sheet very hidden? Different from (normal) hidden
setVisible(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFComment
  Returns whether this comment is visible.
setVisible(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSimpleShape
setVisible(boolean) - Method in interface org.apache.poi.ss.usermodel.Comment
  Returns whether this comment is visible.
setVResolution(short) - Method in class org.apache.poi.hssf.record.PrintSetupRecord
setVResolution(short) - Method in class org.apache.poi.hssf.usermodel.HSSFPrintSetup
  Sets the vertical resolution.
setVResolution(short) - Method in interface org.apache.poi.ss.usermodel.PrintSetup
  Sets the vertical resolution.
setWeight(short) - Method in class org.apache.poi.hssf.record.chart.LineFormatRecord
  Set the weight field for the LineFormat record.
setWidth(int) - Method in class org.apache.poi.ddf.EscherBlipWMFRecord
  Set the width of the metafile in EMU's (English Metric Units).
setWidth(int) - Method in class org.apache.poi.hssf.record.chart.AxisParentRecord
  Set the width field for the AxisParent record.
setWidth(int) - Method in class org.apache.poi.hssf.record.chart.ChartFormatRecord
setWidth(int) - Method in class org.apache.poi.hssf.record.chart.ChartRecord
  Set the width field for the Chart record.
setWidth(int) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the width field for the Text record.
setWidth(short) - Method in class org.apache.poi.hssf.record.WindowOneRecord
  set the width of the window
setWindowing(short) - Method in class org.apache.poi.hssf.record.DateWindow1904Record
  sets whether or not to use 1904 date windowing (which means you'll be screwed in 2004)
setWordCount(int) - Method in class org.apache.poi.hpsf.SummaryInformation
  Sets the word count.
setWrapText(boolean) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether to wrap the text in the cell
setWrapText(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFCellStyle
  set whether the text should be wrapped
setWrapText(boolean) - Method in interface org.apache.poi.ss.usermodel.CellStyle
  Set whether the text should be wrapped.
setWSBool1(byte) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  set first byte (see bit setters)
setWSBool2(byte) - Method in class org.apache.poi.hssf.record.WSBoolRecord
  set the second byte (see bit setters)
setX(int) - Method in class org.apache.poi.hssf.record.chart.AxisParentRecord
  Set the x field for the AxisParent record.
setX(int) - Method in class org.apache.poi.hssf.record.chart.ChartRecord
  Set the x field for the Chart record.
setX(int) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the x field for the Text record.
setX(short) - Method in class org.apache.poi.hssf.record.PaneRecord
  Set the x field for the Pane record.
setXAxisUpperLeft(int) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Set the x axis upper left field for the Legend record.
setXBasis(short) - Method in class org.apache.poi.hssf.record.chart.FontBasisRecord
  Set the x Basis field for the FontBasis record.
setXFIndex(short) - Method in class org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
setXFIndex(short) - Method in class org.apache.poi.hssf.record.BlankRecord
  set the index of the extended format record to style this cell with
setXFIndex(short) - Method in class org.apache.poi.hssf.record.CellRecord
  set the index to the ExtendedFormat
setXFIndex(short) - Method in interface org.apache.poi.hssf.record.CellValueRecordInterface
setXFIndex(int) - Method in class org.apache.poi.hssf.record.ColumnInfoRecord
  set the columns' default format info
setXFIndex(short) - Method in class org.apache.poi.hssf.record.LabelRecord
  no op!
setXFIndex(short) - Method in class org.apache.poi.hssf.record.RowRecord
  if the row is formatted then this is the index to the extended format record
setXFIndex(int) - Method in class org.apache.poi.hssf.record.StyleRecord
  set the actual index of the style extended format record
setXfpos(int) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
setXFType(short) - Method in class org.apache.poi.hssf.record.ExtendedFormatRecord
  set whether the cell is a cell or style XFRecord
setXORMode(Color) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
setXORMode(Color) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics
setXORMode(Color) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
setXPosition(int) - Method in class org.apache.poi.hssf.record.chart.ChartFormatRecord
setXSize(int) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Set the x size field for the Legend record.
setY(int) - Method in class org.apache.poi.hssf.record.chart.AxisParentRecord
  Set the y field for the AxisParent record.
setY(int) - Method in class org.apache.poi.hssf.record.chart.ChartRecord
  Set the y field for the Chart record.
setY(int) - Method in class org.apache.poi.hssf.record.chart.TextRecord
  Set the y field for the Text record.
setY(short) - Method in class org.apache.poi.hssf.record.PaneRecord
  Set the y field for the Pane record.
setYAxisUpperLeft(int) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Set the y axis upper left field for the Legend record.
setYBasis(short) - Method in class org.apache.poi.hssf.record.chart.FontBasisRecord
  Set the y Basis field for the FontBasis record.
setYPosition(int) - Method in class org.apache.poi.hssf.record.chart.ChartFormatRecord
setYSize(int) - Method in class org.apache.poi.hssf.record.chart.LegendRecord
  Set the y size field for the Legend record.
setZero1(int) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the zero 1 field for the Tick record.
setZero2(int) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the zero 2 field for the Tick record.
setZero3(short) - Method in class org.apache.poi.hssf.record.chart.TickRecord
  Set the zero 3 field for the Tick record.
setZeroHeight(boolean) - Method in class org.apache.poi.hssf.record.RowRecord
  set whether or not to display this row with 0 height
setZeroHeight(boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFRow
  set whether or not to display this row with 0 height
setZeroHeight(boolean) - Method in interface org.apache.poi.ss.usermodel.Row
  Set whether or not to display this row with 0 height
setZoom(int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets the zoom magnification for the sheet.
setZoom(int, int) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets the zoom magnication for the sheet.
SHADOWSTYLE__COLOR - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__CRMOD - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__HIGHLIGHT - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__OFFSETX - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__OFFSETY - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__OPACITY - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__ORIGINX - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__ORIGINY - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__PERSPECTIVEX - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__PERSPECTIVEY - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__SCALEXTOX - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__SCALEXTOY - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__SCALEYTOX - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__SCALEYTOY - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__SECONDOFFSETX - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__SECONDOFFSETY - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__SHADOW - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__SHADOWOBSURED - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__TYPE - Static variable in class org.apache.poi.ddf.EscherProperties
SHADOWSTYLE__WEIGHT - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__BACKGROUNDSHAPE - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__BLACKANDWHITESETTINGS - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__CONNECTORSTYLE - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__DELETEATTACHEDOBJECT - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__LOCKSHAPETYPE - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__MASTER - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__OLEICON - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__PREFERRELATIVERESIZE - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__WMODEBW - Static variable in class org.apache.poi.ddf.EscherProperties
SHAPE__WMODEPUREBW - Static variable in class org.apache.poi.ddf.EscherProperties
ShapeTypes - Class in org.apache.poi.ss.usermodel
  All known types of automatic shapes in DrawingML
ShapeTypes() - Constructor for class org.apache.poi.ss.usermodel.ShapeTypes
SHARED - Static variable in class org.apache.poi.ss.formula.FormulaType
SharedFeature - Interface in org.apache.poi.hssf.record.common
  Common Interface for all Shared Features
SHAREDFEATURES_ISFFACTOID - Static variable in class org.apache.poi.hssf.record.FeatHdrRecord
  Specifies the smart tag type.
SHAREDFEATURES_ISFFEC2 - Static variable in class org.apache.poi.hssf.record.FeatHdrRecord
  Specifies that formula errors should be ignored
SHAREDFEATURES_ISFLIST - Static variable in class org.apache.poi.hssf.record.FeatHdrRecord
  Specifies the shared list type.
SHAREDFEATURES_ISFPROTECTION - Static variable in class org.apache.poi.hssf.record.FeatHdrRecord
  Specifies the enhanced protection type.
SharedFormulaRecord - Class in org.apache.poi.hssf.record
  Title: SHAREDFMLA (0x04BC) SharedFormulaRecord Description: Primarily used as an excel optimization so that multiple similar formulas are not written out too many times.
SharedFormulaRecord() - Constructor for class org.apache.poi.hssf.record.SharedFormulaRecord
SharedFormulaRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.SharedFormulaRecord
SharedValueManager - Class in org.apache.poi.hssf.record.aggregates
  Manages various auxiliary records while constructing a `RowRecordsAggregate`: `SharedFormulaRecord`s `ArrayRecord`s `TableRecord`s
SharedValueRecordBase - Class in org.apache.poi.hssf.record
  Common base class for `SharedFormulaRecord`, `ArrayRecord` and `TableRecord` which are have similarities.
SharedValueRecordBase(LittleEndianInput) - Constructor for class org.apache.poi.hssf.record.SharedValueRecordBase
  reads only the range (1 `CellRangeAddress8Bit`) from the stream
shear(double, double) - Method in class org.apache.poi.hssf.usermodel.DummyGraphics2d
shear(double, double) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
Sheet - Interface in org.apache.poi.ss.usermodel
  High level representation of a Excel worksheet.
SHEET_STATE_HIDDEN - Static variable in interface org.apache.poi.ss.usermodel.Workbook
  Indicates the book window is hidden, but can be shown by the user via the user interface.
SHEET_STATE_VERY_HIDDEN - Static variable in interface org.apache.poi.ss.usermodel.Workbook
  Indicates the sheet is hidden and cannot be shown in the user interface (UI).
SHEET_STATE_VISIBLE - Static variable in interface org.apache.poi.ss.usermodel.Workbook
  Indicates the sheet is visible.
SHEETEXT_0862 - Static variable in class org.apache.poi.hssf.record.UnknownRecord
SheetNameFormatter - Class in org.apache.poi.hssf.record.formula
  Formats sheet names for use in formula expressions.
SHEETPR_0081 - Static variable in class org.apache.poi.hssf.record.UnknownRecord
SheetPropertiesRecord - Class in org.apache.poi.hssf.record.chart
  Describes a chart sheet properties record.
SheetPropertiesRecord() - Constructor for class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
SheetPropertiesRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
SHEETPROTECTION_0867 - Static variable in class org.apache.poi.hssf.record.UnknownRecord
SheetReferences - Class in org.apache.poi.ss.util
  Holds a collection of Sheet names and their associated reference numbers.
SheetReferences() - Constructor for class org.apache.poi.ss.util.SheetReferences
shiftColumnBreaks(short, short, short) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
  Shifts the vertical page breaks for the indicated count
SHIFTJIS - Static variable in class org.apache.poi.ss.usermodel.FontCharset
shiftRowBreaks(int, int, int) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
  Shifts the horizontal page breaks for the indicated count
shiftRows(int, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Shifts rows between startRow and endRow n number of rows.
shiftRows(int, int, int, boolean, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Shifts rows between startRow and endRow n number of rows.
shiftRows(int, int, int, boolean, boolean, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Shifts rows between startRow and endRow n number of rows.
shiftRows(int, int, int) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Shifts rows between startRow and endRow n number of rows.
shiftRows(int, int, int, boolean, boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Shifts rows between startRow and endRow n number of rows.
SHORT_SIZE - Static variable in interface org.apache.poi.util.LittleEndianConsts
ShortField - Class in org.apache.poi.util
  representation of a short (16-bit) field at a fixed location within a byte array
ShortField(int) - Constructor for class org.apache.poi.util.ShortField
  construct the ShortField with its offset into its containing byte array
ShortField(int, short) - Constructor for class org.apache.poi.util.ShortField
  construct the ShortField with its offset into its containing byte array and initialize its value
ShortField(int, byte[]) - Constructor for class org.apache.poi.util.ShortField
  Construct the ShortField with its offset into its containing byte array and initialize its value from its byte array
ShortField(int, short, byte[]) - Constructor for class org.apache.poi.util.ShortField
  construct the ShortField with its offset into its containing byte array, initialize its value, and write its value to its byte array
ShortList - Class in org.apache.poi.util
  A List of short's; as full an implementation of the java.util.List interface as possible, with an eye toward minimal creation of objects the mimicry of List is as follows: if possible, operations designated 'optional' in the List interface are attempted wherever the List interface refers to an Object, substitute short wherever the List interface refers to a Collection or List, substitute ShortList the mimicry is not perfect, however: operations involving Iterators or ListIterators are not supported remove(Object) becomes removeValue to distinguish it from remove(short index) subList is not supported
ShortList() - Constructor for class org.apache.poi.util.ShortList
  create an ShortList of default size
ShortList(ShortList) - Constructor for class org.apache.poi.util.ShortList
  create a copy of an existing ShortList
ShortList(int) - Constructor for class org.apache.poi.util.ShortList
  create an ShortList with a predefined initial size
shortToHex(int) - Static method in class org.apache.poi.util.HexDump
shouldUseSmallBlocks() - Method in class org.apache.poi.poifs.property.DocumentProperty
  give method more visibility
shouldUseSmallBlocks() - Method in class org.apache.poi.poifs.property.Property
  Based on the currently defined size, should this property use small blocks?
SHOW_ALL - Static variable in class org.apache.poi.hssf.record.HideObjRecord
SHOW_PLACEHOLDERS - Static variable in class org.apache.poi.hssf.record.HideObjRecord
showInPane(short, short) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
  Sets desktop window pane display area, when the file is first opened in a viewer.
showInPane(short, short) - Method in interface org.apache.poi.ss.usermodel.Sheet
  Sets desktop window pane display area, when the file is first opened in a viewer.
sid - Static variable in class org.apache.poi.hssf.record.ArrayRecord
sid - Static variable in class org.apache.poi.hssf.record.AutoFilterInfoRecord
sid - Static variable in class org.apache.poi.hssf.record.BackupRecord
sid - Static variable in class org.apache.poi.hssf.record.BlankRecord
sid - Static variable in class org.apache.poi.hssf.record.BOFRecord
  for BIFF8 files the BOF is 0x809.
sid - Static variable in class org.apache.poi.hssf.record.BookBoolRecord
sid - Static variable in class org.apache.poi.hssf.record.BoolErrRecord
sid - Static variable in class org.apache.poi.hssf.record.BottomMarginRecord
sid - Static variable in class org.apache.poi.hssf.record.BoundSheetRecord
sid - Static variable in class org.apache.poi.hssf.record.CalcCountRecord
sid - Static variable in class org.apache.poi.hssf.record.CalcModeRecord
sid - Static variable in class org.apache.poi.hssf.record.CFHeaderRecord
sid - Static variable in class org.apache.poi.hssf.record.CFRuleRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.AreaFormatRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.AreaRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.AxisOptionsRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.AxisParentRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.AxisRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.AxisUsedRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.BarRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.BeginRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.CategorySeriesAxisRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.CatLabRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ChartEndBlockRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ChartEndObjectRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ChartFormatRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ChartFRTInfoRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ChartRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ChartStartBlockRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ChartStartObjectRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ChartTitleFormatRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.DataFormatRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.DataLabelExtensionRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.DatRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.DefaultDataLabelTextPropertiesRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.EndRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.FontBasisRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.FontIndexRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.FrameRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.LegendRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.LineFormatRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.LinkedDataRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.NumberFormatIndexRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.PlotAreaRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.PlotGrowthRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.SeriesChartGroupIndexRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.SeriesIndexRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.SeriesLabelsRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.SeriesListRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.SeriesRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.SeriesTextRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.SeriesToChartGroupRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.SheetPropertiesRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.TextRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.TickRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.UnitsRecord
sid - Static variable in class org.apache.poi.hssf.record.chart.ValueRangeRecord
sid - Static variable in class org.apache.poi.hssf.record.CodepageRecord
sid - Static variable in class org.apache.poi.hssf.record.ColumnInfoRecord
sid - Static variable in class org.apache.poi.hssf.record.CommonObjectDataSubRecord
sid - Static variable in class org.apache.poi.hssf.record.ContinueRecord
sid - Static variable in class org.apache.poi.hssf.record.CountryRecord
sid - Static variable in class org.apache.poi.hssf.record.CRNCountRecord
sid - Static variable in class org.apache.poi.hssf.record.CRNRecord
sid - Static variable in class org.apache.poi.hssf.record.DateWindow1904Record
sid - Static variable in class org.apache.poi.hssf.record.DBCellRecord
sid - Static variable in class org.apache.poi.hssf.record.DefaultColWidthRecord
sid - Static variable in class org.apache.poi.hssf.record.DefaultRowHeightRecord
sid - Static variable in class org.apache.poi.hssf.record.DeltaRecord
sid - Static variable in class org.apache.poi.hssf.record.DimensionsRecord
sid - Static variable in class org.apache.poi.hssf.record.DrawingGroupRecord
sid - Static variable in class org.apache.poi.hssf.record.DrawingRecord
sid - Static variable in class org.apache.poi.hssf.record.DrawingRecordForBiffViewer
sid - Static variable in class org.apache.poi.hssf.record.DrawingSelectionRecord
sid - Static variable in class org.apache.poi.hssf.record.DSFRecord
sid - Static variable in class org.apache.poi.hssf.record.DVALRecord
sid - Static variable in class org.apache.poi.hssf.record.DVRecord
sid - Static variable in class org.apache.poi.hssf.record.EmbeddedObjectRefSubRecord
sid - Static variable in class org.apache.poi.hssf.record.EndSubRecord
sid - Static variable in class org.apache.poi.hssf.record.EOFRecord
sid - Static variable in class org.apache.poi.hssf.record.EscherAggregate
sid - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
sid - Static variable in class org.apache.poi.hssf.record.ExternalNameRecord
sid - Static variable in class org.apache.poi.hssf.record.ExternSheetRecord
sid - Static variable in class org.apache.poi.hssf.record.ExtSSTRecord
sid - Static variable in class org.apache.poi.hssf.record.FeatHdrRecord
sid - Static variable in class org.apache.poi.hssf.record.FeatRecord
sid - Static variable in class org.apache.poi.hssf.record.FilePassRecord
sid - Static variable in class org.apache.poi.hssf.record.FileSharingRecord
sid - Static variable in class org.apache.poi.hssf.record.FnGroupCountRecord
sid - Static variable in class org.apache.poi.hssf.record.FontRecord
sid - Static variable in class org.apache.poi.hssf.record.FooterRecord
sid - Static variable in class org.apache.poi.hssf.record.FormatRecord
sid - Static variable in class org.apache.poi.hssf.record.formula.AddPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.Area3DPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.AreaErrPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.AreaNPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.AreaPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.ArrayPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.AttrPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.BoolPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.ConcatPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.DeletedArea3DPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.DeletedRef3DPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.DividePtg
sid - Static variable in class org.apache.poi.hssf.record.formula.EqualPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.ErrPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.ExpPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.FuncPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.FuncVarPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.GreaterEqualPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.GreaterThanPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.IntersectionPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.IntPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.LessEqualPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.LessThanPtg
  the sid for the less than operator as hex
sid - Static variable in class org.apache.poi.hssf.record.formula.MemAreaPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.MemErrPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.MemFuncPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.MissingArgPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.MultiplyPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.NamePtg
sid - Static variable in class org.apache.poi.hssf.record.formula.NameXPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.NotEqualPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.NumberPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.ParenthesisPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.PercentPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.PowerPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.RangePtg
sid - Static variable in class org.apache.poi.hssf.record.formula.Ref3DPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.RefErrorPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.RefNPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.RefPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.StringPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.SubtractPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.TblPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.UnaryMinusPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.UnaryPlusPtg
sid - Static variable in class org.apache.poi.hssf.record.formula.UnionPtg
sid - Static variable in class org.apache.poi.hssf.record.FormulaRecord
sid - Static variable in class org.apache.poi.hssf.record.FtCblsSubRecord
sid - Static variable in class org.apache.poi.hssf.record.GridsetRecord
sid - Static variable in class org.apache.poi.hssf.record.GroupMarkerSubRecord
sid - Static variable in class org.apache.poi.hssf.record.GutsRecord
sid - Static variable in class org.apache.poi.hssf.record.HCenterRecord
sid - Static variable in class org.apache.poi.hssf.record.HeaderFooterRecord
sid - Static variable in class org.apache.poi.hssf.record.HeaderRecord
sid - Static variable in class org.apache.poi.hssf.record.HideObjRecord
sid - Static variable in class org.apache.poi.hssf.record.HorizontalPageBreakRecord
sid - Static variable in class org.apache.poi.hssf.record.HyperlinkRecord
sid - Static variable in class org.apache.poi.hssf.record.IndexRecord
sid - Static variable in class org.apache.poi.hssf.record.InterfaceEndRecord
sid - Static variable in class org.apache.poi.hssf.record.InterfaceHdrRecord
sid - Static variable in class org.apache.poi.hssf.record.IterationRecord
sid - Static variable in class org.apache.poi.hssf.record.LabelRecord
sid - Static variable in class org.apache.poi.hssf.record.LabelSSTRecord
sid - Static variable in class org.apache.poi.hssf.record.LbsDataSubRecord
sid - Static variable in class org.apache.poi.hssf.record.LeftMarginRecord
sid - Static variable in class org.apache.poi.hssf.record.MergeCellsRecord
sid - Static variable in class org.apache.poi.hssf.record.MMSRecord
sid - Static variable in class org.apache.poi.hssf.record.MulBlankRecord
sid - Static variable in class org.apache.poi.hssf.record.MulRKRecord
sid - Static variable in class org.apache.poi.hssf.record.NameCommentRecord
sid - Static variable in class org.apache.poi.hssf.record.NameRecord
sid - Static variable in class org.apache.poi.hssf.record.NoteRecord
sid - Static variable in class org.apache.poi.hssf.record.NoteStructureSubRecord
sid - Static variable in class org.apache.poi.hssf.record.NumberRecord
sid - Static variable in class org.apache.poi.hssf.record.ObjectProtectRecord
sid - Static variable in class org.apache.poi.hssf.record.ObjRecord
sid - Static variable in class org.apache.poi.hssf.record.PaletteRecord
sid - Static variable in class org.apache.poi.hssf.record.PaneRecord
sid - Static variable in class org.apache.poi.hssf.record.PasswordRecord
sid - Static variable in class org.apache.poi.hssf.record.PasswordRev4Record
sid - Static variable in class org.apache.poi.hssf.record.pivottable.DataItemRecord
sid - Static variable in class org.apache.poi.hssf.record.pivottable.ExtendedPivotTableViewFieldsRecord
sid - Static variable in class org.apache.poi.hssf.record.pivottable.PageItemRecord
sid - Static variable in class org.apache.poi.hssf.record.pivottable.StreamIDRecord
sid - Static variable in class org.apache.poi.hssf.record.pivottable.ViewDefinitionRecord
sid - Static variable in class org.apache.poi.hssf.record.pivottable.ViewFieldsRecord
sid - Static variable in class org.apache.poi.hssf.record.pivottable.ViewSourceRecord
sid - Static variable in class org.apache.poi.hssf.record.PrecisionRecord
sid - Static variable in class org.apache.poi.hssf.record.PrintGridlinesRecord
sid - Static variable in class org.apache.poi.hssf.record.PrintHeadersRecord
sid - Static variable in class org.apache.poi.hssf.record.PrintSetupRecord
sid - Static variable in class org.apache.poi.hssf.record.ProtectionRev4Record
sid - Static variable in class org.apache.poi.hssf.record.ProtectRecord
sid - Static variable in class org.apache.poi.hssf.record.RecalcIdRecord
sid - Static variable in class org.apache.poi.hssf.record.RefModeRecord
sid - Static variable in class org.apache.poi.hssf.record.RefreshAllRecord
sid - Static variable in class org.apache.poi.hssf.record.RightMarginRecord
sid - Static variable in class org.apache.poi.hssf.record.RKRecord
sid - Static variable in class org.apache.poi.hssf.record.RowRecord
sid - Static variable in class org.apache.poi.hssf.record.SaveRecalcRecord
sid - Static variable in class org.apache.poi.hssf.record.ScenarioProtectRecord
sid - Static variable in class org.apache.poi.hssf.record.SCLRecord
sid - Static variable in class org.apache.poi.hssf.record.SelectionRecord
sid - Static variable in class org.apache.poi.hssf.record.SharedFormulaRecord
sid - Static variable in class org.apache.poi.hssf.record.SSTRecord
sid - Static variable in class org.apache.poi.hssf.record.StringRecord
sid - Static variable in class org.apache.poi.hssf.record.StyleRecord
sid - Static variable in class org.apache.poi.hssf.record.SupBookRecord
sid - Static variable in class org.apache.poi.hssf.record.TabIdRecord
sid - Static variable in class org.apache.poi.hssf.record.TableRecord
sid - Static variable in class org.apache.poi.hssf.record.TableStylesRecord
sid - Static variable in class org.apache.poi.hssf.record.TextObjectRecord
sid - Static variable in class org.apache.poi.hssf.record.TopMarginRecord
sid - Static variable in class org.apache.poi.hssf.record.UncalcedRecord
sid - Static variable in class org.apache.poi.hssf.record.UserSViewBegin
sid - Static variable in class org.apache.poi.hssf.record.UserSViewEnd
sid - Static variable in class org.apache.poi.hssf.record.UseSelFSRecord
sid - Static variable in class org.apache.poi.hssf.record.VCenterRecord
sid - Static variable in class org.apache.poi.hssf.record.VerticalPageBreakRecord
sid - Static variable in class org.apache.poi.hssf.record.WindowOneRecord
sid - Static variable in class org.apache.poi.hssf.record.WindowProtectRecord
sid - Static variable in class org.apache.poi.hssf.record.WindowTwoRecord
sid - Static variable in class org.apache.poi.hssf.record.WriteAccessRecord
sid - Static variable in class org.apache.poi.hssf.record.WriteProtectRecord
sid - Static variable in class org.apache.poi.hssf.record.WSBoolRecord
SIGN - Static variable in class org.apache.poi.hssf.record.formula.functions.NumericFunction
SIGNATURE_EMF - Static variable in class org.apache.poi.ddf.EscherMetafileBlip
  BLIP signatures as defined in the escher spec
SIGNATURE_PICT - Static variable in class org.apache.poi.ddf.EscherMetafileBlip
SIGNATURE_WMF - Static variable in class org.apache.poi.ddf.EscherMetafileBlip
SimpleFilledShape - Class in org.apache.poi.hssf.model
simpleFormat(Object) - Method in class org.apache.poi.ss.format.CellFormatter
  Formats the value in the most basic way, returning the resulting string.
simpleValue(StringBuffer, Object) - Method in class org.apache.poi.ss.format.CellDateFormatter
  Format a value according to the type, in the most basic way.

  For a date, this is `"mm/d/y"`.
simpleValue(StringBuffer, Object) - Method in class org.apache.poi.ss.format.CellElapsedFormatter
  Format a value according to the type, in the most basic way.

  For a date, this is `"mm/d/y"`.
simpleValue(StringBuffer, Object) - Method in class org.apache.poi.ss.format.CellFormatter
  Format a value according to the type, in the most basic way.
simpleValue(StringBuffer, Object) - Method in class org.apache.poi.ss.format.CellGeneralFormatter
  Equivalent to `CellGeneralFormatter.formatValue(StringBuffer,Object)`.
simpleValue(StringBuffer, Object) - Method in class org.apache.poi.ss.format.CellNumberFormatter
  Format a value according to the type, in the most basic way.

  For a number, this is `"#"` for integer values, and `"#.#"` for floating-point values.
simpleValue(StringBuffer, Object) - Method in class org.apache.poi.ss.format.CellTextFormatter
  Format a value according to the type, in the most basic way.

  For text, this is just printing the text.
SIN - Static variable in class org.apache.poi.hssf.record.formula.functions.NumericFunction
SINGLE - Static variable in class org.apache.poi.ss.usermodel.FontUnderline
  Single-line underlining under each character in the cell.
SINGLE_ACCOUNTING - Static variable in class org.apache.poi.ss.usermodel.FontUnderline
  Single-line accounting underlining under each character in the cell.
SINH - Static variable in class org.apache.poi.hssf.record.formula.functions.NumericFunction
size() - Method in class org.apache.poi.hssf.model.WorkbookRecordList
size() - Method in class org.apache.poi.hssf.record.aggregates.ConditionalFormattingTable
SIZE - Static variable in class org.apache.poi.hssf.record.formula.BoolPtg
SIZE - Static variable in class org.apache.poi.hssf.record.formula.FuncPtg
SIZE - Static variable in class org.apache.poi.hssf.record.formula.GreaterEqualPtg
SIZE - Static variable in class org.apache.poi.hssf.record.formula.IntPtg
SIZE - Static variable in class org.apache.poi.hssf.record.formula.NumberPtg
SIZE - Static variable in class org.apache.poi.hssf.record.formula.PercentPtg
SIZE - Static variable in class org.apache.poi.hssf.record.formula.RangePtg
size() - Method in class org.apache.poi.poifs.storage.DocumentBlock
  Get the number of bytes read for this block
size() - Method in interface org.apache.poi.ss.usermodel.CellRange
  Gets the number of cells in this range.
size() - Method in class org.apache.poi.ss.util.SSCellRange
size() - Method in class org.apache.poi.util.BinaryTree
  Returns the number of key-value mappings in this map.
size() - Method in class org.apache.poi.util.IntList
  Returns the number of elements in this list.
size() - Method in class org.apache.poi.util.IntMapper
size() - Method in class org.apache.poi.util.ShortList
  Returns the number of elements in this list.
skip(long) - Method in class org.apache.poi.poifs.filesystem.DocumentInputStream
skip(long) - Method in class org.apache.poi.util.BlockingInputStream
SKY_BLUE - Static variable in class org.apache.poi.ss.usermodel.IndexedColors
SLANTED_DASH_DOT - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
SLANTED_DASH_DOT - Static variable in class org.apache.poi.ss.usermodel.BorderStyle
  slanted dash-dot border
SMALL - Static variable in class org.apache.poi.hssf.record.formula.functions.AggregateFunction
SmallBlockTableReader - Class in org.apache.poi.poifs.storage
  This class implements reading the small document block list from an existing file
SmallBlockTableReader() - Constructor for class org.apache.poi.poifs.storage.SmallBlockTableReader
SmallBlockTableWriter - Class in org.apache.poi.poifs.storage
  This class implements storage for writing the small blocks used by small documents.
SmallBlockTableWriter(POIFSBigBlockSize, List, RootProperty) - Constructor for class org.apache.poi.poifs.storage.SmallBlockTableWriter
  Creates new SmallBlockTable
SmallDocumentBlock - Class in org.apache.poi.poifs.storage
  Storage for documents that are too small to use regular DocumentBlocks for their data
SmallDocumentBlockList - Class in org.apache.poi.poifs.storage
  A list of SmallDocumentBlocks instances, and methods to manage the list
SmallDocumentBlockList(List) - Constructor for class org.apache.poi.poifs.storage.SmallDocumentBlockList
  Constructor SmallDocumentBlockList
SMALLER_BIG_BLOCK_SIZE - Static variable in interface org.apache.poi.poifs.common.POIFSConstants
  Most files use 512 bytes as their big block size
SMALLER_BIG_BLOCK_SIZE_DETAILS - Static variable in interface org.apache.poi.poifs.common.POIFSConstants
SMILEY_FACE - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
SNIP_1_RECT - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
SNIP_2_DIAG_RECT - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
SNIP_2_SAME_RECT - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
SNIP_ROUND_RECT - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
SOLID_FILL - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
SOLID_FOREGROUND - Static variable in class org.apache.poi.hssf.record.cf.PatternFormatting
  Solidly filled
SOLID_FOREGROUND - Static variable in class org.apache.poi.hssf.usermodel.HSSFPatternFormatting
  Solidly filled
SOLID_FOREGROUND - Static variable in interface org.apache.poi.ss.usermodel.CellStyle
  Solidly filled
SOLID_FOREGROUND - Static variable in class org.apache.poi.ss.usermodel.FillPatternType
  Solidly filled
SOLVER_CONTAINER - Static variable in class org.apache.poi.ddf.EscherContainerRecord
SORT_0090 - Static variable in class org.apache.poi.hssf.record.UnknownRecord
sortProperties() - Method in class org.apache.poi.ddf.EscherOptRecord
  Records should be sorted by property number before being stored.
SP_CONTAINER - Static variable in class org.apache.poi.ddf.EscherContainerRecord
SPACE_AFTER_EQUALITY - Static variable in class org.apache.poi.hssf.record.formula.AttrPtg.SpaceType
  06H = Spaces following the equality sign (only in macro sheets)
SPACE_BEFORE - Static variable in class org.apache.poi.hssf.record.formula.AttrPtg.SpaceType
  00H = Spaces before the next token (not allowed before tParen token)
SPACE_BEFORE_CLOSE_PAREN - Static variable in class org.apache.poi.hssf.record.formula.AttrPtg.SpaceType
  04H = Spaces before closing parenthesis (only allowed before tParen, tFunc, and tFuncVar tokens)
SPACE_BEFORE_OPEN_PAREN - Static variable in class org.apache.poi.hssf.record.formula.AttrPtg.SpaceType
  02H = Spaces before opening parenthesis (only allowed before tParen token)
SPACING_CLOSE - Static variable in class org.apache.poi.hssf.record.chart.LegendRecord
SPACING_MEDIUM - Static variable in class org.apache.poi.hssf.record.chart.LegendRecord
SPACING_OPEN - Static variable in class org.apache.poi.hssf.record.chart.LegendRecord
SPARSE_DOTS - Static variable in class org.apache.poi.hssf.record.cf.PatternFormatting
  Sparse dots
SPARSE_DOTS - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
SPARSE_DOTS - Static variable in class org.apache.poi.hssf.usermodel.HSSFPatternFormatting
  Sparse dots
SPARSE_DOTS - Static variable in interface org.apache.poi.ss.usermodel.CellStyle
  Sparse dots
SPARSE_DOTS - Static variable in class org.apache.poi.ss.usermodel.FillPatternType
  Sparse dots
SpecialPropertySet - Class in org.apache.poi.hpsf
  Abstract superclass for the convenience classes `SummaryInformation` and `DocumentSummaryInformation`.
SpecialPropertySet(PropertySet) - Constructor for class org.apache.poi.hpsf.SpecialPropertySet
  Creates a `SpecialPropertySet.`
SpecialPropertySet(MutablePropertySet) - Constructor for class org.apache.poi.hpsf.SpecialPropertySet
  Creates a `SpecialPropertySet.`
SPECIFICATION_GROUP - Static variable in class org.apache.poi.ss.format.CellFormatPart
  Within `CellFormatPart.FORMAT_PAT`, the group number for the format specification.
SPECIFICATION_PAT - Static variable in class org.apache.poi.ss.format.CellFormatPart
  Pattern for the format specification part of a cell format part.
SPGR_CONTAINER - Static variable in class org.apache.poi.ddf.EscherContainerRecord
SpreadsheetVersion - Class in org.apache.poi.ss
  This enum allows spreadsheets from multiple Excel versions to be handled by the common code.
SQRT - Static variable in class org.apache.poi.hssf.record.formula.functions.NumericFunction
SQUARE_TABS - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
SQUARES - Static variable in class org.apache.poi.hssf.record.cf.PatternFormatting
  Squares
SQUARES - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
SQUARES - Static variable in class org.apache.poi.hssf.usermodel.HSSFPatternFormatting
  Squares
SQUARES - Static variable in interface org.apache.poi.ss.usermodel.CellStyle
  Squares
SQUARES - Static variable in class org.apache.poi.ss.usermodel.FillPatternType
  Squares
SS_BRACKET_SYMBOL - Static variable in class org.apache.poi.ss.usermodel.ExcelStyleDateFormatter
SS_NONE - Static variable in class org.apache.poi.hssf.record.cf.FontFormatting
  Escapement type - None
SS_NONE - Static variable in class org.apache.poi.hssf.record.FontRecord
SS_NONE - Static variable in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
  Escapement type - None
SS_NONE - Static variable in interface org.apache.poi.ss.usermodel.Font
  no type offsetting (not super or subscript)
SS_SUB - Static variable in class org.apache.poi.hssf.record.cf.FontFormatting
  Escapement type - Subscript
SS_SUB - Static variable in class org.apache.poi.hssf.record.FontRecord
SS_SUB - Static variable in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
  Escapement type - Subscript
SS_SUB - Static variable in interface org.apache.poi.ss.usermodel.Font
  subscript
SS_SUPER - Static variable in class org.apache.poi.hssf.record.cf.FontFormatting
  Escapement type - Superscript
SS_SUPER - Static variable in class org.apache.poi.hssf.record.FontRecord
SS_SUPER - Static variable in class org.apache.poi.hssf.usermodel.HSSFFontFormatting
  Escapement type - Superscript
SS_SUPER - Static variable in interface org.apache.poi.ss.usermodel.Font
  superscript
SSCellRange - Class in org.apache.poi.ss.util
  For POI internal use only
SSTRecord - Class in org.apache.poi.hssf.record
  Title: Static String Table Record (0x00FC)

  Description: This holds all the strings for LabelSSTRecords.
SSTRecord() - Constructor for class org.apache.poi.hssf.record.SSTRecord
SSTRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.SSTRecord
  Fill the fields from the data
ST_ACCENTBORDERCALLOUT1 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACCENTBORDERCALLOUT2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACCENTBORDERCALLOUT3 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACCENTBORDERCALLOUT90 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACCENTCALLOUT1 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACCENTCALLOUT2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACCENTCALLOUT3 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACCENTCALLOUT90 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONBACKPREVIOUS - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONBEGINNING - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONBLANK - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONDOCUMENT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONEND - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONFORWARDNEXT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONHELP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONHOME - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONINFORMATION - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONMOVIE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONRETURN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ACTIONBUTTONSOUND - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ARC - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BALLOON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BENTARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BENTCONNECTOR2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BENTCONNECTOR3 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BENTCONNECTOR4 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BENTCONNECTOR5 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BENTUPARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BEVEL - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BLOCKARC - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BORDERCALLOUT1 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BORDERCALLOUT2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BORDERCALLOUT3 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BORDERCALLOUT90 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BRACEPAIR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_BRACKETPAIR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CALLOUT1 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CALLOUT2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CALLOUT3 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CALLOUT90 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CAN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CHEVRON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CIRCULARARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CLOUDCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CUBE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CURVEDCONNECTOR2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CURVEDCONNECTOR3 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CURVEDCONNECTOR4 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CURVEDCONNECTOR5 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CURVEDDOWNARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CURVEDLEFTARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CURVEDRIGHTARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_CURVEDUPARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_DIAMOND - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_DONUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_DOUBLEWAVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_DOWNARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_DOWNARROWCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ELLIPSE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ELLIPSERIBBON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ELLIPSERIBBON2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTALTERNATEPROCESS - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTCOLLATE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTCONNECTOR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTDECISION - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTDELAY - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTDISPLAY - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTDOCUMENT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTEXTRACT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTINPUTOUTPUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTINTERNALSTORAGE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTMAGNETICDISK - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTMAGNETICDRUM - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTMAGNETICTAPE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTMANUALINPUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTMANUALOPERATION - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTMERGE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTMULTIDOCUMENT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTOFFLINESTORAGE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTOFFPAGECONNECTOR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTONLINESTORAGE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTOR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTPREDEFINEDPROCESS - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTPREPARATION - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTPROCESS - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTPUNCHEDCARD - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTPUNCHEDTAPE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTSORT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTSUMMINGJUNCTION - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FLOWCHARTTERMINATOR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_FOLDEDCORNER - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_HEART - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_HEXAGON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_HOMEPLATE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_HORIZONTALSCROLL - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_HOSTCONTROL - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_IRREGULARSEAL1 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_IRREGULARSEAL2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ISOCELESTRIANGLE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LEFTARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LEFTARROWCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LEFTBRACE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LEFTBRACKET - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LEFTRIGHTARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LEFTRIGHTARROWCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LEFTRIGHTUPARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LEFTUPARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LIGHTNINGBOLT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_LINE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_MIN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_MOON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_NIL - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_NOSMOKING - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_NOT_PRIMATIVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_NOTCHEDCIRCULARARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_NOTCHEDRIGHTARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_OCTAGON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_PARALLELOGRAM - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_PENTAGON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_PICTUREFRAME - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_PLAQUE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_PLUS - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_QUADARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_QUADARROWCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_RECTANGLE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_RIBBON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_RIBBON2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_RIGHTARROWCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_RIGHTBRACE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_RIGHTBRACKET - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_RIGHTTRIANGLE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_ROUNDRECTANGLE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_SEAL - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_SEAL16 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_SEAL24 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_SEAL32 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_SEAL4 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_SEAL8 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_SMILEYFACE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_STAR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_STRAIGHTCONNECTOR1 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_STRIPEDRIGHTARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_SUN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTARCHDOWNCURVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTARCHDOWNPOUR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTARCHUPCURVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTARCHUPPOUR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTBOX - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTBUTTONCURVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTBUTTONPOUR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCANDOWN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCANUP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCASCADEDOWN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCASCADEUP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCHEVRON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCHEVRONINVERTED - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCIRCLECURVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCIRCLEPOUR - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCURVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCURVEDOWN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTCURVEUP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTDEFLATE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTDEFLATEBOTTOM - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTDEFLATEINFLATE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTDEFLATEINFLATEDEFLATE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTDEFLATETOP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTFADEDOWN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTFADELEFT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTFADERIGHT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTFADEUP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTHEXAGON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTINFLATE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTINFLATEBOTTOM - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTINFLATETOP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTOCTAGON - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTONCURVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTONRING - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTPLAINTEXT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTRING - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTRINGINSIDE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTRINGOUTSIDE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTSIMPLE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTSLANTDOWN - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTSLANTUP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTSTOP - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTTRIANGLE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTTRIANGLEINVERTED - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTWAVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTWAVE1 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTWAVE2 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTWAVE3 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TEXTWAVE4 - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_THICKARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_TRAPEZOID - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_UPARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_UPARROWCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_UPDOWNARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_UPDOWNARROWCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_UTURNARROW - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_VERTICALSCROLL - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_WAVE - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_WEDGEELLIPSECALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_WEDGERECTCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
ST_WEDGERRECTCALLOUT - Static variable in class org.apache.poi.hssf.record.EscherAggregate
STANDARD_PALETTE_SIZE - Static variable in class org.apache.poi.hssf.record.PaletteRecord
  The standard size of an XLS palette
STANDARD_PAPER_10_14 - Static variable in class org.apache.poi.ss.usermodel.PaperSize
STANDARD_PAPER_11_17 - Static variable in class org.apache.poi.ss.usermodel.PaperSize
StandardRecord - Class in org.apache.poi.hssf.record
  Subclasses of this class (the majority of BIFF records) are non-continuable.
StandardRecord() - Constructor for class org.apache.poi.hssf.record.StandardRecord
STANDARDWIDTH_0099 - Static variable in class org.apache.poi.hssf.record.UnknownRecord
STAR_10 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_12 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_16 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_24 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_32 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_4 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_5 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_6 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_7 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
STAR_8 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
startBold() - Static method in class org.apache.poi.hssf.usermodel.HeaderFooter
startDoubleUnderline() - Static method in class org.apache.poi.hssf.usermodel.HeaderFooter
startUnderline() - Static method in class org.apache.poi.hssf.usermodel.HeaderFooter
STATEMENT_PAPER - Static variable in class org.apache.poi.ss.usermodel.PaperSize
STATEMENT_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
  US Statement 5 1/2 x 8 1/2 in
STDEV - Static variable in class org.apache.poi.hssf.record.formula.functions.AggregateFunction
STOP - Static variable in class org.apache.poi.ss.usermodel.DataValidation.ErrorStyle
  STOP style
STRAIGHT_CONNECTOR_1 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
StreamIDRecord - Class in org.apache.poi.hssf.record.pivottable
  SXIDSTM - Stream ID (0x00D5)
StreamIDRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.pivottable.StreamIDRecord
StringEval - Class in org.apache.poi.hssf.record.formula.eval
StringEval(Ptg) - Constructor for class org.apache.poi.hssf.record.formula.eval.StringEval
StringEval(String) - Constructor for class org.apache.poi.hssf.record.formula.eval.StringEval
StringPtg - Class in org.apache.poi.hssf.record.formula
  String Stores a String value in a formula value stored in the format <length 2 bytes>char[]
StringPtg(LittleEndianInput) - Constructor for class org.apache.poi.hssf.record.formula.StringPtg
  Create a StringPtg from a stream
StringPtg(String) - Constructor for class org.apache.poi.hssf.record.formula.StringPtg
  Create a StringPtg from a string representation of the number Number format is not checked, it is expected to be validated in the parser that calls this method.
StringRecord - Class in org.apache.poi.hssf.record
  STRING (0x0207)

  Stores the cached result of a text formula
StringRecord() - Constructor for class org.apache.poi.hssf.record.StringRecord
StringRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.StringRecord
StringUtil - Class in org.apache.poi.util
  Title: String Utility Description: Collection of string handling utilities

  Note - none of the methods in this class deals with `ContinueRecord`s.
StringUtil.StringsIterator - Class in org.apache.poi.util
  An Iterator over an array of Strings.
StringUtil.StringsIterator(String[]) - Constructor for class org.apache.poi.util.StringUtil.StringsIterator
StringValueEval - Interface in org.apache.poi.hssf.record.formula.eval
STRIPED_RIGHT_ARROW - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
stripFields(String) - Static method in class org.apache.poi.hssf.usermodel.HeaderFooter
  Removes any fields (eg macros, page markers etc) from the string.
STYLE_COMBO_DROPDOWN - Static variable in class org.apache.poi.hssf.record.LbsDataSubRecord.LbsDropData
  Combo dropdown control
STYLE_COMBO_EDIT_DROPDOWN - Static variable in class org.apache.poi.hssf.record.LbsDataSubRecord.LbsDropData
  Combo Edit dropdown control
STYLE_COMBO_SIMPLE_DROPDOWN - Static variable in class org.apache.poi.hssf.record.LbsDataSubRecord.LbsDropData
  Simple dropdown control (just the dropdown button)
StyleRecord - Class in org.apache.poi.hssf.record
  Title: Style Record (0x0293)

  Description: Describes a builtin to the gui or user defined style
StyleRecord() - Constructor for class org.apache.poi.hssf.record.StyleRecord
  creates a new style record, initially set to 'built-in'
StyleRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.StyleRecord
subFrom - Variable in class org.apache.poi.hssf.record.PageBreakRecord.Break
SubRecord - Class in org.apache.poi.hssf.record
  Subrecords are part of the OBJ class.
Substitute - Class in org.apache.poi.hssf.record.formula.functions
  An implementation of the SUBSTITUTE function:

  Substitutes text in a text string with new text, some number of times.
Substitute() - Constructor for class org.apache.poi.hssf.record.formula.functions.Substitute
subTo - Variable in class org.apache.poi.hssf.record.PageBreakRecord.Break
Subtotal - Class in org.apache.poi.hssf.record.formula.functions
  Implementation for the Excel function SUBTOTAL
Subtotal() - Constructor for class org.apache.poi.hssf.record.formula.functions.Subtotal
SubtractEval - Static variable in class org.apache.poi.hssf.record.formula.eval.TwoOperandNumericOperation
SubtractPtg - Class in org.apache.poi.hssf.record.formula
suggestFileExtension() - Method in class org.apache.poi.hssf.usermodel.HSSFPictureData
suggestFileExtension() - Method in interface org.apache.poi.ss.usermodel.PictureData
  Suggests a file extension for this image.
SUM - Static variable in class org.apache.poi.hssf.record.formula.AttrPtg
SUM - Static variable in class org.apache.poi.hssf.record.formula.functions.AggregateFunction
SUM - Static variable in class org.apache.poi.hssf.record.formula.FuncVarPtg
  Single instance of this token for 'sum() taking a single argument'
Sumif - Class in org.apache.poi.hssf.record.formula.functions
  Implementation for the Excel function SUMIF
Sumif() - Constructor for class org.apache.poi.hssf.record.formula.functions.Sumif
SUMMARY_INFORMATION_ID - Static variable in class org.apache.poi.hpsf.wellknown.SectionIDMap
  The SummaryInformation's section's format ID.
SummaryInformation - Class in org.apache.poi.hpsf
  Convenience class representing a Summary Information stream in a Microsoft Office document.
SummaryInformation(PropertySet) - Constructor for class org.apache.poi.hpsf.SummaryInformation
  Creates a `SummaryInformation` from a given `PropertySet`.
Sumproduct - Class in org.apache.poi.hssf.record.formula.functions
  Implementation for the Excel function SUMPRODUCT
Sumproduct() - Constructor for class org.apache.poi.hssf.record.formula.functions.Sumproduct
SUMSQ - Static variable in class org.apache.poi.hssf.record.formula.functions.AggregateFunction
Sumx2my2 - Class in org.apache.poi.hssf.record.formula.functions
  Implementation of Excel function SUMX2MY2()

  Calculates the sum of differences of squares in two arrays of the same size.
  Syntax:
  SUMX2MY2(arrayX, arrayY)

  result = Σi: 0..n(xi2-yi2)
Sumx2my2() - Constructor for class org.apache.poi.hssf.record.formula.functions.Sumx2my2
Sumx2py2 - Class in org.apache.poi.hssf.record.formula.functions
  Implementation of Excel function SUMX2PY2()

  Calculates the sum of squares in two arrays of the same size.
  Syntax:
  SUMX2PY2(arrayX, arrayY)

  result = Σi: 0..n(xi2+yi2)
Sumx2py2() - Constructor for class org.apache.poi.hssf.record.formula.functions.Sumx2py2
Sumxmy2 - Class in org.apache.poi.hssf.record.formula.functions
  Implementation of Excel function SUMXMY2()

  Calculates the sum of squares of differences between two arrays of the same size.
  Syntax:
  SUMXMY2(arrayX, arrayY)

  result = Σi: 0..n(xi-yi)2
Sumxmy2() - Constructor for class org.apache.poi.hssf.record.formula.functions.Sumxmy2
SUN - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
SupBookRecord - Class in org.apache.poi.hssf.record
  Title: Sup Book - EXTERNALBOOK (0x01AE)

  Description: A External Workbook Description (Supplemental Book) Its only a dummy record for making new ExternSheet Record
SupBookRecord(String, String[]) - Constructor for class org.apache.poi.hssf.record.SupBookRecord
SupBookRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.SupBookRecord
  called by the constructor, should set class level fields.
SUPPORTED_TYPES - Static variable in class org.apache.poi.hpsf.VariantSupport
  HPSF is able to read these `Variant` types.
swapFontUse(short, short) - Method in class org.apache.poi.hssf.record.common.UnicodeString
  Swaps all use in the string of one font index for use of a different font index.
SWISS - Static variable in class org.apache.poi.ss.usermodel.FontFamily
SWOOSH_ARROW - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
SYMBOL - Static variable in class org.apache.poi.ss.usermodel.FontCharset
SYMBOL_CHARSET - Static variable in interface org.apache.poi.ss.usermodel.Font
  Symbol character set
SystemOutLogger - Class in org.apache.poi.util
  A logger class that strives to make it as easy as possible for developers to write log calls, while simultaneously making those calls as cheap as possible by performing lazy evaluation of the log message.
SystemOutLogger() - Constructor for class org.apache.poi.util.SystemOutLogger

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV LETTER NEXT LETTER | FRAMES NO FRAMES

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _