Paul Buxton
Top achievements
Rank 1
Rank 1
Paul Buxton
asked on 16 Oct 2008, 10:49 AM
Hi,
I have a report template where I've aligned everything precisely to avoid spacer columns and rows being generated as much as possible.
However, the 'business requirement' is that the spacer columns are excluded in their entireity!
For the sake of an example.....
I have two columns defined on the detail row. They are the same height, and width, and their Y offset is the same. There is 0.25in space defined between the columns. I don't want the 0.25in spacer in the exported sheet, but expect it on PDF.
I'd (hopefully!) expected that the engine would only render Spacer columns and rows if absolutely necessary - i.e. if edged weren't aligned properly - when exporting to Excel, but unfortunately it creates a spacer column in the sheet.
I'm assuming that this isn't something that I can circumvent?? Has anyone got any suggestions, other than using a different toolset to do the job?
I have a report template where I've aligned everything precisely to avoid spacer columns and rows being generated as much as possible.
However, the 'business requirement' is that the spacer columns are excluded in their entireity!
For the sake of an example.....
I have two columns defined on the detail row. They are the same height, and width, and their Y offset is the same. There is 0.25in space defined between the columns. I don't want the 0.25in spacer in the exported sheet, but expect it on PDF.
I'd (hopefully!) expected that the engine would only render Spacer columns and rows if absolutely necessary - i.e. if edged weren't aligned properly - when exporting to Excel, but unfortunately it creates a spacer column in the sheet.
I'm assuming that this isn't something that I can circumvent?? Has anyone got any suggestions, other than using a different toolset to do the job?