Sunday, February 26, 2012

Export To Excel Funny Result post Sp1

Hi
I have a report with which looked fine on the web page, and rendered to pdf.
But when export to excel, the cells are not alligned on the same row as the
report should be. It goes up and down 1 row randomly. The whole report just
look like zig zag mesh. Any one experience this issue?
Another issue is objects such as lists and text box where visibility are
toggled with an expression exports randomly. Some visible item are not
exported.
My report is a buch of list and text boxes align into rows. but as i said
before, after export to excel, each cell in the row randomly goes up and down
one row like a zig zag.
Any tips are appreciated.Sounds like the item spacing is interpreted as overlapping by the
export engine.
I'm having tons of fun with this same behavior right now. Spent 6
hours on it yesterday and today with unsatisfactory results. Boss
says "the users will have to live with it." Export results to PDF and
Excel are not consistent with each other, nor with HTML view, nor with
devenv preview. You have to strive for a balanced compromise, and one
at least of the views will look funky if you try to butt each item up
against another.
Don't depend on the design surface for item location and size. Even a
grid size of .025in won't help. Use the numbers in the properties box
for best results. For HTML rendering at least, the smallest size
increment that has meaning (according to BOL) is 0.2mm = 0.0078740 in,
round to 0.008in for use.
See "Design Considerations for Rendering" in the Books Online,
especially "Designing for Microsoft Excel Output."
EtU
happy for correction by the more knowledgeable
>Hi
>I have a report with which looked fine on the web page, and rendered to pdf.
>But when export to excel, the cells are not alligned on the same row as the
>report should be. It goes up and down 1 row randomly. The whole report just
>look like zig zag mesh. Any one experience this issue?
>Another issue is objects such as lists and text box where visibility are
>toggled with an expression exports randomly. Some visible item are not
>exported.
>My report is a buch of list and text boxes align into rows. but as i said
>before, after export to excel, each cell in the row randomly goes up and down
>one row like a zig zag.
>Any tips are appreciated.

No comments:

Post a Comment