View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004812 | MMW v4 | Framework: Scripts/Extensions | public | 2008-08-19 14:25 | 2011-07-07 08:05 |
| Reporter | lowlander | Assigned To | |||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | assigned | Resolution | reopened | ||
| Product Version | 3.0 | ||||
| Summary | 0004812: Excel Track List Export song ammount limitation | ||||
| Description | When exporting a large quantity (>65534) of songs to Excel, the export script fails. I assume that this is due to the row limitation of Excel. The user reports an error in line 444 of the script while using Excel 2007, I got an error in line 442 while using Excel 2003 when trying to reproduce this error. User claims that Excel 2007 supports more rows than 65536 row limitation of Excel 2003 and older. I can't confirm that this is the case. | ||||
| Additional Information | Ticket: 1670 Forum: http://www.mediamonkey.com/forum/viewtopic.php?f=1&t=58514 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | |||||
|
|
Yes, this is really Excel limitation. Excel 2007 seems to support more rows, but maybe that COM interface we use for communication causes this problem. CSV export can be used to prevent this problem. |
|
|
Can a message be shown to the user when more tracks than the Excel limit have been chosen for export instead of having the script throw an error? |
|
|
Peke, please test whether this is a generic Excel limitation or whether it is no longer a problem for newer versions. |
|
|
There is still some sort of limitation as on my other PC that have office 2007 MM locks when exporting >65534 bot not always on track 65535 only thing is in common is that it needs to be more than >65534 in query. Additionally: for later Mm versions we should consider including OpenOffice in export. See more details here http://www.oooforum.org/forum/viewtopic.phtml?t=8878 |
|
|
Ok, please modify the Export script if needed. |
