### Build and install libgdiplus on CentOS 7+

Source: https://github.com/nissl-lab/npoi/wiki/How-to-use-NPOI-on-Linux

Steps to compile and install libgdiplus from source on CentOS systems.

```bash
yum install autoconf automake libtool
yum install freetype-devel fontconfig libXft-devel
yum install libjpeg-turbo-devel libpng-devel giflib-devel libtiff-devel libexif-devel
yum install glib2-devel cairo-devel
git clone https://github.com/mono/libgdiplus
cd libgdiplus
./autogen.sh
make
make install
cd /usr/lib64/
ln -s /usr/local/lib/libgdiplus.so gdiplus.dll
```

--------------------------------

### Install libgdiplus on Ubuntu 16.04+

Source: https://github.com/nissl-lab/npoi/wiki/How-to-use-NPOI-on-Linux

Commands to install dependencies and create a symbolic link for libgdiplus on Ubuntu systems.

```bash
apt-get install libgdiplus libc6-dev
cd /usr/lib
ln -s libgdiplus.so gdiplus.dll
```

--------------------------------

### Install libgdiplus on Fedora 23+

Source: https://github.com/nissl-lab/npoi/wiki/How-to-use-NPOI-on-Linux

Commands to install dependencies and create a symbolic link for libgdiplus on Fedora systems.

```bash
dnf install libgdiplus
cd /usr/lib64/
ln -s libgdiplus.so.0 gdiplus.dll
```

--------------------------------

### Configure Alpine Docker image for NPOI

Source: https://github.com/nissl-lab/npoi/wiki/How-to-use-NPOI-on-Linux

Dockerfile commands to add the testing repository and install libgdiplus on Alpine Linux.

```dockerfile
base sdk-alpine/aspnetcore-runtime-alpine images

RUN echo "http://dl-cdn.alpinelinux.org/alpine/edge/testing" >> /etc/apk/repositories
RUN apk --update add libgdiplus
```

--------------------------------

### Configure Debian Docker image for NPOI

Source: https://github.com/nissl-lab/npoi/wiki/How-to-use-NPOI-on-Linux

Dockerfile commands to install libgdiplus and create the required symbolic link on Debian-based images.

```dockerfile
FROM microsoft/dotnet:2.1-aspnetcore-runtime
RUN apt-get update && apt-get install -y libgdiplus libc6-dev && ln -s /usr/lib/libgdiplus.so /usr/lib/gdiplus.dll
```

--------------------------------

### Initialize and access BidirectionalDictionary

Source: https://github.com/nissl-lab/npoi/blob/master/main/Util/Collections/BidirectionalDictionary/README-BidirectionalDictionary.md

Demonstrates creating a dictionary with key-value pairs and accessing values via both the primary key and the inverse lookup.

```cs
using System.Collections.Generic;

var countryCapitalDictionary = new BidirectionalDictionary<string, string>()
{
    ["Italy"] = "Rome",
    ["India"] = "New Delhi",
    ["USA"]   = "Washington, D.C.",
};

Console.WriteLine(countryCapitalDictionary["Italy"]); // "Rome"
Console.WriteLine(countryCapitalDictionary.Inverse["Rome"]); // "Italy"
```

--------------------------------

### Build and Test NPOI

Source: https://github.com/nissl-lab/npoi/blob/master/AGENTS.md

Commands for building the solution, executing tests, and running performance benchmarks.

```bash
# Build
dotnet build solution/NPOI.Core.sln

# Run tests
dotnet test solution/NPOI.Core.Test.sln

# Run benchmarks
dotnet run -c Release --project benchmarks/NPOI.Benchmarks/
```

--------------------------------

### Create read-only bidirectional dictionaries

Source: https://github.com/nissl-lab/npoi/blob/master/main/Util/Collections/BidirectionalDictionary/README-BidirectionalDictionary.md

Shows how to create read-only versions from existing dictionary instances using either the extension method or the explicit class constructor.

```cs
var readOnlyDictionary = dictionary.AsReadOnly();
```

```cs
using System.Collections.ObjectModel;

var readOnlyDictionary = new ReadOnlyBidirectionalDictionary<string, string>(dictionary);
```

--------------------------------

### Built-In Sheet Functions Reference

Source: https://github.com/nissl-lab/npoi/blob/master/main/Resources/functionMetadata.txt

A comprehensive list of built-in Excel functions supported by the NPOI library, detailing the function name, parameter count limits, and return types.

```APIDOC
## Built-In Sheet Functions

### Description
This table provides the mapping of built-in Excel functions supported by the NPOI library. Each entry includes the function index, name, minimum/maximum parameters, and return class.

### Data Format
- **Index**: Unique identifier for the function.
- **Name**: The name of the Excel function.
- **MinParams**: Minimum number of parameters required.
- **MaxParams**: Maximum number of parameters allowed.
- **ReturnClass**: The type of data returned (e.g., V for Value, R for Reference, A for Array).

### Function List (Sample)
| Index | Name | MinParams | MaxParams | ReturnClass |
|-------|------|-----------|-----------|-------------|
| 0 | COUNT | 0 | 30 | V |
| 1 | IF | 2 | 3 | R |
| 4 | SUM | 0 | 30 | V |
| 15 | SIN | 1 | 1 | V |
| 20 | SQRT | 1 | 1 | V |
| 36 | AND | 1 | 30 | V |
| 65 | DATE | 3 | 3 | V |
| 100 | CHOOSE | 2 | 30 | R |
| 227 | MEDIAN | 1 | 30 | V |
```

--------------------------------

### BIFF5 Built-In Sheet Functions

Source: https://github.com/nissl-lab/npoi/blob/master/main/Resources/functionMetadata.txt

List of new built-in sheet functions introduced in BIFF5 format.

```APIDOC
## BIFF5 Built-In Sheet Functions

### Description
This section lists the new built-in sheet functions available in the BIFF5 format.

### Functions
- **WEEKDAY**: Converts a serial number to a day of the week.
- **HLOOKUP**: Searches for a value in the top row of a table and returns the value in the same column from a specified row.
- **VLOOKUP**: Searches for a value in the first column of a table and returns the value in the same row from a specified column.
- **DAYS360**: Calculates the number of days between two dates based on a 360-day year.
- **CONCATENATE**: Joins two or more text strings into one.
- **POWER**: Returns the result of a number raised to a power.
- **RADIANS**: Converts a degree measure to radians.
- **DEGREES**: Converts a radian measure to degrees.
- **SUBTOTAL**: Returns a number in the list or database that is returned by a relative column function.
- **SUMIF**: Adds the cells specified by a given criteria.
- **COUNTIF**: Counts the number of cells within a range that meet a given criteria.
- **COUNTBLANK**: Counts the number of empty cells in a range.
- **ISPMT**: Returns the interest portion of a payment for an investment based on periodic, constant payments and a constant interest rate.
- **DATEDIF**: Calculates the number of days, months, or years between two dates.
- **DATESTRING**: Converts a date to a string.
- **NUMBERSTRING**: Converts a number to a string.
- **ROMAN**: Converts an Arabic numeral to Roman numeral, as a text string.
```

--------------------------------

### BIFF8 Built-In Sheet Functions

Source: https://github.com/nissl-lab/npoi/blob/master/main/Resources/functionMetadata.txt

List of new built-in sheet functions introduced in BIFF8 format.

```APIDOC
## BIFF8 Built-In Sheet Functions

### Description
This section lists the new built-in sheet functions available in the BIFF8 format.

### Functions
- **GETPIVOTDATA**: Returns data stored in a PivotTable report.
- **HYPERLINK**: Creates a shortcut to open a document stored on a network server, an intranet, or the Internet.
- **PHONETIC**: Extracts phonetic characters (furigana) from a text string.
- **AVERAGEA**: Returns the average of its arguments, including numbers, text, and logical values.
- **MAXA**: Returns the largest value in a set of values, including numbers, text, and logical values.
- **MINA**: Returns the smallest value in a set of values, including numbers, text, and logical values.
- **STDEVPA**: Estimates standard deviation based on a sample, using numbers, text, and logical values.
- **VARPA**: Estimates variance based on a sample, using numbers, text, and logical values.
- **STDEVA**: Calculates standard deviation based on a sample, including numbers, text, and logical values.
- **VARA**: Calculates variance based on a sample, including numbers, text, and logical values.
```

--------------------------------

### BIFF4 Built-In Sheet Functions

Source: https://github.com/nissl-lab/npoi/blob/master/main/Resources/functionMetadata.txt

List of new built-in sheet functions introduced in BIFF4 format.

```APIDOC
## BIFF4 Built-In Sheet Functions

### Description
This section lists the new built-in sheet functions available in the BIFF4 format.

### Functions
- **USDOLLAR**: Converts a number to a dollar amount.
- **DBCS**: Converts a number to a DBCS string.
- **RANK**: Returns the rank of a number in a list of numbers.
- **DB**: Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
- **FREQUENCY**: Calculates how often values occur within a range of values.
- **ERROR.TYPE**: Returns a numeric value corresponding to an error type in a cell.
- **AVEDEV**: Returns the average of the absolute deviations of data points from their mean.
- **BETADIST**: Returns a continuous probability distribution, the beta distribution.
- **GAMMALN**: Returns the natural logarithm of the gamma function, Γ(x).
- **BETAINV**: Returns the inverse of the beta probability distribution function.
- **BINOMDIST**: Returns the binomial distribution.
- **CHIDIST**: Returns the chi-squared distribution.
- **CHIINV**: Returns the inverse of the chi-squared distribution.
- **COMBIN**: Returns the number of combinations for a given number of items.
- **CONFIDENCE**: Returns a confidence interval for a population mean.
- **CRITBINOM**: Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion.
- **EVEN**: Rounds a number up to the nearest even integer.
- **EXPONDIST**: Returns the exponential distribution.
- **FDIST**: Returns the F probability distribution.
- **FINV**: Returns the inverse of the F probability distribution.
- **FISHER**: Returns a standard Fisher transformation.
- **FISHERINV**: Returns an inverse Fisher transformation.
- **FLOOR**: Rounds a number down, toward zero.
- **GAMMADIST**: Returns the gamma distribution.
- **GAMMAINV**: Returns the inverse of the gamma distribution.
- **CEILING**: Rounds a number up, away from zero.
- **HYPGEOMDIST**: Returns the hypergeometric distribution.
- **LOGNORMDIST**: Returns the lognormal distribution.
- **LOGINV**: Returns the inverse of the lognormal distribution.
- **NEGBINOMDIST**: Returns the negative binomial distribution.
- **NORMDIST**: Returns the normal distribution.
- **NORMSDIST**: Returns the standard normal distribution.
- **NORMINV**: Returns the inverse of the normal distribution.
- **NORMSINV**: Returns the inverse of the standard normal distribution.
- **STANDARDIZE**: Returns a normal distribution, mean 0, and standard deviation 1.
- **ODD**: Rounds a number up to the nearest odd integer.
- **PERMUT**: Returns the number of permutations for a given number of items.
- **POISSON**: Returns the Poisson distribution.
- **TDIST**: Returns the Student's t-distribution.
- **WEIBULL**: Returns the Weibull distribution.
- **SUMXMY2**: Returns the sum of the squares of the differences between corresponding values in two arrays.
- **SUMX2MY2**: Returns the sum of the squares of the differences of corresponding values in two arrays.
- **SUMX2PY2**: Returns the sum of the squares of the sum of corresponding values in two arrays.
- **CHITEST**: Returns a two-tailed probability from the chi-squared distribution.
- **CORREL**: Returns the correlation coefficient of two data sets.
- **COVAR**: Returns covariance, the average of products of paired differences for two data sets.
- **FORECAST**: Calculates a future value along a linear trend.
- **FTEST**: Returns the result of an F-test.
- **INTERCEPT**: Calculates the intercept of the linear regression line.
- **PEARSON**: Returns the Pearson product moment correlation coefficient.
- **RSQ**: Returns the square of the Pearson product moment correlation coefficient.
- **STEYX**: Returns the standard error of the predicted y-value for each x in the regression.
- **SLOPE**: Calculates the slope of the linear regression line.
- **TTEST**: Returns the probability, associated with a Student's t-test.
- **PROB**: Returns the probability that values in a range will be between two limits.
- **DEVSQ**: Returns the sum of squares of deviation.
- **GEOMEAN**: Returns the geometric mean.
- **HARMEAN**: Returns the harmonic mean.
- **SUMSQ**: Returns the sum of the squares of its arguments.
- **KURT**: Returns the kurtosis of a data set.
- **SKEW**: Returns the skewness of a distribution.
- **ZTEST**: Returns a two-tailed probability that a value belongs to a population.
- **LARGE**: Returns the k-th largest value in a data set.
- **SMALL**: Returns the k-th smallest value in a data set.
- **QUARTILE**: Returns a quartile of a data set.
- **PERCENTILE**: Returns the k-th percentile of values in a range.
- **PERCENTRANK**: Returns the rank of a value in a data set as a percentage.
- **MODE**: Returns the most frequently occurring value in a data set.
- **TRIMMEAN**: Returns the mean of the interior of a data set.
- **TINV**: Returns the inverse of the Student's t-distribution.
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.