Can't Switch off Text Warp - problem in SSRS 2008
I have unique problem while creating report in SSRS. My tab loks like that:
cell1 | cell2 | rest_of_cells
name1 | name2 | data...
name3 | (empty cell) | data ...
In excel text in name3 fieeld will automaticly show over the empty cell without text warp. But when I generate excel from SSRS the warp text (in excel cell properties) is on by default - I don't know how to shitch it off in SSRS. Can any1 help?
January 17th, 2011 5:03am
ping
January 18th, 2011 6:00am
Hi,
Based on my and testing, the Warp Text option of cells in exported Excel is always enabled. I also checked the device information settings for rendering in Microsoft Excel format,
but there is no item for this option. So, I’m afraid currently we can only uncheck the wrap text option for each exported Excel.
Since word-wrapped behavior is by design and we are not allowed to change it. I would suggest you submit a wish at
https://connect.microsoft.com/SQLServer/. If the service requests frequency, we may include it in the next release.
We appreciate your understanding. If you have any question, please feel free to ask.
Thanks,
Tony ChainTony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 3:00am