Merged Cells in one row when exporting to excel

[IskandarAir]

Hi,

Please consider that it is not about StiText that throws this error, Which is in article you mentioned - since in regualar row ( without Style for even row), this error is not seen.

What can be an issue for Styled-even row? What property of it creates this bug?

Thank you

[HighAley]

Hello, Iskandar.

Sorry, maybe we don't understand your issue.
Could you describe it more detailed with samples?
What is wrong with the Excel sheet that we get from Report sample.mrt file?

Thank you.

[IskandarAir]

Hi,

I have attached the .mrt file. please try to generate excel file with it. You will see that even-row-style has problem of merged cells (but not odd-row-style in which the article you mentioned is implemented and the problem there is not seen).
I have attached the generated excel file (with different data, though, the error can be seen).

Regards,
Iskandar A

[IskandarAir]

Hi,

Is there any updates regarding this term?

Regards,
Iskandar A

[Lech Kulikowski]

Hello,

usually, if a component has nothing (no color, no border, no text), it is not exported at all and you get a lot of empty cells in a row.

but if the band has a background color (specified in the even style), then it is exported as a container (under the components). Textboxes with text appear at the beginning of the line — there is one, and at the end, textboxes are empty — they are not exported, but under them there is a piece of band with a background, so it gives the merged cells.

in this case, there are options:
- set the style not for the band, but for each textbox
or
- for empty textboxes, specify at least one space, for example
{string.IsNullOrEmpty (Products.ProductName)? "": Products.ProductName}

Thank you.

[IskandarAir]

Dear Lech,

Thank you. i think we will prefer first option

Regards,
Iskandar

[Andrew]

Hello,

Okay, thank you for the reply. Let us know if you need additional clarification.