ironcalc/IronCalc

Features

• Spreadsheet Formula Engines - Provides a full calculation engine for evaluating mathematical and logical expressions within spreadsheet cells using industry-standard rules.
• Relative Reference Shifting - Returns a reference to a range located a specified distance from a starting cell.
• Excel Spreadsheet Management - Provides programmatic reading and loading of Excel spreadsheet files from local devices.
• Financial Software - Implements advanced financial software capabilities for calculating bond pricing, loan payments, and net present value.
• Workbook Management - Manages the creation and structural organization of sheets and cells within a workbook.
• XLSX Export - Transforms internal spreadsheet models into physical XLSX files for external application use.
• XLSX Serialization - Implements bidirectional conversion of the internal spreadsheet model to and from the binary XML XLSX format.
• Coordinate-Based Data Retrieval - Retrieves a value from a database or array constant based on a row and column index.
• Grid Coordinate Resolution - Returns the numerical position of a cell or column to identify its location.
• Expression Evaluators - Computes arithmetic results from input strings using double-precision floats for numerical expression evaluation.
• Cell Coordinate Mapping - Implements a system for mapping logical data addresses to specific row and column intersections in a spreadsheet grid.
• Named Range Mappings - Provides a mechanism to map human-readable names and dynamic text to specific spreadsheet cell coordinates.
• Engineering Calculation Toolkits - Provides a comprehensive engineering toolkit for complex number arithmetic, bitwise operations, and Bessel functions.
• Filtered Average Calculations - Computes the arithmetic mean of numeric values by summing them and dividing by the count.
• Financial Computation Libraries - Provides a comprehensive library for calculating interest, depreciation, and bond yields for cash-flow analysis.
• Floating Point Arithmetic - Computes numerical expressions using double-precision floating-point arithmetic for high-accuracy calculations.
• Formula Error Verification - Detects and manages calculation error states to provide fallback values or validate cell contents.
• Cell Range Definitions - Points to specific cells or ranges whether defined manually or generated dynamically.
• Spreadsheet Interfaces - Ships a browser interface for creating, editing, and formatting spreadsheets with regional localization support.
• Transposition Utilities - Swaps the orientation of a range by flipping rows into columns and columns into rows.
• Cross-Range Lookups - Implements the ability to search a range for a specific value and return a corresponding item from another range.
• Dynamic Cell Referencing - Enables the retrieval of cell contents using text strings to build spreadsheet references programmatically.
• Dynamic Row Referencing - Returns a reference to a specific row or range of rows to be used within spreadsheet formulas.
• Financial Interest Calculators - Provides tools for calculating cumulative interest charges on financial positions over specific durations.
• Accrued Interest Calculations - The spreadsheet engine computes the accrued interest for monthly paying securities based on settlement and coupon dates.
• Horizontal Range Lookups - Implements horizontal search capabilities to locate values in a top row and retrieve data from specified rows.
• Position-Matched Retrieval - Searches for values within ranges and returns related data based on the matching relative position.
• Relative Index Location - Locates a specific value within a range and returns its relative index position.
• Relative Position Search - Provides flexible match modes to find the relative position of a specific item within a cell range.
• Standard Range Lookups - Searches a range for a value and returns a corresponding value from the same position.
• Transaction Summarization - Aggregates and calculates metrics from datasets using averages, probability distributions, and regression.
• Vertical Range Lookups - Searches the first column of a range and returns a value from a specified target column.
• Workbook Management Interfaces - Implements programmatic tools for deleting individual spreadsheets or batches of workbook files from the system.
• Workbook Generation - Provides the ability to generate new spreadsheets or duplicate existing ones to initialize calculations.
• Array-to-Column Conversions - Transforms a range of cells or an array into a single column of values.
• Discounted Cash Flow Valuations - Determines the current value of future cash flows by discounting them based on a periodic rate.
• Conditional Cell Counting - Provides functionality to count cells containing numbers that match specified conditions.
• Criteria-Based Aggregations - Calculates sums, averages, or counts for rows within a range that meet filter criteria.
• Criteria-Based Range Sorting - Rearranges a set of data based on the values of a corresponding array.
• Criteria-Based Summation - Calculates the total of a numeric column based on specified criteria.
• Spreadsheet Analysis Workflows - Enables the creation of automated workflows to filter, sort, and aggregate large datasets using database-style criteria.
• Data Sorting Engines - Organizes data into ascending or descending order based on the values in a specified column.
• Filtered Row Counts - Counts the number of non-empty cells in a column based on filtered conditions.
• Date and Time Libraries - Encodes calendar dates and clock times as numeric values using a fixed epoch for consistent temporal handling.
• Numeric and Date Formatting - Applies regional settings to localize numeric, currency, and temporal data displays based on geographic zones.
• In-Place Cell Editing - Allows users to modify the values of individual cells directly within the grid via keyboard triggers.
• Index-Based Extraction - Provides retrieval of specific values from a list based on a provided index number.
• Coordinate-Based Retrieval - Returns values from specific positions in a spreadsheet based on provided row and column offsets.
• Fixed Rate Bond Pricing - The spreadsheet engine computes the clean price of a bond by discounting future cash flows at a required yield.
• Criteria-Based Maximums - Searches a specified range for a maximum value based on a set of criteria.
• Criteria-Based Minimums - The spreadsheet engine returns the smallest value in a specific field based on a set of criteria.
• Principal Repayment Calculations - Computes the total principal paid over a period based on constant payments and interest rates.
• Range and Exact Match Filters - Extracts a subset of a range based on boolean conditions to return matching records.
• Row Index Identification - Determines the numerical position of a record to isolate a specific row from a range by its index.
• Undo-Redo State History - Manages a stack of state transitions to enable undo and redo operations for workbook modifications.
• Component Extractions - The spreadsheet engine returns the real component of a complex number specified as a string or numeric value.
• Sum-of-Years' Digits Methods - The spreadsheet engine computes the depreciation of an asset using the sum-of-years digits method.
• Asset Depreciation Models - Implements the fixed-declining balance method for computing asset depreciation.
• Average Deviation Calculators - Calculates the average of the absolute differences between each value and the mean for statistical analysis.
• Complex Argument Calculators - The spreadsheet engine computes the angle in radians between the positive real axis and the vector of a complex number.
• Complex Trigonometric Functions - The spreadsheet engine computes the cosine of a complex number for mathematical calculations.
• Modified Internal Rate of Return - Computes the internal rate of return while accounting for cost of capital and reinvestment rates.
• Day Count Conventions - Determines the number of days between dates using professional accounting day-count conventions.
• Decimal-to-Hexadecimal Converters - The spreadsheet engine translates a decimal number into its hexadecimal string representation.
• Filtered Product Calculations - Multiplies values in a specific field that match a set of defined criteria.
• Formula Text Extraction - Allows the retrieval of the underlying formula of a cell as a text string rather than its evaluated result.
• Future Value Projections - Predicts the future value of investments by applying interest and regular payments over time.
• Investment Duration Calculators - Calculates the number of periods remaining in an investment based on rate and payment.
• Loan Principal Calculators - Computes the principal portion of a loan payment for a specific period.
• Measurement Unit Conversions - The spreadsheet engine translates a numeric value from one unit of measurement to another using a specified conversion scale.
• Unit-Aware Evaluators - Processes values associated with specific units, such as currencies or percentages, to maintain data context.
• Binary-to-Decimal Conversions - The spreadsheet engine transforms a decimal number into a binary string.
• Complex Arithmetic Primitives - The spreadsheet engine executes mathematical operations on complex numbers using real and imaginary parts.
• String-to-Complex Parsing - The spreadsheet engine processes complex numbers represented as strings containing real and imaginary components.
• Complex Property Analyzers - The spreadsheet engine calculates the difference between two complex numbers by subtracting real and imaginary parts.
• Complex Conjugate Calculators - The spreadsheet engine reverses the sign of the imaginary part of a complex number to find its conjugate.
• Distribution Function Calculators - Computes the cumulative distribution function for a value using alpha and beta parameters.
• Binomial Probability Calculators - Computes the probability that a specific number of successes occurs within a range.
• Future Value Calculations - The spreadsheet engine computes the future value of an investment based on constant periodic payments.
• Periodic Return Calculators - Computes the internal rate of return for a series of irregular cash flows.
• Serial Date Representations - Encodes calendar dates and times as numeric serial numbers to enable mathematical operations and flexible formatting.
• Present Value Calculations - Computes the current value of future cash flows based on a fixed interest rate.
• Named Range Creation - Provides the ability to assign custom alphanumeric names to specific cell ranges for easier formula referencing.
• Cell Styling Systems - Applies named presets for colors and fonts to ensure consistent visual styling across cells.
• Number Formatting - Applies specialized formatting to numeric values for currencies, dates, and percentages.
• Conditional Formatting - Changes cell appearance based on values or rules to highlight specific data patterns.
• Undo-Redo History - Maintains a history of state changes to enable undo and redo functionality.

Star history