#249  Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.
    #248  Autofilter Removed When Copying Sheet
    #247  Asp.Net file delivering example   question 
    #246  Reworked conditional formatting behavior and added some changes
    #245  Add formula for SumProduct
    #244  How to add IEnumerable<Customer> object to ClosedXML ?
    #243  HELP PLEASE! Applying AutoFilter changes formula references
    #242  Please support .Net Core / .Net Standard   duplicate 
    #241  Custom Filter
    #240  InsertRowsBelow slower than InsertData
    #239  Get "Identifier expected." when try to read a value   duplicate 
    #238  Columns().AdjustToContents - TableHeader Column names ?
    #237  Columns().AdjustToContents(1, 20) - throwing several System.Exception
    #236  Support ConditionalFormat DataBar like Office 2010
    #235  Replace instances of Exception class with instances of other sub clas
    #234  Open excel and add row
    #233  Don't crash when file contains multiple default styles
    #232  Column.AdjustToContents(): Inspect worksheet and table autofilters to leave space for arrow
    #231  Text() function - return string as is if input value is already a string
    #230  0.86 Sequence contains more than one matching element   enhancement 
    #229  Can we do the format and group column on the Pivot Table?   Parked   Sample file required 
    #228  Set ColumnOrderAttribute Obsolete
    #227  Implement new XLColumnAttribute
    #226  Formula Text excel different behavior   bug 
    #225  Upgrade OpenXML to v2.7.1
    #224  Columns().AdjustToContents(1, 20) - Performance regression   Sample file required 
    #223  'br' start tag on line #### position ## does not match end tag of 'font'
    #222  Add VmlDrawing Id's to context to avoid reuse.
    #221  Id conflicts with the Id of an existing relationship.   bug 
    #220  Save Existing Excel file: File gets corrupted
    #219  Cannot open existing Excel File
    #218  Pivot tables default filter
    #217  Conditional formatting to stop when true
    #216  Faster way to search for text
    #215  XLConditionalFormat CopyFrom NULL exception
    #214  Don't reference cell to get row height
    #213  InsertRowsBelow fails with ArgumentException when there is a comment below the new rows   bug 
    #212  Preserve cell format when inserting table or data
    #211  Issue175 use xlparser to parse print area
    #210  Use FastMember instead of slow Reflection
    #209  Implement new XLColumnAttribute
    #208  Add attribute to ignore column
    #207  new XLWorkbook() is working too slow
    #206  default cell style   invalid 
    #205  IXLColumn.Delete() sometimes creates corrupt XLSX files.
    #204  Better detection of numerical data types. Not only System.Double.
    #203  Remove orphaned drawings from worksheets
    #202  cannot operate with existing excel file
    #201  decimal datatype not handled properly as number
    #200  Preserve whitespace in cells.
    #199  Classic layout should be disabled by default.
    #198  Current NuGet packages are Debug Builds failing validation on non US systems   help wanted 
    #197  Closedxml error after merging cells   Sample file required 
    #196  Theme XLColor to System.Drawing.Color   question 
    #195  fixed null reference exception
    #194  Cell with only white space is trimmed   bug 
    #193  DataValidation not working copy from another cell
    #192  sheet.Cell("B3").InsertData(table.AsEnumerable()) doesn't apply a user defined cell format   bug 
    #191  ClassicPivotTableLayout does not work   bug 
    #190  Exception opening xlsx with existing Pivot tables   Sample file required 
    #189  Requested value 'TableStyleQueryResult' was not found   Parked 
    #188  Tally.cs not found   Sample file required 
    #187  Formula Row(A1) is not supported
    #186  Deduce default header and footer font from worksheet
    #185  Correctly deduce data type from number format string if data type is number (as for LibreOffice files).
    #184  Can we write data and char in power point file by ClosedXML
    #183  ClosedXML throwing out of memory exception when exporting 73000 records
    #182  InsertData Skipping Columns
    #181  ClosedXML not handling dates correctly   bug 
    #180  Implement sheet zooming
    #179  Pivot table loading enhancements and collapsing fields
    #178  'System.ApplicationException' 
    #177  Issue175 parse commas in print area
    #176  Saving value date '1000-01-01' in xlsx
    #175  Allow references to worksheet with a space in its name
    #174  Header/Footer length error - xlsx file   bug 
    #173  Cap column width at 255
    #172  Allow pivot table field to be a value field and a row/column/filter field
    #171  PivotTable created from LINQ query is corrupt but recoverable in Excel 
    #170  AdjustToContents() will adjust to invalid values
    #169  Header/Footer Text Formatting    question 
    #168  Disabling Autofilter 
    #167  Create file in memory
    #166  Cannot add New Line
    #165  Dispose hell
    #164  Adding rows clears Conditional Formatting
    #163  Can't retrieve a excel file from a code
    #162  Cannot save workbooks
    #161  Shift Conditional Formats
    #160  Conditional formatting should be applicable to multiple ranges
    #159  Force OpenXMLValidator to run under invariant culture
    #158  Explicitly ignore custom sheet view elements.
    #157  Fix maths / statistical functions
    #156  Calling SaveAs fails with validation error
    #155  Can't load an excel file: "An item with the same key has already been added."
    #154  Shift page breaks
    #153  Page breaks are not shifting
    #152  Culture non invariant cause crash on save
    #151  Error in ImportStream
    #150  sheet.Evaluate("COUNTIF......
    #149  Update test for correctly testing time value as string
    #148  Improve conditional formatting loading and saving
    #147  When saving a document with cell, staring with apostrophe ( ' ), this symbol is trimmed   question 
    #146  XlWorkbook NamedRanges do not include local names
    #145  System.ApplicationException in ClosedXML
    #144  exception: `System.IndexOutOfRangeException`
    #143  UWP and Xamarin Forms support
    #142  Use BuiltInId to determine default style
    #141  Getting this exp "Specified argument was out of the range of valid values." while opening an excel file
    #140  Workbook generated using closedxml, throwing error (Couldn't find 'xl/worksheets/sheet1.xml' ) while trying to read from other software
    #139  Workbook Connection lost   enhancement 
    #138  Release 0.85.0, Worksheet.PivotTables not detecting pivot tables
    #137  Named constants throw exception.   enhancement 
    #136  Save workbook exception   bug 
    #135  Generated XLSX is invalid   bug 
    #134  How I can copy range values without formulas?
    #133  XLTable.FieldNames Dictionary doesn't Refresh Keys
    #132  When a cell's text begins with a new line code and Japanese Kanji   enhancement   help wanted 
    #131  When an Id of a first sheet is 2
    #130  Why are all number types converted into double?
    #129  Query Sheets    help wanted   question 
    #128  Pivot table case sensitivity problem with rowlabels
    #127  Correctly save sheet Id and RelId
    #126  Workbook loses fit to page settings on save
    #125  Screws up references from second sheet to first sheet when first sheet is updated
    #124  Implement loading pivot tables
    #123  PivotTable case sensitivity problem with RowLabels
    #122  PageSetup
    #121  External link relationship in formulas   enhancement 
    #120  CurrentRegion for IXLRange   enhancement 
    #119  nuget ETA
    #118  Catch implicit conversion that fails. 
    #117  Calculation failure in date cell
    #116  Implement 'Visible' property on named ranges. 
    #115  Exception when calling SaveAs()
    #114  PageSetup.Footer.Left is not filled with data from PageSetup.Footer
    #113  Getting format exception and not getting proper value of a cell which shows properly on excel
    #112  After the first 4 sheets, Border is assigned only to specific cells
    #111  There is a phenomenon that the setting of Border does not apply.
    #110  Copying sheet doesn't bring graphs over   enhancement   Hacktoberfest 
    #109  Don't match parts of formula between single quotes (i.e. sheet names)
    #108  Fix regex for parsing cell formula.
    #107  Copying cell with certain formula results in corrupt cell
    #106  Defined Name Visibility
    #105  Sort does not work properly when using Formula's
    #104  Load sheet data with table with no rows correctly
    #103  Additional Cell Formatting Options
    #102  StackOverflowException due to long chain of formula dependencies
    #101  Support .NET Standard   enhancement   Parked 
    #100  Multiple SaveAs calls causes InvalidCastException
     #99  Pivot table improvements
     #98  Theme colors
     #97  Parse inline string with rich text correctly.
     #96  More than one Value to Pivot table not working
     #95  Setting thread culture so that tests pass on any machine
     #94  Properly dispose workbook after tests are completed.
     #93  Number formatting does not work
     #92  number format
     #91  Parsing of rich text inside inline string fails
     #90  Copying a range will alter the worksheet names in a Formula
     #89  checkboxes support
     #88  Expose new Cells() function to iterate over cells, including unused cells inside range, but excluding unused cells outside range.   enhancement 
     #87  Support for multiple pivot tables   bug 
     #86  Large Files - Performance & Memory consumption   bug 
     #85  Fix the pivot table support for multiple pivot tables.
     #84  reading empty cell issue
     #83  Please any one help me out to read blank cell using Closed XML.
     #82  Reading value from empty cell
     #81  Allow room for filter arrow when adjusting column widths automatically.   bug   Hacktoberfest 
     #80  Fix VLOOKUP and HLOOKUP when reference table is not at A1. Fixes #72.
     #79  More double parse fixes   bug   Hacktoberfest 
     #78  Improve HasDuplicates<T>
     #77  Columns().AdjustToContents ignored AutoFilter
     #76  Add custom attribute to specify column order of object exported.   enhancement   Hacktoberfest 
     #75  Excel functions   enhancement   Hacktoberfest 
     #74  Excel functions
     #73  DocumentFormat.OpenXml nuget dependency   duplicate 
     #72  Vlookup using wrong row numbers   bug   Hacktoberfest 
     #71  Fix date and time functions where negative days are involved.   bug   Hacktoberfest 
     #70  Formulas like FIND and COUNTIF get removed
     #69  Implement all date and time functions   bug   Hacktoberfest 
     #68  Include nuget install command  
     #67  Cannot set horizontal alignment on merged cells
     #66  NickNack2020's fix for invalid char   enhancement   Hacktoberfest 
     #65  Fix conditional formatting   bug   Hacktoberfest 
     #64  Remove shadow test   Hacktoberfest 
     #63  Excel found unreadable content - strip invalid XML characters?   Hacktoberfest 
     #62  Optionally validate the workbook using OpenXmlValidator when saving it.   enhancement   Hacktoberfest 
     #61  Problem with the conditional formatting
     #60  Object Creation Validation
     #59  Read or retrieve value from spreadsheet using existing rangenames
     #58  Implement RightToLeft in sheet view. Fixes #53 .   Hacktoberfest 
     #57  Issue55 load table with hidden header row   Hacktoberfest 
     #56  Use globally defined number style to parse text to double. Especially…   Hacktoberfest 
     #55  installed ClosedXml nuget from nuget manager but can't load an existing excel file   Hacktoberfest 
     #54  Wrong bar proportions in DataBar   bug   Hacktoberfest 
     #53  Sheet->Right-to-Left does not work   bug   Hacktoberfest 
     #52  Implement all Excel functions   Hacktoberfest 
     #51  Full pivot table support   enhancement   Hacktoberfest 
     #50  Charting support   enhancement   Hacktoberfest 
     #49  Query table support   enhancement   Hacktoberfest 
     #48  Image support   enhancement   Hacktoberfest 
     #47  Parse and convert to string using invariant culture
     #46  Fix paths for Unix environments
     #45  Allow Access to lower level xml
     #44  Dont hardcode examples folders
     #43  Correct set page header
     #42  Can't set header on non empty header
     #41  Fixed R1C1 regex bug
     #40  Problem with R1C1 Regex
     #39  "Pivot Tables Values Problem"    bug   Hacktoberfest 
     #38  Investigate "Unreadable content" Issue 
     #37  Codeplex pr8519 performance improvements when inserting rows
     #36  cell.RichText.Text v/s cell.Value.Tostring()
     #35  When setting cell value to RichText, don't use SetEnumerable.
     #34  Clearing AutoFilter shouldn't throw an exception
     #33  Implement VLOOKUP and HLOOKUP
     #32  Remove Autofilter problem
     #31  Align develop branch with master
     #30  Support for lookup functions   enhancement 
     #29  Update version to 0.80
     #28  Calculation properties
     #27  Generate files in subfolders under executing assembly's folder.
     #26  Clean up project files
     #25  Fix XLColor equals method
     #24  Suppress warning CS1591
     #23  Sort(3);  does not work on sheets
     #22  Remove ClosedXML_Sandbox_VB project
     #21  Remove warnings
     #20  Ignore packages folder (from NuGet)
     #19  Remove ClosedXML_Package project. 
     #18  Text function fixes
     #17  SetRichText(object value)
     #16  fix "conditional format doesn't work when range has multiple conditional format"
     #15  fix "conditional format doesn't work when range has multiple conditio…
     #14  Data at root level is invalid, generating xlsx from linux with mono
     #13  Add .editorconfig file
     #12  Upgrade NUnit to version 3.4.1   enhancement 
     #11  Fix workbook properties custom datetime property
     #10  Fix datetime bug with short date format
      #9  Parse dates with current culture
      #8  PROPER function handling
      #7  Implement type safe XLTableTheme class 
      #6  Allow for custom themes in tables.  Fixes Codeplex 9499
      #5  Check returned value is null when no worksheet was found.
      #4  Delete obsolete files and folders.
      #3  Fix number format id bug
      #2  Preserve tables' column names when table is of type queryTable.   Parked 
      #1  Delete pivotcache when deleting a sheet