darknessomi / darknessomi/excellibrary

Valid Cell value check in class WorkSheetEncoder

Open
#65 0 comments 0 reactions 0 assignees View on GitHub
auto-migrated Priority-Medium Type-Defect
Dominant language
C#
Stars
22
Forks
8
PR merge metrics
No merged PRs in 30d

Description

```
What steps will reproduce the problem?
1.Create a new cell with value System.DBNull.Value
2.Save Workbook

What is the expected output? What do you see instead?
Expected output is to treat this value the same as null. Instead an exception
"Invalid cell value." is thrown.

What version of the product are you using? On what operating system?
20090331. Windows server 2003.

Please provide any additional information below.
I corrected this with changing line #62 from:
if (cell != Cell.EmptyCell && cell.Value != null)

to:
if (cell != Cell.EmptyCell && cell.Value != null && cell.Value !=
System.DBNull.Value)
```

Original issue reported on code.google.com by `halliday...@gmail.com` on 17 Aug 2010 at 12:05

Contributor guide

No contributing guide indexed for this repository

Research direction

Start at line 62 of the WorkSheetEncoder class and reproduce the issue by creating a cell with System.DBNull.Value, then saving the workbook. Done means DBNull.Value is treated like null and saving completes without an "Invalid cell value." exception.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
data
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.