Creating reports and dashboards | Stimulsoft community forum

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

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.

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

Hi,

Is there any updates regarding this term?

Regards,
Iskandar A

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.

Dear Lech,

Thank you. i think we will prefer first option

Regards,
Iskandar

Hello,

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