• State Suggested Answer
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 7 subscribers
  • Views 5453 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

how to word wrap for a particular cell in excel

Seenivasagan Perumalsamy

Hello,

I'm using excel plugin to download a report.

I'm having one column which holds around 500 characters.

Actually it is not wrapping inside the cell and it is not appearing in print also.

can you guide me as how to wrap text inside the cell.

Thanks,

Seenivasgan 

  Discussion posts and replies are publicly visible

Parents
  • 0
    What excel plugin are you using for this? Does it rely on excel template to populate data? If so, you can try applying wrapping format for that column inside the template and use this template in the plugin...
  • 0
    Certified Lead Developer
     in reply to GouthamKrishna
    Agreed with , Most Document creation smart services I have seen use a template, which you can use as your formatting template, setting Cells to Word Wrap, setting Heights and Widths, Fonts, etc.

    I've noticed odd behavior with templates before, however. Using the Export SQL to Excel Smart service of the Excel Tools shared component, forum.appian.com/.../summary , I have noticed that my word wrap would only work for columns A-Z, but AA and beyond would not keep my word wrap from the template in the final output document. However, things such as column width on AA did make it into my final document. I do not believe my Environment has the latest version of the Plugin, to be clear. Just wanted to share this anecdote, as formats of files tend to require extensive unit testing for these strange edge cases.
Reply
  • 0
    Certified Lead Developer
     in reply to GouthamKrishna
    Agreed with , Most Document creation smart services I have seen use a template, which you can use as your formatting template, setting Cells to Word Wrap, setting Heights and Widths, Fonts, etc.

    I've noticed odd behavior with templates before, however. Using the Export SQL to Excel Smart service of the Excel Tools shared component, forum.appian.com/.../summary , I have noticed that my word wrap would only work for columns A-Z, but AA and beyond would not keep my word wrap from the template in the final output document. However, things such as column width on AA did make it into my final document. I do not believe my Environment has the latest version of the Plugin, to be clear. Just wanted to share this anecdote, as formats of files tend to require extensive unit testing for these strange edge cases.
Children
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.