Tabnine Logo
BaseCellFeatures
Code IndexAdd Tabnine to your IDE (free)

How to use
BaseCellFeatures
in
jxl.biff

Best Java code snippets using jxl.biff.BaseCellFeatures (Showing top 20 results out of 315)

origin: com.hynnet/jxl

/**
 * Accessor for the cell comment
 *
 * @return the cell comment, or NULL if this cell doesn't have
 *         a comment associated with it
 */
public String getComment()
{
 return super.getComment();
}
origin: net.sourceforge.jexcelapi/jxl

/**
 * Gets the data validation list
 *
 * @return the data validation list
 */
public String getDataValidationList()
{
 return super.getDataValidationList();
}
origin: net.sourceforge.jexcelapi/jxl

 /**
  * Gets the range of cells to which the data validation applies.  If the
  * validation applies to just this cell, this will be reflected in the 
  * returned range
  *
  * @return the range to which the same validation extends, or NULL if this
  *         cell doesn't have a validation
  */
 public Range getSharedDataValidationRange()
 {
  return super.getSharedDataValidationRange();
 }
}
origin: net.sourceforge.jexcelapi/jxl

/**
 * Use the same data validation logic as the specified cell features
 *
 * @param cf the data validation to reuse
 */
public void shareDataValidation(BaseCellFeatures source)
{
 if (dataValidation)
 {
  logger.warn("Attempting to share a data validation on cell " + 
        CellReferenceHelper.getCellReference(writableCell) + 
        " which already has a data validation");
  return;
 }
 clearValidationSettings();
 dvParser = source.getDVParser();
 validationSettings = null;
 dataValidation = true;
 dropDown = source.dropDown;
 comboBox = source.comboBox;
}
origin: com.hynnet/jxl

/**
 * Sets the cell comment
 *
 * @param s the comment
 */
public void setComment(String s)
{
 setComment(s, defaultCommentWidth, defaultCommentHeight);
}
origin: net.sourceforge.jexcelapi/jxl

/**
 * Internal function which removes any data validation, including
 * shared ones, if present.  This is called from WritableSheetImpl
 * in response to a call to removeDataValidation
 */
public void removeSharedDataValidation()
{
 if (!dataValidation)
 {
  return;
 }
 // Remove the validation from the WritableSheet object if present
 writableCell.removeDataValidation();
 clearValidationSettings();
}
origin: net.sourceforge.jexcelapi/jxl

 /**
  * Gets the range of cells to which the data validation applies.  If the
  * validation applies to just this cell, this will be reflected in the 
  * returned range
  *
  * @return the range to which the same validation extends, or NULL if this
  *         cell doesn't have a validation
  */
 public Range getSharedDataValidationRange()
 {
  if (!dataValidation)
  {
   return null;
  }
  
  DVParser dvp = getDVParser();

  return new SheetRangeImpl(writableCell.getSheet(),
               dvp.getFirstColumn(),
               dvp.getFirstRow(),
               dvp.getLastColumn(),
               dvp.getLastRow());
 }
}
origin: com.hynnet/jxl

/**
 * Use the same data validation logic as the specified cell features
 *
 * @param cf the data validation to reuse
 */
public void shareDataValidation(BaseCellFeatures source)
{
 if (dataValidation)
 {
  logger.warn("Attempting to share a data validation on cell " + 
        CellReferenceHelper.getCellReference(writableCell) + 
        " which already has a data validation");
  return;
 }
 clearValidationSettings();
 dvParser = source.getDVParser();
 validationSettings = null;
 dataValidation = true;
 dropDown = source.dropDown;
 comboBox = source.comboBox;
}
origin: net.sourceforge.jexcelapi/jxl

/**
 * Sets the cell comment
 *
 * @param s the comment
 */
public void setComment(String s)
{
 setComment(s, defaultCommentWidth, defaultCommentHeight);
}
origin: com.hynnet/jxl

/**
 * Internal function which removes any data validation, including
 * shared ones, if present.  This is called from WritableSheetImpl
 * in response to a call to removeDataValidation
 */
public void removeSharedDataValidation()
{
 if (!dataValidation)
 {
  return;
 }
 // Remove the validation from the WritableSheet object if present
 writableCell.removeDataValidation();
 clearValidationSettings();
}
origin: com.hynnet/jxl

 /**
  * Gets the range of cells to which the data validation applies.  If the
  * validation applies to just this cell, this will be reflected in the 
  * returned range
  *
  * @return the range to which the same validation extends, or NULL if this
  *         cell doesn't have a validation
  */
 public Range getSharedDataValidationRange()
 {
  if (!dataValidation)
  {
   return null;
  }
  
  DVParser dvp = getDVParser();

  return new SheetRangeImpl(writableCell.getSheet(),
               dvp.getFirstColumn(),
               dvp.getFirstRow(),
               dvp.getLastColumn(),
               dvp.getLastRow());
 }
}
origin: com.hynnet/jxl

/**
 * Sets the data validation based upon a named range
 */
public void setDataValidationRange(String namedRange)
{
 if (dataValidation && getDVParser().extendedCellsValidation())
 {
  logger.warn("Cannot set data validation on " + 
        CellReferenceHelper.getCellReference(writableCell) + 
        " as it is part of a shared data validation");
  return;
 }
 clearValidationSettings();
 dvParser = new DVParser(namedRange);
 dropDown = true;
 dataValidation = true;
}
origin: net.sourceforge.jexcelapi/jxl

/**
 * Accessor for the cell comment
 *
 * @return the cell comment, or NULL if this cell doesn't have
 *         a comment associated with it
 */
public String getComment()
{
 return super.getComment();
}
origin: com.hynnet/jxl

 /**
  * Gets the range of cells to which the data validation applies.  If the
  * validation applies to just this cell, this will be reflected in the 
  * returned range
  *
  * @return the range to which the same validation extends, or NULL if this
  *         cell doesn't have a validation
  */
 public Range getSharedDataValidationRange()
 {
  return super.getSharedDataValidationRange();
 }
}
origin: com.hynnet/jxl

/**
 * Gets the data validation list
 *
 * @return the data validation list
 */
public String getDataValidationList()
{
 return super.getDataValidationList();
}
origin: com.hynnet/jxl

/**
 * The list of items to validate for this cell in the form of a cell range.
 *
 * @param c the list of valid values
 */
public void setDataValidationRange(int col1, int r1, int col2, int r2)
{
 if (dataValidation && getDVParser().extendedCellsValidation())
 {
  logger.warn("Cannot set data validation on " + 
        CellReferenceHelper.getCellReference(writableCell) + 
        " as it is part of a shared data validation");
  return;
 }
 clearValidationSettings();
 dvParser = new DVParser(col1, r1, col2, r2);
 dropDown = true;
 dataValidation = true;
}
origin: net.sourceforge.jexcelapi/jxl

/**
 * The list of items to validate for this cell in the form of a cell range.
 *
 * @param c the list of valid values
 */
public void setDataValidationRange(int col1, int r1, int col2, int r2)
{
 if (dataValidation && getDVParser().extendedCellsValidation())
 {
  logger.warn("Cannot set data validation on " + 
        CellReferenceHelper.getCellReference(writableCell) + 
        " as it is part of a shared data validation");
  return;
 }
 clearValidationSettings();
 dvParser = new DVParser(col1, r1, col2, r2);
 dropDown = true;
 dataValidation = true;
}
origin: net.sourceforge.jexcelapi/jxl

/**
 * Sets the data validation based upon a named range
 */
public void setDataValidationRange(String namedRange)
{
 if (dataValidation && getDVParser().extendedCellsValidation())
 {
  logger.warn("Cannot set data validation on " + 
        CellReferenceHelper.getCellReference(writableCell) + 
        " as it is part of a shared data validation");
  return;
 }
 clearValidationSettings();
 dvParser = new DVParser(namedRange);
 dropDown = true;
 dataValidation = true;
}
origin: net.sourceforge.jexcelapi/jxl

/**
 * The list of items to validate for this cell.  For each object in the 
 * collection, the toString() method will be called and the data entered
 * will be validated against that string
 *
 * @param c the list of valid values
 */
public void setDataValidationList(Collection c)
{
 if (dataValidation && getDVParser().extendedCellsValidation())
 {
  logger.warn("Cannot set data validation on " + 
        CellReferenceHelper.getCellReference(writableCell) + 
        " as it is part of a shared data validation");
  return;
 }
 clearValidationSettings();
 dvParser = new DVParser(c);
 dropDown = true;
 dataValidation = true;
}
origin: net.sourceforge.jexcelapi/jxl

public void setNumberValidation(double val1, double val2, 
                ValidationCondition c)
{
 if (dataValidation && getDVParser().extendedCellsValidation())
 {
  logger.warn("Cannot set data validation on " + 
        CellReferenceHelper.getCellReference(writableCell) + 
        " as it is part of a shared data validation");
  return;
 }
 clearValidationSettings();
 dvParser = new DVParser(val1, val2, c.getCondition());
 dropDown = false;
 dataValidation = true;
}
jxl.biffBaseCellFeatures

Javadoc

Container for any additional cell features

Most used methods

  • clearValidationSettings
    Clears out any existing validation settings
  • getComment
    Accessor for the cell comment
  • getDVParser
    Gets the dv parser
  • getDataValidationList
    Gets the data validation list as a formula. Used only when reading
  • getSharedDataValidationRange
    Gets the range of cells to which the data validation applies. If the validation applies to just this
  • setComment
    Sets the cell comment

Popular in Java

  • Reading from database using SQL prepared statement
  • putExtra (Intent)
  • orElseThrow (Optional)
    Return the contained value, if present, otherwise throw an exception to be created by the provided s
  • onRequestPermissionsResult (Fragment)
  • Rectangle (java.awt)
    A Rectangle specifies an area in a coordinate space that is enclosed by the Rectangle object's top-
  • ConnectException (java.net)
    A ConnectException is thrown if a connection cannot be established to a remote host on a specific po
  • SecureRandom (java.security)
    This class generates cryptographically secure pseudo-random numbers. It is best to invoke SecureRand
  • ReentrantLock (java.util.concurrent.locks)
    A reentrant mutual exclusion Lock with the same basic behavior and semantics as the implicit monitor
  • JTable (javax.swing)
  • LogFactory (org.apache.commons.logging)
    Factory for creating Log instances, with discovery and configuration features similar to that employ
  • Best IntelliJ plugins
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogTabnine AcademyTerms of usePrivacy policyJava Code IndexJavascript Code Index
Get Tabnine for your IDE now