<div>
Unfortunately that is a fundamental restiction in using i/e with spreadsheets. &nbsp; You can use Tabular text though and then bring it into your spreadsheet.
</div>


Unfortunately that is a fundamental restiction in using i/e with spreadsheets.   You can use Tabular text though and then bring it into your spreadsheet.

<div>
Try exporting in 123 format - and open this in Excel ??
</div>


Try exporting in 123 format - and open this in Excel ??

<div>
You could also try a package from granite software called zMerge... been a while since I've used it but it was a really good tool then.
</div>


You could also try a package from granite software called zMerge... been a while since I've used it but it was a really good tool then.

<div>
<div class="content wysiwyg-content">
I am trying to export a view from a notes database into an excel spreadsheet. However, the problem I am having is the text fields in excel are only importing and displaying the first 255 characters from the lotus notes field and then it gets truncated. How can I solve this? I need the whole text field to be displayed in the spreadhseet, regardless of length.<br />
Thanks.
</div>
</div>


I am trying to export a view from a notes database into an excel spreadsheet. However, the problem I am having is the text fields in excel are only importing and displaying the first 255 characters from the lotus notes field and then it gets truncated. How can I solve this? I need the whole text field to be displayed in the spreadhseet, regardless of length.
Thanks.

Exporting view/report to Excel

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.