topic Re: hyperlink selection in a column in ODS and Base Reporting

hyperlink selection in a column

ccc143 — Tue, 21 Jun 2011 13:40:02 GMT

I have a table where the columns contain links:

ie.

WANTTHISTOAPPEAR.csv

And I added an autofilter so that there could be a drop down option. I want the drop down options to show 'WANTTHISTOAPPEAR' instead of the entire code of

'WANTTHISTOAPPEAR.csv'

to show. This is the code I added on for autofilter:

options(autofilter="yes"
autofilter_width="7em"
autofilter_table="1"
) style=styles.mystyle;

Is there something I need to do to get rid of the additional code from showing in the autofilter?

Thanks,
Connie

Re: hyperlink selection in a column

Eric_SAS — Tue, 21 Jun 2011 16:59:20 GMT

Excel generates the autofilter list from the actual values in the column which means it will spell them all out completely.

Re: hyperlink selection in a column

ccc143 — Tue, 21 Jun 2011 18:11:48 GMT

Oh, ok. Thanks!