Table box from EXCEL cells with several lines

[#1]

Hi there,

I have an EXCEL file with a comment column that varies from null to several lines.

When I import it into QV, it works fine but it displays by default only the first line.

I would like it to display all the content of my cell and not only a comment box when I hover it with my pointer...

I can modify the presentation tab by modifying the Multiple Settings but I would like QV to adapt automaticly depending on what I have in my cell.

I guess it's possible to do so but how ???

Regards

[Anonymous]

Do you mean you would want to show mutliple lines for those records (rows) that have mutli-line comment, but just the one rows where comments are short enough to fit on one line.

The Presntation properties' Multiline setting obviously applies across all rows the same way.

If you are purely interested in the presentation of these comments to the user you test their length when you read them in, and then chop them up into seperate records, effectively creating x number of records depending on the number of lines they would occupy.

Presentation within a table box could then set the colour of the other column to white where they aren't row 1 of the specific comment, to give the staggered effect you appear to want.

Jonathan

[#3]

Basically I would like to see in my table box exacly what I have in my excel cell...

If my comments are 2 lines in my excel sheet the should be in two lines in QV (but same row)

If I have a couple words in one line no problem

If I have more than 1 line, QV display by default only the first line in my row

If I change the multiline setting (Wrap Text / Cell height 5 lines) it applies as you say for every rows which doesn' make sense where I have only 1 line to display...

Also, if I have a bullet point list in my Excel cell I would like to see the same bullet point list in my QV table box...

[Anonymous]

I don't think that this sort of wrapping and expanding of rows dependent on content is supported.

Did my suggestion make sense ?

Jonathan

[#5]

I will have to find a workaround...