Issue 60 in linqtoexcel: Data not pulled from cell.
linqt...@googlecode.com
Owner: ----
Labels: Type-Defect Priority-Medium
New issue 60 by paqogo...@gmail.com: Data not pulled from cell.
http://code.google.com/p/linqtoexcel/issues/detail?id=60
What steps will reproduce the problem?
1. Run the attached project
2. Notice in the xlsx file (in the bin\Debug directory) the value in D12
has the value "TextPickLetters, ImageV, AudioChooseA"
3. Notice the console output. The value from D12 is not displayed.
What is the expected output? What do you see instead?
The expected output is for the 11th section object to have its media names
populated. Instead an empty string is passed into the method. This is
presumably because the column next to it or values above it are empty.
What version of the product are you using? On what operating system?
Latest version from NuGet. Should be in the project.
OS = Win 7
Please provide any additional information below.
please let me know if there is anything else you need, or if you are unable
to reproduce the problem. paqogomez at gmail dot com
Attachments:
linqtoexcel_bug_test.zip 5.6 MB
linqt...@googlecode.com
Comment #1 on issue 60 by paulyo...@gmail.com: Data not pulled from cell.
http://code.google.com/p/linqtoexcel/issues/detail?id=60
I downloaded the project, and I don't see the spreadsheet in the bin\Debug
directory.
I opened the solution and it didn't compile either.
Can you try creating another zip package and attaching it.
linqt...@googlecode.com
Comment #2 on issue 60 by crthomp...@gmail.com: Data not pulled from cell.
http://code.google.com/p/linqtoexcel/issues/detail?id=60
Ok, fixed the project and made sure the spreadsheet is in the correct
folder. Sorry for the mixup.
Attachments:
linqtoexcel_bug_test.zip 1.5 MB
linqt...@googlecode.com
Status: Fixed
Comment #3 on issue 60 by paulyo...@gmail.com: Data not pulled from cell.
http://code.google.com/p/linqtoexcel/issues/detail?id=60
This issue is caused by a limitation in Excel.
Excel determines the data type of a column by looking at the first 11 rows,
and since the first 11 rows are blank in your spreadsheet, Excel thinks all
the rows are blank.
I added some text in the first row, and it works fine. I attached the
spreadsheet I used to show it as well.
Attachments:
linqtoexcell_bug_test.xlsx 9.6 KB