Last Updated: 22 Nov 2019 09:30 by ADMIN
Created on: 13 Nov 2017 14:22
Category: SpreadProcessing
Type: Feature Request
SpreadProcessing: Exported csv should have extra comma-separated field in place of empty cells
When a csv is exported the entire range which has values is exported. When export is done in Excel, the cells of this range which are empty are marked by an additional field, separated by a comma. This comma is present in SpreadProcessing only in places where it is obligatory for example in the middle of the row. Obligatory comma in this context means that without it the file will not be read correctly by Excel or SpreadProcessing. In places where it is not obligatory, like in an empty row or in the end of the row, it is skipped. These non-obligatory commas do not influence how the file will be interpreted by Excel, however, according to the most-popular csv spec, they should be present, which means that there could be parsers which are unable to parse the resulting file. (2.4 Each line should contain the same number of fields throughout the file.) 

Exported by Excel:
Product,Unit Price,Units in Stock,Discontinued
Chai,$18.00 ,39,
Chef Anton's Cajun Seasoning,$22.00 ,53,No
Chef Anton's Gumbo Mix,$21.35 ,0,No
Exported by SpreadProcessing:
Product,Unit Price,Units in Stock,Discontinued
Chai,$18.00 ,39
Chef Anton's Cajun Seasoning,$22.00 ,53,No

Chef Anton's Gumbo Mix,$21.35 ,0,No
Note the extra commas in the empty row and in the end of the first two rows in the SpreadProcessing sample.
Posted on: 22 Nov 2019 09:30

Hello Paulo,

This issue is still not fixed. Unfortunately, the issue is not planned for the next release and this is why I cannot provide a timeframe for its resolving.  At this point, the best approach would be to follow the item. This way you will be notified when its status changes. 

Thank you for your understanding.

Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Posted on: 22 Nov 2019 06:13
Has the issue been fixed yet?
Posted on: 27 Nov 2017 14:47
Hi Aron, 

Thank you very much for the kind words! We appreciate your report, I am marking it as Approved and I will edit the description with more details.