darknessomi / darknessomi/excellibrary

Error when opening created (or updated) excel file.

Open
#145 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

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?

  string file = "D:\\Test\\newdoc.xls";
  Workbook workbook = new Workbook();
  Worksheet worksheet = new Worksheet("First Sheet");
  worksheet.Cells[1, 1] = new Cell("Text string");
  workbook.Worksheets.Add(worksheet);
  workbook.Save(file);

What is the expected output? What do you see instead?

Excel complains there is unreadable content an gives an option to recover. 
However, once recovered, the content is there. 

Excel's error: 
  <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
- <recoveryLog 
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>error044240_01.xml</logFileName> 
  <summary>Errors were detected in file 'D:\Test\newdoc.xls'</summary> 
- <additionalInfo>
  <info>Excel recovered your formulas and cell values, but some data may have been lost.</info> 
  </additionalInfo>
  </recoveryLog>

What version of the product are you using? On what operating system?

Windows 7 32bit, Excel 2007


Original issue reported on code.google.com by cic.le...@gmail.com on 2 Apr 2013 at 3:22

Attachments:

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the provided reproduction using Workbook, Worksheet, Cell, and Workbook.Save to create D:\Test\newdoc.xls, then open it in Excel 2007 and inspect the recovery warning. Done means the generated workbook opens without Excel reporting unreadable content or needing recovery.

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
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.