VintaSoft Imaging .NET SDK 14.1: Documentation for .NET developer
Vintasoft.Imaging.Office.Spreadsheet.Functions Namespace
/ SupportedFunctions Class
Properties
Methods
SeeAlso
Collapse All
Expand All
In This Topic
About VintaSoft Imaging .NET SDK
Overview
History
VintaSoft Annotation .NET Plug-in
VintaSoft Annotation .NET Plug-in: Overview
VintaSoft Annotation .NET Plug-in: History
VintaSoft PDF .NET Plug-in
VintaSoft PDF .NET Plug-in: Overview
VintaSoft PDF .NET Plug-in: History
VintaSoft JBIG2 .NET Plug-in
VintaSoft JBIG2 .NET Plug-in: Overview
VintaSoft JBIG2 .NET Plug-in: History
VintaSoft JPEG2000 .NET Plug-in
VintaSoft JPEG2000 .NET Plug-in: Overview
VintaSoft JPEG2000 .NET Plug-in: History
VintaSoft OCR .NET Plug-in
VintaSoft OCR .NET Plug-in: Overview
VintaSoft OCR .NET Plug-in: History
VintaSoft Document Cleanup .NET Plug-in
VintaSoft Document Cleanup .NET Plug-in: Overview
VintaSoft Document Cleanup .NET Plug-in: History
VintaSoft DICOM .NET Plug-in
VintaSoft DICOM .NET Plug-in: Overview
VintaSoft DICOM .NET Plug-in: History
VintaSoft Forms Processing .NET Plug-in
VintaSoft Forms Processing .NET Plug-in: Overview
VintaSoft Forms Processing .NET Plug-in: History
VintaSoft Office .NET Plug-in
VintaSoft Office .NET Plug-in: Overview
VintaSoft Office .NET Plug-in: History
Licensing
How to use evaluation version
The License Agreement
Getting Started
Operating requirements
Installing VintaSoft Imaging .NET SDK
Updating VintaSoft Imaging .NET SDK
Learning
Information sources
Demo Applications Overview
Programming
Load images
Capture images
Capture images from cameras
View images
WinForms controls
View images
View thumbnails
Visual tools
Overview of visual tools
VisualTool class
GraphicObjectTool class
HighlightTool class
CustomSelectionTool class
UserInteractionVisualTool class
CompositeVisualTool class
How to's
How to select/deselect thumbnails?
How to speed up image preview process?
How to determine that image is visible in the image viewer?
How to change thumbnail appearance?
How to draw text on thumbnails?
How to load and view images in ImageViewer with different rendering settings?
How to use the external scroll bars with image viewer?
How to change the image brightness in image viewer?
How to start animation in image viewer?
WPF controls
View images
View thumbnails
Visual tools
Overview of visual tools
WpfVisualTool class
WpfGraphicObjectTool class
WpfHighlightTool class
WpfCustomSelectionTool class
WpfUserInteractionVisualTool class
WpfCompositeVisualTool class
How to's
How to use the external scroll bars with WPF image viewer?
How to add text on thumbnails in WPF thumbnail viewer?
How to change brightness of image on image viewer?
How to start animation in image viewer?
Fonts
Install TrueType fonts on Linux
2D graphics
Draw 2D graphics
Draw 2D graphics using GDI+
Overview
How to's
How to convert System.Drawing.Bitmap to VintasoftImage?
How to convert VintasoftImage to System.Drawing.Bitmap?
Draw 2D graphics using SkiaSharp
Overview
Render images
Process images
Overview of image processing
Processing command features
Custom processing command
Undo/redo changes in images
How to's
How to detect orientation of document image
Color Management
Print images
Print images using System.Drawing
Print images in WPF
Annotate images
Overview of image annotating
Annotation data
Save and load annotations
Save and load annotations
WANG annotations
Annotation view
Annotation view in WinForms
Annotation view in WPF
Link between image and annotation data collection
Link between annotation data and view collections
Link between annotation data and view collections in WinForms
Link between annotation data and view collections in WPF
Build and transform annotations
Build and transform annotations in WinForms
Build and transform annotations in WPF
Change visual appearance of interactive points of annotations
Change visual appearance of interactive points of annotations in WinForms
Change visual appearance of interactive points of annotations in WPF
View images with annotations
WinForms controls
View images with annotations in WinForms
View thumbnails with annotations in WinForms
View and transform annotations, interact with annotations in WinForms
WPF controls
View images with annotations in WPF
View thumbnails with annotations in WPF
View and transform annotations, interact with annotations in WPF
How to's
How to filter annotations while loading?
How to create square annotations?
How to get information about annotations of TIFF file?
How to annotate TIFF file?
How to annotate PDF document?
How to rotate image with annotations?
How to create custom annotation
How to create custom triangle annotation?
How to create custom mark annotation?
Image metadata
OCR
Introduction
Prepare image for text recognition
Prepare OCR engine for text recognition
Recognize text in an image
Obtain and edit the OCR results
Save the OCR results to a text file
Save the OCR results to a searchable PDF document
How to's
How to run OCR in image region?
How to convert an image-only PDF document to a searchable PDF document?
How to convert TIFF file to a searchable PDF document?
How to acquire image from scanner and generate searchable PDF document?
How to analyze layout of document image using Tesseract OCR
How to recognize only digits?
How to recognize MICR E-13B characters from image?
How to recognize MRZ characters from image?
How to recognize text in two languages?
How to export the OCR result to hOCR file?
How to import the OCR result from hOCR file?
How to use result from other OCR engine?
How to use other OCR engine?
ICR
Recognize handwritten digits
Save images
Save image
Save image collection
How to's
How to save image with the same encoder settings?
Image codecs
Overview of codecs architecture
Advanced functionality for image decoding
Advanced functionality for image encoding
An example of custom BMP codec
An example of custom raster grid codec
TIFF
Overview
How to's
How to get information about TIFF file?
How to add image to TIFF file?
How to add image collection to TIFF file?
How to remove page from TIFF file?
How to merge TIFF files?
How to split TIFF file?
How to convert TIFF file to a big TIFF file?
How to get information about tags of TIFF file?
How to modify tags of TIFF file?
How to annotate TIFF file?
JBIG2
Overview
How to's
How to get information about JBIG2 document?
How to add image to JBIG2 file?
How to add images to JBIG2 document?
How to remove page from JBIG2 document?
How to merge JBIG2 documents?
How to reach the best results at encoding?
JPEG
How to 's
JPEG: How to get a quality value of JPEG image?
JPEG2000
Overview
How to's
How to get information about JPEG2000 image?
How to's
How to convert TIFF to PDF?
How to convert TIFF to PDF/A?
How to convert TIFF to JBIG2?
How to convert JBIG2 to TIFF?
How to convert JPEG to JPEG2000?
How to convert JPEG2000 to TIFF?
How to convert PDF to DOCX?
PDF
Working with PDF document
Create PDF document
Load PDF document
Print PDF document
Print PDF document using System.Drawing
Verify PDF document
Working with PDF page
Working with pages of PDF document
Render PDF content
Render PDF page
Customize rendering of PDF content
Search and extract text in PDF document
Working with actions of PDF document
Navigate PDF document
Working with fonts of PDF document
Working with image resources of PDF document
Working with templates of PDF document
Working with embedded files of PDF document
Working with portfolio of PDF document
Edit content of PDF page
Draw graphics on PDF page
Edit content of PDF page programmatically
Edit content of PDF page in WPF viewer
Edit content of PDF page in WinForms viewer
Remove content from PDF page
Work with annotations of PDF document
Annotate PDF document
Working with PDF annotations of PDF document
View PDF annotations of PDF document
View PDF annotations of PDF document in WinForms
View PDF annotations of PDF document in WPF
Edit PDF annotations of PDF document
Edit PDF annotations of PDF document in WinForms
Edit PDF annotations of PDF document in WPF
Working with optional content of PDF document
Interactive forms of PDF document
Interactive fields of PDF document
Working with interactive fields of PDF document
Get information about fields of PDF interactive form
Extract field values from PDF interactive form
Add field to the PDF interactive form
Add field to the PDF interactive form
Add a check box field to the PDF interactive form
Add a pushbutton field to the PDF interactive form
Add a group of radio buttons field to the PDF interactive form
Add a combo box field to the PDF interactive form
Add a list box field to the PDF interactive form
Add a text input field to the PDF interactive form
Add a barcode field to the PDF interactive form
Add a signature field to the PDF interactive form
Change field value in PDF interactive form
Remove field from PDF interactive form
Work with actions of PDF interactive form field
Work with actions of PDF interactive form field
Add a JavaScript calculator to a PDF interactive form
Add a 'Submit' action button to a PDF interactive form
Add an 'Import' action button to a PDF interactive form
Import and export data of PDF interactive form
View interactive fields of PDF document
View interactive fields of PDF document in WinForms
View interactive fields of PDF document in WPF
Edit interactive fields of PDF document in viewer
Edit interactive fields of PDF document in WinForms
Edit interactive fields of PDF document in WPF
Low level access to the structure of PDF document
Protect PDF document
Use digital signatures in PDF document
Optimize and compress PDF document
Optimize and compress PDF document
Use MRC compression for encoding PDF document
Convert PDF document
Save PDF document
How to's
How to split PDF document?
How to merge PDF documents?
How to convert a text file to a PDF document?
How to convert PDF to TIFF?
How to convert PDF to SVG?
How to convert PDF to DOCX?
Office
DOCX
DOCX: Overview
Render pages of DOCX document
Programmatically edit DOCX document using low-lewel editor
How to's
How to set layout settings of DOCX document?
How to convert DOCX to PDF?
How to convert DOCX to TIFF?
How to convert DOCX to PNG?
How to convert DOCX to SVG?
How to convert DOCX to HTML?
How to convert DOCX to a text file?
How to convert DOC to DOCX?
How to convert RTF to DOCX?
How to convert PDF to DOCX?
How to convert HTML to DOCX?
How to convert ODT to DOCX?
How to work with secured DOCX file?
XLSX
XLSX: Overview
Render pages of XLSX document
Programmatically edit XLSX document using low-level editor
Programmatically edit a spreadsheet document using high-level editor
Edit a spreadsheet document in spreadsheet editor control
Edit a spreadsheet document in WinForms spreadsheet editor control
Edit a spreadsheet document in WPF spreadsheet editor control
Work with worksheets in XLSX document
Work with cell rows on XLSX page
Work with cell columns on XLSX page
Work with cells on XLSX page
Work with formulas on XLSX page
Work with drawing objects on XLSX page
Work with charts on XLSX page
Work with comments on XLSX page
How to's
How to set layout settings of XLSX document?
How to convert XLSX to PDF?
How to convert XLSX to TIFF?
How to convert XLSX to PNG?
How to convert XLS to XLSX?
How to convert ODS to XLSX?
How to work with secured XLSX file?
DICOM
Working with DICOM files
View DICOM images
View DICOM images in WinForms
View DICOM images in WPF
Annotate DICOM images
Annotate DICOM images
Annotate DICOM images in WinForms
Annotate DICOM images in WPF
DICOM MPR
DICOM Multiplanar reconstruction
View DICOM multiplanar reconstruction in WinForms
View DICOM multiplanar reconstruction in WPF
Forms Processing
Introduction to the forms processing
Form template
Forms identification and recognition
Forms identification and recognition
Identify and recognize a document that contains only one form
Identify and recognize a document that contains several forms
Identify and recognize a document that contains forms with marks
Identify and recognize a document that contains forms with text
Identify and recognize a document that contains forms with handwritten digits
Identify and recognize a document that contains forms with barcodes
Identification of document image
Localization
Localize VintaSoft Imaging .NET SDK
Localize VintaSoft .NET assembly
Localize VintaSoft WinForms demo project
Deploying
Deploying VintaSoft Imaging .NET SDK
API References
.NET API Reference
Vintasoft.Imaging Assembly
Vintasoft.Imaging.Annotation Assembly
Vintasoft.Imaging.Annotation.Dicom Assembly
Vintasoft.Imaging.Annotation.Dicom.UI Assembly
Vintasoft.Imaging.Annotation.Dicom.Wpf.UI Assembly
Vintasoft.Imaging.Annotation.Office Assembly
Vintasoft.Imaging.Annotation.Office.UI Assembly
Vintasoft.Imaging.Annotation.Office.Wpf.UI Assembly
Vintasoft.Imaging.Annotation.Pdf Assembly
Vintasoft.Imaging.Annotation.Pdf.UI Assembly
Vintasoft.Imaging.Annotation.UI Assembly
Vintasoft.Imaging.Annotation.Wpf.UI Assembly
Vintasoft.Imaging.Dicom Assembly
Vintasoft.Imaging.Dicom.Mpr Assembly
Vintasoft.Imaging.Dicom.Mpr.UI Assembly
Vintasoft.Imaging.Dicom.Mpr.Wpf.UI Assembly
Vintasoft.Imaging.Dicom.UI Assembly
Vintasoft.Imaging.Dicom.Wpf.UI Assembly
Vintasoft.Imaging.DocCleanup Assembly
Vintasoft.Imaging.Drawing.SkiaSharp Assembly
Vintasoft.Imaging.FormsProcessing Assembly
Vintasoft.Imaging.FormsProcessing.Ocr Assembly
Vintasoft.Imaging.FormsProcessing.Ocr.UI Assembly
Vintasoft.Imaging.FormsProcessing.Ocr.Wpf.UI Assembly
Vintasoft.Imaging.FormsProcessing.UI Assembly
Vintasoft.Imaging.FormsProcessing.Wpf.UI Assembly
Vintasoft.Imaging.Gdi Assembly
Vintasoft.Imaging.Jbig2Codec Assembly
Vintasoft.Imaging.Jpeg2000Codec Assembly
Vintasoft.Imaging.Media Assembly
Vintasoft.Imaging.Ocr Assembly
Vintasoft.Imaging.Ocr.ML Assembly
Vintasoft.Imaging.Ocr.Tesseract Assembly
Vintasoft.Imaging.Office.OpenXml Assembly
Overview
Namespaces
Vintasoft.Imaging.Codecs Namespace
Overview
Classes
DocxCodec
Vintasoft.Imaging.Codecs.Decoders Namespace
Overview
Classes
DocxDecoder
DocxRenderingSettings
MarkupRenderingSettings
OpenXmlDecoder<TDocument>
XlsxDecoder
XlsxRenderingSettings
Vintasoft.Imaging.Codecs.Encoders Namespace
Overview
Classes
DocxEncoder
DocxEncoderException
XlsxEncoder
XlsxEncoderException
Vintasoft.Imaging.Metadata Namespace
Overview
Classes
DocxDocumentMetadata
DocxPageMetadata
DocxPageTextRegionMetadata
OpenXmlDocumentMetadata
OpenXmlGotoActionMetadata
OpenXmlPageMetadata
OpenXmlPageTextRegionMetadata
OpenXmlUriActionMetadata
XlsxDocumentMetadata
XlsxPageMetadata
XlsxPageTextRegionMetadata
Vintasoft.Imaging.Office Namespace
Overview
Classes
OfficeDocumentCryptography
RuntimeError
RuntimeMessage
RuntimeWarning
Enumerations
BorderSide
Vintasoft.Imaging.Office.OpenXml Namespace
Overview
Classes
DocxConverterSettings
HtmlConverterSettings
OpenXmlDocument
OpenXmlDocumentConverter
OpenXmlDocumentInformation
OpenXmlPage
OpenXmlPageCollection<TPage,TDocument>
Enumerations
HtmlDocumentFormat
Delegates
CreateUriStreamDelegate
Vintasoft.Imaging.Office.OpenXml.Docx Namespace
Overview
Classes
DocxDocument
DocxDocumentException
DocxPage
DocxPageCollection
Vintasoft.Imaging.Office.OpenXml.Editor Namespace
Overview
Classes
OpenXmlCompositeTextContent
OpenXmlContentInfo
OpenXmlCustomTabStop
OpenXmlCustomTabStops
OpenXmlDateFieldInfo
OpenXmlDocumentChart
OpenXmlDocumentChartData
OpenXmlDocumentChartDataPoint
OpenXmlDocumentChartDataSeries
OpenXmlDocumentChartMarker
OpenXmlDocumentChartMarkerShapeProperties
OpenXmlDocumentChartShapeProperties
OpenXmlDocumentEditor
OpenXmlDocumentElement
OpenXmlDocumentElementCollection
OpenXmlDocumentElementCollection<T>
OpenXmlDocumentGraphics
OpenXmlDocumentImage
OpenXmlDocumentInformation
OpenXmlDocumentNumbering
OpenXmlDocumentParagraph
OpenXmlDocumentRootElement
OpenXmlDocumentStyle
OpenXmlDocumentTable
OpenXmlDocumentTableCell
OpenXmlDocumentTableRow
OpenXmlDocumentTextContent
OpenXmlDrawingObjectProperties
OpenXmlFieldInfo
OpenXmlHyperlinkInfo
OpenXmlNumPagesFieldInfo
OpenXmlPageBreakInfo
OpenXmlPageFieldInfo
OpenXmlParagraphInfo
OpenXmlParagraphProperties
OpenXmlTabInfo
OpenXmlTextBreakInfo
OpenXmlTextContent
OpenXmlTextInfo
OpenXmlTextProperties
OpenXmlTimeFieldInfo
Enumerations
OpenXmlCustomTabStopLeaderCharacter
OpenXmlCustomTabStopType
OpenXmlDocumentChartMarkerStyle
OpenXmlParagraphJustification
OpenXmlTextHighlightType
OpenXmlTextUnderlineType
OpenXmlTextVerticalPositionType
Vintasoft.Imaging.Office.OpenXml.Editor.Docx Namespace
Overview
Classes
DocxDocumentEditor
DocxDocumentNumbering
DocxDocumentNumberingDefinitions
DocxDocumentStyle
DocxDocumentStyleDefinitions
Vintasoft.Imaging.Office.OpenXml.Editor.Xlsx Namespace
Overview
Classes
XlsxDocumentDefinedName
XlsxDocumentEditor
XlsxDocumentHyperlinks
XlsxDocumentMergeCells
XlsxDocumentSheet
XlsxDocumentSheetCell
XlsxDocumentSheetDrawing
XlsxDocumentSheetFormat
XlsxDocumentSheetRow
XlsxDocumentSheetView
Enumerations
XlsxDocumentSheetCellCommentTransformType
Vintasoft.Imaging.Office.OpenXml.Xlsx Namespace
Overview
Classes
XlsxDocument
XlsxDocumentException
XlsxPage
XlsxPageCollection
Vintasoft.Imaging.Office.Spreadsheet Namespace
Overview
Classes
EditingEventArgs
SheetCellsClipboard
SpreadsheetCellReference
SpreadsheetEditor
SpreadsheetEditorSettings
SpreadsheetEditorSource
SpreadsheetEditorUndoAction
SpreadsheetEditorUndoActionEventArgs
SpreadsheetEditorUndoManager
SpreadsheetFindReplace
StandardCharts
StreamRequestEventArgs
SynchronizationEventArgs
Enumerations
CellsFillDirection
CellStyleProperty
SheetCellsCopyMode
StandardChartType
Vintasoft.Imaging.Office.Spreadsheet.Document Namespace
Overview
Classes
CellBorder
CellBorders
CellComment
CellFormattedValue
CellHyperlink
CellReference
CellReferences
CellReferencesSet
CellsBorders
CellStyle
ChartDataPoint
ChartDataSeries
ChartInsertParams
ChartMarker
ChartProperties
Comment
DefinedName
DocumentDefaults
DocumentInformation
DocumentView
FontProperties
FormattingProperties
Hyperlink
NumbersReference
ShapeAppearance
SheetCell
SheetColumn
SheetDrawing
SheetDrawingImage
SheetDrawingLocation
SheetRow
SpreadsheetDocument
StringsReference
TextAppearance
TextProperties
TextShapeAppearance
Worksheet
WorksheetFormat
WorksheetView
Enumerations
CellBorderStyle
CellDataType
CellErrorType
ChartDataSeriesType
ChartMarkerStyle
ChartType
DrawingType
SheetDrawingLocationType
TextHorizontalAlign
TextVerticalAlign
Vintasoft.Imaging.Office.Spreadsheet.Document.Editors Namespace
Overview
Classes
CellCommentEditor
CellStyleEditor
ChartDataSeriesEditor
ChartPropertiesEditor
SheetCellEditor
SheetDrawingEditor
SpreadsheetDocumentEditor
SpreadsheetEditorCommand
SpreadsheetEditorCommandSerializer
WorksheetEditor
Vintasoft.Imaging.Office.Spreadsheet.Formulas Namespace
Overview
Classes
FormulaExpression
FormulaParser
Vintasoft.Imaging.Office.Spreadsheet.Functions Namespace
Overview
Classes
SupportedFunctions
Overview
Members
Properties
Categories
Methods
GetFunctions Methods
GetFunctions(FunctionCategory)
GetFunctions(FunctionCategory,FormattingProperties)
Enumerations
FunctionCategory
Vintasoft.Imaging.Office.Spreadsheet.NumberFormats Namespace
Overview
Classes
CurrencyFormat
DateFormat
GeneralFormat
NumberFormat
NumberingFormat
NumberingFormatBase
PercentageFormat
ScientificFormat
SupportedNumberFormats
TextFormat
TimeFormat
UndefinedFormat
Enumerations
NumberFormatCategory
Vintasoft.Imaging.Office.OpenXml.UI Assembly
Vintasoft.Imaging.Office.OpenXml.Wpf.UI Assembly
Vintasoft.Imaging.Pdf Assembly
Vintasoft.Imaging.Pdf.JavaScript Assembly
Vintasoft.Imaging.Pdf.Mrc Assembly
Vintasoft.Imaging.Pdf.Ocr Assembly
Vintasoft.Imaging.Pdf.Office Assembly
Vintasoft.Imaging.Pdf.Office.UI Assembly
Vintasoft.Imaging.Pdf.Office.Wpf.UI Assembly
Vintasoft.Imaging.Pdf.UI Assembly
Vintasoft.Imaging.Pdf.Wpf.UI Assembly
Vintasoft.Imaging.RawCodec Assembly
Vintasoft.Imaging.UI Assembly
Vintasoft.Imaging.WebpCodec Assembly
Vintasoft.Imaging.WsiCodec Assembly
Vintasoft.Imaging.Wpf Assembly
Vintasoft.Imaging.Wpf.UI Assembly
Vintasoft.Shared Assembly
API changes history
API changes in version 9.0
API changes in Imaging
API changes in PDF
API changes in Forms Processing
API changes in version 9.1
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in DICOM
API changes in Forms Processing
API changes in JPEG2000
API changes in version 9.1.2
API changes in Imaging
API changes in PDF
API changes in Office
API changes in version 10.0
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in Document Cleanup
API changes in DICOM
API changes in Office
API changes in version 10.1
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in DICOM
API changes in Forms Processing
API changes in Office
API changes in version 11.0
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in DICOM
API changes in Office
API changes in version 12.0
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in OCR
API changes in DICOM
API changes in Office
API changes in version 12.1
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in OCR
API changes in Office
API changes in version 12.2
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in OCR
API changes in Office
API changes in DICOM
API changes in Document Cleanup
API changes in version 12.3
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in OCR
API changes in Office
API changes in Forms Processing
API changes in DICOM
API changes in Document Cleanup
API changes in version 12.4
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in Office
API changes in DICOM
API changes in JPEG2000
API changes in version 12.5
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in Document Cleanup
API changes in OCR
API changes in DICOM
API changes in Office
API changes in version 14.0
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in DICOM
API changes in Office
API changes in version 14.1
API changes in Imaging
API changes in Annotation
API changes in PDF
API changes in JPEG2000
API changes in Forms Processing
API changes in Office
API changes in DICOM
SupportedFunctions Class Members
In This Topic
The following tables list the members exposed by
SupportedFunctions
.
Public Properties
Name
Description
Categories
Gets names of function categories.
Public Methods
Name
Description
GetFunctions
Overloaded. Returns an array that contains function names for specified category.
See Also
Reference
SupportedFunctions Class
Vintasoft.Imaging.Office.Spreadsheet.Functions Namespace