Excel export warning

Posted by: tosch on 8 November 2018, 8:52 pm EST

    • Post Options:
    • Link

    Posted 8 November 2018, 8:52 pm EST

    What does this warning mean?

    ‘The source string of validation data cannot greater than 255’

    Thomas

  • Posted 11 November 2018, 6:31 pm EST

    Hello,

    Could you please share a small stripped out sample with us so that we can replicate the issue and debug the issue at our end and provide you with a fix for the same?

    Please confirm.

    Thanks,

    Reeva

  • Posted 11 November 2018, 9:50 pm EST

    Unfortunately I can’t.

    This is happening on one client machine only. It works with the same data on a different client machine.

    It’s not very urgent I just wanted to know what the error message means.

    Thomas

  • Posted 12 November 2018, 9:53 pm EST

    Hello,

    By design, when we export ComboBoxCellType to excel, Spread will export to DataValidation list with source as string which is separated by “,” character. The maximum length of list is 255 characters. So other text at the end of string will be truncated after export i.e. Spread don’t export combo box that have total item length larger than 255.

    However, we are not sure when are you getting the warning you mentioned above. Hence, could you please share that are you getting this warning while exporting to Excel from SpreadJS or while opening the exported Excel in MS Excel?

    And also please share the difference in machines wherein this warning is occurring and where it is not? What is the exact machine configuration and architecture of the machine and also which Office is installed on the machine, which version of Spread are you using? And even if possible please share the small code snippet with dummy data which replicates the issue for us.

    Please confirm so that we can investigate this issue further.

    Thanks,

    Reeva

  • Posted 12 November 2018, 11:48 pm EST

    Thanks for the explanation.

    I was able to replicate the problem on my side. We have a combobox in our sheet with suppliernames and when the length of all names is > 255 the error occurs.

    Thomas

  • Posted 13 November 2018, 5:51 pm EST

    Hello,

    Unfortunately, we are unable to replicate the issue at our end with the given information using Spread Winforms version v11.45.20183.0.

    We created a sample application using the 255 character item in combobox but we are unable to replicate the issue as we are not getting any warnings.

    We request you to send across your sample or modify our attached sample and send it back so that we can investigate the issue further.

    Thanks,

    Reeva

    combo-export-spreadwin.zip

  • Posted 13 November 2018, 11:12 pm EST

    Adding the flag ‘ExcelSaveFlags.UseOOXMLFormat’ seems to fix the problem.

    I have attached my modified sample app.

    Thomas

  • Posted 13 November 2018, 11:13 pm EST

    here’s the attachement, didn’t upload the first time.

    combo-export-spreadwin_modified.zip

  • Posted 14 November 2018, 2:53 pm EST

    Hello,

    We are glad to know that your issue has been resolved with ExcelSaveFlags being set to UseOOXMLFormat because for saving to xlsx format, we have to use this flag as it saves the spreadsheet to an Excel 2007 (OfficeOpen XML) format.

    Hope it clarifies.

    Thanks,

    Reeva

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels