API Reference
OdsCell
An XML-backed ODS cell produced without expanding surrounding repeat runs.
Inheritance
- Object
- OdsCell
Usage
Explore 2 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 2
- Method OdsSheet.Cell
- Method OdsSheet.Merge
Methods
public OdsAnnotation AddAnnotation(String text, String? creator = null, DateTimeOffset? date = null, String? name = null) #OdsAnnotationAdds an annotation to this cell.
Parameters
- text System.String
- creator System.String? = null
- date System.DateTimeOffset? = null
- name System.String? = null
public Void ClearValue() #VoidClears value content while retaining style, formula, validation, and annotations.
public Void SetBoolean(Boolean value) #VoidSets a boolean value.
Parameters
- value System.Boolean
public Void SetCurrency(Decimal value, String currencyCode) #VoidSets a currency amount and ISO currency code.
Parameters
- value System.Decimal
- currencyCode System.String
public Void SetDate(DateTime value) #VoidSets a local date or date-time value.
Parameters
- value System.DateTime
public Void SetDateTime(DateTimeOffset value) #VoidSets an offset-aware date-time value.
Parameters
- value System.DateTimeOffset
public Void SetDecimal(Decimal value) #VoidSets a decimal without a binary floating-point round trip.
Parameters
- value System.Decimal
public Void SetDuration(TimeSpan value) #VoidSets a duration. ODF stores both time-of-day and duration values as ISO durations.
Parameters
- value System.TimeSpan
public Void SetHyperlink(String text, String href) #VoidSets a hyperlink display value without fetching its target.
Parameters
- text System.String
- href System.String
public Void SetPercentage(Decimal value) #VoidSets a percentage from a fractional value, where 0.25 represents 25%.
Parameters
- value System.Decimal
public Void SetString(String? value) #VoidSets a string value and display text.
Parameters
- value System.String?
public Void SetTime(TimeSpan value) #VoidSets a time-of-day using the ODF duration representation.
Parameters
- value System.TimeSpan
public Boolean TransformTextCase(OfficeTextCase textCase, CultureInfo? culture = null) #BooleanTransforms stored string text while retaining the cell style.
Parameters
- textCase OfficeIMO.Drawing.OfficeTextCase
- culture System.Globalization.CultureInfo? = null
Returns
true when a string value was transformed; otherwise false.
Inherited Methods
public virtual Boolean Equals(Object? obj) #BooleanParameters
- obj Object?
Properties
public Boolean IsCovered { get; } #True when this position is covered by a merged cell.
public String? Formula { get; set; } #Raw OpenFormula expression, including any namespace prefix.
public OdsAnnotation? Annotation { get; } #The annotation attached to this cell, when present.
public IReadOnlyList<OdsAnnotation> Annotations { get; } #Annotation elements present on this cell. Conforming ODF permits at most one.
public String? NumberFormatName { get; set; } #Referenced number/date/time data style through the cell style.
public OdfTextDecorationStyle? UnderlineStyle { get; set; } #Explicit or inherited native underline pattern.
public OdfTextDecorationType? UnderlineType { get; set; } #Explicit or inherited underline line count.
public Boolean? StrikeThrough { get; set; } #Explicit or inherited strikethrough state.
public OdfTextDecorationStyle? LineThroughStyle { get; set; } #Explicit or inherited native strikethrough pattern.
public OdfTextDecorationType? LineThroughType { get; set; } #Explicit or inherited strikethrough line count.
public OdfTextPosition? TextPosition { get; set; } #Explicit or inherited baseline placement.
public OdfTextTransform? TextTransform { get; set; } #Explicit or inherited display-time case transformation.
public Boolean? SmallCaps { get; set; } #Explicit or inherited small-cap display formatting.
public OdfColor? BackgroundColor { get; set; } #Explicit or inherited cell background color.
public String? TextAlign { get; set; } #Explicit or inherited horizontal text alignment token.
public String? TextAlignSource { get; set; } #Explicit or inherited table-cell horizontal alignment source token.
public String? VerticalAlign { get; set; } #Explicit or inherited table-cell vertical alignment token.
public String? WrapOption { get; set; } #Explicit or inherited table-cell wrapping token.