GetUsedCells doesn't properly limit candidate cells (OutOfMemoryException) #2291
Labels
performance
There is a problem with performance (speed/memory).
triaged
Checked and and verified that it is actionable (not dup, has required info)
Read and complete the full issue template
Do not randomly delete sections. They are here for a reason.
Do you want to request a feature or report a bug?
Did you test against the latest CI build?
If you answered
No
, please test with the latest development build first.Version of ClosedXML
0.95.4
What is the current behavior?
When reading excel file, getting below Out of memory exception. This only happens on IIS. It works well on develeopment machine while debugging using Visual Studio. Excel file size is just 40KB.
at TestCasesImport.ReadExcelFile(FileUpload fu, String SheetName) in E:\agent_work\1\s\TDMS Web App\TestCasesImport.aspx.cs:line 364 at line 384 In the method ReadExcelFileSystem.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.Linq.Set
1.Resize() at System.Linq.Set
1.Find(TElement value, Boolean add)at System.Linq.Enumerable.d__67
1.MoveNext() at System.Linq.Enumerable.<DistinctIterator>d__64
1.MoveNext()at ClosedXML.Excel.XLCells.d__9.MoveNext()
at System.Linq.Enumerable.d__17
2.MoveNext() at System.Linq.Buffer
1..ctor(IEnumerable1 source) at System.Linq.OrderedEnumerable
1.d__1.MoveNext()at ClosedXML.Excel.XLCells.d__8.MoveNext()
at ClosedXML.Excel.XLCells.d__11.MoveNext()
at ClosedXML.Excel.XLCells.<System-Collections-Generic-IEnumerable-GetEnumerator>d__12.MoveNext()
What is the expected behavior or new feature?
Complete this.
No
Regressions get higher priority. Test against the latest build of the previous minor version. For example, if you experience a problem on v0.95.3, check whether it the problem occurred in v0.94.2 too.
Reproducibility
This is an important section. Read it carefully. Failure to do so will cause a 'RTFM' comment.
Without a code sample, it is unlikely that your issue will get attention. Don't be lazy. Do the effort and assist the developers to reproduce your problem. Code samples should be minimal complete and verifiable. Sample spreadsheets should be attached whenever applicable. Remove sensitive information.
Code to reproduce problem:
The text was updated successfully, but these errors were encountered: