Hi,
We have a Webi report in which we applied "Custom Sorting" to sort the Business Names in the required order. However, when we import that to excel using live office, excel doesnt retain the same format and there are not much options that are available within xcelsius to do the sorting. I have gone through various posts here but none resolved this specific issue.
Here is our environment:
Xcelsius 4.5
Live Office Frame work 11.5.5.525
BOXI R2 SP1 and MHF1
I tried using different options under "Report View formatting" within live office options but none seem to have made any difference. Unfortunately we can't make any changes to the universe in this case. I checked for few paid addon's but they seem to be for Xcelsius 2008. We have a release next week and would appreciate if any of you can guide me to solve this issue.
Thanks
Pavan