How can I return more than 255 characters from an Excel cell? 1

[zootjazz]

Hi

I have created a report that uses an Excel sheet as its datasource.

However, text from cells with more than 255 characters is being truncated in my Business Objects reports. I am saving the Excel sheet as V5/97 and selecting Excel 97 in the datasource editor.

Any help in how I can return all the text would be very gratefully received.

Thanks

Zoot

 

[nimmy99]

If you creata a n universe using EXCEL , you can set the text width to more than 255 under parameter-control option.

 

[skrandel]

I gotta be honest. I just tried this, and I can't reproduce it. I am using BO 5.1.6 and have have brought in cells that have over 1200 characters.

I'm using Windows XP on my desktop and Office 2000.

This might not be a BO issue at all. This might be a Microsoft DAO issue. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com