ImportData with ExcelNestedDataLayoutOptions.Merge skips some columns

[Paul Meems]

This is related to my previous question: https://www.syncfusion.com/forums/158738/save-tree-like-data-to-excel

I've made a simple sample application to reproduce it.

This is my result:

Several parts are not as expected:

1. Column I and J are wrong. The data in H, I and J should be 2 cells to the left.
2. Column B, D and E are DateTime values. After setting a style for the background and the borders the date values are changed to numbers.

I also have another question.

Is it possible to set different colors for the background making it easier to see which rows belong to each other?

In the screenshot I would like rows 2, 3 and 4 to have a darker background, row 5 a lighter one and rows 6 and 7 to be darker again.

Zebra style as it is called with HTML-tables and grids.

Please advice how to change my code to get this working properly.

Attachment: SyncfusionNestedDataLayout_68db0449.zip

[Shamini Kiruba Sobers]

Hi Paul, 

Greetings from Syncfusion support. 

Please find the response for your queries from the following table. 

Query	Response
Column I and J are wrong. The data in H, I and J should be 2 cells to the left.	We are able to reproduce the reported issue and validating it currently. We will share the validation details on October 22nd, 2020.
Column B, D and E are DateTime values. After setting a style for the background and the borders the date values are changed to numbers.	Kindly set the IncludeNumberFormat property to false as below, before setting the cell styles.  Code snippet:  defaultCellStyle.IncludeNumberFormat = false;  worksheet.UsedRange.CellStyle = defaultCellStyle;
Is it possible to set different colors for the background making it easier to see which rows belong to each other?  In the screenshot I would like rows 2, 3 and 4 to have a darker background, row 5 a lighter one and rows 6 and 7 to be darker again.	It is not possible to set different colors for each employee on importing the data. You have to manually set the styles based on the rows. The following UG link might help in achieving your requirement.  https://help.syncfusion.com/file-formats/xlsio/working-with-cell-or-range-formatting#set-default-style-for-row-or-column

Kindly let us know if the solutions help. 

Regards,
Shamini 

[Paul Meems]

Thanks for the help.

I can confirm defaultCellStyle.IncludeNumberFormat = false;  is solving my issue with the date formats.

Looking forward to seeing the shift of the columns fixed soon.

Regards,

Paul

[Shamini Kiruba Sobers]

Hi Paul, 

Thanks for the update. 

We will share the validation details for skipping of columns on October 22^nd, 2020 as promised earlier. 

Regards,
Shamini 

[Shamini Kiruba Sobers]

Hi Paul, 

 

We appreciate your patience. 

 

We have validated the issue Data is incorrect while importing nested object collection and logged a defect report. The fix for the issue will be available on November 5^th, 2020. You can track the status of the issue through the following link. 

 

Track status: https://www.syncfusion.com/feedback/19043/data-is-incorrect-while-importing-nested-object-collection 

 

Kindly confirm your working version of Syncfusion XlsIO so that we can provide patch in that version. 

 

Regards, 

Shamini 

[Paul Meems]

I'm using NuGet package Syncfusion.XlsIO.Net.Core v18.3.0.42.

I'm still in the development phase so I can easily update the package.

[Shamini Kiruba Sobers]

Hi Paul, 

Thanks for the update. 

As mentioned earlier, the fix for the reported issue will be available on November 5^th, 2020 and we do have weekly NuGet releases on every Tuesday. Hence, the fix will be included in the weekly NuGet package that rolls out after the mentioned date. 

We appreciate your patience. 

Regards, 

Shamini 

[Shamini Kiruba Sobers]

Hi Paul, 

We have fixed the reported issue and generated custom NuGet package of Syncfusion.XlsIO.Net.Core in the version v18.3.0.42. Kindly download the same from the following link and let us know if it resolves the issue. 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/Custom_Nuget1969244417.zip 

We will include the fix in the upcoming weekly NuGet release on November 10^th 2020 and let you know once the package is available for download. 

Regards, 

Shamini 

[Shamini Kiruba Sobers]

Hi Paul, 

Thanks for the patience. 

We are glad to announce that our latest weekly NuGet release v18.3.0.48 is rolled out and is available for download under the following link.   

https://www.nuget.org/packages/Syncfusion.XlsIO.Net.Core/ 

This package includes the fix to resolve the reported issue Data is incorrect while importing nested object collection. 

Regards, 

Shamini 

[Paul Meems]

I can confirm v18.3.0.48 is solving the issue.

With v18.3.0.40 my export looked like:

And with v18.3.0.48 it looks like:

Thanks for the fix.

This issue can be closed.

[Shamini Kiruba Sobers]

Hi Paul, 

Thanks for the update. We are glad that the fix resolved your issue. 

Regards, 

Shamini