EPPlus
EPPlus copied to clipboard
EPPlus-Excel spreadsheets for .NET
Excel gives a result of `FALSE` for `=24>""` and a result of `TRUE` for `=24
When a custom numberformat contains for example "[Red]-#" the HTML-exporter outputs "-Red" in content instead of coloring the text red. This as ValueToTextHandler FormatNumber method outputs it as content.
EPPlus uses .NET OADate functions to serialize/deserialize dates. Excel has a different behaviour, see below. >> [Microsoft Excel](https://en.wikipedia.org/wiki/Microsoft_Excel) has, since its earliest versions, incorrectly considered 1900 to be a leap...
The current Dimension functionality in EPPlus includes cells that only has a style set on it, but no value and no formula (same as Excel). We should investigate if we...
### EPPlus usage Commercial use (I have a commercial license) ### Environment Windows ### Epplus version 7.1.2 ### Spreadsheet application Excel ### Description I am writing code that will merge...
### EPPlus usage Noncommercial use ### Environment Windows ### Epplus version 7.1.2 ### Spreadsheet application Excel ### Description Create a blank worksheet and enter some data in it. Add header/footer...
- Added all missing xml comments. - Removed unused files. - Removed attributes hiding base-class attributes - Enabled nullable where neccesary
**Is your feature request related to a problem? Please describe.** The calculation engine in EPPlus doesn't support the LET function (see [Microsoft's documentation](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999) **Describe the solution you'd like** Implement support...
ShowHeaders = True and saving no longer causes crash if table has same column names. It also no longer overwrites cell values in empty cells when set to true. That...
### EPPlus usage Commercial use (I have a commercial license) ### Environment Windwos ### Epplus version 7.1 ### Spreadsheet application Excel ### Description When initializing a ExcelControlScrollBar it throws the...