Package com.independentsoft.office.odf

Class Spreadsheet

java.lang.Object
com.independentsoft.office.odf.Document
com.independentsoft.office.odf.Spreadsheet
public class Spreadsheet extends Document
The Class Spreadsheet.

  • Constructor Details

  • Method Details

    • open

      public void open​(String filePath) throws IOException, XMLStreamException
      Description copied from class: Document
      Open.
      Specified by:
      open in class Document
      Parameters:
      filePath - the file
      Throws:
      IOException - Signals that an I/O exception has occurred.
      XMLStreamException - the xML stream exception

    • open

      public void open​(InputStream inputStream) throws IOException, XMLStreamException
      Description copied from class: Document
      Open.
      Specified by:
      open in class Document
      Parameters:
      inputStream - the stream
      Throws:
      IOException - Signals that an I/O exception has occurred.
      XMLStreamException - the xML stream exception

    • openImplementation

      protected void openImplementation​(InputStream inputStream) throws IOException, XMLStreamException
      Overrides:
      openImplementation in class Document
      Throws:
      IOException
      XMLStreamException

    • renameStyle

      public void renameStyle​(Style style, String newName)
      Rename style.
      Parameters:
      style - the style
      newName - the new name

    • getContentElements

      public List<IContentElement> getContentElements()
      Returns all content elements.
      Specified by:
      getContentElements in class Document
      Returns:
      A collection of content elements.

    • clone

      public Spreadsheet clone()
      Creates a new object that is a deep copy of the current instance.
      Overrides:
      clone in class Object
      Returns:
      A new object that is a copy of this instance.

    • save

      public void save​(String filePath) throws IOException
      Description copied from class: Document
      Save.
      Specified by:
      save in class Document
      Parameters:
      filePath - the file
      Throws:
      IOException - Signals that an I/O exception has occurred.

    • save

      public void save​(String filePath, boolean overwrite) throws IOException
      Description copied from class: Document
      Save.
      Specified by:
      save in class Document
      Parameters:
      filePath - the file
      overwrite - the overwrite
      Throws:
      IOException - Signals that an I/O exception has occurred.

    • save

      public void save​(OutputStream outputStream) throws IOException
      Description copied from class: Document
      Save.
      Specified by:
      save in class Document
      Parameters:
      outputStream - the stream
      Throws:
      IOException - Signals that an I/O exception has occurred.

    • getInputStream

      public InputStream getInputStream() throws IOException
      Description copied from class: Document
      Gets the input stream.
      Specified by:
      getInputStream in class Document
      Returns:
      the input stream
      Throws:
      IOException - Signals that an I/O exception has occurred.

    • getBytes

      public byte[] getBytes() throws IOException
      Description copied from class: Document
      Gets the bytes.
      Specified by:
      getBytes in class Document
      Returns:
      the bytes
      Throws:
      IOException - Signals that an I/O exception has occurred.

    • getTables

      public List<Table> getTables()
      Description copied from class: Document
      Gets the tables.
      Overrides:
      getTables in class Document
      Returns:
      the tables

    • getNamedElements

      public List<NamedElement> getNamedElements()
      Gets the named elements.
      Returns:
      the named elements

    • isProtected

      public boolean isProtected()
      Checks if is protected.
      Returns:
      true, if is protected

    • setProtected

      public void setProtected​(boolean isProtected)
      Sets the protected.
      Parameters:
      isProtected - the new protected

    • getProtectionKey

      public String getProtectionKey()
      Gets the protection key.
      Returns:
      the protection key

    • setProtectionKey

      public void setProtectionKey​(String protectionKey)
      Sets the protection key.
      Parameters:
      protectionKey - the new protection key

    • isCaseSensitive

      public boolean isCaseSensitive()
      Checks if is case sensitive.
      Returns:
      true, if is case sensitive

    • setCaseSensitive

      public void setCaseSensitive​(boolean isCaseSensitive)
      Sets the case sensitive.
      Parameters:
      isCaseSensitive - the new case sensitive

    • usePrecisionAsShown

      public boolean usePrecisionAsShown()
      Use precision as shown.
      Returns:
      true, if successful

    • setUsePrecisionAsShown

      public void setUsePrecisionAsShown​(boolean usePrecisionAsShown)
      Sets the use precision as shown.
      Parameters:
      usePrecisionAsShown - the new use precision as shown

    • isApplySearchCriteriaToWholeCell

      public boolean isApplySearchCriteriaToWholeCell()
      Checks if is apply search criteria to whole cell.
      Returns:
      true, if is apply search criteria to whole cell

    • setApplySearchCriteriaToWholeCell

      public void setApplySearchCriteriaToWholeCell​(boolean applySearchCriteriaToWholeCell)
      Sets the apply search criteria to whole cell.
      Parameters:
      applySearchCriteriaToWholeCell - the new apply search criteria to whole cell

    • isAutomaticallyFindLabels

      public boolean isAutomaticallyFindLabels()
      Checks if is automatically find labels.
      Returns:
      true, if is automatically find labels

    • setAutomaticallyFindLabels

      public void setAutomaticallyFindLabels​(boolean automaticallyFindLabels)
      Sets the automatically find labels.
      Parameters:
      automaticallyFindLabels - the new automatically find labels

    • useRegularExpressions

      public boolean useRegularExpressions()
      Use regular expressions.
      Returns:
      true, if successful

    • setUseRegularExpressions

      public void setUseRegularExpressions​(boolean useRegularExpressions)
      Sets the use regular expressions.
      Parameters:
      useRegularExpressions - the new use regular expressions

    • getStartYear

      public int getStartYear()
      Gets the start year.
      Returns:
      the start year

    • setStartYear

      public void setStartYear​(int startYear)
      Sets the start year.
      Parameters:
      startYear - the new start year

    • getStartDateType

      public CellValueType getStartDateType()
      Gets the start date type.
      Returns:
      the start date type

    • setStartDateType

      public void setStartDateType​(CellValueType startDateType)
      Sets the start date type.
      Parameters:
      startDateType - the new start date type

    • getStartDate

      public String getStartDate()
      Gets the start date.
      Returns:
      the start date

    • setStartDate

      public void setStartDate​(String startDate)
      Sets the start date.
      Parameters:
      startDate - the new start date

    • isIterationStatus

      public boolean isIterationStatus()
      Checks if is iteration status.
      Returns:
      true, if is iteration status

    • setIterationStatus

      public void setIterationStatus​(boolean iterationStatus)
      Sets the iteration status.
      Parameters:
      iterationStatus - the new iteration status

    • getIterationStep

      public int getIterationStep()
      Gets the iteration step.
      Returns:
      the iteration step

    • setIterationStep

      public void setIterationStep​(int iterationStep)
      Sets the iteration step.
      Parameters:
      iterationStep - the new iteration step

    • getIterationMaximumDifference

      public double getIterationMaximumDifference()
      Gets the iteration maximum difference.
      Returns:
      the iteration maximum difference

    • setIterationMaximumDifference

      public void setIterationMaximumDifference​(double iterationMaximumDifference)
      Sets the iteration maximum difference.
      Parameters:
      iterationMaximumDifference - the new iteration maximum difference

    • getFonts

      public List<Font> getFonts()
      Gets the fonts.
      Returns:
      the fonts

    • getOfficeScripts

      public OfficeScripts getOfficeScripts()
      Gets the office scripts.
      Returns:
      the office scripts

    • getAutomaticStyles

      public AutomaticStyles getAutomaticStyles()
      Gets the automatic styles.
      Returns:
      the automatic styles

    • getCalculationSettings

      public CalculationSettings getCalculationSettings()
      Gets the calculation settings.
      Returns:
      the calculation settings

    • getLabelRanges

      public List<LabelRange> getLabelRanges()
      Gets the label ranges.
      Returns:
      the label ranges

    • getContentValidations

      public List<ContentValidation> getContentValidations()
      Gets the content validations.
      Returns:
      the content validations

    • getContent

      public SpreadsheetContent getContent()
      Gets the content.
      Returns:
      the content