Error doing data validation from another sheet

When using closedxml to add data validation to a file, all validations are written in the <x:dataValidations> element. However, this is not how excel saves data validation from other sheets. Here...

Id #9498 | Release: None | Updated: Nov 11 at 10:00 AM by igitur | Created: Aug 11 at 6:58 PM by jesta1215

Store must be open for this operation

I am creating an excel file in excess of 40MB using the .net 4.5.1 framework with ClosedXML for .Net Framework 4.0. I save and reopen the file to append every 10000 rows to conserve memory. This ...

Id #9495 | Release: None | Updated: Sep 27 at 11:03 AM by igitur | Created: May 30 at 2:34 PM by LouLoglisci

Formula IFERROR not included

Hi, first of all: Thank you for the ClosedXML-API! I have a Worksheet with the formula "IFERROR(Auswertung!B113,""""), but I can't get the value. Is there a possibility to get the cell text with...

Id #9493 | Release: None | Updated: May 12 at 12:31 PM by Cionk | Created: May 12 at 12:31 PM by Cionk

ClosedXML integration with Windows RMS (Right Management Services)

ClosedXML integration with Windows RMS (Right Management Services) I got requirement to Export Excel with integrating the Windows AD RMS ( Active Directory Right management Service) integration. ...

Id #9492 | Release: None | Updated: May 4 at 3:47 PM by nicksoft | Created: May 4 at 3:47 PM by nicksoft

How to update/formatting existing excel (like template) file?

Please guide me for How to update/formatting existing excel (like template) file? I have tried below code but it's give error. // FilePath - c drive temp folder string tempFile = FilePath +...

Id #9491 | Release: None | Updated: Sep 27 at 1:57 PM by igitur | Created: May 2 at 12:15 PM by amitjoshiTTI

System out of memory(Hide row)

How to hide a row from 1000 to 1048576 it will show some error message like System out of memory

Id #9490 | Release: None | Updated: Apr 22 at 7:14 AM by Alavudeen_soft | Created: Apr 22 at 7:14 AM by Alavudeen_soft

'', hexadecimal value 0x1A, is an invalid character.

When trying to write a datatable in .net to an Excel file with someout put from a third party I get an error message as per the subject line. '', hexadecimal value 0x1A, is an invalid character...

Id #9489 | Release: None | Updated: Oct 13 at 4:00 AM by NickNack2020 | Created: Apr 20 at 3:17 PM by SimonPrice33

Umlauts in hyperlinks to files have wrong encoding

Trying to add hyperlinks pointing to a file on a network share containing umlauts in the path (e.g. "X:\Pläne\list.xlsx") - yes, I know what should be done to people creating these folders ;) I ...

Id #9488 | Release: None | Updated: Apr 13 at 5:04 PM by Flominator | Created: Apr 13 at 4:58 PM by Flominator

Multiple save() causes cell formating to break

Scenario: Open excel file from file and add DateTime to A1. Call Save() for 50 times. Open file in Excel. I see double instead of datetime. Each call to Save() adds next entry to <x:numFmts>, <...

Id #9487 | Release: None | Updated: Aug 12 at 5:15 PM by tfletch | Created: Mar 31 at 1:41 PM by blackzork

Setting DataType for entire column leads to huge memory consumption

Hi guys, Just have found a weird bug: Create a workbook and a worksheet in it. Set data type for entire column to Text. This operation adds around 350Mb (on my x64 machine) to the process memor...

Id #9486 | Release: None | Updated: Mar 25 at 3:54 PM by a_llex | Created: Mar 25 at 3:54 PM by a_llex