On April 27, 2024, our Sign-in and Create Account options will be unavailable from 9am-12pm ET. During this maintenance window, developer account access and free trial registration will be unavailable.

links too long for xls sheet

amezzi
amezzi Junior Member
edited 2020 23 in Designing Analytics Reports #1
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.
Tagged:
Flag · Like

Comments

  • Virgil
    Virgil Administrator EM admin
    edited 1969 31 #2
    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
    Flag · Like

Categories