hi everyone, i am developing a report that can be printed in 2 different layouts, depending on if the user chooses the standard one, or the "excel friendly" one. this is what i've done so far:
i've higlighted in red the table for the excel layout. the other part of the report is the standard layout.
this have been done in order to have all the data striped on a single line.
I know i can use excel buffer to achieve the same result, hyperlink feature. Moreover, the excel buffer is deadly slow, compared to the save as excel.
the final result in excel is this
you can see that it needs some arrangement like:
1. Delete the first 2 blank rows
2. Remove the wrap text on the whole sheet
3. double click the columns in order to autosize them
this is a small step for a developer, but a big step for a low end user
I am asking if someone of you knows if there's a way to trick the wrap text and the white spaces...(the autosize will come automatically after removing the wrap).
Thanks in advance
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
Comments
I should have thought about it before #-o
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog