cell limitations

  • Thread starter Thread starter jgale94043
  • Start date Start date
J

jgale94043

We use an Oracle database and Brio Query to create queries and report
but also use Brio to export data to excel. The problem is that exce
only allows 255 charactors and cuts off at that point. My thoughts ar
that if I can change the default format of the cells to wrap text, the
it will export the entire data field.
As an interim workaround I have exported from brio to a tab deliniate
text file and then opened it in excel and it works but I would like t
skip the text step.
I have already tried to create a new template but it doesn't seem t
work either.
Any advice would be appreciated, I have excel 2003 and brio exports t
excel 2.1 format.

Jac
 
...
...
As an interim workaround I have exported from brio to a tab deliniated
text file and then opened it in excel and it works but I would like to
skip the text step.
I have already tried to create a new template but it doesn't seem to
work either.
Any advice would be appreciated, I have excel 2003 and brio exports to
excel 2.1 format.
Click to expand...

The problem is with Brio, not Excel. Excel 97 (several versions older than Excel
2003) has no problem whatsoever importing CSV files with fields much longer 255
chars. As you state, Excel 2003 has no problems whatsoever with tab-delimited
files with fields longer than 255 chars. The problem is the Excel 2.1 format
XLS files that seems to be all that Brio supports. That .XLS format supports
only 255 chars per cell, so no amount of formatting or line wrapping will avoid
truncation.

Since XL2.1 .XLS files are single worksheet, and since it's highly unlikely Brio
is doing anything more than filling cells in these .XLS files with text and
number constants, what do you believe the advantages would be exporting in .XLS
format rather than tab-delimited text format? Excel can open both of them
directly, and once open I'd bet they'd be identical except perhaps for some
numeric formatting. Do you object to text files as the data conduit between Brio
and Excel because once you save the files from Excel in current format .XLS
files you then have unneeded text files you need to delete?
 
Back
Top