Deleting row from table resizes table incorrectly

I am greatly enjoying ClosedXml but have run into an issue when deleting a row from a table. The issue seems to be that while the row indeed is deleted, the last (undeleted) row of the table ends...

Id #9418 | Release: None | Updated: Fri at 12:24 AM by HenrikN | Created: Fri at 12:24 AM by HenrikN

Problem opening created spreadsheet in open office

I haved used this example to create a spreadsheet. The resulting spreadsheet will open fine in the Microsoft Execel Previewer but gets a general i/o error when I try to open it in OpenOffice Calc. ...

Id #9417 | Release: None | Updated: Jan 19 at 10:34 PM by otlarkin | Created: Jan 19 at 10:34 PM by otlarkin

WorkBook opening exception with message "Identifier expected"

When I trying to open workbook I catch exception. Code: var doc = new XLWorkbook(workBookFileName); StackTrace: в ClosedXML.Excel.CalcEngine.CalcEngine.Throw(String msg) в ClosedXML.Excel....

Id #9416 | Release: None | Updated: Jan 19 at 7:07 AM by Luckyman | Created: Jan 19 at 7:07 AM by Luckyman

Comment.Delete() crashes workbook

Hi! I'm troubled by a simple problem. Sometimes, workbook including comments is crashed by deleting comment. In order to ascertain reproducibility conditions, I prepared simple program. cla...

Id #9415 | Release: None | Updated: Jan 16 at 5:27 AM by kussy | Created: Jan 16 at 5:27 AM by kussy

Page break crashes workbook in saving.

Hi! Thank you for good library. I'm troubled by a simple problem. Sometimes, workbook is crashed in saving. In order to ascertain reproducibility conditions, I prepared simple program. it only...

Id #9414 | Release: None | Updated: Jan 15 at 7:12 AM by kussy | Created: Jan 15 at 7:12 AM by kussy

Loading a new workbook fails under mono

I am unable to do one of the most basic things, open a new workbook under Ubuntu running monodevelop. The following code: XLWorkbook wb = new XLWorkbook("input.xlsx"); throws an exceptio...

Id #9413 | Release: None | Updated: Jan 14 at 8:41 PM by rivanov | Created: Jan 14 at 8:41 PM by rivanov

Formula is broken when you copy

<Formula of the source cell> =R[5]C-1 var wb = new XLWorkbook(@"C:\Sample.xlsx"); var wsSource = wb.Worksheet(1); wsSource.CopyTo("Copy"); wb.SaveAs(@"C:\Sample.xlsx"); <Formula of th...

Id #9412 | Release: None | Updated: Jan 14 at 1:20 AM by tetsutetsu0402 | Created: Jan 14 at 1:20 AM by tetsutetsu0402

InsertData failes if at least one element is null

Hi, <TestMethod()> Sub WriteNothing() Dim workBook As New XLWorkbook(XLEventTracking.Disabled) Dim workSheet As IXLWorksheet = workBook.Worksheets.Add("Sheet 1") Dim array(3) As Object array(0)...

Id #9411 | Release: None | Updated: Jan 13 at 12:17 PM by michaelleopold | Created: Jan 13 at 12:17 PM by michaelleopold

Reduce memory usage during SaveAs()

I'm trying to use ClosedXml to generate a large sheet (620K rows, 10 columns, CSV version approx 104 MB), loading the data and creating the sheets needs a lot of memory (approx 4 GB) but this is fi...

Id #9410 | Release: None | Updated: Jan 10 at 6:40 PM by Pitterling | Created: Jan 9 at 10:37 AM by fhoeben

The specified package is invalid. The main part is missing.

I am using the closed XML for generating the excel template. After filling the data in the generated excel, I am trying to import the excel with data. It returns error "The specified package is inv...

Id #9409 | Release: None | Updated: Jan 23 at 11:35 PM by dmboucher | Created: Jan 9 at 4:51 AM by razkp007