GemBox.Spreadsheet by GemBox Software

API Diff between 39.3.30.1129 and 47.0.1095

54 Additions 279 Removals

GemBox.Spreadsheet

public abstract class AbstractRange
- public IEnumerable<FormattedCharacterRange> CharacterRanges { get; }
- public abstract void Calculate()
- protected virtual void ClearFormat()
- public abstract void Insert(InsertShiftDirection direction)
- public abstract void Remove(RemoveShiftDirection direction)
- public bool ReplaceText(string oldValue, string newValue)
- public bool ReplaceText(string oldValue, string newValue, bool matchCase)
- public bool ReplaceText(string oldValue, string newValue, bool matchCase, bool matchEntireCellContents)
- public bool ReplaceText(Regex regex, string replacement)
public sealed class AnchorCell : IEquatable<AnchorCell>
- public AnchorCell(ExcelCell cell, bool topLeft)
public enum BuiltInDocumentProperties
- DateContentCreated = 12
- DateLastPrinted = 14
- DateLastSaved = 13
public sealed class CellBorders
- public CellBorder GetUnresolvedBorder(IndividualBorder individualBorder)
public class CellRange : AbstractRange, IEnumerable, IEnumerable<ExcelCell>
- public bool FindText(string text, out int row, out int column)
- public bool FindText(string text, bool matchCase, out int row, out int column)
- public bool FindText(Regex regex, out int row, out int column)
- public CellRange GetCurrentRegion()
- public CellRange GetSubrange(string reference)
public class CellStyle
- public string NumberFormatLocal { get; }
- public TextDirection TextDirection { get; set; }
public class ComHelper
- public ExcelColumn GetColumn(object sheet, int index)
- public ExcelRow GetRow(object sheet, int index)
- public bool IsEncrypted(string path)
- public ExcelFile Load(string path)
- public ExcelFile LoadWithOptions(string path, object options)
- public ExcelFile LoadXlsxFromDirectory(string path)
- public void RemoveColumn(object sheet, int index)
- public void RemoveRow(object sheet, int index)
- public void SaveEntireFileToPdf(object file, string path)
- public void SaveWithOptions(object file, string path, object options)
- public void SaveXlsxToDirectory(object file, string path)
- public void SetFrozenWorksheetPanes(object sheet, string topLeftCell)
public sealed class CreateDataTableOptions
- public StringComparer ColumnHeadersComparer { get; set; }
public sealed class CsvLoadOptions : LoadOptions
- public bool HasFormulas { get; set; }
- public bool HasQuotedValues { get; set; }
- public NumberStyles NumberStyles { get; set; }
public sealed class CsvSaveOptions : SaveOptions
- public bool UseFormattedValues { get; set; }
public sealed class DigitalSignatureSaveOptions
- public object Certificate { get; set; }
- public string ContactInfo { get; set; }
- public string Location { get; set; }
- public ExcelDrawing Signature { get; set; }
- public bool UseMachineKeySet { get; set; }
public sealed class ExcelCell : AbstractRange, IFormatHolder<CellFormatData>, IExcelEditor<ExcelCellData>
- public static double ConvertDateTimeToExcelNumber(DateTime date, bool use1904DateSystem)
- public CellRange GetCurrentRegion()
- public void SetValue(string html, HtmlLoadOptions options)
public class ExcelComment : IExcelEditor<ExcelCommentData>
- public FormattedCharacterRange GetCharacters(int startIndex)
- public FormattedCharacterRange GetCharacters(int startIndex, int length)
public sealed class ExcelCommentCollection : IEnumerable, IEnumerable<ExcelComment>
- public bool Remove(ExcelComment item)
public abstract class ExcelDrawing
- public ExcelWorksheet Worksheet { get; }
public abstract class ExcelDrawingCollection<T> : IEnumerable<T>, IEnumerable, IList<T>, ICollection<T>, IExcelDrawingCollection where T : ExcelDrawing
- protected T Add(T item, string positionFromCell, string positionToCell)
- public void Move(int oldIndex, int newIndex)
public sealed class ExcelEmbeddedObject
public sealed class ExcelEmbeddedObjectCollection : IEnumerable<ExcelEmbeddedObject>, IEnumerable
public sealed class ExcelFile
- public bool AutomaticFormulaUpdate { get; set; }
- public CalculationOptions CalculationOptions { get; }
- public WorkbookProtection ProtectionSettings { get; }
- public static ExcelFile Load(Stream stream)
- public static ExcelFile LoadFromDirectory(string path, OdsLoadOptions options)
- public static ExcelFile LoadFromDirectory(string path, OdsLoadOptions options)
- public void Calculate()
- public ExcelFile Clone()
- public ExcelFilePaginator GetPaginator()
- public ExcelFilePaginator GetPaginator(PaginatorOptions options)
- public ImageSource ConvertToImageSource(ImageSaveOptions options)
- public XpsDocument ConvertToXpsDocument(XpsSaveOptions options)
- public void LoadXls(Stream stream, XlsOptions xlsOptions)
- public void LoadXls(Stream stream, XlsOptions xlsOptions)
- public void LoadXls(string path, XlsOptions xlsOptions)
- public void LoadXls(string path, XlsOptions xlsOptions)
- public void SaveToDirectory(string path, OdsSaveOptions options)
- public void SaveToDirectory(string path, OdsSaveOptions options)
public sealed class ExcelFilePage
public sealed class ExcelFilePaginator : IDocumentPaginator
public static class ExcelFileStore
public enum ExcelObjectSourceType
public sealed class ExcelPicture : ExcelDrawing
- public SpreadsheetColor? TransparentColor { get; set; }
public sealed class ExcelPictureCollection : ExcelDrawingCollection<ExcelPicture>
- public ExcelPicture Add(MemoryStream pictureStream, PositioningMode positioningMode, AnchorCell positionFrom, AnchorCell positionTo, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(MemoryStream pictureStream, PositioningMode positioningMode, AnchorCell positionFrom, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(MemoryStream pictureStream, PositioningMode positioningMode, AnchorCell positionFrom, int width, int height, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(MemoryStream pictureStream, PositioningMode positioningMode, Rectangle rectangle, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(MemoryStream pictureStream, Rectangle rectangle, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(string picturePath, PositioningMode positioningMode, AnchorCell positionFrom)
- public ExcelPicture Add(string picturePath, PositioningMode positioningMode, AnchorCell positionFrom, AnchorCell positionTo)
- public ExcelPicture Add(string picturePath, PositioningMode positioningMode, AnchorCell positionFrom, int width, int height)
- public ExcelPicture Add(string picturePath, PositioningMode positioningMode, Rectangle rectangle)
- public ExcelPicture Add(string picturePath, Rectangle rectangle)
- public ExcelPicture Add(string picturePath, double left, double top, double width, double height, LengthUnit unit, ExcelObjectSourceType sourceType)
- public ExcelPicture Add(string picturePath, double left, double top, LengthUnit unit, ExcelObjectSourceType sourceType)
- public ExcelPicture Add(string picturePath, AnchorCell positionFrom, double width, double height, LengthUnit unit, ExcelObjectSourceType sourceType)
- public ExcelPicture Add(string picturePath, string positionFromCell, double width, double height, LengthUnit unit, ExcelObjectSourceType sourceType)
- public ExcelPicture Add(string picturePath, AnchorCell positionFrom, ExcelObjectSourceType sourceType)
- public ExcelPicture Add(string picturePath, string positionFromCell, ExcelObjectSourceType sourceType)
- public ExcelPicture Add(string picturePath, AnchorCell positionFrom, AnchorCell positionTo, ExcelObjectSourceType sourceType)
- public ExcelPicture Add(string picturePath, string positionFromCell, string positionToCell, ExcelObjectSourceType sourceType)
- public ExcelPicture Add(MemoryStream pictureStream, PositioningMode positioningMode, AnchorCell positionFrom, AnchorCell positionTo, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(MemoryStream pictureStream, PositioningMode positioningMode, AnchorCell positionFrom, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(MemoryStream pictureStream, PositioningMode positioningMode, AnchorCell positionFrom, int width, int height, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(MemoryStream pictureStream, PositioningMode positioningMode, Rectangle rectangle, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(MemoryStream pictureStream, Rectangle rectangle, ExcelPictureFormat pictureFormat)
- public ExcelPicture Add(string picturePath, PositioningMode positioningMode, AnchorCell positionFrom)
- public ExcelPicture Add(string picturePath, PositioningMode positioningMode, AnchorCell positionFrom, AnchorCell positionTo)
- public ExcelPicture Add(string picturePath, PositioningMode positioningMode, AnchorCell positionFrom, int width, int height)
- public ExcelPicture Add(string picturePath, PositioningMode positioningMode, Rectangle rectangle)
- public ExcelPicture Add(string picturePath, Rectangle rectangle)
public enum ExcelPictureFormat
- Svg = 9
public sealed class ExcelPrintOptions
- public void SetPrinterSettings(string printerName, Stream xmlStream)
public sealed class ExcelRow : ExcelColumnRowBase
- public bool IsAutoFitted { get; }
- public void AutoFit(bool autoFitMergedRanges)
public abstract class ExcelRowColumnCollectionBase<T> : ExcelRowColumnCollectionBase, IEnumerable<T>, IEnumerable where T : ExcelColumnRowBase
- protected void FixAllIndexes(int index, int offset, int rowColumnIndex, int rowColumnLength)
- protected abstract void FixConditionalFormatRuleIndexes(int index, int offset, int rowColumnIndex, int rowColumnLength)
- protected abstract void FixDataValidationIndexes(int index, int offset, int rowColumnIndex, int rowColumnLength)
- protected abstract void FixFormulaReferencesIndexes(int index, int offset, int rowColumnIndex, int rowColumnLength)
- protected abstract void FixMergedRegionsIndexes(int index, int offset, int rowColumnIndex, int rowColumnLength)
- protected abstract void FixNamedRegionsIndexes(int index, int offset, int rowColumnIndex, int rowColumnLength)
- protected abstract void FixMergedRegionsIndexes(int index, int offset)
- protected abstract void FixNamedRegionsIndexes(int index, int offset)
- protected abstract void FixTableIndexes(int index, int offset, int rowColumnIndex, int rowColumnLength)
public sealed class ExcelShape : ExcelDrawing, IColorContext
public class ExcelShapeCollection : ExcelDrawingCollection<ExcelShape>
public sealed class ExcelWorksheet
- public ExcelPictureFormat BackgroundPictureFormat { get; }
- public MemoryStream BackgroundPictureStream { get; }
- public ExcelEmbeddedObjectCollection EmbeddedObjects { get; }
- public bool FilterMode { get; }
- public ProtectedRangeCollection ProtectedRanges { get; }
- public CellRangeCollection SelectedRanges { get; }
- public ExcelShapeCollection Shapes { get; }
- public TableCollection Tables { get; }
- public SheetType Type { get; }
- public void Calculate()
- public void DeleteBackgroundPicture()
- public void SetBackgroundPicture(MemoryStream pictureStream, ExcelPictureFormat pictureFormat)
- public void SetBackgroundPicture(string picturePath)
public sealed class ExcelWorksheetCollection : IEnumerable, IEnumerable<ExcelWorksheet>
- public ExcelWorksheet Add(SheetType type, string worksheetName)
- public ExcelWorksheet InsertEmpty(int worksheetIndex, SheetType type, string worksheetName)
public sealed class FixedWidthLoadOptions : LoadOptions
- public NumberStyles NumberStyles { get; set; }
public sealed class FormattedExcelDrawing
- public FrameworkElement Content { get; }
public sealed class HtmlLoadOptions : LoadOptions
- public NumberStyles NumberStyles { get; set; }
public sealed class ImageSaveOptions : SaveOptions
- public bool CropToContent { get; set; }
- public PixelFormat PixelFormat { get; set; }
- public TiffCompression TiffCompression { get; set; }
- public event EventHandler<OperationProgressChangedEventArgs> ProgressChanged
public enum InsertShiftDirection
public enum MultipleBorders
- Inside = 192
- InsideHorizontal = 64
- InsideVertical = 128
public static class NumberFormatBuilder
public class OperationProgressChangedEventArgs : ProgressChangedEventArgs
public abstract class PageBreakCollection<T> : PageBreakCollection, IEnumerable<T>, IEnumerable where T : PageBreak
- protected abstract int MaxLastLimit { get; }
public sealed class PaginatorOptions
public enum PdfConformanceLevel
public class PdfDigitalSignatureSaveOptions : DigitalSignatureSaveOptions, IPdfDigitalSigner
public enum PdfPermissions
- ModifyAnnotations = 128
public sealed class PdfSaveOptions : SaveOptions
- public PdfConformanceLevel ConformanceLevel { get; set; }
- public PdfDigitalSignatureSaveOptions DigitalSignature { get; set; }
- public DigitalSignatureSaveOptions DigitalSignature { get; }
- public int ImageDpi { get; set; }
- public event EventHandler<OperationProgressChangedEventArgs> ProgressChanged
public enum PixelFormat
public sealed class PrintOptions
- public PrintOptions(MemoryStream xmlStream)
public sealed class ProtectedRange
public sealed class ProtectedRangeCollection : IEnumerable<ProtectedRange>, IEnumerable
public enum RemoveShiftDirection
public enum SheetType
public sealed class SpreadsheetHyperlinkCollection : IEnumerable, IEnumerable<SpreadsheetHyperlink>
- public bool Remove(SpreadsheetHyperlink item)
public static class SpreadsheetInfo
- public static string FullVersion { get; }
- public static string Title { get; }
- public const string FullVersion = "39.3.30.1129"
- public const string Title = "GemBox.Spreadsheet 3.9 for .NET 3.0 - 4.5"
public enum TextDirection
public enum TiffCompression
public sealed class WorkbookProtection
public sealed class XlsLoadOptions : LoadOptions
- public string Password { get; set; }
- public XlsOptions PreserveOptions { get; set; }
- public bool PreserveUnsupportedFeatures { get; set; }
- public XlsOptions PreserveOptions { get; set; }
public enum XlsOptions
- None = 0
- PreserveAll = 15
- PreserveGlobalRecords = 1
- PreserveMacros = 8
- PreserveSummaries = 4
- PreserveWorksheetRecords = 2
public class XlsxDigitalSignatureSaveOptions : DigitalSignatureSaveOptions
public sealed class XlsxLoadOptions : LoadOptions
- public event EventHandler<OperationProgressChangedEventArgs> ProgressChanged
- public static bool IsEncrypted(string path)
- public static bool IsEncrypted(Stream stream)
public sealed class XlsxSaveOptions : SaveOptions
- public IList<XlsxDigitalSignatureSaveOptions> DigitalSignatures { get; }
- public bool EnableZip64 { get; set; }
- public int ImageDpi { get; set; }
- public event EventHandler<OperationProgressChangedEventArgs> ProgressChanged

GemBox.Spreadsheet.CalculationEngine

public sealed class CalculationOptions
public enum SpreadsheetCalculationError
public sealed class SpreadsheetCalculationException : SpreadsheetException
public sealed class SpreadsheetParserException : SpreadsheetException

GemBox.Spreadsheet.Charts

public sealed class AxisGridlines : IChartObject
- public FillFormat Fill { get; set; }
- public LineFormat Outline { get; set; }
public sealed class BarChart : ExcelChart
- public double SeriesGapWidth { get; set; }
- public double SeriesOverlap { get; set; }
public sealed class CategoryAxis : ChartAxis
- public int? LabelsInterval { get; set; }
- public int TickMarksInterval { get; set; }
public abstract class ChartAxis : IChartObject, IChartTitleParent
- public FillFormat Fill { get; set; }
- protected virtual bool IsDefaultMajorGridlinesVisible { get; }
- protected virtual bool IsDefaultMinorGridlinesVisible { get; }
- public LineFormat Outline { get; set; }
- public TextFormat TextFormat { get; set; }
public sealed class ChartDataLabels
public sealed class ChartLegend : IChartObject
- public FillFormat Fill { get; set; }
- public LineFormat Outline { get; set; }
- public TextFormat TextFormat { get; set; }
public sealed class ChartPlotArea : IChartObject
public class ChartSeries : IChartObject
- public ChartDataLabels DataLabels { get; }
- public DataPointCollection DataPoints { get; }
- public virtual FillFormat Fill { get; set; }
- public virtual LineFormat Outline { get; set; }
public abstract class ChartSeriesCollection : ICollection, IEnumerable, IList, IChartObject
- protected abstract int CountCore { get; }
- protected abstract IList ItemsCore { get; }
- protected abstract void CopyToCore(Array array, int index)
- protected abstract void ClearCore()
- protected abstract void MoveCore(int oldIndex, int newIndex)
- protected abstract void RemoveAtCore(int index)
public abstract class ChartSeriesCollection<T> : ChartSeriesCollection, IEnumerable<T>, IEnumerable, IList<T>, ICollection<T> where T : ChartSeries
- public int Count { get; }
- public void Clear()
- public void Move(int oldIndex, int newIndex)
- public void RemoveAt(int index)
public sealed class ChartTitle : IChartObject
- public FillFormat Fill { get; set; }
- public LineFormat Outline { get; set; }
- public TextFormat TextFormat { get; set; }
public enum ChartType
- Combo = 5
- Scatter = 6
public sealed class ColumnChart : ExcelChart
- public double SeriesGapWidth { get; set; }
- public double SeriesOverlap { get; set; }
public sealed class ComboChart : ExcelChart, IExcelChartCollection, IExcelDrawingCollection, IEnumerable, IEnumerable<ExcelChart>
public enum DataLabelPosition
public sealed class DataPoint : IChartObject, IColorContext
public sealed class DataPointCollection : IEnumerable<DataPoint>, IEnumerable, IChartObject
public abstract class ExcelChart : ExcelDrawing, IChartObject, IChartTitleParent
- protected static readonly DataLabelPosition[] allSupportedDataLabelPositions
- public ChartDataLabels DataLabels { get; }
- protected virtual DataLabelPosition DefaultDataLabelPosition { get; }
- protected virtual string DefaultDataLabelSeparator { get; }
- public FillFormat Fill { get; set; }
- public LineFormat Outline { get; set; }
- public ChartPlotArea PlotArea { get; }
- public bool RoundedCorners { get; set; }
- protected virtual IList<DataLabelPosition> SupportedDataLabelPositions { get; }
- public TextFormat TextFormat { get; set; }
- protected void ImportCategoryLabels(ExcelChart source)
public sealed class LineChartSeries : ChartSeries
- public Marker Marker { get; }
public sealed class Marker : IChartObject
- public FillFormat Fill { get; set; }
- public LineFormat Outline { get; set; }
public abstract class MarkerChartSeries : ChartSeries
public sealed class ScatterChart : ExcelChart
public sealed class ScatterChartSeries : MarkerChartSeries
public sealed class ScatterChartSeriesCollection : ChartSeriesCollection<ScatterChartSeries>

GemBox.Spreadsheet.ConditionalFormatting

public sealed class ConditionalFormatRule
- public void Calculate()
- public bool Matches(ExcelCell cell)
public sealed class ConditionalFormatRuleCollection : IEnumerable, IEnumerable<ConditionalFormatRule>
- public void Calculate()

GemBox.Spreadsheet.Drawing

public enum CapsType
public class Content : IContent
public struct DrawingColor : IEquatable<DrawingColor>
public enum DrawingColorName
public enum DrawingUnderlineStyle
public abstract class FillFormat
public enum FillFormatType
public enum HorizontalAlignment
public struct Length : IComparable<Length>, IEquatable<Length>, IFormattable
public struct LineArrow : IEquatable<LineArrow>
public enum LineArrowSize
public enum LineArrowType
public enum LineCapType
public enum LineCompoundType
public enum LineDashType
public sealed class LineFormat
public enum LineJoinType
public enum ListBulletType
public enum ListNumberType
public enum ListType
public sealed class PatternFillFormat : FillFormat
public enum PatternFillType
public enum PictureCompressionType
public sealed class PictureContent : IPictureContent
public enum PictureContentType
public enum ShapeType
public sealed class SolidFillFormat : FillFormat
public enum StrikethroughType
public enum TextAutoFit
public class TextBox : IColorContext
public sealed class TextBoxFormat
public enum TextDirection
public abstract class TextElement : IColorContext
public class TextElementCollection : IEnumerable<TextElement>, IEnumerable
public enum TextElementType
public class TextField : TextElement
public sealed class TextFormat
public class TextLineBreak : TextElement
public sealed class TextListFormat
public class TextParagraph : IColorContext
public class TextParagraphCollection : IEnumerable<TextParagraph>, IEnumerable
public sealed class TextParagraphFormat
public class TextRun : TextElement
public struct TextSpacing : IEquatable<TextSpacing>
public enum VerticalAlignment

GemBox.Spreadsheet.PivotTables

public sealed class PivotCache
- public void ChangeWorksheetSource(string reference)
public sealed class PivotField
- public PivotTableSortOptions SortOptions { get; }
- public void ClearSort()
- public void Collapse(bool collapsed)
- public void Sort(bool descending)
- public void Sort(bool descending, PivotField sortByDataField, PivotItem[] sortByPivotItems)
public sealed class PivotFilter
public sealed class PivotFilterCollection : IEnumerable<PivotFilter>, IEnumerable
public sealed class PivotItem
- public bool Collapsed { get; set; }
public sealed class PivotTable
- public bool ClassicPivotTableLayout { get; set; }
- public PivotTableFilter Filter { get; }
- public bool ShowDataTips { get; set; }
- public bool ShowDrill { get; set; }
- public bool ShowDropZones { get; set; }
- public bool ShowEmptyColumn { get; set; }
- public bool ShowEmptyRow { get; set; }
- public bool ShowError { get; set; }
public sealed class PivotTableFilter
public sealed class PivotTableSortOptions

GemBox.Spreadsheet.Security

public class Certificate : IDigitalId
public enum DigitalSignatureCommitmentType

GemBox.Spreadsheet.Tables

public enum BuiltInTableStyleName
public sealed class Table
public sealed class TableAlternativeText
public sealed class TableCollection : IEnumerable<Table>, IEnumerable
public sealed class TableColumn
public sealed class TableColumnCollection : IEnumerable<TableColumn>, IEnumerable
public sealed class TableRowCollection
public enum TableStyleOptions
public enum TotalsRowFunction

GemBox.Spreadsheet.Xls

public enum XlsOptions