Merged Cells in one row when exporting to excel

Stimulsoft Reports.NET discussion
IskandarAir
Posts: 105
Joined: Thu Aug 17, 2017 12:07 pm

Merged Cells in one row when exporting to excel

Post by IskandarAir »

Hi,

When we export as excel file. Empty cells in rows gets merged. Image attached.

How we can disable the merge of cells in the same row?

We are using Version 2017.1.6 from 3 of June 2017. WinForms

Regards,
Iskandar A
Lech Kulikowski
Posts: 6261
Joined: Tue Mar 20, 2018 5:34 am

Re: Merged Cells in one row when exporting to excel

Post by Lech Kulikowski »

Hello,

Please upload your image again.

Thank you.
IskandarAir
Posts: 105
Joined: Thu Aug 17, 2017 12:07 pm

Re: Merged Cells in one row when exporting to excel

Post by IskandarAir »

Hello,

Done. The reason why it is important some clients generates excel and adds filter on top

Regards,
Iskandar A
Attachments
mergecElls.PNG
mergecElls.PNG (7.85 KiB) Viewed 5143 times
Lech Kulikowski
Posts: 6261
Joined: Tue Mar 20, 2018 5:34 am

Re: Merged Cells in one row when exporting to excel

Post by Lech Kulikowski »

Hello,

We couldn't reproduce this bug.
Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.
IskandarAir
Posts: 105
Joined: Thu Aug 17, 2017 12:07 pm

Re: Merged Cells in one row when exporting to excel

Post by IskandarAir »

Hello,

Don't you know can it be specific to excel version or configuration?

Regards,
Iskandar A
IskandarAir
Posts: 105
Joined: Thu Aug 17, 2017 12:07 pm

Re: Merged Cells in one row when exporting to excel

Post by IskandarAir »

Merge Cells happen when evenRowStyle is added to report,in cells, there is string fields and it is empty (no data)

Please review the attachments, There is generated excel file, paremeters of evenRowNumber. (B,D,E cells are deleted due to sensitive data, there were all data on each cells)

Regards,
Iskandar A
Attachments
evenRowStyle.PNG
evenRowStyle.PNG (138.36 KiB) Viewed 5112 times
Exceptions Report 30.12.2018 14-10-36.xlsx
(17.67 KiB) Downloaded 233 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Merged Cells in one row when exporting to excel

Post by Alex K. »

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.
IskandarAir
Posts: 105
Joined: Thu Aug 17, 2017 12:07 pm

Re: Merged Cells in one row when exporting to excel

Post by IskandarAir »

I have attached my report Sample.

Please try to generate Excel file with it

Regards,
Iskandar A
Attachments
Report sample.mrt
(794 KiB) Downloaded 222 times
IskandarAir
Posts: 105
Joined: Thu Aug 17, 2017 12:07 pm

Re: Merged Cells in one row when exporting to excel

Post by IskandarAir »

We are using Version 2017.1.6 from 3 of June 2017. WinForms
Lech Kulikowski
Posts: 6261
Joined: Tue Mar 20, 2018 5:34 am

Re: Merged Cells in one row when exporting to excel

Post by Lech Kulikowski »

Hello,

Please check the following article:
https://www.stimulsoft.com/en/documenta ... export.htm

Thank you.
Post Reply