darknessomi / darknessomi/excellibrary

DataSetHelper.CreateWorkbook uses 1904 Date system

Open
#76 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 Dataset
2. Save dataset using ExcelLibrary.DataSetHelper.CreateWorkbook
3. Open workbook in Excel

What is the expected output? What do you see instead?
Standard excel behaviour is to create workbooks not using the 1904 date system,
workbooks using this library do use the 1904 date system (in Excel options you
can see this). Other than that, it's perfect.

What version of the product are you using? On what operating system?
Windows XP with Office 2007

Please provide any additional information below.

```

Original issue reported on code.google.com by `garethte...@gmail.com` on 26 Oct 2010 at 2:06

Contributor guide

No contributing guide indexed for this repository

Research direction

Start at DataSetHelper.CreateWorkbook, following how the generated workbook's date system is written. Reproduce the issue by creating and opening a dataset workbook in Excel, then verify that the workbook uses the standard date system rather than 1904. The payload names no test file, so identify the project's existing test location before adding regression coverage.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
backend
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.