What's the best way to modify the way dynamic cells are rendered ?
We often use Birt to generate some xlsx.
Quite often we need to be able to merge cells horizontally or vertically to met requirements.
Some good examples, would be to merge cells that have same values vertically ( drop property of grouping in table is broken) in table.
I know this works in crosstabs but usually the need happens in use case where we can't use crosstabs.
Another case, was to force a cell to have a colspan of 2 in a crosstab. We managed to do it, but I think we exploited a bug in this particular case.
For this kind of operations, what is the way to go (mostly developpers are working on reports) ?
Also as a side question, do you have any sources about birt best practices ?
Because we feel that even for things that looks basics, we spend a lot of time and end up scripting just to get "basic" behaviors working.