links too long for xls sheet

amezziamezzi Junior Member
edited December 31, 1969 in Designing Analytics Reports
Hi,
I have a problem in a report that contains one column with links to sub-reports.
when I want to export to xls , I got a popup error message from Microsoft XL with the following message:

XML Spreadsheet Warning in Table
REASON: String too long

it seems that the string of the url of the link is too large for xl.
I had tried one solution but unfortunatley it dosen't work,it consists on hiding this colun in xls formt and showing it in html format and replacing it in xls by a new column containning the same data but without the links.

any inout or idea would be very helpfull.

Comments

  • VirgilVirgil Administrator EM admin
    edited December 31, 1969
    Hi amezzi,

    What version of BIRT are you using? I tried the same thing with BIRT 2.2 (hiding field with hyperlink for XLS, and hiding plain text field for rest of formats). All the formats worked correctly except for XLS which never showed the field at all.

    I tried this again with BIRT 2.2.1 and could see the correct field in XLS.

    Virgil

    Virgil Dodson
    OpenText Analytics Developer Community
    https://forums.opentext.com/forums/categories/analytics

Sign In or Register to comment.