Export bug in version 2.2.0.28 / Advanced options / Export file group column

[Niels Henrik Sodemann]

When using version 2.2.0.28, I consistenly get's the error-message below (sorry, in danish) when exporting and using  Advanced options / Export file group column.

Any input?

Version: 2.2.0.28

Build: 09-06-2013 16:23

System.ArgumentException

-----------------

Værdien var enten for stor eller for lille til en Int32.<15016825057> kunne ikke gemmes i kolonnen Group. Den forventede type er Int32.

-----------------

ved System.Data.DataColumn.set_Item(Int32 record, Object value)

   ved System.Data.DataRow.set_Item(DataColumn column, Object value)

   ved System.Data.DataRow.set_Item(Int32 columnIndex, Object value)

   ved ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.doProcess(PreparedInformation preparedInformation, BackgroundWorker bw, Int32 fileGroupsLength, ICollection`1 savedFiles) i c:\P\ZetaResourceEditor\Source\RuntimeBusinessLogic\ExportImportExcel\Export\ExcelExportController.cs:linje 579

   ved ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.Process(BackgroundWorker bw) i c:\P\ZetaResourceEditor\Source\RuntimeBusinessLogic\ExportImportExcel\Export\ExcelExportController.cs:linje 307

   ved ZetaResourceEditor.UI.ExportImportExcel.ExcelExportWizardForm.progressBackgroundWorker_DoWork(Object sender, DoWorkEventArgs e) i c:\P\ZetaResourceEditor\Source\Main\UI\ExportImportExcel\ExcelExportWizardForm.cs:linje 758

   ved System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)

   ved System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

ArgumentException

{

Message="Værdien var enten for stor eller for lille til en Int32.<15016825057> kunne ikke gemmes i kolonnen Group. Den forventede type er Int32.",

ParamName=null,

Data=

[

]

,

InnerException=OverflowException

{

Message="Værdien var enten for stor eller for lille til en Int32.",

Data=

[

]

,

InnerException=null,

TargetSite=RuntimeMethodInfo: ToInt32,

StackTrace="   ved System.Convert.ToInt32(Int64 value)\\r\\n   ved System.Int64.System.IConvertible.ToInt32(IFormatProvider provider)\\r\\n   ved System.Data.Common.Int32Storage.Set(Int32 record, Object value)\\r\\n   ved System.Data.DataColumn.set_Item(Int32 record, Object value)",

HelpLink=null,

Source="mscorlib"

},

TargetSite=RuntimeMethodInfo: set_Item,

StackTrace="   ved System.Data.DataColumn.set_Item(Int32 record, Object value)\\r\\n   ved System.Data.DataRow.set_Item(DataColumn column, Object value)\\r\\n   ved System.Data.DataRow.set_Item(Int32 columnIndex, Object value)\\r\\n   ved ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.doProcess(PreparedInformation preparedInformation, BackgroundWorker bw, Int32 fileGroupsLength, ICollection`1 savedFiles) i c:\\P\\ZetaResourceEditor\\Source\\RuntimeBusinessLogic\\ExportImportExcel\\Export\\ExcelExportController.cs:linje 579\\r\\n   ved ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.Process(BackgroundWorker bw) i c:\\P\\ZetaResourceEditor\\Source\\RuntimeBusinessLogic\\ExportImportExcel\\Export\\ExcelExportController.cs:linje 307\\r\\n   ved ZetaResourceEditor.UI.ExportImportExcel.ExcelExportWizardForm.progressBackgroundWorker_DoWork(Object sender, DoWorkEventArgs e) i c:\\P\\ZetaResourceEditor\\Source\\Main\\UI\\ExportImportExcel\\ExcelExportWizardForm.cs:linje 758\\r\\n   ved System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)\\r\\n   ved System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)",

HelpLink=null,

Source="System.Data"

}

-->Værdien var enten for stor eller for lille til en Int32.System.OverflowException

-----------------

Værdien var enten for stor eller for lille til en Int32.

-----------------

ved System.Convert.ToInt32(Int64 value)

   ved System.Int64.System.IConvertible.ToInt32(IFormatProvider provider)

   ved System.Data.Common.Int32Storage.Set(Int32 record, Object value)

   ved System.Data.DataColumn.set_Item(Int32 record, Object value)

OverflowException

{

Message="Værdien var enten for stor eller for lille til en Int32.",

Data=

[

]

,

InnerException=null,

TargetSite=RuntimeMethodInfo: ToInt32,

StackTrace="   ved System.Convert.ToInt32(Int64 value)\\r\\n   ved System.Int64.System.IConvertible.ToInt32(IFormatProvider provider)\\r\\n   ved System.Data.Common.Int32Storage.Set(Int32 record, Object value)\\r\\n   ved System.Data.DataColumn.set_Item(Int32 record, Object value)",

HelpLink=null,

Source="mscorlib"

}

[Christian Pogea]

i've got the same issue.

is there a workaround available?

System.ArgumentException

-----------------

Der Wert für einen Int32 war zu groß oder zu klein.<4512055023> konnte nicht in der Gruppe-Spalte gespeichert werden. Erwarteter Typ: Int32.

-----------------

bei System.Data.DataColumn.set_Item(Int32 record, Object value)

   bei System.Data.DataRow.set_Item(DataColumn column, Object value)

   bei System.Data.DataRow.set_Item(Int32 columnIndex, Object value)

   bei ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.doProcess(PreparedInformation preparedInformation, BackgroundWorker bw, Int32 fileGroupsLength, ICollection`1 savedFiles) in c:\P\ZetaResourceEditor\Source\RuntimeBusinessLogic\ExportImportExcel\Export\ExcelExportController.cs:Zeile 579

[Anton Swart]

same error in english:

System.ArgumentException

-----------------

Value was either too large or too small for an Int32.Couldn't store <11138452293> in Group Column.  Expected type is Int32.

-----------------

at System.Data.DataColumn.set_Item(Int32 record, Object value)

   at System.Data.DataRow.set_Item(DataColumn column, Object value)

   at System.Data.DataRow.set_Item(Int32 columnIndex, Object value)

   at ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.doProcess(PreparedInformation preparedInformation, BackgroundWorker bw, Int32 fileGroupsLength, ICollection`1 savedFiles) in c:\P\ZetaResourceEditor\Source\RuntimeBusinessLogic\ExportImportExcel\Export\ExcelExportController.cs:line 579

   at ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.Process(BackgroundWorker bw) in c:\P\ZetaResourceEditor\Source\RuntimeBusinessLogic\ExportImportExcel\Export\ExcelExportController.cs:line 307

   at ZetaResourceEditor.UI.ExportImportExcel.ExcelExportWizardForm.progressBackgroundWorker_DoWork(Object sender, DoWorkEventArgs e) in c:\P\ZetaResourceEditor\Source\Main\UI\ExportImportExcel\ExcelExportWizardForm.cs:line 758

   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)

   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

ArgumentException

{

Message="Value was either too large or too small for an Int32.Couldn\\'t store <11138452293> in Group Column.  Expected type is Int32.",

ParamName=null,

Data=

[

]

,

InnerException=OverflowException

{

Message="Value was either too large or too small for an Int32.",

Data=

[

]

,

InnerException=null,

TargetSite=RuntimeMethodInfo: ToInt32,

StackTrace="   at System.Convert.ToInt32(Int64 value)\\r\\n   at System.Int64.System.IConvertible.ToInt32(IFormatProvider provider)\\r\\n   at System.Data.Common.Int32Storage.Set(Int32 record, Object value)\\r\\n   at System.Data.DataColumn.set_Item(Int32 record, Object value)",

HelpLink=null,

Source="mscorlib"

},

TargetSite=RuntimeMethodInfo: set_Item,

StackTrace="   at System.Data.DataColumn.set_Item(Int32 record, Object value)\\r\\n   at System.Data.DataRow.set_Item(DataColumn column, Object value)\\r\\n   at System.Data.DataRow.set_Item(Int32 columnIndex, Object value)\\r\\n   at ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.doProcess(PreparedInformation preparedInformation, BackgroundWorker bw, Int32 fileGroupsLength, ICollection`1 savedFiles) in c:\\P\\ZetaResourceEditor\\Source\\RuntimeBusinessLogic\\ExportImportExcel\\Export\\ExcelExportController.cs:line 579\\r\\n   at ZetaResourceEditor.RuntimeBusinessLogic.ExportImportExcel.Export.ExcelExportController.Process(BackgroundWorker bw) in c:\\P\\ZetaResourceEditor\\Source\\RuntimeBusinessLogic\\ExportImportExcel\\Export\\ExcelExportController.cs:line 307\\r\\n   at ZetaResourceEditor.UI.ExportImportExcel.ExcelExportWizardForm.progressBackgroundWorker_DoWork(Object sender, DoWorkEventArgs e) in c:\\P\\ZetaResourceEditor\\Source\\Main\\UI\\ExportImportExcel\\ExcelExportWizardForm.cs:line 758\\r\\n   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)\\r\\n   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)",

HelpLink=null,

Source="System.Data"

}

-->Value was either too large or too small for an Int32.System.OverflowException

-----------------

Value was either too large or too small for an Int32.

-----------------

at System.Convert.ToInt32(Int64 value)

   at System.Int64.System.IConvertible.ToInt32(IFormatProvider provider)

   at System.Data.Common.Int32Storage.Set(Int32 record, Object value)

   at System.Data.DataColumn.set_Item(Int32 record, Object value)

OverflowException

{

Message="Value was either too large or too small for an Int32.",

Data=

[

]

,

InnerException=null,

TargetSite=RuntimeMethodInfo: ToInt32,

StackTrace="   at System.Convert.ToInt32(Int64 value)\\r\\n   at System.Int64.System.IConvertible.ToInt32(IFormatProvider provider)\\r\\n   at System.Data.Common.Int32Storage.Set(Int32 record, Object value)\\r\\n   at System.Data.DataColumn.set_Item(Int32 record, Object value)",

HelpLink=null,

Source="mscorlib"

}

[BhaaLseN .]

Same here, same error, same version.
I wanted to export all resources to excel to do a mass-spell check on all resources around there; not just the selected key.
Got a different error aswell (duplicate names in data set), but that one doesn't belong here.

[Ken Kick]

You can find the fix here:

http://krickbaum.wordpress.com/

Zeta Resource Editor 2.2.0.28 Excel Export fix

[Christian Andersen]

I am experiencing the same problem in version 2.2.0.29. Has anybody found a solution for this? Unfortunately I do not have access to DevExpress to compile the project myself.