DeleteBlankOptions
Inheritance: java.lang.Object, com.aspose.cells.DeleteOptions
public class DeleteBlankOptions extends DeleteOptions
Represents the setting of deleting blank cells/rows/columns.
Constructors
| Constructor | Description |
|---|---|
| DeleteBlankOptions() |
Methods
| Method | Description |
|---|---|
| equals(Object arg0) | |
| getClass() | |
| getEmptyFormulaValueAsBlank() | Whether one cell will be taken as blank when it is formula and the calculated result is null or empty string. |
| getEmptyStringAsBlank() | Whether one cell will be taken as blank when its value is empty string. |
| getUpdateReference() | Indicates if update references in other worksheets. |
| hashCode() | |
| notify() | |
| notifyAll() | |
| setEmptyFormulaValueAsBlank(boolean value) | Whether one cell will be taken as blank when it is formula and the calculated result is null or empty string. |
| setEmptyStringAsBlank(boolean value) | Whether one cell will be taken as blank when its value is empty string. |
| setUpdateReference(boolean value) | Indicates if update references in other worksheets. |
| toString() | |
| wait() | |
| wait(long arg0) | |
| wait(long arg0, int arg1) |
DeleteBlankOptions()
public DeleteBlankOptions()
equals(Object arg0)
public boolean equals(Object arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | java.lang.Object |
Returns: boolean
getClass()
public final native Class<?> getClass()
Returns: java.lang.Class
getEmptyFormulaValueAsBlank()
public boolean getEmptyFormulaValueAsBlank()
Whether one cell will be taken as blank when it is formula and the calculated result is null or empty string. Default value is false.
Remarks
Generally user should make sure the formulas have been calculated before deleting operation with this property as true. Otherwise all newly cretaed formulas by normal apis such as Cell.getFormula() will be taken as blank and may be deleted because before calculation their calculated results are all null.
Returns: boolean
getEmptyStringAsBlank()
public boolean getEmptyStringAsBlank()
Whether one cell will be taken as blank when its value is empty string. Default value is true.
Returns: boolean
getUpdateReference()
public boolean getUpdateReference()
Indicates if update references in other worksheets.
Returns: boolean
hashCode()
public native int hashCode()
Returns: int
notify()
public final native void notify()
notifyAll()
public final native void notifyAll()
setEmptyFormulaValueAsBlank(boolean value)
public void setEmptyFormulaValueAsBlank(boolean value)
Whether one cell will be taken as blank when it is formula and the calculated result is null or empty string. Default value is false.
Remarks
Generally user should make sure the formulas have been calculated before deleting operation with this property as true. Otherwise all newly cretaed formulas by normal apis such as Cell.getFormula() will be taken as blank and may be deleted because before calculation their calculated results are all null.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setEmptyStringAsBlank(boolean value)
public void setEmptyStringAsBlank(boolean value)
Whether one cell will be taken as blank when its value is empty string. Default value is true.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
setUpdateReference(boolean value)
public void setUpdateReference(boolean value)
Indicates if update references in other worksheets.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | boolean |
toString()
public String toString()
Returns: java.lang.String
wait()
public final void wait()
wait(long arg0)
public final native void wait(long arg0)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
| Parameter | Type | Description |
|---|---|---|
| arg0 | long | |
| arg1 | int |