Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
4 subscribers
Views
1350 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi Everyone, We are using Export to Excel smart service in one of our
siddharthg521
over 10 years ago
Hi Everyone,
We are using Export to Excel smart service in one of our processes. In the excel template we have done certain formatting such as, making some columns bold and wrap text. Now, when this template is used in Export to Excel smart service, and when the data is written into it and the final generated excel is opened in Microsoft office, then the formatting gets RESET (or formatting done in template does NOT apply) of/to all the cells in which data are populated in cells from this smart service. However, for rest of the cells in which there is no data, formatting holds valid and applies to the same.
Also, this issue is coming up only when the generated excel is opened in MS Office. When the same is opened with Open office, everything works fine.
Any reasons why this is happening?
Thanks in advance......
OriginalPostID-79315
OriginalPostID-79315
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 10 years ago
By default, the code applies only the formatting style of the field to the cell via the code (i.e. Number or text). No styles are applied to the code. If you are seeing the correct formatting via openoffice and not via Excel, what I'd suggest is check at the backend XML data and see if any of the generated data has overwritten a tag that Excel things it cannot render in the format you need. I've seen this in the past between MSOffice and PDF where MS office is more lenient in some degree of bad XML in the code but the same gets thrown away when converted to PDF format. This is the first time I'm hearing about Excel and OpenOffice.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel