hodzung / excellibrary

Automatically exported from code.google.com/p/excellibrary
1 stars 0 forks source link

big string in cell create corrupted xls file #46

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.create a workbook which contains cells with more than 10 000 chars
2. save as compound document .xls

What is the expected output? What do you see instead?
when you try to open it with excel 2007 : corrupted file

What version of the product are you using? On what operating system?
windows.excel 2007

Please provide any additional information below.

Original issue reported on code.google.com by alexandr...@gmail.com on 3 Sep 2009 at 5:27

Attachments:

GoogleCodeExporter commented 9 years ago
i discovered this issue as well. no errors thrown, and excel 2010 was able to 
'partially recover' the file, which led to wildly confusing results with cells 
randomly empty and/or rearranged. Trimming my large strings (the one I noticed 
was just over 20K chars) to 1500 eliminated the problem.

Original comment by thadarkl...@gmail.com on 30 Sep 2014 at 4:46